Hongshun Wang created FLINK-38512:
-------------------------------------
Summary: Postgres YAML CDC support database name with middlescore
Key: FLINK-38512
URL: https://issues.apache.org/jira/browse/FLINK-38512
Project: Flink
Issue Type: Improvement
Components: Flink CDC
Affects Versions: cdc-3.5.0
Reporter: Hongshun Wang
Fix For: cdc-3.6.0
Though in postgres official documents, it write:
SQL identifiers and key words must begin with a letter ({{{}a{}}}-{{{}z{}}},
but also letters with diacritical marks and non-Latin letters) or an underscore
({{{}_{}}}).[1]
However , this is not exactly the documentation for a database name. If you
read it closely, {{-}} is not allowed, yet, while {{CREATE TABLE foo-bar;}}
does indeed fail, {{createdb foo-bar}} on the command line works perfectly to
create a database named {{foo-bar[2]}}
[1][https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS]
[2]
https://stackoverflow.com/questions/10216784/what-is-a-valid-postgresql-database-name
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
