Bug 42710 - SQL parser: WHERE clause "colname" or "NOT colname"
Summary: SQL parser: WHERE clause "colname" or "NOT colname"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Hardware: All All
: low enhancement
Assignee: Not Assigned
Depends on:
Blocks: Database-Queries
  Show dependency treegraph
Reported: 2011-11-08 07:59 UTC by Lionel Elie Mamane
Modified: 2018-02-07 23:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Lionel Elie Mamane 2011-11-08 07:59:54 UTC
The LO SQL parser does not accept:

 SELECT foo.bar
 FROM sch.foo
 WHERE foo.qux

because it expects some operator after "foo.qux". But this syntax (and also "WHERE NOT foo.qux") is accepted by at least PostgreSQL when foo.qux is a boolean column.

Investigate whether this syntax is standard SQL or PostgreSQL-specific (or maybe not standard, but widely supported) and whether it would be a good idea to support it in LO's SQL parser.
Comment 1 Alex Thurgood 2015-01-03 17:41:23 UTC Comment hidden (no-value)
Comment 2 Xisco Faulí 2018-02-07 23:40:27 UTC
Dear Lionel Elie Mamane,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.