Hello,
I have this strange behaviour which I am not able to solve.
After debugging, I found 1 SQL script that fails and another very similar that passes. Please note the 'keyword' string in the query.
Fails
SELECT COUNT(DISTINCT uuid.keyword) as count FROM "monitoring*" WHERE resolved.keyword = 'false'
In the screenshot movie, you can see that from status "changes saved" it goes to "can't save changes" (bottom right status).
Pass
SELECT COUNT(DISTINCT uuid.keyword) as count FROM "monitoring*" WHERE resolved = 'false'
In the screenshot movie , you can see that after I paste the code it is saved (bottom right status)
Any ideas of the root cause and the solution?
Cheers!