You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hex number used at end of statement (for exame with CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions [CORE6290]
#6532
summary: CREATE DOMAIN can not use DEFAULT clause with HEX literal if another domain has been created before this statement => Hex number used at end of statement (for exame with CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions
Submitted by: @pavel-zotov
Run this script:
set echo on;
shell del c:\temp\tmp4test.fdb 2>nul;
create database 'localhost:c:\temp\tmp4test.fdb' user sysdba password 'masterkey';
create domain dm_test_a as double precision default 99999999;
create domain dm_test_b as bigint default 0xf0000000;
----------------------------------------------------------------
create domain dm_test_c as double precision default 100000000;
create domain dm_test_d as bigint default 0xf0000000;
----------------------------------------------------------------
create domain dm_test_e as int default 1;
create domain dm_test_f as bigint default 0xf0000000;
commit;
show domain;
Output in WI-V3.0.6.33288 and WI-T4.0.0.1926 is the same (except show domain elements position):
############
create domain dm_test_a as double precision default 99999999;
create domain dm_test_b as bigint default 0xf0000000;
----------------------------------------------------------------
create domain dm_test_c as double precision default 100000000;
create domain dm_test_d as bigint default 0xf0000000;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 44
-xf0000000
At line 12 in file dd.sql
----------------------------------------------------------------
create domain dm_test_e as int default 1;
create domain dm_test_f as bigint default 0xf0000000;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 44
-xf0000000
At line 18 in file dd.sql
commit;
show domain;
DM_TEST_A DM_TEST_B
DM_TEST_C DM_TEST_E
############
Commits: c2f132a df23e50
The text was updated successfully, but these errors were encountered: