Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv22437
Modified Files:
Tag: SQL_2-22
All
Added Files:
Tag: SQL_2-22
multi-column-constraint.SF-1964587.sql
multi-column-constraint.SF-1964587.stable.err
multi-column-constraint.SF-1964587.stable.out
Log Message:
Added test for bug [ 1964587 ] mclient doesn't dump multi-colum unique
constraint correctly
--- NEW FILE: multi-column-constraint.SF-1964587.sql ---
create table test_property(subject integer, p1 integer, p2 integer,
unique(subject, p1), unique(subject, p2));
\D
--- NEW FILE: multi-column-constraint.SF-1964587.stable.err ---
stderr of test 'multi-column-constraint.SF-1964587` in directory
'src/test/BugTracker` itself:
# 16:17:36 >
# 16:17:36 > mserver5
"--config=/ufs/sjoerd/Monet-virgin-stable/etc/monetdb5.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5/.libs:/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set
"sql_logdir=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/sql_logs"
--set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=32134 --set
xrpc_port=45022 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 16:17:36 >
#warning: please don't forget to set your vault key!
#(see /ufs/sjoerd/Monet-virgin-stable/etc/monetdb5.conf)
# 16:17:36 >
# 16:17:36 > mclient -lsql -umonetdb -Pmonetdb --host=ottar --port=32134
# 16:17:36 >
# 16:17:36 >
# 16:17:36 > Done.
# 16:17:36 >
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.80.2.11
retrieving revision 1.80.2.12
diff -u -d -r1.80.2.11 -r1.80.2.12
--- All 21 Mar 2008 08:55:13 -0000 1.80.2.11
+++ All 15 May 2008 14:18:56 -0000 1.80.2.12
@@ -115,3 +115,4 @@
count_crash.SF-1918780
table_function_column_crash.SF-1913572
drop_function.SF-1910396
+multi-column-constraint.SF-1964587
--- NEW FILE: multi-column-constraint.SF-1964587.stable.out ---
stdout of test 'multi-column-constraint.SF-1964587` in directory
'src/test/BugTracker` itself:
# 16:17:36 >
# 16:17:36 > mserver5
"--config=/ufs/sjoerd/Monet-virgin-stable/etc/monetdb5.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5/.libs:/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set
"sql_logdir=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/sql_logs"
--set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=32134 --set
xrpc_port=45022 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 16:17:36 >
# MonetDB server v5.4.1, based on kernel v1.22.1
# Serving database 'mTests_src_test_BugTracker'
# Compiled for x86_64-unknown-linux-gnu/64bit with 32bit OIDs dynamically linked
# Copyright (c) 1993-2008 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://ottar.ins.cwi.nl:32134/
# MonetDB/SQL module v2.22.1 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 16:17:36 >
# 16:17:36 > mclient -lsql -umonetdb -Pmonetdb --host=ottar --port=32134
# 16:17:36 >
START TRANSACTION;
CREATE TABLE "sys"."test_property" (
"subject" int,
"p1" int,
"p2" int,
CONSTRAINT "test_property_subject_p1_unique" UNIQUE ("subject", "p1"),
CONSTRAINT "test_property_subject_p2_unique" UNIQUE ("subject", "p2")
);
COPY 0 RECORDS INTO "sys"."test_property" FROM stdin USING DELIMITERS '\t';
COMMIT;
# 16:17:36 >
# 16:17:36 > Done.
# 16:17:36 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
