[FB-Tracker] Created: (CORE-5494) Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[FB-Tracker] Created: (CORE-5494) Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown

JIRA tracker@firebirdsql.org
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
)

--
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

       

------------------------------------------------------------------------------
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [FB-Tracker] Created: (CORE-5494) Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown

Mark Rotteveel-2
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
Loading...