List:GUI Tools« Previous MessageNext Message »
From:Adam Hooper Date:February 5 2002 4:07am
Subject:Bug report: Auto-sorting sorts INTs as CHARs
View as plain text  
CREATE TABLE temptable (tempval INT PRIMARY KEY);
INSERT INTO temptable VALUES (5), (9), (10), (30);

Then in MyCC run the query "SELECT * FROM temptable". In the results
pane, click on the "tempval" column to sort that column.

In ascending order the values are 10, 30, 5, 9.

I love the feature, though, and it works great for CHAR columns.



----------------------
Adam Hooper
Densigraphix Kopi Inc.
adamh@stripped

Thread
Bug report: Auto-sorting sorts INTs as CHARsAdam Hooper5 Feb
  • RE: Bug report: Auto-sorting sorts INTs as CHARsJorge del Conde5 Feb