adding test scripts
[csql.git] / test / cache / Gateway / exp.test001.ksh.psql
bloba9b68178e1fed356e1a005c5ab6a0c11b925e0e8
1 ---------------------------------------------------------
2         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   
3 ---------------------------------------------------------
4         1       2011    111111111       Govind  113.140999      111111111.111111        1915/12/25      11:42:35.0      1971/12/25 11:42:35.0   
5         2       1978    222222222       Gopal   114.567001      222222222.222222        1926/5/16       12:32:14.0      1972/5/16 12:32:14.0    
6         3       2008    333333333       kishor  122.699997      333333333.333333        1937/8/15       13:45:36.0      1973/8/15 13:45:36.0    
7         4       1973    444444444       kiran   142.718002      444444444.444444        1946/12/25      14:42:35.0      1974/12/25 14:42:35.0   
8         5       2005    555555555       ganesh  152.718002      555555555.555555        1955/12/25      15:42:35.0      1975/12/25 15:42:35.0   
9         6       1962    666666666       suresh  162.718002      666666666.666666        1965/12/25      16:42:35.0      1976/12/25 16:42:35.0   
10         7       1965    777777777       Praba   172.718002      777777777.777777        1975/12/25      17:42:35.0      1977/12/25 17:42:35.0   
11         8       1942    888888888       karan   182.718002      888888888.888888        1985/12/25      18:42:35.0      1978/12/25 18:42:35.0   
12         9       1956    999999999       sharan  192.718002      999999999.999999        1995/12/25      19:42:35.0      1979/12/25 19:42:35.0   
13         10      1999    101010101       vijay   102.718002      111111111.999999        1915/12/25      20:42:35.0      1980/12/25 20:42:35.0   
14         11      2010    121212121       Prasad  112.718002      111111111.222222        2005/12/25      21:42:35.0      2005/12/25 21:42:35.0   
15         12      2069    131313131       jiten   122.718002      222222222.333333        2025/12/25      22:42:35.0      2025/12/25 22:42:35.0   
16         13      1857    141414141       hiten   132.718002      333333333.444444        2035/12/25      23:42:35.0      2035/12/25 23:42:35.0   
17         14      1545    151515151       methane 126.718002      444444444.555555        2045/12/25      0:42:35.0       2032/12/25 0:42:35.0    
18         15      1889    161616161       ethane  211.718002      555555555.222222        2065/12/25      1:42:35.0       2005/12/25 1:42:35.0    
19         16      1789    171717171       sanjay  222.718002      666666666.777777        2010/12/25      2:42:35.0       2010/12/25 2:42:35.0    
20         17      2032    181818181       vikrant 233.718002      777777777.888888        2020/12/25      3:42:35.0       2020/12/25 3:42:35.0    
21         18      2038    444455555       nishant 244.718002      888888888.999999        2040/12/25      4:42:35.0       2031/12/25 4:42:35.0    
22         19      2048    777755555       Sushant 277.717987      333333333.999999        2023/12/25      5:42:35.0       2011/12/25 4:42:35.0    
23         20      1994    666633333       vishnu  255.718002      333333333.666666        2030/12/25      6:42:35.0       2030/12/25 5:42:35.0    
24         
25 +---------------------------------------+
26 | Connected!                            |
27 |                                       |
28 | sql-statement                         |
29 | help [tablename]                      |
30 | quit                                  |
31 |                                       |
32 +---------------------------------------+
33 \e[?1034hSQL> select * from t1;
34 +-------+------------+---------------------+-----------+--------------+-----------------------+-----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
35 | f1    | f2         | f3                  | f4        | f5           | f6                    | f7        | f8      | f9                                                                                                                                                                                                                                                            |
36 +-------+------------+---------------------+-----------+--------------+-----------------------+-----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
37 | 1     | 2011       | 111111111           | Govind    | 113.141      | 111111111.111111      | 1915-12-25| 11:42:35| 1971-12-25 11:42:35                                                                                                                                                                                                                                           |
38 | 2     | 1978       | 222222222           | Gopal     | 114.567      | 222222222.222222      | 1926-05-16| 12:32:14| 1972-05-16 12:32:14                                                                                                                                                                                                                                           |
39 | 3     | 2008       | 333333333           | kishor    | 122.7        | 333333333.333333      | 1937-08-15| 13:45:36| 1973-08-15 13:45:36                                                                                                                                                                                                                                           |
40 | 4     | 1973       | 444444444           | kiran     | 142.718      | 444444444.444444      | 1946-12-25| 14:42:35| 1974-12-25 14:42:35                                                                                                                                                                                                                                           |
41 | 5     | 2005       | 555555555           | ganesh    | 152.718      | 555555555.555555      | 1955-12-25| 15:42:35| 1975-12-25 15:42:35                                                                                                                                                                                                                                           |
42 | 6     | 1962       | 666666666           | suresh    | 162.718      | 666666666.666666      | 1965-12-25| 16:42:35| 1976-12-25 16:42:35                                                                                                                                                                                                                                           |
43 | 7     | 1965       | 777777777           | Praba     | 172.718      | 777777777.777777      | 1975-12-25| 17:42:35| 1977-12-25 17:42:35                                                                                                                                                                                                                                           |
44 | 8     | 1942       | 888888888           | karan     | 182.718      | 888888888.888888      | 1985-12-25| 18:42:35| 1978-12-25 18:42:35                                                                                                                                                                                                                                           |
45 | 9     | 1956       | 999999999           | sharan    | 192.718      | 999999999.999999      | 1995-12-25| 19:42:35| 1979-12-25 19:42:35                                                                                                                                                                                                                                           |
46 | 10    | 1999       | 101010101           | vijay     | 102.718      | 111111111.999999      | 1915-12-25| 20:42:35| 1980-12-25 20:42:35                                                                                                                                                                                                                                           |
47 | 11    | 2010       | 121212121           | Prasad    | 112.718      | 111111111.222222      | 2005-12-25| 21:42:35| 2005-12-25 21:42:35                                                                                                                                                                                                                                           |
48 | 12    | 2069       | 131313131           | jiten     | 122.718      | 222222222.333333      | 2025-12-25| 22:42:35| 2025-12-25 22:42:35                                                                                                                                                                                                                                           |
49 | 13    | 1857       | 141414141           | hiten     | 132.718      | 333333333.444444      | 2035-12-25| 23:42:35| 2035-12-25 23:42:35                                                                                                                                                                                                                                           |
50 | 14    | 1545       | 151515151           | methane   | 126.718      | 444444444.555555      | 2045-12-25| 00:42:35| 2032-12-25 00:42:35                                                                                                                                                                                                                                           |
51 | 15    | 1889       | 161616161           | ethane    | 211.718      | 555555555.222222      | 2065-12-25| 01:42:35| 2005-12-25 01:42:35                                                                                                                                                                                                                                           |
52 | 16    | 1789       | 171717171           | sanjay    | 222.718      | 666666666.777777      | 2010-12-25| 02:42:35| 2010-12-25 02:42:35                                                                                                                                                                                                                                           |
53 | 17    | 2032       | 181818181           | vikrant   | 233.718      | 777777777.888888      | 2020-12-25| 03:42:35| 2020-12-25 03:42:35                                                                                                                                                                                                                                           |
54 | 18    | 2038       | 444455555           | nishant   | 244.718      | 888888888.999999      | 2040-12-25| 04:42:35| 2031-12-25 04:42:35                                                                                                                                                                                                                                           |
55 | 19    | 2048       | 777755555           | Sushant   | 277.718      | 333333333.999999      | 2023-12-25| 05:42:35| 2011-12-25 04:42:35                                                                                                                                                                                                                                           |
56 | 20    | 1994       | 666633333           | vishnu    | 255.718      | 333333333.666666      | 2030-12-25| 06:42:35| 2030-12-25 05:42:35                                                                                                                                                                                                                                           |
57 +-------+------------+---------------------+-----------+--------------+-----------------------+-----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
58 SQLRowCount returns 20
59 20 rows fetched
60 SQL> ---------------------------------------------------------
61         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   
62 ---------------------------------------------------------
63         1       2011    111111111       Govind  113.140999      111111111.111111        1915/12/25      11:42:35.0      1971/12/25 11:42:35.0   
64         5       2005    555555555       ganesh  152.718002      555555555.555555        1955/12/25      15:42:35.0      1975/12/25 15:42:35.0   
65         10      1999    101010101       vijay   102.718002      111111111.999999        1915/12/25      20:42:35.0      1980/12/25 20:42:35.0   
66         15      1889    161616161       ethane  211.718002      555555555.222222        2065/12/25      1:42:35.0       2005/12/25 1:42:35.0    
67         20      1994    666633333       vishnu  255.718002      333333333.666666        2030/12/25      6:42:35.0       2030/12/25 5:42:35.0    
68         
69 ---------------------------------------------------------
70         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   
71 ---------------------------------------------------------
72         7       1965    777777777       Praba   172.718002      777777777.777777        1975/12/25      17:42:35.0      1977/12/25 17:42:35.0   
73         8       1942    888888888       karan   182.718002      888888888.888888        1985/12/25      18:42:35.0      1978/12/25 18:42:35.0   
74         9       1956    999999999       sharan  192.718002      999999999.999999        1995/12/25      19:42:35.0      1979/12/25 19:42:35.0   
75         10      1999    101010101       vijay   102.718002      111111111.999999        1915/12/25      20:42:35.0      1980/12/25 20:42:35.0   
76         11      2010    121212121       Prasad  112.718002      111111111.222222        2005/12/25      21:42:35.0      2005/12/25 21:42:35.0   
77         12      2069    131313131       jiten   122.718002      222222222.333333        2025/12/25      22:42:35.0      2025/12/25 22:42:35.0   
78         13      1857    141414141       hiten   132.718002      333333333.444444        2035/12/25      23:42:35.0      2035/12/25 23:42:35.0   
79         14      1545    151515151       methane 126.718002      444444444.555555        2045/12/25      0:42:35.0       2032/12/25 0:42:35.0    
80         15      1889    161616161       ethane  211.718002      555555555.222222        2065/12/25      1:42:35.0       2005/12/25 1:42:35.0    
81         
82 ---------------------------------------------------------
83         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   
84 ---------------------------------------------------------
85         1       2011    111111111       Govind  113.140999      111111111.111111        1915/12/25      11:42:35.0      1971/12/25 11:42:35.0   
86         4       1973    444444444       kiran   142.718002      444444444.444444        1946/12/25      14:42:35.0      1974/12/25 14:42:35.0   
87         7       1965    777777777       Praba   172.718002      777777777.777777        1975/12/25      17:42:35.0      1977/12/25 17:42:35.0   
88         10      1999    101010101       vijay   102.718002      111111111.999999        1915/12/25      20:42:35.0      1980/12/25 20:42:35.0   
89         13      1857    141414141       hiten   132.718002      333333333.444444        2035/12/25      23:42:35.0      2035/12/25 23:42:35.0   
90         16      1789    171717171       sanjay  222.718002      666666666.777777        2010/12/25      2:42:35.0       2010/12/25 2:42:35.0    
91         19      2048    777755555       Sushant 277.717987      333333333.999999        2023/12/25      5:42:35.0       2011/12/25 4:42:35.0    
92         
93 ---------------------------------------------------------
94         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   
95 ---------------------------------------------------------
96         1       2011    111111111       Govind  113.140999      111111111.111111        1915/12/25      11:42:35.0      1971/12/25 11:42:35.0   
97         2       1995    222222222       Gopal   114.567001      222222222.222222        1926/5/16       12:32:14.0      1971/12/25 11:42:35.0   
98         3       2008    333666999       kishor  122.699997      333333333.333333        1937/8/15       13:45:36.0      1973/8/15 13:45:36.0    
99         4       1973    444444444       poonam  142.718002      444444444.444444        1946/12/25      14:42:35.0      1974/12/25 14:42:35.0   
100         5       2005    555555555       ganesh  152.718002      555555555.555555        1955/12/25      15:42:35.0      1975/12/25 15:42:35.0   
101         6       1962    666666666       suresh  162.718002      666666666.666666        1965/12/25      16:42:35.0      1976/12/25 16:42:35.0   
102         7       1965    777777777       Praba   172.718002      777777777.777777        1978/9/12       17:42:35.0      1977/12/25 17:42:35.0   
103         8       1942    888888888       karan   182.718002      888888888.888888        1985/12/25      12:34:56.0      1978/12/25 18:42:35.0   
104         9       1956    999999999       sharan  192.718002      999999999.999999        1995/12/25      19:42:35.0      1979/12/25 19:42:35.0   
105         10      1999    101010101       vijay   102.718002      111111111.999999        1915/12/25      20:42:35.0      1980/12/25 20:42:35.0   
106         11      2010    121212121       Prasad  112.718002      111111111.222222        2005/12/25      21:42:35.0      2005/12/25 21:42:35.0   
107         12      2069    131313131       jiten   122.718002      222222222.333333        2025/12/25      22:42:35.0      2025/12/25 22:42:35.0   
108         16      1789    171717171       sanjay  222.718002      666666666.777777        2010/12/25      2:42:35.0       2010/12/25 2:42:35.0    
109         17      2032    181818181       vikrant 233.718002      777777777.888888        2020/12/25      3:42:35.0       2020/12/25 3:42:35.0    
110         
111 +---------------------------------------+
112 | Connected!                            |
113 |                                       |
114 | sql-statement                         |
115 | help [tablename]                      |
116 | quit                                  |
117 |                                       |
118 +---------------------------------------+
119 \e[?1034hSQL> select * from t1;
120 +-------+------------+---------------------+-----------+--------------+-----------------------+-----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
121 | f1    | f2         | f3                  | f4        | f5           | f6                    | f7        | f8      | f9                                                                                                                                                                                                                                                            |
122 +-------+------------+---------------------+-----------+--------------+-----------------------+-----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
123 | 1     | 2011       | 111111111           | Govind    | 113.141      | 111111111.111111      | 1915-12-25| 11:42:35| 1971-12-25 11:42:35                                                                                                                                                                                                                                           |
124 | 5     | 2005       | 555555555           | ganesh    | 152.718      | 555555555.555555      | 1955-12-25| 15:42:35| 1975-12-25 15:42:35                                                                                                                                                                                                                                           |
125 | 6     | 1962       | 666666666           | suresh    | 162.718      | 666666666.666666      | 1965-12-25| 16:42:35| 1976-12-25 16:42:35                                                                                                                                                                                                                                           |
126 | 9     | 1956       | 999999999           | sharan    | 192.718      | 999999999.999999      | 1995-12-25| 19:42:35| 1979-12-25 19:42:35                                                                                                                                                                                                                                           |
127 | 10    | 1999       | 101010101           | vijay     | 102.718      | 111111111.999999      | 1915-12-25| 20:42:35| 1980-12-25 20:42:35                                                                                                                                                                                                                                           |
128 | 11    | 2010       | 121212121           | Prasad    | 112.718      | 111111111.222222      | 2005-12-25| 21:42:35| 2005-12-25 21:42:35                                                                                                                                                                                                                                           |
129 | 12    | 2069       | 131313131           | jiten     | 122.718      | 222222222.333333      | 2025-12-25| 22:42:35| 2025-12-25 22:42:35                                                                                                                                                                                                                                           |
130 | 16    | 1789       | 171717171           | sanjay    | 222.718      | 666666666.777777      | 2010-12-25| 02:42:35| 2010-12-25 02:42:35                                                                                                                                                                                                                                           |
131 | 17    | 2032       | 181818181           | vikrant   | 233.718      | 777777777.888888      | 2020-12-25| 03:42:35| 2020-12-25 03:42:35                                                                                                                                                                                                                                           |
132 | 2     | 1995       | 222222222           | Gopal     | 114.567      | 222222222.222222      | 1926-05-16| 12:32:14| 1971-12-25 11:42:35                                                                                                                                                                                                                                           |
133 | 3     | 2008       | 333666999           | kishor    | 122.7        | 333333333.333333      | 1937-08-15| 13:45:36| 1973-08-15 13:45:36                                                                                                                                                                                                                                           |
134 | 4     | 1973       | 444444444           | poonam    | 142.718      | 444444444.444444      | 1946-12-25| 14:42:35| 1974-12-25 14:42:35                                                                                                                                                                                                                                           |
135 | 7     | 1965       | 777777777           | Praba     | 172.718      | 777777777.777777      | 1978-09-12| 17:42:35| 1977-12-25 17:42:35                                                                                                                                                                                                                                           |
136 | 8     | 1942       | 888888888           | karan     | 182.718      | 888888888.888888      | 1985-12-25| 12:34:56| 1978-12-25 18:42:35                                                                                                                                                                                                                                           |
137 +-------+------------+---------------------+-----------+--------------+-----------------------+-----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
138 SQLRowCount returns 14
139 14 rows fetched
140 SQL>