Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv10154/src/test/Tests
Modified Files:
All
Added Files:
orderby_non_selection_column.sql.src
orderby_non_selection_column.stable.err
orderby_non_selection_column.stable.out
Log Message:
allow for order by on columns (not expressions) not in the selection
--- NEW FILE: orderby_non_selection_column.stable.err ---
stderr of test 'orderby_non_selection_column` in directory 'src/test` itself:
# 09:21:42 >
# 09:21:42 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=33976 --set xrpc_port=48121 --set monet_prompt= --trace
"--dbname=mTests_src_test" --dbinit=" module(sql_server);" ; echo ; echo Over..
# 09:21:42 >
# 09:21:42 >
# 09:21:42 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33976
# 09:21:42 >
# 09:21:43 >
# 09:21:43 > Done.
# 09:21:43 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/All,v
retrieving revision 1.35
retrieving revision 1.36
diff -u -d -r1.35 -r1.36
--- All 1 Apr 2007 22:08:59 -0000 1.35
+++ All 27 Apr 2007 07:27:33 -0000 1.36
@@ -67,6 +67,7 @@
null-byte-hang
orderby_limit
+orderby_non_selection_column
psm
--- NEW FILE: orderby_non_selection_column.stable.out ---
stdout of test 'orderby_non_selection_column` in directory 'src/test` itself:
# 09:21:42 >
# 09:21:42 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=33976 --set xrpc_port=48121 --set monet_prompt= --trace
"--dbname=mTests_src_test" --dbinit=" module(sql_server);" ; echo ; echo Over..
# 09:21:42 >
# Monet Database Server V4.17.1
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 09:21:42 >
# 09:21:42 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33976
# 09:21:42 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
% sys.lim_prob # table_name
% test # name
% varchar # type
% 7 # length
[ "mytest3" ]
[ "mytest2" ]
[ "mytest1" ]
[ "mytest4" ]
[ "mytest2" ]
[ "mytest1" ]
[ "mytest3" ]
% sys.lim_prob # table_name
% dir # name
% varchar # type
% 7 # length
[ "mydir1/" ]
[ "mydir2/" ]
[ "mydir2/" ]
[ "mydir1/" ]
[ "mydir2/" ]
[ "mydir1/" ]
[ "mydir1/" ]
% sys.lim_prob # table_name
% dir # name
% varchar # type
% 7 # length
[ "mydir1/" ]
[ "mydir1/" ]
[ "mydir1/" ]
[ "mydir1/" ]
[ "mydir2/" ]
[ "mydir2/" ]
[ "mydir2/" ]
# 09:21:43 >
# 09:21:43 > Done.
# 09:21:43 >
--- NEW FILE: orderby_non_selection_column.sql.src ---
$RELSRCDIR/../orderby_non_selection_column.sql
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
