table query of integer column with non integer value returns incorrect results

Description

I am not sure if this is intentional behavior but it is unexpected:

retrieves rows with internal_id = 2.

retrieves reows with internal_id = 123.

My expectation would be that these queries either return an error ("can't query an integer column with a string") or no rows.

Environment

None

Assignee

John Hill

Reporter

Robert Allaway

Labels

None

Validator

Robert Allaway

Development Area

None

Release Version History

None

Components

Priority

Major
Configure