Re: BugID: 1167704 (Error in Order By)
Is this bug a "known" architectural limitation of HSQLDB?
If not, can somebody point out where to look in the source-code for information about ordering-logic?
It works correctly with the current version:
create table Test(ID Integer, Cost Float);
insert into test values(1,10);
insert into test values(2,20);
insert into test values (3,1);
SELECT ID, ' kr' + Cost FROM Test ORDER BY Cost;
Try adding "insert into test values (4,2);" at the bottom, and
you will see the error (String comperator).
(Tried on ver: 22.214.171.124, 2.0 rc7 and rc9)
Thanks, this has now been fixed in CVS.
Wow, that was fast.
Does that mean it will start sorting like this:
instead of this:
with string variables?
Well, its the other way around. When ordering by Cost i should sort like your first entry, but sorts like the second (String-sorting instead of double-sorting).
This error is now reported fixed, in CVS, by fredt!
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.