Hey @haoq, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss_bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at Here to find the details.

Hi @haoq, please use the command /sig xxx to add a SIG label to this issue.
For example: /sig sqlengine or /sig storageengine or /sig om or /sig ai and so on.
You can find more SIG labels from Here.
If you have no idea about that, please contact with @xiangxinyong , @zhangxubo .

@李居隆 sql_mode中是否包含 Pipes_as_concat，mysql那边都可执行，openGauss不行，两种场景都要兼容

@haoq 这里回归测试的时候要注意sql_mode的参数是否包含Pipes_as_concat

已完成自验

mysql端表现

时间：2023/11/27
版本：(openGauss 5.1.1 build 6460c491) compiled at 2023-11-23 00:09:51 commit 0 last mr on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.0,64-bit
结论：通过

时间：2023/11/27
版本：(openGauss 5.1.1 build 6460c491) compiled at 2023-11-23 00:09:51 commit 0 last mr on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.0,64-bit
结论：不通过

@邹佳良 为什么这个结论写的是不通过，你这个截图的测试结果不是和mysql表现一致吗

@邹佳良 为什么这个结论写的是不通过，你这个截图的测试结果不是和mysql表现一致吗

@李居隆 笔误，已修改

5.0.1
时间：2023/11/29
版本：(openGauss 5.0.1 build d855a18f) compiled at 2023-11-28 19:14:36 commit 0 last mr on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
结论：通过