bug in stored procedures with SQL Editor
Posted in 1999
Laurent LAFEUILLE — — source: Informix-list mailing list archive (1991-1998)
I just found this really stange bug in IUS V9 only with SQL Editor
create procedure test( str varchar(10) )
-- nothing, just an empty procedure for our exemple
end procedure;
execute procedure test('hello'); => ok
execute procedure test(' hello'); => ok
execute procedure test('hello '); => the space at the end of the varcharcause an SQL Synthax Error !!!
Even native informix stored procedures ( weblower, weburlencode ... ) using
a varchar,char,lvarchar,html parameter fail.
The same call with dbaccess or in an webPages works well, so the problem
seems to come from SQL Editor !?
Any idee ?