UDT Query tag not behaving as expected

Torsten_Giesbrecht1 · October 31, 2025, 2:21pm

I’ve got the following UDT:

I get the following error in my instance: Error_ExpressionEval("Unknown column 'Winnipeg' in 'where clause'")

But if I use

SELECT id FROM sites WHERE name = "Winnipeg"

I get the right value.

Leor_Fishman · October 31, 2025, 2:22pm

Wrap the tag in quotes?

pturmel · October 31, 2025, 2:29pm

In single quotes.... Double quotes for string constants are only supported for MariaDB and friends, and only when not in standards-compliant mode.

Torsten_Giesbrecht1 · October 31, 2025, 2:42pm

That did the trick thank you!