BUG system.db.runPrepQuery fails to return error when wrong column name is selected

Ignition
1

I ran a Prep Query in ignition 8.3 and it seems like when the query contains a column that doesn't exist, a column is returned...

image

image922×137 7.93 KB

Clearly table has no rows and column "abc" doesn't exist.

image

image392×166 1.81 KB

When I run in SSMS, this is the error I get and is the one I expect to come back in the traceback.

image

image403×190 7.64 KB

Any ideas? Or is it just a bug?

2

The bug is you attempting to use a ? placeholder for column name. They aren't allowed to provide query structure, only query values.