Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26186/test/Tests
Modified Files:
All
Added Files:
order_by_simple_exp.sql.src order_by_simple_exp.stable.err
order_by_simple_exp.stable.out
Log Message:
added support for order by on 'very simple' column expressions.
--- NEW FILE: order_by_simple_exp.sql.src ---
$RELSRCDIR/../order_by_simple_exp.sql
--- NEW FILE: order_by_simple_exp.stable.err ---
stderr of test 'order_by_simple_exp` in directory 'src/test` itself:
# 23:24:30 >
# 23:24:30 > 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_open=true --set mapi_port=32999 --set xrpc_port=49898 --set
monet_prompt= --trace "--dbname=mTests_src_test" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 23:24:30 >
# 23:24:31 >
# 23:24:31 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=32999
# 23:24:31 >
# 23:24:31 >
# 23:24:31 > Done.
# 23:24:31 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/All,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -d -r1.42 -r1.43
--- All 13 May 2007 19:14:22 -0000 1.42
+++ All 29 May 2007 21:32:14 -0000 1.43
@@ -83,3 +83,4 @@
rank
function_syntax
procedure_syntax
+order_by_simple_exp
--- NEW FILE: order_by_simple_exp.stable.out ---
stdout of test 'order_by_simple_exp` in directory 'src/test` itself:
# 23:24:30 >
# 23:24:30 > 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_open=true --set mapi_port=32999 --set xrpc_port=49898 --set
monet_prompt= --trace "--dbname=mTests_src_test" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 23:24:30 >
# 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..
# 23:24:31 >
# 23:24:31 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=32999
# 23:24:31 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
% sys.test01 # table_name
% col1 # name
% varchar # type
% 3 # length
[ "ABC" ]
[ "ABD" ]
[ "ABE" ]
[ "ABF" ]
% sys.test01 # table_name
% c0 # name
% varchar # type
% 3 # length
[ "ABC" ]
[ "ABD" ]
[ "ABE" ]
[ "ABF" ]
% sys.test01 # table_name
% c0 # name
% varchar # type
% 3 # length
[ "ABC" ]
[ "ABD" ]
[ "ABE" ]
[ "ABF" ]
# 23:24:31 >
# 23:24:31 > Done.
# 23:24:31 >
-------------------------------------------------------------------------
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
