The element type of a JSON ARRAY column, or null if the values are not all arrays. Real schemas keep
lists of ids this way (measured on a 65-table production schema: client_ids, room_id,
equipment_id are all [123504,312]), and without a hint the model wrote
JSON_CONTAINS(col, '["1"]') - a string against numbers - which matched nothing and raised no error.
The element type only; never an element.
The element type of a JSON ARRAY column, or null if the values are not all arrays. Real schemas keep lists of ids this way (measured on a 65-table production schema:
client_ids,room_id,equipment_idare all[123504,312]), and without a hint the model wroteJSON_CONTAINS(col, '["1"]')- a string against numbers - which matched nothing and raised no error. The element type only; never an element.