joyCurry30 commented on PR #3996: URL: https://github.com/apache/flink-cdc/pull/3996#issuecomment-2816474768
As documented in the official MySQL 8.4 reference manual: https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html The case sensitivity behavior of MySQL identifiers is governed by the system variable "lower_case_table_names", which defines three distinct operational modes: | mode | Behavior | Scope | | ----------- | ----------- | ----------- | | 0 | Case-sensitive comparisons with case-preserving storage | Affects database names and table names | | 1 | Case-insensitive comparisons with lowercase conversion | Applies to database names and table names | | 2 | Case-insensitive comparisons with case-preserving storage| Impacts database names and table names | Should we introduce a validation mechanism to ensure configuration parity between the connector and MySQL server (e.g., rejecting mixed-case identifiers when lower_case_table_names=1)? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
