Changeset: c40733f0a35a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c40733f0a35a
Modified Files:
sql/src/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.sql
sql/src/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.stable.err
sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.sql
sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.stable.err
sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.sql
sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.err
sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out
sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.sql
sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.stable.err
sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.sql
sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.stable.err
sql/src/test/BugTracker/Tests/create_column.SF-1643542.sql
sql/src/test/BugTracker/Tests/create_column.SF-1643542.stable.err
sql/src/test/BugTracker/Tests/create_column.SF-1643542.stable.out
sql/src/test/BugTracker/Tests/create_table_with_data.SF-1715679.sql
sql/src/test/BugTracker/Tests/create_table_with_data.SF-1715679.stable.out
sql/src/test/BugTracker/Tests/full_join_crash.SF-1841754.sql
sql/src/test/BugTracker/Tests/full_join_crash.SF-1841754.stable.out
sql/src/test/BugTracker/Tests/huge_math_expre.SF-1907048.sql
sql/src/test/BugTracker/Tests/like_join.SF-1684798.sql
sql/src/test/BugTracker/Tests/like_join.SF-1684798.stable.out
sql/src/test/BugTracker/Tests/local_global_temporary_table.SF-1715672.sql
sql/src/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.sql
sql/src/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.sql
sql/src/test/BugTracker/Tests/set_default_value.SF-1715553.sql
sql/src/test/BugTracker/Tests/table_dependency_inside_union.SF-1884382.sql
sql/src/test/BugTracker/Tests/table_dependency_inside_union.SF-1884382.stable.err
sql/src/test/BugTracker/Tests/table_dependency_inside_union.SF-1884382.stable.out
sql/src/test/BugTracker/Tests/temporary_tables.SF-1715669.sql
sql/src/test/BugTracker/Tests/temporary_tables.SF-1715669.stable.err
sql/src/test/BugTracker/Tests/update_fkey_with_value_not_in_the_pkey.SF-1734143.sql
sql/src/test/BugTracker/Tests/update_fkey_with_value_not_in_the_pkey.SF-1734143.stable.err
sql/src/test/BugTracker/Tests/update_fkey_with_value_not_in_the_pkey.SF-1734143.stable.out
sql/src/test/BugTracker/Tests/update_pkey_bug.SF-1733712.sql
sql/src/test/BugTracker/Tests/update_pkey_bug.SF-1733712.stable.err
sql/src/test/BugTracker/Tests/update_pkey_bug.SF-1733712.stable.out
sql/src/test/BugTracker/Tests/update_with_correlated_subselect.SF-1284791.sql
sql/src/test/BugTracker/Tests/update_with_correlated_subselect.SF-1284791.stable.out
sql/src/test/BugTracker/Tests/view_creation_using_func.SF-1714814.sql
sql/src/test/BugTracker/Tests/view_creation_using_func.SF-1714814.stable.err
Branch: Oct2010
Log Message:
use unique table names to prevent subsequent tests failing (only) due to
preceding tests crashing
renamed t{1,2,3,4,5} to t<bug-id>{a,b,c,d,e}
diffs (truncated from 797 to 300 lines):
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.sql
--- a/sql/src/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.sql Fri Oct
29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.sql Fri Oct
29 13:27:10 2010 +0200
@@ -1,28 +1,28 @@
-create table t2 (id int , name varchar(1024), CONSTRAINT pk_t2_id PRIMARY KEY
(id));
-create table t3 (age int , address int, CONSTRAINT pk_t3_age PRIMARY KEY
(age));
-create table t1 (id int , age int);
+create table t1737668b (id int , name varchar(1024), CONSTRAINT pk_t2_id
PRIMARY KEY (id));
+create table t1737668c (age int , address int, CONSTRAINT pk_t3_age PRIMARY
KEY (age));
+create table t1737668a (id int , age int);
-insert into t1 values(1, 10);
-insert into t1 values(2, 11);
-insert into t1 values(3, 12);
-insert into t1 values(4, 13);
-insert into t1 values(5, 14);
+insert into t1737668a values(1, 10);
+insert into t1737668a values(2, 11);
+insert into t1737668a values(3, 12);
+insert into t1737668a values(4, 13);
+insert into t1737668a values(5, 14);
-insert into t2 values(10, 'monetdb');
-insert into t2 values(11, 'moetdb');
-insert into t2 values(12, 'montdb');
-insert into t2 values(13, 'monetb');
-insert into t2 values(14, 'metdb');
+insert into t1737668b values(10, 'monetdb');
+insert into t1737668b values(11, 'moetdb');
+insert into t1737668b values(12, 'montdb');
+insert into t1737668b values(13, 'monetb');
+insert into t1737668b values(14, 'metdb');
-insert into t3 values(1, 101);
-insert into t3 values(2, 118);
-insert into t3 values(3, 108);
-insert into t3 values(4, 18);
-insert into t3 values(5, 1);
+insert into t1737668c values(1, 101);
+insert into t1737668c values(2, 118);
+insert into t1737668c values(3, 108);
+insert into t1737668c values(4, 18);
+insert into t1737668c values(5, 1);
-alter table t1 add constraint fk_t1_id_t2_id FOREIGN key(id) references t2(id);
-alter table t1 add constraint fk_t1_age_t3_age FOREIGN key(age) references
t3(age);
+alter table t1737668a add constraint fk_t1_id_t2_id FOREIGN key(id) references
t1737668b(id);
+alter table t1737668a add constraint fk_t1_age_t3_age FOREIGN key(age)
references t1737668c(age);
-drop table t1;
-drop table t3;
-drop table t2;
+drop table t1737668a;
+drop table t1737668c;
+drop table t1737668b;
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.stable.err
--- a/sql/src/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.stable.err
Fri Oct 29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.stable.err
Fri Oct 29 13:27:10 2010 +0200
@@ -13,11 +13,11 @@
# 13:25:13 >
MAPI = mone...@koala:32311
-QUERY = alter table t1 add constraint fk_t1_id_t2_id FOREIGN key(id)
references t2(id);
-ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint
't1.fk_t1_id_t2_id' violated
+QUERY = alter table t1737668a add constraint fk_t1_id_t2_id FOREIGN key(id)
references t1737668b(id);
+ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint
't1737668a.fk_t1_id_t2_id' violated
MAPI = mone...@koala:32311
-QUERY = alter table t1 add constraint fk_t1_age_t3_age FOREIGN key(age)
references t3(age);
-ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint
't1.fk_t1_age_t3_age' violated
+QUERY = alter table t1737668a add constraint fk_t1_age_t3_age FOREIGN key(age)
references t1737668c(age);
+ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint
't1737668a.fk_t1_age_t3_age' violated
# 13:25:13 >
# 13:25:13 > Done.
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.sql
--- a/sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.sql Fri Oct
29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.sql Fri Oct
29 13:27:10 2010 +0200
@@ -1,6 +1,6 @@
-create table t4 (id int);
-create table t5 (age float, yea int);
-select yea from t4, t5 where age between 0.03 and id < 30 ;
+create table t1959410d (id int);
+create table t1959410e (age float, yea int);
+select yea from t1959410d, t1959410e where age between 0.03 and id < 30 ;
-drop table t4;
-drop table t5;
+drop table t1959410d;
+drop table t1959410e;
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.stable.err
--- a/sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.stable.err
Fri Oct 29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.stable.err
Fri Oct 29 13:27:10 2010 +0200
@@ -13,7 +13,7 @@
# 10:53:08 >
MAPI = mone...@volund:38056
-QUERY = select yea from t4, t5 where age between 0.03 and id < 30 ;
+QUERY = select yea from t1959410d, t1959410e where age between 0.03 and id <
30 ;
ERROR = !types boolean(1,0) and double(53,2) are not equal
# 10:53:08 >
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.sql
--- a/sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.sql Fri Oct
29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.sql Fri Oct
29 13:27:10 2010 +0200
@@ -8,12 +8,12 @@
select * from test_subquery;
-- we don't support limit in the subquery
-SELECT date, (SELECT date from test_subquery where date > t1.date limit 1) as
dtNext from test_subquery t1;
+SELECT date, (SELECT date from test_subquery where date > t1892413a.date limit
1) as dtNext from test_subquery t1892413a;
-- but we need to reduce (ie this fails)
-SELECT date, (SELECT date from test_subquery where date > t1.date) as dtNext
from test_subquery t1;
+SELECT date, (SELECT date from test_subquery where date > t1892413a.date) as
dtNext from test_subquery t1892413a;
-- so we use MAX
-SELECT date, (SELECT max(date) from test_subquery where date > t1.date) as
dtNext from test_subquery t1;
+SELECT date, (SELECT max(date) from test_subquery where date > t1892413a.date)
as dtNext from test_subquery t1892413a;
drop table test_subquery;
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.err
--- a/sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.err
Fri Oct 29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.err
Fri Oct 29 13:27:10 2010 +0200
@@ -13,10 +13,10 @@
# 10:24:35 >
MAPI = mone...@koala:39391
-QUERY = SELECT date, (SELECT date from test_subquery where date > t1.date
limit 1) as dtNext from test_subquery t1;
-ERROR = !syntax error, unexpected LIMIT, expecting INTERSECT or EXCEPT or
UNION or ')' in: "select date, (select date from test_subquery where date >
t1.date limit"
+QUERY = SELECT date, (SELECT date from test_subquery where date >
t1892413a.date limit 1) as dtNext from test_subquery t1892413a;
+ERROR = !syntax error, unexpected LIMIT, expecting INTERSECT or EXCEPT or
UNION or ')' in: "select date, (select date from test_subquery where date >
t1892413a.date limit"
MAPI = mone...@koala:39391
-QUERY = SELECT date, (SELECT date from test_subquery where date > t1.date) as
dtNext from test_subquery t1;
+QUERY = SELECT date, (SELECT date from test_subquery where date >
t1892413a.date) as dtNext from test_subquery t1892413a;
ERROR = !SQLException:assert:zero_or_one: cardinality violation (2>1)
# 10:24:35 >
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out
--- a/sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out
Fri Oct 29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out
Fri Oct 29 13:27:10 2010 +0200
@@ -34,7 +34,7 @@
[ 19251231 ]
[ 19260102 ]
[ 19260104 ]
-% .t1, .test_subquery # table_name
+% .t1892413a, .test_subquery # table_name
% date, dtnext # name
% int, int # type
% 8, 8 # length
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.sql
--- a/sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.sql Fri Oct
29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.sql Fri Oct
29 13:27:10 2010 +0200
@@ -1,8 +1,8 @@
-create table t1 (id int, name varchar(1024), PRIMARY KEY(id));
-create table t2 (id int, age int, FOREIGN KEY(id) REFERENCES t1(id));
-insert into t1 values(3, 'monb');
-insert into t2 values(3, 25);
-update t2 set id = 10 where id =3;
+create table t1703497a (id int, name varchar(1024), PRIMARY KEY(id));
+create table t1703497b (id int, age int, FOREIGN KEY(id) REFERENCES
t1703497a(id));
+insert into t1703497a values(3, 'monb');
+insert into t1703497b values(3, 25);
+update t1703497b set id = 10 where id =3;
-drop table t2;
-drop table t1;
+drop table t1703497b;
+drop table t1703497a;
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.stable.err
--- a/sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.stable.err
Fri Oct 29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.stable.err
Fri Oct 29 13:27:10 2010 +0200
@@ -11,8 +11,8 @@
# 13:27:58 >
MAPI = mone...@localhost:32317
-QUERY = update t2 set id = 10 where id =3;
-ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint 't2.t2_id_fkey'
violated
+QUERY = update t1703497b set id = 10 where id =3;
+ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint
't1703497b.t1703497b_id_fkey' violated
# 13:27:58 >
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.sql
--- a/sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.sql
Fri Oct 29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.sql
Fri Oct 29 13:27:10 2010 +0200
@@ -1,10 +1,10 @@
START TRANSACTION;
-create table t1 (id int, name varchar(1024), PRIMARY KEY(id));
-create table t2 (id int, age int, FOREIGN KEY(id) REFERENCES t1(id));
-insert into t1 values(3, 'monb');
-insert into t2 values(3, 25);
-update t2 set id = 10 where id =3;
+create table t1703497a (id int, name varchar(1024), PRIMARY KEY(id));
+create table t1703497b (id int, age int, FOREIGN KEY(id) REFERENCES
t1703497a(id));
+insert into t1703497a values(3, 'monb');
+insert into t1703497b values(3, 25);
+update t1703497b set id = 10 where id =3;
-drop table t2;
-drop table t1;
+drop table t1703497b;
+drop table t1703497a;
COMMIT;
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.stable.err
--- a/sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.stable.err
Fri Oct 29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.stable.err
Fri Oct 29 13:27:10 2010 +0200
@@ -81,13 +81,13 @@
# 21:01:02 >
MAPI = mone...@localhost:33906
-QUERY = update t2 set id = 10 where id =3;
-ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint 't2.t2_id_fkey'
violated
+QUERY = update t1703497b set id = 10 where id =3;
+ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint
't1703497b.t1703497b_id_fkey' violated
MAPI = mone...@localhost:33906
-QUERY = drop table t2;
+QUERY = drop table t1703497b;
ERROR = !current transaction is aborted (please ROLLBACK)
MAPI = mone...@localhost:33906
-QUERY = drop table t1;
+QUERY = drop table t1703497a;
ERROR = !current transaction is aborted (please ROLLBACK)
MAPI = mone...@localhost:33906
QUERY = COMMIT;
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/create_column.SF-1643542.sql
--- a/sql/src/test/BugTracker/Tests/create_column.SF-1643542.sql Fri Oct
29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/create_column.SF-1643542.sql Fri Oct
29 13:27:10 2010 +0200
@@ -1,8 +1,8 @@
-create table t1(id int, name varchar(1024));
+create table t1643542a(id int, name varchar(1024));
-alter table t1 add col int;
-alter table t1 add col int;
+alter table t1643542a add col int;
+alter table t1643542a add col int;
-select * from t1;
+select * from t1643542a;
-drop table t1;
+drop table t1643542a;
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/create_column.SF-1643542.stable.err
--- a/sql/src/test/BugTracker/Tests/create_column.SF-1643542.stable.err Fri Oct
29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/create_column.SF-1643542.stable.err Fri Oct
29 13:27:10 2010 +0200
@@ -13,7 +13,7 @@
# 12:47:21 >
MAPI = mone...@volund:35971
-QUERY = alter table t1 add col int;
+QUERY = alter table t1643542a add col int;
ERROR = !ALTER TABLE: a column named 'col' already exists
# 12:47:21 >
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/create_column.SF-1643542.stable.out
--- a/sql/src/test/BugTracker/Tests/create_column.SF-1643542.stable.out Fri Oct
29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/create_column.SF-1643542.stable.out Fri Oct
29 13:27:10 2010 +0200
@@ -19,7 +19,7 @@
# 12:47:21 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31435 < create_column.SF-1643542.sql
# 12:47:21 >
-% sys.t1, sys.t1, sys.t1 # table_name
+% sys.t1643542a, sys.t1643542a, sys.t1643542a # table_name
% id, name, col # name
% int, varchar, int # type
% 1, 0, 1 # length
diff -r 77b5ee7cd20f -r c40733f0a35a
sql/src/test/BugTracker/Tests/create_table_with_data.SF-1715679.sql
--- a/sql/src/test/BugTracker/Tests/create_table_with_data.SF-1715679.sql
Fri Oct 29 10:53:50 2010 +0200
+++ b/sql/src/test/BugTracker/Tests/create_table_with_data.SF-1715679.sql
Fri Oct 29 13:27:10 2010 +0200
@@ -1,18 +1,18 @@
-create table t2 (id int);
+create table t1715679b (id int);
-insert into t2 values(1);
-insert into t2 values(2);
-insert into t2 values(3);
-insert into t2 values(4);
-insert into t2 values(5);
-insert into t2 values(6);
-insert into t2 values(7);
-insert into t2 values(8);
-insert into t2 values(9);
+insert into t1715679b values(1);
+insert into t1715679b values(2);
+insert into t1715679b values(3);
+insert into t1715679b values(4);
+insert into t1715679b values(5);
+insert into t1715679b values(6);
+insert into t1715679b values(7);
+insert into t1715679b values(8);
+insert into t1715679b values(9);
-create table t1 as select * from t2 order by id asc with data;
-select * from t1;
+create table t1715679a as select * from t1715679b order by id asc with data;
+select * from t1715679a;
-drop table t1;
-drop table t2;
+drop table t1715679a;
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
