Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8616/src/test/BugTracker/Tests
Modified Files:
copy_decimal.SF-1582957.stable.err.Five
explain.SF-1739353.stable.out.Five
limit_timestampz.SF-1774217.sql
limit_timestampz.SF-1774217.stable.out
Log Message:
replaced using local char arrays of size BUFSIZ, by a single function
(sql_message). Reduces stack pressure, smaller code etc.
approved output for m5/sql
Index: limit_timestampz.SF-1774217.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/limit_timestampz.SF-1774217.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- limit_timestampz.SF-1774217.sql 17 Aug 2007 14:58:27 -0000 1.2
+++ limit_timestampz.SF-1774217.sql 21 Aug 2007 22:24:43 -0000 1.3
@@ -1,9 +1,9 @@
-create table t1 (
+create table timestamp1 (
nr integer auto_increment,
tr_time timestamp(3) with time zone
)
;
-insert into t1 (tr_time)
+insert into timestamp1 (tr_time)
select *
from
(
@@ -19,7 +19,7 @@
) as foo
;
-- this will crash server
-select nr from t1
+select nr from timestamp1
order by tr_time
limit 3
;
Index: copy_decimal.SF-1582957.stable.err.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/copy_decimal.SF-1582957.stable.err.Five,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- copy_decimal.SF-1582957.stable.err.Five 27 Apr 2007 09:45:54 -0000
1.2
+++ copy_decimal.SF-1582957.stable.err.Five 21 Aug 2007 22:24:42 -0000
1.3
@@ -63,11 +63,11 @@
# 21:06:21 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32735 < copy_decimal.SF-1582957.sql
# 21:06:21 >
-MAPI = [EMAIL PROTECTED]:30145
+MAPI = [EMAIL PROTECTED]:31641
QUERY = COPY 1 RECORDS INTO LINEITEM FROM stdin USING DELIMITERS '|','|\n';
ERROR = !SQLException:sql:decimal wrong format (17.000)
+ !SQLException:sql:value
17.000|17954.55|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN
PERSON|TRUCK|blithely regular ideas caj from line 0 not inserted
!SQLException:importTable:failed to import table
- !ERROR: value
17.000|17954.55|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN
PERSON|TRUCK|blithely regular ideas caj from line 0 not inserted
# 21:06:21 >
# 21:06:21 > Done.
Index: limit_timestampz.SF-1774217.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/limit_timestampz.SF-1774217.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- limit_timestampz.SF-1774217.stable.out 17 Aug 2007 14:58:33 -0000
1.2
+++ limit_timestampz.SF-1774217.stable.out 21 Aug 2007 22:24:44 -0000
1.3
@@ -22,7 +22,7 @@
# 23:35:36 >
[ 5 ]
-% sys.t1 # table_name
+% sys.timestamp1 # table_name
% nr # name
% int # type
% 1 # length
Index: explain.SF-1739353.stable.out.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/explain.SF-1739353.stable.out.Five,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- explain.SF-1739353.stable.out.Five 17 Jul 2007 11:20:00 -0000 1.2
+++ explain.SF-1739353.stable.out.Five 21 Aug 2007 22:24:43 -0000 1.3
@@ -37,79 +37,80 @@
| mal
|
+==============================================================================+
| function user.s1_1():void;
|
-| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=174} :=
sql.bind("tmp","_tables","id",0); |
+| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12861} :=
sql.bind("tmp","_tables","id",0); |
| constraints.emptySet(_1);
|
-| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=178} :=
sql.bind("tmp","_tables","type",0); |
-| _13:bat[:oid,:int]{notnil=true,rows=30:lng,bid=88} :=
sql.bind("sys","_tables","id",0); |
-| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=387} :=
sql.bind("sys","_tables","id",1); |
+| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=12865} :=
sql.bind("tmp","_tables","type",0); |
+| _13:bat[:oid,:int]{notnil=true,rows=127:lng,bid=848} :=
sql.bind("sys","_tables","id",0); |
+| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12711} :=
sql.bind("sys","_tables","id",1); |
| constraints.emptySet(_15);
|
-| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=387} := nil;
|
-| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=389} :=
sql.bind("sys","_tables","id",2); |
+| _15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12711} := nil;
|
+| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12712} :=
sql.bind("sys","_tables","id",2); |
| constraints.emptySet(_16);
|
-| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=389} := nil;
|
-| _20:bat[:oid,:sht]{notnil=true,rows=30:lng,bid=92} :=
sql.bind("sys","_tables","type",0); |
-| _38:bat[:oid,:str]{notnil=true,rows=0:lng,bid=175} :=
sql.bind("tmp","_tables","name",0); |
-| _41:bat[:oid,:str]{notnil=true,rows=30:lng,bid=89} :=
sql.bind("sys","_tables","name",0); |
+| _16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12712} := nil;
|
+| _18:bat[:oid,:oid]{rows=94:lng,bid=12710} :=
sql.bind_dbat("sys","_tables",1); |
+| _23:bat[:oid,:sht]{notnil=true,rows=127:lng,bid=854} :=
sql.bind("sys","_tables","type",0); |
+| _41:bat[:oid,:str]{notnil=true,rows=0:lng,bid=12862} :=
sql.bind("tmp","_tables","name",0); |
+| _44:bat[:oid,:str]{notnil=true,rows=127:lng,bid=850} :=
sql.bind("sys","_tables","name",0); |
| _8{rows=0:lng} := algebra.markT(_1,[EMAIL PROTECTED]);
|
| _9{rows=0:lng} := bat.reverse(_8);
|
| _8{rows=0:lng} := nil;
|
| _12{rows=0:lng} := algebra.join(_9,_10);
|
-| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=178} := nil;
|
-| _18{rows=30:lng} := algebra.markT(_13,[EMAIL PROTECTED]);
|
-| _19{rows=30:lng} := bat.reverse(_18);
|
-| _18{rows=30:lng} := nil;
|
-| _21{rows=30:lng} := algebra.join(_19,_20);
|
-| _20:bat[:oid,:sht]{notnil=true,rows=30:lng,bid=92} := nil;
|
-| _22{rows=31:lng} := bat.setWriteMode(_21);
|
-| _21{rows=30:lng} := nil;
|
-| bat.append(_22,_12,true);
|
+| _10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=12865} := nil;
|
+| _19{rows=94:lng} := bat.reverse(_18);
|
+| _18:bat[:oid,:oid]{rows=94:lng,bid=12710} := nil;
|
+| _20{rows=34:lng} := algebra.kdifference(_13,_19);
|
+| _19{rows=94:lng} := nil;
|
+| _21{rows=34:lng} := algebra.markT(_20,[EMAIL PROTECTED]);
|
+| _20{rows=34:lng} := nil;
|
+| _22{rows=34:lng} := bat.reverse(_21);
|
+| _21{rows=34:lng} := nil;
|
+| _24{rows=34:lng} := algebra.join(_22,_23);
|
+| _23:bat[:oid,:sht]{notnil=true,rows=127:lng,bid=854} := nil;
|
+| _25{rows=35:lng} := bat.setWriteMode(_24);
|
+| _24{rows=34:lng} := nil;
|
+| bat.append(_25,_12,true);
|
| _12{rows=0:lng} := nil;
|
-| _26{rows=31:lng} := algebra.uselect(_22,nil:sht,2,false,false);
|
-| _22{rows=31:lng} := nil;
|
-| _29{rows=31:lng} := algebra.markT(_26,[EMAIL PROTECTED]);
|
-| _26{rows=31:lng} := nil;
|
-| _30{rows=31:lng} := bat.reverse(_29);
|
-| _29{rows=31:lng} := nil;
|
-| _31{rows=0:lng} := algebra.join(_9,_1);
|
-| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=174} := nil;
|
-| _32{rows=30:lng} := algebra.join(_19,_13);
|
-| _13:bat[:oid,:int]{notnil=true,rows=30:lng,bid=88} := nil;
|
-| _33{rows=31:lng} := bat.setWriteMode(_32);
|
-| _32{rows=30:lng} := nil;
|
-| bat.append(_33,_31,true);
|
-| _31{rows=0:lng} := nil;
|
-| _35{rows=31:lng} := algebra.join(_30,_33);
|
-| _33{rows=31:lng} := nil;
|
-| _36{rows=31:lng} := algebra.markT(_35,[EMAIL PROTECTED]);
|
-| _35{rows=31:lng} := nil;
|
-| _37{rows=31:lng} := bat.reverse(_36);
|
-| _36{rows=31:lng} := nil;
|
-| _40{rows=0:lng} := algebra.join(_9,_38);
|
+| _29{rows=35:lng} := algebra.uselect(_25,nil:sht,2,false,false);
|
+| _25{rows=35:lng} := nil;
|
+| _32{rows=35:lng} := algebra.markT(_29,[EMAIL PROTECTED]);
|
+| _29{rows=35:lng} := nil;
|
+| _33{rows=35:lng} := bat.reverse(_32);
|
+| _32{rows=35:lng} := nil;
|
+| _34{rows=0:lng} := algebra.join(_9,_1);
|
+| _1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=12861} := nil;
|
+| _35{rows=34:lng} := algebra.join(_22,_13);
|
+| _13:bat[:oid,:int]{notnil=true,rows=127:lng,bid=848} := nil;
|
+| _36{rows=35:lng} := bat.setWriteMode(_35);
|
+| _35{rows=34:lng} := nil;
|
+| bat.append(_36,_34,true);
|
+| _34{rows=0:lng} := nil;
|
+| _38{rows=35:lng} := algebra.join(_33,_36);
|
+| _36{rows=35:lng} := nil;
|
+| _39{rows=35:lng} := algebra.markT(_38,[EMAIL PROTECTED]);
|
+| _38{rows=35:lng} := nil;
|
+| _40{rows=35:lng} := bat.reverse(_39);
|
+| _39{rows=35:lng} := nil;
|
+| _43{rows=0:lng} := algebra.join(_9,_41);
|
| _9{rows=0:lng} := nil;
|
-| _38:bat[:oid,:str]{notnil=true,rows=0:lng,bid=175} := nil;
|
-| _42{rows=30:lng} := algebra.join(_19,_41);
|
-| _19{rows=30:lng} := nil;
|
-| _41:bat[:oid,:str]{notnil=true,rows=30:lng,bid=89} := nil;
|
-| _43{rows=31:lng} := bat.setWriteMode(_42);
|
-| _42{rows=30:lng} := nil;
|
-| bat.append(_43,_40,true);
|
-| _40{rows=0:lng} := nil;
|
-| _45{rows=31:lng} := algebra.joinPath(_37,_30,_43);
|
-| _37{rows=31:lng} := nil;
|
-| _30{rows=31:lng} := nil;
|
-| _43{rows=31:lng} := nil;
|
-| _46 := sql.resultSet(1,1,_45);
|
-| sql.rsColumn(_46,"sys.tables","name","varchar",1024,0,_45);
|
-| _45{rows=31:lng} := nil;
|
-| sql.exportResult(_46,"");
|
+| _41:bat[:oid,:str]{notnil=true,rows=0:lng,bid=12862} := nil;
|
+| _45{rows=34:lng} := algebra.join(_22,_44);
|
+| _22{rows=34:lng} := nil;
|
+| _44:bat[:oid,:str]{notnil=true,rows=127:lng,bid=850} := nil;
|
+| _46{rows=35:lng} := bat.setWriteMode(_45);
|
+| _45{rows=34:lng} := nil;
|
+| bat.append(_46,_43,true);
|
+| _43{rows=0:lng} := nil;
|
+| _48{rows=35:lng} := algebra.joinPath(_40,_33,_46);
|
+| _40{rows=35:lng} := nil;
|
+| _33{rows=35:lng} := nil;
|
+| _46{rows=35:lng} := nil;
|
+| _49 := sql.resultSet(1,1,_48);
|
+| sql.rsColumn(_49,"sys.tables","name","varchar",1024,0,_48);
|
+| _48{rows=35:lng} := nil;
|
+| sql.exportResult(_49,"");
|
| end s1_1;
|
+------------------------------------------------------------------------------+
-67 rows
-
-
-# 13:06:43 >
-# 13:06:43 > Mtimeout -timeout 60 mjclient -h pegasus -p 31876 -d
mTests_src_test_BugTracker -q
-# 13:06:43 >
+73 rows
# 13:06:44 >
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
