I am also having this problem.
Build ID: 1:6.4.6-0ubuntu0.20.04.1
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3;
Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB
I have an HSQLDB embedded database which contains a query with a sort.
I have a second query which uses the 1st query as a source.
This was working fine until last week - I had been using it regularly with no problems.
I have managed to duplicate this problem, reducing the queries to the absolute minimum to replicate the problem.
(My actual queries are much more complicated but I have reproduced the problem with the following)
Query 1 = SELECT “Name” FROM “Customers” ORDER BY “Name” ASC
Query 2 = SELECT “Name” FROM “Query1”
Query 1 works fine (as you would expect).
Query 2 fails:-
The data content could not be loaded.
Cannot be in ORDER BY clause in statement[SELECT"Name" FROM (SELECT “Name” FROM “Customers” ORDER BY “Name” ASC) AS “Query1”]
Removing the "ORDER BY “Name” ASC from Query 1 removes the error
I should point out again that this worked perfectly until last week (I don’t know what changed, some update probably). I also don’t know what versions I was using before the change but I was using Ubuntu 20.04.
I also noticed that it is only possible to create a new database as HSQLDB embedded. There used to be the option of selecting either HQSLDB or Firebird but the Firebird option is no longer a choice.
I have also noticed that BASE seems to crash a lot, an awful lot and has to be recovered, but I guess that is a separate issue.