|Subject||Re: [firebird-support] Selection/group order causes an error|
> At 09:07 PM 1/11/2007, you wrote:it.
> >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
> >lets you stop a cursor from fetching).
> >No problems in FlameRobin.
> In IB_SQL it just keeps fetching ad infinitum (tho' fortunately IB_SQL
Works fine in Database Workbench that uses IBO.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!