Changeset: bc1bd81e7cbf for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bc1bd81e7cbf
Removed Files:
sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.sql
sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.err
sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.out
sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.sql
sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.out
Modified Files:
sql/test/BugTracker-2017/Tests/All
Branch: default
Log Message:
Removing tests 6444, 6448, moving them to stable branch
diffs (276 lines):
diff --git a/sql/test/BugTracker-2017/Tests/All
b/sql/test/BugTracker-2017/Tests/All
--- a/sql/test/BugTracker-2017/Tests/All
+++ b/sql/test/BugTracker-2017/Tests/All
@@ -98,5 +98,3 @@ sqlsmith.Bug-6432
sqlitelogictest-select-in.Bug-6433
sqlitelogictest-select-not-in.Bug-6435
sqlitelogictest-cast-decimal.Bug-6445
-HAVE_LIBPY?table_returning_with.Bug-6444
-insert_into_multiple_subqueries.Bug-6448
diff --git
a/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.sql
b/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.sql
deleted file mode 100644
---
a/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-CREATE TABLE test_table(x VARCHAR(10), y INTEGER);
-INSERT INTO test_table VALUES ('test1', (SELECT 1)), ('test3', (SELECT 1));
-SELECT * FROM test_table;
diff --git
a/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.err
b/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.err
deleted file mode 100644
---
a/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.err
+++ /dev/null
@@ -1,29 +0,0 @@
-# 13:58:29 >
-# 13:58:29 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=32428" "--set"
"mapi_usock=/var/tmp/mtest-43229/.s.monetdb.32428" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/Users/rkoopmanschap/projects/MonetDB/MonetDB/install/var/MonetDB/mTests_sql_test_BugTracker-2017"
-# 13:58:29 >
-
-# builtin opt gdk_dbpath =
/Users/rkoopmanschap/projects/MonetDB/MonetDB/install/var/monetdb5/dbfarm/demo
-# builtin opt gdk_debug = 0
-# builtin opt gdk_vmtrim = no
-# builtin opt monet_prompt = >
-# builtin opt monet_daemon = no
-# builtin opt mapi_port = 50000
-# builtin opt mapi_open = false
-# builtin opt mapi_autosense = false
-# builtin opt sql_optimizer = default_pipe
-# builtin opt sql_debug = 0
-# cmdline opt gdk_nr_threads = 0
-# cmdline opt mapi_open = true
-# cmdline opt mapi_port = 32428
-# cmdline opt mapi_usock = /var/tmp/mtest-43229/.s.monetdb.32428
-# cmdline opt monet_prompt =
-# cmdline opt gdk_dbpath =
/Users/rkoopmanschap/projects/MonetDB/MonetDB/install/var/MonetDB/mTests_sql_test_BugTracker-2017
-# cmdline opt gdk_debug = 536870922
-
-# 13:58:30 >
-# 13:58:30 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-43229" "--port=32428"
-# 13:58:30 >
-
-# 13:58:30 >
-# 13:58:30 > "Done."
-# 13:58:30 >
diff --git
a/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.out
b/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.out
deleted file mode 100644
---
a/sql/test/BugTracker-2017/Tests/insert_into_multiple_subqueries.Bug-6448.stable.out
+++ /dev/null
@@ -1,69 +0,0 @@
-# 13:58:29 >
-# 13:58:29 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=32428" "--set"
"mapi_usock=/var/tmp/mtest-43229/.s.monetdb.32428" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/Users/rkoopmanschap/projects/MonetDB/MonetDB/install/var/MonetDB/mTests_sql_test_BugTracker-2017"
-# 13:58:29 >
-
-# MonetDB 5 server v11.28.0
-# This is an unreleased version
-# Serving database 'mTests_sql_test_BugTracker-2017', using 4 threads
-# Compiled for x86_64-apple-darwin16.1.0/64bit with 128bit integers
-# Found 16.000 GiB available main-memory.
-# Copyright (c) 1993-July 2008 CWI.
-# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved
-# Visit https://www.monetdb.org/ for further information
-# Listening for connection requests on
mapi:monetdb://dhcp-41.eduroam.cwi.nl:32428/
-# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-43229/.s.monetdb.32428
-# MonetDB/GIS module loaded
-# MonetDB/SQL module loaded
-
-Ready.
-# 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_profiler.sql
-# loading sql script: 51_sys_schema_extension.sql
-# loading sql script: 60_wlcr.sql
-# loading sql script: 72_fits.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: 90_generator.sql
-# loading sql script: 90_generator_hge.sql
-# loading sql script: 99_system.sql
-
-# 13:58:30 >
-# 13:58:30 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-43229" "--port=32428"
-# 13:58:30 >
-
-#CREATE TABLE test_table(x VARCHAR(10), y INTEGER);
-[ 1 ]
-#INSERT INTO test_table VALUES ('test1', (SELECT 1)), ('test3', (SELECT 1));
-[ 1 ]
-#SELECT * FROM test_table;
-[ test1, 1 ]
-[ test2, 2 ]
-# 13:58:30 >
-# 13:58:30 > "Done."
-# 13:58:30 >
diff --git a/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.sql
b/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.sql
deleted file mode 100644
--- a/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-CREATE TABLE test_table(x STRING, y STRING, z STRING);
-INSERT INTO test_table VALUES ('test value 1', 'test value 2', 'test value 3');
-
-CREATE FUNCTION test_function(x STRING, y STRING, z STRING) RETURNS TABLE(a
STRING, b STRING, c FLOAT) LANGUAGE PYTHON {
- result = dict()
- result['a'] = ['test value a']
- result['b'] = ['test value b']
- result['c'] = [3]
-
- return result
-};
-
-CREATE TABLE results_table AS (
- WITH test_table_tmp AS (
- SELECT * FROM test_table
- )
- SELECT * FROM test_function(test_table_tmp.x, test_table_tmp.y,
test_table_tmp.z)
-);
-
-SELECT * FROM results_table;
diff --git
a/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
b/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
deleted file mode 100644
--- a/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
+++ /dev/null
@@ -1,30 +0,0 @@
-
-# 11:38:03 >
-# 11:38:03 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=34277" "--set"
"mapi_usock=/var/tmp/mtest-1506/.s.monetdb.34277" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/Users/rkoopmanschap/projects/monetdb/MonetDB/install/var/MonetDB/mTests_sql_test_BugTracker-2017"
-# 11:38:03 >
-
-# builtin opt gdk_dbpath =
/Users/rkoopmanschap/projects/monetdb/MonetDB/install/var/monetdb5/dbfarm/demo
-# builtin opt gdk_debug = 0
-# builtin opt gdk_vmtrim = no
-# builtin opt monet_prompt = >
-# builtin opt monet_daemon = no
-# builtin opt mapi_port = 50000
-# builtin opt mapi_open = false
-# builtin opt mapi_autosense = false
-# builtin opt sql_optimizer = default_pipe
-# builtin opt sql_debug = 0
-# cmdline opt gdk_nr_threads = 0
-# cmdline opt mapi_open = true
-# cmdline opt mapi_port = 34277
-# cmdline opt mapi_usock = /var/tmp/mtest-1506/.s.monetdb.34277
-# cmdline opt monet_prompt =
-# cmdline opt gdk_dbpath =
/Users/rkoopmanschap/projects/monetdb/MonetDB/install/var/MonetDB/mTests_sql_test_BugTracker-2017
-# cmdline opt gdk_debug = 536870922
-
-# 11:38:03 >
-# 11:38:03 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1506" "--port=34277"
-# 11:38:03 >
-
-# 11:38:04 >
-# 11:38:04 > "Done."
-# 11:38:04 >
diff --git
a/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.out
b/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.out
deleted file mode 100644
--- a/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.out
+++ /dev/null
@@ -1,86 +0,0 @@
-stdout of test 'table_returning_with.Bug-6444` in directory
'sql/test/BugTracker-2017` itself:
-
-
-# 11:38:03 >
-# 11:38:03 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=34277" "--set"
"mapi_usock=/var/tmp/mtest-1506/.s.monetdb.34277" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/Users/rkoopmanschap/projects/monetdb/MonetDB/install/var/MonetDB/mTests_sql_test_BugTracker-2017"
-# 11:38:03 >
-
-# MonetDB 5 server v11.28.0
-# This is an unreleased version
-# Serving database 'mTests_sql_test_BugTracker-2017', using 4 threads
-# Compiled for x86_64-apple-darwin16.1.0/64bit with 128bit integers
-# Found 16.000 GiB available main-memory.
-# Copyright (c) 1993-July 2008 CWI.
-# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved
-# Visit https://www.monetdb.org/ for further information
-# Listening for connection requests on
mapi:monetdb://dhcp-41.eduroam.cwi.nl:34277/
-# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-1506/.s.monetdb.34277
-# MonetDB/GIS module loaded
-# MonetDB/SQL module loaded
-
-Ready.
-# 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_profiler.sql
-# loading sql script: 51_sys_schema_extension.sql
-# loading sql script: 60_wlcr.sql
-# loading sql script: 72_fits.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: 90_generator.sql
-# loading sql script: 90_generator_hge.sql
-# loading sql script: 99_system.sql
-
-# 11:38:03 >
-# 11:38:03 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1506" "--port=34277"
-# 11:38:03 >
-
-#CREATE TABLE test_table(x STRING, y STRING, z STRING);
-#INSERT INTO test_table VALUES ('test value 1', 'test value 2', 'test value
3');
-[ 1 ]
-#CREATE FUNCTION test_function(x STRING, y STRING, z STRING) RETURNS TABLE(a
STRING, b STRING, c FLOAT) LANGUAGE PYTHON {
-# result = dict()
-# result['a'] = ['test value a']
-# result['b'] = ['test value b']
-# result['c'] = [3]
-#
-# return result
-#};
-[ 1 ]
-#CREATE TABLE results_table AS (
-# WITH test_table_tmp AS (
-# SELECT * FROM test_table
-# )
-# SELECT * FROM test_function(test_table_tmp.x, test_table_tmp.y,
test_table_tmp.z)
-#);
-[ 1 ]
-#SELECT * FROM results_table;
-[ test value 1, test value 2, test value 3 ]
-# 11:38:04 >
-# 11:38:04 > "Done."
-# 11:38:04 >
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
