From: Jorge del Conde Date: February 5 2002 5:24am Subject: RE: Bug report: Auto-sorting sorts INTs as CHARs List-Archive: http://lists.mysql.com/gui-tools/18 Message-Id: <000401c1ae05$55f0f9d0$0100a8c0@WINDOWS> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi! This is already fixed in the current snapshot. It will become available in the 0.8.3! Thanks for the bug-report. Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico <___/ www.mysql.com > -----Original Message----- > From: Adam Hooper [mailto:adamh@stripped] > Sent: Monday, February 04, 2002 10:08 PM > To: mycc@stripped > Subject: Bug report: Auto-sorting sorts INTs as CHARs > > > 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 > > > --------------------------------------------------------------------- > Before posting please check: > http://www.mysql.com/products/mycc/index.html > posting. To > request this thread, email mycc-thread14@stripped > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see > it, email mycc-unsubscribe@stripped instead. >