Changeset: 527f977b7e33 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=527f977b7e33 Modified Files: sql/test/BugTracker-2017/Tests/wrong_aggregation_count.Bug-6257.stable.out sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out Branch: linear-hashing Log Message:
approved output diffs (149 lines): diff --git a/sql/test/BugTracker-2017/Tests/wrong_aggregation_count.Bug-6257.stable.out b/sql/test/BugTracker-2017/Tests/wrong_aggregation_count.Bug-6257.stable.out --- a/sql/test/BugTracker-2017/Tests/wrong_aggregation_count.Bug-6257.stable.out +++ b/sql/test/BugTracker-2017/Tests/wrong_aggregation_count.Bug-6257.stable.out @@ -80,91 +80,91 @@ stdout of test 'wrong_aggregation_count. [ "json", 3, 3, true, 0, 0, 0, 0, 0 ] [ "profiler", 3, 3, true, 0, 0, 0, 0, 0 ] #SELECT count(*) as "# tmp tables/views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'tmp'); -% . # table_name +% sys. # table_name % "# tmp tables/views" # name % bigint # type % 1 # length [ 6 ] #SELECT count(*) as "# json tables/views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'json'); -% . # table_name +% sys. # table_name % "# json tables/views" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# profiler tables/views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'profiler'); -% . # table_name +% sys. # table_name % "# profiler tables/views" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# tmp system tables" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'tmp') AND system AND query is NULL; -% . # table_name +% sys. # table_name % "# tmp system tables" # name % bigint # type % 1 # length [ 6 ] #SELECT count(*) as "# json system tables" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'json') AND system AND query is NULL; -% . # table_name +% sys. # table_name % "# json system tables" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# profiler system tables" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'profiler') AND system AND query is NULL; -% . # table_name +% sys. # table_name % "# profiler system tables" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# tmp user tables" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'tmp') AND NOT system AND query is NULL; -% . # table_name +% sys. # table_name % "# tmp user tables" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# json user tables" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'json') AND NOT system AND query is NULL; -% . # table_name +% sys. # table_name % "# json user tables" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# profiler user tables" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'profiler') AND NOT system AND query is NULL; -% . # table_name +% sys. # table_name % "# profiler user tables" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# tmp system views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'tmp') AND system AND query is NOT NULL; -% . # table_name +% sys. # table_name % "# tmp system views" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# json system views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'json') AND system AND query is NOT NULL; -% . # table_name +% sys. # table_name % "# json system views" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# profiler system views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'profiler') AND system AND query is NOT NULL; -% . # table_name +% sys. # table_name % "# profiler system views" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# tmp user views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'tmp') AND NOT system AND query is NOT NULL; -% . # table_name +% sys. # table_name % "# tmp user views" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# json user views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'json') AND NOT system AND query is NOT NULL; -% . # table_name +% sys. # table_name % "# json user views" # name % bigint # type % 1 # length [ 0 ] #SELECT count(*) as "# profiler user views" FROM sys.tables WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name = 'profiler') AND NOT system AND query is NOT NULL; -% . # table_name +% sys. # table_name % "# profiler user views" # name % bigint # type % 1 # length diff --git a/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out b/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out --- a/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out +++ b/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out @@ -67,7 +67,7 @@ stdout of test 'alter_table_set_schema.B % 1 # length [ 1 ] #select count(*) as count_rows from keys where table_id in (select id from tables where name = 'test2'); -% sys. # table_name +% . # table_name % count_rows # name % bigint # type % 1 # length @@ -86,7 +86,7 @@ stdout of test 'alter_table_set_schema.B % 1 # length [ 1 ] #select count(*) as count_rows from keys where table_id in (select id from tables where name = 'test2'); -% sys. # table_name +% . # table_name % count_rows # name % bigint # type % 1 # length @@ -105,7 +105,7 @@ stdout of test 'alter_table_set_schema.B % 1 # length [ 1 ] #select count(*) as count_rows from keys where table_id in (select id from tables where name = 'test2'); -% sys. # table_name +% . # table_name % count_rows # name % bigint # type % 1 # length @@ -124,7 +124,7 @@ stdout of test 'alter_table_set_schema.B % 1 # length [ 1 ] #select count(*) as count_rows from keys where table_id in (select id from tables where name = 'test2'); -% sys. # table_name +% . # table_name % count_rows # name % bigint # type % 1 # length _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
