v.24.3upgrade-notes
MySQL compatibility update for locate function argument order in ClickHouse
To increase compatibility with MySQL, the compatibility aliaslocatenow accepts arguments(needle, haystack[, start_pos])by default. The previous behavior(haystack, needle, [, start_pos])can be restored by settingfunction_locate_has_mysql_compatible_argument_order = 0. #61092 (Robert Schulze).