Error running CTE in the database query browser

Ignition
1

Says I can't run in read only mode even if I am not in read only mode.

I believe I was able to run CTE queries in the database query browser before though.

Anyone come across this before or know of a setting that might have got flipped?

2

have you tried setting the query type to select rather than auto?

1 Like
3

Thanks, that worked.

I don't remember having to do that before or auto being update. Thanks so much.

Was it always that way or is that something new?

4

I don't recall what version introduced that selector, but before that it was always "auto". If the query doesn't literally start with SELECT, "auto" picks "update". Since CTEs start with WITH, they'd be misidentified as updates.

4 Likes