Changeset: 9b531a83053d for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9b531a83053d Modified Files: sql/test/BugTracker-2011/Tests/All sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.sql sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.stable.err sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.stable.out Branch: Aug2011 Log Message:
Added test for bug 2877. diffs (139 lines): diff --git a/sql/test/BugTracker-2011/Tests/All b/sql/test/BugTracker-2011/Tests/All --- a/sql/test/BugTracker-2011/Tests/All +++ b/sql/test/BugTracker-2011/Tests/All @@ -35,6 +35,7 @@ multicolumn_constraints.Bug-2849 CASE_nested_functions.Bug-2852 FK_self_reference.Bug-2862 time_precision.Bug-2873 +default-interval.Bug-2877 multiple-joins.Bug-2879 delete-large-table.Bug-2882 HAVE_PERL?perl-table_info.Bug-2885 diff --git a/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.sql b/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.sql @@ -0,0 +1,9 @@ +start transaction; +create table table2877 ( + i int, + c1 interval hour to second default interval '1:00:00' hour to second, + c2 interval hour to second default 3600 +); +insert into table2877 (i) values (1); +select * from table2877; +rollback; diff --git a/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.stable.err b/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.stable.err @@ -0,0 +1,37 @@ +stderr of test 'default-interval.Bug-2877` in directory 'test/BugTracker-2011` itself: + + +# 12:40:50 > +# 12:40:50 > mserver5 --debug=10 --set gdk_nr_threads=0 --set "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" --set mapi_open=true --set mapi_port=30322 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_test_BugTracker-2011" --set mal_listing=0 ; echo ; echo Over.. +# 12:40:50 > + +# builtin opt gdk_dbname = demo +# builtin opt gdk_dbfarm = /ufs/sjoerd/Monet-candidate/var/monetdb5/dbfarm +# builtin opt gdk_debug = 0 +# builtin opt gdk_alloc_map = no +# builtin opt gdk_vmtrim = yes +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt gdk_dbfarm = /ufs/sjoerd/Monet-candidate/var/MonetDB +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 30322 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbname = mTests_test_BugTracker-2011 +# cmdline opt mal_listing = 0 + +# 12:40:50 > +# 12:40:50 > mclient -lsql -ftest -i -e --host=ottar --port=30322 +# 12:40:50 > + + +# 12:40:50 > +# 12:40:50 > Done. +# 12:40:50 > + diff --git a/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.stable.out b/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.stable.out @@ -0,0 +1,67 @@ +stdout of test 'default-interval.Bug-2877` in directory 'test/BugTracker-2011` itself: + + +# 12:40:50 > +# 12:40:50 > mserver5 --debug=10 --set gdk_nr_threads=0 --set "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" --set mapi_open=true --set mapi_port=30322 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_test_BugTracker-2011" --set mal_listing=0 ; echo ; echo Over.. +# 12:40:50 > + +# MonetDB 5 server v11.5.2 +# This is an unreleased version +# Serving database 'mTests_test_BugTracker-2011', using 4 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 7.749 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://ottar.ins.cwi.nl:30322/ +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. +# SQL catalog created, loading sql scripts once +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/10_math.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/11_times.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/12_url.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/13_date.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/14_inet.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/15_history.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/16_tracelog.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/17_compress.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/18_dictionary.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/19_cluster.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/20_vacuum.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/21_dependency_functions.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/22_clients.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/23_skyserver.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/24_zorder.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/25_debug.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/40_geom.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/80_udf.sql +# SQL loading sql scripts /net/ottar/export/scratch0/sjoerd/bin/candidate/.stowdir/MonetDB/lib64/monetdb5/createdb/99_system.sql + +Over.. + +# 12:40:50 > +# 12:40:50 > mclient -lsql -ftest -i -e --host=ottar --port=30322 +# 12:40:50 > + +#start transaction; +#create table table2877 ( +# i int, +# c1 interval hour to second default interval '1:00:00' hour to second, +# c2 interval hour to second default 3600 +#); +#insert into table2877 (i) values (1); +[ 1 ] +#select * from table2877; +% sys.table2877, sys.table2877, sys.table2877 # table_name +% i, c1, c2 # name +% int, sec_interval, sec_interval # type +% 1, 0, 0 # length +[ 1, 3600, 3600 ] +#rollback; + +# 12:40:50 > +# 12:40:50 > Done. +# 12:40:50 > + _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
