OLD | NEW |
1 # 2011 October 13 | 1 # 2011 October 13 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 19 matching lines...) Expand all Loading... |
30 INSERT INTO t1 VALUES ('a'); | 30 INSERT INTO t1 VALUES ('a'); |
31 INSERT INTO t1 VALUES ('A'); | 31 INSERT INTO t1 VALUES ('A'); |
32 INSERT INTO t1 VALUES ('A'); | 32 INSERT INTO t1 VALUES ('A'); |
33 SELECT count(CASE WHEN x='a' THEN 1 END), | 33 SELECT count(CASE WHEN x='a' THEN 1 END), |
34 count(CASE WHEN x='A' THEN 1 END) | 34 count(CASE WHEN x='A' THEN 1 END) |
35 FROM t1; | 35 FROM t1; |
36 } | 36 } |
37 } {1 2} | 37 } {1 2} |
38 | 38 |
39 finish_test | 39 finish_test |
OLD | NEW |