Changeset: 0a6a367cda4c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0a6a367cda4c
Removed Files:
sql/test/Tests/crashme.test
sql/test/Tests/crashme.timeout
Modified Files:
sql/test/Tests/All
Branch: Jan2022
Log Message:
Removed useless (unused) test.
diffs (truncated from 5587 to 300 lines):
diff --git a/sql/test/Tests/All b/sql/test/Tests/All
--- a/sql/test/Tests/All
+++ b/sql/test/Tests/All
@@ -93,7 +93,6 @@ order_by_complex_exp
setoptimizer
string
-#NOT_WIN32?crashme bug #1825
50ways
load_with_offset
copy_into
diff --git a/sql/test/Tests/crashme.test b/sql/test/Tests/crashme.test
deleted file mode 100644
--- a/sql/test/Tests/crashme.test
+++ /dev/null
@@ -1,5565 +0,0 @@
-statement error
-set auto_commit = true
-
-statement error
-drop table crash_me
-
-statement error
-drop table crash_me cascade
-
-statement ok
-create table crash_me (a integer not null)
-
-statement ok
-drop table crash_me
-
-statement error
-drop table crash_me
-
-statement error
-drop table crash_me2
-
-statement error
-drop table crash_me3
-
-statement error
-drop table crash_q
-
-statement error
-drop table crash_q1
-
-statement ok
-create table crash_me (a integer not null,b char(10) not null)
-
-statement ok
-insert into crash_me (a,b) values (1,'a')
-
-query I rowsort
-select 1
-----
-1
-
-query I rowsort
-select 1
-----
-1
-
-query I rowsort
-select a from crash_me where b<'b'
-----
-1
-
-query I rowsort
-select 1
-----
-1
-
-query IT rowsort
-select crash_me.* from crash_me
-----
-1
-a
-
-statement error
-select a from crash_me where b<"c"
-
-query T rowsort
-select 'Walker''s'
-----
-Walker's
-
-query I rowsort
-select a from crash_me where b < 'a'
-'b'
-----
-1
-
-statement error
-select "A" from crash_me
-
-statement error
-select `A` from crash_me
-
-statement error
-select [A] from crash_me
-
-statement ok
-create table crash_me1 ("abc""d" integer)
-
-statement ok
-drop table crash_me1
-
-query I rowsort
-select a as ab from crash_me
-----
-1
-
-query I rowsort
-select b.a from crash_me as b
-----
-1
-
-query I rowsort
-select 1+1
-----
-2
-
-query I rowsort
-select count(*) from crash_me
-----
-1
-
-query I rowsort
-select count(distinct a) from crash_me
-----
-1
-
-query II rowsort
-select count(distinct a), count(distinct b) from crash_me
-----
-1
-1
-
-query I rowsort
-select a from crash_me group by a
-----
-1
-
-statement error
-select a from crash_me group by 1
-
-query I rowsort
-select a as ab from crash_me group by ab
-----
-1
-
-query I rowsort
-select count(*) from crash_me group by a
-----
-1
-
-query I rowsort
-select a from crash_me order by a
-----
-1
-
-query I rowsort
-select a from crash_me order by 1
-----
-1
-
-query I rowsort
-select a from crash_me order by a+1
-----
-1
-
-query T rowsort
-select b from crash_me order by a
-----
-a
-
-statement error
-select a from crash_me order by a compute sum(a) by a
-
-statement ok
-create table crash_q (s char(10))
-
-statement ok
-insert into crash_q values ('a'),('b')
-
-statement ok
-drop table crash_q
-
-statement ok
-create table crash_q (a integer)
-
-statement error
-insert into crash_q SET a=1
-
-statement ok
-drop table crash_q
-
-statement ok
-create table crash_me_q (a int)
-
-statement error
-insert into crash_me_q (a) values (DEFAULT)
-
-statement ok
-drop table crash_me_q
-
-statement ok
-create table crash_me_q (a int)
-
-statement error
-insert into crash_me_q (a) values ()
-
-statement ok
-drop table crash_me_q
-
-statement ok
-create table crash_me_q (a int)
-
-statement ok
-insert into crash_me_q DEFAULT VALUES
-
-statement ok
-drop table crash_me_q
-
-query IT rowsort
-select * from crash_me
-----
-1
-a
-
-query IT rowsort
-select * from crash_me limit 1
-----
-1
-a
-
-statement error
-select * from crash_me limit 1,1
-
-query IT rowsort
-select * from crash_me limit 1 offset 1
-----
-
-statement ok
-create table crash_q (a integer, b integer,c1 CHAR(10))
-
-statement ok
-alter table crash_q add d integer
-
-statement error
-alter table crash_q add (f integer,g integer)
-
-statement error
-alter table crash_q change a e char(50)
-
-statement error
-alter table crash_q modify c1 CHAR(20)
-
-statement ok
-alter table crash_q alter b set default 10
-
-statement ok
-alter table crash_q drop column b
-
-statement ok
-alter table crash_q rename to crash_q1
-
-statement ok
-drop table crash_q1
-
-statement error
-drop table crash_q
-
-statement ok
-create table crash_q (a integer, b integer,c1 CHAR(10))
-
-statement error
-rename table crash_q to crash_q1
-
-statement error
-drop table crash_q1
-
-statement error
-drop table crash_q1
-
-statement ok
-drop table crash_q
-
-statement ok
-create table crash_q (a integer, b integer,c1 CHAR(10))
-
-statement ok
-truncate table crash_q
-
-statement ok
-drop table crash_q
-
-statement ok
-create table crash_q (a integer, b integer,c1 CHAR(10))
-
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
