| OLD | NEW |
| 1 # 2009-02-24 | 1 # 2009-02-24 |
| 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 173 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 184 SELECT count(*) FROM t4; | 184 SELECT count(*) FROM t4; |
| 185 } | 185 } |
| 186 } {1} | 186 } {1} |
| 187 | 187 |
| 188 do_execsql_test count-5.1 { | 188 do_execsql_test count-5.1 { |
| 189 CREATE TABLE t5(a TEXT PRIMARY KEY, b VARCHAR(50)) WITHOUT ROWID; | 189 CREATE TABLE t5(a TEXT PRIMARY KEY, b VARCHAR(50)) WITHOUT ROWID; |
| 190 INSERT INTO t5 VALUES('bison','jazz'); | 190 INSERT INTO t5 VALUES('bison','jazz'); |
| 191 SELECT count(*) FROM t5; | 191 SELECT count(*) FROM t5; |
| 192 } {1} | 192 } {1} |
| 193 | 193 |
| 194 do_catchsql_test count-6.1 { |
| 195 CREATE TABLE t6(x); |
| 196 SELECT count(DISTINCT) FROM t6 GROUP BY x; |
| 197 } {1 {DISTINCT aggregates must have exactly one argument}} |
| 198 |
| 194 finish_test | 199 finish_test |
| OLD | NEW |