Changeset: 420ab874ea15 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=420ab874ea15 Modified Files: sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.sql sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err Branch: default Log Message:
tests: don't use a transaction if errors are expected make sure we continue processing, since the file clearly seems to try a couple of faulty statements diffs (54 lines): diff --git a/sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.sql b/sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.sql --- a/sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.sql +++ b/sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.sql @@ -1,6 +1,5 @@ -start transaction; - create schema intro1; +-- hint: should use "authorization" instead create schema intro2 authorized monetdb; create schema authorized monetdb; @@ -10,9 +9,12 @@ create schema intro1 default character set whatever; +drop schema intro1; + -- following gives unexpected error create table t2010(i int); create schema intro3 grant insert on t2010 to monetdb; -rollback; +drop table t2010; +drop schema intro3; diff --git a/sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err b/sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err --- a/sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err +++ b/sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err @@ -71,15 +71,22 @@ # 18:47:50 > mclient -lsql -ftest -i -e --host=alf --port=39317 # 18:47:50 > -MAPI = monetdb@volund:35971 +MAPI = monetdb@volund:31615 QUERY = create schema intro2 authorized monetdb; ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "create schema intro2 authorized" -MAPI = monetdb@volund:35971 +MAPI = monetdb@volund:31615 QUERY = create schema authorized monetdb; ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "create schema authorized monetdb" -MAPI = monetdb@volund:35971 +MAPI = monetdb@volund:31615 QUERY = drop schema intro2; ERROR = !SQLException:sql.catalog:DROP SCHEMA: name intro2 does not exist +MAPI = monetdb@volund:31615 +QUERY = create schema intro3 + grant insert on t2010 to monetdb; +ERROR = !syntax error, unexpected GRANT, ... (made this up) +MAPI = monetdb@volund:31615 +QUERY = drop schema intro3; +ERROR = !SQLException:sql.catalog:DROP SCHEMA: name intro3 does not exist # 18:47:50 > # 18:47:50 > Done. _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
