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).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 settinginput_format_values_interpret_expressions to 0 to disable expression interpretation. Numbers with leading zeroes will then be interpreted as decimal values rather than octals.