#284 Extend Oracle syntax support for Binary Literals

closed
engine (144)
1
2012-11-30
2012-11-15
Anonymous
No

Extend Oracle syntax support (sql.syntax_ora=true) for Binary Literals

HSQLDB Syntax
INSERT INTO FOO_TABLE (A_BLOB_COLUMN) VALUES (X'1abACD34')

Oracle Syntax
INSERT INTO FOO_TABLE (A_BLOB_COLUMN) VALUES ('1abACD34')

Currently using Oracle Syntax with sql.syntax_ora=true yields:
org.hsqldb.HsqlException: incompatible data type in conversion
at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]
at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]
at org.hsqldb.types.BlobType.convertToType(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]
at org.hsqldb.StatementDML.getInsertData(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]
at org.hsqldb.StatementInsert.getResult(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]
at org.hsqldb.StatementDMQL.execute(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]
at org.hsqldb.Session.executeCompiledStatement(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]
at org.hsqldb.Session.executeDirectStatement(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]
at org.hsqldb.Session.execute(Unknown Source) ~[hsqldb-2.2.9.jar:2.2.9]

Discussion

  • Fred Toussi

    Fred Toussi - 2012-11-30

    Feature implemented for the next release.

     
  • Fred Toussi

    Fred Toussi - 2012-11-30
    • labels: --> engine
    • priority: 5 --> 1
    • assigned_to: nobody --> fredt
    • status: open --> closed
     

Log in to post a comment.