diff options
Diffstat (limited to 'test/spellfix2.test')
-rw-r--r-- | test/spellfix2.test | 20 |
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 - |