You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm trying to do a little complicated SQL and it seems that I cannot properly escape the natural language to put in a question mark. I always only get 4 params when I should be getting 5. Does anyone know how I could escape the first so I can also have a natural language search param?
Relevant log output
No response
Database schema
CREATETABLEProfile (
id SERIALPRIMARY KEY AUTO_INCREMENT UNIQUE,
profileOwner VARCHAR(36) NOT NULL,
name VARCHAR(512) NOT NULL,
subHead VARCHAR(512) NOT NULL,
body TEXT,
locationLat FLOAT,
locationLon FLOAT,
createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMPNOT NULL,
updatedAt TIMESTAMPONUPDATECURRENT_TIMESTAMP,
FOREIGN KEY (profileOwner) REFERENCES User(id) ON DELETE CASCADE,
FULLTEXT (name, body, subHead)
);
SQL queries
SELECT*FROM
Profile
WHERE
MATCH (subHead, body, name)
AGAINST (? IN NATURAL LANGUAGE MODE)
AND locationLat BETWEEN ? AND ?
AND locationLon BETWEEN ? AND ?;
Activity
haashemi commentedon Apr 25, 2025
@kyleconroy
Sorry for pinging. But any updates on this?
As of SQLC v1.29.0, the issue still exists.
feat(engine/dolphin): implement MATCH_AGAINST conversion in SQL AST (s…
feat(engine/dolphin): implement MATCH_AGAINST conversion in SQL AST (#…
kyleconroy commentedon Aug 24, 2025
Fixed in #4070
feat(engine/dolphin): implement MATCH_AGAINST conversion in SQL AST (s…