He Zhenxing created TRAFODION-3287:
--------------------------------------
Summary: LOB functions stringtolob/filetolob not work with
parameter in prepare statement
Key: TRAFODION-3287
URL: https://issues.apache.org/jira/browse/TRAFODION-3287
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Affects Versions: any
Reporter: He Zhenxing
Fix For: 2.4
Using LOB functions stringtolob/filetolob with parameters in prepare statement
will result in error:
{code:java}
>> create table (a int, b blob);
>> prepare s1 from insert into t1 values (1, stringtolob(?));
*** ERROR[4221] The operand of function LOBINSERT must be CHARACTER.
*** ERROR[8822] The statement was not prepared.
>> prepare s1 from update t1 set b = filetolob(?) where a = 1;
*** ERROR[15001] A syntax error occurred at or before:
update t1 set b = filetolob(?) where a = 1;
^ (29 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
