Red underline on script which previously wasn't underlined but still works perfectly #5196
Labels
bug
Something isn't working
pending-clarification
The item is pending clarification from author or someone else before could be processed further
Discussed in #5195
Originally posted by wlclifford January 2, 2025
This seems to have started with update from 3.4.10 to 3.4.13. Screen shot below of what seems to be valid syntax. Also happens with red underline of just the semicolon when the last line of a script contains WHERE and LIKE - again the script below works fine.
UPDATE NHPProductLicence
SET product_name = REPLACE(product_name, CHAR(10), '')
WHERE product_name LIKE '%' || CHAR(10) || '%';
The text was updated successfully, but these errors were encountered: