aboutsummaryrefslogtreecommitdiff
path: root/test/spellfix2.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/spellfix2.test')
-rw-r--r--test/spellfix2.test20
1 files changed, 11 insertions, 9 deletions
diff --git a/test/spellfix2.test b/test/spellfix2.test
index b4614a9e1..e9d6c693b 100644
--- a/test/spellfix2.test
+++ b/test/spellfix2.test
@@ -29,32 +29,35 @@ do_execsql_test 1.0 {
do_execsql_test 1.1 {
SELECT word, distance, matchlen FROM demo
- WHERE word MATCH 'amstedam*' AND top=3;
+ WHERE word MATCH 'amstedam*' AND top=3
+ ORDER BY +word;
} {
amsterdam 100 9
- amsterdammetje 100 9
amsterdamania 100 9
+ amsterdammetje 100 9
}
do_execsql_test 1.2 {
SELECT word, distance, matchlen FROM demo WHERE
- word MATCH 'amstedam*' AND top=3 AND distance <= 100;
+ word MATCH 'amstedam*' AND top=3 AND distance <= 100
+ ORDER BY +word;
} {
amsterdam 100 9
- amsterdammetje 100 9
amsterdamania 100 9
+ amsterdammetje 100 9
}
do_execsql_test 1.3 {
SELECT word, distance, matchlen FROM demo WHERE
- word MATCH 'amstedam*' AND distance <= 100;
+ word MATCH 'amstedam*' AND distance <= 100
+ ORDER BY +word;
} {
amsterdam 100 9
- amsterdammetje 100 9
amsterdamania 100 9
- amsterdamweg 100 9
- amsterdamsestraat 100 9
amsterdamlaan 100 9
+ amsterdammetje 100 9
+ amsterdamsestraat 100 9
+ amsterdamweg 100 9
}
do_test 1.4 {
@@ -111,4 +114,3 @@ do_execsql_test 1.7 {
finish_test
-