tests/golite.go: Change FTS3/FTS4 tests in favor of FTS5

1 files changed, 5 insertions, 15 deletions

diff --git a/tests/golite.go b/tests/golite.go
index 3f09878..d9693ad 100644
--- a/tests/golite.go
+++ b/tests/golite.go
@@ -1187,7 +1187,7 @@ func TestColumnTableName(t *testing.T) {
 	}
 }
 
-func TestFTS3(t *testing.T) {
+func TestFTS5(t *testing.T) {
 	db, err := sql.Open("golite", ":memory:")
 	if err != nil {
 		t.Fatal("Failed to open database:", err)
@@ -1195,7 +1195,7 @@ func TestFTS3(t *testing.T) {
 	defer db.Close()
 
 	_, err = db.Exec("DROP TABLE foo")
-	_, err = db.Exec("CREATE VIRTUAL TABLE foo USING fts3(id INTEGER PRIMARY KEY, value TEXT)")
+	_, err = db.Exec("CREATE VIRTUAL TABLE foo USING fts5(id, value)")
 	if err != nil {
 		t.Fatal("Failed to create table:", err)
 	}
@@ -1254,17 +1254,9 @@ func TestFTS3(t *testing.T) {
 	if rows.Next() {
 		t.Fatal("Result should be only one")
 	}
-}
-
-func TestFTS4(t *testing.T) {
-	db, err := sql.Open("golite", ":memory:")
-	if err != nil {
-		t.Fatal("Failed to open database:", err)
-	}
-	defer db.Close()
 
 	_, err = db.Exec("DROP TABLE foo")
-	_, err = db.Exec("CREATE VIRTUAL TABLE foo USING fts4(tokenize=unicode61, id INTEGER PRIMARY KEY, value TEXT)")
+	_, err = db.Exec("CREATE VIRTUAL TABLE foo USING fts5(tokenize=unicode61, id, value)")
 	switch {
 	case err != nil && err.Error() == "unknown tokenizer: unicode61":
 		t.Skip("FTS4 not supported")
@@ -1277,13 +1269,12 @@ func TestFTS4(t *testing.T) {
 		t.Fatal("Failed to insert value:", err)
 	}
 
-	rows, err := db.Query("SELECT value FROM foo WHERE value MATCH 'fevrier'")
+	rows, err = db.Query("SELECT value FROM foo WHERE value MATCH 'fevrier'")
 	if err != nil {
 		t.Fatal("Unable to query foo table:", err)
 	}
 	defer rows.Close()
 
-	var value string
 	if !rows.Next() {
 		t.Fatal("Result should be only one")
 	}
@@ -3633,8 +3624,7 @@ func MainTest() {
 		{ "TestExecCancel", TestExecCancel },
 		{ "TestFileCopyTruncate", TestFileCopyTruncate },
 		{ "TestColumnTableName", TestColumnTableName },
-		{ "TestFTS3", TestFTS3 },
-		{ "TestFTS4", TestFTS4 },
+		{ "TestFTS5", TestFTS5 },
 		{ "TestMathFunctions", TestMathFunctions },
 		{ "TestSerializeDeserialize", TestSerializeDeserialize },
 		{ "TestOpenWithVFS", TestOpenWithVFS },