From 7a3883486d5b41e02bdd52a1a646da96baa87a9c Mon Sep 17 00:00:00 2001 From: prabatuty Date: Fri, 8 Apr 2011 17:34:02 +0000 Subject: [PATCH] fixing exp files --- test/durability/redologs/exp.test001.ksh | 2 -- test/durability/redologs/exp.test002.ksh | 2 -- test/durability/redologs/exp.test003.ksh | 18 ++++++++---------- test/durability/redologs/exp.test004.ksh | 2 -- test/durability/redologs/exp.test004a.ksh | 2 -- test/durability/redologs/exp.test005.ksh | 16 +++++++--------- test/durability/redologs/exp.test006.ksh | 2 -- test/durability/redologs/exp.test007.ksh | 6 ++---- test/durability/redologs/exp.test008.ksh | 2 -- test/durability/redologs/exp.test009.ksh | 4 +--- 10 files changed, 18 insertions(+), 38 deletions(-) diff --git a/test/durability/redologs/exp.test001.ksh b/test/durability/redologs/exp.test001.ksh index eb1d9790..6944aae8 100644 --- a/test/durability/redologs/exp.test001.ksh +++ b/test/durability/redologs/exp.test001.ksh @@ -4,7 +4,6 @@ Statement Executed: Rows Affected = 1 Statement Executed: Rows Affected = 1 Statement Executed: Rows Affected = 1 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:48 STMT:CREATE TABLE laks(f1 int); PREPARE: SID:2 INSERT INTO laks values (10); EXEC SID:2 TID:16 @@ -21,7 +20,6 @@ Checking Durability Server Started Statement Executed: Rows Affected = 1 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt -Redo log filename is :/tmp/csql/db/csql.db.cur PREPARE: SID:1 INSERT INTO laks values (50); EXEC SID:1 TID:16 FREE SID:1 diff --git a/test/durability/redologs/exp.test002.ksh b/test/durability/redologs/exp.test002.ksh index aae6e6df..fb05a8da 100644 --- a/test/durability/redologs/exp.test002.ksh +++ b/test/durability/redologs/exp.test002.ksh @@ -15,7 +15,6 @@ Statement Executed: Rows Affected = 1 50 50 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:56 STMT:CREATE TABLE laks(f1 int, f2 int); PREPARE: SID:2 INSERT INTO laks values (10, 10); EXEC SID:2 TID:16 @@ -45,4 +44,3 @@ Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt diff --git a/test/durability/redologs/exp.test003.ksh b/test/durability/redologs/exp.test003.ksh index b1948e9c..6a22f797 100644 --- a/test/durability/redologs/exp.test003.ksh +++ b/test/durability/redologs/exp.test003.ksh @@ -8,21 +8,19 @@ PREPARE: SID:3 UPDATE t1 set f1=? where f2=200; FREE: SID:3 TID:12 PREPARE: SID:4 DELETE from t1 where f2=?; FREE: SID:4 TID:12 -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:56 STMT:CREATE TABLE t1(f1 int, f2 int); -SET SID:2 POS:1 TYPE:0 LEN:4 Value:100 -EXEC SID:2 TID:72 -SET SID:2 POS:1 TYPE:0 LEN:4 Value:200 -EXEC SID:2 TID:72 +SET SID:2 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100 +EXEC SID:2 TID:80 +SET SID:2 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:200 +EXEC SID:2 TID:80 FREE SID:2 -SET SID:3 POS:1 TYPE:0 LEN:4 Value:200 -EXEC SID:3 TID:40 +SET SID:3 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:200 +EXEC SID:3 TID:44 FREE SID:3 -SET SID:4 POS:1 TYPE:0 LEN:4 Value:100 -EXEC SID:4 TID:40 +SET SID:4 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100 +EXEC SID:4 TID:44 FREE SID:4 Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt diff --git a/test/durability/redologs/exp.test004.ksh b/test/durability/redologs/exp.test004.ksh index 85519770..33c915eb 100644 --- a/test/durability/redologs/exp.test004.ksh +++ b/test/durability/redologs/exp.test004.ksh @@ -7,7 +7,6 @@ Statement Executed: Rows Affected = 1 Statement Executed Statement Executed: Rows Affected = 1 Statement Redo log filename is :/tmp/csql/db/csql.db.stmt -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:64 STMT:CREATE TABLE laks(f1 int not null, f2 int); PREPARE: SID:2 INSERT INTO laks values (10, 10); EXEC SID:2 TID:16 @@ -26,7 +25,6 @@ Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt CREATE TABLE laks (f1 INT NOT NULL , f2 INT ); INSERT INTO laks VALUES(10,10); INSERT INTO laks VALUES(50,50); diff --git a/test/durability/redologs/exp.test004a.ksh b/test/durability/redologs/exp.test004a.ksh index e70fcae5..940fea58 100644 --- a/test/durability/redologs/exp.test004a.ksh +++ b/test/durability/redologs/exp.test004a.ksh @@ -8,7 +8,6 @@ Statement Executed Statement Executed: Rows Affected = 1 Statement Executed Statement Redo log filename is :/tmp/csql/db/csql.db.stmt -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:64 STMT:CREATE TABLE laks(f1 int not null, f2 int); PREPARE: SID:2 INSERT INTO laks values (10, 10); EXEC SID:2 TID:16 @@ -28,4 +27,3 @@ Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt diff --git a/test/durability/redologs/exp.test005.ksh b/test/durability/redologs/exp.test005.ksh index b7234c39..7a6606fb 100644 --- a/test/durability/redologs/exp.test005.ksh +++ b/test/durability/redologs/exp.test005.ksh @@ -7,25 +7,23 @@ PREPARE: SID:4 INSERT INTO t1 VALUES(1234,?); FREE: SID:4 TID:12 PREPARE: SID:6 INSERT INTO t1 VALUES(1234,?); FREE: SID:6 TID:12 -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:72 STMT:CREATE TABLE t1(f1 int not null, f2 int not null); -SET SID:2 POS:1 TYPE:0 LEN:4 Value:100 -EXEC SID:2 TID:72 -SET SID:2 POS:1 TYPE:0 LEN:4 Value:200 -EXEC SID:2 TID:72 +SET SID:2 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100 +EXEC SID:2 TID:80 +SET SID:2 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:200 +EXEC SID:2 TID:80 FREE SID:2 EXECDIRECT SID:3 TID:64 STMT:create index idx on t1 (f2) primary hash; -SET SID:4 POS:1 TYPE:0 LEN:4 Value:100 +SET SID:4 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100 FREE SID:4 EXECDIRECT SID:5 TID:36 STMT:drop index idx; -SET SID:6 POS:1 TYPE:0 LEN:4 Value:100 -EXEC SID:6 TID:40 +SET SID:6 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100 +EXEC SID:6 TID:44 FREE SID:6 Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt CREATE TABLE t1 (f1 INT NOT NULL , f2 INT NOT NULL ); INSERT INTO t1 VALUES(1234,100); INSERT INTO t1 VALUES(1234,200); diff --git a/test/durability/redologs/exp.test006.ksh b/test/durability/redologs/exp.test006.ksh index c807e2bc..667f3f22 100644 --- a/test/durability/redologs/exp.test006.ksh +++ b/test/durability/redologs/exp.test006.ksh @@ -1,7 +1,6 @@ Server Started Statement Executed Statement Redo log filename is :/tmp/csql/db/csql.db.stmt -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:72 STMT:CREATE TABLE t1(f1 int not null, f2 int not null); PREPARE: SID:2 INSERT INTO t1 VALUES(1234,100); EXEC SID:2 TID:16 @@ -9,6 +8,5 @@ Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt CREATE TABLE t1 (f1 INT NOT NULL , f2 INT NOT NULL ); INSERT INTO t1 VALUES(1234,100); diff --git a/test/durability/redologs/exp.test007.ksh b/test/durability/redologs/exp.test007.ksh index fd81031e..e92f9361 100644 --- a/test/durability/redologs/exp.test007.ksh +++ b/test/durability/redologs/exp.test007.ksh @@ -2,14 +2,12 @@ Server Started Statement Executed Statement Redo log filename is :/tmp/csql/db/csql.db.stmt PREPARE: SID:2 INSERT INTO t1 VALUES(1234,?); -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:72 STMT:CREATE TABLE t1(f1 int not null, f2 int not null); -SET SID:2 POS:1 TYPE:0 LEN:4 Value:100 -EXEC SID:2 TID:40 +SET SID:2 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100 +EXEC SID:2 TID:44 Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt CREATE TABLE t1 (f1 INT NOT NULL , f2 INT NOT NULL ); INSERT INTO t1 VALUES(1234,100); diff --git a/test/durability/redologs/exp.test008.ksh b/test/durability/redologs/exp.test008.ksh index 57515269..e65ea2ad 100644 --- a/test/durability/redologs/exp.test008.ksh +++ b/test/durability/redologs/exp.test008.ksh @@ -1,12 +1,10 @@ Server Started Statement Executed Statement Redo log filename is :/tmp/csql/db/csql.db.stmt -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:72 STMT:CREATE TABLE t1(f1 int not null, f2 int not null); PREPARE: SID:2 INSERT INTO t1 VALUES(1234,100); Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt CREATE TABLE t1 (f1 INT NOT NULL , f2 INT NOT NULL ); diff --git a/test/durability/redologs/exp.test009.ksh b/test/durability/redologs/exp.test009.ksh index e60c4e7f..fab80c12 100644 --- a/test/durability/redologs/exp.test009.ksh +++ b/test/durability/redologs/exp.test009.ksh @@ -2,12 +2,10 @@ Server Started Statement Executed Statement Redo log filename is :/tmp/csql/db/csql.db.stmt PREPARE: SID:2 INSERT INTO t1 VALUES(1234,?); -Redo log filename is :/tmp/csql/db/csql.db.cur EXECDIRECT SID:1 TID:72 STMT:CREATE TABLE t1(f1 int not null, f2 int not null); -SET SID:2 POS:1 TYPE:0 LEN:4 Value:100 +SET SID:2 POS:1 ISNULL:FALSE TYPE:0 LEN:4 Value:100 Server Killed Checking Durability Server Started -Statement Redo log filename is :/tmp/csql/db/csql.db.stmt CREATE TABLE t1 (f1 INT NOT NULL , f2 INT NOT NULL ); -- 2.11.4.GIT