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 |