https://bugs.documentfoundation.org/show_bug.cgi?id=103519
--- Comment #2 from Tony <[email protected]> ---
Created attachment 128295
--> https://bugs.documentfoundation.org/attachment.cgi?id=128295&action=edit
Sample DB
When I created this sample DB to demonstrate the effect, using non personal
data, column and variable names, I realized, that I was not able to reproduce
the error any more. I did some testing and stumbled across a strange behaviour.
The variable names have an effect on the result. If you replace for example the
variable "R" with a "T" I get a SQL syntax error. Looks like "T" is somehow a
reserved identifier.
Unfortunately I lost the original query, which only differs in the identifiers
and was tested on a productive database. Hence I can't reproduce the error at
the moment, but I will continue to search for it. At the moment I believe it
depends on identifier names or on a particular status of the SQL engine. I make
the latter assumption, because I had to "Run Query" twice after each change as
the first run always produced a runtime error.
Thanks
--
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
