flamerobin icon indicating copy to clipboard operation
flamerobin copied to clipboard

Add support for Fb4 datatypes

Open arvanus opened this issue 4 years ago • 1 comments

New datatypes:

  • INT128
  • DECFLOAT(16)
  • DECFLOAT(34)
  • DECFLOAT
  • TIME [ { WITHOUT | WITH } TIME ZONE ]
  • TIMESTAMP [ { WITHOUT | WITH } TIME ZONE ]

arvanus avatar Feb 05 '21 14:02 arvanus

@andy-123 could you please take a look at Fb4 data types? I've found a bug and would like to ask you to give a look please

Steps:


CREATE TABLE TABLE_NAME (
    COLUMN_NAME  DECIMAL(18,6) NOT NULL,
    DEC_F2       NUMERIC(38,6)
);
ALTER TABLE TABLE_NAME ADD CONSTRAINT CONSTRAINT_NAME_PK PRIMARY KEY (COLUMN_NAME);
INSERT INTO TABLE_NAME (COLUMN_NAME, DEC_F2) VALUES (1, '123123124123412577766.441231');
select * from table_name;
--Edit manually dec_f2 to value 123123124123412577766.44123
--See that the value changed to 123123124123412577767.444123

Thanks

arvanus avatar Aug 28 '22 19:08 arvanus

See fix in PR #306

(Sorry for long time beeing inactive.)

andy-123 avatar Apr 10 '23 19:04 andy-123

looks like it's working now, thanks for your effort! I'm not using any of the new data types now, so lets wait for others reviewing it too I'll close the issue for now

arvanus avatar May 10 '23 13:05 arvanus