MonetDB: Nov2019 - Don't use system schemas on tests

[Pedro Ferreira]

Changeset: 7e7a2395efeb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7e7a2395efeb
Modified Files:
        sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.sql
        sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.err
        sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.out
Branch: Nov2019
Log Message:

Don't use system schemas on tests


diffs (79 lines):

diff --git a/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.sql 
b/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.sql
--- a/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.sql
+++ b/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.sql
@@ -1,25 +1,30 @@
 delete from statistics;
 select count(*) from statistics;
 
-CREATE STREAM TABLE "sys"."strt" (
+CREATE SCHEMA "ttt";
+
+CREATE TABLE "ttt"."a"("id" INTEGER);
+
+CREATE STREAM TABLE "ttt"."strt" (
         "id" INTEGER       NOT NULL,
         "nm" VARCHAR(123)  NOT NULL,
         CONSTRAINT "strt_id_pkey" PRIMARY KEY ("id")
 );
 
-select * from "sys"."strt";
+select * from "ttt"."strt";
 
-analyze "sys"."strt";
+analyze "ttt"."strt";
 -- Error: Table 'strt' is not persistent   SQLState:  42S02
 select (count(*) > 0) as has_rows from statistics;
 
-analyze sys; --not an error, skip stream table "strt"
+analyze ttt; --not an error, skip stream table "strt"
 select (count(*) > 0) as has_rows from statistics;
 
-drop table "sys"."strt";
+drop table "ttt"."strt";
 -- now run analyze without the stream table
-analyze sys;
+analyze ttt;
 select (count(*) > 0) as has_rows from statistics;
--- true (181)
+-- true
 delete from statistics;
 
+drop schema "ttt" cascade;
diff --git 
a/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.err 
b/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.err
--- a/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.err
+++ b/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.err
@@ -25,8 +25,8 @@ stderr of test 'analyze-stream-table.Bug
 # 13:50:18 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-891865" "--port=35996"
 # 13:50:18 >  
 
-MAPI  = (monetdb) /var/tmp/mtest-161340/.s.monetdb.34379
-QUERY = analyze "sys"."strt";
+MAPI  = (monetdb) /var/tmp/mtest-4325/.s.monetdb.33720
+QUERY = analyze "ttt"."strt";
 ERROR = !STREAM TABLE 'strt' is not persistent
 CODE  = 42S02
 
diff --git 
a/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.out 
b/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.out
--- a/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.out
+++ b/sql/test/BugTracker-2020/Tests/analyze-stream-table.Bug-6817.stable.out
@@ -35,8 +35,8 @@ stdout of test 'analyze-stream-table.Bug
 #        "nm" VARCHAR(123)  NOT NULL,
 #        CONSTRAINT "strt_id_pkey" PRIMARY KEY ("id")
 #);
-#select * from "sys"."strt";
-% sys.strt,    sys.strt # table_name
+#select * from "ttt"."strt";
+% ttt.strt,    ttt.strt # table_name
 % id,  nm # name
 % int, varchar # type
 % 1,   0 # length
@@ -63,7 +63,8 @@ stdout of test 'analyze-stream-table.Bug
 % 5 # length
 [ true ]
 #delete from statistics;
-[ 181  ]
+[ 1    ]
+#drop schema "ttt" cascade;
 
 # 13:50:18 >  
 # 13:50:18 >  "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list