Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4483

Not null constraint is not checked on temp table update

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 9.1, 9.0.5
    • Component/s: Query Engine
    • Labels:
      None

      Description

      An update such as:

      update x set e1 = (select null)

      will still be allowed to happen even if e1 is not null, since the not null validation is only being checked at for literal values.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: