Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3186

IN expressions in UPDATE statements throws Exceptions

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Invalid
    • Affects Version/s: 1.20.0
    • Fix Version/s: None
    • Component/s: None

      Description

      The patch to get correlated sub-queries working in UPDATE statements had this side-effect.

       

      CREATE TABLE t1 (id1 INT, val1 TEXT);
      CREATE TABLE t2 (id2 INT, val2 TEXT);
      
      UPDATE t1 SET val1 = 't2' WHERE id1 IN (1, 2, 3);
      
      -- or
      
      UPDATE t1 SET val1 = 't2' WHERE id1 IN (SELECT id2 FROM t2);

       

      These seem to raise exceptions now.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                psockali Pressenna
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h
                  1h