Changeset: 37b8044e54cb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=37b8044e54cb Modified Files: sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.sql sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.sql sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.sql sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.stable.out Branch: Jun2020 Log Message:
No hugeint in the output diffs (172 lines): diff --git a/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.sql b/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.sql --- a/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.sql +++ b/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.sql @@ -1,3 +1,3 @@ select 'a'+1; select 1-'a'; -select true+1; +select cast(true+1 as bigint); diff --git a/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out b/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out --- a/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out +++ b/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out @@ -1,32 +1,14 @@ stdout of test 'mixed_type.SF-917372` in directory 'sql/test/BugDay_2005-10-06_2.8` itself: -# 18:31:51 > -# 18:31:51 > mserver5 "--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=4 --set "monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=38592 --set xrpc_port=45862 --set monet_prompt= --trace "--dbname=mTests_src_test_BugDay_2005-10-06_2.8" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. -# 18:31:51 > - -# MonetDB server v5.9.0, based on kernel v1.27.0 -# Serving database 'mTests_src_test_BugDay_2005-10-06_2.8', using 4 threads -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Copyright (c) 1993-July 2008 CWI. -# Copyright (c) August 2008- MonetDB B.V., all rights reserved -# Visit http://monetdb.cwi.nl/ for further information -# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:38592/ -# MonetDB/SQL module v2.27.0 loaded +# 14:04:34 > +# 14:04:34 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-390464" "--port=31391" +# 14:04:34 > -#function user.main():void; -# clients.quit(); -#end main; - - -# 11:50:16 > -# 11:50:16 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35781 < mixed_type.SF-917372.sql -# 11:50:16 > - -#select true+1; -% .%2 # table_name -% %2 # name -% hugeint # type +#select cast(true+1 as bigint); +% .%1 # table_name +% %1 # name +% bigint # type % 1 # length [ 2 ] diff --git a/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.sql b/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.sql --- a/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.sql +++ b/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.sql @@ -1,7 +1,7 @@ CREATE TABLE t2852 (c INT); INSERT INTO t2852 VALUES (0); SELECT - COALESCE( + CAST(COALESCE( COALESCE("c" / CASE WHEN COALESCE("c" , 0) = 0 @@ -15,7 +15,7 @@ SELECT NULL END ,0) - , 0) + , 0) AS BIGINT) FROM t2852 ; diff --git a/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out b/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out --- a/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out +++ b/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out @@ -46,9 +46,9 @@ stdout of test 'CASE_nested_functions.Bu # FROM # t2852 # ; -% sys.%15 # table_name -% %15 # name -% hugeint # type +% sys.%4 # table_name +% %4 # name +% bigint # type % 1 # length [ 0 ] #DROP TABLE t2852; diff --git a/sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.sql b/sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.sql --- a/sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.sql +++ b/sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.sql @@ -1,1 +1,1 @@ -select 1 + null; +select cast(1 + null as bigint); diff --git a/sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.stable.out b/sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.stable.out --- a/sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.stable.out +++ b/sql/test/BugTracker-2017/Tests/one-plus-nil.Bug-6243.stable.out @@ -5,70 +5,10 @@ stdout of test 'one-plus-nil.Bug-6243` i # 21:23:57 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39261" "--set" "mapi_usock=/var/tmp/mtest-22986/.s.monetdb.39261" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/sjoerd/Monet-stable/var/MonetDB/mTests_sql_test_BugTracker-2017" "--set" "embedded_r=yes" "--set" "embedded_py=true" # 21:23:57 > -# MonetDB 5 server v11.25.12 (hg id: 947957af7128+) -# This is an unreleased version -# Serving database 'mTests_sql_test_BugTracker-2017', using 4 threads -# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers -# Found 15.521 GiB available main-memory. -# Copyright (c) 1993-July 2008 CWI. -# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved -# Visit http://www.monetdb.org/ for further information -# Listening for connection requests on mapi:monetdb://meeuw.mullender.nl:39261/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-22986/.s.monetdb.39261 -# MonetDB/GIS module loaded -# MonetDB/SQL module loaded -# MonetDB/Python module loaded -# MonetDB/R module loaded - -# SQL catalog created, loading sql scripts once -# loading sql script: 09_like.sql -# loading sql script: 10_math.sql -# loading sql script: 11_times.sql -# loading sql script: 12_url.sql -# loading sql script: 13_date.sql -# loading sql script: 14_inet.sql -# loading sql script: 15_querylog.sql -# loading sql script: 16_tracelog.sql -# loading sql script: 17_temporal.sql -# loading sql script: 18_index.sql -# loading sql script: 20_vacuum.sql -# loading sql script: 21_dependency_functions.sql -# loading sql script: 22_clients.sql -# loading sql script: 23_skyserver.sql -# loading sql script: 25_debug.sql -# loading sql script: 26_sysmon.sql -# loading sql script: 27_rejects.sql -# loading sql script: 39_analytics.sql -# loading sql script: 39_analytics_hge.sql -# loading sql script: 40_geom.sql -# loading sql script: 40_json.sql -# loading sql script: 40_json_hge.sql -# loading sql script: 41_md5sum.sql -# loading sql script: 45_uuid.sql -# loading sql script: 46_gsl.sql -# loading sql script: 46_profiler.sql -# loading sql script: 51_sys_schema_extension.sql -# loading sql script: 72_fits.sql -# loading sql script: 74_netcdf.sql -# loading sql script: 75_lidar.sql -# loading sql script: 75_shp.sql -# loading sql script: 75_storagemodel.sql -# loading sql script: 80_statistics.sql -# loading sql script: 80_udf.sql -# loading sql script: 80_udf_hge.sql -# loading sql script: 85_bam.sql -# loading sql script: 90_generator.sql -# loading sql script: 90_generator_hge.sql -# loading sql script: 99_system.sql - -# 21:23:57 > -# 21:23:57 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-22986" "--port=39261" -# 21:23:57 > - -#select 1 + null; -% .%2 # table_name -% %2 # name -% hugeint # type +#select cast(1 + null as bigint); +% .%1 # table_name +% %1 # name +% bigint # type % 1 # length [ NULL ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
