From 035821be1180d90868d2c18394f37d4170842a73 Mon Sep 17 00:00:00 2001 From: kishoramballi Date: Tue, 1 Jul 2008 07:14:33 +0000 Subject: [PATCH] input sql files for the test scripts --- test/cache/Gateway/csqlinputtest12.sql | 11 +++++++++++ test/cache/Gateway/mysqlinputtest12.sql | 11 +++++++++++ test/cache/Gateway/selectstart2.sql | 1 + test/cache/Gateway/selectstart3.sql | 1 + test/cache/Gateway/updatet2.sql | 7 +++++++ test/cache/Gateway/updatet3.sql | 7 +++++++ 6 files changed, 38 insertions(+) create mode 100644 test/cache/Gateway/csqlinputtest12.sql create mode 100644 test/cache/Gateway/mysqlinputtest12.sql create mode 100644 test/cache/Gateway/selectstart2.sql create mode 100644 test/cache/Gateway/selectstart3.sql create mode 100644 test/cache/Gateway/updatet2.sql create mode 100644 test/cache/Gateway/updatet3.sql diff --git a/test/cache/Gateway/csqlinputtest12.sql b/test/cache/Gateway/csqlinputtest12.sql new file mode 100644 index 00000000..9fb24b58 --- /dev/null +++ b/test/cache/Gateway/csqlinputtest12.sql @@ -0,0 +1,11 @@ +CREATE TABLE t3 (t3f1 SMALLINT, t3f2 INT , t3f3 BIGINT , t3f4 CHAR (20), t3f5 FLOAT , t3f6 DOUBLE , t3f7 DATE , t3f8 TIME , t3f9 TIMESTAMP, primary key (t3f1) ); +INSERT INTO t3 VALUES(1, 2011, 111111111, 'Govind', 113.141, 111111111.111111, '1915/12/25', '11:42:35', '1971/12/25 11:42:35'); +INSERT INTO t3 VALUES(2, 1978, 222222222, 'Gopal', 114.567, 222222222.222222, '1926/05/16', '12:32:14', '1972/05/16 12:32:14'); +INSERT INTO t3 VALUES(3, 2008, 333333333, 'kishor', 122.700, 333333333.333333, '1937/08/15', '13:45:36', '1973/08/15 13:45:36'); +INSERT INTO t3 VALUES(4, 1973, 444444444, 'kiran', 142.718, 444444444.444444, '1946/12/25', '14:42:35', '1974/12/25 14:42:35'); +INSERT INTO t3 VALUES(5, 2005, 555555555, 'ganesh', 152.718, 555555555.555555, '1955/12/25', '15:42:35', '1975/12/25 15:42:35'); +INSERT INTO t3 VALUES(6, 1962, 666666666, 'suresh', 162.718, 666666666.666666, '1965/12/25', '16:42:35', '1976/12/25 16:42:35'); +INSERT INTO t3 VALUES(7, 1965, 777777777, 'Praba', 172.718, 777777777.777777, '1975/12/25', '17:42:35', '1977/12/25 17:42:35'); +INSERT INTO t3 VALUES(8, 1942, 888888888, 'karan', 182.718, 888888888.888888, '1985/12/25', '18:42:35', '1978/12/25 18:42:35'); +INSERT INTO t3 VALUES(9, 1956, 999999999, 'sharan', 192.718, 999999999.999999, '1995/12/25', '19:42:35', '1979/12/25 19:42:35'); +INSERT INTO t3 VALUES(10, 1999,101010101, 'vijay', 102.718, 111111111.999999, '1915/12/25', '20:42:35', '1980/12/25 20:42:35'); diff --git a/test/cache/Gateway/mysqlinputtest12.sql b/test/cache/Gateway/mysqlinputtest12.sql new file mode 100644 index 00000000..91eeea08 --- /dev/null +++ b/test/cache/Gateway/mysqlinputtest12.sql @@ -0,0 +1,11 @@ +CREATE TABLE t2 (t2f1 SMALLINT primary key, t2f2 INT , t2f3 BIGINT , t2f4 CHAR (20), t2f5 FLOAT , t2f6 DOUBLE , t2f7 DATE , t2f8 TIME , t2f9 TIMESTAMP ); +INSERT INTO t2 VALUES(1, 2011, 111111111, 'Govind', 113.141, 111111111.111111, '1915/12/25', '11:42:35', '1971/12/25 11:42:35'); +INSERT INTO t2 VALUES(2, 1978, 222222222, 'Gopal', 114.567, 222222222.222222, '1926/05/16', '12:32:14', '1972/05/16 12:32:14'); +INSERT INTO t2 VALUES(3, 2008, 333333333, 'kishor', 122.700, 333333333.333333, '1937/08/15', '13:45:36', '1973/08/15 13:45:36'); +INSERT INTO t2 VALUES(4, 1973, 444444444, 'kiran', 142.718, 444444444.444444, '1946/12/25', '14:42:35', '1974/12/25 14:42:35'); +INSERT INTO t2 VALUES(5, 2005, 555555555, 'ganesh', 152.718, 555555555.555555, '1955/12/25', '15:42:35', '1975/12/25 15:42:35'); +INSERT INTO t2 VALUES(6, 1962, 666666666, 'suresh', 162.718, 666666666.666666, '1965/12/25', '16:42:35', '1976/12/25 16:42:35'); +INSERT INTO t2 VALUES(7, 1965, 777777777, 'Praba', 172.718, 777777777.777777, '1975/12/25', '17:42:35', '1977/12/25 17:42:35'); +INSERT INTO t2 VALUES(8, 1942, 888888888, 'karan', 182.718, 888888888.888888, '1985/12/25', '18:42:35', '1978/12/25 18:42:35'); +INSERT INTO t2 VALUES(9, 1956, 999999999, 'sharan', 192.718, 999999999.999999, '1995/12/25', '19:42:35', '1979/12/25 19:42:35'); +INSERT INTO t2 VALUES(10, 1999,101010101, 'vijay', 102.718, 111111111.999999, '1915/12/25', '20:42:35', '1980/12/25 20:42:35'); diff --git a/test/cache/Gateway/selectstart2.sql b/test/cache/Gateway/selectstart2.sql new file mode 100644 index 00000000..68a32ae8 --- /dev/null +++ b/test/cache/Gateway/selectstart2.sql @@ -0,0 +1 @@ +select * from t2; diff --git a/test/cache/Gateway/selectstart3.sql b/test/cache/Gateway/selectstart3.sql new file mode 100644 index 00000000..2a820e8f --- /dev/null +++ b/test/cache/Gateway/selectstart3.sql @@ -0,0 +1 @@ +select * from t3; diff --git a/test/cache/Gateway/updatet2.sql b/test/cache/Gateway/updatet2.sql new file mode 100644 index 00000000..88005f1c --- /dev/null +++ b/test/cache/Gateway/updatet2.sql @@ -0,0 +1,7 @@ +update t2 set t2f2=1995, t2f9 = '1971/12/25 11:42:35' where t2f1 = 2; +update t2 set t2f3=333666999, t2f9 = '1973/08/15 13:45:36' where t2f1 = 3; +update t2 set t2f4='poonam', t2f9 = '1974/12/25 14:42:35' where t2f1 = 4; +update t2 set t2f7='1978/09/12', t2f9 = '1977/12/25 17:42:35' where t2f1 = 7; +update t2 set t2f8='12:34:56', t2f9 = '1978/12/25 18:42:35' where t2f1 =8; +update t2 set t2f9='1978/09/12 12:34:56', t2f9 = '1979/12/25 19:42:35' where t2f1 = 9; + diff --git a/test/cache/Gateway/updatet3.sql b/test/cache/Gateway/updatet3.sql new file mode 100644 index 00000000..0debd64b --- /dev/null +++ b/test/cache/Gateway/updatet3.sql @@ -0,0 +1,7 @@ +update t3 set t3f2=1995, t3f9 = '1971/12/25 11:42:35' where t3f1 = 2; +update t3 set t3f3=333666999, t3f9 = '1973/08/15 13:45:36' where t3f1 = 3; +update t3 set t3f4='poonam', t3f9 = '1974/12/25 14:42:35' where t3f1 = 4; +update t3 set t3f7='1978/09/12', t3f9 = '1977/12/25 17:42:35' where t3f1 = 7; +update t3 set t3f8='12:34:56', t3f9 = '1978/12/25 18:42:35' where t3f1 =8; +update t3 set t3f9='1978/09/12 12:34:56', t3f9 = '1979/12/25 19:42:35' where t3f1 = 9; + -- 2.11.4.GIT