https://bugs.documentfoundation.org/show_bug.cgi?id=126178
mc <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #17 from mc <[email protected]> --- (In reply to Robert Großkopf from comment #16) > (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? > > ... In this way, the sorting with GUI work fine for all DB Engine (HSQLDB, Firebird ...) SELECT "Table1"."Surname" "Surname1", "Table2"."Surname" "Surname2" FROM "Table1", "Table2" WHERE "Table1"."ID" = "Table2"."ID" -- You are receiving this mail because: You are the assignee for the bug.
