Project table Name
columns contains this data:
- USA Russia England Canada
- Canada
Query:
SELECT name
FROM project
WHERE FREETEXT(name, '"USA Canada"')
Result: the query returns both rows.
Expectation: the query should only return 1 row containing USA and Canada