[Libreoffice-bugs] [Bug 104918] LibreOffice SQL parser chokes on Firebird's DATEDIFF syntax, making use impossible in normal (non-direct SQL) queries

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=104918

--- Comment #16 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to robert from comment #0)
> Created attachment 129934 [details]
> Open the query "Datediff". Changing of data impossible. Works only with
> direct SQL.
> 
> Open the attached Firebird-database.
> Start the query "Datediff".
> It shows a datediff between two dates. There couldn't be changed data in
> this query, because datediff runs only with direct SQL.
> 
> With internal HSQLDB datediff runs in the GUI. You could change data, add
> new rows ...
> 

Using Libo6.1Alpha0 latest build (fc5d185bdb0f27bc6014d47338740f741ac05d21)

Downloaded the original bug report attachment (ODB from 2016-12-25) This
(datediff in querys) is working now as expected and the result set is editable
in the GUI.

So, close this as working?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180419/4381db7a/attachment-0001.html>