Hello Paul, Monty,
On Date: 2/16/2003 at 14:22:50 -0600, Paul DuBois wrote:
<< cut >>
>>
>>Anyway, as Sergei said, the current (changed) behaviour is probably
>>what ANSI SQL means and is most like the way most other database is
>>handling DESC with NULL. Sorry again for the confusion....
>>
>Okay. Please don't change NULL sorting again for at least 10 years.
>:-)
>>
>>
>>Regards,
>>Monty
It's not urgent, but I think there should be a change to NULL
sorting.
As I've said in previous postings, the current draft
of SQL:2003 has what seems to be an error, touching
on this particular question. I am hopeful that things
will be clear by the time SQL:2003 comes out.
One reason for the proposed change -- whatever it
turns out to mean -- is that we might want interspersed
ROLLUP subtotals to appear just after the detail
columns.
Regards,
Peter
February 17/2003
--
For technical support contracts, visit https://order.mysql.com/?ref=mpgu
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Gulutzan <peterg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Software Architect
/_/ /_/\_, /___/\___\_\___/ Edmonton, Canada
<___/ www.mysql.com Office: +1 780 472-6838
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
