dynamobi/dynamobi — Issue #719: [FRG-153] cast ('foo' as char) gives unhelpful error message
Author: dynamobi-build
Created: 2011-12-30 03:45:02+00:00
State: open
Labels: DDL, FRG

[reporter="johnk", created="Tue, 20 Jun 2006 19:59:49 -0500 (GMT-05:00)"]
0: jdbc:sqlstream://localhost> values cast ('foo' as char);

Error: java.lang.AssertionError: null (state=,code=0)

Null wasn't helpful to me.

This, OTOH, looks good:

0: jdbc:sqlstream://localhost> values cast ('foo' as char());

Error: org.eigenbase.sql.parser.SqlParseException: Encountered ")" at line 1, column 28.

Was expecting:

... (state=,code=0)

And it works if correctly specified:

0: jdbc:sqlstream://localhost> values cast ('foo' as char(10));

'EXPR$0'

'foo '

1 row selected (1.208 seconds)

0: jdbc:sqlstream://localhost>