Skip to content

Instantly share code, notes, and snippets.

@chaudum
Created November 28, 2016 21:48
Show Gist options
  • Save chaudum/d9f93f6b403a5838056cfd24a4c06b44 to your computer and use it in GitHub Desktop.
Save chaudum/d9f93f6b403a5838056cfd24a4c06b44 to your computer and use it in GitHub Desktop.
Exception:
SQLActionException[SQLParseException: line 1:14: no viable alternative at input 'col1']
Query:
SELECT ALL ( col1 * tab2.col0 + + CAST ( NULL AS REAL ) ) AS col2 FROM tab2
Exception:
Expected 1620 values, got 540
Query:
SELECT b6+285, a2*485, a5, a8+e2, d9, a3+e5
Exception:
Expected rows: [78, 79]. Got []
Query:
SELECT col0 AS col0 FROM tab2 WHERE NOT col2 BETWEEN + col0 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:31: no viable alternative at input 'col1']
Query:
SELECT + col0 * cor0.col0 + ( col1 + - CAST ( NULL AS REAL ) ) * + cor0.col0 col0 FROM tab1 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:12: no viable alternative at input 'col2']
Query:
SELECT - ( col2 * CAST ( NULL AS REAL ) ) AS col2 FROM tab0
Exception:
Expected rows: [-20, 41, 52]. Got []
Query:
SELECT DISTINCT col0 - col2 col0 FROM tab2 WHERE NOT col0 + - col0 * col1 BETWEEN col1 AND NULL
Exception:
Expected rows: [33]. Got []
Query:
SELECT ALL + col2 AS col2 FROM tab0 WHERE - col2 * col1 NOT BETWEEN + col2 + col0 * - col1 AND NULL
Exception:
Expected rows: [3481]. Got []
Query:
SELECT col1 * col1 FROM tab2 WHERE NOT col2 BETWEEN + col1 + - col2 AND ( NULL )
Exception:
Expected rows: [26, 27, 38]. Got []
Query:
SELECT ALL tab2.col2 AS col2 FROM tab2 WHERE ( col1 ) NOT BETWEEN NULL AND ( - col0 )
Exception:
Expected rows: [-2599, -2812, -8163]. Got []
Query:
SELECT + col1 * tab1.col0 + col1 - + col2 * col2 FROM tab1 WHERE + col2 NOT BETWEEN + col2 * col0 AND ( NULL )
Exception:
SQLActionException[SQLParseException: line 1:36: no viable alternative at input '-']
Query:
SELECT col2 + cor0.col1 * col1 / ( - 9 * + cor0.col0 + CAST ( NULL AS REAL ) ) AS col0 FROM tab2 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:24: no viable alternative at input 'col0']
Query:
SELECT tab2.col0 + + ( col0 * + CAST ( - ( + col0 ) AS REAL ) ) FROM tab2
Exception:
Expected rows: [106135, 1546]. Got []
Query:
SELECT ALL col2 + + tab2.col0 * col1 * tab2.col0 AS col1 FROM tab2 WHERE NOT + col1 BETWEEN ( NULL ) AND ( col2 * - col0 - - col0 * col1 )
Exception:
Expected rows: [10, 13]. Got []
Query:
SELECT col1 AS col2 FROM tab1 WHERE NOT ( - col0 ) BETWEEN - col1 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:23: no viable alternative at input '+']
Query:
SELECT ALL col1 * + ( + col2 * + col0 + CAST ( NULL AS REAL ) ) AS col2 FROM tab0
Exception:
Expected rows: [54, 96]. Got []
Query:
SELECT DISTINCT col2 FROM tab1 WHERE col0 NOT BETWEEN col2 AND NULL
Exception:
Expected rows: [2150, 3492, 8190]. Got []
Query:
SELECT ALL + col1 + - col1 * - col0 AS col2 FROM tab0 WHERE - col2 NOT BETWEEN col1 AND NULL
Exception:
Expected 4320 values, got 2760
Query:
SELECT d4+827, x1, c8+710, e9+360, x5, c2*231+d9
Exception:
Expected 24192 values, got 0
Query:
SELECT x9, a8+113, x3, b5, a2, c1, e7+413, a4
Exception:
Expected rows: [-7396]. Got []
Query:
SELECT DISTINCT tab0.col1 * - col1 col0 FROM tab0 WHERE NOT ( col0 ) BETWEEN + col2 AND NULL
Exception:
Expected rows: [86, 91, 97]. Got []
Query:
SELECT + col1 AS col0 FROM tab0 WHERE NOT col1 + col1 BETWEEN NULL AND col2 - + col1
Exception:
SQLActionException[SQLParseException: line 1:41: no viable alternative at input 'cor0']
Query:
SELECT + + CAST ( NULL AS INTEGER ) - ( cor0.col2 + - CAST ( NULL AS REAL ) ) / col2 FROM tab2 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:25: no viable alternative at input 'col1']
Query:
SELECT + - col1 + - ( ( col1 ) * - CAST ( - 33 AS REAL ) + - col1 ) AS col1 FROM tab1 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:19: no viable alternative at input 'col2']
Query:
SELECT ALL 92 * ( col2 + - CAST ( NULL AS REAL ) ) AS col1 FROM tab1 AS cor0
Exception:
Expected rows: [1225, 19008, 649522]. Got []
Query:
SELECT cor0.col0 * + col2 * col0 col0 FROM tab0 AS cor0 WHERE col0 / col2 NOT BETWEEN + col1 AND NULL
Exception:
SQLActionException[RelationUnknownException: Cannot resolve relation 't1']
Query:
SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END, (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d) FROM t1 WHERE a>b AND (e>c OR e<d) ORDER BY 2,1
Exception:
SQLActionException[SQLParseException: line 1:12: no viable alternative at input 'tab2']
Query:
SELECT - ( tab2.col1 * CAST ( NULL AS REAL ) ) FROM tab2
Exception:
Expected rows: [-26, -27, -38]. Got []
Query:
SELECT - col2 AS col2 FROM tab2 WHERE NOT + col0 + + col2 BETWEEN ( NULL ) AND col2 + - col2
Exception:
Expected rows: [-1, -33]. Got []
Query:
SELECT - col2 FROM tab0 cor0 WHERE col1 NOT BETWEEN ( NULL ) AND ( col0 + col0 )
Exception:
Expected rows: [-189, -2028, -3002]. Got []
Query:
SELECT DISTINCT - col0 * col2 FROM tab2 AS cor0 WHERE NOT ( - col2 ) BETWEEN col0 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:19: no viable alternative at input '76']
Query:
SELECT + col0 - ( 76 + + col2 * CAST ( - col0 AS REAL ) ) AS col0 FROM tab2
Exception:
Expected rows: [-86, -91, -97]. Got []
Query:
SELECT - tab0.col1 AS col0 FROM tab0 WHERE ( col0 ) NOT BETWEEN NULL AND - col2
Exception:
Expected rows: [24, 86, 33]. Got []
Query:
SELECT * FROM tab0 WHERE NOT col0 BETWEEN ( + col2 ) AND NULL
Exception:
SQLActionException[SQLParseException: line 1:28: no viable alternative at input 'col0']
Query:
SELECT + col2 * + col1 * ( col0 + - col1 * CAST ( col2 AS REAL ) ) AS col1 FROM tab2 cor0
Exception:
SQLActionException[SQLParseException: line 1:21: no viable alternative at input '-']
Query:
SELECT - col0 * + ( - col1 + - col0 * CAST ( col2 AS REAL ) ) AS col0 FROM tab2 AS cor0
Exception:
Expected rows: [29, 74, 93]. Got []
Query:
SELECT + col1 + tab1.col0 FROM tab1 WHERE NOT ( + col2 ) BETWEEN ( NULL ) AND ( col0 + + col1 - col0 * col2 * col0 )
Exception:
SQLActionException[SQLParseException: line 1:56: no viable alternative at input 'tab0']
Query:
SELECT ALL - tab0.col0 + col2 * tab0.col1 + + col2 * ( tab0.col0 * - CAST ( col0 AS REAL ) ) FROM tab0
Exception:
Expected rows: [-28, -47, -83]. Got []
Query:
SELECT - col2 + + col1 FROM tab1 WHERE ( - col1 ) NOT BETWEEN + col2 + col1 AND NULL
Exception:
Expected rows: [1, 33, 82]. Got []
Query:
SELECT tab0.col2 AS col2 FROM tab0 WHERE - col0 / + col1 NOT BETWEEN NULL AND - col2
Exception:
SQLActionException[SQLParseException: line 1:39: no viable alternative at input '+']
Query:
SELECT DISTINCT + col0 * - col1 + - ( + col1 * + CAST ( NULL AS REAL ) ) AS col1 FROM tab0
Exception:
Expected rows: [-35, -7298, -792]. Got []
Query:
SELECT ALL tab0.col2 * - tab0.col0 FROM tab0 WHERE NOT - col2 - - col2 BETWEEN col0 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:36: no viable alternative at input '+']
Query:
SELECT DISTINCT ( + col1 ) + 7 + ( + col2 + - CAST ( NULL AS REAL ) ) AS col1 FROM tab1
Exception:
Expected rows: [-11]. Got []
Query:
SELECT ALL + col2 / - col2 + - col1 AS col0 FROM tab1 WHERE NOT + col1 * + col0 - col2 * + col1 BETWEEN NULL AND + col0
Exception:
SQLActionException[SQLParseException: line 1:32: no viable alternative at input 'col0']
Query:
SELECT ALL - + col1 * col2 * ( col0 * CAST ( NULL AS REAL ) ) + col2 AS col2 FROM tab1 AS cor0
Exception:
Expected rows: [36480, 4212, 99840]. Got []
Query:
SELECT ALL - tab1.col2 * - col1 * + col0 AS col1 FROM tab1 WHERE NOT ( - col1 - + col0 ) BETWEEN + col0 + + col1 AND NULL
Exception:
Expected rows: [-96, 1003, 6633]. Got []
Query:
SELECT tab0.col2 * + tab0.col2 + - col1 FROM tab0 WHERE NOT col1 BETWEEN NULL AND ( col0 )
Exception:
SQLActionException[SQLParseException: line 1:26: no viable alternative at input '+']
Query:
SELECT - col2 / 53 - - ( + col2 + CAST ( + 74 AS REAL ) ) * col2 FROM tab2 AS cor0
Exception:
Expected rows: [17]. Got []
Query:
SELECT col1 FROM tab2 WHERE + col1 NOT BETWEEN col2 AND ( NULL )
Exception:
Expected rows: [26, 27]. Got []
Query:
SELECT DISTINCT col2 FROM tab2 WHERE col2 - + col1 NOT BETWEEN ( + col2 * col2 / col0 ) AND NULL
Exception:
Expected rows: [-2064, -8099]. Got []
Query:
SELECT DISTINCT col0 * - tab0.col1 FROM tab0 WHERE NOT + col0 * + col2 BETWEEN NULL AND ( + col1 + - col0 )
Exception:
Expected rows: [0, 0, 8]. Got []
Query:
SELECT col1 / col0 FROM tab1 WHERE - col0 NOT BETWEEN + col2 AND NULL
Exception:
Expected rows: [79, 17, 38]. Got []
Query:
SELECT ALL * FROM tab2 WHERE NOT col1 * - col1 + col1 * col2 BETWEEN NULL AND + tab2.col2
Exception:
SQLActionException[SQLParseException: line 1:32: no viable alternative at input 'col1']
Query:
SELECT DISTINCT + + col2 * - ( col1 * - col0 + + CAST ( col2 AS REAL ) ) AS col2 FROM tab1 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:10: no viable alternative at input 'tab1']
Query:
SELECT ( tab1.col2 + + CAST ( NULL AS REAL ) ) FROM tab1
Exception:
Expected rows: [2064]. Got []
Query:
SELECT DISTINCT col0 * col1 col1 FROM tab0 WHERE + col0 NOT BETWEEN col2 AND ( NULL )
Exception:
Expected rows: [10, 13, 26]. Got []
Query:
SELECT + col1 FROM tab1 WHERE NOT ( - col0 ) BETWEEN col1 AND NULL
Exception:
Expected 756 values, got 84
Query:
SELECT e6, e8+376, x4, x9, e5*680, d2+210, d3
Exception:
SQLActionException[SQLParseException: line 1:18: no viable alternative at input 'cor0']
Query:
SELECT ALL - ( ( cor0.col2 / CAST ( NULL AS REAL ) / - col0 ) ) * + col1 * cor0.col2 col1 FROM tab1 cor0
Exception:
Expected rows: [51072]. Got []
Query:
SELECT + col2 + + col0 * - tab2.col1 * - col2 FROM tab2 WHERE NOT ( - col1 * - col2 ) BETWEEN NULL AND + col1 * + col1
Exception:
SQLActionException[SQLParseException: line 1:42: no viable alternative at input '-']
Query:
SELECT col2 + + col2 * - col2 - col2 * ( - cor0.col1 + - col1 * + CAST ( col0 AS REAL ) ) FROM tab1 AS cor0
Exception:
Expected rows: [-7, -78, -79]. Got []
Query:
SELECT - tab2.col0 AS col1 FROM tab2 WHERE NOT + col1 + + col0 BETWEEN NULL AND - col2 * tab2.col1
Exception:
SQLActionException[SQLParseException: line 1:42: no viable alternative at input '+']
Query:
SELECT DISTINCT - + col1 - cor0.col1 * ( + col0 * + CAST ( NULL AS REAL ) ) FROM tab2 AS cor0
Exception:
Expected rows: [1, 1]. Got []
Query:
SELECT col0 / col0 FROM tab0 WHERE NOT col0 BETWEEN NULL AND + col2
Exception:
Expected rows: [215, 3704, 7775]. Got []
Query:
SELECT ALL col2 * + col0 + col2 / - col2 + + col2 AS col1 FROM tab1 WHERE NOT ( col1 ) BETWEEN + col2 AND NULL
Exception:
Expected rows: [-17, -31, -59]. Got []
Query:
SELECT DISTINCT - col1 FROM tab2 WHERE ( - col1 ) NOT BETWEEN NULL AND - col2 * col2
Exception:
SQLActionException[SQLParseException: line 1:12: no viable alternative at input 'tab1']
Query:
SELECT + ( tab1.col1 * - CAST ( NULL AS REAL ) ) AS col0 FROM tab1
Exception:
SQLActionException[SQLParseException: line 1:18: no viable alternative at input '+']
Query:
SELECT ALL + ( ( + col0 ) * + CAST ( NULL AS REAL ) ) - - col2 * col1 FROM tab1
Exception:
Expected rows: [26]. Got []
Query:
SELECT ALL col1 AS col1 FROM tab1 WHERE NOT col1 BETWEEN NULL AND - col0 * - col0
Exception:
Expected rows: [-5700]. Got []
Query:
SELECT DISTINCT - col2 * + col1 * col1 AS col2 FROM tab1 WHERE + col0 NOT BETWEEN NULL AND ( col2 )
Exception:
Expected 9 values, got 6
Query:
SELECT DISTINCT * FROM tab1 AS cor0 WHERE cor0.col2 >= + col0 OR NOT col1 BETWEEN + col0 * col2 AND NULL
Exception:
Expected rows: [-3, -64, -80]. Got []
Query:
SELECT DISTINCT - col0 FROM tab1 WHERE - col2 NOT BETWEEN col1 AND ( NULL )
Exception:
SQLActionException[SQLParseException: line 1:10: no viable alternative at input '+']
Query:
SELECT ( + col0 * CAST ( NULL AS REAL ) ) + col1 + + tab1.col2 col2 FROM tab1
Exception:
SQLActionException[SQLParseException: line 1:29: no viable alternative at input 'col1']
Query:
SELECT col1 + cor0.col0 - ( col1 + CAST ( NULL AS REAL ) ) / 49 AS col0 FROM tab2 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:28: no viable alternative at input 'col2']
Query:
SELECT - + cor0.col1 + + ( col2 + CAST ( - col2 AS REAL ) ) col1 FROM tab2 cor0
Exception:
SQLActionException[SQLParseException: line 1:46: no viable alternative at input '+']
Query:
SELECT DISTINCT - - col1 / col2 - col1 * - ( + ( col2 ) * CAST ( NULL AS REAL ) ) FROM tab0 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:33: no viable alternative at input 'col2']
Query:
SELECT + + cor0.col2 * - 26 + ( col2 + CAST ( NULL AS REAL ) ) FROM tab2 AS cor0
Exception:
SQLActionException[ClassCastException: java.lang.Long cannot be cast to java.lang.Integer]
Query:
SELECT abs(a), CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 WHEN a<b+3 THEN 333 ELSE 444 END FROM t1 WHERE d>e OR c>d OR (e>c OR e<d) ORDER BY 2,1
Exception:
SQLActionException[SQLParseException: line 1:14: no viable alternative at input '+']
Query:
SELECT ALL ( + tab2.col2 * - CAST ( NULL AS REAL ) ) col0 FROM tab2, tab1 AS cor0, tab1 AS cor1
Exception:
SQLActionException[SQLParseException: line 1:27: no viable alternative at input '-']
Query:
SELECT ALL - + col0 * - ( - ( cor0.col2 ) * + CAST ( col1 AS REAL ) ) + col2 col1 FROM tab2 AS cor0
Exception:
Expected rows: [78, 59, 26]. Got []
Query:
SELECT DISTINCT * FROM tab2 WHERE NOT ( - col1 * col0 + col2 * + col2 ) BETWEEN - col1 AND ( NULL )
Exception:
Expected rows: [64, 10, 57]. Got []
Query:
SELECT ALL * FROM tab1 WHERE NOT tab1.col2 BETWEEN col0 AND NULL
Exception:
Expected rows: [164, 2, 66]. Got []
Query:
SELECT col2 + col2 AS col1 FROM tab0 WHERE NOT col1 * - col2 BETWEEN col0 AND NULL
Exception:
Expected rows: [53, 9, 96]. Got []
Query:
SELECT - col2 + + col1 AS col1 FROM tab0 WHERE NOT col0 BETWEEN col0 * col0 AND NULL
Exception:
Expected rows: [35, 89]. Got []
Query:
SELECT cor0.col0 FROM tab0 AS cor0 WHERE NOT col2 BETWEEN col0 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:12: no viable alternative at input '+']
Query:
SELECT - ( + tab0.col1 + CAST ( NULL AS REAL ) ) FROM tab0
Exception:
Expected rows: [3, 26, 54, 80, 13, 96]. Got []
Query:
SELECT DISTINCT * FROM tab1 WHERE ( + col2 + - col1 ) NOT BETWEEN NULL AND ( col0 )
Exception:
SQLActionException[SQLParseException: line 1:17: no viable alternative at input '33']
Query:
SELECT col1 - ( 33 * cor0.col0 + - CAST ( NULL AS REAL ) ) FROM tab1 AS cor0
Exception:
Expected rows: [-1040, -640, -78]. Got []
Query:
SELECT - col0 * tab1.col1 AS col1 FROM tab1 WHERE - col1 * + col1 NOT BETWEEN ( - col1 - col1 ) AND NULL
Exception:
Expected 1620 values, got 0
Query:
SELECT b6+285, a2*485, a5, a8+e2, d9, a3+e5
Exception:
SQLActionException[SQLParseException: line 1:35: no viable alternative at input 'col1']
Query:
SELECT + - col0 + - cor0.col0 + ( col1 * + CAST ( col0 AS REAL ) ) FROM tab1 cor0
Exception:
Expected rows: [-1113, -6813]. Got []
Query:
SELECT - col2 * col2 + - col0 col0 FROM tab0 WHERE NOT ( - col1 ) BETWEEN NULL AND col0 + col2 + col0 * - col2
Exception:
SQLActionException[SQLParseException: line 1:58: no viable alternative at input 'cor0']
Query:
SELECT ALL + CAST ( + ( - cor0.col1 ) AS INTEGER ) + ( ( cor0.col0 / - CAST ( NULL AS REAL ) / col0 ) ) * + col0 * col1 FROM tab0 AS cor0
Exception:
Expected rows: [-1248, -1404, -570]. Got []
Query:
SELECT DISTINCT - col2 * col1 AS col1 FROM tab1 WHERE + col0 * col2 * col2 NOT BETWEEN NULL AND - col1
Exception:
SQLActionException[SQLParseException: line 1:12: no viable alternative at input 'col1']
Query:
SELECT - ( col1 + - col2 * CAST ( col2 AS REAL ) ) FROM tab0
Exception:
Expected rows: [-1264, -210, -4524]. Got []
Query:
SELECT DISTINCT + col0 + col0 * - col1 col0 FROM tab2 WHERE col2 * - col1 + col0 NOT BETWEEN + col0 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:52: no viable alternative at input '-']
Query:
SELECT 18 + col0 * - col0 - ( + ( + col1 ) ) * - ( - cor0.col0 + + col1 * - CAST ( col2 AS REAL ) ) AS col0 FROM tab1 cor0
Exception:
Expected rows: [109, 67, 80]. Got []
Query:
SELECT col1 + + col2 FROM tab1 WHERE NOT + col0 + col1 BETWEEN ( NULL ) AND ( - col2 + col2 )
Exception:
Expected rows: [-1534, -646, -837]. Got []
Query:
SELECT + col2 * - col1 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN col1 + col0 AND NULL OR NOT - col1 BETWEEN col1 * col1 + + col1 AND NULL
Exception:
Expected rows: [-20, 118, 147]. Got []
Query:
SELECT DISTINCT col0 + + col0 + - col1 FROM tab1 WHERE + col1 NOT BETWEEN col2 AND NULL
Exception:
Expected rows: [35, 97, 1]. Got []
Query:
SELECT * FROM tab0 WHERE NOT col1 * + col1 + col2 + - col1 BETWEEN ( NULL ) AND ( - col1 + + tab0.col2 * col1 * col0 )
Exception:
SQLActionException[SQLParseException: line 1:19: no viable alternative at input 'tab1']
Query:
SELECT DISTINCT ( tab1.col0 * + CAST ( NULL AS REAL ) ) FROM tab1
Exception:
SQLActionException[SQLParseException: line 1:23: no viable alternative at input 'cor0']
Query:
SELECT - col1 + + ( ( cor0.col1 ) + - CAST ( 53 AS REAL ) ) AS col0 FROM tab1 AS cor0
Exception:
Expected rows: [-1326, -186, -4543]. Got []
Query:
SELECT ALL + col1 * - col0 + + col1 col0 FROM tab2 AS cor0 WHERE NOT ( col2 ) BETWEEN NULL AND - col1
Exception:
Expected rows: [3, 26, 54]. Got []
Query:
SELECT ALL * FROM tab1 WHERE NOT - col2 / + col1 BETWEEN col1 - + col0 AND NULL
Exception:
Expected 94080 values, got 70000
Query:
SELECT b5, d3, x9, c8+411, c4+e6, c6+c4, b2
Exception:
Expected rows: [-33, -82]. Got []
Query:
SELECT - col2 FROM tab0 WHERE NOT + col1 + + col0 BETWEEN + col1 * col2 AND NULL
Exception:
Expected rows: [-7482, -8372, -9506]. Got []
Query:
SELECT ALL - col1 * col1 + - col1 AS col2 FROM tab0 WHERE NOT col1 * + col1 BETWEEN NULL AND col1 * - col2
Exception:
SQLActionException[SQLParseException: line 1:10: no viable alternative at input 'col2']
Query:
SELECT ( col2 + CAST ( NULL AS REAL ) ) * - 36 FROM tab2
Exception:
SQLActionException[SQLParseException: line 1:41: no viable alternative at input 'col1']
Query:
SELECT ALL + cor0.col1 + - col0 * + ( ( col1 ) * CAST ( 90 AS REAL ) ) FROM tab1 AS cor0
Exception:
SQLActionException[NullPointerException in io.crate.operation.join.CombinedRow.get(CombinedRow.java:39)]
Query:
SELECT * FROM tab2, tab2 AS cor0 WHERE NOT NULL NOT IN ( + tab2.col1 )
Exception:
SQLActionException[Error in ClassCastException]
Query:
SELECT abs(a), abs(b-c), d-e, e FROM t1 WHERE a>b OR b>c OR (e>c OR e<d) ORDER BY 2,1,4,3
Exception:
Expected rows: [0, 0, 4]. Got []
Query:
SELECT col1 / col0 FROM tab2 WHERE NOT - col2 BETWEEN ( col2 * + col1 ) AND NULL
Exception:
SQLActionException[SQLParseException: line 1:19: no viable alternative at input 'col1']
Query:
SELECT + 41 + + ( col1 + + CAST ( col0 AS REAL ) ) FROM tab1 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:8: no viable alternative at input 'INDEX']
Query:
CREATE INDEX t8all ON t8(e8 DESC, d8 ASC, c8 DESC, b8 ASC, a8 DESC)
Exception:
SQLActionException[SQLParseException: line 1:48: no viable alternative at input '+']
Query:
SELECT DISTINCT CAST ( NULL AS INTEGER ) * + ( + col0 * CAST ( NULL AS REAL ) ) AS col0 FROM tab1 AS cor0
Exception:
Expected rows: [262144, 27, 512000]. Got []
Query:
SELECT DISTINCT col0 * tab1.col0 * col0 FROM tab1 WHERE col1 * tab1.col1 NOT BETWEEN NULL AND - col1
Exception:
Expected rows: [-54, -57, -96]. Got []
Query:
SELECT ALL - col2 AS col1 FROM tab1 WHERE col1 + col0 + col0 * - col1 NOT BETWEEN col0 + col0 AND NULL
Exception:
Expected rows: [89, 91, 82]. Got []
Query:
SELECT * FROM tab0 WHERE NOT col0 BETWEEN NULL AND + col1 - col2
Exception:
Expected rows: [0, 0, 0]. Got []
Query:
SELECT col0 - col0 AS col2 FROM tab2 WHERE NOT col0 BETWEEN NULL AND - col0
Exception:
Expected rows: [-2916, -3249, -9216]. Got []
Query:
SELECT ALL col2 * - tab1.col2 AS col0 FROM tab1 WHERE - col1 * - col0 NOT BETWEEN NULL AND + col0
Exception:
SQLActionException[SQLParseException: line 1:12: no viable alternative at input '-']
Query:
SELECT + ( - col2 + - CAST ( + col0 AS REAL ) ) AS col0 FROM tab2
Exception:
Expected rows: [-97]. Got []
Query:
SELECT + tab0.col2 * - tab0.col1 FROM tab0 WHERE NOT ( + col2 * + col2 * col1 ) BETWEEN col1 * tab0.col0 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:28: no viable alternative at input 'col1']
Query:
SELECT - col0 / + col0 + ( col1 + - CAST ( NULL AS REAL ) ) FROM tab1 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:32: no viable alternative at input '-']
Query:
SELECT DISTINCT + + col0 + + ( - col1 + col0 * CAST ( NULL AS REAL ) ) FROM tab1 AS cor0
Exception:
Expected rows: [11, 14, 27]. Got []
Query:
SELECT + col1 + tab1.col0 / col0 AS col0 FROM tab1 WHERE col1 * col1 NOT BETWEEN NULL AND + col2
Exception:
SQLActionException[SQLParseException: line 1:21: no viable alternative at input '+']
Query:
SELECT - col2 * - ( + ( col0 ) * - CAST ( ( col0 ) AS REAL ) ) AS col2 FROM tab2
Exception:
Expected rows: [-24, -35, -89]. Got []
Query:
SELECT DISTINCT - tab0.col0 FROM tab0 WHERE NOT ( - col1 * - col1 ) BETWEEN ( NULL ) AND ( col2 + col0 / - col0 )
Exception:
Expected rows: [178, 48, 70]. Got []
Query:
SELECT ALL tab0.col0 + col0 FROM tab0 WHERE NOT - col0 BETWEEN + col0 + col1 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:12: no viable alternative at input 'col0']
Query:
SELECT + ( col0 + + col1 * + CAST ( col1 AS REAL ) ) AS col0 FROM tab0
Exception:
SQLActionException[SQLParseException: line 1:27: no viable alternative at input 'col1']
Query:
SELECT + 9 * col0 + - ( ( col1 ) + + CAST ( NULL AS REAL ) ) * col2 AS col2 FROM tab0 cor0
Exception:
Expected rows: [1225, 576]. Got []
Query:
SELECT - tab0.col0 * - col0 AS col0 FROM tab0 WHERE col1 + - col2 NOT BETWEEN NULL AND ( col2 )
Exception:
SQLActionException[SQLParseException: line 1:19: no viable alternative at input '+']
Query:
SELECT col0 * - ( + col1 + - CAST ( + col2 AS REAL ) ) FROM tab0 cor0
Exception:
Expected rows: [3]. Got []
Query:
SELECT ALL col0 AS col1 FROM tab1 WHERE tab1.col2 * col1 NOT BETWEEN NULL AND - col0 * - col2
Exception:
Expected 72576 values, got 60000
Query:
SELECT e2, c5+766, e1, d9, d4+913+d2, x3
Exception:
Expected 840 values, got 0
Query:
SELECT a1+568, b6, e5+681, d4+e4, x3, d9, c2+504
Exception:
Expected rows: [24, 35, 89]. Got []
Query:
SELECT + col0 FROM tab0 WHERE NOT ( col2 ) BETWEEN col1 * tab0.col2 AND ( NULL )
Exception:
Expected 82944 values, got 60000
Query:
SELECT e8, e6+952, d4, c2, a5, b9
Exception:
Expected rows: [-51, -7, 24]. Got []
Query:
SELECT DISTINCT - col1 + - tab2.col2 + col0 FROM tab2 WHERE NOT ( col0 * - col0 ) BETWEEN ( col0 ) AND NULL
Exception:
SQLActionException[SQLParseException: line 1:55: no viable alternative at input '-']
Query:
SELECT DISTINCT - - col1 * + col0 + + cor0.col2 * + ( - ( + col2 ) + - CAST ( NULL AS REAL ) ) FROM tab0 AS cor0
Exception:
Expected rows: [119, 173, 98]. Got []
Query:
SELECT col1 + col2 FROM tab0 WHERE NOT col0 BETWEEN NULL AND - col2
Exception:
SQLActionException[SQLParseException: line 1:10: no viable alternative at input 'col0']
Query:
SELECT ( col0 * CAST ( NULL AS REAL ) ) FROM tab0
Exception:
Expected rows: [0]. Got []
Query:
SELECT DISTINCT - col0 - - col0 col1 FROM tab0 WHERE NOT col1 * col0 BETWEEN NULL AND ( - col2 )
Exception:
Expected rows: [2088, 3430, 8188]. Got []
Query:
SELECT DISTINCT col1 * col0 + + col0 AS col2 FROM tab0 WHERE NOT col1 + + col1 BETWEEN NULL AND - col0 + - col0
Exception:
Expected rows: [289, 3481]. Got []
Query:
SELECT + col1 * tab2.col1 AS col0 FROM tab2 WHERE ( + col1 ) NOT BETWEEN col0 AND ( NULL )
Exception:
Expected rows: [-1225, -19008, -649522]. Got []
Query:
SELECT - tab0.col0 * + col0 * tab0.col2 FROM tab0 WHERE - col2 * + col0 NOT BETWEEN col0 AND NULL
Exception:
Expected rows: [86, 91]. Got []
Query:
SELECT col1 AS col1 FROM tab0 WHERE NOT col1 + col2 BETWEEN NULL AND col1 + - col0 / - col2
Exception:
SQLActionException[SQLParseException: line 1:23: no viable alternative at input 'col1']
Query:
SELECT DISTINCT + ( ( col1 ) + CAST ( NULL AS REAL ) ) * col0 FROM tab2
Exception:
SQLActionException[SQLParseException: line 1:17: no viable alternative at input 'col1']
Query:
SELECT - 85 * ( col1 + CAST ( col2 AS REAL ) ) * col0 FROM tab2
Exception:
SQLActionException[SQLParseException: line 1:10: no viable alternative at input 'col1']
Query:
SELECT ( col1 * col1 + - CAST ( NULL AS REAL ) ) AS col0 FROM tab0
Exception:
SQLActionException[SQLParseException: line 1:35: no viable alternative at input '+']
Query:
SELECT DISTINCT col0 * - col1 + ( + col2 * + CAST ( NULL AS REAL ) ) + + col0 AS col2 FROM tab2 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:41: no viable alternative at input 'col2']
Query:
SELECT ALL CAST ( NULL AS INTEGER ) * ( col2 * CAST ( + 74 AS REAL ) ) FROM tab1
Exception:
SQLActionException[SQLParseException: line 1:30: no viable alternative at input '-']
Query:
SELECT + col1 * + col0 + + ( - ( col2 ) * CAST ( col2 AS REAL ) + - col1 ) AS col2 FROM tab0 AS cor0
Exception:
SQLActionException[UnsupportedFeatureException: Unsupported expression EXISTS (SELECT 1
Query:
SELECT c, a+b*2+c*3+d*4 FROM t1 WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) ORDER BY 2,1
Exception:
SQLActionException[SQLParseException: line 1:16: no viable alternative at input '-']
Query:
SELECT ALL + ( - col0 * - CAST ( - 22 AS REAL ) ) AS col2 FROM tab0
Exception:
Expected 13824 values, got 6912
Query:
SELECT e6+e3, x9, b4, a3+a7, b1+c4, x2, d7, c5*484+d3
Exception:
SQLActionException[SQLParseException: line 1:27: no viable alternative at input 'col2']
Query:
SELECT ALL + + col1 * + ( col2 * CAST ( - col2 AS REAL ) ) FROM tab0 cor0
Exception:
SQLActionException[SQLParseException: line 1:15: no viable alternative at input '+']
Query:
SELECT 14 + ( + cor0.col2 + CAST ( NULL AS REAL ) ) AS col0 FROM tab1 AS cor0
Exception:
Expected rows: [-17635, -19714]. Got []
Query:
SELECT - col2 * + col2 * col2 - + col1 FROM tab2 WHERE col2 NOT BETWEEN ( tab2.col1 ) AND NULL
Exception:
Expected rows: [-53, -9, -96]. Got []
Query:
SELECT ALL - col1 + col2 FROM tab0 WHERE + col0 NOT BETWEEN NULL AND ( col1 / col1 )
Exception:
Expected rows: [7, 31, 27, 79, 17, 38]. Got []
Query:
SELECT ALL * FROM tab2 WHERE - col2 * + col2 NOT BETWEEN ( - col0 * col1 ) AND NULL
Exception:
Expected rows: [6241]. Got []
Query:
SELECT col0 * col0 col0 FROM tab2 WHERE NOT ( + col1 ) BETWEEN col2 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:26: no viable alternative at input '-']
Query:
SELECT 2 + tab1.col0 + ( - col1 * col1 + + CAST ( NULL AS REAL ) ) AS col0 FROM tab1
Exception:
SQLActionException[SQLParseException: line 1:16: no viable alternative at input 'col1']
Query:
SELECT ALL - ( col1 * CAST ( NULL AS REAL ) ) - - col2 * - col0 AS col1 FROM tab0
Exception:
Expected rows: [-109, -67, -80]. Got []
Query:
SELECT - col1 + - col2 FROM tab1 WHERE NOT - col2 BETWEEN ( col1 ) AND NULL
Exception:
SQLActionException[SQLParseException: line 1:38: no viable alternative at input 'col2']
Query:
SELECT DISTINCT col1 * cor0.col2 - ( col2 + CAST ( NULL AS REAL ) ) col2 FROM tab2 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:41: no viable alternative at input '+']
Query:
SELECT DISTINCT - + col2 + + col0 * - ( + col0 * - col2 + + CAST ( NULL AS REAL ) * col1 ) AS col0 FROM tab2 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:35: no viable alternative at input 'tab1']
Query:
SELECT col0 + - 59 + + col0 * ( ( tab1.col0 ) * CAST ( + col2 AS REAL ) ) AS col1 FROM tab1
Exception:
Expected 7680 values, got 2112
Query:
SELECT d4*104+c5, x2, e7, a3+c5, b5, d1+522, a9, c6
Exception:
Expected rows: [-21, -519, -864]. Got []
Query:
SELECT + col2 + col0 + col1 * - col0 FROM tab1 WHERE ( + col2 ) NOT BETWEEN col1 * + col2 AND NULL
Exception:
Expected rows: [108, 3591, 7584]. Got []
Query:
SELECT ALL col2 * col0 - + col2 AS col2 FROM tab1 WHERE NOT - col2 * col2 - col0 BETWEEN col0 * col2 + col2 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:25: no viable alternative at input '+']
Query:
SELECT ALL - + col1 * ( + col2 * + CAST ( ( col1 ) AS REAL ) ) + + col0 AS col1 FROM tab0 AS cor0
Exception:
Expected rows: [7, 31, 27]. Got []
Query:
SELECT ALL * FROM tab2 WHERE col0 NOT BETWEEN - col0 + + col2 / - col0 + + col2 AND NULL
Exception:
Expected rows: [7, 78]. Got []
Query:
SELECT ALL col0 FROM tab2 WHERE ( + col1 ) NOT BETWEEN NULL AND + col2
Exception:
Expected rows: [1534, 646, 837]. Got []
Query:
SELECT - col1 * - col2 FROM tab2 WHERE NOT col1 + - col0 BETWEEN NULL AND - col0 * col2
Exception:
SQLActionException[SQLParseException: line 1:24: no viable alternative at input '+']
Query:
SELECT DISTINCT 81 * ( + tab0.col1 + CAST ( NULL AS REAL ) ) / + cor0.col1 AS col1 FROM tab0, tab1 AS cor0, tab2 AS cor1
Exception:
SQLActionException[SQLParseException: line 1:17: no viable alternative at input '+']
Query:
SELECT 34 / + ( + cor0.col1 * + CAST ( NULL AS REAL ) ) col2 FROM tab0 AS cor0 CROSS JOIN tab1 AS cor1
Exception:
Expected rows: [-162, -3648, -7680]. Got []
Query:
SELECT - col2 * + col0 AS col0 FROM tab1 WHERE ( + col2 ) NOT BETWEEN NULL AND - col0
Exception:
Expected rows: [-706, -7207, 62]. Got []
Query:
SELECT col1 + col0 * - col2 AS col1 FROM tab0 WHERE col1 NOT BETWEEN NULL AND ( - col2 )
Exception:
SQLActionException[SQLParseException: line 1:30: no viable alternative at input 'col0']
Query:
SELECT + col0 * + col1 + + ( col0 * + CAST ( NULL AS REAL ) ) AS col1 FROM tab0
Exception:
Expected rows: [91, 97]. Got []
Query:
SELECT col1 AS col1 FROM tab0 WHERE ( + col0 ) NOT BETWEEN NULL AND + col2
Exception:
SQLActionException[SQLParseException: line 1:16: no viable alternative at input '+']
Query:
SELECT ALL - ( + col0 + CAST ( NULL AS REAL ) * - col0 ) FROM tab1
Exception:
Expected rows: [1136, 132, 697]. Got []
Query:
SELECT col1 * tab1.col2 / col1 + col0 * + col1 AS col0 FROM tab1 WHERE NOT col2 BETWEEN NULL AND col1 / col0
Exception:
Expected rows: [327, 3507, 988]. Got []
Query:
SELECT col1 * + tab2.col1 + col2 FROM tab2 WHERE ( - col0 * + col2 - col2 ) NOT BETWEEN col0 + col2 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:17: no viable alternative at input '-']
Query:
SELECT col1 * ( - ( + col1 ) * - CAST ( NULL AS REAL ) ) FROM tab1
Exception:
SQLActionException[SQLParseException: line 1:21: no viable alternative at input 'col0']
Query:
SELECT - + 24 + - ( col0 + - CAST ( NULL AS REAL ) ) AS col2 FROM tab2 cor0
Exception:
Expected rows: [78, 59, 26, 79, 17, 38]. Got []
Query:
SELECT ALL * FROM tab2 WHERE NOT - col0 BETWEEN - col1 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:19: no viable alternative at input '-']
Query:
SELECT col2 * - ( - tab1.col0 * - CAST ( + col2 AS REAL ) ) + - col0 FROM tab1
Exception:
Expected rows: [-16, -51, 7]. Got []
Query:
SELECT DISTINCT col0 - col2 FROM tab1 WHERE col1 + col1 NOT BETWEEN ( tab1.col2 ) AND NULL
Exception:
Expected rows: [24, 86, 33, 89, 91, 82]. Got []
Query:
SELECT DISTINCT * FROM tab0 WHERE ( - col2 * col2 ) NOT BETWEEN - col0 AND NULL
Exception:
Expected rows: [622, 73]. Got []
Query:
SELECT + col1 * + col1 + - col2 AS col2 FROM tab1 WHERE - col2 NOT BETWEEN - col0 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:21: no viable alternative at input 'col1']
Query:
SELECT DISTINCT - ( col1 + - col0 * + CAST ( NULL AS REAL ) ) FROM tab1
Exception:
Expected rows: [108, 114, 192]. Got []
Query:
SELECT col2 + col2 FROM tab1 WHERE ( col2 + col0 ) NOT BETWEEN NULL AND + col0
Exception:
Expected 3528 values, got 630
Query:
SELECT b5+342+a6, d4+810+a1, c8, a1, d6+b1, c7+554, x2
Exception:
Expected rows: [1115, 599]. Got []
Query:
SELECT col2 * + col2 + - col0 * col0 / + col1 + tab2.col2 FROM tab2 WHERE col0 NOT BETWEEN ( NULL ) AND ( col1 )
Exception:
SQLActionException[SQLParseException: line 1:28: no viable alternative at input '66']
Query:
SELECT - col1 * col2 * - ( 66 + + col0 * - CAST ( + col0 AS REAL ) ) AS col1 FROM tab2 AS cor0
Exception:
Expected rows: [210]. Got []
Query:
SELECT DISTINCT - col0 + col1 * + col0 FROM tab2 WHERE NOT - col2 BETWEEN col2 + - col0 AND ( NULL )
Exception:
Expected rows: [3, 70, 86]. Got []
Query:
SELECT ALL col0 / + cor0.col1 + col0 AS col1 FROM tab1 cor0 WHERE NOT ( - col0 ) BETWEEN + col1 AND NULL
Exception:
Expected 9 values, got 0
Query:
SELECT DISTINCT * FROM tab0 WHERE ( col1 ) NOT BETWEEN col1 * col0 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:18: no viable alternative at input '-']
Query:
SELECT - 0 + - ( - col0 + - CAST ( col2 AS REAL ) ) FROM tab0
Exception:
Expected rows: [-86]. Got []
Query:
SELECT ALL - col1 FROM tab0 WHERE NOT col0 BETWEEN + col2 AND NULL
Exception:
Expected rows: [17, 31, 59]. Got []
Query:
SELECT tab2.col1 AS col2 FROM tab2 WHERE - col1 + - col2 NOT BETWEEN col0 + - col1 * - col2 AND NULL
Exception:
Expected rows: [-636056, -753571, -912673]. Got []
Query:
SELECT tab0.col1 * col1 * - col1 AS col2 FROM tab0 WHERE col2 NOT BETWEEN + col1 * col0 AND NULL
Exception:
Expected rows: [189, 2028, 3002]. Got []
Query:
SELECT cor0.col0 * + col2 AS col2 FROM tab2 AS cor0 WHERE NOT ( + col1 ) BETWEEN col2 * cor0.col1 AND NULL
Exception:
Expected rows: [2838, 7462, 97]. Got []
Query:
SELECT + cor0.col1 * col2 FROM tab0 AS cor0 WHERE + col2 * col0 NOT BETWEEN NULL AND - col1 OR NOT NULL IN ( + cor0.col0 - + col2 )
Exception:
Expected 20160 values, got 0
Query:
SELECT d6, c7+c3, b9+a4, e1+748, e3+d3, x4, a8+b6
Exception:
SQLActionException[SQLParseException: line 1:45: no viable alternative at input '-']
Query:
SELECT DISTINCT + + 99 * + ( + col2 ) - - ( - ( + col1 ) * CAST ( NULL AS REAL ) ) AS col1 FROM tab2 AS cor0
Exception:
SQLActionException[SQLParseException: line 1:21: no viable alternative at input 'col2']
Query:
SELECT col0 + - ( ( col2 ) + - CAST ( NULL AS REAL ) ) FROM tab0 AS cor0
Exception:
Expected rows: [289, 3481, 961]. Got []
Query:
SELECT + col1 * tab2.col1 AS col2 FROM tab2 WHERE + col1 NOT BETWEEN NULL AND col1 * - col0
Exception:
Expected rows: [33, 82]. Got []
Query:
SELECT col2 FROM tab0 WHERE ( col0 ) NOT BETWEEN col0 * + col2 AND NULL
Exception:
Expected rows: [-2064, -3395, -8099]. Got []
Query:
SELECT ALL - col0 * col1 col1 FROM tab0 WHERE NOT col1 BETWEEN NULL AND col2 * - col0
Exception:
Expected rows: [-87, -91, -97]. Got []
Query:
SELECT DISTINCT col2 / - col0 - + col1 AS col1 FROM tab0 WHERE + col2 NOT BETWEEN ( col0 * + col1 ) AND NULL
Exception:
SQLActionException[SQLParseException: line 1:15: no viable alternative at input 'col0']
Query:
SELECT 53 + ( col0 + - CAST ( col1 AS REAL ) ) AS col2 FROM tab2
Exception:
SQLActionException[SQLParseException: line 1:37: no viable alternative at input '+']
Query:
SELECT DISTINCT 72 * col2 + - 0 / ( + col0 + - CAST ( + col0 AS REAL ) * - col2 ) col2 FROM tab1
Exception:
SQLActionException[SQLParseException: line 1:28: no viable alternative at input '-']
Query:
SELECT + col2 + - col1 + ( - col0 + - CAST ( NULL AS REAL ) ) * col2 AS col1 FROM tab0 AS cor0
Exception:
Expected rows: [64, 10, 57, 80, 13, 96]. Got []
Query:
SELECT * FROM tab1 WHERE NOT col0 BETWEEN NULL AND ( col1 )
Exception:
Expected rows: [7, 77, 78]. Got []
Query:
SELECT ALL col0 + - col2 / col1 FROM tab2 WHERE + col2 * col2 NOT BETWEEN ( NULL ) AND col1
Exception:
SQLActionException[SQLParseException: line 1:34: no viable alternative at input 'col2']
Query:
SELECT DISTINCT + col2 - 0 / + ( col2 + + CAST ( NULL AS REAL ) ) FROM tab0 AS cor0
Exception:
Expected rows: [171]. Got []
Query:
SELECT ALL + col2 + col2 + col2 AS col1 FROM tab1 WHERE NOT + col0 BETWEEN ( NULL ) AND + col2
Exception:
Expected rows: [3, 64, 80]. Got []
Query:
SELECT + col0 FROM tab1 WHERE - col0 + col0 NOT BETWEEN + col2 + + col2 AND NULL
Exception:
Expected rows: [7, 78, 79]. Got []
Query:
SELECT col0 FROM tab2 WHERE NOT + col1 BETWEEN NULL AND tab2.col1 * + col0 * - col2
Exception:
Expected rows: [837]. Got []
Query:
SELECT col2 * + col1 FROM tab2 WHERE ( col0 ) NOT BETWEEN col1 AND NULL
Exception:
Expected rows: [1, 1089, 6724]. Got []
Query:
SELECT col2 * col2 FROM tab0 AS cor0 WHERE NOT col1 * col2 * - cor0.col2 BETWEEN col2 AND NULL
Exception:
SQLActionException[SQLParseException: line 1:23: no viable alternative at input 'col0']
Query:
SELECT ALL - 18 + - ( col0 * CAST ( NULL AS REAL ) + cor0.col2 ) FROM tab2 cor0
Exception:
Expected rows: [-10, -13, -26]. Got []
Query:
SELECT DISTINCT - col1 AS col2 FROM tab1 WHERE + col2 NOT BETWEEN NULL AND - col1
Exception:
Expected rows: [7, 31, 27, 78, 59, 26]. Got []
Query:
SELECT ALL * FROM tab2 WHERE NOT ( + col1 ) BETWEEN NULL AND col2
Exception:
SQLActionException[SQLParseException: line 1:53: no viable alternative at input 'col0']
Query:
SELECT ALL + - col2 * col1 + col2 * + cor0.col2 - ( col0 * CAST ( 15 AS REAL ) ) FROM tab0 AS cor0
Exception:
Expected rows: [54, 57, 96]. Got []
Query:
SELECT col2 FROM tab1 WHERE + col1 + col0 NOT BETWEEN ( NULL ) AND col1
Exception:
SQLActionException[SQLParseException: line 1:66: no viable alternative at input 'col2']
Query:
SELECT col1 - - CAST ( NULL AS INTEGER ) * + ( - cor0.col0 ) * ( col2 * col1 + CAST ( NULL AS REAL ) ) FROM tab1 AS cor0
Exception:
Expected rows: [-13, -26]. Got []
Query:
SELECT ALL - col1 FROM tab1 AS cor0 WHERE NOT col0 BETWEEN + cor0.col2 AND NULL
Exception:
Expected rows: [729]. Got []
Query:
SELECT DISTINCT + tab2.col2 * col2 AS col0 FROM tab2 WHERE NOT + col1 BETWEEN NULL AND + col0
Exception:
Expected rows: [35, 97, 1, 89, 91, 82]. Got []
Query:
SELECT * FROM tab0 AS cor0 WHERE ( + col2 NOT IN ( + col1 * + col0 ) ) AND col2 + - col1 IN ( - col0 / + col1 + col2 / - col1 ) OR NOT col2 BETWEEN col0 AND ( NULL )
Exception:
Expected rows: [10]. Got []
Query:
SELECT ALL col1 AS col1 FROM tab1 AS cor0 WHERE NOT NULL IN ( cor0.col2 ) OR NOT - col2 BETWEEN NULL AND - col0
Exception:
SQLActionException[SQLParseException: line 1:30: no viable alternative at input '+']
Query:
SELECT DISTINCT + col0 * + ( + cor0.col2 * + CAST ( NULL AS REAL ) ) AS col1 FROM tab1 AS cor0
Exception:
Expected rows: [86]. Got []
Query:
SELECT DISTINCT + col1 FROM tab0 WHERE NOT ( col0 ) BETWEEN ( col2 ) AND ( NULL )
Exception:
Expected rows: [-100, -169, -676]. Got []
Query:
SELECT col1 * - col1 FROM tab1 WHERE NOT col2 * col0 BETWEEN NULL AND col1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment