At 11:15 PM +0000 6/19/1999, Sean McKenna wrote:
>On Sat, 19 Jun 1999 15:48:46 -0500, you wrote:
>
>>>I had not seen DISTINCTROW before, I always use DISTINCT.
>>>
>>>DISTINCTROW does not work for me, but DISTINCT does just fine.
>>
>>
>>DISTINCTROW seems to have been added between MySQL 3.21 and 3.22.
>
>That explains it since I am running 3.21. In the 3.22 documentation
>online I find DISTINCTROW listed in the reserved words (which is new
>to the documentation since 3.21) but there is no reference to it
>elsewhere. Does it do something different than DISTINCT or is it a
>synonym?
sql/ChangeLog contains this note:
Mon May 4 00:33:27 1998 Michael Widenius <monty@stripped>
* Added BOOL as a synonym for BIT and DISTINCTROW as a synonym for DISTINCT.
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
