|Issue 2519:||Adapt client grid sorting logic to server logic|
|1 person starred this issue and may be notified of changes.||Back to list|
What is the problem that needs to be solved (required)? //////////////////////////////////////////////// version :HeidiSQL Portable 184.108.40.20603 /*the code for test(note: the sort result from the code is right):*/ CREATE TABLE `table_A10` ( `B2` double(25,6) NOT NULL, PRIMARY KEY (`B2`), UNIQUE KEY `B2` (`B2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; insert into table_A10 values (0.1),(-1.1),(-0.1),(-1.2); select * from table_A10 order by B2; ///////////////////////////////////// then in the query windows click on tab "B2" ,the sort result is: -0.100000 -1.100000 -1.200000 0.100000 /////////////////////////// click on tab "B2" again ,the sort result is: 0.100000 -1.200000 -1.100000 -0.100000 //////////////////////////////
Aug 7, 2011
(No comment was entered for this change.)
Summary: Adapt client grid sorting logic to server logic
Dec 17, 2011
This issue was closed by revision r3987.
Dec 17, 2011
Problem was that only the first char was taken to detect if some value is a string or a number. The minus sign alone caused Heidi to think this is a string. Now it takes the first two chars to detect number or string, which then fixes this issue.
|► Sign in to add a comment|