Ask Your Question

Changes to SQL

asked 2019-02-10 12:35:36 +0100

johnwt gravatar image

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: but there has been no response. Is this likely to be a bug or has there been a change to the SQL being used?

edit retag flag offensive close merge delete



Have just tested with Debian 9.3 and LO:

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.

Ratslinger gravatar imageRatslinger ( 2019-02-10 17:18:19 +0100 )edit

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?

johnwt gravatar imagejohnwt ( 2019-02-12 19:22:21 +0100 )edit

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

Ratslinger gravatar imageRatslinger ( 2019-02-13 00:12:35 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-02-17 13:11:04 +0100

johnwt gravatar image

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.


edit flag offensive delete link more


Know nothing of those settings but that one & "EnableSQL92Check" appear in multiple, but not all, drivers installed. Not all are same settings.

Ratslinger gravatar imageRatslinger ( 2019-02-17 18:16:08 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-10 12:35:36 +0100

Seen: 45 times

Last updated: yesterday