I use a method in a database involving copying a query into a new table. I have done this many times in the past without any problem. Since around last October this is now throwing up errors. I have reported this as a bug to Debian, the details are here:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=911859
but there has been no response.
Is this likely to be a bug or has there been a change to the SQL being used?
Hello,
Have just tested with Debian 9.3 and LO:
Version: 6.2.0.3
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 4; OS: Linux 3.16; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Cannot re-create problem. Tried with HSQLDB embedded & split. Used a variety of SQL combinations without a problem. You may want to look at anything containing spaces and/or special characters.
Yes, as I wrote in the Debian bug, it seems now to object to spaces and hyphens in identifiers, but it did not do so before. It also now comes up with a “parameter index out of range” error which it also did not before. Has the SQL for HSQLDB been changed?
There are issues with this type of situation in regard to the Firebird SDBC driver. I know of nothing to do with HSQLDB.
May be best to file a Bug report → Bugzilla
I found that the setting:
“Use SQL-92 naming constraints”
in Edit > Database > Advanced settings" was set. I unset it and the problem seems to be resolved.
Is this a new setting that defaults to being set? Or a setting that has been changed to default to set?
I suppose I could have inadvertently set it, but I don’t know how as these are not settings that I am aware of ever having changed.
John
Know nothing of those settings but that one & “EnableSQL92Check” appear in multiple, but not all, drivers installed. Not all are same settings.