I created https://github.com/FirebirdSQL/firebird/pull/85 for this.
On 4-3-2017 14:35, Mark Rotteveel (JIRA) wrote: > Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown > ------------------------------------------------------------------------- > > Key: CORE-5494 > URL: http://tracker.firebirdsql.org/browse/CORE-5494 > Project: Firebird Core > Issue Type: Bug > Components: Engine > Affects Versions: 4.0 Initial > Environment: Firebird-4.0.0.546-0_x64 on Windows 10 > Reporter: Mark Rotteveel > > > 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 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 CORE-5064: > > create table x ( > binary1 binary > ) > -- Mark Rotteveel ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
