Test grant-select-column.Bug-6765.py (id c952acc49888) (err)
grant-select-column.Bug-6765.stable.out.FILTERED 2019-12-03 09:26:03.406183182 +0100grant-select-column.Bug-6765.test.out.FILTERED 2019-12-03 09:26:03.408183193 +0100
+ 1 Statistics about stdout of test 'grant-select-column.Bug-6765` in directory 'sql/test/BugTracker-2019`: 1
+ 2 8 lines, 39 words, 220 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 8 lines, 39 words, 220 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 41 lines, 333 words, 2829 chars in all lines 4
+ 5 5
+ 6 stdout of test 'grant-select-column.Bug-6765` in directory 'sql/test/BugTracker-2019` itself: 6
+ 7 7
+ 8 8
+ 9 # 09:26:02 > 9
+ 10 # 09:26:02 > "/usr/bin/python3" "grant-select-column.Bug-6765.py" "grant-select-column.Bug-6765" 10
+ 11 # 09:26:02 > 11
+ 12 12
+ 13 #CREATE schema "myschema";CREATE TABLE "myschema"."test" ("id" integer, "name" varchar(20));INSERT INTO "myschema"."test" ("id", "name") VALUES (1,'Tom'),(2,'Karen');CREATE USER myuser WITH UNENCRYPTED PASSWORD 'Test123' NAME 'Hulk' SCHEMA "myschema";GRANT SELECT ON "myschema"."test" TO myuser; 13
+ 14 #CREATE schema "myschema";CREATE TABLE "myschema"."test" ("id" integer, "name" varchar(20));INSERT INTO "myschema"."test" ("id", "name") VALUES (1,'Tom'),(2,'Karen');CREATE USER myuser WITH UNENCRYPTED PASSWORD 'Test123' NAME 'Hulk' SCHEMA "myschema";GRANT SELECT ON "myschema"."test" TO myuser; 14
+ 15 #CREATE schema "myschema";CREATE TABLE "myschema"."test" ("id" integer, "name" varchar(20));INSERT INTO "myschema"."test" ("id", "name") VALUES (1,'Tom'),(2,'Karen');CREATE USER myuser WITH UNENCRYPTED PASSWORD 'Test123' NAME 'Hulk' SCHEMA "myschema";GRANT SELECT ON "myschema"."test" TO myuser; 15
+ 16 [ 2 ] 16
+ 17 #CREATE schema "myschema";CREATE TABLE "myschema"."test" ("id" integer, "name" varchar(20));INSERT INTO "myschema"."test" ("id", "name") VALUES (1,'Tom'),(2,'Karen');CREATE USER myuser WITH UNENCRYPTED PASSWORD 'Test123' NAME 'Hulk' SCHEMA "myschema";GRANT SELECT ON "myschema"."test" TO myuser; 17
+ 18 #CREATE schema "myschema";CREATE TABLE "myschema"."test" ("id" integer, "name" varchar(20));INSERT INTO "myschema"."test" ("id", "name") VALUES (1,'Tom'),(2,'Karen');CREATE USER myuser WITH UNENCRYPTED PASSWORD 'Test123' NAME 'Hulk' SCHEMA "myschema";GRANT SELECT ON "myschema"."test" TO myuser; 18
+ 19 #SELECT "id", "name" FROM "myschema"."test"; 19
+ 20 % myschema.test, myschema.test # table_name 20
+ 21 % id, name # name 21
+ 22 % int, varchar # type 22
+ 23 % 1, 5 # length 23
+ 24 [ 1, "Tom" ] 24
+ 25 [ 2, "Karen" ] 25
+ 26 #REVOKE SELECT ON "myschema"."test" FROM myuser;GRANT SELECT ("name") ON "myschema"."test" TO myuser; 26
+ 27 #REVOKE SELECT ON "myschema"."test" FROM myuser;GRANT SELECT ("name") ON "myschema"."test" TO myuser; 27
+ 28 #DROP USER myuser;DROP SCHEMA "myschema" CASCADE; 28
+ 29 #DROP USER myuser;DROP SCHEMA "myschema" CASCADE; 29
+ 30 # MonetDB 5 server v11.36.0 30
+ 31 # This is an unreleased version 31
+ 32 # Serving database 'mTests_sql_test_BugTracker-2019', using 1 thread 32
+ 33 # Compiled for x86_64-redhat-linux-gnu/64bit with 128bit integers 33
+ 34 # Found 11.713 GiB available main-memory. 34
+ 35 # Copyright (c) 1993 - July 2008 CWI. 35
+ 36 # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved 36
+ 37 # Visit https://www.monetdb.org/ for further information 37
+ 38 # Listening for connection requests on mapi:monetdb://lab04.da.cwi.nl:31449/ 38
+ 39 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-25744/.s.monetdb.31449 39
+ 40 # MonetDB/GIS module loaded 40
+ 41 # MonetDB/SQL module loaded 41
+ 42 42
+ 43 # 09:26:03 > 43
+ 44 # 09:26:03 > "Done." 44
+ 45 # 09:26:03 > 45
+ 46 46