[FRG-246] Statement with binary string literal gives AssertionError

[dynamobi-build]

[reporter="jhyde", created="Thu, 21 Dec 2006 15:57:11 -0500 (GMT-05:00)"] Statement with binary string literal gives AssertionError. Example:

0: jdbc:farrago:> values (x'11');
Error: java.lang.AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(BINARY(1) NOT NULL EXPR$0) NOT NULL
converted type:
RecordType(VARBINARY(1) NOT NULL EXPR$0) NOT NULL
rel:
ProjectRel(EXPR$0=[$0])
  ProjectRel(EXPR$0=[11])
    OneRowRel (state=,code=0)

Stack trace:

at org.eigenbase.util.Util.newInternal(Util.java:803)
at org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:235)
at org.eigenbase.oj.stmt.OJPreparingStmt.prepareSql(OJPreparingStmt.java:257)
at net.sf.farrago.query.FarragoPreparingStmt.prepare(FarragoPreparingStmt.java:283)
at net.sf.farrago.db.FarragoDatabase$2.initializeEntry(FarragoDatabase.java:823)
at net.sf.farrago.util.FarragoObjectCache.pin(FarragoObjectCache.java:153)
at net.sf.farrago.db.FarragoDatabase.prepareStmtImpl(FarragoDatabase.java:835)
at net.sf.farrago.db.FarragoDatabase.prepareStmt(FarragoDatabase.java:705)
at net.sf.farrago.db.FarragoDbSession.prepareImpl(FarragoDbSession.java:939)
at net.sf.farrago.db.FarragoDbSession.prepare(FarragoDbSession.java:864)
at net.sf.farrago.db.FarragoDbStmtContext.prepare(FarragoDbStmtContext.java:105)
at net.sf.farrago.jdbc.engine.FarragoJdbcEngineStatement.execute(FarragoJdbcEngineStatement.java:107)
at sqlline.SqlLine$Commands.execute(Unknown Source)
at sqlline.SqlLine$Commands.sql(Unknown Source)
at sqlline.SqlLine.dispatch(Unknown Source)
at sqlline.SqlLine.begin(Unknown Source)
at sqlline.SqlLine.mainWithInputRedirection(Unknown Source)
at sqlline.SqlLine.main(Unknown Source)

[dynamobi-build]

[author="jhyde", created="Tue, 18 May 2010 02:47:24 -0500 (GMT-05:00)"] Works for me.