I'm trying to map the CONTAINS function to use in EFCore queries however the generated sql is malformed. Full runnable repro attached.
OracleFulltextBug.zip (993 Bytes)I would expect the following command text:
SELECT "t"."Name"
FROM "Things" "t"
WHERE CONTAINS("t"."Name", N'asd') > 0.0
however I get the following:
SELECT "t"."Name"
FROM "Things" "t"
WHERE CASE
WHEN CONTAINS("t"."Name", N'asd') THEN 1
ELSE 0
END > 0.0
Am I doing something wrong or is this a bug?