Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv5366/src/test/bugs/Tests
Modified Files:
Tag: Feb2009
case_parenthesis-bug-sf-1023056.stable.out
case_substring.stable.out order_limit_offset_bug.stable.out
select_not_equal.stable.out zero_or_one_bug.stable.out
Log Message:
disabled mitosis (not ready for production/release)
fixed bugs
2585592 Serial with order by is not working properly
First order then project, added check for project with order)
2582389 subtraction between two columns
Disabled pushing sort down, this causes problems when the sorted
column is used in other selection/projection results)
2581617 cardinality of expression is wrong
When optimizing we sometimes have to fixup the cardinality of
expressions
2523442 IS NULL handled wrong in searched CASE
The case condition column needs its null's removed.
2513620 subquery returns a table crash
Properly detect unexpected table results in the selection
2499537 SQL: time to implement BINOP
Done
Optimizer now also pushes select under cross-product
fixed bug in alter add index
fixed bug in "OR" handling, with views. These require a distinct over
their "%TID%" columns. These TID columns are usualy not include in a
view, but when used now they are re-introduced.
U case_parenthesis-bug-sf-1023056.stable.out
Index: case_parenthesis-bug-sf-1023056.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/case_parenthesis-bug-sf-1023056.stable.out,v
retrieving revision 1.11
retrieving revision 1.11.8.1
diff -u -d -r1.11 -r1.11.8.1
--- case_parenthesis-bug-sf-1023056.stable.out 6 Nov 2007 15:45:26 -0000
1.11
+++ case_parenthesis-bug-sf-1023056.stable.out 11 Feb 2009 19:35:45 -0000
1.11.8.1
@@ -1,19 +1,23 @@
stdout of test 'case_parenthesis-bug-sf-1023056` in directory 'src/test/bugs`
itself:
-# 11:55:42 >
-# 11:55:42 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB/lib:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB/bin"
--set
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-monetdb-pegasus.ins.cwi.nl/sql/dbfarm"
--set
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-monetdb-pegasus.ins.cwi.nl/sql/log"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/xquery_logs"
--set mapi_port=35185 --set monet_prompt= --trace
"--dbname=mTests_src_test_bugs" --dbinit="module(sql_server);
sql_server_start();" ; echo ; echo Over..
-# 11:55:42 >
-
-# Monet Database Server V4.13.1
-# Copyright (c) 1993-2006, CWI. All rights reserved.
-# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs; dynamically linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 10:19:36 >
+# 10:19:36 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33734 --set
xrpc_port=47492 --set
xrpc_docroot=/net/alf.ins.cwi.nl/export/scratch1/niels/rc/sql --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 10:19:36 >
-printf("\nReady.\n");
+# MonetDB server v5.10.0, based on kernel v1.28.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:33734/
+# MonetDB/SQL module v2.28.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -23,7 +27,7 @@
[ 3 ]
% sys. # table_name
-% ifthenelse_or_=_name # name
+% ifthenelse_isnull_or_=_name # name
% tinyint # type
% 1 # length
[ 1 ]
U case_substring.stable.out
Index: case_substring.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/case_substring.stable.out,v
retrieving revision 1.2
retrieving revision 1.2.6.1
diff -u -d -r1.2 -r1.2.6.1
--- case_substring.stable.out 15 Feb 2008 18:17:54 -0000 1.2
+++ case_substring.stable.out 11 Feb 2009 19:35:45 -0000 1.2.6.1
@@ -1,21 +1,23 @@
stdout of test 'case_substring` in directory 'src/test/bugs` itself:
-# 14:09:53 >
-# 14:09:53 > Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=32711 --set
xrpc_port=42408 --set monet_prompt= --trace "--dbname=mTests_src_test_bugs"
"--dbinit= module(sql_server);" ; echo ; echo Over..
-# 14:09:53 >
-
-# MonetDB Server v4.22.0
-# based on GDK v1.22.0
-# Copyright (c) 1993-2008, CWI. All rights reserved.
-# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
-# MonetDB/SQL module v2.22.0 loaded
+# 10:19:45 >
+# 10:19:45 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=33734 --set
xrpc_port=47492 --set
xrpc_docroot=/net/alf.ins.cwi.nl/export/scratch1/niels/rc/sql --set
monet_prompt= --trace "--dbname=mTests_src_test_bugs" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
+# 10:19:45 >
-printf("\nReady.\n");
+# MonetDB server v5.10.0, based on kernel v1.28.0
+# Serving database 'mTests_src_test_bugs', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008- MonetDB B.V., all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:33734/
+# MonetDB/SQL module v2.28.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -38,7 +40,7 @@
[ NULL, NULL, NULL, NULL ]
[ NULL, NULL, NULL, NULL ]
% sys. # table_name
-% ifthenelse_not_isnull_col1 # name
+% isnull_not_isnull_col1 # name
% date # type
% 10 # length
[ 2008-01-01 ]
U zero_or_one_bug.stable.out
Index: zero_or_one_bug.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/zero_or_one_bug.stable.out,v
retrieving revision 1.5
retrieving revision 1.5.2.1
diff -u -d -r1.5 -r1.5.2.1
--- zero_or_one_bug.stable.out 30 Dec 2008 19:19:06 -0000 1.5
+++ zero_or_one_bug.stable.out 11 Feb 2009 19:35:45 -0000 1.5.2.1
@@ -34,7 +34,7 @@
[ 1 ]
[ 1 ]
% ., .L5 # table_name
-% ifthenelse_not_isnull_id1, L5 # name
+% isnull_not_isnull_id1, L5 # name
% int, varchar # type
% 1, 1 # length
[ 1, NULL ]
@@ -47,7 +47,7 @@
[ 8, NULL ]
[ 9, NULL ]
% ., .L7 # table_name
-% ifthenelse_not_isnull_id1, my_col1 # name
+% isnull_not_isnull_id1, my_col1 # name
% int, varchar # type
% 1, 1 # length
[ 1, NULL ]
U order_limit_offset_bug.stable.out
Index: order_limit_offset_bug.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/order_limit_offset_bug.stable.out,v
retrieving revision 1.3
retrieving revision 1.3.2.1
diff -u -d -r1.3 -r1.3.2.1
--- order_limit_offset_bug.stable.out 29 Dec 2008 21:30:08 -0000 1.3
+++ order_limit_offset_bug.stable.out 11 Feb 2009 19:35:45 -0000 1.3.2.1
@@ -65,7 +65,7 @@
% sys.developers, sys.developers, sys.developers, sys.developers,
sys.developers # table_name
% id, name, salary, created_at, updated_at # name
% int, varchar, int, timestamp, timestamp # type
-% 2, 9, 6, 26, 26 # length
+% 1, 9, 6, 26, 26 # length
[ 3, "fixture_3", 100000, 2008-06-10 19:13:40.000000, 2008-06-10
19:13:40.000000 ]
# 17:38:03 >
U select_not_equal.stable.out
Index: select_not_equal.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/select_not_equal.stable.out,v
retrieving revision 1.3
retrieving revision 1.3.2.1
diff -u -d -r1.3 -r1.3.2.1
--- select_not_equal.stable.out 30 Dec 2008 19:19:06 -0000 1.3
+++ select_not_equal.stable.out 11 Feb 2009 19:35:45 -0000 1.3.2.1
@@ -36,7 +36,7 @@
% 2 # length
[ 20 ]
[ 30 ]
-% .tst123 # table_name
+% sys.tst123 # table_name
% col1 # name
% int # type
% 2 # length
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
