Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv16471/src/test/BugTracker/Tests
Modified Files:
All
Added Files:
multi-column-constraint.SF-1964587.sql
multi-column-constraint.SF-1964587.stable.err
multi-column-constraint.SF-1964587.stable.out
Log Message:
propagated changes of Thursday May 15 2008
from the SQL_2-22 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/05/15 - sjoerd: src/test/BugTracker/Tests/All,1.80.2.12
src/test/BugTracker/Tests/multi-column-constraint.SF-1964587.sql,1.1.2.1
src/test/BugTracker/Tests/multi-column-constraint.SF-1964587.stable.err,1.1.2.1
src/test/BugTracker/Tests/multi-column-constraint.SF-1964587.stable.out,1.1.2.1
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 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.92
retrieving revision 1.93
diff -u -d -r1.92 -r1.93
--- All 8 May 2008 09:25:49 -0000 1.92
+++ All 16 May 2008 07:36:41 -0000 1.93
@@ -120,3 +120,4 @@
is_not_null_syntax_error.SF-1959456
order_by_over_table_from_another_function.SF-1959822
sql_div.SF-1959357
+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
