dynamobi/dynamobi — Issue #796: [FRG-74] Character Constants Should be CHAR not VARCHAR
Author: dynamobi-build
Created: 2011-12-30 03:49:24+00:00
State: open
Labels: FRG, SQL Validator

[reporter="edan", created="Fri, 17 Mar 2006 14:46:14 -0500 (GMT-05:00)"]
Issue #1 Character constants are coming out VARCHAR.

CREATE VIEW v AS VALUES ('foo');

The column should have type CHAR(3) NOT NULL.

Issue #2 Compound literals should have the same type, e.g.

CREATE VIEW v2 AS VALUES ('foo'

'bar');

The column should have type CHAR(6) NOT NULL.

Issue #3. The standard prohibits columns from having zero length. So, the views

CREATE VIEW v0 AS VALUES ('');

CREATE VIEW v00 AS VALUES (''

'');

should both have columns of type CHAR(1) NOT NULL.

------- Comment #1 From Julian Hyde 2005-10-08 18:02 [reply] -------

When fixing this bug, please fix SqlOperatorTests.testLiteralChain.