*** empty log message ***
[csql.git] / test / tools / csql / exp.testnw016.ksh
blob25998cda64e17568b525c3939ed46c24dc2317b1
1 Network CSql
2 echo LIKE operator char datatype testing;
3 Statement Executed
4 Statement Executed: Rows Affected = 1
5 Statement Executed: Rows Affected = 1
6 Statement Executed: Rows Affected = 1
7 Statement Executed: Rows Affected = 1
8 Statement Executed: Rows Affected = 1
9 Statement Executed: Rows Affected = 1
10 Statement Executed: Rows Affected = 1
11 Statement Executed: Rows Affected = 1
12 Statement Executed: Rows Affected = 1
13 Statement Executed: Rows Affected = 1
14 Statement Executed: Rows Affected = 1
15 echo select * from t1;
16 ---------------------------------------------------------
17 t1.f1 t1.f2
18 ---------------------------------------------------------
19 10 A
20 11 B
21 12 C
22 13 D
23 14 14
24 50 E
25 This is really a ve E
26 UPPERCASE UPPER
27 uppercase LOWER
28 upperletter LOWER
29 uppercaseletter LOWER
31 echo select * from t1 where f1 LIKE 'UPP%';
32 ---------------------------------------------------------
33 t1.f1 t1.f2
34 ---------------------------------------------------------
35 UPPERCASE UPPER
37 echo select * from t1 where f1 LIKE 'upp%';
38 ---------------------------------------------------------
39 t1.f1 t1.f2
40 ---------------------------------------------------------
41 uppercase LOWER
42 upperletter LOWER
43 uppercaseletter LOWER
45 echo select * from t1 where f1 LIKE 'upper%letter';
46 ---------------------------------------------------------
47 t1.f1 t1.f2
48 ---------------------------------------------------------
49 upperletter LOWER
50 uppercaseletter LOWER
52 echo select * from t1 where f1 LIKE 'upper____letter';
53 ---------------------------------------------------------
54 t1.f1 t1.f2
55 ---------------------------------------------------------
56 uppercaseletter LOWER
58 echo select * from t1 where f1 like 'UP__R%SE';
59 ---------------------------------------------------------
60 t1.f1 t1.f2
61 ---------------------------------------------------------
62 UPPERCASE UPPER
64 echo select * from t1 where f1 like 'UP__R%SE' and f2 = 'B';
65 ---------------------------------------------------------
66 t1.f1 t1.f2
67 ---------------------------------------------------------
69 echo select * from t1 where f1 like 'UP__R%SE' and f2 = 'UPPER';
70 ---------------------------------------------------------
71 t1.f1 t1.f2
72 ---------------------------------------------------------
73 UPPERCASE UPPER
75 echo select * from t1 where f1 like 'UP__R%SE' and f2 like 'UPPER';
76 ---------------------------------------------------------
77 t1.f1 t1.f2
78 ---------------------------------------------------------
79 UPPERCASE UPPER
81 Statement Executed