[SQLite] Ignore cases where we cannot get an expected result for a cast

mrigger · mrigger · commit 93462d9646a8 · 2020-08-24T15:31:33.000+02:00
diff --git a/src/sqlancer/sqlite3/ast/SQLite3Expression.java b/src/sqlancer/sqlite3/ast/SQLite3Expression.java
@@ -1630,17 +1630,25 @@ public static ConstantTuple applyAffinities(TypeAffinity leftAffinity, TypeAffin
         if (leftAffinity.isNumeric() && (rightAffinity == TypeAffinity.TEXT || rightAffinity == TypeAffinity.BLOB
                 || rightAffinity == TypeAffinity.NONE)) {
             right = right.applyNumericAffinity();
+            assert right != null;
         } else if (rightAffinity.isNumeric() && (leftAffinity == TypeAffinity.TEXT || leftAffinity == TypeAffinity.BLOB
                 || leftAffinity == TypeAffinity.NONE)) {
             left = left.applyNumericAffinity();
+            assert left != null;
         }
 
         // If one operand has TEXT affinity and the other has no affinity, then TEXT
         // affinity is applied to the other operand.
         if (leftAffinity == TypeAffinity.TEXT && rightAffinity == TypeAffinity.NONE) {
             right = right.applyTextAffinity();
+            if (right == null) {
+                throw new IgnoreMeException();
+            }
         } else if (rightAffinity == TypeAffinity.TEXT && leftAffinity == TypeAffinity.NONE) {
             left = left.applyTextAffinity();
+            if (left == null) {
+                throw new IgnoreMeException();
+            }
         }
         return new ConstantTuple(left, right);
     }
