Changeset: d4f17b9d4fc7 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d4f17b9d4fc7 Modified Files: sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out Branch: sciql Log Message:
predicate_select.Bug-3090: approved SciQL output diffs (86 lines): diff --git a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out --- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out +++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out @@ -24,41 +24,47 @@ Ready. # 18:53:13 > #select * from tables where 1; -% .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables # table_name -% id, name, schema_id, query, type, system, commit_action, readonly, temporary # name -% int, varchar, int, varchar, smallint, boolean, smallint, boolean, tinyint # type -% 4, 15, 4, 192, 1, 5, 1, 5, 1 # length -[ 2001, "schemas", 2000, NULL, 0, true, 0, false, 0 ] -[ 2006, "types", 2000, NULL, 0, true, 0, false, 0 ] -[ 2015, "functions", 2000, NULL, 0, true, 0, false, 0 ] -[ 2024, "args", 2000, NULL, 0, true, 0, false, 0 ] -[ 2032, "sequences", 2000, NULL, 0, true, 0, false, 0 ] -[ 2042, "dependencies", 2000, NULL, 0, true, 0, false, 0 ] -[ 2046, "connections", 2000, NULL, 0, true, 0, false, 0 ] -[ 2055, "_tables", 2000, NULL, 0, true, 0, false, 0 ] -[ 2064, "_columns", 2000, NULL, 0, true, 0, false, 0 ] -[ 2075, "keys", 2000, NULL, 0, true, 0, false, 0 ] -[ 2082, "idxs", 2000, NULL, 0, true, 0, false, 0 ] -[ 2087, "triggers", 2000, NULL, 0, true, 0, false, 0 ] -[ 2098, "objects", 2000, NULL, 0, true, 0, false, 0 ] -[ 2103, "_tables", 2102, NULL, 0, true, 2, false, 0 ] -[ 2112, "_columns", 2102, NULL, 0, true, 2, false, 0 ] -[ 2123, "keys", 2102, NULL, 0, true, 2, false, 0 ] -[ 2130, "idxs", 2102, NULL, 0, true, 2, false, 0 ] -[ 2135, "triggers", 2102, NULL, 0, true, 2, false, 0 ] -[ 2146, "objects", 2102, NULL, 0, true, 2, false, 0 ] -[ 4993, "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, 0 ] -[ 5003, "columns", 2000, "SELECT * FROM (SELECT p.* FROM \"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t) AS columns;", 1, true, 0, false, 0 ] -[ 5023, "db_user_info", 2000, NULL, 0, true, 0, false, 0 ] -[ 5031, "users", 2000, "SELECT u.\"name\" AS \"name\", ui.\"fullname\", ui.\"default_schema\" FROM db_users() AS u LEFT JOIN \"sys\".\"db_user_info\" AS ui ON u.\"name\" = ui.\"name\" ;", 1, true, 0, false, 0 ] -[ 5035, "user_role", 2000, NULL, 0, true, 0, false, 0 ] -[ 5038, "auths", 2000, NULL, 0, true, 0, false, 0 ] -[ 5042, "privileges", 2000, NULL, 0, true, 0, false, 0 ] -[ 5195, "queryhistory", 2000, NULL, 0, true, 0, false, 0 ] -[ 5209, "callhistory", 2000, NULL, 0, true, 0, false, 0 ] -[ 5226, "querylog", 2000, "create view querylog as\nselect qd.*, ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, ql.inblock, ql.oublock from queryhistory qd, callhistory ql\nwhere qd.id = ql.id;", 1, true, 0, false, 0 ] -[ 5832, "systemfunctions", 2000, NULL, 0, true, 0, false, 0 ] -[ 5941, "r", 2000, NULL, 0, false, 0, false, 0 ] +% .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables # table_name +% id, name, schema_id, query, type, system, commit_action, readonly, fixed_array, nr_dimensions, temporary # name +% int, varchar, int, varchar, smallint, boolean, smallint, boolean, boolean, int, tinyint # type +% 4, 15, 4, 292, 1, 5, 1, 5, 5, 1, 1 # length +[ 2001, "schemas", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2006, "types", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2015, "functions", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2024, "args", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2032, "sequences", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2042, "dependencies", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2046, "connections", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2055, "_tables", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2066, "_columns", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2077, "_dimensions", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2082, "keys", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2089, "idxs", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2094, "triggers", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2105, "objects", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 2110, "_tables", 2109, NULL, 0, true, 2, false, false, 0, 0 ] +[ 2121, "_columns", 2109, NULL, 0, true, 2, false, false, 0, 0 ] +[ 2132, "_dimensions", 2109, NULL, 0, true, 2, false, false, 0, 0 ] +[ 2137, "keys", 2109, NULL, 0, true, 2, false, false, 0, 0 ] +[ 2144, "idxs", 2109, NULL, 0, true, 2, false, false, 0, 0 ] +[ 2149, "triggers", 2109, NULL, 0, true, 2, false, false, 0, 0 ] +[ 2160, "objects", 2109, NULL, 0, true, 2, false, false, 0, 0 ] +[ 5007, "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, false, 0, 0 ] +[ 5019, "columns", 2000, "SELECT * FROM (SELECT p.* FROM \"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t) AS columns;", 1, true, 0, false, false, 0, 0 ] +[ 5030, "arrays", 2000, "SELECT * FROM (SELECT p.*, 0 AS \"temporary\" FROM \"sys\".\"_tables\" AS p WHERE nr_dimensions > 0 UNION ALL SELECT t.*, 1 AS \"temporary\" FROM \"tmp\".\"_tables\" AS t WHERE nr_dimensions > 0) AS arrays;", 1, true, 0, false, false, 0, 0 ] +[ 5042, "dimensions", 2000, "SELECT * FROM (SELECT pc.*, \"pd\".\"start\", pd.step, pd.stop FROM \"sys\".\"_columns\" AS pc, \"sys\".\"_dimensions\" AS pd WHERE pc.id = pd.column_id UNION ALL SELECT tc.*, \"td\".\"start\", td.step, td.stop FROM \"tmp\".\"_columns\" AS tc, \"tmp\".\"_dimensions\" AS td WHERE tc.id = td.column_id) AS dimensions;", 1, true, 0, false, false, 0, 0 ] +[ 5065, "db_user_info", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 5073, "users", 2000, "SELECT u.\"name\" AS \"name\", ui.\"fullname\", ui.\"default_schema\" FROM db_users() AS u LEFT JOIN \"sys\".\"db_user_info\" AS ui ON u.\"name\" = ui.\"name\" ;", 1, true, 0, false, false, 0, 0 ] +[ 5077, "user_role", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 5080, "auths", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 5084, "privileges", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 5237, "queryhistory", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 5251, "callhistory", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 5268, "querylog", 2000, "create view querylog as\nselect qd.*, ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, ql.inblock, ql.oublock from queryhistory qd, callhistory ql\nwhere qd.id = ql.id;", 1, true, 0, false, false, 0, 0 ] +[ 6543, "files", 6537, NULL, 0, false, 0, false, false, 0, 0 ] +[ 6550, "catalog", 6537, NULL, 0, false, 0, false, false, 0, 0 ] +[ 6844, "systemfunctions", 2000, NULL, 0, true, 0, false, false, 0, 0 ] +[ 6953, "r", 2000, NULL, 0, false, 0, false, false, 0, 0 ] # 18:53:13 > # 18:53:13 > "Done." _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
