https://bugs.documentfoundation.org/show_bug.cgi?id=104918
--- Comment #6 from [email protected] ---
(In reply to Tor Lillqvist from comment #5)
> Sorry, but could I have some more detailed reproduction instructions for
> what the initial comment describes please? What does "There couldn't be
> changed data in this query" mean? What should I try to change, and what is
> the expected error?
If you start this query with HSQLDB and don't switch to direct SQL in the
query-editor you could delete, update and insert data in the query:
SELECT "Table3".*, DATEDIFF(DAY, "StartDate", "EndDate") FROM "Table3"
You couldn't start this query with Firebird without switching to direct SQL,
because the GUI doesn't produce a right SQL-code of DATEDIFF(DAY, "StartDate",
"EndDate"). So you couldn't delete, update or insert data.
SELECT "Table3".* FROM "Table3"
will work without switching to direct SQL with Firebird. You could update,
insert or delete data.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs