OLD | NEW |
1 # 2007 Dec 4 | 1 # 2007 Dec 4 |
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 255 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
266 # | 266 # |
267 do_test tkt2822-7.1 { | 267 do_test tkt2822-7.1 { |
268 execsql { | 268 execsql { |
269 CREATE TABLE t7(a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14, | 269 CREATE TABLE t7(a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14, |
270 a15,a16,a17,a18,a19,a20,a21,a22,a23,a24,a25); | 270 a15,a16,a17,a18,a19,a20,a21,a22,a23,a24,a25); |
271 } | 271 } |
272 catchsql { | 272 catchsql { |
273 SELECT * FROM t7 ORDER BY 0; | 273 SELECT * FROM t7 ORDER BY 0; |
274 } | 274 } |
275 } {1 {1st ORDER BY term out of range - should be between 1 and 25}} | 275 } {1 {1st ORDER BY term out of range - should be between 1 and 25}} |
276 do_test tkt2822-7.2 { | 276 do_test tkt2822-7.2.1 { |
277 catchsql { | 277 catchsql { |
278 SELECT * FROM t7 ORDER BY 1, 0; | 278 SELECT * FROM t7 ORDER BY 1, 0; |
279 } | 279 } |
280 } {1 {2nd ORDER BY term out of range - should be between 1 and 25}} | 280 } {1 {2nd ORDER BY term out of range - should be between 1 and 25}} |
| 281 do_test tkt2822-7.2.2 { |
| 282 catchsql { |
| 283 SELECT * FROM t7 ORDER BY 1, 26; |
| 284 } |
| 285 } {1 {2nd ORDER BY term out of range - should be between 1 and 25}} |
| 286 do_test tkt2822-7.2.3 { |
| 287 catchsql { |
| 288 SELECT * FROM t7 ORDER BY 1, 65536; |
| 289 } |
| 290 } {1 {2nd ORDER BY term out of range - should be between 1 and 25}} |
281 do_test tkt2822-7.3 { | 291 do_test tkt2822-7.3 { |
282 catchsql { | 292 catchsql { |
283 SELECT * FROM t7 ORDER BY 1, 2, 0; | 293 SELECT * FROM t7 ORDER BY 1, 2, 0; |
284 } | 294 } |
285 } {1 {3rd ORDER BY term out of range - should be between 1 and 25}} | 295 } {1 {3rd ORDER BY term out of range - should be between 1 and 25}} |
286 do_test tkt2822-7.4 { | 296 do_test tkt2822-7.4 { |
287 catchsql { | 297 catchsql { |
288 SELECT * FROM t7 ORDER BY 1, 2, 3, 0; | 298 SELECT * FROM t7 ORDER BY 1, 2, 3, 0; |
289 } | 299 } |
290 } {1 {4th ORDER BY term out of range - should be between 1 and 25}} | 300 } {1 {4th ORDER BY term out of range - should be between 1 and 25}} |
(...skipping 36 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
327 } {1 {21st ORDER BY term out of range - should be between 1 and 25}} | 337 } {1 {21st ORDER BY term out of range - should be between 1 and 25}} |
328 do_test tkt2822-7.22 { | 338 do_test tkt2822-7.22 { |
329 catchsql { | 339 catchsql { |
330 SELECT * FROM t7 ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, | 340 SELECT * FROM t7 ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, |
331 11,12,13,14,15,16,17,18,19, 20, 21, 0 | 341 11,12,13,14,15,16,17,18,19, 20, 21, 0 |
332 } | 342 } |
333 } {1 {22nd ORDER BY term out of range - should be between 1 and 25}} | 343 } {1 {22nd ORDER BY term out of range - should be between 1 and 25}} |
334 | 344 |
335 | 345 |
336 finish_test | 346 finish_test |
OLD | NEW |