Changeset: 52479db2c3b9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=52479db2c3b9
Modified Files:
sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.err
sql/test/BugTracker-2015/Tests/create-temp-table-using-like.Bug-3767.stable.err
sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.stable.err
sql/test/BugTracker-2015/Tests/string_split.Bug-3564.stable.err
Branch: malerrors
Log Message:
approved output
diffs (59 lines):
diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.err
b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.err
--- a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.err
+++ b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.err
@@ -33,9 +33,6 @@ stderr of test 'crash.Bug-3736` in direc
MAPI = (monetdb) /var/tmp/mtest-15304/.s.monetdb.34590
QUERY = Select b.* FROM open_auctions o, b bidder WHERE (select b3.INCREASE
from bidder b3 where b3.id = (select min (b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id order by date, time;
ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !SELECT: no such table 'b'
-MAPI = (monetdb) /var/tmp/mtest-21551/.s.monetdb.38677
-QUERY = plan Select b.* FROM open_auctions o, bidder b WHERE (select
b3.INCREASE from bidder b3 where b3.id = (select min (b3a.id) from bidder b3a
where b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id;
-ERROR = !ParseException:SQLparser:SQLSTATE M0M27 !Semantic errors
# 10:50:38 >
# 10:50:38 > "Done."
diff --git
a/sql/test/BugTracker-2015/Tests/create-temp-table-using-like.Bug-3767.stable.err
b/sql/test/BugTracker-2015/Tests/create-temp-table-using-like.Bug-3767.stable.err
---
a/sql/test/BugTracker-2015/Tests/create-temp-table-using-like.Bug-3767.stable.err
+++
b/sql/test/BugTracker-2015/Tests/create-temp-table-using-like.Bug-3767.stable.err
@@ -32,13 +32,13 @@ stderr of test 'create-temp-table-using-
MAPI = (monetdb) /var/tmp/mtest-1894/.s.monetdb.33598
QUERY = create temp table tmp (like t1);
-ERROR = !CREATE TABLE: no such table 't1'
-MAPI = (monetdb) /var/tmp/mtest-1894/.s.monetdb.33598
+ERROR = !ParseException:SQLparser:SQLSTATE 3F000 !CREATE TABLE: no such table
't1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = select * from tmp;
-ERROR = !SELECT: no such table 'tmp'
-MAPI = (monetdb) /var/tmp/mtest-1894/.s.monetdb.33598
+ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !SELECT: no such table 'tmp'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = drop table tmp;
-ERROR = !DROP TABLE: no such table 'tmp'
+ERROR = !SQLException:sql.droptable:SQLSTATE 42S02 !DROP TABLE: no such table
'tmp'
# 15:59:58 >
# 15:59:58 > "Done."
diff --git
a/sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.stable.err
b/sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.stable.err
--- a/sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.stable.err
+++ b/sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.stable.err
@@ -42,6 +42,8 @@ QUERY = CREATE TABLE instrument (
CONSTRAINT instrument_exchange_fk FOREIGN KEY (fk_exchange)
REFERENCES exchange (pk_symbol),
CONSTRAINT instrument_entity_fk FOREIGN KEY (fk_entity_uuid)
REFERENCES entity (pk_uuid)
ERROR = !ParseException:SQLparser:SQLSTATE 42000 !CONSTRAINT FOREIGN KEY: key
'instrument_exchange_fk' already exists
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
+ERROR = !SQLException:sql.execute:SQLSTATE 25005 !Current transaction is
aborted (please ROLLBACK)
# 13:08:16 >
# 13:08:16 > "Done."
diff --git a/sql/test/BugTracker-2015/Tests/string_split.Bug-3564.stable.err
b/sql/test/BugTracker-2015/Tests/string_split.Bug-3564.stable.err
--- a/sql/test/BugTracker-2015/Tests/string_split.Bug-3564.stable.err
+++ b/sql/test/BugTracker-2015/Tests/string_split.Bug-3564.stable.err
@@ -32,7 +32,7 @@ stderr of test 'string_split.Bug-3564` i
MAPI = (monetdb) /var/tmp/mtest-61161/.s.monetdb.38988
QUERY = select split_part('joeuser@mydatabase','@',0) AS "an error";
-ERROR = !field position must be greater than zero
+ERROR = !MALException:str.splitpart:field position must be greater than zero
# 15:17:36 >
# 15:17:36 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
