Changeset: 44580ebcfa76 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=44580ebcfa76 Modified Files: sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out Branch: default Log Message:
swapped_likejoin.Bug-3375: approve default branch output diffs (24 lines): diff --git a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out --- a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out +++ b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out @@ -35,13 +35,13 @@ Ready. % 4, 35, 4, 496, 1, 5, 1, 5, 6 # length [ 2055, "_tables", 2000, NULL, 0, true, 0, false, "%able%" ] [ 2103, "_tables", 2102, NULL, 0, true, 2, false, "%able%" ] -[ 5075, "tables", 2000, "SELECT * FROM (SELECT p.*, 0 AS \"temporary\" FROM \"sys\".\"_tables\" AS p UNION ALL SELECT t.*, 1 AS \"temporary\" FROM \"tmp\".\"_tables\" AS t) AS tables where tables.type <> 2;", 1, true, 0, false, "%able%" ] -[ 5405, "#dependencies_tables_on_views", 2000, NULL, 2, true, 0, false, "%able%" ] -[ 5412, "#dependencies_tables_on_indexes", 2000, NULL, 2, true, 0, false, "%able%" ] -[ 5419, "#dependencies_tables_on_triggers", 2000, NULL, 2, true, 0, false, "%able%" ] -[ 5426, "#dependencies_tables_on_foreignkeys", 2000, NULL, 2, true, 0, false, "%able%" ] -[ 5433, "#dependencies_tables_on_functions", 2000, NULL, 2, true, 0, false, "%able%" ] -[ 6115, "tablestoragemodel", 2000, "-- A summary of the table storage requirement is is available as a table view.\n-- The auxillary column denotes the maximum space if all non-sorted columns\n-- would be augmented with a hash (rare situation)\ncreate view sys.tablestoragemodel\nas select \"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";", 1, true, 0, false, "%able%" ] +[ 5077, "tables", 2000, "SELECT * FROM (SELECT p.*, 0 AS \"temporary\" FROM \"sys\".\"_tables\" AS p UNION ALL SELECT t.*, 1 AS \"temporary\" FROM \"tmp\".\"_tables\" AS t) AS tables where tables.type <> 2;", 1, true, 0, false, "%able%" ] +[ 5433, "#dependencies_tables_on_views", 2000, NULL, 2, true, 0, false, "%able%" ] +[ 5440, "#dependencies_tables_on_indexes", 2000, NULL, 2, true, 0, false, "%able%" ] +[ 5447, "#dependencies_tables_on_triggers", 2000, NULL, 2, true, 0, false, "%able%" ] +[ 5454, "#dependencies_tables_on_foreignkeys", 2000, NULL, 2, true, 0, false, "%able%" ] +[ 5461, "#dependencies_tables_on_functions", 2000, NULL, 2, true, 0, false, "%able%" ] +[ 6266, "tablestoragemodel", 2000, "-- A summary of the table storage requirement is is available as a table view.\n-- The auxillary column denotes the maximum space if all non-sorted columns\n-- would be augmented with a hash (rare situation)\ncreate view sys.tablestoragemodel\nas select \"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";", 1, true, 0, false, "%able%" ] #drop table x; # 10:06:32 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
