Changeset: a33fa2d35a6e for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a33fa2d35a6e
Added Files:
sql/test/snodgrass/Tests/cast_select.sql
Removed Files:
sql/test/snodgrass/Tests/cast_select.SQL.bat
sql/test/snodgrass/Tests/cast_select.SQL.sh
sql/test/snodgrass/cast_select.sql
Modified Files:
sql/test/snodgrass/Tests/All
sql/test/snodgrass/Tests/cast_select.stable.err
sql/test/snodgrass/Tests/cast_select.stable.out
Branch: Apr2012
Log Message:
snodgrass: converted cast test to mclient
diffs (truncated from 427 to 300 lines):
diff --git a/sql/test/snodgrass/Tests/All b/sql/test/snodgrass/Tests/All
--- a/sql/test/snodgrass/Tests/All
+++ b/sql/test/snodgrass/Tests/All
@@ -1,1 +1,1 @@
-HAVE_JDBCCLIENT_JAR?cast_select
+cast_select
diff --git a/sql/test/snodgrass/Tests/cast_select.SQL.bat
b/sql/test/snodgrass/Tests/cast_select.SQL.bat
deleted file mode 100755
--- a/sql/test/snodgrass/Tests/cast_select.SQL.bat
+++ /dev/null
@@ -1,11 +0,0 @@
-@echo off
-
-echo user=monetdb> .monetdb
-echo password=monetdb>> .monetdb
-
-prompt # $t $g
-echo on
-
-java nl.cwi.monetdb.client.JdbcClient -h %HOST% -p %MAPIPORT% -d %TSTDB% -e -f
"%RELSRCDIR%\..\cast_select.sql" 2>&1
-
-@del .monetdb
diff --git a/sql/test/snodgrass/Tests/cast_select.SQL.sh
b/sql/test/snodgrass/Tests/cast_select.SQL.sh
deleted file mode 100755
--- a/sql/test/snodgrass/Tests/cast_select.SQL.sh
+++ /dev/null
@@ -1,13 +0,0 @@
-#!/bin/sh
-
-cat << EOF > .monetdb
-user=monetdb
-password=monetdb
-EOF
-
-LC_ALL="`locale -a | grep -i en_us | grep -i utf | head -n 1`"
-export LC_ALL
-
-Mlog -x "$MTIMEOUT java nl.cwi.monetdb.client.JdbcClient -h $HOST -p $MAPIPORT
-d ${TSTDB} -e -f \"$RELSRCDIR/../cast_select.sql\" 2>&1"
-
-rm -f .monetdb
diff --git a/sql/test/snodgrass/cast_select.sql
b/sql/test/snodgrass/Tests/cast_select.sql
rename from sql/test/snodgrass/cast_select.sql
rename to sql/test/snodgrass/Tests/cast_select.sql
--- a/sql/test/snodgrass/cast_select.sql
+++ b/sql/test/snodgrass/Tests/cast_select.sql
@@ -13,15 +13,15 @@ SELECT CAST( DATE '1997-01-01' AS TIMEST
-- intervals
SELECT CAST('2' AS INTERVAL MONTH );
SELECT CAST('3-7' AS INTERVAL MONTH );
-SELECT CAST(INTERVAL '8-7' YEAR TO MONTH AS INTERVAL MONTH(2) ); -- err:
exception is raised
+-- SELECT CAST(INTERVAL '8-7' YEAR TO MONTH AS INTERVAL MONTH(2) ); -- err:
exception is raised
SELECT CAST( INTERVAL '3' YEAR AS INTERVAL YEAR TO MONTH ) = INTERVAL '3-0'
YEAR TO MONTH;
SELECT CAST( 103 AS INTERVAL MONTH ) = INTERVAL '103' MONTH;
-SELECT CAST( 103 AS INTERVAL MONTH(2) ); -- err: overflow exception
+-- SELECT CAST( 103 AS INTERVAL MONTH(2) ); -- err: overflow exception
SELECT CAST('2 12:34' AS INTERVAL DAY TO MINUTE );
SELECT CAST('12:34' AS INTERVAL DAY TO MINUTE ); -- err: works not
SELECT CAST( INTERVAL'86 00:00:00' DAY TO SECOND AS INTERVAL HOUR TO SECOND )
= INTERVAL '2064:00:00' HOUR TO SECOND;
SELECT CAST('86 00:00:00' AS INTERVAL HOUR(3) TO SECOND ); -- err: overflow
exception
SELECT CAST( CAST( 7430400 AS INTERVAL SECOND ) AS INTERVAL DAY TO SECOND ) =
INTERVAL '86 00:00:00' DAY TO SECOND;
-SELECT CAST(DATE '1997-01-01' AS CHARACTER) = '1997-01-01';
-SELECT CAST(INTERVAL '7430400' SECOND AS INTEGER) = 7430400;
-SELECT CAST(CAST(INTERVAL '2064:00:00' HOUR TO SECOND AS INTERVAL SECOND) AS
INTEGER) = 7430400;
+SELECT CAST(DATE '1997-01-01' AS CHARACTER(10)) = '1997-01-01';
+SELECT CAST(INTERVAL '7430400' SECOND AS BIGINT) = 7430400000;
+SELECT CAST(CAST(INTERVAL '2064:00:00' HOUR TO SECOND AS INTERVAL SECOND) AS
BIGINT) = 7430400000;
diff --git a/sql/test/snodgrass/Tests/cast_select.stable.err
b/sql/test/snodgrass/Tests/cast_select.stable.err
--- a/sql/test/snodgrass/Tests/cast_select.stable.err
+++ b/sql/test/snodgrass/Tests/cast_select.stable.err
@@ -1,22 +1,12 @@
stderr of test 'cast_select` in directory 'test/snodgrass` itself:
+MAPI = monetdb@sofia:38848
+QUERY = SELECT CAST(TIME '12:34:56' AS TIMESTAMP WITH TIME ZONE) = TIMESTAMP
'1997-07-23 12:34:56-07:00';
+ERROR = !types time(1,0) and timestamptz(7,0) are not equal
+MAPI = monetdb@sofia:38848
+QUERY = SELECT CAST('12:34' AS INTERVAL DAY TO MINUTE ); -- err: works not
+ERROR = !wrong format (12:34)
+MAPI = monetdb@sofia:38848
+QUERY = SELECT CAST('86 00:00:00' AS INTERVAL HOUR(3) TO SECOND ); -- err:
overflow exception
+ERROR = !wrong format (86 00:00:00)
-# 10:11:49 >
-# 10:11:49 > Mtimeout -timeout 300 Mserver
"--config=/ufs/fabian/scratch/monetdb/stable/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-monetdb-pegasus.ins.cwi.nl/sql/dbfarm"
--set
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-monetdb-pegasus.ins.cwi.nl/sql/log"
--set mapi_port=30930 --set monet_prompt= --trace
"--dbname=mTests_src_test_snodgrass" --dbinit="module(sql_server);
sql_server_start();" ; echo ; echo Over..
-# 10:11:49 >
-
-
-# 10:11:50 >
-# 10:11:50 > Mtimeout -timeout 180 ./cast_select.SQL cast_select
-# 10:11:50 >
-
-
-# 10:11:50 >
-# 10:11:50 > Mtimeout -timeout 60 java -jar
/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/build-stable-monetdb-pegasus.ins.cwi.nl/sql/src/jdbc/jdbcclient-1.4.jar
-h localhost -p 30930 -d mTests_src_test_snodgrass -e -f
../../../../../../../../..//scratch1/fabian/monetdb/stable/sql/src/test/snodgrass/Tests/../cast_select.sql
-# 10:11:50 >
-
-
-# 10:11:51 >
-# 10:11:51 > Done.
-# 10:11:51 >
-
diff --git a/sql/test/snodgrass/Tests/cast_select.stable.out
b/sql/test/snodgrass/Tests/cast_select.stable.out
--- a/sql/test/snodgrass/Tests/cast_select.stable.out
+++ b/sql/test/snodgrass/Tests/cast_select.stable.out
@@ -1,181 +1,152 @@
stdout of test 'cast_select` in directory 'test/snodgrass` itself:
-# 10:11:49 >
-# 10:11:49 > Mtimeout -timeout 300 Mserver
"--config=/ufs/fabian/scratch/monetdb/stable/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/stable/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-monetdb-pegasus.ins.cwi.nl/sql/dbfarm"
--set
"sql_logdir=/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-stable-monetdb-pegasus.ins.cwi.nl/sql/log"
--set mapi_port=30930 --set monet_prompt= --trace
"--dbname=mTests_src_test_snodgrass" --dbinit="module(sql_server);
sql_server_start();" ; echo ; echo Over..
-# 10:11:49 >
+# 17:38:29 >
+# 17:38:29 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-Apr2012-sofia.ins.cwi.nl/sql/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=30049" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2"
"--dbname=mTests_test_snodgrass" "--set" "mal_listing=0"
+# 17:38:29 >
-# Monet Database Server V4.12.1
-# Copyright (c) 1993-2006, 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.
-
+# MonetDB 5 server v11.9.0 "Apr2012-0474aa42f907+"
+# Serving database 'mTests_test_snodgrass', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
+# Found 15.630 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://sofia.ins.cwi.nl:30049/
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
Ready.
+# SQL catalog created, loading sql scripts once
+# loading sql script: 09_like.sql
+# loading sql script: 10_math.sql
+# loading sql script: 11_times.sql
+# loading sql script: 12_url.sql
+# loading sql script: 13_date.sql
+# loading sql script: 14_inet.sql
+# loading sql script: 15_history.sql
+# loading sql script: 16_tracelog.sql
+# loading sql script: 17_compress.sql
+# loading sql script: 18_dictionary.sql
+# loading sql script: 19_cluster.sql
+# loading sql script: 20_vacuum.sql
+# loading sql script: 21_dependency_functions.sql
+# loading sql script: 22_clients.sql
+# loading sql script: 23_skyserver.sql
+# loading sql script: 24_zorder.sql
+# loading sql script: 25_debug.sql
+# loading sql script: 39_analytics.sql
+# loading sql script: 40_geom.sql
+# loading sql script: 50_datacell.sql
+# loading sql script: 80_udf.sql
+# loading sql script: 99_system.sql
+# 17:38:29 >
+# 17:38:29 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=sofia"
"--port=30049"
+# 17:38:29 >
-# 10:11:50 >
-# 10:11:50 > Mtimeout -timeout 180 ./cast_select.SQL cast_select
-# 10:11:50 >
-
-
-# 10:11:50 >
-# 10:11:50 > Mtimeout -timeout 60 java -jar
/net/pegasus.ins.cwi.nl/export/scratch0/fabian/vtmp/build-stable-monetdb-pegasus.ins.cwi.nl/sql/src/jdbc/jdbcclient-1.4.jar
-h localhost -p 30930 -d mTests_src_test_snodgrass -e -f
../../../../../../../../..//scratch1/fabian/monetdb/stable/sql/src/test/snodgrass/Tests/../cast_select.sql
-# 10:11:50 >
-
- -- simultaneously
--- dates, times and timestamps
-SELECT CAST('1996-02-24' AS DATE) = DATE '1996-02-24';
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST('12:34:56' AS TIME) = TIME '12:34:56';
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST(TIME '12:34:56' AS TIMESTAMP WITH TIME ZONE) = TIMESTAMP
'1997-07-23 12:34:56-07:00';
-Error on line 5: types time(1,0) (daytime) and timestamptz(7,0) (timestamp)
are not equal
---rollback;
-SELECT CAST( TIME '12:34:56.123' AS TIME(6) ) = TIME '12:34:56.123000';
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST( TIME '12:34:56.123' AS TIME(1) ) = TIME '12:34:56.1';
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST( TIMESTAMP '1997-07-23 12:34:56.123' AS TIME(6) ) = TIME
'12:34:56.123000';
-+----------------+
-| =_single_value |
-+================+
-| false |
-+----------------+
-1 row
-
-SELECT CAST( TIMESTAMP '1997-07-23 12:34:56.123' AS DATE ) = DATE '1997-07-23';
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST( DATE '1997-01-01' AS TIMESTAMP(4)) = '1997-01-01 00:00:00.0000';
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-
--- intervals
-SELECT CAST('2' AS INTERVAL MONTH );
-+--------------+
-| single_value |
-+==============+
-| 2 |
-+--------------+
-1 row
-
-SELECT CAST('3-7' AS INTERVAL MONTH );
-+--------------+
-| single_value |
-+==============+
-| 3 |
-+--------------+
-1 row
-
-SELECT CAST(INTERVAL '8-7' YEAR TO MONTH AS INTERVAL MONTH(2) ); -- err:
overflows
-Error: meuh, 103 doesn't fit in two digits... FIXME
-
-SELECT CAST( INTERVAL '3' YEAR AS INTERVAL YEAR TO MONTH ) = INTERVAL '3-0'
YEAR TO MONTH;
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST( 103 AS INTERVAL MONTH ) = INTERVAL '103' MONTH;
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST( 103 AS INTERVAL MONTH(2) ); -- err: overflow exception
-Error: meuh, 103 doesn't fit in two digits... FIXME
-
-SELECT CAST('2 12:34' AS INTERVAL DAY TO MINUTE );
-+--------------+
-| single_value |
-+==============+
-| 218040.000 |
-+--------------+
-1 row
-
-SELECT CAST('12:34' AS INTERVAL DAY TO MINUTE ); -- err: works not
-Error on line 21: [22000] wrong format (12:34)
-SELECT CAST( INTERVAL'86 00:00:00' DAY TO SECOND AS INTERVAL HOUR TO SECOND )
= INTERVAL '2064:00:00' HOUR TO SECOND;
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST('86 00:00:00' AS INTERVAL HOUR(3) TO SECOND ); -- err: overflow
exception
-Error on line 23: [22000] wrong format (86 00:00:00)
-SELECT CAST( CAST( 7430400 AS INTERVAL SECOND ) AS INTERVAL DAY TO SECOND ) =
INTERVAL '86 00:00:00' DAY TO SECOND;
-+----------------+
-| =_single_value |
-+================+
-| true |
-+----------------+
-1 row
-
-SELECT CAST(DATE '1997-01-01' AS CHARACTER(10)) = '1997-01-01';
-+----------------+
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
