Changeset: 82e4d400ae81 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=82e4d400ae81 Modified Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.stable.out sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.stable.out Branch: Mar2018 Log Message:
Cast output to bigint, so no .int128 output file is needed diffs (69 lines): diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.sql --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.sql +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.sql @@ -1,1 +1,1 @@ -SELECT COALESCE ( + 55, + 71 * - 23 + 20 + 74 / - COUNT ( ALL - 0 ) / + 75, - 85 / - 71 ) - + - 62 + - - CAST ( + 88 AS INTEGER ) * + + 83 AS col0; +SELECT CAST(COALESCE ( + 55, + 71 * - 23 + 20 + 74 / - COUNT ( ALL - 0 ) / + 75, - 85 / - 71 ) - + - 62 + - - CAST ( + 88 AS INTEGER ) * + + 83 AS BIGINT) AS col0; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.stable.out b/sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.stable.out --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.stable.out +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-coalesce-division-by-zero.Bug-6556.stable.out @@ -24,10 +24,10 @@ Ready. # 19:24:33 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-27357" "--port=31020" # 19:24:33 > -#SELECT COALESCE ( + 55, + 71 * - 23 + 20 + 74 / - COUNT ( ALL - 0 ) / + 75, - 85 / - 71 ) - + - 62 + - - CAST ( + 88 AS INTEGER ) * + + 83 AS col0; -% .L5 # table_name +#SELECT CAST(COALESCE ( + 55, + 71 * - 23 + 20 + 74 / - COUNT ( ALL - 0 ) / + 75, - 85 / - 71 ) - + - 62 + - - CAST ( + 88 AS INTEGER ) * + + 83 AS BIGINT) AS col0; +% .L6 # table_name % col0 # name -% hugeint # type +% bigint # type % 4 # length [ 7421 ] diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.sql @@ -1,3 +1,3 @@ -SELECT ALL + 62 * + - ( CASE WHEN NULL NOT IN ( CAST ( CAST ( - 77 AS INTEGER ) AS INTEGER ) ) +SELECT ALL + 62 * + - CAST( ( CASE WHEN NULL NOT IN ( CAST ( CAST ( - 77 AS INTEGER ) AS INTEGER ) ) THEN NULL WHEN ( NULL ) NOT IN ( 94 * COUNT ( * ) ) THEN + ( NULLIF ( 45, 80 + 90 ) ) - COUNT ( * ) -ELSE NULL END ) AS col2; +ELSE NULL END ) AS BIGINT) AS col2; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.stable.out b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.stable.out --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.stable.out +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-not-in.Bug-6594.stable.out @@ -26,10 +26,10 @@ Ready. #SELECT ALL + 62 * + - ( CASE WHEN NULL NOT IN ( CAST ( CAST ( - 77 AS INTEGER ) AS INTEGER ) ) #THEN NULL WHEN ( NULL ) NOT IN ( 94 * COUNT ( * ) ) THEN + ( NULLIF ( 45, 80 + 90 ) ) - COUNT ( * ) -#ELSE NULL END ) AS col2; -% .L13 # table_name +#ELSE NULL END ) AS BIGINT) AS col2; +% .L14 # table_name % col2 # name -% hugeint # type +% bigint # type % 1 # length [ NULL ] diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.sql --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.sql +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.sql @@ -1,3 +1,3 @@ SELECT ALL + 60 * - NULLIF ( - CAST ( NULL AS INTEGER ), 51 * 70 * 62 / + 52 * + 58 / 90 - CAST ( + 44 AS INTEGER ) ) AS col2, 35; -SELECT ALL 11 * COUNT ( * ) * + 2 * 6; +SELECT ALL CAST( 11 * COUNT ( * ) * + 2 * 6 AS BIGINT); SELECT ALL - 9 * NULLIF ( + 30, + 64 ) * + 46 * 1; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.stable.out b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.stable.out --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.stable.out +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-errors.Bug-6600.stable.out @@ -33,7 +33,7 @@ Ready. #SELECT ALL 11 * COUNT ( * ) * + 2 * 6; % .L4 # table_name % L4 # name -% hugeint # type +% bigint # type % 3 # length [ 132 ] #SELECT ALL - 9 * NULLIF ( + 30, + 64 ) * + 46 * 1; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
