Issue Details (XML | Word | Printable)

Key: CORE-6290
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Hex number used at end of statement (for exame with CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions

Created: 23/Apr/20 11:06 AM   Updated: 24/Apr/20 08:48 AM
Component/s: Engine
Affects Version/s: 4.0 Beta 1, 3.0.5
Fix Version/s: 4.0 Beta 2, 3.0.6

QA Status: Done successfully


 Description  « Hide
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
############


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.