Since upgrading to 7.3 I've noticed that the ORDER BY clause seems to
ignore leading spaces/punctuation for eg we have a simple table with 6
rows containing:
'a'
'b'
'c'
'd'
' bill'
'-bill'
SELECT * FROM table ORDER BY 1;
gives:
a
b
bill
-bill
c
d
which is different from previous versions and different to MySQL and SQL
Server. Is this a bug, or can you turn this behaviour off? It's breaking a
lot of our applications!
--
Ollie Clark - [EMAIL PROTECTED] - [EMAIL PROTECTED]
http://www.ollieclark.com/acronyms.html
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
