summaryrefslogtreecommitdiff
path: root/lang/sql/sqlite/test/tkt2822.test
diff options
context:
space:
mode:
Diffstat (limited to 'lang/sql/sqlite/test/tkt2822.test')
-rw-r--r--lang/sql/sqlite/test/tkt2822.test12
1 files changed, 11 insertions, 1 deletions
diff --git a/lang/sql/sqlite/test/tkt2822.test b/lang/sql/sqlite/test/tkt2822.test
index 281e5dc9..d0b16338 100644
--- a/lang/sql/sqlite/test/tkt2822.test
+++ b/lang/sql/sqlite/test/tkt2822.test
@@ -273,11 +273,21 @@ do_test tkt2822-7.1 {
SELECT * FROM t7 ORDER BY 0;
}
} {1 {1st ORDER BY term out of range - should be between 1 and 25}}
-do_test tkt2822-7.2 {
+do_test tkt2822-7.2.1 {
catchsql {
SELECT * FROM t7 ORDER BY 1, 0;
}
} {1 {2nd ORDER BY term out of range - should be between 1 and 25}}
+do_test tkt2822-7.2.2 {
+ catchsql {
+ SELECT * FROM t7 ORDER BY 1, 26;
+ }
+} {1 {2nd ORDER BY term out of range - should be between 1 and 25}}
+do_test tkt2822-7.2.3 {
+ catchsql {
+ SELECT * FROM t7 ORDER BY 1, 65536;
+ }
+} {1 {2nd ORDER BY term out of range - should be between 1 and 25}}
do_test tkt2822-7.3 {
catchsql {
SELECT * FROM t7 ORDER BY 1, 2, 0;