Posting a dummy post to keep the post from getting frozen. Just in case it could be useful in the future. (Actually, this is probably not needed if no other rooms are associated with the site - the system always keeps at least one room open.)

@MartinSleziak Thanks

As long as it's the only room, we're safe from freeze.

Query documentation says "In case of mixed data types in a single column, the majority data type determines the data type of the column for query purposes. Minority data types are considered null values."

And I think this is how it used to work, but now I see numbers coerced to text when there is more text (instead of being treated as null)

E.g. "select *" from a column with "a", "b", 23 will return "a", "b", "23"

If there are more numbers than text, then text is indeed treated as null.