Changeset: 79ed3a367132 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=79ed3a367132 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-aritmetic-expressions-handling.Bug-6576.stable.out.int128 Branch: Mar2018 Log Message:
Adding an .int128 version for hugeint outputs diffs (169 lines): diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-aritmetic-expressions-handling.Bug-6576.stable.out.int128 b/sql/test/BugTracker-2018/Tests/sqlitelogictest-aritmetic-expressions-handling.Bug-6576.stable.out.int128 new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-aritmetic-expressions-handling.Bug-6576.stable.out.int128 @@ -0,0 +1,164 @@ +stdout of test 'sqlitelogictest-aritmetic-expressions-handling.Bug-6576` in directory 'sql/test/BugTracker-2018` itself: + + +# 16:20:37 > +# 16:20:37 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39398" "--set" "mapi_usock=/var/tmp/mtest-2283/.s.monetdb.39398" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/rc-old/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2018" "--set" "embedded_c=true" +# 16:20:37 > + +# MonetDB 5 server v11.29.2 +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2018', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 15.387 GiB available main-memory. +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://xps13:39398/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-2283/.s.monetdb.39398 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 16:20:37 > +# 16:20:37 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-2283" "--port=39398" +# 16:20:37 > + +#SELECT -2 * 50; -- -100 +% .L2 # table_name +% L2 # name +% smallint # type +% 4 # length +[ -100 ] +#SELECT ALL - 0 * 36; -- 0 +% .L2 # table_name +% L2 # name +% smallint # type +% 1 # length +[ 0 ] +#SELECT ALL - 33 + - 77 * 0 AS col1; -- -33 +% .L2 # table_name +% col1 # name +% int # type +% 3 # length +[ -33 ] +#SELECT + 12 + - 0 * + 70; -- 12 +% .L2 # table_name +% L2 # name +% int # type +% 2 # length +[ 12 ] +#SELECT - ( ( 0 ) ) * 78; -- 0 +% .L2 # table_name +% L2 # name +% smallint # type +% 1 # length +[ 0 ] +#SELECT ALL - 4 * + 0 * - - 48 col1; -- 0 +% .L2 # table_name +% col1 # name +% int # type +% 1 # length +[ 0 ] +#SELECT - 0 * - 15 AS col0; -- 0 +% .L2 # table_name +% col0 # name +% smallint # type +% 1 # length +[ 0 ] +#SELECT - 48 * + + 0 + + 94 AS col1; -- 94 +% .L2 # table_name +% col1 # name +% smallint # type +% 2 # length +[ 94 ] +#SELECT ALL + - 32 * - 32 + - - 76 - - - 43 * COUNT ( * ) + - + 84 * 0 * + + 39 + + 44 * + 76; -- 4401 +% .L4 # table_name +% L4 # name +% hugeint # type +% 4 # length +[ 4401 ] +#SELECT 38 + - 63 * 0 * - 13 AS col2; -- 38 +% .L2 # table_name +% col2 # name +% int # type +% 2 # length +[ 38 ] +#SELECT 64 + - 0 * 40 AS col1; -- 64 +% .L2 # table_name +% col1 # name +% smallint # type +% 2 # length +[ 64 ] +#SELECT ALL - 35 * - 0 AS col2; -- 0 +% .L2 # table_name +% col2 # name +% smallint # type +% 1 # length +[ 0 ] +#SELECT + - 36 * - + 33 * - + 49 * + CASE 50 WHEN - 21 + 0 + - COUNT ( * ) THEN NULL +#WHEN + 99 * - 43 + - - 35 THEN - 75 ELSE NULL END * - - 51 * + 0 AS col2; -- NULL +% .L4 # table_name +% col2 # name +% bigint # type +% 1 # length +[ NULL ] +#SELECT - 66 * 0 * - 87 AS col2; -- 0 +% .L2 # table_name +% col2 # name +% int # type +% 1 # length +[ 0 ] +#SELECT - 13 * - ( + 0 ) + 39 * - COUNT ( * ) * - COUNT ( * ) col1; -- 39 +% .L5 # table_name +% col1 # name +% hugeint # type +% 2 # length +[ 39 ] +#SELECT COUNT ( - + 70 ) - - 99 * - 0 AS col2; -- 1 +% .L4 # table_name +% col2 # name +% hugeint # type +% 1 # length +[ 1 ] +#SELECT - ( - - 15 ) + - 53 * - 0; -- -15 +% .L2 # table_name +% L2 # name +% smallint # type +% 3 # length +[ -15 ] +#SELECT - + 22 * + COUNT ( * ) + - - 58 - + 83 * + MAX ( - 94 * 0 ); -- 36 +% .L5 # table_name +% L5 # name +% hugeint # type +% 2 # length +[ 36 ] +#SELECT DISTINCT - 16 + ( + 37 ) - - 56 * - - 11 * - 0 + + MAX ( + 29 ) AS col2; -- 50 +% .L4 # table_name +% col2 # name +% bigint # type +% 2 # length +[ 50 ] +#SELECT - 54 * + 0; -- 0 +% .L2 # table_name +% L2 # name +% smallint # type +% 1 # length +[ 0 ] +#SELECT ALL - 30 + + 85, - ( - + 43 ) - 71 + - 0 * - - 78 + - 78 + - - 47 * - 93 + 32 * + SUM ( 90 ) AS col0; -- 55, -1597 +% .L2, .L6 # table_name +% L2, col0 # name +% smallint, hugeint # type +% 2, 5 # length +[ 55, -1597 ] +#SELECT ALL + COUNT ( * ) - - + 0 * - 32; -- 1 +% .L4 # table_name +% L4 # name +% hugeint # type +% 1 # length +[ 1 ] + +# 16:20:37 > +# 16:20:37 > "Done." +# 16:20:37 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
