CREATE DOMAIN can not use DEFAULT clause with HEX literal if another domain has
been created before this statement
------------------------------------------------------------------------------------------------------------------
Key: CORE-6290
URL: http://tracker.firebirdsql.org/browse/CORE-6290
Project: Firebird Core
Issue Type: Bug
Components: Engine
Reporter: 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
############
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
