Split DataBase HSQLBD 2.6.1 in LO 7 series Query editing issues

Hello All,

On page 46 of BG64-BaseGuide.pdf and clearly repeated on page 207 of BG72-BaseGuide.pdf, there is a notation method of field names between double quotes, like “sportage” and “Loan”.
The User can assume that this is a valid method to be used for writing queries over time and can still be used ‘today’ (as of the date of discribing this issue).

Now it is obvious that the manuals are specific for the internal version of HSQLDB (1.8), but up to LO 6.4 this way of writing code was also available to the User in SQL View, even when using the split database setup for HSQLDB 2.6.1.

After LO 6.4 something changed as such that 2 things are not available anymore to the User in SQL View:

  1. Using the double quote notation
  2. Using a ‘Tab’ as an indent

Now, for writing and editing a Query, wanting to use both the double quote method and the ‘Tab’, the User is “forced” to write and edit outside the SQL View.

My Questions are:
a. “Why has it changed”?
b. “Can something be done about it”?

Dream

UPDATE: It turns out that also with HSQL 1.8 (the embedded version) the ‘double quotes’ and the ‘Tab’ are both not available either.

Hello,

Do not see any problem with quote marks. Has been OK for a very long time:

Possibly a profile problem. Try safe mode.

As for the Tab, have not tried that until this version and there is no response. If you say this has worked before, file a bug report here → Bugzilla

Using:

Version: 7.3.0.3 / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Tried Safe Mode and resetting complete profile. Nothing changes.
Going back to LO 6.4.7.2 (last one in the LO 6 series) does allow both options.
Will report a bug.

Thanks,

Dream