[jira] [Created] (TRAFODION-2944) LOB: Allow param specification in stringtolob() and filetolob() functions.

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

Sandhya Sundaresan created TRAFODION-2944:
---------------------------------------------

             Summary: LOB: Allow param specification in stringtolob() and filetolob() functions.
                 Key: TRAFODION-2944
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2944
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Sandhya Sundaresan
            Assignee: Sandhya Sundaresan


Today we have to explicitly cast the param for stringtolob. And param spec is not allowed for filetolob().

>>prepare s from insert into tblob values (stringtolob(cast(? as varchar(10)))); 

 --- SQL command prepared.

>> 

 

insert into tlobfile values (1, filetolob(cast(? as varchar(256))));
 ^ (46 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared. 

>>prepare s from update tblob set a = stringtolob(cast(? as varchar(10)), append);

--- SQL command prepared.

>> 

 

Fix both to allow syntax like this :

 

 

>>prepare s from insert into tlob values (1, stringtolob(?));

*** ERROR[4221] The operand of function LOBINSERT must be CHARACTER.

*** ERROR[8822] The statement was not prepared.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)