https://bugs.documentfoundation.org/show_bug.cgi?id=126178
--- Comment #16 from Robert Großkopf <[email protected]> --- (In reply to mc from comment #15) > @robert > Also HSQLDB does not work if you try to sort from the Sort buttons in the > toolbar, in fact, the sort only works on the first column. And this is the behavior user expect since Base exists together with internal HSQLDB: Queries could be mixed as you want. If there are duplicate names in the fields the first field will be taken as the field for sorting. This isn't a special behavior of HSQLDB. It is a behavior of the GUI. This has nothing to do with writing a statement correctly. It is something I could create by the GUI offered for creating queries and users expect the GUI will work, special with internal databases. By the way: How would you define "correctly"? As the GUI creates a statement? I would prefer to end this discussion and offer a solution Firebird will work as expected with GUI. We try this since nearly 8 years and had decided some times ago to set Firebird as experimental, because there are too much elements which doesn't work as expected. One thing is sorting: When creating a database in Firebird I only sort after changing columns to UPPER cased, because the kind of sorting Firebird uses at default is a nightmare. You could do this better by setting the collation, but I got external Firebird databases with setting collation, which couldn't be used by peoples with other systems. -- You are receiving this mail because: You are the assignee for the bug.
