Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-3287

LOB functions stringtolob/filetolob not work with parameter in prepare statement

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • any
    • 2.4
    • sql-exe
    • None

    Description

      Using LOB functions stringtolob/filetolob with parameters in prepare statement will result in error:

       

      >> 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.
      

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            hezhenxing He Zhenxing
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: