Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown [CORE5494] #5763
Comments
Modified by: @mrotteveel |
Modified by: @mrotteveeldescription: Executing the following create table create table x ( Leads to an exception: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 213; BINARY [SQLState:42000, ISC error code:335544634] This works in Firebird 3 and earlier. Workaround is to leave of `sub_type binary` or use `sub_type 0` instead. Note that the following works, so it looks like this is introduced by the implementation of CORE5064: create table x ( => Executing the following create table create table x ( Leads to an exception: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 213; BINARY [SQLState:42000, ISC error code:335544634] This works in Firebird 3 and earlier. Workaround is to leave off `sub_type binary` or use `sub_type 0` instead. Note that the following works, so it looks like this is introduced by the implementation of CORE5064: create table x ( |
|
Commented by: @aafemt May be we really should make "binary" non-reserved word and ignore parser conflicts... |
|
Commented by: @mrotteveel Small note: the line and column index is off, because I copied the exception message from a larger create table statement. |
|
Commented by: @mrotteveel PR: #85 |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Alpha 1 [ 10731 ] assignee: Mark Rotteveel [ avalanche1979 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @mrotteveel
Is related to CORE5064
Executing the following create table
create table x (
blob1 blob sub_type binary
)
Leads to an exception: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 213; BINARY [SQLState:42000, ISC error code:335544634]
This works in Firebird 3 and earlier.
Workaround is to leave off `sub_type binary` or use `sub_type 0` instead.
Note that the following works, so it looks like this is introduced by the implementation of CORE5064:
create table x (
binary1 binary
)
Commits: cad0840 63eb729
The text was updated successfully, but these errors were encountered: