Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ddl log添加额外的guc信息,避免ddl复制停止 #798

Open
jd-zhang opened this issue Jul 7, 2022 · 2 comments
Open

ddl log添加额外的guc信息,避免ddl复制停止 #798

jd-zhang opened this issue Jul 7, 2022 · 2 comments

Comments

@jd-zhang
Copy link
Contributor

jd-zhang commented Jul 7, 2022

*Issue migrated from trac ticket # 883 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-07 15:30:21: smith created the issue


记录ddl时,需要检查如下几个GUC变量的值:

extern  bool standard_conforming_strings;
extern bool mysql_ansi_quotes;
extern int	backslash_quote;
extern bool quote_all_identifiers;

因为这些变量影响着字符串的解析或者生成。

@jd-zhang
Copy link
Contributor Author

jd-zhang commented Jul 7, 2022

2022-07-07 15:30:29: smith changed status from new to accepted

@jd-zhang
Copy link
Contributor Author

jd-zhang commented Jul 7, 2022

2022-07-07 15:32:31: smith commented


例如:

-- 非sql标准模式,将‘\'作为转移字符
set standard_conforming_strings = off;

create table t(a varchar(10) default 'a\n\b\n\c', b int);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant