Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory 
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26670/src/test/BugTracker/Tests

Modified Files:
        All 
Added Files:
        coalesce_equal_coalesce.SF-1907905.sql 
        coalesce_equal_coalesce.SF-1907905.stable.err 
        coalesce_equal_coalesce.SF-1907905.stable.out 
        decl_sec_tab_in_func_body.SF-1907858.sql 
        decl_sec_tab_in_func_body.SF-1907858.stable.err 
        decl_sec_tab_in_func_body.SF-1907858.stable.out 
        huge_math_expre.SF-1907048.sql 
        join_table_with_floats.SF-1907060.sql 
        join_table_with_floats.SF-1907060.stable.err 
        join_table_with_floats.SF-1907060.stable.out 
        like_perl.SF-1907051.sql like_perl.SF-1907051.stable.err 
        like_perl.SF-1907051.stable.out ms_round.SF-1907063.sql 
        ms_round.SF-1907063.stable.err ms_round.SF-1907063.stable.out 
        range_select.SF-1907006.sql sql_prepare_prob.SF-1909638.sql 
Log Message:
propagated changes of Friday Mar 07 2008 - Monday Mar 10 2008
from the SQL_2-22 branch to the development trunk

===================================================================
2008/03/07 - nielsnes: src/server/bin_optimizer.mx,1.10.2.1
we cannot push a limit simply through a cross product (TODO just repeat
the limit under both the inputs of the corss product, assuming no order
is needed afcourse)
===================================================================
2008/03/07 - romulog: src/test/BugTracker/Tests/All,1.80.2.6
Add tests for bugs:

range_select.SF-1907006
huge_math_expre.SF-1907048
join_table_with_floats.SF-1907060
ms_round.SF-1907063
decl_sec_tab_in_func_body.SF-1907858
coalesce_equal_coalesce.SF-1907905
like_perl.SF-1907051
sql_prepare_prob.SF-1909638
===================================================================
2008/03/08 - romulog: src/sql/ms_functions.sql,1.1.12.1
Correct the function ms_round...

Truncate does not work with floats ;)
===================================================================



--- NEW FILE: coalesce_equal_coalesce.SF-1907905.stable.err ---
stderr of test 'coalesce_equal_coalesce.SF-1907905` in directory 
'src/test/BugTracker` itself:


# 00:33:50 >  
# 00:33:50 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=39578 --set 
xrpc_port=40023 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:33:50 >  

#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf)

# 00:33:51 >  
# 00:33:51 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=39578 
# 00:33:51 >  

MAPI  = [EMAIL PROTECTED]:39578
QUERY = CREATE FUNCTION fDocColumnsWithRank(TableName varchar(400))
ERROR = !SELECT: no such operator 'columnproperty'
MAPI  = [EMAIL PROTECTED]:39578
QUERY = drop function fDocColumnsWithRank;
ERROR = !DROP FUNCTION: no such function 'fdoccolumnswithrank'

# 00:33:51 >  
# 00:33:51 >  Done.
# 00:33:51 >  


--- NEW FILE: decl_sec_tab_in_func_body.SF-1907858.stable.err ---
stderr of test 'decl_sec_tab_in_func_body.SF-1907858` in directory 
'src/test/BugTracker` itself:


# 00:07:58 >  
# 00:07:58 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=36386 --set 
xrpc_port=40452 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:07:58 >  

#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf)

# 00:07:58 >  
# 00:07:58 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=36386 
# 00:07:58 >  


# 00:07:58 >  
# 00:07:58 >  Done.
# 00:07:58 >  


--- NEW FILE: huge_math_expre.SF-1907048.sql ---
create table t1 (z real);
create table t2 (name string, dered_g real, dered_r real);
SELECT p.name FROM t1 as s, t2 as p WHERE
(-0.399*(dered_g-4.79*LOG10(s.z/0.03)-3.65*(dered_g-dered_r)-39.55))> 10.7
LIMIT 100000;

drop table t2;
drop table t1;

--- NEW FILE: coalesce_equal_coalesce.SF-1907905.sql ---
CREATE TABLE syscolumns(
                id int,
                length int,
                uid int,
                nme char(100),
                xtype char(100)
);

CREATE TABLE spt_datatype_info(
                length int,
                ss_dtype varchar(100),
                "AUTO_INCREMENT" varchar(100)
);

CREATE FUNCTION fDocColumnsWithRank(TableName varchar(400))
RETURNS float
BEGIN
        return table ( SELECT c.nme as nme
                        FROM
                                spt_datatype_info d,
                                syscolumns c
                        WHERE
                        coalesce(d."AUTO_INCREMENT",0) =
                        coalesce(ColumnProperty (c.id, c.nme,'IsIdentity'),0) );
END;

drop function fDocColumnsWithRank;
drop table syscolumns;
drop table spt_datatype_info;

--- NEW FILE: like_perl.SF-1907051.stable.err ---
stderr of test 'like_perl.SF-1907051` in directory 'src/test/BugTracker` itself:


# 00:07:59 >  
# 00:07:59 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=36386 --set 
xrpc_port=40452 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:07:59 >  

#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf)

# 00:07:59 >  
# 00:07:59 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=36386 
# 00:07:59 >  


# 00:07:59 >  
# 00:07:59 >  Done.
# 00:07:59 >  


--- NEW FILE: decl_sec_tab_in_func_body.SF-1907858.sql ---
CREATE FUNCTION fR(x float, types float)
RETURNS float
BEGIN
        DECLARE TABLE typesTable(
                type varchar(16)
        );

        INSERT into typesTable (type) values ('asdasd');

        DECLARE TABLE region(
                regionid bigint,
                type varchar(16)
        );
        Return x;
END;

drop function fR;

--- NEW FILE: join_table_with_floats.SF-1907060.sql ---
create table t2 (id float);
create table t1 (age float);

select age from t1, t2 where id < 0.0 limit 10;

drop table t1;
drop table t2;


--- NEW FILE: join_table_with_floats.SF-1907060.stable.err ---
stderr of test 'join_table_with_floats.SF-1907060` in directory 
'src/test/BugTracker` itself:


# 00:15:27 >  
# 00:15:27 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=30709 --set 
xrpc_port=40808 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:15:27 >  

#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf)

# 00:15:27 >  
# 00:15:27 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=30709 
# 00:15:27 >  


# 00:15:27 >  
# 00:15:27 >  Done.
# 00:15:27 >  


--- NEW FILE: range_select.SF-1907006.sql ---
select name from tables where 0<id>10;

Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.85
retrieving revision 1.86
diff -u -d -r1.85 -r1.86
--- All 7 Mar 2008 16:13:23 -0000       1.85
+++ All 10 Mar 2008 10:16:29 -0000      1.86
@@ -103,3 +103,11 @@
 case_with_aggr.SF-1876779
 with_row_number.SF-1898089
 savepoint-SF.1898533
+range_select.SF-1907006
+huge_math_expre.SF-1907048
+join_table_with_floats.SF-1907060
+ms_round.SF-1907063
+decl_sec_tab_in_func_body.SF-1907858
+coalesce_equal_coalesce.SF-1907905
+like_perl.SF-1907051
+sql_prepare_prob.SF-1909638

--- NEW FILE: join_table_with_floats.SF-1907060.stable.out ---
stdout of test 'join_table_with_floats.SF-1907060` in directory 
'src/test/BugTracker` itself:


# 00:15:27 >  
# 00:15:27 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=30709 --set 
xrpc_port=40808 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:15:27 >  



# 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 64bit 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://amelia.ins.cwi.nl:30709/
# MonetDB/SQL module v2.22.1 loaded

Ready.
#function user.main():void;
#    clients.quit();
#end main;

Over..

# 00:15:27 >  
# 00:15:27 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=30709 
# 00:15:27 >  

% sys.t1 # table_name
% age # name
% double # type
% 22 # length

# 00:15:27 >  
# 00:15:27 >  Done.
# 00:15:27 >  


--- NEW FILE: sql_prepare_prob.SF-1909638.sql ---
CREATE FUNCTION fEq (ra float, decim float, r float)
RETURNS int
BEGIN
        return 0;
END;

SELECT  fEq(212.82496,1.27536,0.167);
SELECT  fEq(134.44708,-0.2,0.167);
SELECT  fEq(261,-90,0.167);


