Changeset: 7b8a65d9db85 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7b8a65d9db85
Modified Files:
sql/test/UserDump/Tests/create.SQL.py
sql/test/UserDump/Tests/dump.stable.out
sql/test/UserDump/Tests/dump_with_test.stable.out
Branch: mtest
Log Message:
approved output
diffs (86 lines):
diff --git a/sql/test/UserDump/Tests/create.SQL.py
b/sql/test/UserDump/Tests/create.SQL.py
--- a/sql/test/UserDump/Tests/create.SQL.py
+++ b/sql/test/UserDump/Tests/create.SQL.py
@@ -44,61 +44,3 @@ with SQLTestCase() as tc:
create trigger x after insert on foo insert into a values (1);
create trigger "z" after insert on "foo" insert into a values (1);
""", client="mclient").assertSucceeded()
-
-
-#import os, sys
-#try:
-# from MonetDBtesting import process
-#except ImportError:
-# import process
-#
-#def client(lang, user = 'monetdb', passwd = 'monetdb', input = None):
-# with process.client(lang, user = user, passwd = passwd,
-# stdin = process.PIPE,
-# stdout = process.PIPE,
-# stderr = process.PIPE) as clt:
-# out, err = clt.communicate(input)
-# sys.stdout.write(out)
-# sys.stderr.write(err)
-#
-#client('sql', input = """\
-#create user voc with password 'voc' name 'VOC Explorer' schema sys;
-#create schema voc authorization voc;
-#alter user voc set schema voc;
-#""")
-#client('sql', user = 'voc', passwd = 'voc', input = """\
-#create table foo (
-# id int,
-# v int,
-# primary key (id)
-#);
-#create view bar as select * from foo;
-#create function b(i int) returns int begin return select v from bar where id
= i; end;
-#create table a (
-# id int
-#);
-#create trigger a after insert on foo insert into a values (1);
-#""")
-#client('sql', input = """\
-#create user test with password 'test' name 'Test User' schema sys;
-#create schema test authorization test;
-#alter user test set schema test;
-#""")
-#client('sql', user = 'test', passwd = 'test', input = '''\
-#create table foo (
-# id int,
-# v int,
-# primary key (id)
-#);
-#create view bar as select * from foo;
-#create function b(i int) returns int begin return select v from bar where id
= i; end;
-#create table a (
-# id int
-#);
-#create trigger a after insert on foo insert into a values (1);
-#create trigger test.x after insert on foo insert into a values (1);
-#create trigger "test"."z" after insert on "foo" insert into a values (1);
-#''')
-#client('sqldump')
-#client('sqldump', user = 'voc', passwd = 'voc')
-#client('sqldump', user = 'test', passwd = 'test')
diff --git a/sql/test/UserDump/Tests/dump.stable.out
b/sql/test/UserDump/Tests/dump.stable.out
--- a/sql/test/UserDump/Tests/dump.stable.out
+++ b/sql/test/UserDump/Tests/dump.stable.out
@@ -30,6 +30,6 @@ CREATE TABLE "test"."a" (
);
create trigger a after insert on foo insert into a values (1);
create trigger test.x after insert on foo insert into a values (1);
-create trigger "test"."z" after insert on "foo" insert into a values (1);
+create trigger "z" after insert on "foo" insert into a values (1);
SET SCHEMA "sys";
COMMIT;
diff --git a/sql/test/UserDump/Tests/dump_with_test.stable.out
b/sql/test/UserDump/Tests/dump_with_test.stable.out
--- a/sql/test/UserDump/Tests/dump_with_test.stable.out
+++ b/sql/test/UserDump/Tests/dump_with_test.stable.out
@@ -12,5 +12,5 @@ CREATE TABLE "test"."a" (
);
create trigger a after insert on foo insert into a values (1);
create trigger test.x after insert on foo insert into a values (1);
-create trigger "test"."z" after insert on "foo" insert into a values (1);
+create trigger "z" after insert on "foo" insert into a values (1);
COMMIT;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
