问题现象
GBase 8a MPP Cluster 最佳实践
5 FAQ
文档版本(2022-02-11)
南大通用数据技术股份有限公司
74
使用gccli 客户端创建存储过程包含注释,但是执行show create procedure 注释没
有显示。
> gccli guo
GBase client 8.6.2.33-R11.102859. Copyright (c) 2004-2018, GBase.
All Ri
ghts Reserved.
gbase> delimiter //
gbase> create procedure p1()
-> begin
-> /*aa */
-> select 1;
-> end //
Query OK, 0 rows affected (Elapsed: 00:00:00.05)
gbase> delimiter ;
gbase> show create procedure p1\G
*************************** 1. row ***************************
Procedure: p1
sql_mode: PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPA
CE,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_ALL
_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_AUTO_CREATE_US
ER,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH
Create Procedure: CREATE DEFINER="root"@"%" PROCEDURE "p1"
()
begin
select 1;
end
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
1 row in set (Elapsed: 00:00:00.00)
解决方法
gccli -c 保留存储过程中的注释。
> gccli -c guo
GBase client 8.6.2.33-R11.102859. Copyright (c) 2004-2018, GBase.
All Ri
ghts Reserved.
gbase> delimiter //
GBase 8a MPP Cluster 最佳实践
5 FAQ
文档版本(2022-02-11)
南大通用数据技术股份有限公司
75
gbase> create procedure p1()
-> begin
-> /*aa */
-> select 1;
-> end //
Query OK, 0 rows affected (Elapsed: 00:00:00.04)
gbase> delimiter ;
gbase> show create procedure p1\G
*************************** 1. row ***************************
Procedure: p1
sql_mode: PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPA
CE,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_ALL
_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_AUTO_CREATE_US
ER,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH
Create Procedure: CREATE DEFINER="root"@"%" PROCEDURE "p1"
()
begin
/*aa */
select 1;
end
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
1 row in set (Elapsed: 00:00:00.00)
gbase> \q
Bye
gbase@suse100-1:~> gccli guo
GBase client 8.6.2.33-R11.102859. Copyright (c) 2004-2018, GBase.
All Ri
ghts Reserved.
gbase> show create procedure p1\G
*************************** 1. row ***************************
Procedure: p1
sql_mode: PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPA
CE,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_ALL
_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_AUTO_CREATE_US
ER,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH
Create Procedure: CREATE DEFINER="root"@"%" PROCEDURE "p1"
()
begin
/*aa */
GBase 8a MPP Cluster 最佳实践
5 FAQ
文档版本(2022-02-11)
南大通用数据技术股份有限公司
76
select 1;
end
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
1 row in set (Elapsed: 00:00:00.00)