https://bz.apache.org/ooo/show_bug.cgi?id=121492
--- Comment #26 from Andreas Säger <[email protected]> --- Some "parsed SQL" expression works in your test cases but fails when the backend is PostgreSQL? This would be bad indeed. Originally, the "parsed SQL mode" was designed to work regardless of the database backend whereas "direct SQL mode" passed the literal SQL statement to the underlying database driver. In parsed mode any of the following tokens used to be a literal date: '2015-07-31' (quoted ISO string) {D'2015-07-31'} #07/31/2015# (with US locale) #31/07/2015# (with other locales) or any other expression between hashes according to the current locale including dates with 2-digit year. Missing hashes in the GUI were complemented in the query designer, filter dialog, form based filter and parameter query input box. Likewise any missing single quotes are complemented when you type a literal string argument. -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.
