Created attachment 130193 [details] Open the database. 3 queries - all do not work because the functions aren't supported. While testing queries for Firebird I have reported bug105112. The behavior there is similar to the behavior of HSQLDB: There are functions you could chose in the GUI, which are unknown in the internal database. For HSQLDB these functions are COLLECT, FUSION and INTERSECTION. There has been a report (bug90686) closed as RESOLVED NOTABUG. A better solution would be only to show the functions, which will be available for the internal database. Users, who have the first contact with Base, will use the internal database and don't know much about functions. For those people the GUI is created. People, who will connect Base with an external database, will have more experience. The will know how to write down a special function in SQL directly and don't need the creation through GUI. Currently we have a GUI, that should make it easier for users, but confuses with special functions, which (could be I 'm not right) are special ORACLE-functions. 1. Solution: Put away COLLECT, FUSION and INTERSECTION 2. Solution: For internal database only show the functions, which will work with them, so a special GUI for HSQLDB and Firebird is needed.
I have set this to an ask for an enhancement, because it would make the GUI more usable but works at this moment as expected - with errors in the internal database.
Seems reasonable to me - we already do this for the LO dbf driver which has a limited function set compared to others in use in other products. This limited function set is also visible in the GUI.