adding test scripts
[csql.git] / test / cache / Gateway / exp.test003n.ksh
blob105e14060242c994d7c8b4cdb6daf5dc7c91ebff
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
15 +---------------------------------------+
16 | Connected! |
17 | |
18 | sql-statement |
19 | help [tablename] |
20 | quit |
21 | |
22 +---------------------------------------+
23 \e[?1034hSQL> select * from t1;
24 [ISQL]ERROR: Could not SQLExecute
25 SQL> ---------------------------------------------------------
26 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
27 ---------------------------------------------------------
28 1 2011 111111111 Govind 113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
29 5 2005 555555555 ganesh 152.718002 555555555.555555 1955/12/25 15:42:35.0 1975/12/25 15:42:35.0
30 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
31 15 1889 161616161 ethane 211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0
32 20 1994 666633333 vishnu 255.718002 333333333.666666 2030/12/25 6:42:35.0 2030/12/25 5:42:35.0
34 ---------------------------------------------------------
35 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
36 ---------------------------------------------------------
37 7 1965 777777777 Praba 172.718002 777777777.777777 1975/12/25 17:42:35.0 1977/12/25 17:42:35.0
38 8 1942 888888888 karan 182.718002 888888888.888888 1985/12/25 18:42:35.0 1978/12/25 18:42:35.0
39 9 1956 999999999 sharan 192.718002 999999999.999999 1995/12/25 19:42:35.0 1979/12/25 19:42:35.0
40 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
41 11 2010 121212121 Prasad 112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0
42 12 2069 131313131 jiten 122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0
43 13 1857 141414141 hiten 132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0
44 14 1545 151515151 methane 126.718002 444444444.555555 2045/12/25 0:42:35.0 2032/12/25 0:42:35.0
45 15 1889 161616161 ethane 211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0
47 ---------------------------------------------------------
48 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
49 ---------------------------------------------------------
50 1 2011 111111111 Govind 113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
51 4 1973 444444444 kiran 142.718002 444444444.444444 1946/12/25 14:42:35.0 1974/12/25 14:42:35.0
52 7 1965 777777777 Praba 172.718002 777777777.777777 1975/12/25 17:42:35.0 1977/12/25 17:42:35.0
53 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
54 13 1857 141414141 hiten 132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0
55 16 1789 171717171 sanjay 222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0
56 19 2048 777755555 Sushant 277.717987 333333333.999999 2023/12/25 5:42:35.0 2011/12/25 4:42:35.0
58 ---------------------------------------------------------
59 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
60 ---------------------------------------------------------
61 1 2011 111111111 Govind 113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
62 2 1995 222222222 Gopal 114.567001 222222222.222222 1926/5/16 12:32:14.0 1971/12/25 11:42:35.0
63 3 2008 333666999 kishor 122.699997 333333333.333333 1937/8/15 13:45:36.0 1973/8/15 13:45:36.0
64 4 1973 444444444 poonam 142.718002 444444444.444444 1946/12/25 14:42:35.0 1974/12/25 14:42:35.0
65 5 2005 555555555 ganesh 152.718002 555555555.555555 1955/12/25 15:42:35.0 1975/12/25 15:42:35.0
66 6 1962 666666666 suresh 162.718002 666666666.666666 1965/12/25 16:42:35.0 1976/12/25 16:42:35.0
67 7 1965 777777777 Praba 172.718002 777777777.777777 1978/9/12 17:42:35.0 1977/12/25 17:42:35.0
68 8 1942 888888888 karan 182.718002 888888888.888888 1985/12/25 12:34:56.0 1978/12/25 18:42:35.0
69 9 1956 999999999 sharan 192.718002 999999999.999999 1995/12/25 19:42:35.0 1979/12/25 19:42:35.0
70 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
71 11 2010 121212121 Prasad 112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0
72 12 2069 131313131 jiten 122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0
73 16 1789 171717171 sanjay 222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0
74 17 2032 181818181 vikrant 233.718002 777777777.888888 2020/12/25 3:42:35.0 2020/12/25 3:42:35.0
76 +---------------------------------------+
77 | Connected! |
78 | |
79 | sql-statement |
80 | help [tablename] |
81 | quit |
82 | |
83 +---------------------------------------+
84 \e[?1034hSQL> select * from t1;
85 [ISQL]ERROR: Could not SQLExecute
86 SQL>