drop function fEq;

--- NEW FILE: like_perl.SF-1907051.stable.out ---
stdout of test 'like_perl.SF-1907051` in directory 'src/test/BugTracker` itself:


# 00:07:59 >  
# 00:07:59 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=36386 --set 
xrpc_port=40452 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:07:59 >  

# 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 64bit 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://amelia.ins.cwi.nl:36386/
# MonetDB/SQL module v2.22.1 loaded

Ready.
#function user.main():void;
#    clients.quit();
#end main;

Over..

# 00:07:59 >  
# 00:07:59 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=36386 
# 00:07:59 >  

% sys.tables # table_name
% name # name
% varchar # type
% 0 # length

# 00:07:59 >  
# 00:07:59 >  Done.
# 00:07:59 >  


--- NEW FILE: ms_round.SF-1907063.stable.out ---
stdout of test 'ms_round.SF-1907063` in directory 'src/test/BugTracker` itself:


# 00:07:58 >  
# 00:07:58 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=36386 --set 
xrpc_port=40452 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:07:58 >  

# 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 64bit 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://amelia.ins.cwi.nl:36386/
# MonetDB/SQL module v2.22.1 loaded

Ready.
#function user.main():void;
#    clients.quit();
#end main;

Over..

# 00:07:58 >  
# 00:07:58 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=36386 
# 00:07:58 >  

% sys. # table_name
% round_id # name
% double # type
% 22 # length

# 00:07:58 >  
# 00:07:58 >  Done.
# 00:07:58 >  


--- NEW FILE: ms_round.SF-1907063.stable.err ---
stderr of test 'ms_round.SF-1907063` in directory 'src/test/BugTracker` itself:


# 00:07:58 >  
# 00:07:58 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=36386 --set 
xrpc_port=40452 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:07:58 >  

#warning: please don't forget to set your vault key!
#(see /ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf)

# 00:07:58 >  
# 00:07:58 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=36386 
# 00:07:58 >  


# 00:07:58 >  
# 00:07:58 >  Done.
# 00:07:58 >  


--- NEW FILE: coalesce_equal_coalesce.SF-1907905.stable.out ---
stdout of test 'coalesce_equal_coalesce.SF-1907905` in directory 
'src/test/BugTracker` itself:


# 00:33:50 >  
# 00:33:50 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=39578 --set 
xrpc_port=40023 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:33:50 >  



# 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 64bit 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://amelia.ins.cwi.nl:39578/
# MonetDB/SQL module v2.22.1 loaded

Ready.
#function user.main():void;
#    clients.quit();
#end main;

Over..

# 00:33:51 >  
# 00:33:51 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=39578 
# 00:33:51 >  


# 00:33:51 >  
# 00:33:51 >  Done.
# 00:33:51 >  


--- NEW FILE: like_perl.SF-1907051.sql ---
select name from tables where name LIKE '%????%';


--- NEW FILE: decl_sec_tab_in_func_body.SF-1907858.stable.out ---
stdout of test 'decl_sec_tab_in_func_body.SF-1907858` in directory 
'src/test/BugTracker` itself:


# 00:07:58 >  
# 00:07:58 >   mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/etc/monetdb5.conf" 
--debug=10 --set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/lib/MonetDB5/bin"
 --set 
"gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/dbfarm" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/Stable/MonetDB5/var/MonetDB5/sql_logs"
  --set mapi_open=true --set xrpc_open=true --set mapi_port=36386 --set 
xrpc_port=40452 --set monet_prompt= --trace  
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include 
sql;" ; echo ; echo Over..
# 00:07:58 >  

# 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 64bit 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://amelia.ins.cwi.nl:36386/
# MonetDB/SQL module v2.22.1 loaded

Ready.
#function user.main():void;
#    clients.quit();
#end main;

Over..

# 00:07:58 >  
# 00:07:58 >  mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=36386 
# 00:07:58 >  


# 00:07:58 >  
# 00:07:58 >  Done.
# 00:07:58 >  


--- NEW FILE: ms_round.SF-1907063.sql ---
create table t23(id float);
select round(id,8) from t23; 

drop table t23;


-------------------------------------------------------------------------
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

Reply via email to