Re: [Firebird-devel] Execute statement, engine crash test-case

[Alessandro P. <pet...@in...>]

"Alex Peshkov" <pe...@in...> ha scritto nel messaggio 
news:414...@in......

Hi Alex,

>>I know the following SP have no-sense, but instead of rejecting the query 
>>it crashes the engine.
>>I'm using Fb 1.5.1 Classic under Windows XP SP 2.
>>
>>CREATE PROCEDURE CRASH_ENGINE (
>>    TABLE_NAME VARCHAR(100))
>>RETURNS (
>>    MYCOUNT INTEGER)
>>AS
>>BEGIN
>>  EXECUTE STATEMENT 'select count  from ' || :TABLE_NAME INTO :MYCOUNT;
>>END

sorry but something's gone wrong with copy&paste, should be:

EXECUTE STATEMENT 'select count(*)  from ' || :TABLE_NAME INTO :MYCOUNT;

Ciao,
Alessandro Petrelli.