Subject Re: [firebird-support] Selection/group order causes an error
Author Helen Borrie
At 09:07 PM 1/11/2007, you wrote:
>Woody wrote:
>> If you want to see something really scary, try this one:
>>
>> select cast(coalesce(rdb$security_class, '') as varchar(80)), '1'
>> from rdb$database
>> group by 2, 1
>>
>> WARNING: So far, this locks up IBOConsole (and my PC) every time I try it.
>
>No problems in FlameRobin.

In IB_SQL it just keeps fetching ad infinitum (tho' fortunately IB_SQL lets you stop a cursor from fetching).

./heLen