v.24.2Improvement

Do not interpret leading zeroes as octals with input_format_values_interpret_expressions=0

Do not interpret numbers with leading zeroes as octals when input_format_values_interpret_expressions=0. #59403 (Joanna Hulboj).
Prevent numbers with leading zeroes from being interpreted as octal numbers when input_format_values_interpret_expressions=0.

Why it matters

This feature fixes the problem where numeric values with leading zeroes were mistakenly parsed as octal numbers even when expression interpretation was disabled. It ensures consistent and expected numeric interpretation, improving data import accuracy and preventing errors caused by incorrect number formats.

How to use it

Set the setting input_format_values_interpret_expressions to 0 to disable expression interpretation. Numbers with leading zeroes will then be interpreted as decimal values rather than octals.