From e306b7e35494f0d2e52793bee08d8c9c1c82f33c Mon Sep 17 00:00:00 2001 From: prabatuty Date: Sun, 5 Jun 2011 02:41:20 +0000 Subject: [PATCH] *** empty log message *** --- test/tools/csql/exp.test094.ksh | 10 +++++----- test/tools/csql/exp.testnw032.ksh | 34 +++++++++++++++++++++------------- test/tools/csql/exp.testnw033.ksh | 34 +++++++++++++++++++++------------- 3 files changed, 47 insertions(+), 31 deletions(-) diff --git a/test/tools/csql/exp.test094.ksh b/test/tools/csql/exp.test094.ksh index 1cb762d9..7a46bc30 100644 --- a/test/tools/csql/exp.test094.ksh +++ b/test/tools/csql/exp.test094.ksh @@ -104,7 +104,7 @@ echo SELECT * FROM T4; 5 3 echo UPDATE T4 SET f2=200,f1=0 WHERE f2=20; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T4; --------------------------------------------------------- T4.f1 T4.f2 @@ -116,7 +116,7 @@ echo SELECT * FROM T4; 5 3 echo UPDATE T4 SET f2=300,f1=30 WHERE f1<=2; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T4; --------------------------------------------------------- T4.f1 T4.f2 @@ -224,7 +224,7 @@ echo SELECT * FROM T6; 5 3 echo UPDATE T6 SET f2=200,f1=0 WHERE f2=20; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T6; --------------------------------------------------------- T6.f1 T6.f2 @@ -236,7 +236,7 @@ echo SELECT * FROM T6; 5 3 echo UPDATE T6 SET f2=300,f1=30 WHERE f1<=2; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T6; --------------------------------------------------------- T6.f1 T6.f2 @@ -309,7 +309,7 @@ echo SELECT * FROM T7; 1 2 3 echo UPDATE T7 SET f3=30,f2=20,f1=0 where f1=1; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo UPDATE T7 SET f3=30,f2=20 where f1=1; Statement Executed: Rows Affected = 1 echo SELECT * FROM T7; diff --git a/test/tools/csql/exp.testnw032.ksh b/test/tools/csql/exp.testnw032.ksh index b84071b2..de42e968 100644 --- a/test/tools/csql/exp.testnw032.ksh +++ b/test/tools/csql/exp.testnw032.ksh @@ -105,7 +105,7 @@ echo SELECT * FROM T4; 5 3 echo UPDATE T4 SET f2=200,f1=0 WHERE f2=20; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T4; --------------------------------------------------------- T4.f1 T4.f2 @@ -117,7 +117,7 @@ echo SELECT * FROM T4; 5 3 echo UPDATE T4 SET f2=300,f1=30 WHERE f1<=2; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T4; --------------------------------------------------------- T4.f1 T4.f2 @@ -225,7 +225,7 @@ echo SELECT * FROM T6; 5 3 echo UPDATE T6 SET f2=200,f1=0 WHERE f2=20; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T6; --------------------------------------------------------- T6.f1 T6.f2 @@ -237,7 +237,7 @@ echo SELECT * FROM T6; 5 3 echo UPDATE T6 SET f2=300,f1=30 WHERE f1<=2; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T6; --------------------------------------------------------- T6.f1 T6.f2 @@ -310,7 +310,7 @@ echo SELECT * FROM T7; 1 2 3 echo UPDATE T7 SET f3=30,f2=20,f1=0 where f1=1; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo UPDATE T7 SET f3=30,f2=20 where f1=1; Statement Executed: Rows Affected = 1 echo SELECT * FROM T7; @@ -324,21 +324,29 @@ Statement Executed: Rows Affected = 1 echo DELETE FROM T7 WHERE f3<=3; Statement Executed: Rows Affected = 1 echo CREATE TABLE T8(f1 SMALLINT AUTO_INCREMENT,f2 SMALLINT,f3 SMALLINT,PRIMARY KEY(f1)); -Statement execute failed with error -4 +Statement Executed echo INSERT INTO T8 VALUES(1,2,3); -Statement prepare failed with error -5 +Statement Executed: Rows Affected = 1 echo SELECT * FROM T8; -Statement prepare failed with error -5 +--------------------------------------------------------- + T8.f1 T8.f2 T8.f3 +--------------------------------------------------------- + 1 2 3 + echo UPDATE T8 SET f3=30,f2=20,f1=0 where f1=1; -Statement prepare failed with error -5 +Statement prepare failed with error -21 echo UPDATE T8 SET f3=30,f2=20 where f1=1; -Statement prepare failed with error -5 +Statement Executed: Rows Affected = 1 echo SELECT * FROM T8; -Statement prepare failed with error -5 +--------------------------------------------------------- + T8.f1 T8.f2 T8.f3 +--------------------------------------------------------- + 1 20 30 + echo INSERT INTO T8 VALUES(2,4,3); -Statement prepare failed with error -5 +Statement Executed: Rows Affected = 1 echo DELETE FROM T8 WHERE f3<=3; -Statement prepare failed with error -5 +Statement Executed: Rows Affected = 1 echo CREATE TABLE T9(f1 SMALLINT AUTO_INCREMENT,f2 SMALLINT,f3 SMALLINT); Statement Executed echo CREATE INDEX idx1 ON T9(f1,f2) UNIQUE; diff --git a/test/tools/csql/exp.testnw033.ksh b/test/tools/csql/exp.testnw033.ksh index 4b2cb44c..d93780a8 100644 --- a/test/tools/csql/exp.testnw033.ksh +++ b/test/tools/csql/exp.testnw033.ksh @@ -105,7 +105,7 @@ echo SELECT * FROM T4; 5 3 echo UPDATE T4 SET f2=200,f1=0 WHERE f2=20; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T4; --------------------------------------------------------- T4.f1 T4.f2 @@ -117,7 +117,7 @@ echo SELECT * FROM T4; 5 3 echo UPDATE T4 SET f2=300,f1=30 WHERE f1<=2; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T4; --------------------------------------------------------- T4.f1 T4.f2 @@ -225,7 +225,7 @@ echo SELECT * FROM T6; 5 3 echo UPDATE T6 SET f2=200,f1=0 WHERE f2=20; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T6; --------------------------------------------------------- T6.f1 T6.f2 @@ -237,7 +237,7 @@ echo SELECT * FROM T6; 5 3 echo UPDATE T6 SET f2=300,f1=30 WHERE f1<=2; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo SELECT * FROM T6; --------------------------------------------------------- T6.f1 T6.f2 @@ -310,7 +310,7 @@ echo SELECT * FROM T7; 1 2 3 echo UPDATE T7 SET f3=30,f2=20,f1=0 where f1=1; -Statement prepare failed with error -21 +Statement prepare failed with error -33 echo UPDATE T7 SET f3=30,f2=20 where f1=1; Statement Executed: Rows Affected = 1 echo SELECT * FROM T7; @@ -324,21 +324,29 @@ Statement Executed: Rows Affected = 1 echo DELETE FROM T7 WHERE f3<=3; Statement Executed: Rows Affected = 1 echo CREATE TABLE T8(f1 BIGINT AUTO_INCREMENT,f2 BIGINT,f3 BIGINT,PRIMARY KEY(f1)); -Statement execute failed with error -4 +Statement execute failed with error -8 echo INSERT INTO T8 VALUES(1,2,3); -Statement prepare failed with error -5 +Statement execute failed with error -21 echo SELECT * FROM T8; -Statement prepare failed with error -5 +--------------------------------------------------------- + T8.f1 T8.f2 T8.f3 +--------------------------------------------------------- + 1 20 30 + echo UPDATE T8 SET f3=30,f2=20,f1=0 where f1=1; -Statement prepare failed with error -5 +Statement prepare failed with error -21 echo UPDATE T8 SET f3=30,f2=20 where f1=1; -Statement prepare failed with error -5 +Statement Executed: Rows Affected = 1 echo SELECT * FROM T8; -Statement prepare failed with error -5 +--------------------------------------------------------- + T8.f1 T8.f2 T8.f3 +--------------------------------------------------------- + 1 20 30 + echo INSERT INTO T8 VALUES(2,4,3); -Statement prepare failed with error -5 +Statement Executed: Rows Affected = 1 echo DELETE FROM T8 WHERE f3<=3; -Statement prepare failed with error -5 +Statement Executed: Rows Affected = 1 echo CREATE TABLE T9(f1 BIGINT AUTO_INCREMENT,f2 BIGINT,f3 BIGINT); Statement Executed echo CREATE INDEX idx1 ON T9(f1,f2) UNIQUE; -- 2.11.4.GIT