Changeset: c974c3bc350f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c974c3bc350f Added Files: sql/test/prepare/Tests/All sql/test/prepare/Tests/SingleServer sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.SQL.py sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.sql sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.stable.out sql/test/prepare/Tests/prepare-complex.SQL.py sql/test/prepare/Tests/prepare-complex.stable.out Modified Files: sql/test/BugTracker-2012/Tests/All Branch: mtest Log Message:
moved fixed_limit_for_prepare.Bug-3208 to prepare diffs (truncated from 387 to 300 lines): diff --git a/sql/test/BugTracker-2012/Tests/All b/sql/test/BugTracker-2012/Tests/All --- a/sql/test/BugTracker-2012/Tests/All +++ b/sql/test/BugTracker-2012/Tests/All @@ -79,7 +79,6 @@ update_crash.Bug-2655 tuples_INTERSECT_vs_count_intersect_differs.Bug-2659 large-number-operation-strange-results.Bug-2929 inet-casts.Bug-3205 -fixed_limit_for_prepare.Bug-3208 exp_bin_assertion.Bug-3209 #querycache.Bug-3212 url_script_test.Bug-2972 diff --git a/sql/test/prepare/Tests/All b/sql/test/prepare/Tests/All new file mode 100644 --- /dev/null +++ b/sql/test/prepare/Tests/All @@ -0,0 +1,2 @@ +fixed_limit_for_prepare.Bug-3208 +prepare-complex diff --git a/sql/test/prepare/Tests/SingleServer b/sql/test/prepare/Tests/SingleServer new file mode 100644 diff --git a/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.SQL.py b/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.SQL.py new file mode 100644 --- /dev/null +++ b/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.SQL.py @@ -0,0 +1,11 @@ +import sys +from MonetDBtesting.sqltest import SQLTestCase + +with SQLTestCase() as tc: + # optional or default connection + tc.connect() + with open('fixed_limit_for_prepare.Bug-3208.sql') as f: + tr = tc.execute(query=None, client='mclient', stdin=f)\ + .assertSucceeded()\ + .assertMatchStableOut('fixed_limit_for_prepare.Bug-3208.stable.out') + diff --git a/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.sql b/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.sql new file mode 100644 --- /dev/null +++ b/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.sql @@ -0,0 +1,69 @@ +CREATE TABLE wide("1" VARCHAR(255), "2" VARCHAR(255), "3" VARCHAR(255), "4" + VARCHAR(255), "5" VARCHAR(255), "6" VARCHAR(255), "7" VARCHAR(255), "8" + VARCHAR(255), "9" VARCHAR(255), "10" VARCHAR(255), "11" VARCHAR(255), "12" + VARCHAR(255), "13" VARCHAR(255), "14" VARCHAR(255), "15" VARCHAR(255), "16" + VARCHAR(255), "17" VARCHAR(255), "18" VARCHAR(255), "19" VARCHAR(255), "20" + VARCHAR(255), "21" VARCHAR(255), "22" VARCHAR(255), "23" VARCHAR(255), "24" + VARCHAR(255), "25" VARCHAR(255), "26" VARCHAR(255), "27" VARCHAR(255), "28" + VARCHAR(255), "29" VARCHAR(255), "30" VARCHAR(255), "31" VARCHAR(255), "32" + VARCHAR(255), "33" VARCHAR(255), "34" VARCHAR(255), "35" VARCHAR(255), "36" + VARCHAR(255), "37" VARCHAR(255), "38" VARCHAR(255), "39" VARCHAR(255), "40" + VARCHAR(255), "41" VARCHAR(255), "42" VARCHAR(255), "43" VARCHAR(255), "44" + VARCHAR(255), "45" VARCHAR(255), "46" VARCHAR(255), "47" VARCHAR(255), "48" + VARCHAR(255), "49" VARCHAR(255), "50" VARCHAR(255), "51" VARCHAR(255), "52" + VARCHAR(255), "53" VARCHAR(255), "54" VARCHAR(255), "55" VARCHAR(255), "56" + VARCHAR(255), "57" VARCHAR(255), "58" VARCHAR(255), "59" VARCHAR(255), "60" + VARCHAR(255), "61" VARCHAR(255), "62" VARCHAR(255), "63" VARCHAR(255), "64" + VARCHAR(255), "65" VARCHAR(255), "66" VARCHAR(255), "67" VARCHAR(255), "68" + VARCHAR(255), "69" VARCHAR(255), "70" VARCHAR(255), "71" VARCHAR(255), "72" + VARCHAR(255), "73" VARCHAR(255), "74" VARCHAR(255), "75" VARCHAR(255), "76" + VARCHAR(255), "77" VARCHAR(255), "78" VARCHAR(255), "79" VARCHAR(255), "80" + VARCHAR(255), "81" VARCHAR(255), "82" VARCHAR(255), "83" VARCHAR(255), "84" + VARCHAR(255), "85" VARCHAR(255), "86" VARCHAR(255), "87" VARCHAR(255), "88" + VARCHAR(255), "89" VARCHAR(255), "90" VARCHAR(255), "91" VARCHAR(255), "92" + VARCHAR(255), "93" VARCHAR(255), "94" VARCHAR(255), "95" VARCHAR(255), "96" + VARCHAR(255), "97" VARCHAR(255), "98" VARCHAR(255), "99" VARCHAR(255), "100" + VARCHAR(255), "101" VARCHAR(255), "102" VARCHAR(255), "103" VARCHAR(255), "104" + VARCHAR(255), "105" VARCHAR(255), "106" VARCHAR(255), "107" VARCHAR(255), "108" + VARCHAR(255), "109" VARCHAR(255), "110" VARCHAR(255), "111" VARCHAR(255), "112" + VARCHAR(255), "113" VARCHAR(255), "114" VARCHAR(255), "115" VARCHAR(255), "116" + VARCHAR(255), "117" VARCHAR(255), "118" VARCHAR(255), "119" VARCHAR(255), "120" + VARCHAR(255), "121" VARCHAR(255), "122" VARCHAR(255), "123" VARCHAR(255), "124" + VARCHAR(255), "125" VARCHAR(255), "126" VARCHAR(255), "127" VARCHAR(255), "128" + VARCHAR(255), "129" VARCHAR(255), "130" VARCHAR(255), "131" VARCHAR(255), "132" + VARCHAR(255), "133" VARCHAR(255), "134" VARCHAR(255), "135" VARCHAR(255), "136" + VARCHAR(255), "137" VARCHAR(255), "138" VARCHAR(255), "139" VARCHAR(255), "140" + VARCHAR(255), "141" VARCHAR(255), "142" VARCHAR(255), "143" VARCHAR(255), "144" + VARCHAR(255), "145" VARCHAR(255), "146" VARCHAR(255), "147" VARCHAR(255), "148" + VARCHAR(255), "149" VARCHAR(255), "150" VARCHAR(255)); +PREPARE INSERT INTO wide("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", + "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", + "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", + "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", + "50", "51", "52", "53", "54", "55", "56", "57", "58", "59", "60", "61", "62", + "63", "64", "65", "66", "67", "68", "69", "70", "71", "72", "73", "74", "75", + "76", "77", "78", "79", "80", "81", "82", "83", "84", "85", "86", "87", "88", + "89", "90", "91", "92", "93", "94", "95", "96", "97", "98", "99", "100", "101", + "102", "103", "104", "105", "106", "107", "108", "109", "110", "111", "112", + "113", "114", "115", "116", "117", "118", "119", "120", "121", "122", "123", + "124", "125", "126", "127", "128", "129", "130", "131", "132", "133", "134", + "135", "136", "137", "138", "139", "140", "141", "142", "143", "144", "145", + "146", "147", "148", "149", "150") +VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, + ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, + ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, + ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, + ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, + ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); + +exec **('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', + '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', + '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', + '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', + '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', + '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', + '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', + '', '', '', '', '', '', '', '', '', '', '', '', ''); + +select count(*) from wide; +drop TABLE wide; diff --git a/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.stable.out b/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.stable.out @@ -0,0 +1,221 @@ +stdout of test 'fixed_limit_for_prepare.Bug-3208` in directory 'sql/test/BugTracker-2012` itself: + + +# 18:08:17 > +# 18:08:17 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/home/niels/scratch/rc-clean/Linux-x86_64/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=36971" "--set" "mapi_usock=/var/tmp/mtest-22422/.s.monetdb.36971" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_test_BugTracker-2012" "--set" "mal_listing=0" +# 18:08:17 > + +# MonetDB 5 server v11.13.6 +# This is an unreleased version +# Serving database 'mTests_test_BugTracker-2012', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 3.778 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://niels.nesco.mine.nu:36971/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-22422/.s.monetdb.36971 +# MonetDB/GIS module loaded +# MonetDB/JAQL module loaded +# MonetDB/SQL module loaded + + +# 18:08:17 > +# 18:08:17 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-22422" "--port=36971" +# 18:08:17 > + +#CREATE TABLE wide("1" VARCHAR(255), "2" VARCHAR(255), "3" VARCHAR(255), "4" +# VARCHAR(255), "5" VARCHAR(255), "6" VARCHAR(255), "7" VARCHAR(255), "8" +# VARCHAR(255), "9" VARCHAR(255), "10" VARCHAR(255), "11" VARCHAR(255), "12" +# VARCHAR(255), "13" VARCHAR(255), "14" VARCHAR(255), "15" VARCHAR(255), "16" +# VARCHAR(255), "17" VARCHAR(255), "18" VARCHAR(255), "19" VARCHAR(255), "20" +# VARCHAR(255), "21" VARCHAR(255), "22" VARCHAR(255), "23" VARCHAR(255), "24" +# VARCHAR(255), "25" VARCHAR(255), "26" VARCHAR(255), "27" VARCHAR(255), "28" +#PREPARE INSERT INTO wide("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", +# "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", +# "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", +# "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", +# "50", "51", "52", "53", "54", "55", "56", "57", "58", "59", "60", "61", "62", +# "63", "64", "65", "66", "67", "68", "69", "70", "71", "72", "73", "74", "75", +# "76", "77", "78", "79", "80", "81", "82", "83", "84", "85", "86", "87", "88", +#PREPARE INSERT INTO wide("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", +# "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", +# "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", +# "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", +# "50", "51", "52", "53", "54", "55", "56", "57", "58", "59", "60", "61", "62", +# "63", "64", "65", "66", "67", "68", "69", "70", "71", "72", "73", "74", "75", +# "76", "77", "78", "79", "80", "81", "82", "83", "84", "85", "86", "87", "88", +% .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name +% type, digits, scale, schema, table, column # name +% varchar, int, int, str, str, str # type +% 7, 3, 1, 0, 0, 0 # length +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] +[ "varchar", 255, 0, NULL, NULL, NULL ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list