Server crash with SQL statement

[Ruslan Zasukhin]

on 11/11/03 9:09 PM, Tim Davis at timdavis at amug.org wrote:

> Hi,
> 
>   The following is an example which crashes the server reliably.
> 
> SELECT field1, field2 FROM table1 WHERE field1 like 'something' GROUP
> BY field1 ORDER BY field1
> 
> The problem seems to be the combination of group by and order by. (I
> realize in the above they will sequence on the same field.) When
> removing either, no crash.

Well, after GROUP BY you already have records sorted by field1.
Correct?

It needs to check why it crashes.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------