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