Changeset: 5061267a26ba for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5061267a26ba
Added Files:
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300.test
Removed Files:
sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.test
sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829_cleanup.test
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300-1.test
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300-2.reqtests
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300-2.test
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300-3.reqtests
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300-3.test
Modified Files:
sql/test/BugTracker-2009/Tests/All
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
sql/test/BugTracker-2013/Tests/All
Branch: Aug2024
Log Message:
Cleanup some tests.
diffs (truncated from 528 to 300 lines):
diff --git a/sql/test/BugTracker-2009/Tests/All
b/sql/test/BugTracker-2009/Tests/All
--- a/sql/test/BugTracker-2009/Tests/All
+++ b/sql/test/BugTracker-2009/Tests/All
@@ -116,10 +116,3 @@ NOT_WIN32&HAVE_HGE?copy_multiple_files.S
not_invalidtable_crash.SF-2927174
drop-sequence-crash.SF-2854195
arithmetic-small-values-null.SF-2921310
-#
-# The following test currently crashes and this fact (or its remains) might
-# harm sub-sequent tests; hence, this test should be last in this directory.
-
-# conversion to logic tests (11/2020): These tests use explain so we just skip
them for now
-# explain_gives_crash.SF-2741829
-# explain_gives_crash.SF-2741829_cleanup
diff --git a/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.test
b/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.test
deleted file mode 100644
--- a/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.test
+++ /dev/null
@@ -1,47 +0,0 @@
-statement ok
-set optimizer='sequential_pipe'
-
-statement ok
-create table blabla(id integer)
-
-query T rowsort
-select '~BeginProfilingOutput~'
-----
-~BeginProfilingOutput~
-
-query T rowsort
-explain alter table blabla add constraint dada unique (id)
-----
-42 values hashing to 21a8f0388c1567e3388eff8d26aa8cee
-
-query T rowsort
-explain alter table blabla add constraint dada unique (id)
-----
-42 values hashing to 64069f06ba33ca07651fd1cd0cf2d8a7
-
-query T rowsort
-select '~EndProfilingOutput~'
-----
-~EndProfilingOutput~
-
-statement error
-alter table blabla drop constraint dada
-
-query T rowsort
-select '~BeginProfilingOutput~'
-----
-~BeginProfilingOutput~
-
-query T rowsort
-explain alter table blabla add constraint dada unique (id)
-----
-42 values hashing to 29928a32f10acd62f7ae255837b36c44
-
-query T rowsort
-select '~EndProfilingOutput~'
-----
-~EndProfilingOutput~
-
-statement ok
-set optimizer = 'default_pipe'
-
diff --git
a/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829_cleanup.test
b/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829_cleanup.test
deleted file mode 100644
--- a/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829_cleanup.test
+++ /dev/null
@@ -1,4 +0,0 @@
-statement ok
-drop table blabla
-
-
diff --git
a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
--- a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
+++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
@@ -16,326 +16,16 @@ insert into oblo values (2)
statement ok
insert into oblo values (1)
-query T nosort
- PLAN select * from oblo
-----
-project (
-| table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-) [ "oblo"."a" NOT NULL ]
-
-query T nosort
- PLAN select * from oblo OFFSET 2
-----
-project (
-| top N (
-| | table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-| ) [ bigint(63) NULL, bigint(63) "2" ]
-) [ "oblo"."a" NOT NULL ]
-
-query T nosort
- PLAN select * from oblo LIMIT 2
-----
-project (
-| top N (
-| | table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-| ) [ bigint(63) "2" ]
-) [ "oblo"."a" NOT NULL ]
-
-query T nosort
- PLAN select * from oblo LIMIT 1 OFFSET 2
-----
-project (
-| top N (
-| | table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-| ) [ bigint(63) "1", bigint(63) "2" ]
-) [ "oblo"."a" NOT NULL ]
-
-query T nosort
- PLAN select * from oblo LIMIT 2 OFFSET 1
-----
-project (
-| top N (
-| | table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-| ) [ bigint(63) "2", bigint(63) "1" ]
-) [ "oblo"."a" NOT NULL ]
-
-query T nosort
- PLAN select * from oblo ORDER BY a
-----
-project (
-| table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-) [ "oblo"."a" NOT NULL ] [ "oblo"."a" ASC NOT NULL ]
-
-query T nosort
- PLAN select * from oblo ORDER BY a OFFSET 2
-----
-top N (
-| project (
-| | table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-| ) [ "oblo"."a" NOT NULL ] [ "oblo"."a" ASC NOT NULL ]
-) [ bigint(63) NULL, bigint(63) "2" ]
-
-query T nosort
- PLAN select * from oblo ORDER BY a LIMIT 2
-----
-top N (
-| project (
-| | table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-| ) [ "oblo"."a" NOT NULL ] [ "oblo"."a" ASC NOT NULL ]
-) [ bigint(63) "2" ]
-
-query T nosort
- PLAN select * from oblo ORDER BY a LIMIT 2 OFFSET 1
+query I rowsort
+select * from oblo
----
-top N (
-| project (
-| | table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-| ) [ "oblo"."a" NOT NULL ] [ "oblo"."a" ASC NOT NULL ]
-) [ bigint(63) "2", bigint(63) "1" ]
-
-query T nosort
- PLAN select * from oblo ORDER BY a LIMIT 1 OFFSET 2
-----
-top N (
-| project (
-| | table("sys"."oblo") [ "oblo"."a" NOT NULL ]
-| ) [ "oblo"."a" NOT NULL ] [ "oblo"."a" ASC NOT NULL ]
-) [ bigint(63) "1", bigint(63) "2" ]
-
-query T python .explain.function_histogram
-EXPLAIN select * from oblo
-----
-algebra.projection
-1
-bat.pack
-5
-querylog.define
-1
-sql.bind
-1
-sql.mvc
-1
-sql.resultSet
-1
-sql.tid
-1
-user.main
-1
-
-query T python .explain.function_histogram
-EXPLAIN select * from oblo OFFSET 2
-----
-algebra.projection
-2
-algebra.subslice
-1
-bat.pack
-5
-querylog.define
-1
-sql.bind
-1
-sql.mvc
-1
-sql.resultSet
-1
-sql.tid
-1
-user.main
-1
-
-query T python .explain.function_histogram
-EXPLAIN select * from oblo LIMIT 2
-----
-algebra.projection
-2
-algebra.subslice
-1
-bat.pack
-5
-querylog.define
-1
-sql.bind
-1
-sql.mvc
-1
-sql.resultSet
-1
-sql.tid
-1
-user.main
-1
-
-query T python .explain.function_histogram
-EXPLAIN select * from oblo LIMIT 1 OFFSET 2
-----
-algebra.projection
-2
-algebra.subslice
1
-bat.pack
-5
-querylog.define
-1
-sql.bind
-1
-sql.mvc
-1
-sql.resultSet
-1
-sql.tid
-1
-user.main
-1
-
-query T python .explain.function_histogram
-EXPLAIN select * from oblo LIMIT 2 OFFSET 1
-----
-algebra.projection
2
-algebra.subslice
-1
-bat.pack
-5
-querylog.define
-1
-sql.bind
-1
-sql.mvc
-1
-sql.resultSet
-1
-sql.tid
-1
-user.main
-1
-
-query T python .explain.function_histogram
-EXPLAIN select * from oblo ORDER BY a
-----
-algebra.projection
-1
-algebra.sort
-1
-bat.pack
-5
-querylog.define
-1
-sql.bind
-1
-sql.mvc
-1
-sql.resultSet
-1
-sql.tid
-1
-user.main
-1
+3
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
