OLD | NEW |
1 # | 1 # |
2 # 2007 June 20 | 2 # 2007 June 20 |
3 # | 3 # |
4 # The author disclaims copyright to this source code. In place of | 4 # The author disclaims copyright to this source code. In place of |
5 # a legal notice, here is a blessing: | 5 # a legal notice, here is a blessing: |
6 # | 6 # |
7 # May you do good and not evil. | 7 # May you do good and not evil. |
8 # May you find forgiveness for yourself and forgive others. | 8 # May you find forgiveness for yourself and forgive others. |
9 # May you share freely, never taking more than you give. | 9 # May you share freely, never taking more than you give. |
10 # | 10 # |
(...skipping 105 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
116 SELECT * FROM t2 WHERE (a COLLATE nocase)='abc' COLLATE binary; | 116 SELECT * FROM t2 WHERE (a COLLATE nocase)='abc' COLLATE binary; |
117 } | 117 } |
118 } {abc ABC} | 118 } {abc ABC} |
119 do_test collate8-2.8 { | 119 do_test collate8-2.8 { |
120 execsql { | 120 execsql { |
121 SELECT a COLLATE nocase AS x FROM t2 WHERE 'abc'=x COLLATE binary; | 121 SELECT a COLLATE nocase AS x FROM t2 WHERE 'abc'=x COLLATE binary; |
122 } | 122 } |
123 } {abc} | 123 } {abc} |
124 | 124 |
125 finish_test | 125 finish_test |
OLD | NEW |