Changeset: c3e43ad57d65 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c3e43ad57d65
Added Files:
sql/test/Users/Tests/createUserRollback.stable.err
sql/test/Users/Tests/createUserRollback.stable.out
Modified Files:
sql/test/Users/Tests/createUserRollback.SQL.py
Branch: Jun2020
Log Message:
Added expected output for test, plus an invariant
diffs (72 lines):
diff --git a/sql/test/Users/Tests/createUserRollback.SQL.py
b/sql/test/Users/Tests/createUserRollback.SQL.py
--- a/sql/test/Users/Tests/createUserRollback.SQL.py
+++ b/sql/test/Users/Tests/createUserRollback.SQL.py
@@ -6,15 +6,15 @@ except ImportError:
with process.client('sql', stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as c:
out, err = c.communicate('''
+ CREATE TABLE sys.myvar (c BIGINT);
+ INSERT INTO sys.myvar VALUES ((SELECT COUNT(*) FROM sys.users));
+
START TRANSACTION;
-
CREATE USER "1" WITH PASSWORD '1' NAME '1' SCHEMA "sys";
- CREATE SCHEMA "ups" AUTHORIZATION "1";
- ALTER USER "1" SET SCHEMA "ups";
+ ROLLBACK;
- select * from sys.db_users; --error, doesn't exist
-
- COMMIT; --it will rollback
+ SELECT CAST(COUNT(*) - (SELECT c FROM sys.myvar) AS BIGINT) FROM
sys.users; --the total count, cannot change
+ DROP TABLE sys.myvar;
''')
sys.stdout.write(out)
sys.stderr.write(err)
diff --git a/sql/test/Users/Tests/createUserRollback.stable.err
b/sql/test/Users/Tests/createUserRollback.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/createUserRollback.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'createUserRollback` in directory 'sql/test/Users` itself:
+
+
+# 12:24:01 >
+# 12:24:01 > "/usr/bin/python3" "createUserRollback.SQL.py"
"createUserRollback"
+# 12:24:01 >
+
+
+# 12:24:01 >
+# 12:24:01 > "Done."
+# 12:24:01 >
+
diff --git a/sql/test/Users/Tests/createUserRollback.stable.out
b/sql/test/Users/Tests/createUserRollback.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/createUserRollback.stable.out
@@ -0,0 +1,25 @@
+stdout of test 'createUserRollback` in directory 'sql/test/Users` itself:
+
+
+# 12:24:01 >
+# 12:24:01 > "/usr/bin/python3" "createUserRollback.SQL.py"
"createUserRollback"
+# 12:24:01 >
+
+#CREATE TABLE sys.myvar (c BIGINT);
+#INSERT INTO sys.myvar VALUES ((SELECT COUNT(*) FROM sys.users));
+[ 1 ]
+#START TRANSACTION;
+#CREATE USER "1" WITH PASSWORD '1' NAME '1' SCHEMA "sys";
+#ROLLBACK;
+#SELECT CAST(COUNT(*) - (SELECT c FROM sys.myvar) AS BIGINT) FROM sys.users;
--the total count, cannot change
+% . # table_name
+% %7 # name
+% bigint # type
+% 1 # length
+[ 0 ]
+#DROP TABLE sys.myvar;
+
+# 12:24:01 >
+# 12:24:01 > "Done."
+# 12:24:01 >
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
