| 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 |