Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv32753
Added Files:
select_multiple_not_null_constraints.SF-1926074.sql
select_multiple_not_null_constraints.SF-1926074.stable.err
select_multiple_not_null_constraints.SF-1926074.stable.out
Log Message:
added test for monet bug SF-1926074
--- NEW FILE: select_multiple_not_null_constraints.SF-1926074.stable.out ---
stdout of test 'select_multiple_not_null_constraints.SF-1926074` in directory
'src/test/BugTracker` itself:
# 13:48:11 >
# 13:48:11 > mserver5
"--config=/export/scratch1/rijke/monetdb-head/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/export/scratch1/rijke/monetdb-head/lib/MonetDB5:/export/scratch1/rijke/monetdb-head/lib/MonetDB5/lib:/export/scratch1/rijke/monetdb-head/lib/MonetDB5/bin"
--set "gdk_dbfarm=/export/scratch1/rijke/monetdb-head/var/MonetDB5/dbfarm"
--set "sql_logdir=/export/scratch1/rijke/monetdb-head/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=34875 --set
xrpc_port=48603 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 13:48:11 >
# MonetDB server v5.5.0, based on kernel v1.23.0
# 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://vr7:34875/
# MonetDB/SQL module v2.23.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 13:48:11 >
# 13:48:11 > mclient -lsql -umonetdb -Pmonetdb --host=vr7 --port=34875
# 13:48:11 >
[ 1 ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, NULL, NULL, NULL, NULL ]
[ 1 ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, NULL, NULL, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, NULL, NULL, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, NULL, NULL, NULL ]
[ 1 ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, NULL, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, NULL, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, NULL, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, NULL, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, NULL, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, NULL, NULL ]
[ 1 ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, 1, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, 1, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, 1, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
[ 1, 1, 1, 1, NULL ]
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
% sys.table_a, sys.table_a, sys.table_a, sys.table_a, sys.table_a #
table_name
% column_1, column_2, column_3, column_4, column_5 # name
% int, int, int, int, int # type
% 1, 1, 1, 1, 1 # length
# 13:48:11 >
# 13:48:11 > Done.
# 13:48:11 >
--- NEW FILE: select_multiple_not_null_constraints.SF-1926074.stable.err ---
stderr of test 'select_multiple_not_null_constraints.SF-1926074` in directory
'src/test/BugTracker` itself:
# 13:48:11 >
# 13:48:11 > mserver5
"--config=/export/scratch1/rijke/monetdb-head/etc/monetdb5.conf" --debug=10
--set
"monet_mod_path=/export/scratch1/rijke/monetdb-head/lib/MonetDB5:/export/scratch1/rijke/monetdb-head/lib/MonetDB5/lib:/export/scratch1/rijke/monetdb-head/lib/MonetDB5/bin"
--set "gdk_dbfarm=/export/scratch1/rijke/monetdb-head/var/MonetDB5/dbfarm"
--set "sql_logdir=/export/scratch1/rijke/monetdb-head/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=34875 --set
xrpc_port=48603 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 13:48:11 >
#warning: please don't forget to set your vault key!
#(see /export/scratch1/rijke/monetdb-head/etc/monetdb5.conf)
# 13:48:11 >
# 13:48:11 > mclient -lsql -umonetdb -Pmonetdb --host=vr7 --port=34875
# 13:48:11 >
# 13:48:11 >
# 13:48:11 > Done.
# 13:48:11 >
--- NEW FILE: select_multiple_not_null_constraints.SF-1926074.sql ---
CREATE TABLE TABLE_A (
COLUMN_1 INTEGER,
COLUMN_2 INTEGER,
COLUMN_3 INTEGER,
COLUMN_4 INTEGER,
COLUMN_5 INTEGER
);
INSERT INTO TABLE_A (
COLUMN_1,
COLUMN_2,
COLUMN_3,
COLUMN_4,
COLUMN_5 )
VALUES (
1,
NULL,
NULL,
NULL,
NULL
);
SELECT * FROM TABLE_A;
UPDATE TABLE_A
SET COLUMN_2 = 1;
SELECT * FROM TABLE_A;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL
AND COLUMN_3 IS NULL;
UPDATE TABLE_A
SET COLUMN_3 = 1;
SELECT *
FROM TABLE_A;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_3 IS NOT NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL
AND COLUMN_3 IS NOT NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL
AND COLUMN_3 IS NOT NULL
AND COLUMN_4 IS NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL
AND COLUMN_4 IS NULL
AND COLUMN_3 IS NOT NULL;
UPDATE TABLE_A
SET COLUMN_4 = 1;
SELECT *
FROM TABLE_A;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_3 IS NOT NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL
AND COLUMN_3 IS NOT NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL
AND COLUMN_3 IS NOT NULL
AND COLUMN_4 IS NULL;
SELECT *
FROM TABLE_A
WHERE COLUMN_2 IS NOT NULL
AND COLUMN_4 IS NULL
AND COLUMN_3 IS NOT NULL;
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
