Bug 42710

Summary: SQL parser: WHERE clause "colname" or "NOT colname"
Product: LibreOffice Reporter: Lionel Elie Mamane <lionel>
Component: DatabaseAssignee: Lionel Elie Mamane <lionel>
Status: ASSIGNED --- QA Contact:
Severity: enhancement    
Priority: low CC: dr, iplaw67
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:

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 
Adding self to CC if not already on

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.