mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
216 stars 66 forks source link

Add support for Fb4 datatypes #166

Closed arvanus closed 1 year ago

arvanus commented 3 years ago

New datatypes:

arvanus commented 2 years ago

@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

andy-123 commented 1 year ago

See fix in PR #306

(Sorry for long time beeing inactive.)

arvanus commented 1 year ago

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