[Solved] Issues with HSQL 6.0 and 6.1 under LO 7 series.

Discuss the database features
Post Reply
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

[Solved] Issues with HSQL 6.0 and 6.1 under LO 7 series.

Post by dreamquartz »

Hi All,

Just wondering if anyone has the same "issues" I encounter with my Split Databases since the LO 7 series were introduced.
With this introduction, when using HSQLDB 6.0 and now 6.1 on Ubuntu 20.04, I lost the ability to:
1. add double quotes ("); our databases use double quotes ("), for e.g. "tCity"."CityID".
2. add single quote (') in e.g. 'MM/DD/YYYY' in a TO_CHAR( "tProjectDateTime"."ProjectDateChanged", 'MM/DD/YYYY' )
3. add a 'Tab' for indenting a line.

I have to copy the Query into a text editor to modify and paste it back into LO Base.

Reverted back to LO 6.4.7.2, as the last version without these problems.

Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

Re: [SOLVED] Issues with HSQL 6.0 and 6.1 under LO 7 series.

Post by dreamquartz »

Update:
Latest version (LO 7.3.3.2) shows all issues solved.
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Post Reply