Bug 42710

Summary:	SQL parser: WHERE clause "colname" or "NOT colname"
Product:	LibreOffice	Reporter:	Lionel Elie Mamane <lionel>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	dr, iplaw67, xiscofauli
Priority:	low
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108443

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)

Adding self to CC if not already on

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.