OLD | NEW |
1 # The author disclaims copyright to this source code. In place of | 1 # The author disclaims copyright to this source code. In place of |
2 # a legal notice, here is a blessing: | 2 # a legal notice, here is a blessing: |
3 # | 3 # |
4 # May you do good and not evil. | 4 # May you do good and not evil. |
5 # May you find forgiveness for yourself and forgive others. | 5 # May you find forgiveness for yourself and forgive others. |
6 # May you share freely, never taking more than you give. | 6 # May you share freely, never taking more than you give. |
7 # | 7 # |
8 #*********************************************************************** | 8 #*********************************************************************** |
9 # This file implements regression tests for SQLite library. The | 9 # This file implements regression tests for SQLite library. The |
10 # focus of this file is testing compute SELECT statements and nested | 10 # focus of this file is testing compute SELECT statements and nested |
(...skipping 182 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
193 | 193 |
194 do_test select7-7.7 { | 194 do_test select7-7.7 { |
195 execsql { | 195 execsql { |
196 CREATE TABLE t5(a TEXT, b INT); | 196 CREATE TABLE t5(a TEXT, b INT); |
197 INSERT INTO t5 VALUES(123, 456); | 197 INSERT INTO t5 VALUES(123, 456); |
198 SELECT typeof(a), a FROM t5 GROUP BY a HAVING a<b; | 198 SELECT typeof(a), a FROM t5 GROUP BY a HAVING a<b; |
199 } | 199 } |
200 } {text 123} | 200 } {text 123} |
201 | 201 |
202 finish_test | 202 finish_test |
OLD | NEW |