test/cache/Gateway/exp.test010n.ksh

   1 +---------------------------------------+
   2 | Connected!                            |
   3 |                                       |
   4 | sql-statement                         |
   5 | help [tablename]                      |
   6 | quit                                  |
   7 |                                       |
   8 +---------------------------------------+
   9 \e[?1034hSQL> select * from t1;
  10 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  11 | f1   | f2        | f3                  | f4        | f5            | f6                      | f7        | f8      | f9                 |
  12 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  13 | 1    | 2011      | 111111111           | Govind    | 113.141       | 111111111.111111        | 1915-12-25| 11:42:35| 1971-12-25 11:42:35|
  14 | 2    | 1978      | 222222222           | Gopal     | 114.567       | 222222222.222222        | 1926-05-16| 12:32:14| 1972-05-16 12:32:14|
  15 | 3    | 2008      | 333333333           | kishor    | 122.7         | 333333333.333333        | 1937-08-15| 13:45:36| 1973-08-15 13:45:36|
  16 | 4    | 1973      | 444444444           | kiran     | 142.718       | 444444444.444444        | 1946-12-25| 14:42:35| 1974-12-25 14:42:35|
  17 | 5    | 2005      | 555555555           | ganesh    | 152.718       | 555555555.555555        | 1955-12-25| 15:42:35| 1975-12-25 15:42:35|
  18 | 6    | 1962      | 666666666           | suresh    | 162.718       | 666666666.666666        | 1965-12-25| 16:42:35| 1976-12-25 16:42:35|
  19 | 7    | 1965      | 777777777           | Praba     | 172.718       | 777777777.777777        | 1975-12-25| 17:42:35| 1977-12-25 17:42:35|
  20 | 8    | 1942      | 888888888           | karan     | 182.718       | 888888888.888888        | 1985-12-25| 18:42:35| 1978-12-25 18:42:35|
  21 | 9    | 1956      | 999999999           | sharan    | 192.718       | 999999999.999999        | 1995-12-25| 19:42:35| 1979-12-25 19:42:35|
  22 | 10   | 1999      | 101010101           | vijay     | 102.718       | 111111111.999999        | 1915-12-25| 20:42:35| 1980-12-25 20:42:35|
  23 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  24 SQLRowCount returns 10
  25 10 rows fetched
  26 SQL> ---------------------------------------------------------
  27         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
  28 ---------------------------------------------------------
  29         11      2010    121212121       Prasad  112.718002      111111111.222222        2005/12/25      21:42:35.0      2005/12/25 21:42:35.0
  30         12      2069    131313131       jiten   122.718002      222222222.333333        2025/12/25      22:42:35.0      2025/12/25 22:42:35.0
  31         13      1857    141414141       hiten   132.718002      333333333.444444        2035/12/25      23:42:35.0      2035/12/25 23:42:35.0
  32         14      1545    151515151       methane 126.718002      444444444.555555        2045/12/25      0:42:35.0       2032/12/25 0:42:35.0
  33         15      1889    161616161       ethane  211.718002      555555555.222222        2065/12/25      1:42:35.0       2005/12/25 1:42:35.0
  34         16      1789    171717171       sanjay  222.718002      666666666.777777        2010/12/25      2:42:35.0       2010/12/25 2:42:35.0
  35         17      2032    181818181       vikrant 233.718002      777777777.888888        2020/12/25      3:42:35.0       2020/12/25 3:42:35.0
  36         18      2038    444455555       nishant 244.718002      888888888.999999        2040/12/25      4:42:35.0       2031/12/25 4:42:35.0
  37         19      2048    777755555       Sushant 277.717987      333333333.999999        2023/12/25      5:42:35.0       2011/12/25 4:42:35.0
  38         20      1994    666633333       vishnu  255.718002      333333333.666666        2030/12/25      6:42:35.0       2030/12/25 5:42:35.0
  39
  40 Statement Executed: Rows Affected = 1
  41 +---------------------------------------+
  42 | Connected!                            |
  43 |                                       |
  44 | sql-statement                         |
  45 | help [tablename]                      |
  46 | quit                                  |
  47 |                                       |
  48 +---------------------------------------+
  49 \e[?1034hSQL> select * from t1;
  50 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  51 | f1   | f2        | f3                  | f4        | f5            | f6                      | f7        | f8      | f9                 |
  52 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  53 | 1    | 2011      | 111111111           | Govind    | 113.141       | 111111111.111111        | 1915-12-25| 11:42:35| 1971-12-25 11:42:35|
  54 | 2    | 1978      | 222222222           | Gopal     | 114.567       | 222222222.222222        | 1926-05-16| 12:32:14| 1972-05-16 12:32:14|
  55 | 3    | 2008      | 333333333           | kishor    | 122.7         | 333333333.333333        | 1937-08-15| 13:45:36| 1973-08-15 13:45:36|
  56 | 4    | 1973      | 444444444           | kiran     | 142.718       | 444444444.444444        | 1946-12-25| 14:42:35| 1974-12-25 14:42:35|
  57 | 5    | 2005      | 555555555           | ganesh    | 152.718       | 555555555.555555        | 1955-12-25| 15:42:35| 1975-12-25 15:42:35|
  58 | 6    | 1962      | 666666666           | suresh    | 162.718       | 666666666.666666        | 1965-12-25| 16:42:35| 1976-12-25 16:42:35|
  59 | 7    | 1965      | 777777777           | Praba     | 172.718       | 777777777.777777        | 1975-12-25| 17:42:35| 1977-12-25 17:42:35|
  60 | 8    | 1942      | 888888888           | karan     | 182.718       | 888888888.888888        | 1985-12-25| 18:42:35| 1978-12-25 18:42:35|
  61 | 9    | 1956      | 999999999           | sharan    | 192.718       | 999999999.999999        | 1995-12-25| 19:42:35| 1979-12-25 19:42:35|
  62 | 10   | 1999      | 101010101           | vijay     | 102.718       | 111111111.999999        | 1915-12-25| 20:42:35| 1980-12-25 20:42:35|
  63 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  64 SQLRowCount returns 10
  65 10 rows fetched
  66 SQL> ---------------------------------------------------------
  67         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
  68 ---------------------------------------------------------
  69         11      2010    121212121       Prasad  112.718002      111111111.222222        2005/12/25      21:42:35.0      2005/12/25 21:42:35.0
  70         12      2069    131313131       jiten   122.718002      222222222.333333        2025/12/25      22:42:35.0      2025/12/25 22:42:35.0
  71         13      1857    141414141       hiten   132.718002      333333333.444444        2035/12/25      23:42:35.0      2035/12/25 23:42:35.0
  72         14      1545    151515151       methane 126.718002      444444444.555555        2045/12/25      0:42:35.0       2032/12/25 0:42:35.0
  73         15      1889    161616161       ethane  211.718002      555555555.222222        2065/12/25      1:42:35.0       2005/12/25 1:42:35.0
  74         16      1789    171717171       sanjay  222.718002      666666666.777777        2010/12/25      2:42:35.0       2010/12/25 2:42:35.0
  75         17      2032    181818181       vikrant 233.718002      777777777.888888        2020/12/25      3:42:35.0       2020/12/25 3:42:35.0
  76         18      2038    444455555       nishant 244.718002      888888888.999999        2040/12/25      4:42:35.0       2031/12/25 4:42:35.0
  77         19      2048    777755555       Sushant 277.717987      333333333.999999        2023/12/25      5:42:35.0       2011/12/25 4:42:35.0
  78         20      1994    666633333       vishnu  255.718002      333333333.666666        2030/12/25      6:42:35.0       2030/12/25 5:42:35.0
  79         21      33      4234    mohan   34.340000       345.543000      1999/2/23       11:22:33.0      1999/2/23 11:22:33.0
  80