Search api score always 1

[kangfenmao]

🐛 Describe the bug

LanceDB is ok

Libsql ragApplication.search score always is 1

[kangfenmao]

async similaritySearch(query, k) {
        const statement = `SELECT id, pageContent, uniqueLoaderId, source, metadata,
                vector_distance_cos(vector, vector32('[${query.join(',')}]')) as distance
            FROM ${this.tableName}
            ORDER BY distance DESC
            LIMIT ${k};`;
        this.debug(`Executing statement - ${truncateCenterString(statement, 700)}`);
        const results = await this.client.execute(statement);
        return results.rows.map((result) => {
            const metadata = JSON.parse(result.metadata.toString());
            return {
                metadata,
                pageContent: result.pageContent.toString(),
                score: 1 - result.distance,
            };
        });
    }

vector_distance_cos as distance