Sergey Nuyanzin created CALCITE-7830:
----------------------------------------

             Summary:  UPDATE fails with IndexOutOfBoundsException when a SET 
value's type doesn't match the column
                 Key: CALCITE-7830
                 URL: https://issues.apache.org/jira/browse/CALCITE-7830
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Sergey Nuyanzin
            Assignee: Sergey Nuyanzin


SQL to reproduce in {{SqlValidatorTest}}
{code:sql}
UPDATE emp SET deptno = true
{code}

it fails as 
{noformat}
Caused by: java.lang.IndexOutOfBoundsException: Index 9 out of bounds for 
length 1
        at 
java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:100)
        at 
java.base/jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Preconditions.java:106)
        at 
java.base/jdk.internal.util.Preconditions.checkIndex(Preconditions.java:302)
        at java.base/java.util.Objects.checkIndex(Objects.java:385)
        at java.base/java.util.ArrayList.get(ArrayList.java:427)
        at org.apache.calcite.sql.SqlNodeList.get(SqlNodeList.java:161)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.getNthExpr(SqlValidatorImpl.java:6916)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.checkTypeAssignment(SqlValidatorImpl.java:6871)
{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to