OR not recognized in SELECT clause via Postgres
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Akiban SQL Parser |
Fix Released
|
High
|
Mike McMahon |
Bug Description
Using the Postgres server to perform a SELECT that using the OR operator
in the select expression fails.
SQL:
CREATE TABLE t (bigint_field bigint)
SELECT bigint_field > 1 OR bigint_field < -1 FROM t
Result:
org.postgresq
Was expecting one of:
"and" ...
"from" ...
"is" ...
"*" ...
"+" ...
"," ...
"-" ...
"/" ...
"||" ...
: SELECT bigint_field > 1 OR bigint_field < -1 FROM t
at org.postgresql.
at org.postgresql.
at org.postgresql.
at org.postgresql.
at org.postgresql.
at org.postgresql.
at com.akiban.
To reproduce:
mvn test -Dtest=
Reproduced in trunk revision 1244
affects: | akiban-server → akiban-sql-parser |
Changed in akiban-sql-parser: | |
status: | New → Triaged |
assignee: | nobody → Mike McMahon (mmcm) |
milestone: | none → samba |
Changed in akiban-sql-parser: | |
status: | Triaged → Fix Released |
information type: | Private → Public |
The Derby parser implements a 90's vintage grammar that distinguishes conditions and expressions and does not have boolean as a full fledged type.