Changeset: 8a8d5e7e9df6 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8a8d5e7e9df6
Modified Files:
sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.sql
sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.stable.err
sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.stable.out
Branch: Aug2011
Log Message:
Test for bug 2346.
The bug was constructed using the attachment to the bug report. It
fails as reported on the Aug2011 branch.
The stable outputs may have to be adjusted when the bug is fixed.
diffs (202 lines):
diff --git a/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.sql
b/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.sql
@@ -0,0 +1,42 @@
+START TRANSACTION;
+SET SCHEMA "sys";
+CREATE TABLE "sys"."applied_credit" (
+ "directory" VARCHAR(512) NOT NULL,
+ "passed" INTEGER,
+ "allowed" INTEGER NOT NULL,
+ "multiplicity" INTEGER NOT NULL DEFAULT 0,
+ CONSTRAINT "applied_credit_directory_allowed_multiplicity_pkey" PRIMARY
KEY ("directory", "allowed", "multiplicity")
+);
+CREATE TABLE "sys"."success_credit" (
+ "directory" VARCHAR(512) NOT NULL,
+ "passed" INTEGER,
+ "allowed" INTEGER NOT NULL,
+ CONSTRAINT "success_credit_directory_allowed_pkey" PRIMARY KEY
("directory", "allowed")
+);
+COPY 2 RECORDS INTO "sys"."success_credit" FROM stdin USING DELIMITERS
'\t','\n','"';
+"foo" 1270047915 0
+"bar" 1270047915 0
+CREATE TABLE "sys"."success_setting" (
+ "directory" VARCHAR(512) NOT NULL,
+ "rate" INTEGER,
+ "heartbeat" INTEGER,
+ "success_rate" INTEGER,
+ "success_heartbeat" INTEGER,
+ "concurrency" INTEGER,
+ CONSTRAINT "success_setting_directory_pkey" PRIMARY KEY ("directory")
+);
+COPY 2 RECORDS INTO "sys"."success_setting" FROM stdin USING DELIMITERS
'\t','\n','"';
+"foo" 341 300 341 300 5
+"bar" 341 300 341 300 5
+
+INSERT INTO applied_credit (directory, allowed, multiplicity)
+SELECT success_credit.directory,
+ success_credit.allowed,
+ count(applied_credit.directory)
+FROM success_credit
+ LEFT OUTER JOIN applied_credit
+ ON applied_credit.directory = success_credit.directory
+ AND applied_credit.allowed >= success_credit.allowed
+GROUP BY success_credit.directory, success_credit.allowed;
+
+ROLLBACK;
diff --git
a/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.stable.err
b/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.stable.err
@@ -0,0 +1,48 @@
+stderr of test 'operands-not-synced.Bug-2346` in directory
'test/BugTracker-2011` itself:
+
+
+# 13:48:56 >
+# 13:48:56 > mserver5 --debug=10 --set gdk_nr_threads=0 --set
"gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" --set mapi_open=true --set
mapi_port=32123 --set monet_prompt= --trace --forcemito --set mal_listing=2
"--dbname=mTests_test_BugTracker-2011" --set mal_listing=0 ; echo ; echo Over..
+# 13:48:56 >
+
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm = /ufs/sjoerd/Monet-candidate/var/monetdb5/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# 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 gdk_dbfarm = /ufs/sjoerd/Monet-candidate/var/MonetDB
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 32123
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbname = mTests_test_BugTracker-2011
+# cmdline opt mal_listing = 0
+
+# 13:48:57 >
+# 13:48:57 > mclient -lsql -ftest -i -e --host=ottar --port=32123
+# 13:48:57 >
+
+MAPI = monetdb@ottar:32123
+QUERY = INSERT INTO applied_credit (directory, allowed, multiplicity)
+ SELECT success_credit.directory,
+ success_credit.allowed,
+ count(applied_credit.directory)
+ FROM success_credit
+ LEFT OUTER JOIN applied_credit
+ ON applied_credit.directory = success_credit.directory
+ AND applied_credit.allowed >= success_credit.allowed
+ GROUP BY success_credit.directory, success_credit.allowed;
+
+
+# 13:48:57 >
+# 13:48:57 > Done.
+# 13:48:57 >
+
diff --git
a/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.stable.out
b/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.stable.out
@@ -0,0 +1,97 @@
+stdout of test 'operands-not-synced.Bug-2346` in directory
'test/BugTracker-2011` itself:
+
+
+# 13:48:56 >
+# 13:48:56 > mserver5 --debug=10 --set gdk_nr_threads=0 --set
"gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" --set mapi_open=true --set
mapi_port=32123 --set monet_prompt= --trace --forcemito --set mal_listing=2
"--dbname=mTests_test_BugTracker-2011" --set mal_listing=0 ; echo ; echo Over..
+# 13:48:56 >
+
+# MonetDB 5 server v11.5.2
+# This is an unreleased version
+# Serving database 'mTests_test_BugTracker-2011', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Found 7.749 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://ottar.ins.cwi.nl:32123/
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+
+Ready.
+# SQL catalog created, loading sql scripts once
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/10_math.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/11_times.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/12_url.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/13_date.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/14_inet.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/15_history.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/16_tracelog.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/17_compress.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/18_dictionary.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/19_cluster.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/20_vacuum.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/21_dependency_functions.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/22_clients.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/23_skyserver.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/24_zorder.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/25_debug.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/40_geom.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/80_udf.sql
+# SQL loading sql scripts
/net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/99_system.sql
+
+Over..
+
+# 13:48:57 >
+# 13:48:57 > mclient -lsql -ftest -i -e --host=ottar --port=32123
+# 13:48:57 >
+
+#START TRANSACTION;
+#CREATE TABLE "sys"."applied_credit" (
+# "directory" VARCHAR(512) NOT NULL,
+# "passed" INTEGER,
+# "allowed" INTEGER NOT NULL,
+# "multiplicity" INTEGER NOT NULL DEFAULT 0,
+# CONSTRAINT "applied_credit_directory_allowed_multiplicity_pkey" PRIMARY
KEY ("directory", "allowed", "multiplicity")
+#);
+#CREATE TABLE "sys"."success_credit" (
+# "directory" VARCHAR(512) NOT NULL,
+# "passed" INTEGER,
+# "allowed" INTEGER NOT NULL,
+# CONSTRAINT "success_credit_directory_allowed_pkey" PRIMARY KEY
("directory", "allowed")
+#);
+#COPY 2 RECORDS INTO "sys"."success_credit" FROM stdin USING DELIMITERS
'\t','\n','"';
+#"foo" 1270047915 0
+#"bar" 1270047915 0
+#CREATE TABLE "sys"."success_setting" (
+# "directory" VARCHAR(512) NOT NULL,
+# "rate" INTEGER,
+# "heartbeat" INTEGER,
+# "success_rate" INTEGER,
+# "success_heartbeat" INTEGER,
+# "concurrency" INTEGER,
+# CONSTRAINT "success_setting_directory_pkey" PRIMARY KEY ("directory")
+#);
+[ 2 ]
+#COPY 2 RECORDS INTO "sys"."success_credit" FROM stdin USING DELIMITERS
'\t','\n','"';
+#"foo" 1270047915 0
+#"bar" 1270047915 0
+#CREATE TABLE "sys"."success_setting" (
+# "directory" VARCHAR(512) NOT NULL,
+# "rate" INTEGER,
+# "heartbeat" INTEGER,
+# "success_rate" INTEGER,
+# "success_heartbeat" INTEGER,
+# "concurrency" INTEGER,
+# CONSTRAINT "success_setting_directory_pkey" PRIMARY KEY ("directory")
+#);
+#COPY 2 RECORDS INTO "sys"."success_setting" FROM stdin USING DELIMITERS
'\t','\n','"';
+#"foo" 341 300 341 300 5
+#"bar" 341 300 341 300 5
+#
+[ 2 ]
+#ROLLBACK;
+
+# 13:48:57 >
+# 13:48:57 > Done.
+# 13:48:57 >
+
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
