RE: [Firebird-devel] INT64/BIGINT & Dialect 1

[Dmitry Y. <di...@us...>]

Martijn,

> > Yes, but NUMERIC(18,0) is actually DOUBLE PRECISION in dialect 1.
> > RDB$FIELD_TYPE shows the physical type of a field.
>
> I know... but a field can also be defined as DOUBLE PRECISION - how
> do you know the difference? Is SUB_TYPE used in IB 5.6?

I'm afraid, you cannot know the difference in dialect 1. Just tested with FB
1.0, ISQL and dialect 1 database:

isql
SQL> connect test.gdb;
SQL> create domain numeric_test numeric(18,0);
SQL> commit;
SQL> exit;

Then

isql test.gdb -x -o test.sql

Domain numeric_test is extracted as DOUBLE PRECISION. EMS QuickDesk also
shows that domain created as NUMERIC(18,0) is in fact DOUBLE PRECISION. How
did you handle it yourself in your tool?


Dmitry