hash-threshold 8 statement ok CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER) statement ok CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER) statement ok CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER) statement ok INSERT INTO tab0 VALUES(97,1,99) statement ok INSERT INTO tab0 VALUES(15,81,47) statement ok INSERT INTO tab0 VALUES(87,21,10) statement ok INSERT INTO tab1 VALUES(51,14,96) statement ok INSERT INTO tab1 VALUES(85,5,59) statement ok INSERT INTO tab1 VALUES(91,47,68) statement ok INSERT INTO tab2 VALUES(64,77,40) statement ok INSERT INTO tab2 VALUES(75,67,58) statement ok INSERT INTO tab2 VALUES(46,51,23) onlyif mysql # aggregate syntax: query I rowsort label-0 SELECT ALL - COUNT( * ) + + + 30 FROM tab0 AS cor0 ---- 27 skipif mysql # not compatible query I rowsort label-0 SELECT ALL - COUNT ( * ) + + + 30 FROM tab0 AS cor0 ---- 27 query I rowsort SELECT DISTINCT - col2 * - + col2 * + 14 - - col2 FROM tab1 AS cor0 ---- 129120 48793 64804 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-2 SELECT DISTINCT + - col2 + + CAST( - ( + - col1 ) AS SIGNED ) AS col0 FROM tab0 AS cor0 ---- -98 11 34 skipif mysql # not compatible query I rowsort label-2 SELECT DISTINCT + - col2 + + CAST ( - ( + - col1 ) AS INTEGER ) AS col0 FROM tab0 AS cor0 ---- -98 11 34 onlyif mysql # aggregate syntax: query II rowsort label-3 SELECT ALL + ( MAX( col1 ) ) AS col1, - 20 FROM tab0 AS cor0 ---- 81 -20 skipif mysql # not compatible query II rowsort label-3 SELECT ALL + ( MAX ( col1 ) ) AS col1, - 20 FROM tab0 AS cor0 ---- 81 -20 onlyif mysql # aggregate syntax: query I rowsort label-4 SELECT + - MAX( col0 ) FROM tab1 AS cor0 ---- -91 skipif mysql # not compatible query I rowsort label-4 SELECT + - MAX ( col0 ) FROM tab1 AS cor0 ---- -91 query I rowsort SELECT - 32 * + col1 * + col2 FROM tab0 ---- -121824 -3168 -6720 onlyif mysql # aggregate syntax: query II rowsort label-6 SELECT ALL + - SUM( 47 ) AS col1, + 39 * - COUNT( * ) AS col1 FROM tab1 WHERE NULL IS NOT NULL ---- NULL 0 skipif mysql # not compatible query II rowsort label-6 SELECT ALL + - SUM ( 47 ) AS col1, + 39 * - COUNT ( * ) AS col1 FROM tab1 WHERE NULL IS NOT NULL ---- NULL 0 query II rowsort SELECT col1 AS col1, + col2 FROM tab2 ---- 51 23 67 58 77 40 query I rowsort SELECT DISTINCT - ( - 18 ) + col0 AS col2 FROM tab1 ---- 103 109 69 query I rowsort SELECT + col0 * ( - - col2 ) - - + col0 FROM tab1 ---- 4947 5100 6279 query I rowsort SELECT ALL - col1 + + 94 FROM tab0 ---- 13 73 93 onlyif mysql # aggregate syntax: query I rowsort label-11 SELECT DISTINCT + ( 83 ) + + COUNT( * ) - + ( - - ( 98 ) ) AS col2 FROM tab0 ---- -12 skipif mysql # not compatible query I rowsort label-11 SELECT DISTINCT + ( 83 ) + + COUNT ( * ) - + ( - - ( 98 ) ) AS col2 FROM tab0 ---- -12 query I rowsort SELECT DISTINCT col2 + 69 * - + col1 FROM tab2 ---- -3496 -4565 -5273 query II rowsort SELECT - 46 + - col1 AS col1, - col1 FROM tab1 AS cor0 ---- -51 -5 -60 -14 -93 -47 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-14 SELECT - CAST( + + 84 AS SIGNED ) + + 9 FROM tab2 AS cor0 ---- -75 -75 -75 skipif mysql # not compatible query I rowsort label-14 SELECT - CAST ( + + 84 AS INTEGER ) + + 9 FROM tab2 AS cor0 ---- -75 -75 -75 onlyif mysql # aggregate syntax: query I rowsort label-15 SELECT + SUM( 46 ) AS col1 FROM tab0 AS cor0 ---- 138 skipif mysql # not compatible query I rowsort label-15 SELECT + SUM ( 46 ) AS col1 FROM tab0 AS cor0 ---- 138 query I rowsort SELECT DISTINCT 83 + + 7 - - + 67 + + + col2 + + - 37 FROM tab2 ---- 143 160 178 query I rowsort SELECT ALL - col0 AS col0 FROM tab0 WHERE NOT NULL <> + col2 ---- query I rowsort SELECT DISTINCT - ( - 31 ) * - - col2 AS col0 FROM tab2 AS cor0 ---- 1240 1798 713 query III rowsort SELECT * FROM tab2 AS cor0 WHERE NOT ( NULL ) NOT BETWEEN NULL AND - col0 ---- query I rowsort SELECT DISTINCT - col2 + col0 AS col2 FROM tab1 AS cor0 WHERE ( NULL ) IS NULL ---- -45 23 26 onlyif mysql # aggregate syntax: query II rowsort label-21 SELECT DISTINCT COUNT( * ) * + COUNT( * ) + - COUNT( col0 ) + - + 35 col2, + 99 FROM tab1 AS cor0 ---- -29 99 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort label-21 SELECT DISTINCT COUNT ( * ) * + COUNT ( * ) + - COUNT ( col0 ) + - + 35 col2, + 99 FROM tab1 AS cor0 ---- -29 99 query III rowsort SELECT * FROM tab1 cor0 WHERE NOT col2 * + 64 BETWEEN NULL AND NULL ---- query I rowsort SELECT DISTINCT - col1 * - 79 FROM tab0 AS cor0 ---- 1659 6399 79 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-24 SELECT - + 26 * - col1 * - 52 AS col0 FROM tab1 AS cor0 WHERE NOT CAST( NULL AS SIGNED ) IS NOT NULL ---- -18928 -63544 -6760 skipif mysql # not compatible query I rowsort label-24 SELECT - + 26 * - col1 * - 52 AS col0 FROM tab1 AS cor0 WHERE NOT CAST ( NULL AS INTEGER ) IS NOT NULL ---- -18928 -63544 -6760 onlyif mysql # DIV for integer division: query I rowsort label-25 SELECT 50 DIV - col1 FROM tab1 ---- -1 -10 -3 skipif mysql # not compatible query I rowsort label-25 SELECT 50 / - col1 FROM tab1 ---- -1 -10 -3 query I rowsort SELECT - col2 * - ( col1 ) * - 9 - col1 AS col2 FROM tab1 ---- -12110 -2660 -28811 onlyif mysql # aggregate syntax: query I rowsort label-27 SELECT + MAX( 5 ) AS col0 FROM tab2 AS cor0 ---- 5 skipif mysql # not compatible query I rowsort label-27 SELECT + MAX ( 5 ) AS col0 FROM tab2 AS cor0 ---- 5 query I rowsort SELECT DISTINCT col1 AS col0 FROM tab2 WHERE NULL NOT BETWEEN ( + - col2 ) AND NULL ---- query I rowsort SELECT - 24 + + - 98 AS col1 FROM tab0 AS cor0 ---- -122 -122 -122 query I rowsort SELECT DISTINCT + 26 AS col2 FROM tab0 cor0 ---- 26 onlyif mysql # aggregate syntax: query I rowsort label-31 SELECT - + 27 + COUNT( + + 43 ) + + - COUNT( * ) FROM tab2 cor0 ---- -27 skipif mysql # not compatible query I rowsort label-31 SELECT - + 27 + COUNT ( + + 43 ) + + - COUNT ( * ) FROM tab2 cor0 ---- -27 onlyif mysql # aggregate syntax: query I rowsort label-32 SELECT ALL - + SUM( 75 ) AS col0 FROM tab2 AS cor0 ---- -225 skipif mysql # not compatible query I rowsort label-32 SELECT ALL - + SUM ( 75 ) AS col0 FROM tab2 AS cor0 ---- -225 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-33 SELECT col0 * + col1 * + + 83 + + ( - + CAST( NULL AS SIGNED ) ) + + col1 FROM tab2 AS cor0 WHERE + ( col1 ) * 15 / - col2 * - col0 IS NULL ---- skipif mysql # not compatible query I rowsort label-33 SELECT col0 * + col1 * + + 83 + + ( - + CAST ( NULL AS INTEGER ) ) + + col1 FROM tab2 AS cor0 WHERE + ( col1 ) * 15 / - col2 * - col0 IS NULL ---- query I rowsort SELECT + col2 AS col1 FROM tab0 cor0 WHERE + 70 IS NOT NULL ---- 10 47 99 onlyif mysql # aggregate syntax: query I rowsort label-35 SELECT ALL - COUNT( DISTINCT - 32 ) AS col2 FROM tab0 ---- -1 skipif mysql # not compatible query I rowsort label-35 SELECT ALL - COUNT ( DISTINCT - 32 ) AS col2 FROM tab0 ---- -1 onlyif mysql # aggregate syntax: DIV for integer division: query I rowsort label-36 SELECT + 25 DIV ( - COUNT( * ) ) + COUNT( * ) AS col1 FROM tab2 ---- -5 skipif mysql # not compatible query I rowsort label-36 SELECT + 25 / ( - COUNT ( * ) ) + COUNT ( * ) AS col1 FROM tab2 ---- -5 query I rowsort SELECT DISTINCT ( + col0 ) FROM tab1 WHERE - col2 IS NULL ---- query I rowsort SELECT ALL + 73 * + + col0 - + - col2 FROM tab0 ---- 1142 6361 7180 query I rowsort SELECT 90 * - col1 FROM tab2 ---- -4590 -6030 -6930 query I rowsort SELECT ALL - 2 - - col1 AS col0 FROM tab0 ---- -1 19 79 onlyif mysql # aggregate syntax: query I rowsort label-41 SELECT ALL COUNT( ALL col2 ) - 6 * - 99 FROM tab0 ---- 597 skipif mysql # not compatible query I rowsort label-41 SELECT ALL COUNT ( ALL col2 ) - 6 * - 99 FROM tab0 ---- 597 query III rowsort SELECT ALL * FROM tab2 cor0 WHERE NOT NULL >= 45 ---- onlyif mysql # aggregate syntax: query I rowsort label-43 SELECT ALL + - MIN( + col2 ) FROM tab2 AS cor0 ---- -23 skipif mysql # not compatible query I rowsort label-43 SELECT ALL + - MIN ( + col2 ) FROM tab2 AS cor0 ---- -23 query II rowsort SELECT col0, - col0 AS col1 FROM tab2 ---- 46 -46 64 -64 75 -75 query I rowsort SELECT DISTINCT + + 5 AS col2 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1 ---- 5 onlyif mysql # aggregate syntax: query I rowsort label-46 SELECT DISTINCT + + 79 - COUNT( * ) * - 11 FROM tab0 AS cor0 CROSS JOIN tab0 AS cor1 ---- 178 skipif mysql # not compatible query I rowsort label-46 SELECT DISTINCT + + 79 - COUNT ( * ) * - 11 FROM tab0 AS cor0 CROSS JOIN tab0 AS cor1 ---- 178 onlyif mysql # aggregate syntax: query I rowsort label-47 SELECT DISTINCT + + COUNT( * ) FROM tab0 WHERE + col2 IS NOT NULL ---- 3 skipif mysql # not compatible query I rowsort label-47 SELECT DISTINCT + + COUNT ( * ) FROM tab0 WHERE + col2 IS NOT NULL ---- 3 onlyif mysql # aggregate syntax: query I rowsort label-48 SELECT DISTINCT MAX( + 75 ) * + 11 AS col0 FROM tab1 cor0 ---- 825 skipif mysql # not compatible query I rowsort label-48 SELECT DISTINCT MAX ( + 75 ) * + 11 AS col0 FROM tab1 cor0 ---- 825 query I rowsort SELECT + + ( - ( + - 55 ) ) FROM tab0 AS cor0 ---- 55 55 55 query I rowsort SELECT + - ( + - 36 ) AS col1 FROM tab2 AS cor0 ---- 36 36 36 onlyif mysql # aggregate syntax: query I rowsort label-51 SELECT + MIN( - col0 ) * + COUNT( * ) AS col2 FROM tab0 cor0 ---- -291 skipif mysql # not compatible query I rowsort label-51 SELECT + MIN ( - col0 ) * + COUNT ( * ) AS col2 FROM tab0 cor0 ---- -291 query II rowsort SELECT col2 AS col0, - 26 + col1 FROM tab1 AS cor0 ---- 59 -21 68 21 96 -12 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query II rowsort label-53 SELECT - COUNT( * ) * CAST( NULL AS SIGNED ) AS col0, - COUNT( DISTINCT CAST( NULL AS SIGNED ) ) FROM tab1 ---- NULL 0 skipif mysql # not compatible query II rowsort label-53 SELECT - COUNT ( * ) * CAST ( NULL AS INTEGER ) AS col0, - COUNT ( DISTINCT CAST ( NULL AS INTEGER ) ) FROM tab1 ---- NULL 0 query II rowsort SELECT ALL - ( 15 ), col0 FROM tab2 ---- -15 46 -15 64 -15 75 onlyif mysql # aggregate syntax: query I rowsort label-55 SELECT + MIN( ALL + 81 ) AS col0 FROM tab0 ---- 81 skipif mysql # not compatible query I rowsort label-55 SELECT + MIN ( ALL + 81 ) AS col0 FROM tab0 ---- 81 onlyif mysql # aggregate syntax: query I rowsort label-56 SELECT ALL - - COUNT( DISTINCT col0 ) - - MAX( - 61 ) + - - 87 AS col0 FROM tab1 WHERE NOT NULL IS NULL ---- NULL skipif mysql # not compatible query I rowsort label-56 SELECT ALL - - COUNT ( DISTINCT col0 ) - - MAX ( - 61 ) + - - 87 AS col0 FROM tab1 WHERE NOT NULL IS NULL ---- NULL query I rowsort SELECT ALL 52 * - ( + col0 ) * + col2 AS col0 FROM tab0 ---- -36660 -45240 -499356 query III rowsort SELECT DISTINCT * FROM tab0 WHERE NOT col2 + + col0 IS NOT NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-59 SELECT DISTINCT + COUNT( + + col1 ) FROM tab0 ---- 3 skipif mysql # not compatible query I rowsort label-59 SELECT DISTINCT + COUNT ( + + col1 ) FROM tab0 ---- 3 query II rowsort SELECT ALL + - col1 + - col0 AS col1, 5 * + col1 AS col0 FROM tab1 AS cor0 ---- -138 235 -65 70 -90 25 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT - col2 + - 90 col0 FROM tab2 cor0 ---- -113 -130 -148 onlyif mysql # CAST syntax: DECIMAL type: query II rowsort label-62 SELECT - AVG ( ALL - col0 ) + - + CAST( NULL AS DECIMAL ) AS col2, - 48 col1 FROM tab1 ---- NULL -48 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort label-62 SELECT - AVG ( ALL - col0 ) + - + CAST ( NULL AS REAL ) AS col2, - 48 col1 FROM tab1 ---- NULL -48 onlyif mysql # DIV for integer division: query I rowsort label-63 SELECT DISTINCT - 82 DIV col2 * col1 FROM tab0 ---- -168 -81 0 skipif mysql # not compatible query I rowsort label-63 SELECT DISTINCT - 82 / col2 * col1 FROM tab0 ---- -168 -81 0 query I rowsort SELECT DISTINCT - 71 + - col0 FROM tab1 ---- -122 -156 -162 onlyif mysql # aggregate syntax: DIV for integer division: query I rowsort label-65 SELECT ALL - MAX( - col0 ) DIV - 81 AS col1 FROM tab1 AS cor0 ---- 0 skipif mysql # not compatible query I rowsort label-65 SELECT ALL - MAX ( - col0 ) / - 81 AS col1 FROM tab1 AS cor0 ---- 0 query II rowsort SELECT ALL col2, 38 FROM tab1 AS cor0 ---- 59 38 68 38 96 38 onlyif mysql # aggregate syntax: query I rowsort label-67 SELECT + COUNT( * ) * - + 88 AS col1 FROM tab0 AS cor0 ---- -264 skipif mysql # not compatible query I rowsort label-67 SELECT + COUNT ( * ) * - + 88 AS col1 FROM tab0 AS cor0 ---- -264 onlyif mysql # DIV for integer division: query I rowsort label-68 SELECT + ( - col1 ) DIV + col2 FROM tab1 AS cor0 ---- 0 0 0 skipif mysql # not compatible query I rowsort label-68 SELECT + ( - col1 ) / + col2 FROM tab1 AS cor0 ---- 0 0 0 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT col1 * col1 * - - col0 col0 FROM tab0 AS cor0 ---- 38367 97 98415 onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-70 SELECT - - 96, + CAST( NULL AS SIGNED ) * - CAST( NULL AS SIGNED ) AS col0 FROM tab1 AS cor0 ---- 96 NULL 96 NULL 96 NULL skipif mysql # not compatible query II rowsort label-70 SELECT - - 96, + CAST ( NULL AS INTEGER ) * - CAST ( NULL AS INTEGER ) AS col0 FROM tab1 AS cor0 ---- 96 NULL 96 NULL 96 NULL onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-71 SELECT CAST( 24 AS SIGNED ) AS col2 FROM tab0 AS cor0 WHERE + 62 IS NULL ---- skipif mysql # not compatible query I rowsort label-71 SELECT CAST ( 24 AS INTEGER ) AS col2 FROM tab0 AS cor0 WHERE + 62 IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-72 SELECT COUNT( * ) AS col2 FROM tab2 WHERE + col2 NOT BETWEEN - - col0 AND col2 ---- 3 skipif mysql # not compatible query I rowsort label-72 SELECT COUNT ( * ) AS col2 FROM tab2 WHERE + col2 NOT BETWEEN - - col0 AND col2 ---- 3 query I rowsort SELECT DISTINCT - col2 + - - col1 * - - col2 FROM tab2 ---- 1150 3040 3828 onlyif mysql # aggregate syntax: query I rowsort label-74 SELECT DISTINCT 71 + - SUM( + 84 ) col2 FROM tab2 ---- -181 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-74 SELECT DISTINCT 71 + - SUM ( + 84 ) col2 FROM tab2 ---- -181 onlyif mysql # aggregate syntax: query I rowsort label-75 SELECT - 11 + COUNT( * ) AS col0 FROM tab1 ---- -8 skipif mysql # not compatible query I rowsort label-75 SELECT - 11 + COUNT ( * ) AS col0 FROM tab1 ---- -8 onlyif mysql # aggregate syntax: query II rowsort label-76 SELECT DISTINCT COUNT( * ) AS col1, + 27 * 66 FROM tab0, tab2 AS cor0 ---- 9 1782 skipif mysql # not compatible query II rowsort label-76 SELECT DISTINCT COUNT ( * ) AS col1, + 27 * 66 FROM tab0, tab2 AS cor0 ---- 9 1782 onlyif mysql # aggregate syntax: query I rowsort label-77 SELECT + MAX( + ( col1 ) ) AS col0 FROM tab0 AS cor0 ---- 81 skipif mysql # not compatible query I rowsort label-77 SELECT + MAX ( + ( col1 ) ) AS col0 FROM tab0 AS cor0 ---- 81 onlyif mysql # aggregate syntax: query I rowsort label-78 SELECT 85 * + SUM( + col0 ) FROM tab2 AS cor0 ---- 15725 skipif mysql # not compatible query I rowsort label-78 SELECT 85 * + SUM ( + col0 ) FROM tab2 AS cor0 ---- 15725 query I rowsort SELECT 4 * - - col0 FROM tab0 ---- 348 388 60 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-80 SELECT DISTINCT AVG ( ALL - + CAST( NULL AS SIGNED ) ) FROM tab1 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-80 SELECT DISTINCT AVG ( ALL - + CAST ( NULL AS INTEGER ) ) FROM tab1 AS cor0 ---- NULL onlyif mysql # aggregate syntax: query I rowsort label-81 SELECT ALL + MAX( DISTINCT + - col0 ) FROM tab1 AS cor0 ---- -51 skipif mysql # not compatible query I rowsort label-81 SELECT ALL + MAX ( DISTINCT + - col0 ) FROM tab1 AS cor0 ---- -51 onlyif mysql # aggregate syntax: query I rowsort label-82 SELECT DISTINCT + MAX( - 33 ) FROM tab0 AS cor0 ---- -33 skipif mysql # not compatible query I rowsort label-82 SELECT DISTINCT + MAX ( - 33 ) FROM tab0 AS cor0 ---- -33 query I rowsort SELECT DISTINCT - col0 AS col1 FROM tab2 cor0 WHERE NULL IS NULL ---- -46 -64 -75 query I rowsort SELECT DISTINCT col0 + + + 58 AS col2 FROM tab0 ---- 145 155 73 query I rowsort SELECT ALL - col1 + - ( - + col2 ) FROM tab0 ---- -11 -34 98 query I rowsort SELECT DISTINCT - - 81 + + col0 + 35 AS col1 FROM tab1 WHERE NOT + 74 <= + + col2 ---- 201 207 query I rowsort SELECT ALL + - 86 FROM tab1 WHERE NOT - 86 = + col2 / - col1 ---- -86 -86 -86 onlyif mysql # aggregate syntax: query I rowsort label-88 SELECT - 15 + + COUNT( * ) FROM tab2 ---- -12 skipif mysql # not compatible query I rowsort label-88 SELECT - 15 + + COUNT ( * ) FROM tab2 ---- -12 onlyif mysql # aggregate syntax: query I rowsort label-89 SELECT ALL + COUNT( - + col0 ) AS col1 FROM tab0 ---- 3 skipif mysql # not compatible query I rowsort label-89 SELECT ALL + COUNT ( - + col0 ) AS col1 FROM tab0 ---- 3 query III rowsort SELECT ALL * FROM tab2 WHERE NOT + - col2 * - - col2 <> col2 ---- onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-91 SELECT + CAST( NULL AS SIGNED ) * - col2 * - + 65 + + + col0, - 34 AS col1 FROM tab1 AS cor0 ---- NULL -34 NULL -34 NULL -34 skipif mysql # not compatible query II rowsort label-91 SELECT + CAST ( NULL AS INTEGER ) * - col2 * - + 65 + + + col0, - 34 AS col1 FROM tab1 AS cor0 ---- NULL -34 NULL -34 NULL -34 onlyif mysql # aggregate syntax: query I rowsort label-92 SELECT + 94 * + COUNT( * ) AS col0 FROM tab2 AS cor0 ---- 282 skipif mysql # not compatible query I rowsort label-92 SELECT + 94 * + COUNT ( * ) AS col0 FROM tab2 AS cor0 ---- 282 query II rowsort SELECT + col2 AS col0, + col1 * - - col2 FROM tab1 AS cor0 ---- 59 295 68 3196 96 1344 query I rowsort SELECT + col0 + + 98 FROM tab0 ---- 113 185 195 query I rowsort SELECT ( col2 ) + - col2 AS col1 FROM tab1 ---- 0 0 0 query I rowsort SELECT ALL + 27 FROM tab2 AS cor0 CROSS JOIN tab2 AS cor1 ---- 9 values hashing to 701bf12d86392cb1585d9e4f3c72e9a8 onlyif mysql # aggregate syntax: query I rowsort label-97 SELECT + 0 * + + MIN( DISTINCT + + col2 ) + + ( + - ( COUNT( * ) ) ) FROM tab0 AS cor0 ---- -3 skipif mysql # not compatible query I rowsort label-97 SELECT + 0 * + + MIN ( DISTINCT + + col2 ) + + ( + - ( COUNT ( * ) ) ) FROM tab0 AS cor0 ---- -3 query I rowsort SELECT ALL - + 52 - col0 AS col0 FROM tab0 cor0 ---- -139 -149 -67 onlyif mysql # aggregate syntax: query I rowsort label-99 SELECT 31 + MAX( DISTINCT 37 ) col0 FROM tab0 AS cor0 ---- 68 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-99 SELECT 31 + MAX ( DISTINCT 37 ) col0 FROM tab0 AS cor0 ---- 68 onlyif mysql # aggregate syntax: query I rowsort label-100 SELECT ALL - - MIN( ALL 29 ) * COUNT( * ) AS col0 FROM tab1 AS cor0 ---- 87 skipif mysql # not compatible query I rowsort label-100 SELECT ALL - - MIN ( ALL 29 ) * COUNT ( * ) AS col0 FROM tab1 AS cor0 ---- 87 query I rowsort SELECT - 21 * + 50 FROM tab1 ---- -1050 -1050 -1050 onlyif mysql # aggregate syntax: query I rowsort label-102 SELECT DISTINCT 69 + MIN( ALL + col2 ) AS col1 FROM tab1 ---- 128 skipif mysql # not compatible query I rowsort label-102 SELECT DISTINCT 69 + MIN ( ALL + col2 ) AS col1 FROM tab1 ---- 128 onlyif mysql # aggregate syntax: query I rowsort label-103 SELECT ALL + 37 * + COUNT( * ) AS col1 FROM tab1 WHERE NOT col2 NOT BETWEEN - 74 AND - col2 ---- 0 skipif mysql # not compatible query I rowsort label-103 SELECT ALL + 37 * + COUNT ( * ) AS col1 FROM tab1 WHERE NOT col2 NOT BETWEEN - 74 AND - col2 ---- 0 onlyif mysql # aggregate syntax: query I rowsort label-104 SELECT SUM( + 60 ) FROM tab0 ---- 180 skipif mysql # not compatible query I rowsort label-104 SELECT SUM ( + 60 ) FROM tab0 ---- 180 onlyif mysql # DIV for integer division: query I rowsort label-105 SELECT DISTINCT col1 DIV + - col2 FROM tab2 ---- -1 -2 skipif mysql # not compatible query I rowsort label-105 SELECT DISTINCT col1 / + - col2 FROM tab2 ---- -1 -2 onlyif mysql # aggregate syntax: query I rowsort label-106 SELECT SUM( ALL + 90 ) AS col2 FROM tab1 ---- 270 skipif mysql # not compatible query I rowsort label-106 SELECT SUM ( ALL + 90 ) AS col2 FROM tab1 ---- 270 onlyif mysql # aggregate syntax: query I rowsort label-107 SELECT ALL - + COUNT( ALL col0 ) AS col1 FROM tab1 cor0 ---- -3 skipif mysql # not compatible query I rowsort label-107 SELECT ALL - + COUNT ( ALL col0 ) AS col1 FROM tab1 cor0 ---- -3 onlyif mysql # aggregate syntax: query I rowsort label-108 SELECT DISTINCT 93 * COUNT( * ) FROM tab2 AS cor0 ---- 279 skipif mysql # not compatible query I rowsort label-108 SELECT DISTINCT 93 * COUNT ( * ) FROM tab2 AS cor0 ---- 279 query I rowsort SELECT DISTINCT col2 FROM tab0 AS cor0 WHERE NOT ( NULL ) < NULL ---- query I rowsort SELECT DISTINCT - - 56 AS col0 FROM tab2 AS cor0 ---- 56 onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-111 SELECT ALL - CAST( + 1 AS SIGNED ), 97 + + 20 AS col1 FROM tab1 cor0 ---- -1 117 -1 117 -1 117 skipif mysql # not compatible query II rowsort label-111 SELECT ALL - CAST ( + 1 AS INTEGER ), 97 + + 20 AS col1 FROM tab1 cor0 ---- -1 117 -1 117 -1 117 onlyif mysql # aggregate syntax: query I rowsort label-112 SELECT - SUM( col1 ) * 97 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND col1 ---- NULL skipif mysql # not compatible query I rowsort label-112 SELECT - SUM ( col1 ) * 97 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND col1 ---- NULL onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-113 SELECT ALL + - CAST( + + MAX( ALL - + 61 ) AS SIGNED ) FROM tab0 AS cor0 ---- 61 skipif mysql # not compatible query I rowsort label-113 SELECT ALL + - CAST ( + + MAX ( ALL - + 61 ) AS INTEGER ) FROM tab0 AS cor0 ---- 61 query I rowsort SELECT DISTINCT + col2 * - 67 AS col1 FROM tab0 AS cor0 ---- -3149 -6633 -670 query I rowsort SELECT ALL 26 + + + col1 - - ( - + 53 ) - + col2 * 93 * - + 12 FROM tab0 ---- 110458 11154 52506 onlyif mysql # aggregate syntax: query I rowsort label-116 SELECT - SUM( - - 32 ) AS col2 FROM tab0 ---- -96 skipif mysql # not compatible query I rowsort label-116 SELECT - SUM ( - - 32 ) AS col2 FROM tab0 ---- -96 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL + col2 + - ( - col2 ) * + col0 col0 FROM tab0 ---- 752 880 9702 query I rowsort SELECT DISTINCT + col1 + 46 FROM tab2 ---- 113 123 97 onlyif mysql # DIV for integer division: query I rowsort label-119 SELECT ALL + col2 + col1 * 77 DIV col1 FROM tab1 ---- 136 145 173 skipif mysql # not compatible query I rowsort label-119 SELECT ALL + col2 + col1 * 77 / col1 FROM tab1 ---- 136 145 173 onlyif mysql # DIV for integer division: query I rowsort label-120 SELECT + col0 + + + col0 DIV - + col1 FROM tab2 AS cor0 ---- 46 64 74 skipif mysql # not compatible query I rowsort label-120 SELECT + col0 + + + col0 / - + col1 FROM tab2 AS cor0 ---- 46 64 74 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-121 SELECT ALL + + CAST( + COUNT( * ) AS SIGNED ) AS col1 FROM tab1 AS cor0 ---- 3 skipif mysql # not compatible query I rowsort label-121 SELECT ALL + + CAST ( + COUNT ( * ) AS INTEGER ) AS col1 FROM tab1 AS cor0 ---- 3 query I rowsort SELECT col2 + + col2 - + col1 + - + 40 AS col2 FROM tab0 AS cor0 ---- -27 -41 157 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-123 SELECT col1 * + 49 AS col0 FROM tab1 AS cor0 WHERE + CAST( NULL AS SIGNED ) NOT IN ( + col0 * + col0 ) ---- skipif mysql # not compatible query I rowsort label-123 SELECT col1 * + 49 AS col0 FROM tab1 AS cor0 WHERE + CAST ( NULL AS INTEGER ) NOT IN ( + col0 * + col0 ) ---- query I rowsort SELECT DISTINCT ( + 54 ) + + col1 FROM tab1 ---- 101 59 68 query II rowsort SELECT - 71, col2 * - ( + col2 ) AS col1 FROM tab1 WHERE - col1 IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-126 SELECT - MAX( DISTINCT + 62 ) AS col0 FROM tab2 ---- -62 skipif mysql # not compatible query I rowsort label-126 SELECT - MAX ( DISTINCT + 62 ) AS col0 FROM tab2 ---- -62 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-127 SELECT ALL * FROM tab2 AS cor0 WHERE col1 / + CAST( NULL AS SIGNED ) NOT BETWEEN NULL AND + + 81 ---- skipif mysql # not compatible query III rowsort label-127 SELECT ALL * FROM tab2 AS cor0 WHERE col1 / + CAST ( NULL AS INTEGER ) NOT BETWEEN NULL AND + + 81 ---- onlyif mysql # aggregate syntax: DIV for integer division: query I rowsort label-128 SELECT DISTINCT - + COUNT( * ) DIV + - 24 - + 68 col2 FROM tab2 cor0 ---- -68 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-128 SELECT DISTINCT - + COUNT ( * ) / + - 24 - + 68 col2 FROM tab2 cor0 ---- -68 query I rowsort SELECT DISTINCT - col0 * - 63 FROM tab0 AS cor0 ---- 5481 6111 945 onlyif mysql # aggregate syntax: query I rowsort label-130 SELECT - + COUNT( + + col1 ) FROM tab1 AS cor0 ---- -3 skipif mysql # not compatible query I rowsort label-130 SELECT - + COUNT ( + + col1 ) FROM tab1 AS cor0 ---- -3 query I rowsort SELECT ALL col1 - + col0 * + 52 * - col0 FROM tab1 AS cor0 ---- 135266 375705 430659 query I rowsort SELECT DISTINCT + col1 - + + col1 * ( + - col1 ) FROM tab0 AS cor0 ---- 2 462 6642 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-133 SELECT DISTINCT + + CAST( - - 20 AS SIGNED ) * - + 67 col0 FROM tab2 AS cor0 ---- -1340 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-133 SELECT DISTINCT + + CAST ( - - 20 AS INTEGER ) * - + 67 col0 FROM tab2 AS cor0 ---- -1340 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-134 SELECT ALL - CAST( + + 61 AS SIGNED ) + - 36 FROM tab1 AS cor0 ---- -97 -97 -97 skipif mysql # not compatible query I rowsort label-134 SELECT ALL - CAST ( + + 61 AS INTEGER ) + - 36 FROM tab1 AS cor0 ---- -97 -97 -97 query I rowsort SELECT DISTINCT 23 * - 49 * 52 + + 81 FROM tab1 AS cor0 ---- -58523 query I rowsort SELECT ALL - 88 * - col0 * + - col2 AS col0 FROM tab1 AS cor0 ---- -430848 -441320 -544544 skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort SELECT - + 55 col1, - 84 AS col0 FROM tab2 WHERE NOT NULL IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-138 SELECT DISTINCT SUM( - + col1 ) FROM tab2 WHERE NOT + col1 IS NULL ---- -195 skipif mysql # not compatible query I rowsort label-138 SELECT DISTINCT SUM ( - + col1 ) FROM tab2 WHERE NOT + col1 IS NULL ---- -195 onlyif mysql # aggregate syntax: query I rowsort label-139 SELECT ALL SUM( - col0 ) FROM tab1 WHERE NOT col2 IS NOT NULL ---- NULL skipif mysql # not compatible query I rowsort label-139 SELECT ALL SUM ( - col0 ) FROM tab1 WHERE NOT col2 IS NOT NULL ---- NULL query III rowsort SELECT DISTINCT * FROM tab0 AS cor0 WHERE col0 + col2 IS NOT NULL ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: DIV for integer division: query I rowsort label-141 SELECT DISTINCT + COUNT( DISTINCT + col2 ) DIV - ( 69 ) + - - CAST( 9 AS SIGNED ) * + COUNT( * ) FROM tab1 AS cor0 WHERE ( NULL ) IS NOT NULL ---- 0 skipif mysql # not compatible query I rowsort label-141 SELECT DISTINCT + COUNT ( DISTINCT + col2 ) / - ( 69 ) + - - CAST ( 9 AS INTEGER ) * + COUNT ( * ) FROM tab1 AS cor0 WHERE ( NULL ) IS NOT NULL ---- 0 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-142 SELECT ALL + + col0 / - + col2 FROM tab0 AS cor0 WHERE + CAST( NULL AS SIGNED ) NOT IN ( - + CAST( - + 85 AS SIGNED ), + 69 / + + col0 * + 12 * - col0 ) ---- skipif mysql # not compatible query I rowsort label-142 SELECT ALL + + col0 / - + col2 FROM tab0 AS cor0 WHERE + CAST ( NULL AS INTEGER ) NOT IN ( - + CAST ( - + 85 AS INTEGER ), + 69 / + + col0 * + 12 * - col0 ) ---- onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-143 SELECT ALL 70 * - + CAST( - - COUNT( * ) AS SIGNED ) FROM tab0, tab1 AS cor0 ---- -630 skipif mysql # not compatible query I rowsort label-143 SELECT ALL 70 * - + CAST ( - - COUNT ( * ) AS INTEGER ) FROM tab0, tab1 AS cor0 ---- -630 onlyif mysql # DIV for integer division: query I rowsort label-144 SELECT col2 DIV 3 * - 36 FROM tab1 ---- -1152 -684 -792 skipif mysql # not compatible query I rowsort label-144 SELECT col2 / 3 * - 36 FROM tab1 ---- -1152 -684 -792 query III rowsort SELECT * FROM tab2 AS cor0 WHERE NULL IS NOT NULL OR - 56 + + 21 IS NOT NULL ---- 9 values hashing to 75c998aa53ac83218cbf2feb962d0a49 query III rowsort SELECT * FROM tab0 AS cor0 WHERE NOT col2 + - - ( + col2 ) + col2 + - col0 / - col0 + + col1 = col0 + + col1 * + col2 ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-147 SELECT DISTINCT - CAST( NULL AS SIGNED ) + - CAST( COUNT( col2 ) AS SIGNED ) - COUNT( * ) AS col1 FROM tab0 cor0 ---- NULL skipif mysql # not compatible query I rowsort label-147 SELECT DISTINCT - CAST ( NULL AS INTEGER ) + - CAST ( COUNT ( col2 ) AS INTEGER ) - COUNT ( * ) AS col1 FROM tab0 cor0 ---- NULL onlyif mysql # DIV for integer division: query I rowsort label-148 SELECT DISTINCT col1 + col2 DIV + col0 AS col2 FROM tab2 ---- 51 67 77 skipif mysql # not compatible query I rowsort label-148 SELECT DISTINCT col1 + col2 / + col0 AS col2 FROM tab2 ---- 51 67 77 onlyif mysql # aggregate syntax: query I rowsort label-149 SELECT DISTINCT + 32 + - COUNT( DISTINCT - 70 ) FROM tab1 ---- 31 skipif mysql # not compatible query I rowsort label-149 SELECT DISTINCT + 32 + - COUNT ( DISTINCT - 70 ) FROM tab1 ---- 31 query II rowsort SELECT col0 * - col2, + col0 * col1 AS col2 FROM tab0 ---- -705 1215 -870 1827 -9603 97 onlyif mysql # aggregate syntax: query I rowsort label-151 SELECT ALL - 64 + + MAX( ALL 26 ) FROM tab0 ---- -38 skipif mysql # not compatible query I rowsort label-151 SELECT ALL - 64 + + MAX ( ALL 26 ) FROM tab0 ---- -38 onlyif mysql # aggregate syntax: DIV for integer division: query I rowsort label-152 SELECT COUNT( * ) DIV - 91 * + 90 FROM tab2 ---- 0 skipif mysql # not compatible query I rowsort label-152 SELECT COUNT ( * ) / - 91 * + 90 FROM tab2 ---- 0 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-153 SELECT DISTINCT + CAST( NULL AS SIGNED ) * - 98 AS col2 FROM tab2 ---- NULL skipif mysql # not compatible query I rowsort label-153 SELECT DISTINCT + CAST ( NULL AS INTEGER ) * - 98 AS col2 FROM tab2 ---- NULL onlyif mysql # aggregate syntax: query I rowsort label-154 SELECT 88 * COUNT( * ) FROM tab1 ---- 264 skipif mysql # not compatible query I rowsort label-154 SELECT 88 * COUNT ( * ) FROM tab1 ---- 264 query III rowsort SELECT * FROM tab2 AS cor0 WHERE ( NULL ) BETWEEN NULL AND - col1 ---- query I rowsort SELECT + col2 + - 48 FROM tab0 ---- -1 -38 51 query III rowsort SELECT * FROM tab2 WHERE - + col1 > + col2 ---- query I rowsort SELECT DISTINCT - col0 - + + 43 FROM tab0 WHERE NOT 51 IS NULL OR NOT 4 NOT BETWEEN - + 45 AND NULL ---- -130 -140 -58 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-159 SELECT DISTINCT + CAST( NULL AS SIGNED ) * + + col1 AS col2 FROM tab1 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-159 SELECT DISTINCT + CAST ( NULL AS INTEGER ) * + + col1 AS col2 FROM tab1 AS cor0 ---- NULL query I rowsort SELECT DISTINCT - 94 - + ( col1 ) - - 0 AS col1 FROM tab2 AS cor0 ---- -145 -161 -171 onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-161 SELECT DISTINCT CAST( NULL AS SIGNED ), col1 AS col2 FROM tab0 AS cor0 ---- NULL 1 NULL 21 NULL 81 skipif mysql # not compatible query II rowsort label-161 SELECT DISTINCT CAST ( NULL AS INTEGER ), col1 AS col2 FROM tab0 AS cor0 ---- NULL 1 NULL 21 NULL 81 query III rowsort SELECT DISTINCT * FROM tab1 AS cor0 WHERE - col1 + - - col1 IN ( - - col2, col2, col2 + col0, - - 39 ) ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL - - 82 col2 FROM tab1 AS cor0 ---- 82 82 82 onlyif mysql # aggregate syntax: query I rowsort label-164 SELECT ALL + - MAX( ALL 91 ) AS col1 FROM tab2 AS cor0 ---- -91 skipif mysql # not compatible query I rowsort label-164 SELECT ALL + - MAX ( ALL 91 ) AS col1 FROM tab2 AS cor0 ---- -91 query I rowsort SELECT DISTINCT - - ( + col2 ) * - + col2 * - col0 * - + 64 + 27 AS col2 FROM tab0 AS cor0 ---- -2120613 -556773 -60844581 query I rowsort SELECT + 58 * - - col0 FROM tab1 cor0 ---- 2958 4930 5278 onlyif mysql # DIV for integer division: query I rowsort label-167 SELECT - + 16 DIV + col0 FROM tab2 AS cor0 ---- 0 0 0 skipif mysql # not compatible query I rowsort label-167 SELECT - + 16 / + col0 FROM tab2 AS cor0 ---- 0 0 0 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-168 SELECT - col2, + 38 AS col1, col1 + + CAST( NULL AS SIGNED ) AS col0 FROM tab0 ---- 9 values hashing to 602b53657ce743479e7fd731d12d5ae5 skipif mysql # not compatible query III rowsort label-168 SELECT - col2, + 38 AS col1, col1 + + CAST ( NULL AS INTEGER ) AS col0 FROM tab0 ---- 9 values hashing to 602b53657ce743479e7fd731d12d5ae5 query I rowsort SELECT DISTINCT + col0 * + 93 AS col2 FROM tab1 ---- 4743 7905 8463 query II rowsort SELECT + col0 AS col2, + col0 * + - col1 AS col0 FROM tab0 ---- 15 -1215 87 -1827 97 -97 query I rowsort SELECT 12 * col2 AS col0 FROM tab2 ---- 276 480 696 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-172 SELECT DISTINCT + + col1 AS col0 FROM tab1 WHERE + 86 / - col2 NOT IN ( - col1 + 7, + col1, + - CAST( - + col1 AS SIGNED ) ) ---- 14 47 5 skipif mysql # not compatible query I rowsort label-172 SELECT DISTINCT + + col1 AS col0 FROM tab1 WHERE + 86 / - col2 NOT IN ( - col1 + 7, + col1, + - CAST ( - + col1 AS INTEGER ) ) ---- 14 47 5 query II rowsort SELECT ALL + col0, col2 * - ( 42 ) * - + 39 FROM tab2 ---- 46 37674 64 65520 75 95004 skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort SELECT col0 AS col0, 79 col2 FROM tab1 ---- 51 79 85 79 91 79 query III rowsort SELECT * FROM tab1 cor0 WHERE NOT NULL NOT BETWEEN NULL AND + col0 ---- query III rowsort SELECT * FROM tab1 cor0 WHERE NOT col0 <= NULL ---- onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-177 SELECT ALL CAST( + 61 AS SIGNED ) * + - col2 AS col0 FROM tab2 cor0 ---- -1403 -2440 -3538 skipif mysql # not compatible query I rowsort label-177 SELECT ALL CAST ( + 61 AS INTEGER ) * + - col2 AS col0 FROM tab2 cor0 ---- -1403 -2440 -3538 query I rowsort SELECT - ( + - 90 ) AS col2 FROM tab0 AS cor0 ---- 90 90 90 onlyif mysql # DIV for integer division: query I rowsort label-179 SELECT DISTINCT + 61 DIV - + 69 FROM tab1 AS cor0 ---- 0 skipif mysql # not compatible query I rowsort label-179 SELECT DISTINCT + 61 / - + 69 FROM tab1 AS cor0 ---- 0 query I rowsort SELECT ALL + - ( 95 ) AS col2 FROM tab0 AS cor0 ---- -95 -95 -95 query II rowsort SELECT + + col1, 5 FROM tab1 AS cor0 ---- 14 5 47 5 5 5 query I rowsort SELECT col0 FROM tab1 AS cor0 WHERE - col2 NOT IN ( + col0 + col1 + - 55 + - col0 ) ---- 51 85 91 query III rowsort SELECT ALL * FROM tab2 AS cor0 WHERE 9 / col0 IS NULL ---- query I rowsort SELECT - col2 * - - 43 FROM tab0 AS cor0 ---- -2021 -4257 -430 query III rowsort SELECT ALL * FROM tab1 AS cor0 WHERE + 77 IS NULL ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort SELECT + 39 AS col2, col1 - 51 col2 FROM tab2 ---- 39 0 39 16 39 26 query I rowsort SELECT DISTINCT + col0 + - 13 + - col1 + col0 AS col1 FROM tab2 ---- 28 38 70 onlyif mysql # aggregate syntax: query I rowsort label-188 SELECT DISTINCT COUNT( * ) + - - ( + 37 ) AS col2 FROM tab2 ---- 40 skipif mysql # not compatible query I rowsort label-188 SELECT DISTINCT COUNT ( * ) + - - ( + 37 ) AS col2 FROM tab2 ---- 40 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-189 SELECT ALL 46 + ( - CAST( NULL AS SIGNED ) ) FROM tab1 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-189 SELECT ALL 46 + ( - CAST ( NULL AS INTEGER ) ) FROM tab1 ---- NULL NULL NULL query III rowsort SELECT ALL * FROM tab1 WHERE NOT - 15 IS NOT NULL ---- query III rowsort SELECT * FROM tab1 WHERE col1 / col2 NOT BETWEEN ( NULL ) AND NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-192 SELECT DISTINCT - 57 - - MIN( ALL + - 15 ) AS col2 FROM tab2 AS cor0 ---- -72 skipif mysql # not compatible query I rowsort label-192 SELECT DISTINCT - 57 - - MIN ( ALL + - 15 ) AS col2 FROM tab2 AS cor0 ---- -72 query I rowsort SELECT - col1 + + + col2 FROM tab1 cor0 ---- 21 54 82 query III rowsort SELECT DISTINCT * FROM tab1 cor0 WHERE NOT col2 + - 35 IS NULL ---- 9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad onlyif mysql # DIV for integer division: query I rowsort label-195 SELECT DISTINCT - 33 DIV - + 65 * + - 29 * - col1 AS col0 FROM tab0 AS cor0 ---- 0 skipif mysql # not compatible query I rowsort label-195 SELECT DISTINCT - 33 / - + 65 * + - 29 * - col1 AS col0 FROM tab0 AS cor0 ---- 0 query I rowsort SELECT + 37 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1 ---- 9 values hashing to a10b03e72860b949bdff53827700a9a8 query II rowsort SELECT 41 + - col2, - 12 AS col2 FROM tab2 AS cor0 WHERE NOT ( NULL ) NOT BETWEEN NULL AND NULL ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT - - 63 col2 FROM tab1 AS cor0 ---- 63 63 63 onlyif mysql # aggregate syntax: query I rowsort label-199 SELECT DISTINCT - MIN( - 98 ) AS col2 FROM tab0 AS cor0 ---- 98 skipif mysql # not compatible query I rowsort label-199 SELECT DISTINCT - MIN ( - 98 ) AS col2 FROM tab0 AS cor0 ---- 98 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT DISTINCT - + 66 col0 FROM tab2 AS cor0 ---- -66 query III rowsort SELECT * FROM tab0 WHERE NOT + 54 BETWEEN + 77 AND + - col1 ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 query II rowsort SELECT DISTINCT col0 AS col1, - 43 * - - col2 FROM tab1 ---- 51 -4128 85 -2537 91 -2924 onlyif mysql # aggregate syntax: query I rowsort label-203 SELECT ALL + MAX( DISTINCT - col1 ) FROM tab0 ---- -1 skipif mysql # not compatible query I rowsort label-203 SELECT ALL + MAX ( DISTINCT - col1 ) FROM tab0 ---- -1 onlyif mysql # DIV for integer division: query I rowsort label-204 SELECT + 5 DIV 19 AS col1 FROM tab2 ---- 0 0 0 skipif mysql # not compatible query I rowsort label-204 SELECT + 5 / 19 AS col1 FROM tab2 ---- 0 0 0 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-205 SELECT 82 * + col0 * + CAST( + col1 AS SIGNED ) AS col1 FROM tab0 ---- 149814 7954 99630 skipif mysql # not compatible query I rowsort label-205 SELECT 82 * + col0 * + CAST ( + col1 AS INTEGER ) AS col1 FROM tab0 ---- 149814 7954 99630 query I rowsort SELECT DISTINCT - - 45 AS col2 FROM tab0 AS cor0 ---- 45 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query II rowsort label-207 SELECT 56 col1, - MIN( + - CAST( NULL AS SIGNED ) ) AS col2 FROM tab1 ---- 56 NULL skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort label-207 SELECT 56 col1, - MIN ( + - CAST ( NULL AS INTEGER ) ) AS col2 FROM tab1 ---- 56 NULL onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-208 SELECT col0 * - 4 * + + CAST( NULL AS SIGNED ) AS col1 FROM tab2 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-208 SELECT col0 * - 4 * + + CAST ( NULL AS INTEGER ) AS col1 FROM tab2 ---- NULL NULL NULL onlyif mysql # DIV for integer division: query I rowsort label-209 SELECT - 45 DIV + 58 AS col2 FROM tab1 ---- 0 0 0 skipif mysql # not compatible query I rowsort label-209 SELECT - 45 / + 58 AS col2 FROM tab1 ---- 0 0 0 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-210 SELECT DISTINCT + ( + - CAST( NULL AS SIGNED ) ) AS col2 FROM tab1 ---- NULL skipif mysql # not compatible query I rowsort label-210 SELECT DISTINCT + ( + - CAST ( NULL AS INTEGER ) ) AS col2 FROM tab1 ---- NULL query III rowsort SELECT ALL * FROM tab2 AS cor0 WHERE NOT 18 BETWEEN col1 AND NULL ---- 9 values hashing to 75c998aa53ac83218cbf2feb962d0a49 query I rowsort SELECT - col2 + + + col1 AS col1 FROM tab1 AS cor0 ---- -21 -54 -82 query I rowsort SELECT ( - + 55 ) + + col0 FROM tab2 AS cor0 ---- -9 20 9 onlyif mysql # aggregate syntax: query I rowsort label-214 SELECT - + 45 * COUNT( * ) + SUM( col1 ) FROM tab0 AS cor0 ---- -32 skipif mysql # not compatible query I rowsort label-214 SELECT - + 45 * COUNT ( * ) + SUM ( col1 ) FROM tab0 AS cor0 ---- -32 onlyif mysql # DIV for integer division: query I rowsort label-215 SELECT ALL + + col1 DIV col0 + + 1 AS col0 FROM tab1 cor0 ---- 1 1 1 skipif mysql # not compatible query I rowsort label-215 SELECT ALL + + col1 / col0 + + 1 AS col0 FROM tab1 cor0 ---- 1 1 1 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-216 SELECT DISTINCT * FROM tab1 AS cor0 WHERE NOT 9 + - - 33 * + + CAST( NULL AS SIGNED ) * + col0 * - col0 / col1 NOT BETWEEN + col2 AND col2 ---- skipif mysql # not compatible query III rowsort label-216 SELECT DISTINCT * FROM tab1 AS cor0 WHERE NOT 9 + - - 33 * + + CAST ( NULL AS INTEGER ) * + col0 * - col0 / col1 NOT BETWEEN + col2 AND col2 ---- onlyif mysql # aggregate syntax: query I rowsort label-217 SELECT DISTINCT + ( COUNT( DISTINCT + + col0 ) ) + - SUM( + - col0 ) AS col0 FROM tab1 ---- 230 skipif mysql # not compatible query I rowsort label-217 SELECT DISTINCT + ( COUNT ( DISTINCT + + col0 ) ) + - SUM ( + - col0 ) AS col0 FROM tab1 ---- 230 query I rowsort SELECT DISTINCT col0 + + col2 + + col2 FROM tab2 ---- 144 191 92 query I rowsort SELECT DISTINCT + 89 - - + ( - + 59 ) FROM tab1 AS cor0 ---- 30 onlyif mysql # aggregate syntax: query I rowsort label-220 SELECT SUM( + 92 ) FROM tab0 AS cor0 ---- 276 skipif mysql # not compatible query I rowsort label-220 SELECT SUM ( + 92 ) FROM tab0 AS cor0 ---- 276 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-221 SELECT ALL + CAST( + + col2 AS SIGNED ) - - + col0 FROM tab2 AS cor0 ---- 104 133 69 skipif mysql # not compatible query I rowsort label-221 SELECT ALL + CAST ( + + col2 AS INTEGER ) - - + col0 FROM tab2 AS cor0 ---- 104 133 69 query I rowsort SELECT ALL + ( - + col0 ) FROM tab1 cor0 ---- -51 -85 -91 query III rowsort SELECT DISTINCT * FROM tab2 AS cor0 WHERE NOT col0 / + col1 + + col0 IS NULL ---- 9 values hashing to 75c998aa53ac83218cbf2feb962d0a49 onlyif mysql # aggregate syntax: query I rowsort label-224 SELECT DISTINCT SUM( + + ( + col1 ) ) AS col1 FROM tab0 cor0 ---- 103 skipif mysql # not compatible query I rowsort label-224 SELECT DISTINCT SUM ( + + ( + col1 ) ) AS col1 FROM tab0 cor0 ---- 103 onlyif mysql # aggregate syntax: query II rowsort label-225 SELECT ALL - COUNT( * ) AS col1, COUNT( + + col2 ) FROM tab1 AS cor0 ---- -3 3 skipif mysql # not compatible query II rowsort label-225 SELECT ALL - COUNT ( * ) AS col1, COUNT ( + + col2 ) FROM tab1 AS cor0 ---- -3 3 query I rowsort SELECT DISTINCT - col2 FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NOT NULL ---- -23 -40 -58 onlyif mysql # aggregate syntax: query I rowsort label-227 SELECT ALL SUM( ALL + 38 ) FROM tab2 cor0 ---- 114 skipif mysql # not compatible query I rowsort label-227 SELECT ALL SUM ( ALL + 38 ) FROM tab2 cor0 ---- 114 query III rowsort SELECT ALL * FROM tab1 AS cor0 WHERE NOT col0 * col2 * - col2 IS NOT NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-229 SELECT ALL - + COUNT( + - 65 ) AS col0 FROM tab1 AS cor0 ---- -3 skipif mysql # not compatible query I rowsort label-229 SELECT ALL - + COUNT ( + - 65 ) AS col0 FROM tab1 AS cor0 ---- -3 query I rowsort SELECT ( + col1 ) * + 37 FROM tab1 ---- 1739 185 518 query I rowsort SELECT - col1 * 77 AS col0 FROM tab2 ---- -3927 -5159 -5929 query I rowsort SELECT + + col0 FROM tab1 WHERE NOT col2 * - col2 IS NOT NULL ---- query I rowsort SELECT ALL - + col2 AS col0 FROM tab0 AS cor0 WHERE + 2 IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-234 SELECT - - COUNT( ALL + col2 ) + + 99 FROM tab2 AS cor0 ---- 102 skipif mysql # not compatible query I rowsort label-234 SELECT - - COUNT ( ALL + col2 ) + + 99 FROM tab2 AS cor0 ---- 102 query I rowsort SELECT ALL + col0 + + 77 AS col1 FROM tab2 AS cor0 ---- 123 141 152 query I rowsort SELECT DISTINCT 58 AS col2 FROM tab1 AS cor0 WHERE ( NULL ) <> - 46 ---- query I rowsort SELECT - col2 AS col0 FROM tab1 AS cor0 WHERE + col0 IS NOT NULL ---- -59 -68 -96 query I rowsort SELECT 31 * - + ( + 99 ) AS col2 FROM tab2 cor0 ---- -3069 -3069 -3069 query I rowsort SELECT - col2 * + + 42 AS col1 FROM tab1 AS cor0 ---- -2478 -2856 -4032 query III rowsort SELECT DISTINCT * FROM tab0 AS cor0 WHERE NOT 13 IS NOT NULL ---- onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-241 SELECT + CAST( NULL AS SIGNED ) * + 20 AS col1 FROM tab0 AS cor0 WHERE NULL IS NOT NULL ---- skipif mysql # not compatible query I rowsort label-241 SELECT + CAST ( NULL AS INTEGER ) * + 20 AS col1 FROM tab0 AS cor0 WHERE NULL IS NOT NULL ---- onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-242 SELECT ALL - - 38, CAST( col2 AS SIGNED ) AS col2 FROM tab2 AS cor0 ---- 38 23 38 40 38 58 skipif mysql # not compatible query II rowsort label-242 SELECT ALL - - 38, CAST ( col2 AS INTEGER ) AS col2 FROM tab2 AS cor0 ---- 38 23 38 40 38 58 query III rowsort SELECT * FROM tab0 AS cor0 WHERE NULL = - ( + col0 ) ---- onlyif mysql # aggregate syntax: query I rowsort label-244 SELECT DISTINCT - COUNT( * ) + 66 FROM tab0 AS cor0 ---- 63 skipif mysql # not compatible query I rowsort label-244 SELECT DISTINCT - COUNT ( * ) + 66 FROM tab0 AS cor0 ---- 63 onlyif mysql # aggregate syntax: query I rowsort label-245 SELECT DISTINCT - COUNT( - col0 ) + 34 AS col2 FROM tab2 ---- 31 skipif mysql # not compatible query I rowsort label-245 SELECT DISTINCT - COUNT ( - col0 ) + 34 AS col2 FROM tab2 ---- 31 onlyif mysql # CAST syntax: SIGNED type: DIV for integer division: query I rowsort label-246 SELECT ALL 42 DIV col2 + + CAST( 42 AS SIGNED ) AS col2 FROM tab0 ---- 42 42 46 skipif mysql # not compatible query I rowsort label-246 SELECT ALL 42 / col2 + + CAST ( 42 AS INTEGER ) AS col2 FROM tab0 ---- 42 42 46 query III rowsort SELECT ALL * FROM tab2 WHERE NOT NULL IS NULL AND NULL IS NOT NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-248 SELECT ALL SUM( - col1 ) FROM tab2 WHERE - + 8 + + col2 IS NOT NULL ---- -195 skipif mysql # not compatible query I rowsort label-248 SELECT ALL SUM ( - col1 ) FROM tab2 WHERE - + 8 + + col2 IS NOT NULL ---- -195 query I rowsort SELECT + 81 + + 86 FROM tab2 AS cor0 ---- 167 167 167 onlyif mysql # DIV for integer division: query II rowsort label-250 SELECT DISTINCT - col0, - col1 DIV col0 * + col1 AS col1 FROM tab1 AS cor0 ---- -51 0 -85 0 -91 0 skipif mysql # not compatible query II rowsort label-250 SELECT DISTINCT - col0, - col1 / col0 * + col1 AS col1 FROM tab1 AS cor0 ---- -51 0 -85 0 -91 0 onlyif mysql # aggregate syntax: query I rowsort label-251 SELECT ALL + + 34 * - + 64 + + - COUNT( * ) AS col0 FROM tab2 AS cor0 ---- -2179 skipif mysql # not compatible query I rowsort label-251 SELECT ALL + + 34 * - + 64 + + - COUNT ( * ) AS col0 FROM tab2 AS cor0 ---- -2179 onlyif mysql # aggregate syntax: query I rowsort label-252 SELECT + - MAX( + col1 ) * 12 FROM tab2 AS cor0 ---- -924 skipif mysql # not compatible query I rowsort label-252 SELECT + - MAX ( + col1 ) * 12 FROM tab2 AS cor0 ---- -924 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-253 SELECT ALL SUM( ALL - CAST( - - ( + + col0 ) AS SIGNED ) ) AS col1 FROM tab0 ---- -199 skipif mysql # not compatible query I rowsort label-253 SELECT ALL SUM ( ALL - CAST ( - - ( + + col0 ) AS INTEGER ) ) AS col1 FROM tab0 ---- -199 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-254 SELECT * FROM tab0 AS cor0 WHERE NOT 64 * + CAST( NULL AS SIGNED ) <= col2 ---- skipif mysql # not compatible query III rowsort label-254 SELECT * FROM tab0 AS cor0 WHERE NOT 64 * + CAST ( NULL AS INTEGER ) <= col2 ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT - - 61 col0 FROM tab2 AS cor0 ---- 61 61 61 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-256 SELECT DISTINCT * FROM tab2 AS cor0 WHERE col0 * + CAST( NULL AS SIGNED ) <> 93 ---- skipif mysql # not compatible query III rowsort label-256 SELECT DISTINCT * FROM tab2 AS cor0 WHERE col0 * + CAST ( NULL AS INTEGER ) <> 93 ---- onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-257 SELECT - 58 * + col2 + CAST( NULL AS SIGNED ) col1 FROM tab0 ---- NULL NULL NULL skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-257 SELECT - 58 * + col2 + CAST ( NULL AS INTEGER ) col1 FROM tab0 ---- NULL NULL NULL query I rowsort SELECT DISTINCT - 40 * + - col1 FROM tab2 WHERE NOT NULL IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-259 SELECT ( ( + - 87 ) ) * + - MIN( - col2 ) FROM tab2 ---- -5046 skipif mysql # not compatible query I rowsort label-259 SELECT ( ( + - 87 ) ) * + - MIN ( - col2 ) FROM tab2 ---- -5046 onlyif mysql # aggregate syntax: query I rowsort label-260 SELECT DISTINCT + - COUNT( ALL - col1 ) AS col2 FROM tab1 AS cor0 ---- -3 skipif mysql # not compatible query I rowsort label-260 SELECT DISTINCT + - COUNT ( ALL - col1 ) AS col2 FROM tab1 AS cor0 ---- -3 query I rowsort SELECT DISTINCT + ( col2 ) + - - col1 - col0 * - + col1 AS col1 FROM tab1 AS cor0 WHERE NOT NULL < col2 ---- onlyif mysql # aggregate syntax: query I rowsort label-262 SELECT MIN( - col2 ) col1 FROM tab0 AS cor0 ---- -99 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-262 SELECT MIN ( - col2 ) col1 FROM tab0 AS cor0 ---- -99 query I rowsort SELECT ALL - + ( - 11 ) FROM tab0 cor0 ---- 11 11 11 query I rowsort SELECT + - col0 AS col1 FROM tab0 AS cor0 WHERE NULL NOT BETWEEN NULL AND col1 ---- query I rowsort SELECT ALL 25 * col1 AS col2 FROM tab2 ---- 1275 1675 1925 query I rowsort SELECT ALL - 78 * 48 FROM tab2 ---- -3744 -3744 -3744 onlyif mysql # aggregate syntax: query I rowsort label-267 SELECT DISTINCT 14 * - SUM( ALL ( + col1 ) ) col1 FROM tab1 ---- -924 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-267 SELECT DISTINCT 14 * - SUM ( ALL ( + col1 ) ) col1 FROM tab1 ---- -924 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT DISTINCT - 19 * col2 col0 FROM tab1 ---- -1121 -1292 -1824 onlyif mysql # aggregate syntax: query I rowsort label-269 SELECT - MIN( col2 ) FROM tab1 WHERE NOT col2 IN ( + col1 ) ---- -59 skipif mysql # not compatible query I rowsort label-269 SELECT - MIN ( col2 ) FROM tab1 WHERE NOT col2 IN ( + col1 ) ---- -59 query III rowsort SELECT * FROM tab1 WHERE ( NULL ) BETWEEN NULL AND + col1 * - col2 ---- query III rowsort SELECT * FROM tab2 WHERE ( NULL ) NOT BETWEEN NULL AND - col2 ---- onlyif mysql # aggregate syntax: query I rowsort label-272 SELECT DISTINCT COUNT( * ) * + 67 AS col2 FROM tab2 ---- 201 skipif mysql # not compatible query I rowsort label-272 SELECT DISTINCT COUNT ( * ) * + 67 AS col2 FROM tab2 ---- 201 query III rowsort SELECT DISTINCT * FROM tab1 WHERE ( + 39 ) >= NULL ---- query I rowsort SELECT DISTINCT col1 AS col0 FROM tab2 WHERE + col0 * col1 IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-275 SELECT COUNT( * ) * + COUNT( ALL ( + col2 ) ) AS col1 FROM tab2 ---- 9 skipif mysql # not compatible query I rowsort label-275 SELECT COUNT ( * ) * + COUNT ( ALL ( + col2 ) ) AS col1 FROM tab2 ---- 9 query III rowsort SELECT DISTINCT * FROM tab0 WHERE ( col1 ) NOT BETWEEN + 44 AND + col1 + + 11 ---- 87 21 10 97 1 99 query I rowsort SELECT DISTINCT + ( col2 ) * - col0 + col0 FROM tab2 ---- -1012 -2496 -4275 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-278 SELECT ALL * FROM tab2 WHERE NOT ( NULL ) NOT BETWEEN + CAST( NULL AS SIGNED ) AND col0 ---- skipif mysql # not compatible query III rowsort label-278 SELECT ALL * FROM tab2 WHERE NOT ( NULL ) NOT BETWEEN + CAST ( NULL AS INTEGER ) AND col0 ---- onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-279 SELECT DISTINCT * FROM tab1 WHERE NOT ( NULL ) NOT IN ( + CAST( - 31 AS SIGNED ) * + 33 ) ---- skipif mysql # not compatible query III rowsort label-279 SELECT DISTINCT * FROM tab1 WHERE NOT ( NULL ) NOT IN ( + CAST ( - 31 AS INTEGER ) * + 33 ) ---- query I rowsort SELECT ( 83 ) AS col2 FROM tab0 WHERE NOT NULL <= ( - col1 ) ---- query I rowsort SELECT DISTINCT - col0 + 19 AS col0 FROM tab0 WHERE NOT - col1 - col1 * col2 <> - 44 ---- query I rowsort SELECT 37 * 73 FROM tab2 WHERE ( NULL ) < + ( col1 ) ---- onlyif mysql # aggregate syntax: DIV for integer division: query I rowsort label-283 SELECT + ( + MIN( ALL + col0 ) ) + COUNT( * ) DIV - ( COUNT( * ) ) FROM tab0 ---- 14 skipif mysql # not compatible query I rowsort label-283 SELECT + ( + MIN ( ALL + col0 ) ) + COUNT ( * ) / - ( COUNT ( * ) ) FROM tab0 ---- 14 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-284 SELECT + 6 / CAST( NULL AS SIGNED ) col2 FROM tab1 ---- NULL NULL NULL skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-284 SELECT + 6 / CAST ( NULL AS INTEGER ) col2 FROM tab1 ---- NULL NULL NULL query III rowsort SELECT * FROM tab0 WHERE 88 * 50 NOT IN ( - ( + col0 ) ) ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-286 SELECT COUNT( * ) + COUNT( * ) AS col0 FROM tab0 AS cor0 WHERE NOT + 39 + CAST( col1 AS SIGNED ) IN ( col0 - col2 ) ---- 6 skipif mysql # not compatible query I rowsort label-286 SELECT COUNT ( * ) + COUNT ( * ) AS col0 FROM tab0 AS cor0 WHERE NOT + 39 + CAST ( col1 AS INTEGER ) IN ( col0 - col2 ) ---- 6 query I rowsort SELECT ALL col0 FROM tab0 AS cor0 WHERE NOT ( - col2 * + col0 ) IS NULL ---- 15 87 97 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-288 SELECT + col1 * + CAST( CAST( NULL AS SIGNED ) / + ( - 38 / col2 ) AS SIGNED ) FROM tab2 AS cor0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-288 SELECT + col1 * + CAST ( CAST ( NULL AS INTEGER ) / + ( - 38 / col2 ) AS INTEGER ) FROM tab2 AS cor0 ---- NULL NULL NULL query III rowsort SELECT DISTINCT * FROM tab2 AS cor0 WHERE NOT + col2 + col1 IS NOT NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-290 SELECT ALL - 87 * + COUNT( * ) FROM tab1 ---- -261 skipif mysql # not compatible query I rowsort label-290 SELECT ALL - 87 * + COUNT ( * ) FROM tab1 ---- -261 onlyif mysql # aggregate syntax: query I rowsort label-291 SELECT MIN( DISTINCT 39 ) FROM tab0 AS cor0 WHERE NOT NULL <> NULL ---- NULL skipif mysql # not compatible query I rowsort label-291 SELECT MIN ( DISTINCT 39 ) FROM tab0 AS cor0 WHERE NOT NULL <> NULL ---- NULL skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL 87 col1 FROM tab0 AS cor0 WHERE + 44 * col0 IS NULL ---- query I rowsort SELECT col2 * col2 + ( 32 + col0 ) FROM tab2 AS cor0 WHERE NOT ( NULL ) < NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-294 SELECT DISTINCT - + MIN( + col0 ) FROM tab1 AS cor0 ---- -51 skipif mysql # not compatible query I rowsort label-294 SELECT DISTINCT - + MIN ( + col0 ) FROM tab1 AS cor0 ---- -51 query I rowsort SELECT - col1 * - ( + col1 ) AS col0 FROM tab0 AS cor0 ---- 1 441 6561 onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-296 SELECT ALL ( 44 ) / CAST( NULL AS DECIMAL ) AS col2 FROM tab1 AS cor0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-296 SELECT ALL ( 44 ) / CAST ( NULL AS REAL ) AS col2 FROM tab1 AS cor0 ---- NULL NULL NULL query I rowsort SELECT + + 58 * 19 FROM tab0 cor0 ---- 1102 1102 1102 query I rowsort SELECT DISTINCT - col2 + - 85 AS col0 FROM tab0 AS cor0 ---- -132 -184 -95 query I rowsort SELECT ALL + ( - col2 ) + + col0 AS col2 FROM tab0 ---- -2 -32 77 query III rowsort SELECT * FROM tab2 WHERE NOT ( + 26 ) IN ( - col0 ) ---- 9 values hashing to 75c998aa53ac83218cbf2feb962d0a49 onlyif mysql # DIV for integer division: query I rowsort label-301 SELECT DISTINCT col0 DIV 32 FROM tab0 ---- 0 2 3 skipif mysql # not compatible query I rowsort label-301 SELECT DISTINCT col0 / 32 FROM tab0 ---- 0 2 3 query I rowsort SELECT + col2 * + - col2 AS col0 FROM tab1 ---- -3481 -4624 -9216 onlyif mysql # aggregate syntax: query I rowsort label-303 SELECT + MIN( + 70 ) AS col1 FROM tab2 ---- 70 skipif mysql # not compatible query I rowsort label-303 SELECT + MIN ( + 70 ) AS col1 FROM tab2 ---- 70 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL - col0 * - + col1 col0 FROM tab0 ---- 1215 1827 97 query III rowsort SELECT ALL * FROM tab2 WHERE NOT ( NULL ) <> - 49 ---- onlyif mysql # aggregate syntax: query I rowsort label-306 SELECT DISTINCT + COUNT( ALL + 3 ) * - SUM( ALL ( - col0 ) * col0 ) FROM tab0 ---- 51609 skipif mysql # not compatible query I rowsort label-306 SELECT DISTINCT + COUNT ( ALL + 3 ) * - SUM ( ALL ( - col0 ) * col0 ) FROM tab0 ---- 51609 query III rowsort SELECT DISTINCT * FROM tab1 WHERE NOT - col2 * col2 IN ( + col2 ) ---- 9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad query I rowsort SELECT + col0 FROM tab2 AS cor0 WHERE NOT 4 * - col0 + 55 IS NULL AND NOT + col2 IS NOT NULL ---- query I rowsort SELECT DISTINCT col1 + + + col1 FROM tab2 AS cor0 ---- 102 134 154 query I rowsort SELECT + col0 * - col0 + + col1 + 87 FROM tab2 cor0 ---- -1978 -3932 -5471 query I rowsort SELECT ALL - 98 AS col2 FROM tab0 AS cor0 CROSS JOIN tab2 cor1 ---- 9 values hashing to f17b7008a7deae1eb5a2e707ec237638 query I rowsort SELECT DISTINCT ( 30 ) + 61 FROM tab0 AS cor0 CROSS JOIN tab2 AS cor1 ---- 91 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL - col1 col1 FROM tab2 WHERE - col1 * - col1 IS NOT NULL ---- -51 -67 -77 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-314 SELECT ALL CAST( NULL AS SIGNED ) FROM tab2 cor0 CROSS JOIN tab2 cor1 ---- 9 values hashing to cd7a7901e47c15155404aff0d216fe0b skipif mysql # not compatible query I rowsort label-314 SELECT ALL CAST ( NULL AS INTEGER ) FROM tab2 cor0 CROSS JOIN tab2 cor1 ---- 9 values hashing to cd7a7901e47c15155404aff0d216fe0b query I rowsort SELECT col2 * + 13 FROM tab0 ---- 1287 130 611 onlyif mysql # DIV for integer division: query I rowsort label-316 SELECT DISTINCT - col2 DIV - col1 + + 52 AS col1 FROM tab2 AS cor0 ---- 52 skipif mysql # not compatible query I rowsort label-316 SELECT DISTINCT - col2 / - col1 + + 52 AS col1 FROM tab2 AS cor0 ---- 52 query III rowsort SELECT * FROM tab0 AS cor0 WHERE - col1 + - - col1 / col1 NOT BETWEEN ( + col0 ) AND - 7 ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-318 SELECT ALL CAST( NULL AS DECIMAL ) AS col1 FROM tab2 AS cor0 WHERE NULL NOT BETWEEN NULL AND - col0 ---- skipif mysql # not compatible query I rowsort label-318 SELECT ALL CAST ( NULL AS REAL ) AS col1 FROM tab2 AS cor0 WHERE NULL NOT BETWEEN NULL AND - col0 ---- query I rowsort SELECT DISTINCT 70 * - col0 - + - col1 FROM tab2 AS cor0 ---- -3169 -4403 -5183 query I rowsort SELECT + col0 - + - col1 * + - col2 AS col1 FROM tab0 AS cor0 ---- -123 -2 -3792 onlyif mysql # aggregate syntax: query I rowsort label-321 SELECT ( 74 ) - + SUM( DISTINCT 89 ) FROM tab1 AS cor0 ---- -15 skipif mysql # not compatible query I rowsort label-321 SELECT ( 74 ) - + SUM ( DISTINCT 89 ) FROM tab1 AS cor0 ---- -15 onlyif mysql # DIV for integer division: query I rowsort label-322 SELECT 94 DIV col0 AS col0 FROM tab0 AS cor0 WHERE col0 IS NOT NULL ---- 0 1 6 skipif mysql # not compatible query I rowsort label-322 SELECT 94 / col0 AS col0 FROM tab0 AS cor0 WHERE col0 IS NOT NULL ---- 0 1 6 query I rowsort SELECT col1 * + + col1 * - + col0 - col0 * - col0 AS col2 FROM tab2 AS cor0 ---- -117530 -331050 -375360 query I rowsort SELECT + col1 - ( - col1 ) * col2 FROM tab0 AS cor0 ---- 100 231 3888 query I rowsort SELECT DISTINCT + + 86 * - + col1 FROM tab0 AS cor0 ---- -1806 -6966 -86 query III rowsort SELECT ALL * FROM tab0 WHERE ( - col0 ) NOT IN ( 85 - 8 ) ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 query III rowsort SELECT * FROM tab1 WHERE NOT - 49 - + - col0 >= - col1 ---- onlyif mysql # DIV for integer division: query I rowsort label-328 SELECT - 19 DIV + col1 col1 FROM tab1 ---- -1 -3 0 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-328 SELECT - 19 / + col1 col1 FROM tab1 ---- -1 -3 0 query III rowsort SELECT * FROM tab1 WHERE NOT NULL = ( - col1 * - - col2 ) ---- query I rowsort SELECT - + ( col0 ) AS col2 FROM tab0 AS cor0 WHERE NOT - 83 IS NOT NULL ---- query I rowsort SELECT DISTINCT col0 AS col2 FROM tab1 AS cor0 WHERE col2 + col2 IN ( 32 * + col0 ) ---- onlyif mysql # aggregate syntax: query I rowsort label-332 SELECT COUNT( DISTINCT - - col2 ) AS col1 FROM tab0 ---- 3 skipif mysql # not compatible query I rowsort label-332 SELECT COUNT ( DISTINCT - - col2 ) AS col1 FROM tab0 ---- 3 onlyif mysql # DIV for integer division: query I rowsort label-333 SELECT - col1 DIV 97 AS col1 FROM tab2 ---- 0 0 0 skipif mysql # not compatible query I rowsort label-333 SELECT - col1 / 97 AS col1 FROM tab2 ---- 0 0 0 onlyif mysql # aggregate syntax: query I rowsort label-334 SELECT ( + 77 ) * SUM( ALL + + ( - 59 ) ) FROM tab1 AS cor0 ---- -13629 skipif mysql # not compatible query I rowsort label-334 SELECT ( + 77 ) * SUM ( ALL + + ( - 59 ) ) FROM tab1 AS cor0 ---- -13629 query III rowsort SELECT ALL * FROM tab1 cor0 WHERE NULL NOT BETWEEN col1 AND + col0 ---- onlyif mysql # aggregate syntax: query I rowsort label-336 SELECT DISTINCT COUNT( + 10 ) FROM tab2 AS cor0 ---- 3 skipif mysql # not compatible query I rowsort label-336 SELECT DISTINCT COUNT ( + 10 ) FROM tab2 AS cor0 ---- 3 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-337 SELECT ALL * FROM tab2 AS cor0 WHERE NOT CAST( NULL AS SIGNED ) <= + col1 ---- skipif mysql # not compatible query III rowsort label-337 SELECT ALL * FROM tab2 AS cor0 WHERE NOT CAST ( NULL AS INTEGER ) <= + col1 ---- onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-338 SELECT ALL * FROM tab1 cor0 WHERE - CAST( NULL AS SIGNED ) = NULL ---- skipif mysql # not compatible query III rowsort label-338 SELECT ALL * FROM tab1 cor0 WHERE - CAST ( NULL AS INTEGER ) = NULL ---- query III rowsort SELECT ALL * FROM tab0 AS cor0 WHERE - 25 IS NOT NULL ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 query I rowsort SELECT ALL - col2 * - col1 * + col1 * + col2 FROM tab1 AS cor0 ---- 10214416 1806336 87025 query III rowsort SELECT * FROM tab0 AS cor0 WHERE NOT + 1 IS NOT NULL ---- query I rowsort SELECT - col1 + 17 FROM tab0 ---- -4 -64 16 query III rowsort SELECT DISTINCT * FROM tab1 WHERE - col0 * + - col2 >= col2 ---- 9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad query I rowsort SELECT col2 AS col0 FROM tab2 WHERE - + col1 + - - col1 * - col0 + - col0 < + col1 ---- 23 40 58 query I rowsort SELECT ALL + 22 + 62 FROM tab0 WHERE NULL IS NULL ---- 84 84 84 query I rowsort SELECT col1 + 22 AS col1 FROM tab2 ---- 73 89 99 query I rowsort SELECT DISTINCT + col1 + + - ( - - ( - + col0 ) ) AS col1 FROM tab2 ---- 141 142 97 query I rowsort SELECT + col1 + 65 FROM tab1 ---- 112 70 79 onlyif mysql # aggregate syntax: query I rowsort label-349 SELECT - 24 * + COUNT( * ) AS col2 FROM tab2 ---- -72 skipif mysql # not compatible query I rowsort label-349 SELECT - 24 * + COUNT ( * ) AS col2 FROM tab2 ---- -72 query III rowsort SELECT * FROM tab0 WHERE ( - col2 IS NULL ) ---- query I rowsort SELECT DISTINCT - col0 + - + col0 + - col0 AS col0 FROM tab1 AS cor0 WHERE NOT col2 IS NOT NULL ---- query III rowsort SELECT * FROM tab1 AS cor0 WHERE col2 * + 24 IS NULL ---- query IIIIII rowsort SELECT ALL * FROM tab0 AS cor0 CROSS JOIN tab2 cor1 WHERE NULL IS NULL ---- 54 values hashing to eaa394f1627c8d5e53406d9ca3b09469 onlyif mysql # DIV for integer division: query I rowsort label-354 SELECT DISTINCT col1 DIV - - col0 - - 10 AS col1 FROM tab2 ---- 10 11 skipif mysql # not compatible query I rowsort label-354 SELECT DISTINCT col1 / - - col0 - - 10 AS col1 FROM tab2 ---- 10 11 onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-355 SELECT DISTINCT + CAST( NULL AS SIGNED ) + 24, + col2 + - col2 * + 26 AS col0 FROM tab0 ---- NULL -1175 NULL -2475 NULL -250 skipif mysql # not compatible query II rowsort label-355 SELECT DISTINCT + CAST ( NULL AS INTEGER ) + 24, + col2 + - col2 * + 26 AS col0 FROM tab0 ---- NULL -1175 NULL -2475 NULL -250 query I rowsort SELECT - + col2 + + col0 + + col2 AS col0 FROM tab1 AS cor0 ---- 51 85 91 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-357 SELECT DISTINCT CAST( - COUNT( * ) AS SIGNED ) - + 65 AS col0 FROM tab1 AS cor0 ---- -68 skipif mysql # not compatible query I rowsort label-357 SELECT DISTINCT CAST ( - COUNT ( * ) AS INTEGER ) - + 65 AS col0 FROM tab1 AS cor0 ---- -68 query III rowsort SELECT ALL * FROM tab1 AS cor0 WHERE ( NULL >= - + col0 ) ---- query I rowsort SELECT DISTINCT + + col2 * - + 5 FROM tab1 AS cor0 WHERE 14 + + 16 IS NOT NULL ---- -295 -340 -480 query I rowsort SELECT ALL - col1 - 10 + + col2 * - col2 - + 35 AS col2 FROM tab0 AS cor0 ---- -166 -2335 -9847 onlyif mysql # aggregate syntax: query I rowsort label-361 SELECT DISTINCT - COUNT( * ) * - COUNT( * ) - - MAX( DISTINCT + + col1 ) col0 FROM tab2 AS cor0 ---- 86 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-361 SELECT DISTINCT - COUNT ( * ) * - COUNT ( * ) - - MAX ( DISTINCT + + col1 ) col0 FROM tab2 AS cor0 ---- 86 query II rowsort SELECT - col1 AS col2, col1 FROM tab0 ---- -1 1 -21 21 -81 81 query III rowsort SELECT * FROM tab1 WHERE NOT ( - 10 ) BETWEEN ( NULL ) AND NULL ---- query I rowsort SELECT col1 * + - col2 AS col2 FROM tab1 ---- -1344 -295 -3196 query III rowsort SELECT * FROM tab0 WHERE NOT col1 NOT IN ( + col0, col2 ) ---- query I rowsort SELECT DISTINCT 83 AS col0 FROM tab1 WHERE NOT NULL NOT IN ( + + col2 * + 51 * col2 + - + col1 - + col2 + - 19 + - col0 / - col0 ) ---- query I rowsort SELECT DISTINCT 58 * col0 * - col2 AS col2 FROM tab0 WHERE - 21 IS NOT NULL ---- -40890 -50460 -556974 onlyif mysql # aggregate syntax: query I rowsort label-368 SELECT SUM( - 78 ) AS col0 FROM tab2 ---- -234 skipif mysql # not compatible query I rowsort label-368 SELECT SUM ( - 78 ) AS col0 FROM tab2 ---- -234 onlyif mysql # aggregate syntax: query I rowsort label-369 SELECT MAX( ALL + 74 ) AS col2 FROM tab2 AS cor0 WHERE NOT ( + col1 ) IS NOT NULL ---- NULL skipif mysql # not compatible query I rowsort label-369 SELECT MAX ( ALL + 74 ) AS col2 FROM tab2 AS cor0 WHERE NOT ( + col1 ) IS NOT NULL ---- NULL query II rowsort SELECT DISTINCT - - col1, col0 AS col1 FROM tab1 AS cor0 WHERE col0 IS NULL ---- query II rowsort SELECT DISTINCT + - 79, col0 FROM tab2 AS cor0 ---- -79 46 -79 64 -79 75 onlyif mysql # aggregate syntax: query I rowsort label-372 SELECT ALL - COUNT( ALL - - col0 ) FROM tab1 ---- -3 skipif mysql # not compatible query I rowsort label-372 SELECT ALL - COUNT ( ALL - - col0 ) FROM tab1 ---- -3 query III rowsort SELECT ALL * FROM tab2 AS cor0 WHERE - col1 * + col0 * + - 36 IS NOT NULL ---- 9 values hashing to 75c998aa53ac83218cbf2feb962d0a49 query I rowsort SELECT - - 74 FROM tab2 cor0 ---- 74 74 74 query III rowsort SELECT * FROM tab2 AS cor0 WHERE 58 / - ( - + col1 ) IS NULL ---- query III rowsort SELECT DISTINCT * FROM tab2 WHERE + - 57 <= - col0 + + col1 + 83 ---- 9 values hashing to 75c998aa53ac83218cbf2feb962d0a49 query I rowsort SELECT ALL col1 + 59 AS col1 FROM tab2 ---- 110 126 136 onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-378 SELECT DISTINCT - CAST( NULL AS DECIMAL ) + + 83 + col0 * - - col1 FROM tab1 ---- NULL skipif mysql # not compatible query I rowsort label-378 SELECT DISTINCT - CAST ( NULL AS REAL ) + + 83 + col0 * - - col1 FROM tab1 ---- NULL query I rowsort SELECT ALL + col2 * 94 FROM tab0 ---- 4418 9306 940 onlyif mysql # aggregate syntax: query I rowsort label-380 SELECT DISTINCT 49 + - COUNT( * ) col0 FROM tab1 ---- 46 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-380 SELECT DISTINCT 49 + - COUNT ( * ) col0 FROM tab1 ---- 46 query I rowsort SELECT DISTINCT col0 * - 4 AS col1 FROM tab0 ---- -348 -388 -60 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-382 SELECT CAST( NULL AS SIGNED ) + + col0 col0 FROM tab1 ---- NULL NULL NULL skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-382 SELECT CAST ( NULL AS INTEGER ) + + col0 col0 FROM tab1 ---- NULL NULL NULL query I rowsort SELECT ALL col2 * + 25 FROM tab1 cor0 ---- 1475 1700 2400 query I rowsort SELECT + col0 * col1 + - col2 AS col2 FROM tab1 AS cor0 ---- 366 4209 618 onlyif mysql # aggregate syntax: query I rowsort label-385 SELECT + COUNT( DISTINCT + - col2 ) + - + 33 col1 FROM tab0 AS cor0 ---- -30 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-385 SELECT + COUNT ( DISTINCT + - col2 ) + - + 33 col1 FROM tab0 AS cor0 ---- -30 onlyif mysql # aggregate syntax: query I rowsort label-386 SELECT MIN( col0 ) AS col0 FROM tab0 cor0 ---- 15 skipif mysql # not compatible query I rowsort label-386 SELECT MIN ( col0 ) AS col0 FROM tab0 cor0 ---- 15 query I rowsort SELECT DISTINCT + col2 + + 3 AS col1 FROM tab2 ---- 26 43 61 onlyif mysql # aggregate syntax: query I rowsort label-388 SELECT ALL COUNT( * ) + - 30 * ( + 98 ) FROM tab0 ---- -2937 skipif mysql # not compatible query I rowsort label-388 SELECT ALL COUNT ( * ) + - 30 * ( + 98 ) FROM tab0 ---- -2937 query I rowsort SELECT + col0 + - + col0 * - - 66 * + col2 AS col2 FROM tab0 WHERE ( - 98 ) IS NOT NULL ---- -46515 -57333 -633701 onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: query I rowsort label-390 SELECT DISTINCT + col2 * + - col2 / - col1 + col1 - - + CAST( NULL AS SIGNED ) * col0 + - + CAST( 27 AS DECIMAL ) AS col1 FROM tab0 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-390 SELECT DISTINCT + col2 * + - col2 / - col1 + col1 - - + CAST ( NULL AS INTEGER ) * col0 + - + CAST ( 27 AS REAL ) AS col1 FROM tab0 AS cor0 ---- NULL onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-391 SELECT ALL - CAST( NULL AS SIGNED ), 96 col2 FROM tab1 AS cor0 ---- NULL 96 NULL 96 NULL 96 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort label-391 SELECT ALL - CAST ( NULL AS INTEGER ), 96 col2 FROM tab1 AS cor0 ---- NULL 96 NULL 96 NULL 96 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-392 SELECT ALL CAST( + + col0 AS SIGNED ) AS col2 FROM tab1 AS cor0 ---- 51 85 91 skipif mysql # not compatible query I rowsort label-392 SELECT ALL CAST ( + + col0 AS INTEGER ) AS col2 FROM tab1 AS cor0 ---- 51 85 91 query II rowsort SELECT ALL 78 AS col0, 64 AS col0 FROM tab0 AS cor0 ---- 78 64 78 64 78 64 onlyif mysql # aggregate syntax: query I rowsort label-394 SELECT - - COUNT( * ) * + + 96 AS col1 FROM tab1 AS cor0 ---- 288 skipif mysql # not compatible query I rowsort label-394 SELECT - - COUNT ( * ) * + + 96 AS col1 FROM tab1 AS cor0 ---- 288 query I rowsort SELECT ALL col2 AS col1 FROM tab0 AS cor0 WHERE 33 IS NOT NULL ---- 10 47 99 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-396 SELECT ALL * FROM tab2 AS cor0 WHERE NOT CAST( NULL AS SIGNED ) * col0 * - col2 IS NULL ---- skipif mysql # not compatible query III rowsort label-396 SELECT ALL * FROM tab2 AS cor0 WHERE NOT CAST ( NULL AS INTEGER ) * col0 * - col2 IS NULL ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL - 45 * + col2 * - 54 + + 74 col0 FROM tab2 AS cor0 ---- 141014 55964 97274 query I rowsort SELECT DISTINCT + 25 * + 95 FROM tab1 AS cor0 ---- 2375 query I rowsort SELECT DISTINCT col2 + + 64 FROM tab1 WHERE NOT col1 + + + col1 IS NULL ---- 123 132 160 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-400 SELECT col2 / + - col1 col2 FROM tab2 WHERE NOT NULL NOT BETWEEN + - CAST( NULL AS SIGNED ) AND + col1 ---- skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-400 SELECT col2 / + - col1 col2 FROM tab2 WHERE NOT NULL NOT BETWEEN + - CAST ( NULL AS INTEGER ) AND + col1 ---- query I rowsort SELECT col0 * + 76 FROM tab0 WHERE NOT ( NULL ) IS NOT NULL ---- 1140 6612 7372 onlyif mysql # DIV for integer division: query I rowsort label-402 SELECT 93 DIV + + 5 AS col0 FROM tab1 ---- 18 18 18 skipif mysql # not compatible query I rowsort label-402 SELECT 93 / + + 5 AS col0 FROM tab1 ---- 18 18 18 query I rowsort SELECT DISTINCT + ( + - 92 ) AS col1 FROM tab0 WHERE + col2 + + col0 IS NOT NULL ---- -92 query I rowsort SELECT DISTINCT - 13 * col0 FROM tab2 AS cor0 WHERE ( NULL ) IS NOT NULL ---- query III rowsort SELECT * FROM tab2 WHERE NOT NULL NOT BETWEEN - 5 AND - - col2 ---- query III rowsort SELECT DISTINCT * FROM tab2 WHERE 67 + col1 + - col0 >= NULL ---- query I rowsort SELECT ALL col0 FROM tab1 WHERE + 58 <> + col1 * + col2 ---- 51 85 91 onlyif mysql # aggregate syntax: query II rowsort label-408 SELECT - COUNT( * ) AS col0, + COUNT( * ) FROM tab2 ---- -3 3 skipif mysql # not compatible query II rowsort label-408 SELECT - COUNT ( * ) AS col0, + COUNT ( * ) FROM tab2 ---- -3 3 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: DIV for integer division: query I rowsort label-409 SELECT - CAST( - + CAST( AVG ( + - 17 ) AS SIGNED ) AS SIGNED ) DIV ( - COUNT( * ) ) FROM tab1 cor0 ---- 5 skipif mysql # not compatible query I rowsort label-409 SELECT - CAST ( - + CAST ( AVG ( + - 17 ) AS INTEGER ) AS INTEGER ) / ( - COUNT ( * ) ) FROM tab1 cor0 ---- 5 query I rowsort SELECT + col0 FROM tab0 AS cor0 WHERE + col0 / + 17 + + - col0 IS NOT NULL ---- 15 87 97 query I rowsort SELECT ALL col1 FROM tab1 AS cor0 WHERE NOT ( + col1 ) <> NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-412 SELECT DISTINCT - SUM( DISTINCT - col0 ) FROM tab1 AS cor0 ---- 227 skipif mysql # not compatible query I rowsort label-412 SELECT DISTINCT - SUM ( DISTINCT - col0 ) FROM tab1 AS cor0 ---- 227 query III rowsort SELECT * FROM tab0 AS cor0 WHERE ( NULL ) >= + col2 ---- query I rowsort SELECT ALL col2 FROM tab2 AS cor0 WHERE - 99 IS NULL ---- onlyif mysql # DIV for integer division: query I rowsort label-415 SELECT + 89 * - col2 + - 14 DIV + - ( + col1 ) AS col0 FROM tab0 AS cor0 ---- -4183 -8797 -890 skipif mysql # not compatible query I rowsort label-415 SELECT + 89 * - col2 + - 14 / + - ( + col1 ) AS col0 FROM tab0 AS cor0 ---- -4183 -8797 -890 query I rowsort SELECT - col1 AS col2 FROM tab1 WHERE NULL BETWEEN NULL AND NULL ---- query I rowsort SELECT DISTINCT + ( col2 ) + - 78 FROM tab0 ---- -31 -68 21 query I rowsort SELECT col0 + - + 95 FROM tab0 ---- -8 -80 2 query I rowsort SELECT ALL - + col2 FROM tab0 WHERE ( + 98 ) IS NOT NULL ---- -10 -47 -99 onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-420 SELECT DISTINCT col0 + - 21 - + CAST( NULL AS DECIMAL ) * + + 30 AS col0 FROM tab1 ---- NULL skipif mysql # not compatible query I rowsort label-420 SELECT DISTINCT col0 + - 21 - + CAST ( NULL AS REAL ) * + + 30 AS col0 FROM tab1 ---- NULL onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-421 SELECT ALL CAST( NULL AS DECIMAL ) - + + col2 + - 4 FROM tab0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-421 SELECT ALL CAST ( NULL AS REAL ) - + + col2 + - 4 FROM tab0 ---- NULL NULL NULL onlyif mysql # aggregate syntax: query I rowsort label-422 SELECT MAX( ALL + col0 ) AS col0 FROM tab0 ---- 97 skipif mysql # not compatible query I rowsort label-422 SELECT MAX ( ALL + col0 ) AS col0 FROM tab0 ---- 97 onlyif mysql # aggregate syntax: query I rowsort label-423 SELECT - ( COUNT( - - 78 ) ) + COUNT( * ) + - + 59 col2 FROM tab2 AS cor0 WHERE col1 <= 89 ---- -59 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-423 SELECT - ( COUNT ( - - 78 ) ) + COUNT ( * ) + - + 59 col2 FROM tab2 AS cor0 WHERE col1 <= 89 ---- -59 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query II rowsort label-424 SELECT ALL + CAST( - 29 AS SIGNED ) + + - MIN( DISTINCT + 72 ) + + 70 AS col2, - 99 FROM tab0 ---- -31 -99 skipif mysql # not compatible query II rowsort label-424 SELECT ALL + CAST ( - 29 AS INTEGER ) + + - MIN ( DISTINCT + 72 ) + + 70 AS col2, - 99 FROM tab0 ---- -31 -99 query I rowsort SELECT + 39 * - - col1 + - - col2 FROM tab2 ---- 2012 2671 3043 query I rowsort SELECT DISTINCT + 76 AS col0 FROM tab2 WHERE NULL <> NULL ---- onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-427 SELECT * FROM tab2 AS cor0 WHERE NOT + CAST( - 77 AS SIGNED ) * + col1 < - 39 ---- skipif mysql # not compatible query III rowsort label-427 SELECT * FROM tab2 AS cor0 WHERE NOT + CAST ( - 77 AS INTEGER ) * + col1 < - 39 ---- onlyif mysql # aggregate syntax: query I rowsort label-428 SELECT DISTINCT + COUNT( * ) FROM tab0 AS cor0 WHERE NOT 7 * + 81 IS NULL ---- 3 skipif mysql # not compatible query I rowsort label-428 SELECT DISTINCT + COUNT ( * ) FROM tab0 AS cor0 WHERE NOT 7 * + 81 IS NULL ---- 3 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-429 SELECT DISTINCT 93 * - + ( - col2 ) * + CAST( NULL AS SIGNED ) / - col1 AS col2 FROM tab0 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-429 SELECT DISTINCT 93 * - + ( - col2 ) * + CAST ( NULL AS INTEGER ) / - col1 AS col2 FROM tab0 AS cor0 ---- NULL query II rowsort SELECT - col2 AS col0, - col2 + - col2 * + + col1 FROM tab0 cor0 ---- -10 -220 -47 -3854 -99 -198 onlyif mysql # aggregate syntax: query I rowsort label-431 SELECT - 83 * - 68 * - + COUNT( * ) col1 FROM tab0 ---- -16932 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-431 SELECT - 83 * - 68 * - + COUNT ( * ) col1 FROM tab0 ---- -16932 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT DISTINCT ( 89 ) col0 FROM tab1 ---- 89 onlyif mysql # aggregate syntax: query I rowsort label-433 SELECT ALL - COUNT( DISTINCT 53 ) col2 FROM tab1 ---- -1 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-433 SELECT ALL - COUNT ( DISTINCT 53 ) col2 FROM tab1 ---- -1 query II rowsort SELECT - col0 AS col1, 54 AS col0 FROM tab0 AS cor0 ---- -15 54 -87 54 -97 54 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT - 99 col0 FROM tab2 AS cor0 ---- -99 -99 -99 onlyif mysql # aggregate syntax: query I rowsort label-436 SELECT - COUNT( * ) + + COUNT( * ) FROM tab0 AS cor0 WHERE NOT col0 IS NOT NULL ---- 0 skipif mysql # not compatible query I rowsort label-436 SELECT - COUNT ( * ) + + COUNT ( * ) FROM tab0 AS cor0 WHERE NOT col0 IS NOT NULL ---- 0 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-437 SELECT ALL + CAST( 55 AS SIGNED ) AS col2 FROM tab1 AS cor0 ---- 55 55 55 skipif mysql # not compatible query I rowsort label-437 SELECT ALL + CAST ( 55 AS INTEGER ) AS col2 FROM tab1 AS cor0 ---- 55 55 55 query I rowsort SELECT - col2 FROM tab2 AS cor0 WHERE NULL NOT BETWEEN NULL AND 86 ---- query I rowsort SELECT DISTINCT ( + col2 ) + - col1 AS col0 FROM tab0 WHERE + - col1 <= ( NULL ) ---- onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-440 SELECT CAST( - 11 AS SIGNED ) * - 69 * + + ( col2 ) - + 88 * col0 * + + col2 * col1 + col1 FROM tab1 ---- -2161814 -25541909 -5958994 skipif mysql # not compatible query I rowsort label-440 SELECT CAST ( - 11 AS INTEGER ) * - 69 * + + ( col2 ) - + 88 * col0 * + + col2 * col1 + col1 FROM tab1 ---- -2161814 -25541909 -5958994 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-441 SELECT ALL + 65 * - 8 + - 41 * + + col1 * CAST( NULL AS SIGNED ) FROM tab0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-441 SELECT ALL + 65 * - 8 + - 41 * + + col1 * CAST ( NULL AS INTEGER ) FROM tab0 ---- NULL NULL NULL query I rowsort SELECT DISTINCT 42 AS col2 FROM tab2 WHERE col2 + - col1 IS NULL ---- query II rowsort SELECT DISTINCT col0 AS col0, + col2 + col1 AS col2 FROM tab1 ---- 51 110 85 64 91 115 query I rowsort SELECT - + col1 AS col0 FROM tab2 WHERE ( col2 ) >= NULL ---- onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-445 SELECT + COUNT( ALL - 59 ) * + CAST( NULL AS SIGNED ) * - 27 AS col0 FROM tab1 AS cor0 WHERE NULL > ( + col1 ) ---- NULL skipif mysql # not compatible query I rowsort label-445 SELECT + COUNT ( ALL - 59 ) * + CAST ( NULL AS INTEGER ) * - 27 AS col0 FROM tab1 AS cor0 WHERE NULL > ( + col1 ) ---- NULL query I rowsort SELECT ALL ( - col2 ) * - + ( - 86 ) AS col2 FROM tab2 AS cor0 ---- -1978 -3440 -4988 query I rowsort SELECT - + col1 * + - col0 FROM tab1 AS cor0 ---- 425 4277 714 onlyif mysql # aggregate syntax: query I rowsort label-448 SELECT ALL - 54 * - SUM( - 13 ) AS col1 FROM tab1 AS cor0 ---- -2106 skipif mysql # not compatible query I rowsort label-448 SELECT ALL - 54 * - SUM ( - 13 ) AS col1 FROM tab1 AS cor0 ---- -2106 query I rowsort SELECT 62 FROM tab1 cor0 WHERE NULL NOT BETWEEN NULL AND NULL ---- onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-450 SELECT ALL - 0 + + CAST( NULL AS DECIMAL ) + + - 5 + + AVG ( DISTINCT - col2 ) + - 64 AS col1 FROM tab2 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-450 SELECT ALL - 0 + + CAST ( NULL AS REAL ) + + - 5 + + AVG ( DISTINCT - col2 ) + - 64 AS col1 FROM tab2 AS cor0 ---- NULL query I rowsort SELECT DISTINCT - + 90 FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1 ---- -90 query I rowsort SELECT col0 * 21 AS col0 FROM tab1 ---- 1071 1785 1911 query IIIIII rowsort SELECT * FROM tab0 AS cor0 CROSS JOIN tab2 AS cor1 WHERE NOT - + 72 IS NULL AND NOT NULL IS NOT NULL ---- 54 values hashing to eaa394f1627c8d5e53406d9ca3b09469 query I rowsort SELECT DISTINCT - col1 * + + col2 * col2 FROM tab1 AS cor0 ---- -129024 -17405 -217328 query I rowsort SELECT ALL + - col0 * + ( - - col2 ) AS col0 FROM tab0 AS cor0 ---- -705 -870 -9603 onlyif mysql # aggregate syntax: query II rowsort label-456 SELECT ALL - MAX( ALL - col1 ), + COUNT( * ) AS col0 FROM tab0 AS cor0 ---- 1 3 skipif mysql # not compatible query II rowsort label-456 SELECT ALL - MAX ( ALL - col1 ), + COUNT ( * ) AS col0 FROM tab0 AS cor0 ---- 1 3 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-457 SELECT DISTINCT - COUNT( * ) AS col0 FROM tab1 WHERE + CAST( CAST( - - col1 AS SIGNED ) AS SIGNED ) - + 66 + - + 88 >= NULL ---- 0 skipif mysql # not compatible query I rowsort label-457 SELECT DISTINCT - COUNT ( * ) AS col0 FROM tab1 WHERE + CAST ( CAST ( - - col1 AS INTEGER ) AS INTEGER ) - + 66 + - + 88 >= NULL ---- 0 onlyif mysql # DIV for integer division: query I rowsort label-458 SELECT DISTINCT 1 DIV col0 AS col2 FROM tab0 ---- 0 skipif mysql # not compatible query I rowsort label-458 SELECT DISTINCT 1 / col0 AS col2 FROM tab0 ---- 0 query III rowsort SELECT DISTINCT * FROM tab2 WHERE NOT + 65 IS NOT NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-460 SELECT DISTINCT SUM( DISTINCT - 40 ) col2 FROM tab2 ---- -40 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-460 SELECT DISTINCT SUM ( DISTINCT - 40 ) col2 FROM tab2 ---- -40 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT DISTINCT col2 * - col0 col0 FROM tab0 ---- -705 -870 -9603 query I rowsort SELECT col2 * col1 * 32 AS col2 FROM tab2 ---- 124352 37536 98560 onlyif mysql # DIV for integer division: query II rowsort label-463 SELECT ALL col2 AS col2, col2 DIV - col0 FROM tab0 ---- 10 0 47 -3 99 -1 skipif mysql # not compatible query II rowsort label-463 SELECT ALL col2 AS col2, col2 / - col0 FROM tab0 ---- 10 0 47 -3 99 -1 query I rowsort SELECT - col1 * + + 74 * + 97 FROM tab1 AS cor0 ---- -100492 -337366 -35890 onlyif mysql # DIV for integer division: query II rowsort label-465 SELECT col0 AS col0, col1 * 66 DIV + - 99 FROM tab2 AS cor0 ---- 46 -34 64 -51 75 -44 skipif mysql # not compatible query II rowsort label-465 SELECT col0 AS col0, col1 * 66 / + - 99 FROM tab2 AS cor0 ---- 46 -34 64 -51 75 -44 query I rowsort SELECT DISTINCT + col1 + + 84 FROM tab2 cor0 ---- 135 151 161 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-467 SELECT ALL CAST( NULL AS SIGNED ) / + + COUNT( * ) FROM tab1, tab2 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-467 SELECT ALL CAST ( NULL AS INTEGER ) / + + COUNT ( * ) FROM tab1, tab2 AS cor0 ---- NULL onlyif mysql # DIV for integer division: query I rowsort label-468 SELECT DISTINCT col0 DIV + + 21 AS col0 FROM tab0 cor0 ---- 0 4 skipif mysql # not compatible query I rowsort label-468 SELECT DISTINCT col0 / + + 21 AS col0 FROM tab0 cor0 ---- 0 4 query I rowsort SELECT ALL - + 76 * + col2 AS col2 FROM tab0 AS cor0 ---- -3572 -7524 -760 query I rowsort SELECT - col1 + + 54 * + + ( col1 ) AS col0 FROM tab0 AS cor0 ---- 1113 4293 53 query I rowsort SELECT - + 36 + + col1 AS col1 FROM tab2 AS cor0 ---- 15 31 41 query II rowsort SELECT ALL col1, col1 AS col0 FROM tab2 AS cor0 ---- 51 51 67 67 77 77 query III rowsort SELECT DISTINCT * FROM tab1 AS cor0 WHERE NOT + 49 IS NULL ---- 9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad query III rowsort SELECT * FROM tab0 cor0 WHERE + ( + 86 ) IS NOT NULL ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 onlyif mysql # DIV for integer division: query II rowsort label-475 SELECT + + 36 AS col1, col0 DIV + col0 AS col1 FROM tab2 AS cor0 ---- 36 1 36 1 36 1 skipif mysql # not compatible query II rowsort label-475 SELECT + + 36 AS col1, col0 / + col0 AS col1 FROM tab2 AS cor0 ---- 36 1 36 1 36 1 query I rowsort SELECT DISTINCT - 88 AS col0 FROM tab2 WHERE NULL BETWEEN NULL AND - 38 - + col2 ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT DISTINCT + col0 + 8 + - col0 * col0 col1 FROM tab2 ---- -2062 -4024 -5542 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-478 SELECT ALL MIN( - 58 ) - CAST( NULL AS SIGNED ) * - COUNT( - - 49 ) * - + 44 AS col1 FROM tab0 ---- NULL skipif mysql # not compatible query I rowsort label-478 SELECT ALL MIN ( - 58 ) - CAST ( NULL AS INTEGER ) * - COUNT ( - - 49 ) * - + 44 AS col1 FROM tab0 ---- NULL query I rowsort SELECT DISTINCT col2 - + - 17 AS col1 FROM tab2 ---- 40 57 75 query I rowsort SELECT DISTINCT col0 + + ( + 17 ) AS col2 FROM tab0 ---- 104 114 32 query I rowsort SELECT DISTINCT col1 FROM tab2 WHERE NULL NOT BETWEEN NULL AND - + col0 ---- onlyif mysql # CAST syntax: SIGNED type: DIV for integer division: query I rowsort label-482 SELECT ALL ( - - col1 ) DIV CAST( col1 AS SIGNED ) - - col0 + + col1 FROM tab2 ---- 142 143 98 skipif mysql # not compatible query I rowsort label-482 SELECT ALL ( - - col1 ) / CAST ( col1 AS INTEGER ) - - col0 + + col1 FROM tab2 ---- 142 143 98 query I rowsort SELECT + col2 FROM tab0 AS cor0 WHERE - col0 > NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-484 SELECT DISTINCT - MIN( DISTINCT col0 ) AS col2 FROM tab0 AS cor0 ---- -15 skipif mysql # not compatible query I rowsort label-484 SELECT DISTINCT - MIN ( DISTINCT col0 ) AS col2 FROM tab0 AS cor0 ---- -15 onlyif mysql # aggregate syntax: query I rowsort label-485 SELECT - ( + - COUNT( DISTINCT + 97 ) ) AS col0 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1 ---- 1 skipif mysql # not compatible query I rowsort label-485 SELECT - ( + - COUNT ( DISTINCT + 97 ) ) AS col0 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1 ---- 1 onlyif mysql # aggregate syntax: query I rowsort label-486 SELECT DISTINCT + MAX( ALL + + ( + col0 ) ) col1 FROM tab2 AS cor0 ---- 75 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-486 SELECT DISTINCT + MAX ( ALL + + ( + col0 ) ) col1 FROM tab2 AS cor0 ---- 75 onlyif mysql # aggregate syntax: query I rowsort label-487 SELECT ALL + MAX( ALL 13 ) FROM tab1 AS cor0 ---- 13 skipif mysql # not compatible query I rowsort label-487 SELECT ALL + MAX ( ALL 13 ) FROM tab1 AS cor0 ---- 13 query I rowsort SELECT DISTINCT ( - 14 ) AS col0 FROM tab2 cor0 ---- -14 query II rowsort SELECT ALL col2 * - ( - col1 ), + col0 FROM tab1 AS cor0 ---- 1344 51 295 85 3196 91 query II rowsort SELECT - 26 AS col2, ( - ( - col0 ) ) AS col0 FROM tab2 AS cor0 ---- -26 46 -26 64 -26 75 query II rowsort SELECT + - 15 + + col2 AS col2, + col2 AS col2 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL AND NULL <= 46 + + - col2 ---- onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-492 SELECT ALL * FROM tab0 AS cor0 WHERE NULL <= + CAST( NULL AS SIGNED ) * - - col2 ---- skipif mysql # not compatible query III rowsort label-492 SELECT ALL * FROM tab0 AS cor0 WHERE NULL <= + CAST ( NULL AS INTEGER ) * - - col2 ---- onlyif mysql # aggregate syntax: query II rowsort label-493 SELECT - + ( - SUM( + - 96 ) ), + COUNT( ALL - 68 ) AS col0 FROM tab0 AS cor0 ---- -288 3 skipif mysql # not compatible query II rowsort label-493 SELECT - + ( - SUM ( + - 96 ) ), + COUNT ( ALL - 68 ) AS col0 FROM tab0 AS cor0 ---- -288 3 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-494 SELECT DISTINCT - 3 / + col2 + - - 9 / CAST( NULL AS SIGNED ) / 63 FROM tab0 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-494 SELECT DISTINCT - 3 / + col2 + - - 9 / CAST ( NULL AS INTEGER ) / 63 FROM tab0 AS cor0 ---- NULL onlyif mysql # aggregate syntax: query I rowsort label-495 SELECT 95 * - + COUNT( * ) * - 26 FROM tab2 ---- 7410 skipif mysql # not compatible query I rowsort label-495 SELECT 95 * - + COUNT ( * ) * - 26 FROM tab2 ---- 7410 query I rowsort SELECT DISTINCT + col2 AS col0 FROM tab2 WHERE - col1 < NULL ---- query III rowsort SELECT * FROM tab1 WHERE NOT - + col2 * - - col1 IS NOT NULL ---- query III rowsort SELECT * FROM tab0 WHERE NOT - 78 = NULL ---- onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-499 SELECT ALL col1 * + 89 * - CAST( NULL AS DECIMAL ) AS col1 FROM tab2 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-499 SELECT ALL col1 * + 89 * - CAST ( NULL AS REAL ) AS col1 FROM tab2 ---- NULL NULL NULL onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-500 SELECT * FROM tab0 WHERE NOT - col0 > - 8 - - CAST( NULL AS SIGNED ) - + 54 * + 10 ---- skipif mysql # not compatible query III rowsort label-500 SELECT * FROM tab0 WHERE NOT - col0 > - 8 - - CAST ( NULL AS INTEGER ) - + 54 * + 10 ---- onlyif mysql # DIV for integer division: query I rowsort label-501 SELECT ALL + - col1 DIV - col2 col2 FROM tab0 AS cor0 ---- 0 1 2 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-501 SELECT ALL + - col1 / - col2 col2 FROM tab0 AS cor0 ---- 0 1 2 query III rowsort SELECT * FROM tab0 AS cor0 WHERE - col1 + col2 * + - col2 IS NULL ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT + - col1 + 49 col2 FROM tab0 AS cor0 ---- -32 28 48 query I rowsort SELECT ALL + 47 * + - ( - - col2 ) + ( - + col1 ) AS col2 FROM tab0 AS cor0 ---- -2290 -4654 -491 query I rowsort SELECT col0 FROM tab0 AS cor0 WHERE ( + col2 + 9 + col0 > - + 10 * - - col1 ) ---- 15 87 97 query I rowsort SELECT - - ( col1 ) * col0 FROM tab0 cor0 ---- 1215 1827 97 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT col1 col2 FROM tab1 AS cor0 WHERE NULL IS NOT NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-508 SELECT ALL - COUNT( - - ( + - col2 ) ) col0 FROM tab1 AS cor0 ---- -3 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-508 SELECT ALL - COUNT ( - - ( + - col2 ) ) col0 FROM tab1 AS cor0 ---- -3 query I rowsort SELECT + 29 - col2 - - - col0 AS col1 FROM tab2 cor0 ---- -104 -40 -75 onlyif mysql # aggregate syntax: query I rowsort label-510 SELECT - + MIN( col0 ) AS col1 FROM tab0 WHERE ( NULL ) >= col2 ---- NULL skipif mysql # not compatible query I rowsort label-510 SELECT - + MIN ( col0 ) AS col1 FROM tab0 WHERE ( NULL ) >= col2 ---- NULL query III rowsort SELECT * FROM tab2 WHERE 26 > - col0 ---- 9 values hashing to 75c998aa53ac83218cbf2feb962d0a49 query III rowsort SELECT * FROM tab0 WHERE NULL >= + col1 - - col2 ---- query III rowsort SELECT * FROM tab2 WHERE + ( + col2 ) BETWEEN ( - + 28 ) AND - 57 ---- onlyif mysql # aggregate syntax: query I rowsort label-514 SELECT ALL COUNT( * ) AS col2 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - col2 - - col0 ---- 0 skipif mysql # not compatible query I rowsort label-514 SELECT ALL COUNT ( * ) AS col2 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - col2 - - col0 ---- 0 query I rowsort SELECT col2 * - col1 * 41 FROM tab1 AS cor0 WHERE NOT NULL IS NULL ---- onlyif mysql # aggregate syntax: DIV for integer division: query I rowsort label-516 SELECT DISTINCT + SUM( DISTINCT - + col1 ) DIV - + COUNT( * ) AS col0 FROM tab2 AS cor0 ---- 65 skipif mysql # not compatible query I rowsort label-516 SELECT DISTINCT + SUM ( DISTINCT - + col1 ) / - + COUNT ( * ) AS col0 FROM tab2 AS cor0 ---- 65 query II rowsort SELECT - + 98, - col0 AS col0 FROM tab0 AS cor0 ---- -98 -15 -98 -87 -98 -97 query II rowsort SELECT - col1 AS col2, - 34 AS col0 FROM tab0 AS cor0 ---- -1 -34 -21 -34 -81 -34 onlyif mysql # aggregate syntax: query I rowsort label-519 SELECT DISTINCT SUM( DISTINCT + 88 ) + - 17 FROM tab2 cor0 CROSS JOIN tab0 AS cor1 ---- 71 skipif mysql # not compatible query I rowsort label-519 SELECT DISTINCT SUM ( DISTINCT + 88 ) + - 17 FROM tab2 cor0 CROSS JOIN tab0 AS cor1 ---- 71 onlyif mysql # aggregate syntax: query I rowsort label-520 SELECT + SUM( 34 ) AS col1 FROM tab2 AS cor0 ---- 102 skipif mysql # not compatible query I rowsort label-520 SELECT + SUM ( 34 ) AS col1 FROM tab2 AS cor0 ---- 102 query I rowsort SELECT ALL 99 * 25 * - 64 FROM tab1 AS cor0 WHERE NOT NULL IS NOT NULL ---- -158400 -158400 -158400 query I rowsort SELECT DISTINCT 96 FROM tab0 AS cor0 WHERE ( NULL ) IS NULL ---- 96 onlyif mysql # DIV for integer division: query I rowsort label-523 SELECT - col1 DIV - - 50 FROM tab2 cor0 ---- -1 -1 -1 skipif mysql # not compatible query I rowsort label-523 SELECT - col1 / - - 50 FROM tab2 cor0 ---- -1 -1 -1 query I rowsort SELECT ALL ( + 2 ) AS col0 FROM tab1 AS cor0 ---- 2 2 2 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-525 SELECT DISTINCT + + 65 * - + 54 + - - CAST( NULL AS SIGNED ) FROM tab0 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-525 SELECT DISTINCT + + 65 * - + 54 + - - CAST ( NULL AS INTEGER ) FROM tab0 AS cor0 ---- NULL query III rowsort SELECT DISTINCT * FROM tab2 WHERE NOT NULL <= + col0 ---- onlyif mysql # DIV for integer division: query I rowsort label-527 SELECT 57 + - 35 DIV + 35 FROM tab0 ---- 56 56 56 skipif mysql # not compatible query I rowsort label-527 SELECT 57 + - 35 / + 35 FROM tab0 ---- 56 56 56 query III rowsort SELECT * FROM tab1 WHERE NOT NULL > + col0 - col2 + - + col2 / - 50 + - col1 ---- query I rowsort SELECT DISTINCT - col2 + - col2 * 56 FROM tab1 ---- -3363 -3876 -5472 query II rowsort SELECT + 87 * col0 * - col1 AS col1, col0 AS col1 FROM tab2 ---- -204102 46 -428736 64 -437175 75 onlyif mysql # aggregate syntax: query I rowsort label-531 SELECT DISTINCT ( + COUNT( * ) ) * + + 38 FROM tab0 ---- 114 skipif mysql # not compatible query I rowsort label-531 SELECT DISTINCT ( + COUNT ( * ) ) * + + 38 FROM tab0 ---- 114 onlyif mysql # aggregate syntax: query I rowsort label-532 SELECT - MIN( - + col2 ) FROM tab0 ---- 99 skipif mysql # not compatible query I rowsort label-532 SELECT - MIN ( - + col2 ) FROM tab0 ---- 99 onlyif mysql # aggregate syntax: query I rowsort label-533 SELECT ALL SUM( - 21 ) FROM tab0 AS cor0 ---- -63 skipif mysql # not compatible query I rowsort label-533 SELECT ALL SUM ( - 21 ) FROM tab0 AS cor0 ---- -63 onlyif mysql # DIV for integer division: query I rowsort label-534 SELECT ( - - col1 ) + + col1 DIV ( + col1 ) FROM tab0 ---- 2 22 82 skipif mysql # not compatible query I rowsort label-534 SELECT ( - - col1 ) + + col1 / ( + col1 ) FROM tab0 ---- 2 22 82 query I rowsort SELECT col0 + - - 49 + - + col1 FROM tab1 ---- 129 86 93 query I rowsort SELECT - 27 + + col2 + + + col2 FROM tab1 AS cor0 ---- 109 165 91 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-537 SELECT ALL col2 - + col2 + - CAST( 62 AS SIGNED ) + + 88 * - 18 FROM tab2 AS cor0 ---- -1646 -1646 -1646 skipif mysql # not compatible query I rowsort label-537 SELECT ALL col2 - + col2 + - CAST ( 62 AS INTEGER ) + + 88 * - 18 FROM tab2 AS cor0 ---- -1646 -1646 -1646 query I rowsort SELECT 49 * + col1 * + + col2 AS col2 FROM tab2 AS cor0 ---- 150920 190414 57477 onlyif mysql # aggregate syntax: query I rowsort label-539 SELECT ALL - COUNT( * ) - - + COUNT( * ) FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NOT NULL ---- 0 skipif mysql # not compatible query I rowsort label-539 SELECT ALL - COUNT ( * ) - - + COUNT ( * ) FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NOT NULL ---- 0 onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-540 SELECT - - CAST( NULL AS DECIMAL ) * - + col1 + - col0 FROM tab1 AS cor0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-540 SELECT - - CAST ( NULL AS REAL ) * - + col1 + - col0 FROM tab1 AS cor0 ---- NULL NULL NULL onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-541 SELECT CAST( NULL AS DECIMAL ) * + col0 col2 FROM tab2 ---- NULL NULL NULL skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-541 SELECT CAST ( NULL AS REAL ) * + col0 col2 FROM tab2 ---- NULL NULL NULL onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-542 SELECT DISTINCT 27 + + - 29 + - CAST( - SUM( ALL + col1 ) AS SIGNED ) - 24 AS col0 FROM tab1 ---- 40 skipif mysql # not compatible query I rowsort label-542 SELECT DISTINCT 27 + + - 29 + - CAST ( - SUM ( ALL + col1 ) AS INTEGER ) - 24 AS col0 FROM tab1 ---- 40 onlyif mysql # aggregate syntax: query I rowsort label-543 SELECT + MIN( ALL - ( col2 ) ) * - 76 FROM tab2 ---- 4408 skipif mysql # not compatible query I rowsort label-543 SELECT + MIN ( ALL - ( col2 ) ) * - 76 FROM tab2 ---- 4408 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT DISTINCT + 89 * ( col0 ) col0 FROM tab1 ---- 4539 7565 8099 query III rowsort SELECT ALL * FROM tab2 AS cor0 WHERE NOT col1 + + col1 IS NOT NULL ---- query I rowsort SELECT DISTINCT + - 88 AS col0 FROM tab2 cor0 ---- -88 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL - - ( 7 ) col0 FROM tab1 AS cor0 ---- 7 7 7 onlyif mysql # aggregate syntax: query I rowsort label-548 SELECT ( + - MAX( + col1 ) ) FROM tab1 AS cor0 ---- -47 skipif mysql # not compatible query I rowsort label-548 SELECT ( + - MAX ( + col1 ) ) FROM tab1 AS cor0 ---- -47 query I rowsort SELECT - col1 * - col2 * - - 31 * - 45 * + + col1 AS col1 FROM tab2 ---- -330838200 -363204990 -83453085 onlyif mysql # DIV for integer division: query II rowsort label-550 SELECT DISTINCT ( - ( col0 ) ) DIV - col1 col0, - 17 AS col2 FROM tab2 ---- 0 -17 1 -17 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort label-550 SELECT DISTINCT ( - ( col0 ) ) / - col1 col0, - 17 AS col2 FROM tab2 ---- 0 -17 1 -17 onlyif mysql # CAST syntax: aggregate syntax: DECIMAL type: query I rowsort label-551 SELECT ALL MAX( DISTINCT - 22 ) + - MAX( ALL + + col0 ) FROM tab0 WHERE + + CAST( - col2 AS DECIMAL ) IS NULL ---- NULL skipif mysql # not compatible query I rowsort label-551 SELECT ALL MAX ( DISTINCT - 22 ) + - MAX ( ALL + + col0 ) FROM tab0 WHERE + + CAST ( - col2 AS REAL ) IS NULL ---- NULL query I rowsort SELECT + 13 * - + col0 FROM tab0 ---- -1131 -1261 -195 onlyif mysql # DIV for integer division: query I rowsort label-553 SELECT DISTINCT - col0 DIV - + 16 AS col2 FROM tab2 ---- 2 4 skipif mysql # not compatible query I rowsort label-553 SELECT DISTINCT - col0 / - + 16 AS col2 FROM tab2 ---- 2 4 query I rowsort SELECT + col0 * - 34 AS col2 FROM tab1 ---- -1734 -2890 -3094 query I rowsort SELECT DISTINCT + 24 AS col0 FROM tab1 AS cor0 CROSS JOIN tab1 AS cor1 ---- 24 query II rowsort SELECT DISTINCT - col2, + col1 + + 7 AS col0 FROM tab1 cor0 ---- -59 12 -68 54 -96 21 query II rowsort SELECT ALL col0, + col0 AS col2 FROM tab2 AS cor0 ---- 46 46 64 64 75 75 query I rowsort SELECT + col2 * + col0 AS col1 FROM tab2 AS cor0 WHERE NOT NULL IS NOT NULL ---- 1058 2560 4350 onlyif mysql # aggregate syntax: query I rowsort label-559 SELECT + + MIN( ALL + 36 ) col0 FROM tab2 AS cor0 ---- 36 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-559 SELECT + + MIN ( ALL + 36 ) col0 FROM tab2 AS cor0 ---- 36 query II rowsort SELECT ALL - col2, 21 * - 87 + ( + col0 ) * col0 AS col1 FROM tab2 AS cor0 ---- -23 289 -40 2269 -58 3798 query II rowsort SELECT 67 AS col2, - col1 FROM tab1 AS cor0 ---- 67 -14 67 -47 67 -5 onlyif mysql # aggregate syntax: query I rowsort label-562 SELECT ALL + 24 + COUNT( * ) AS col1 FROM tab1 AS cor0 ---- 27 skipif mysql # not compatible query I rowsort label-562 SELECT ALL + 24 + COUNT ( * ) AS col1 FROM tab1 AS cor0 ---- 27 query I rowsort SELECT DISTINCT + 56 + + - 86 AS col1 FROM tab0 ---- -30 onlyif mysql # aggregate syntax: query I rowsort label-564 SELECT ALL - COUNT( * ) FROM tab1 WHERE NOT ( ( + 15 ) > + col2 - - ( 46 ) ) OR NOT col0 + col2 * + col2 IS NULL ---- -3 skipif mysql # not compatible query I rowsort label-564 SELECT ALL - COUNT ( * ) FROM tab1 WHERE NOT ( ( + 15 ) > + col2 - - ( 46 ) ) OR NOT col0 + col2 * + col2 IS NULL ---- -3 query I rowsort SELECT DISTINCT + col1 + + ( col0 ) FROM tab1 ---- 138 65 90 onlyif mysql # aggregate syntax: query I rowsort label-566 SELECT - COUNT( 72 ) * - - COUNT( ALL - 75 ) + + COUNT( * ) FROM tab2 AS cor0 ---- -6 skipif mysql # not compatible query I rowsort label-566 SELECT - COUNT ( 72 ) * - - COUNT ( ALL - 75 ) + + COUNT ( * ) FROM tab2 AS cor0 ---- -6 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-567 SELECT - CAST( + - 56 AS SIGNED ) + - - col0 FROM tab1 cor0 ---- 107 141 147 skipif mysql # not compatible query I rowsort label-567 SELECT - CAST ( + - 56 AS INTEGER ) + - - col0 FROM tab1 cor0 ---- 107 141 147 onlyif mysql # aggregate syntax: query I rowsort label-568 SELECT + 35 + MIN( DISTINCT - col0 ) FROM tab2 cor0 ---- -40 skipif mysql # not compatible query I rowsort label-568 SELECT + 35 + MIN ( DISTINCT - col0 ) FROM tab2 cor0 ---- -40 query I rowsort SELECT DISTINCT - col2 + - 47 FROM tab1 ---- -106 -115 -143 query I rowsort SELECT DISTINCT + + col2 * + - col1 FROM tab0 WHERE - 96 * - 60 NOT BETWEEN - col0 + + + 80 AND NULL ---- query I rowsort SELECT ALL + 99 FROM ( tab1 AS cor0 CROSS JOIN tab1 AS cor1 ) ---- 9 values hashing to 4b77467dd5f346109d29f6364a7bb8db query I rowsort SELECT DISTINCT + + ( + - col0 ) + 27 AS col2 FROM tab1 AS cor0 ---- -24 -58 -64 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-573 SELECT CAST( + 50 AS SIGNED ) * - col2 FROM tab2 AS cor0 WHERE ( NULL ) = NULL ---- skipif mysql # not compatible query I rowsort label-573 SELECT CAST ( + 50 AS INTEGER ) * - col2 FROM tab2 AS cor0 WHERE ( NULL ) = NULL ---- onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-574 SELECT ALL + 59 - - CAST( NULL AS SIGNED ) + + col2 FROM tab0 AS cor0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-574 SELECT ALL + 59 - - CAST ( NULL AS INTEGER ) + + col2 FROM tab0 AS cor0 ---- NULL NULL NULL query II rowsort SELECT ALL - col1 - + + 65 AS col2, col1 FROM tab2 AS cor0 WHERE NOT NULL < 56 ---- query I rowsort SELECT + col0 - - col1 AS col0 FROM tab1 AS cor0 ---- 138 65 90 query II rowsort SELECT ALL + col2 AS col2, + col1 * col2 AS col2 FROM tab2 AS cor0 ---- 23 1173 40 3080 58 3886 query I rowsort SELECT - 19 + - 30 + 56 FROM tab1 AS cor0 ---- 7 7 7 query I rowsort SELECT ALL + - col0 * + 22 AS col1 FROM tab1 AS cor0 ---- -1122 -1870 -2002 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-580 SELECT DISTINCT CAST( 1 AS SIGNED ) * - ( + CAST( + ( + - col2 ) AS SIGNED ) ) FROM tab0 ---- 10 47 99 skipif mysql # not compatible query I rowsort label-580 SELECT DISTINCT CAST ( 1 AS INTEGER ) * - ( + CAST ( + ( + - col2 ) AS INTEGER ) ) FROM tab0 ---- 10 47 99 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT DISTINCT - - 20 - + + col0 + - ( + col0 ) col1 FROM tab2 WHERE NOT NULL IS NOT NULL ---- -108 -130 -72 query III rowsort SELECT * FROM tab2 WHERE NOT + + col0 - + + col1 IS NOT NULL ---- query III rowsort SELECT DISTINCT * FROM tab0 WHERE - + col0 > - 75 ---- 15 81 47 onlyif mysql # aggregate syntax: query I rowsort label-584 SELECT + COUNT( ALL - - col1 ) AS col0 FROM tab2 AS cor0 ---- 3 skipif mysql # not compatible query I rowsort label-584 SELECT + COUNT ( ALL - - col1 ) AS col0 FROM tab2 AS cor0 ---- 3 query II rowsort SELECT + col0 * - - col0 - + col1 + 48 + + 66 AS col1, col1 AS col2 FROM tab2 AS cor0 WHERE NOT NULL >= 23 ---- query III rowsort SELECT ALL * FROM tab0 AS cor0 WHERE NULL > 98 + - + col1 + - col1 ---- onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-587 SELECT MIN( - + CAST( NULL AS SIGNED ) ) FROM tab2 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-587 SELECT MIN ( - + CAST ( NULL AS INTEGER ) ) FROM tab2 AS cor0 ---- NULL onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-588 SELECT DISTINCT COUNT( * ) * - ( - - MIN( DISTINCT - - col2 ) ) + + CAST( NULL AS SIGNED ) AS col2 FROM tab2 cor0 ---- NULL skipif mysql # not compatible query I rowsort label-588 SELECT DISTINCT COUNT ( * ) * - ( - - MIN ( DISTINCT - - col2 ) ) + + CAST ( NULL AS INTEGER ) AS col2 FROM tab2 cor0 ---- NULL onlyif mysql # aggregate syntax: query I rowsort label-589 SELECT - COUNT( * ) * + + 5 FROM tab0 ---- -15 skipif mysql # not compatible query I rowsort label-589 SELECT - COUNT ( * ) * + + 5 FROM tab0 ---- -15 query I rowsort SELECT + col2 * - col2 * + col1 * 39 FROM tab0 ---- -382239 -6978231 -81900 onlyif mysql # aggregate syntax: query I rowsort label-591 SELECT DISTINCT - COUNT( - 73 ) FROM tab2 cor0 CROSS JOIN tab1 AS cor1 ---- -9 skipif mysql # not compatible query I rowsort label-591 SELECT DISTINCT - COUNT ( - 73 ) FROM tab2 cor0 CROSS JOIN tab1 AS cor1 ---- -9 query I rowsort SELECT ALL col2 * + col0 * + 87 AS col1 FROM tab2 AS cor0 ---- 222720 378450 92046 query I rowsort SELECT - + 99 FROM tab0 cor0 ---- -99 -99 -99 onlyif mysql # aggregate syntax: query II rowsort label-594 SELECT COUNT( * ), 3 col1 FROM tab2 AS cor0 ---- 3 3 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort label-594 SELECT COUNT ( * ), 3 col1 FROM tab2 AS cor0 ---- 3 3 query I rowsort SELECT - 72 + - col2 * ( + 17 ) FROM tab1 AS cor0 ---- -1075 -1228 -1704 query I rowsort SELECT ALL ( + col1 ) * col1 AS col2 FROM tab1 AS cor0 ---- 196 2209 25 query I rowsort SELECT + 77 + - - col2 FROM tab0 cor0 ---- 124 176 87 onlyif mysql # DIV for integer division: query I rowsort label-598 SELECT DISTINCT - col2 DIV + + col0 FROM tab1 cor0 ---- -1 0 skipif mysql # not compatible query I rowsort label-598 SELECT DISTINCT - col2 / + + col0 FROM tab1 cor0 ---- -1 0 query III rowsort SELECT * FROM tab0 AS cor0 WHERE col1 * - col1 <= - col2 ---- 15 81 47 87 21 10 query I rowsort SELECT DISTINCT + col2 AS col1 FROM tab0 AS cor0 WHERE col2 + + - col1 NOT BETWEEN NULL AND NULL ---- query III rowsort SELECT ALL * FROM tab2 AS cor0 WHERE - 15 IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-602 SELECT ALL - MAX( ALL - col2 ) AS col1 FROM tab1 WHERE NULL IS NOT NULL ---- NULL skipif mysql # not compatible query I rowsort label-602 SELECT ALL - MAX ( ALL - col2 ) AS col1 FROM tab1 WHERE NULL IS NOT NULL ---- NULL onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-603 SELECT DISTINCT col0 + - 53 - - col0 * + col0 + + + col1 * + CAST( NULL AS SIGNED ), col1 AS col0 FROM tab2 ---- NULL 51 NULL 67 NULL 77 skipif mysql # not compatible query II rowsort label-603 SELECT DISTINCT col0 + - 53 - - col0 * + col0 + + + col1 * + CAST ( NULL AS INTEGER ), col1 AS col0 FROM tab2 ---- NULL 51 NULL 67 NULL 77 query I rowsort SELECT - ( - 97 ) + - col0 AS col1 FROM tab2 ---- 22 33 51 query I rowsort SELECT ALL - col1 / + col2 FROM tab1 WHERE + - 69 * 59 - - 6 IS NULL ---- query I rowsort SELECT ALL + 52 FROM tab0, tab1 AS cor0 ---- 9 values hashing to 7f4ae30893ab330784829711032ae599 query I rowsort SELECT - 20 FROM tab0 WHERE NULL IS NOT NULL ---- onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-608 SELECT DISTINCT * FROM tab2 WHERE NOT NULL NOT BETWEEN CAST( - col1 AS SIGNED ) AND col0 * 74 - + col1 + - col2 / + 13 / - 94 ---- skipif mysql # not compatible query III rowsort label-608 SELECT DISTINCT * FROM tab2 WHERE NOT NULL NOT BETWEEN CAST ( - col1 AS INTEGER ) AND col0 * 74 - + col1 + - col2 / + 13 / - 94 ---- query II rowsort SELECT + 21 AS col1, col0 * ( - + col2 ) FROM tab2 ---- 21 -1058 21 -2560 21 -4350 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-610 SELECT ALL CAST( NULL AS SIGNED ) + + 81 AS col2 FROM tab2 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-610 SELECT ALL CAST ( NULL AS INTEGER ) + + 81 AS col2 FROM tab2 ---- NULL NULL NULL query I rowsort SELECT + 93 * + ( col2 ) FROM tab2 ---- 2139 3720 5394 onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-612 SELECT ALL - 47 + - col2 * + CAST( NULL AS DECIMAL ) * - col1 AS col2 FROM tab2 AS cor0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-612 SELECT ALL - 47 + - col2 * + CAST ( NULL AS REAL ) * - col1 AS col2 FROM tab2 AS cor0 ---- NULL NULL NULL query II rowsort SELECT + + col0 - col2, col0 AS col0 FROM tab2 AS cor0 ---- 17 75 23 46 24 64 query I rowsort SELECT ALL - col0 * + col2 * - col0 - - col2 FROM tab1 ---- 249792 426334 563176 query I rowsort SELECT + + 33 AS col1 FROM tab2 AS cor0 CROSS JOIN tab1 cor1 ---- 9 values hashing to 620d384286e82d1c6c8b1b2b109a7da5 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-616 SELECT col1 + - 19 + CAST( + 82 AS SIGNED ) AS col1 FROM tab2 ---- 114 130 140 skipif mysql # not compatible query I rowsort label-616 SELECT col1 + - 19 + CAST ( + 82 AS INTEGER ) AS col1 FROM tab2 ---- 114 130 140 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT + ( 60 ) col2 FROM tab0 AS cor0 ---- 60 60 60 onlyif mysql # aggregate syntax: query I rowsort label-618 SELECT ALL + + COUNT( * ) * ( + - 1 ) FROM tab0 AS cor0 ---- -3 skipif mysql # not compatible query I rowsort label-618 SELECT ALL + + COUNT ( * ) * ( + - 1 ) FROM tab0 AS cor0 ---- -3 query I rowsort SELECT DISTINCT - col2 AS col2 FROM tab2 AS cor0 WHERE NOT NULL IS NOT NULL ---- -23 -40 -58 query I rowsort SELECT DISTINCT - col1 * 32 FROM tab0 AS cor0 ---- -2592 -32 -672 query II rowsort SELECT + 43 AS col0, + col0 AS col2 FROM tab1 ---- 43 51 43 85 43 91 query II rowsort SELECT 92 AS col0, col2 FROM tab2 ---- 92 23 92 40 92 58 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-623 SELECT ALL - CAST( + col0 AS SIGNED ) AS col0 FROM tab2 ---- -46 -64 -75 skipif mysql # not compatible query I rowsort label-623 SELECT ALL - CAST ( + col0 AS INTEGER ) AS col0 FROM tab2 ---- -46 -64 -75 onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: query III rowsort label-624 SELECT * FROM tab1 WHERE NOT - + 51 - - CAST( NULL AS SIGNED ) >= + CAST( NULL AS DECIMAL ) ---- skipif mysql # not compatible query III rowsort label-624 SELECT * FROM tab1 WHERE NOT - + 51 - - CAST ( NULL AS INTEGER ) >= + CAST ( NULL AS REAL ) ---- query III rowsort SELECT DISTINCT * FROM tab1 WHERE NOT col2 + - + 24 IS NOT NULL ---- query III rowsort SELECT DISTINCT * FROM tab0 AS cor0 WHERE + 75 IN ( + 39 + ( + col2 ) - 32, - 68 ) ---- onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-627 SELECT col1, 70 FROM tab1 AS cor0 WHERE NOT + CAST( NULL AS SIGNED ) <= - + 87 * - - col2 * + CAST( NULL AS SIGNED ) ---- skipif mysql # not compatible query II rowsort label-627 SELECT col1, 70 FROM tab1 AS cor0 WHERE NOT + CAST ( NULL AS INTEGER ) <= - + 87 * - - col2 * + CAST ( NULL AS INTEGER ) ---- query II rowsort SELECT + col1, col2 AS col0 FROM tab2 cor0 ---- 51 23 67 58 77 40 query II rowsort SELECT - 10 AS col0, col2 AS col1 FROM tab2 AS cor0 ---- -10 23 -10 40 -10 58 onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-630 SELECT ALL - CAST( - col0 AS SIGNED ) * - col2 * + col2 * + col2 AS col2, 28 * - col1 FROM tab1 AS cor0 ---- -17457215 -140 -28613312 -1316 -45121536 -392 skipif mysql # not compatible query II rowsort label-630 SELECT ALL - CAST ( - col0 AS INTEGER ) * - col2 * + col2 * + col2 AS col2, 28 * - col1 FROM tab1 AS cor0 ---- -17457215 -140 -28613312 -1316 -45121536 -392 onlyif mysql # DIV for integer division: query I rowsort label-631 SELECT DISTINCT + + col2 DIV - 64 FROM tab2 AS cor0 ---- 0 skipif mysql # not compatible query I rowsort label-631 SELECT DISTINCT + + col2 / - 64 FROM tab2 AS cor0 ---- 0 onlyif mysql # aggregate syntax: query I rowsort label-632 SELECT - + 55 * + - MIN( + col0 ) FROM tab2 AS cor0 ---- 2530 skipif mysql # not compatible query I rowsort label-632 SELECT - + 55 * + - MIN ( + col0 ) FROM tab2 AS cor0 ---- 2530 query III rowsort SELECT DISTINCT * FROM tab0 WHERE NULL IN ( col2 * + col1 + + col2, col1 ) ---- query I rowsort SELECT + 90 - - 31 FROM tab0 ---- 121 121 121 query I rowsort SELECT ALL + 61 + - + col1 FROM tab2 ---- -16 -6 10 onlyif mysql # aggregate syntax: query I rowsort label-636 SELECT ALL - + COUNT( ALL - 99 ) AS col0 FROM tab0 AS cor0 ---- -3 skipif mysql # not compatible query I rowsort label-636 SELECT ALL - + COUNT ( ALL - 99 ) AS col0 FROM tab0 AS cor0 ---- -3 onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-637 SELECT - - CAST( NULL AS DECIMAL ) AS col1 FROM tab0 AS cor0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-637 SELECT - - CAST ( NULL AS REAL ) AS col1 FROM tab0 AS cor0 ---- NULL NULL NULL query I rowsort SELECT ALL + col1 + - col2 * - ( - 1 ) AS col2 FROM tab1 AS cor0 ---- -21 -54 -82 skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort SELECT - col0 col2, col2 AS col2 FROM tab2 ---- -46 23 -64 40 -75 58 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL + 24 + col2 col0 FROM tab0 ---- 123 34 71 query I rowsort SELECT 36 * - 58 FROM tab2 AS cor0 CROSS JOIN tab2 AS cor1 ---- 9 values hashing to 58e9f3902c238258a25fa87e37d76735 onlyif mysql # CAST syntax: DECIMAL type: query II rowsort label-642 SELECT DISTINCT 14 AS col1, CAST( NULL AS DECIMAL ) col2 FROM tab0 ---- 14 NULL skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort label-642 SELECT DISTINCT 14 AS col1, CAST ( NULL AS REAL ) col2 FROM tab0 ---- 14 NULL onlyif mysql # aggregate syntax: query I rowsort label-643 SELECT MAX( col1 ) AS col2 FROM tab0 AS cor0 ---- 81 skipif mysql # not compatible query I rowsort label-643 SELECT MAX ( col1 ) AS col2 FROM tab0 AS cor0 ---- 81 query II rowsort SELECT DISTINCT - + 62, 93 AS col2 FROM tab0 AS cor0 ---- -62 93 query II rowsort SELECT col0, ( - col1 ) * + col1 * - - 55 + col0 FROM tab0 AS cor0 ---- 15 -360840 87 -24168 97 42 query III rowsort SELECT ALL * FROM tab2 AS cor0 WHERE - 57 < NULL ---- query II rowsort SELECT - - 11, col2 FROM tab1 AS cor0 ---- 11 59 11 68 11 96 onlyif mysql # aggregate syntax: query I rowsort label-648 SELECT ALL COUNT( * ) * ( + 60 ) FROM tab2 AS cor0 ---- 180 skipif mysql # not compatible query I rowsort label-648 SELECT ALL COUNT ( * ) * ( + 60 ) FROM tab2 AS cor0 ---- 180 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT - 45 * + col1 col0 FROM tab0 AS cor0 ---- -3645 -45 -945 onlyif mysql # aggregate syntax: query II rowsort label-650 SELECT - COUNT( * ), - 0 AS col2 FROM tab1 AS cor0 ---- -3 0 skipif mysql # not compatible query II rowsort label-650 SELECT - COUNT ( * ), - 0 AS col2 FROM tab1 AS cor0 ---- -3 0 query I rowsort SELECT - 76 * + col0 FROM tab2 ---- -3496 -4864 -5700 onlyif mysql # aggregate syntax: query I rowsort label-652 SELECT DISTINCT 2 * SUM( ALL 95 ) FROM tab2, tab0 AS cor0 ---- 1710 skipif mysql # not compatible query I rowsort label-652 SELECT DISTINCT 2 * SUM ( ALL 95 ) FROM tab2, tab0 AS cor0 ---- 1710 query I rowsort SELECT ALL col0 * 30 * 39 FROM tab2 ---- 53820 74880 87750 onlyif mysql # aggregate syntax: query I rowsort label-654 SELECT DISTINCT - ( - MIN( - - col0 ) ) col2 FROM tab0 ---- 15 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-654 SELECT DISTINCT - ( - MIN ( - - col0 ) ) col2 FROM tab0 ---- 15 query II rowsort SELECT DISTINCT 57 AS col1, - 78 * - col1 FROM tab1 ---- 57 1092 57 3666 57 390 query I rowsort SELECT ALL + 22 * + col1 FROM tab0 ---- 1782 22 462 query III rowsort SELECT * FROM tab2 WHERE NOT NULL <> col2 AND col2 IS NOT NULL ---- query I rowsort SELECT + 57 + 88 AS col1 FROM tab1 AS cor0 ---- 145 145 145 onlyif mysql # aggregate syntax: query I rowsort label-659 SELECT DISTINCT + + 10 * + MAX( ALL ( col0 ) ) FROM tab2 cor0 ---- 750 skipif mysql # not compatible query I rowsort label-659 SELECT DISTINCT + + 10 * + MAX ( ALL ( col0 ) ) FROM tab2 cor0 ---- 750 query I rowsort SELECT DISTINCT + - 82 FROM tab0 AS cor0 WHERE NOT + col2 NOT BETWEEN + 86 / - + col2 * + col1 AND + - col0 ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query II rowsort SELECT ALL col1 + - col2 col2, col1 AS col0 FROM tab1 ---- -21 47 -54 5 -82 14 onlyif mysql # DIV for integer division: query I rowsort label-662 SELECT 72 DIV ( col2 ) FROM tab2 ---- 1 1 3 skipif mysql # not compatible query I rowsort label-662 SELECT 72 / ( col2 ) FROM tab2 ---- 1 1 3 query I rowsort SELECT DISTINCT 35 + - col0 FROM tab0 ---- -52 -62 20 query I rowsort SELECT - + col0 * 8 / + col0 AS col0 FROM tab1 WHERE + + 13 < - 75 + - + col1 + + + col0 ---- onlyif mysql # aggregate syntax: query I rowsort label-665 SELECT ALL + - SUM( - 84 ) - + 92 FROM tab0 AS cor0 ---- 160 skipif mysql # not compatible query I rowsort label-665 SELECT ALL + - SUM ( - 84 ) - + 92 FROM tab0 AS cor0 ---- 160 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT 79 col0 FROM tab0 AS cor0 WHERE NULL IS NOT NULL ---- query I rowsort SELECT ALL - + col2 - - + col1 AS col0 FROM tab1 cor0 ---- -21 -54 -82 onlyif mysql # DIV for integer division: query I rowsort label-668 SELECT DISTINCT - 33 DIV - col1 FROM tab2 ---- 0 skipif mysql # not compatible query I rowsort label-668 SELECT DISTINCT - 33 / - col1 FROM tab2 ---- 0 query I rowsort SELECT 74 + + 11 + col2 FROM tab0 AS cor0 WHERE NOT NULL IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-670 SELECT DISTINCT + + SUM( - col0 ) col1 FROM tab2 AS cor0 ---- -185 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-670 SELECT DISTINCT + + SUM ( - col0 ) col1 FROM tab2 AS cor0 ---- -185 query II rowsort SELECT DISTINCT col0, col1 AS col2 FROM tab0 ---- 15 81 87 21 97 1 onlyif mysql # aggregate syntax: query I rowsort label-672 SELECT - COUNT( * ) * - 15 FROM tab2 ---- 45 skipif mysql # not compatible query I rowsort label-672 SELECT - COUNT ( * ) * - 15 FROM tab2 ---- 45 query I rowsort SELECT + 92 * 48 FROM tab0 ---- 4416 4416 4416 onlyif mysql # aggregate syntax: query II rowsort label-674 SELECT ALL COUNT( * ) AS col1, MAX( - - col0 ) FROM tab2 ---- 3 75 skipif mysql # not compatible query II rowsort label-674 SELECT ALL COUNT ( * ) AS col1, MAX ( - - col0 ) FROM tab2 ---- 3 75 onlyif mysql # aggregate syntax: query I rowsort label-675 SELECT MAX( DISTINCT + + col2 ) * 28 * - 96 AS col0 FROM tab0 AS cor0 WHERE ( - 35 * col0 * + 60 * + - col2 + + 58 IS NULL ) ---- NULL skipif mysql # not compatible query I rowsort label-675 SELECT MAX ( DISTINCT + + col2 ) * 28 * - 96 AS col0 FROM tab0 AS cor0 WHERE ( - 35 * col0 * + 60 * + - col2 + + 58 IS NULL ) ---- NULL query III rowsort SELECT ALL * FROM tab2 AS cor0 WHERE NULL <> + 86 * - col1 ---- onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-677 SELECT - + col1 + - - col0 + - CAST( NULL AS SIGNED ) FROM tab1 AS cor0 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-677 SELECT - + col1 + - - col0 + - CAST ( NULL AS INTEGER ) FROM tab1 AS cor0 ---- NULL NULL NULL onlyif mysql # DIV for integer division: query I rowsort label-678 SELECT + col0 + + col0 DIV col0 AS col1 FROM tab2 ---- 47 65 76 skipif mysql # not compatible query I rowsort label-678 SELECT + col0 + + col0 / col0 AS col1 FROM tab2 ---- 47 65 76 onlyif mysql # DIV for integer division: query I rowsort label-679 SELECT - col2 - col0 DIV col0 FROM tab0 cor0 ---- -100 -11 -48 skipif mysql # not compatible query I rowsort label-679 SELECT - col2 - col0 / col0 FROM tab0 cor0 ---- -100 -11 -48 onlyif mysql # DIV for integer division: query I rowsort label-680 SELECT + col1 DIV col1 * col0 + + 32 - - - col2 AS col0 FROM tab0 AS cor0 ---- 0 109 30 skipif mysql # not compatible query I rowsort label-680 SELECT + col1 / col1 * col0 + + 32 - - - col2 AS col0 FROM tab0 AS cor0 ---- 0 109 30 onlyif mysql # aggregate syntax: DIV for integer division: query I rowsort label-681 SELECT - 90 - - COUNT( * ) + + COUNT( * ) + - + COUNT( * ) DIV + 60 FROM tab0 AS cor0 ---- -84 skipif mysql # not compatible query I rowsort label-681 SELECT - 90 - - COUNT ( * ) + + COUNT ( * ) + - + COUNT ( * ) / + 60 FROM tab0 AS cor0 ---- -84 query I rowsort SELECT 92 + col2 AS col2 FROM tab0 ---- 102 139 191 onlyif mysql # aggregate syntax: query I rowsort label-683 SELECT ALL COUNT( * ) + + - COUNT( + col1 ) AS col0 FROM tab1 ---- 0 skipif mysql # not compatible query I rowsort label-683 SELECT ALL COUNT ( * ) + + - COUNT ( + col1 ) AS col0 FROM tab1 ---- 0 query I rowsort SELECT ALL col2 * 5 FROM tab0 WHERE ( 34 + 33 IS NULL ) ---- query II rowsort SELECT - ( ( 13 ) ), + col1 FROM tab1 AS cor0 ---- -13 14 -13 47 -13 5 query III rowsort SELECT ALL * FROM tab0 AS cor0 WHERE NOT 21 = NULL ---- query I rowsort SELECT 61 FROM tab2 WHERE + 61 * ( - col0 ) IS NOT NULL ---- 61 61 61 query I rowsort SELECT ALL + col2 * + col1 FROM tab1 WHERE NULL NOT IN ( 75 + - 76 ) ---- query I rowsort SELECT DISTINCT 56 * - 52 FROM tab0 WHERE 87 / + 19 + col0 * col0 IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-690 SELECT COUNT( * ) FROM tab0 WHERE NOT ( NULL ) >= ( col0 ) ---- 0 skipif mysql # not compatible query I rowsort label-690 SELECT COUNT ( * ) FROM tab0 WHERE NOT ( NULL ) >= ( col0 ) ---- 0 onlyif mysql # aggregate syntax: DIV for integer division: query I rowsort label-691 SELECT ALL ( 80 ) + MAX( DISTINCT - col1 + col2 ) DIV COUNT( * ) FROM tab2 ---- 77 skipif mysql # not compatible query I rowsort label-691 SELECT ALL ( 80 ) + MAX ( DISTINCT - col1 + col2 ) / COUNT ( * ) FROM tab2 ---- 77 onlyif mysql # aggregate syntax: query I rowsort label-692 SELECT ( + MAX( DISTINCT col2 ) ) AS col1 FROM tab1 ---- 96 skipif mysql # not compatible query I rowsort label-692 SELECT ( + MAX ( DISTINCT col2 ) ) AS col1 FROM tab1 ---- 96 onlyif mysql # aggregate syntax: query I rowsort label-693 SELECT + COUNT( DISTINCT + 14 ) + MIN( 46 ) col0 FROM tab2 WHERE - col1 + col0 IN ( - col2 + 19 ) ---- NULL skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-693 SELECT + COUNT ( DISTINCT + 14 ) + MIN ( 46 ) col0 FROM tab2 WHERE - col1 + col0 IN ( - col2 + 19 ) ---- NULL query III rowsort SELECT ALL * FROM tab0 WHERE NOT col2 * col0 IN ( + col2 * col0 + - col0 ) ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 query I rowsort SELECT ALL + ( - col1 ) FROM tab2 WHERE NOT col0 / col0 IS NOT NULL ---- query I rowsort SELECT + col0 AS col1 FROM tab2 WHERE NOT NULL IS NOT NULL ---- 46 64 75 query I rowsort SELECT ALL - col2 - 75 * col1 FROM tab1 ---- -1146 -3593 -434 query III rowsort SELECT ALL * FROM tab0 WHERE - 78 BETWEEN ( 66 ) AND - ( - col0 ) ---- query III rowsort SELECT * FROM tab0 WHERE - col1 * - col0 IS NOT NULL ---- 9 values hashing to c4b42765dff94eaaa46040e537fb43b7 query I rowsort SELECT 7 + - col0 FROM tab2 WHERE NULL IS NOT NULL ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT + 91 col0 FROM tab1 ---- 91 91 91 query I rowsort SELECT 79 + + 77 AS col2 FROM tab2 ---- 156 156 156 query I rowsort SELECT ALL - col1 FROM tab0 WHERE - col0 * - col1 + - col0 * col2 IS NULL ---- query III rowsort SELECT DISTINCT * FROM tab2 AS cor0 WHERE NOT + col2 * - col1 + + col2 NOT IN ( col0 / + 20 ) ---- query I rowsort SELECT + col1 FROM tab0 WHERE - col2 * + col1 IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-706 SELECT + MAX( DISTINCT + col0 ) + COUNT( * ) AS col1 FROM tab2 ---- 78 skipif mysql # not compatible query I rowsort label-706 SELECT + MAX ( DISTINCT + col0 ) + COUNT ( * ) AS col1 FROM tab2 ---- 78 query I rowsort SELECT - col1 + - 34 * - col1 FROM tab2 ---- 1683 2211 2541 onlyif mysql # aggregate syntax: query I rowsort label-708 SELECT ALL COUNT( * ) * - 48 AS col0 FROM tab0 WHERE ( col2 ) IS NOT NULL ---- -144 skipif mysql # not compatible query I rowsort label-708 SELECT ALL COUNT ( * ) * - 48 AS col0 FROM tab0 WHERE ( col2 ) IS NOT NULL ---- -144 query IIIIII rowsort SELECT DISTINCT * FROM ( tab1 cor0 CROSS JOIN tab1 ) ---- 54 values hashing to 375f372843089b03f23b00160007527a onlyif mysql # aggregate syntax: query I rowsort label-710 SELECT COUNT( * ) + - ( 33 ) AS col2 FROM tab2 ---- -30 skipif mysql # not compatible query I rowsort label-710 SELECT COUNT ( * ) + - ( 33 ) AS col2 FROM tab2 ---- -30 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-711 SELECT ALL + col1 * + CAST( - ( - 85 ) AS SIGNED ) AS col0 FROM tab1 AS cor0 ---- 1190 3995 425 skipif mysql # not compatible query I rowsort label-711 SELECT ALL + col1 * + CAST ( - ( - 85 ) AS INTEGER ) AS col0 FROM tab1 AS cor0 ---- 1190 3995 425 query I rowsort SELECT DISTINCT + col0 * - 76 FROM tab1 AS cor0 ---- -3876 -6460 -6916 onlyif mysql # aggregate syntax: query I rowsort label-713 SELECT + + SUM( DISTINCT col1 ) + - ( 58 ) FROM tab2 AS cor0 ---- 137 skipif mysql # not compatible query I rowsort label-713 SELECT + + SUM ( DISTINCT col1 ) + - ( 58 ) FROM tab2 AS cor0 ---- 137 query I rowsort SELECT col2 * + col0 AS col2 FROM tab0 AS cor0 WHERE NULL BETWEEN ( + col1 ) AND + 57 ---- onlyif mysql # DIV for integer division: query I rowsort label-715 SELECT DISTINCT + col0 DIV 4 - - col1 * col0 FROM tab1 AS cor0 ---- 4299 446 726 skipif mysql # not compatible query I rowsort label-715 SELECT DISTINCT + col0 / 4 - - col1 * col0 FROM tab1 AS cor0 ---- 4299 446 726 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL - col2 col1 FROM tab2 AS cor0 WHERE NOT - col1 <> + col1 ---- query I rowsort SELECT + col2 FROM tab1 AS cor0 WHERE ( col1 + - 98 * + col2 ) > NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-718 SELECT ALL ( + COUNT( * ) ) * 19 FROM tab2 cor0 ---- 57 skipif mysql # not compatible query I rowsort label-718 SELECT ALL ( + COUNT ( * ) ) * 19 FROM tab2 cor0 ---- 57 query I rowsort SELECT DISTINCT + col0 + 45 FROM tab1 AS cor0 ---- 130 136 96 query III rowsort SELECT ALL * FROM tab1 WHERE NOT col2 * 78 + - col0 BETWEEN NULL AND ( + col2 ) ---- 9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad query III rowsort SELECT * FROM tab1 WHERE - 93 NOT BETWEEN NULL AND - col2 ---- 51 14 96 onlyif mysql # CAST syntax: DECIMAL type: query I rowsort label-722 SELECT DISTINCT CAST( NULL AS DECIMAL ) * col1 AS col2 FROM tab1 ---- NULL skipif mysql # not compatible query I rowsort label-722 SELECT DISTINCT CAST ( NULL AS REAL ) * col1 AS col2 FROM tab1 ---- NULL query III rowsort SELECT ALL * FROM tab0 WHERE ( col0 + - 92 * col1 ) < NULL ---- query I rowsort SELECT ALL - col2 + - + 88 AS col0 FROM tab2 ---- -111 -128 -146 query I rowsort SELECT ALL 48 + - col2 AS col0 FROM tab0 ---- -51 1 38 query I rowsort SELECT - col1 - - + 70 AS col0 FROM tab1 ---- 23 56 65 onlyif mysql # DIV for integer division: query I rowsort label-727 SELECT 22 * + ( col0 ) - col1 DIV - col2 FROM tab2 ---- 1014 1409 1651 skipif mysql # not compatible query I rowsort label-727 SELECT 22 * + ( col0 ) - col1 / - col2 FROM tab2 ---- 1014 1409 1651 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-728 SELECT ALL - col0 + + CAST( NULL AS SIGNED ) - + col0 FROM tab1 ---- NULL NULL NULL skipif mysql # not compatible query I rowsort label-728 SELECT ALL - col0 + + CAST ( NULL AS INTEGER ) - + col0 FROM tab1 ---- NULL NULL NULL onlyif mysql # aggregate syntax: query I rowsort label-729 SELECT DISTINCT + + COUNT( * ) * 92 * - 91 AS col0 FROM tab1 cor0 ---- -25116 skipif mysql # not compatible query I rowsort label-729 SELECT DISTINCT + + COUNT ( * ) * 92 * - 91 AS col0 FROM tab1 cor0 ---- -25116 query I rowsort SELECT ALL 95 AS col1 FROM tab0 AS cor0 WHERE NOT + col1 * + col0 IS NULL ---- 95 95 95 onlyif mysql # aggregate syntax: query I rowsort label-731 SELECT DISTINCT 21 + + COUNT( * ) AS col2 FROM tab2 WHERE NULL IS NULL ---- 24 skipif mysql # not compatible query I rowsort label-731 SELECT DISTINCT 21 + + COUNT ( * ) AS col2 FROM tab2 WHERE NULL IS NULL ---- 24 query II rowsort SELECT DISTINCT col0, col2 + + col1 - col2 * col1 FROM tab0 ---- 15 -3679 87 -179 97 1 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-733 SELECT ALL + CAST( + col0 AS SIGNED ) col0 FROM tab0 ---- 15 87 97 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-733 SELECT ALL + CAST ( + col0 AS INTEGER ) col0 FROM tab0 ---- 15 87 97 onlyif mysql # aggregate syntax: query I rowsort label-734 SELECT ALL SUM( - ( - 66 ) ) FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1 ---- 594 skipif mysql # not compatible query I rowsort label-734 SELECT ALL SUM ( - ( - 66 ) ) FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1 ---- 594 query III rowsort SELECT * FROM tab1 WHERE NOT + 7 > ( - 71 * 95 - 84 ) ---- skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL + - col2 * - col0 * col0 * - col1 col0 FROM tab0 cor0 ---- -1589490 -856575 -931491 onlyif mysql # aggregate syntax: query I rowsort label-737 SELECT ALL + - SUM( ALL - col2 ) FROM tab0 cor0 ---- 156 skipif mysql # not compatible query I rowsort label-737 SELECT ALL + - SUM ( ALL - col2 ) FROM tab0 cor0 ---- 156 onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-738 SELECT DISTINCT col0 * CAST( 62 AS SIGNED ) * 18 - - col0 FROM tab2 AS cor0 ---- 51382 71488 83775 skipif mysql # not compatible query I rowsort label-738 SELECT DISTINCT col0 * CAST ( 62 AS INTEGER ) * 18 - - col0 FROM tab2 AS cor0 ---- 51382 71488 83775 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL + ( - col2 ) * - - col2 col1 FROM tab0 AS cor0 ---- -100 -2209 -9801 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT - col0 * + + 83 * - - 69 col2 FROM tab1 AS cor0 ---- -292077 -486795 -521157 onlyif mysql # aggregate syntax: query I rowsort label-741 SELECT ALL MIN( ALL 87 ) AS col1 FROM tab1 AS cor0 WHERE ( col2 / - ( - col1 ) + col1 ) NOT IN ( 45 ) ---- 87 skipif mysql # not compatible query I rowsort label-741 SELECT ALL MIN ( ALL 87 ) AS col1 FROM tab1 AS cor0 WHERE ( col2 / - ( - col1 ) + col1 ) NOT IN ( 45 ) ---- 87 onlyif mysql # aggregate syntax: query I rowsort label-742 SELECT - 65 * + + COUNT( * ) * + + 23 * - COUNT( * ) * 63 FROM tab0 ---- 847665 skipif mysql # not compatible query I rowsort label-742 SELECT - 65 * + + COUNT ( * ) * + + 23 * - COUNT ( * ) * 63 FROM tab0 ---- 847665 onlyif mysql # aggregate syntax: query I rowsort label-743 SELECT DISTINCT COUNT( DISTINCT col2 ) AS col1 FROM tab1 WHERE NOT ( 17 ) NOT BETWEEN 8 AND ( col0 ) * col2 ---- 3 skipif mysql # not compatible query I rowsort label-743 SELECT DISTINCT COUNT ( DISTINCT col2 ) AS col1 FROM tab1 WHERE NOT ( 17 ) NOT BETWEEN 8 AND ( col0 ) * col2 ---- 3 skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort SELECT ALL - - 85 + col0 col0 FROM tab1 WHERE NOT - 30 IS NOT NULL ---- onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-745 SELECT * FROM tab1 WHERE ( ( col2 ) ) < CAST( + col2 AS SIGNED ) ---- skipif mysql # not compatible query III rowsort label-745 SELECT * FROM tab1 WHERE ( ( col2 ) ) < CAST ( + col2 AS INTEGER ) ---- query I rowsort SELECT - col2 AS col0 FROM tab0 WHERE NULL <= + - col0 ---- query I rowsort SELECT col1 + - + 61 * col0 AS col1 FROM tab1 AS cor0 ---- -3097 -5180 -5504 onlyif mysql # aggregate syntax: query I rowsort label-748 SELECT 71 * - - COUNT( * ) + MAX( DISTINCT + col1 ) AS col1 FROM tab0 AS cor0 ---- 294 skipif mysql # not compatible query I rowsort label-748 SELECT 71 * - - COUNT ( * ) + MAX ( DISTINCT + col1 ) AS col1 FROM tab0 AS cor0 ---- 294 onlyif mysql # aggregate syntax: query II rowsort label-749 SELECT + COUNT( * ) AS col2, + 99 AS col2 FROM tab1 cor0 WHERE NULL IS NOT NULL ---- 0 99 skipif mysql # not compatible query II rowsort label-749 SELECT + COUNT ( * ) AS col2, + 99 AS col2 FROM tab1 cor0 WHERE NULL IS NOT NULL ---- 0 99 query III rowsort SELECT * FROM tab2 WHERE + 85 IS NULL ---- onlyif mysql # aggregate syntax: query I rowsort label-751 SELECT ALL - + ( - 12 ) * - + COUNT( * ) FROM tab2 AS cor0 CROSS JOIN tab2 cor1 ---- -108 skipif mysql # not compatible query I rowsort label-751 SELECT ALL - + ( - 12 ) * - + COUNT ( * ) FROM tab2 AS cor0 CROSS JOIN tab2 cor1 ---- -108 query I rowsort SELECT + 51 FROM tab1 cor0 CROSS JOIN tab0 AS cor1 WHERE NOT ( NULL ) IS NOT NULL ---- 9 values hashing to d8bf0a05c9c4d2a93812d106baae4752 onlyif mysql # aggregate syntax: query I rowsort label-753 SELECT ALL MAX( DISTINCT - + col1 ) FROM tab2 AS cor0 ---- -51 skipif mysql # not compatible query I rowsort label-753 SELECT ALL MAX ( DISTINCT - + col1 ) FROM tab2 AS cor0 ---- -51 query I rowsort SELECT - col2 AS col1 FROM tab2 AS cor0 WHERE col2 < ( 81 / - col2 + - + col1 ) ---- onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-755 SELECT - 70 - + - 69 + - COUNT( * ) * CAST( COUNT( * ) AS SIGNED ) - MIN( ALL col0 ) AS col2 FROM tab1 cor0 ---- -61 skipif mysql # not compatible query I rowsort label-755 SELECT - 70 - + - 69 + - COUNT ( * ) * CAST ( COUNT ( * ) AS INTEGER ) - MIN ( ALL col0 ) AS col2 FROM tab1 cor0 ---- -61 query II rowsort SELECT - + col0 - - col1 * - + col1 AS col2, col1 FROM tab2 AS cor0 ---- -2647 51 -4564 67 -5993 77 query I rowsort SELECT + col2 - - - 7 AS col1 FROM tab0 AS cor0 ---- 3 40 92 query I rowsort SELECT DISTINCT col0 AS col2 FROM tab1 cor0 WHERE ( col2 ) IS NOT NULL AND NOT ( + + 16 ) < - col2 - ( + 85 ) ---- 51 85 91 query I rowsort SELECT col0 - + 28 FROM tab1 AS cor0 ---- 23 57 63 onlyif mysql # aggregate syntax: query I rowsort label-760 SELECT ALL - COUNT( * ) + - ( - - 51 ) AS col1 FROM tab0 AS cor0 ---- -54 skipif mysql # not compatible query I rowsort label-760 SELECT ALL - COUNT ( * ) + - ( - - 51 ) AS col1 FROM tab0 AS cor0 ---- -54 onlyif mysql # aggregate syntax: query I rowsort label-761 SELECT ALL - COUNT( * ) * + 15 FROM tab0 AS cor0 ---- -45 skipif mysql # not compatible query I rowsort label-761 SELECT ALL - COUNT ( * ) * + 15 FROM tab0 AS cor0 ---- -45 query III rowsort SELECT * FROM tab2 AS cor0 WHERE col1 IN ( - 81, + col1 + + col1 + - col1 ) ---- 9 values hashing to 75c998aa53ac83218cbf2feb962d0a49 onlyif mysql # CAST syntax: SIGNED type: query III rowsort label-763 SELECT * FROM tab0 AS cor0 WHERE col0 * + col1 + - - col1 BETWEEN ( - CAST( col2 AS SIGNED ) ) AND ( + col2 ) ---- 97 1 99 skipif mysql # not compatible query III rowsort label-763 SELECT * FROM tab0 AS cor0 WHERE col0 * + col1 + - - col1 BETWEEN ( - CAST ( col2 AS INTEGER ) ) AND ( + col2 ) ---- 97 1 99 onlyif mysql # aggregate syntax: query I rowsort label-764 SELECT COUNT( * ) + + 41 AS col0 FROM tab1 AS cor0 ---- 44 skipif mysql # not compatible query I rowsort label-764 SELECT COUNT ( * ) + + 41 AS col0 FROM tab1 AS cor0 ---- 44 onlyif mysql # aggregate syntax: query I rowsort label-765 SELECT - 64 + - - COUNT( * ) FROM tab0 AS cor0 ---- -61 skipif mysql # not compatible query I rowsort label-765 SELECT - 64 + - - COUNT ( * ) FROM tab0 AS cor0 ---- -61 query I rowsort SELECT - col1 * + - col2 + - + col0 AS col1 FROM tab2 ---- 1127 3016 3811 query I rowsort SELECT DISTINCT col1 * + col2 + + col1 FROM tab1 ---- 1358 300 3243 onlyif mysql # aggregate syntax: query I rowsort label-768 SELECT ALL 52 + MIN( ALL col1 ) AS col1 FROM tab0 ---- 53 skipif mysql # not compatible query I rowsort label-768 SELECT ALL 52 + MIN ( ALL col1 ) AS col1 FROM tab0 ---- 53 onlyif mysql # aggregate syntax: query I rowsort label-769 SELECT 99 + + ( + SUM( - col0 ) ) FROM tab2 WHERE col0 IS NULL ---- NULL skipif mysql # not compatible query I rowsort label-769 SELECT 99 + + ( + SUM ( - col0 ) ) FROM tab2 WHERE col0 IS NULL ---- NULL onlyif mysql # aggregate syntax: query I rowsort label-770 SELECT DISTINCT MAX( - col1 ) AS col0 FROM tab2 WHERE col2 IS NULL ---- NULL skipif mysql # not compatible query I rowsort label-770 SELECT DISTINCT MAX ( - col1 ) AS col0 FROM tab2 WHERE col2 IS NULL ---- NULL onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: query III rowsort label-771 SELECT * FROM tab1 WHERE NOT ( ( + col1 * + - col2 ) BETWEEN + CAST( NULL AS SIGNED ) / + CAST( col1 * 8 AS DECIMAL ) AND + col1 / ( - col1 ) ) ---- skipif mysql # not compatible query III rowsort label-771 SELECT * FROM tab1 WHERE NOT ( ( + col1 * + - col2 ) BETWEEN + CAST ( NULL AS INTEGER ) / + CAST ( col1 * 8 AS REAL ) AND + col1 / ( - col1 ) ) ---- query II rowsort SELECT 54, + col2 + - 80 AS col0 FROM tab0 ---- 54 -33 54 -70 54 19 query III rowsort SELECT ALL * FROM tab2 WHERE - 59 IS NULL ---- query I rowsort SELECT DISTINCT ( + + col2 ) FROM tab1 cor0 ---- 59 68 96 onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-775 SELECT + - CAST( COUNT( * ) AS SIGNED ) * 11 FROM tab0 AS cor0 ---- -33 skipif mysql # not compatible query I rowsort label-775 SELECT + - CAST ( COUNT ( * ) AS INTEGER ) * 11 FROM tab0 AS cor0 ---- -33 query I rowsort SELECT - - col0 * - 17 - col1 + 99 + - 8 AS col2 FROM tab1 AS cor0 ---- -1359 -1503 -790 query II rowsort SELECT DISTINCT 58 * - 98 AS col1, 34 FROM tab0 ---- -5684 34 query I rowsort SELECT DISTINCT + col2 + + ( + - col2 ) AS col0 FROM tab1 WHERE NOT NULL <> NULL ---- onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: query I rowsort label-779 SELECT - CAST( - COUNT( * ) AS SIGNED ) FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1 ---- 9 skipif mysql # not compatible query I rowsort label-779 SELECT - CAST ( - COUNT ( * ) AS INTEGER ) FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1 ---- 9 query I rowsort SELECT + col1 AS col1 FROM tab1 AS cor0 WHERE NOT NULL >= + col1 ---- onlyif mysql # CAST syntax: aggregate syntax: DECIMAL type: query I rowsort label-781 SELECT DISTINCT + - ( CAST( NULL AS DECIMAL ) ) * - + MAX( - col2 ) AS col1 FROM tab1 AS cor0 ---- NULL skipif mysql # not compatible query I rowsort label-781 SELECT DISTINCT + - ( CAST ( NULL AS REAL ) ) * - + MAX ( - col2 ) AS col1 FROM tab1 AS cor0 ---- NULL onlyif mysql # CAST syntax: SIGNED type: query II rowsort label-782 SELECT - 66 / + - CAST( NULL AS SIGNED ), col0 AS col2 FROM tab1 AS cor0 ---- NULL 51 NULL 85 NULL 91 skipif mysql # not compatible query II rowsort label-782 SELECT - 66 / + - CAST ( NULL AS INTEGER ), col0 AS col2 FROM tab1 AS cor0 ---- NULL 51 NULL 85 NULL 91 onlyif mysql # DIV for integer division: query I rowsort label-783 SELECT DISTINCT col2 DIV + col1 FROM tab0 AS cor0 WHERE NOT ( NOT NULL IS NULL ) ---- 0 99 skipif mysql # not compatible query I rowsort label-783 SELECT DISTINCT col2 / + col1 FROM tab0 AS cor0 WHERE NOT ( NOT NULL IS NULL ) ---- 0 99 onlyif mysql # aggregate syntax: query I rowsort label-784 SELECT 44 + - MAX( ALL col2 ) AS col0 FROM tab2 AS cor0 ---- -14 skipif mysql # not compatible query I rowsort label-784 SELECT 44 + - MAX ( ALL col2 ) AS col0 FROM tab2 AS cor0 ---- -14 query I rowsort SELECT col0 AS col1 FROM tab0 AS cor0 WHERE NOT ( NULL ) IN ( - 48 ) ---- query I rowsort SELECT col2 AS col2 FROM tab1 WHERE ( NULL ) IS NOT NULL ---- onlyif mysql # CAST syntax: SIGNED type: query I rowsort label-787 SELECT DISTINCT - col2 * + - CAST( NULL AS SIGNED ) / - - 66 col1 FROM tab2 ---- NULL skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query I rowsort label-787 SELECT DISTINCT - col2 * + - CAST ( NULL AS INTEGER ) / - - 66 col1 FROM tab2 ---- NULL query I rowsort SELECT ALL 76 + - - 62 AS col0 FROM tab2 ---- 138 138 138 onlyif mysql # aggregate syntax: query I rowsort label-789 SELECT ALL COUNT( * ) * + 61 FROM tab1 ---- 183 skipif mysql # not compatible query I rowsort label-789 SELECT ALL COUNT ( * ) * + 61 FROM tab1 ---- 183