aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
Diffstat (limited to 'test')
-rw-r--r--test/null.test25
1 files changed, 20 insertions, 5 deletions
diff --git a/test/null.test b/test/null.test
index 9e2d60167..889252d01 100644
--- a/test/null.test
+++ b/test/null.test
@@ -153,11 +153,26 @@ do_test null-5.1 {
# as distinct
#
ifcapable compound {
-do_test null-6.1 {
- execsql {
- select b from t1 union select c from t1 order by c;
- }
-} {{} 0 1}
+ do_test null-6.1 {
+ execsql {
+ select b from t1 union select c from t1 order by b;
+ }
+ } {{} 0 1}
+ do_test null-6.2 {
+ execsql {
+ select b from t1 union select c from t1 order by 1;
+ }
+ } {{} 0 1}
+ do_test null-6.3 {
+ execsql {
+ select b from t1 union select c from t1 order by t1.b;
+ }
+ } {{} 0 1}
+ do_test null-6.4 {
+ execsql {
+ select b from t1 union select c from t1 order by main.t1.b;
+ }
+ } {{} 0 1}
} ;# ifcapable compound
# The UNIQUE constraint only applies to non-null values