Changeset: 0d1063ad6b77 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0d1063ad6b77
Modified Files:
sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.sql
sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.stable.out
Branch: default
Log Message:
Adapted test with temporary table. Added explicit start transaction and commit
as by default the server is in auto commit state and temporary tables do not
preserve data rows by default on commit.
diffs (82 lines):
diff --git a/sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.sql
b/sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.sql
--- a/sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.sql
+++ b/sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.sql
@@ -1,3 +1,4 @@
+start transaction;
create temp table foo (f1 string, f2 text, f3 varchar(12345678));
insert into foo values('aa1','bb1','cc1');
select * from foo;
@@ -12,4 +13,5 @@ select * from foo;
insert into foo values('aa4','bb4','cc4');
select * from foo;
drop table foo;
+commit;
diff --git
a/sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.stable.out
b/sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.stable.out
--- a/sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.stable.out
+++ b/sql/test/BugTracker-2014/Tests/insert_into_temp_table.Bug-3600.stable.out
@@ -64,42 +64,56 @@ Ready.
% tmp.foo, tmp.foo, tmp.foo # table_name
% f1, f2, f3 # name
% clob, clob, varchar # type
-% 0, 0, 0 # length
+% 3, 3, 3 # length
+[ "aa1", "bb1", "cc1" ]
#insert into foo values('aa2','bb2','cc2');
[ 1 ]
#select * from foo;
% tmp.foo, tmp.foo, tmp.foo # table_name
% f1, f2, f3 # name
% clob, clob, varchar # type
-% 0, 0, 0 # length
+% 3, 3, 3 # length
+[ "aa1", "bb1", "cc1" ]
+[ "aa2", "bb2", "cc2" ]
#insert into foo values('aa3','bb3','cc3');
[ 1 ]
#select * from foo;
% tmp.foo, tmp.foo, tmp.foo # table_name
% f1, f2, f3 # name
% clob, clob, varchar # type
-% 0, 0, 0 # length
+% 3, 3, 3 # length
+[ "aa1", "bb1", "cc1" ]
+[ "aa2", "bb2", "cc2" ]
+[ "aa3", "bb3", "cc3" ]
#update foo set f1 = 'abc';
-[ 0 ]
+[ 3 ]
#select * from foo;
% tmp.foo, tmp.foo, tmp.foo # table_name
% f1, f2, f3 # name
% clob, clob, varchar # type
-% 0, 0, 0 # length
+% 3, 3, 3 # length
+[ "abc", "bb1", "cc1" ]
+[ "abc", "bb2", "cc2" ]
+[ "abc", "bb3", "cc3" ]
#delete from foo where f2 = 'bb2';
-[ 0 ]
+[ 1 ]
#select * from foo;
% tmp.foo, tmp.foo, tmp.foo # table_name
% f1, f2, f3 # name
% clob, clob, varchar # type
-% 0, 0, 0 # length
+% 3, 3, 3 # length
+[ "abc", "bb1", "cc1" ]
+[ "abc", "bb3", "cc3" ]
#insert into foo values('aa4','bb4','cc4');
[ 1 ]
#select * from foo;
% tmp.foo, tmp.foo, tmp.foo # table_name
% f1, f2, f3 # name
% clob, clob, varchar # type
-% 0, 0, 0 # length
+% 3, 3, 3 # length
+[ "abc", "bb1", "cc1" ]
+[ "abc", "bb3", "cc3" ]
+[ "aa4", "bb4", "cc4" ]
#drop table foo;
# 16:40:50 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
