From 55989984f1b4f2dfbbaf01990b974ebd75c17b81 Mon Sep 17 00:00:00 2001 From: kishoramballi Date: Mon, 30 Jun 2008 14:33:25 +0000 Subject: [PATCH] expected output files --- test/cache/Gateway/exp.test010.ksh | 80 ++++++++++++++++++++++++++++++++++++++ test/cache/Gateway/exp.test011.ksh | 39 +++++++++++++++++++ 2 files changed, 119 insertions(+) create mode 100644 test/cache/Gateway/exp.test010.ksh create mode 100644 test/cache/Gateway/exp.test011.ksh diff --git a/test/cache/Gateway/exp.test010.ksh b/test/cache/Gateway/exp.test010.ksh new file mode 100644 index 00000000..57558c95 --- /dev/null +++ b/test/cache/Gateway/exp.test010.ksh @@ -0,0 +1,80 @@ ++---------------------------------------+ +| Connected! | +| | +| sql-statement | +| help [tablename] | +| quit | +| | ++---------------------------------------+ +[?1034hSQL> select * from t1; ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +| f1 | f2 | f3 | f4 | f5 | f6 | f7 | f8 | f9 | ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +| 1 | 2011 | 111111111 | Govind | 113.141 | 111111111.111111 | 1915-12-25| 11:42:35| 1971-12-25 11:42:35| +| 2 | 1978 | 222222222 | Gopal | 114.567 | 222222222.222222 | 1926-05-16| 12:32:14| 1972-05-16 12:32:14| +| 3 | 2008 | 333333333 | kishor | 122.7 | 333333333.333333 | 1937-08-15| 13:45:36| 1973-08-15 13:45:36| +| 4 | 1973 | 444444444 | kiran | 142.718 | 444444444.444444 | 1946-12-25| 14:42:35| 1974-12-25 14:42:35| +| 5 | 2005 | 555555555 | ganesh | 152.718 | 555555555.555555 | 1955-12-25| 15:42:35| 1975-12-25 15:42:35| +| 6 | 1962 | 666666666 | suresh | 162.718 | 666666666.666666 | 1965-12-25| 16:42:35| 1976-12-25 16:42:35| +| 7 | 1965 | 777777777 | Praba | 172.718 | 777777777.777777 | 1975-12-25| 17:42:35| 1977-12-25 17:42:35| +| 8 | 1942 | 888888888 | karan | 182.718 | 888888888.888888 | 1985-12-25| 18:42:35| 1978-12-25 18:42:35| +| 9 | 1956 | 999999999 | sharan | 192.718 | 999999999.999999 | 1995-12-25| 19:42:35| 1979-12-25 19:42:35| +| 10 | 1999 | 101010101 | vijay | 102.718 | 111111111.999999 | 1915-12-25| 20:42:35| 1980-12-25 20:42:35| ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +SQLRowCount returns 10 +10 rows fetched +SQL> --------------------------------------------------------- + f1 f2 f3 f4 f5 f6 f7 f8 f9 +--------------------------------------------------------- + 11 2010 121212121 Prasad 112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0 + 12 2069 131313131 jiten 122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0 + 13 1857 141414141 hiten 132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0 + 14 1545 151515151 methane 126.718002 444444444.555555 2045/12/25 0:42:35.0 2032/12/25 0:42:35.0 + 15 1889 161616161 ethane 211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0 + 16 1789 171717171 sanjay 222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0 + 17 2032 181818181 vikrant 233.718002 777777777.888888 2020/12/25 3:42:35.0 2020/12/25 3:42:35.0 + 18 2038 444455555 nishant 244.718002 888888888.999999 2040/12/25 4:42:35.0 2031/12/25 4:42:35.0 + 19 2048 777755555 Sushant 277.717987 333333333.999999 2023/12/25 5:42:35.0 2011/12/25 4:42:35.0 + 20 1994 666633333 vishnu 255.718002 333333333.666666 2030/12/25 6:42:35.0 2030/12/25 5:42:35.0 + +Statement Executed: Rows Affected = 1 ++---------------------------------------+ +| Connected! | +| | +| sql-statement | +| help [tablename] | +| quit | +| | ++---------------------------------------+ +[?1034hSQL> select * from t1; ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +| f1 | f2 | f3 | f4 | f5 | f6 | f7 | f8 | f9 | ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +| 1 | 2011 | 111111111 | Govind | 113.141 | 111111111.111111 | 1915-12-25| 11:42:35| 1971-12-25 11:42:35| +| 2 | 1978 | 222222222 | Gopal | 114.567 | 222222222.222222 | 1926-05-16| 12:32:14| 1972-05-16 12:32:14| +| 3 | 2008 | 333333333 | kishor | 122.7 | 333333333.333333 | 1937-08-15| 13:45:36| 1973-08-15 13:45:36| +| 4 | 1973 | 444444444 | kiran | 142.718 | 444444444.444444 | 1946-12-25| 14:42:35| 1974-12-25 14:42:35| +| 5 | 2005 | 555555555 | ganesh | 152.718 | 555555555.555555 | 1955-12-25| 15:42:35| 1975-12-25 15:42:35| +| 6 | 1962 | 666666666 | suresh | 162.718 | 666666666.666666 | 1965-12-25| 16:42:35| 1976-12-25 16:42:35| +| 7 | 1965 | 777777777 | Praba | 172.718 | 777777777.777777 | 1975-12-25| 17:42:35| 1977-12-25 17:42:35| +| 8 | 1942 | 888888888 | karan | 182.718 | 888888888.888888 | 1985-12-25| 18:42:35| 1978-12-25 18:42:35| +| 9 | 1956 | 999999999 | sharan | 192.718 | 999999999.999999 | 1995-12-25| 19:42:35| 1979-12-25 19:42:35| +| 10 | 1999 | 101010101 | vijay | 102.718 | 111111111.999999 | 1915-12-25| 20:42:35| 1980-12-25 20:42:35| ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +SQLRowCount returns 10 +10 rows fetched +SQL> --------------------------------------------------------- + f1 f2 f3 f4 f5 f6 f7 f8 f9 +--------------------------------------------------------- + 11 2010 121212121 Prasad 112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0 + 12 2069 131313131 jiten 122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0 + 13 1857 141414141 hiten 132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0 + 14 1545 151515151 methane 126.718002 444444444.555555 2045/12/25 0:42:35.0 2032/12/25 0:42:35.0 + 15 1889 161616161 ethane 211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0 + 16 1789 171717171 sanjay 222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0 + 17 2032 181818181 vikrant 233.718002 777777777.888888 2020/12/25 3:42:35.0 2020/12/25 3:42:35.0 + 18 2038 444455555 nishant 244.718002 888888888.999999 2040/12/25 4:42:35.0 2031/12/25 4:42:35.0 + 19 2048 777755555 Sushant 277.717987 333333333.999999 2023/12/25 5:42:35.0 2011/12/25 4:42:35.0 + 20 1994 666633333 vishnu 255.718002 333333333.666666 2030/12/25 6:42:35.0 2030/12/25 5:42:35.0 + 21 33 4234 mohan 34.340000 345.543000 1999/2/23 11:22:33.0 1999/2/23 11:22:33.0 + diff --git a/test/cache/Gateway/exp.test011.ksh b/test/cache/Gateway/exp.test011.ksh new file mode 100644 index 00000000..6a86c278 --- /dev/null +++ b/test/cache/Gateway/exp.test011.ksh @@ -0,0 +1,39 @@ ++---------------------------------------+ +| Connected! | +| | +| sql-statement | +| help [tablename] | +| quit | +| | ++---------------------------------------+ +[?1034hSQL> select * from t1; ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +| f1 | f2 | f3 | f4 | f5 | f6 | f7 | f8 | f9 | ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +| 1 | 2011 | 111111111 | Govind | 113.141 | 111111111.111111 | 1915-12-25| 11:42:35| 1971-12-25 11:42:35| +| 2 | 1978 | 222222222 | Gopal | 114.567 | 222222222.222222 | 1926-05-16| 12:32:14| 1972-05-16 12:32:14| +| 3 | 2008 | 333333333 | kishor | 122.7 | 333333333.333333 | 1937-08-15| 13:45:36| 1973-08-15 13:45:36| +| 4 | 1973 | 444444444 | kiran | 142.718 | 444444444.444444 | 1946-12-25| 14:42:35| 1974-12-25 14:42:35| +| 5 | 2005 | 555555555 | ganesh | 152.718 | 555555555.555555 | 1955-12-25| 15:42:35| 1975-12-25 15:42:35| +| 6 | 1962 | 666666666 | suresh | 162.718 | 666666666.666666 | 1965-12-25| 16:42:35| 1976-12-25 16:42:35| +| 7 | 1965 | 777777777 | Praba | 172.718 | 777777777.777777 | 1975-12-25| 17:42:35| 1977-12-25 17:42:35| +| 8 | 1942 | 888888888 | karan | 182.718 | 888888888.888888 | 1985-12-25| 18:42:35| 1978-12-25 18:42:35| +| 9 | 1956 | 999999999 | sharan | 192.718 | 999999999.999999 | 1995-12-25| 19:42:35| 1979-12-25 19:42:35| +| 10 | 1999 | 101010101 | vijay | 102.718 | 111111111.999999 | 1915-12-25| 20:42:35| 1980-12-25 20:42:35| ++------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+ +SQLRowCount returns 10 +10 rows fetched +SQL> --------------------------------------------------------- + f1 f2 f3 f4 f5 f6 f7 f8 f9 +--------------------------------------------------------- + 11 2010 121212121 Prasad 112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0 + 12 2069 131313131 jiten 122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0 + 13 1857 141414141 hiten 132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0 + 14 1545 151515151 methane 126.718002 444444444.555555 2045/12/25 0:42:35.0 2032/12/25 0:42:35.0 + 15 1889 161616161 ethane 211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0 + 16 1789 171717171 sanjay 222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0 + 17 2032 181818181 vikrant 233.718002 777777777.888888 2020/12/25 3:42:35.0 2020/12/25 3:42:35.0 + 18 2038 444455555 nishant 244.718002 888888888.999999 2040/12/25 4:42:35.0 2031/12/25 4:42:35.0 + 19 2048 777755555 Sushant 277.717987 333333333.999999 2023/12/25 5:42:35.0 2011/12/25 4:42:35.0 + 20 1994 666633333 vishnu 255.718002 333333333.666666 2030/12/25 6:42:35.0 2030/12/25 5:42:35.0 + -- 2.11.4.GIT