Tom Lane wrote:
> Martin Langhoff <martin@catalyst.net.nz> writes:
>> I say they are worrying because Moodle code has many ocurrences of
>> /* bla.id is an INT8 */
>> SELECT x,y,z FROM bla WHERE id='1';
>> And we also often quote INT values for inserts/updates, I am not sure if
>> this is supported either.
>
> This is not a problem. Read up on unknown-type literals --- that
> behavior isn't changing.
Tom,
thanks for the clarification - reading up on those now...
> The cases that we are tightening up on
> involve values that are of *known* non-string data types being used
> in situations where logically only a string should appear.
Hmmm. We'll have to test and see if we have any in Moodle.
- Is there a way to turn it back to the old behaviour with a
warning going to the logs?
- Is there a way to get v8.2.x to warn on the dubious casts
so we can tighten the application side while on v8.2?
cheers,
martin