一些sql语句

 

 

【硬件类型版本】（cat /etc/system-release）：EulerOS release 2.0 (SP3)

【全局版本号】：C20

【测试环境】： 分布式

【被测功能】：SQL

【测试类型】：功能性测试

【对应用例号】： cluster_fault.py

【测试步骤】：

【问题】

 

[/lib64/libc.so.6 + 0x355c7] gsignal + 0x37

[/lib64/libc.so.6 + 0x36cb8] abort + 0x148

[bin/gaussdb + 0x998078] _Z20ExceptionalConditionPKcS0_S0_i + 0x38

[bin/gaussdb + 0xbc6efc] _Z23distribute_qual_to_relsP11PlannerInfoP4Nodebb8JoinTypejP9BitmapsetS5_S5_S5_PP4List + 0x73c

[bin/gaussdb + 0xbc73c8]0xfc73c8

[bin/gaussdb + 0xbc726d]0xfc726d

[bin/gaussdb + 0xbc8256] _Z20deconstruct_jointreeP11PlannerInfo + 0xb6

[bin/gaussdb + 0xbc9fc7] _Z13query_plannerP11PlannerInfoP4ListddPP4PathS5_PdS2_S2_ + 0x137

[bin/gaussdb + 0xbd6d86]0xfd6d86

[bin/gaussdb + 0xbdefcd] _Z16subquery_plannerP13PlannerGlobalP5QueryP11PlannerInfobdPS4_iP10ItstDisKeyP4List + 0xf5d

[bin/gaussdb + 0xbe302f] _Z16standard_plannerP5QueryiP17ParamListInfoData + 0x34f

[bin/gaussdb + 0x1519c34] _Z12pgxc_plannerP5QueryiP17ParamListInfoData + 0x314

[bin/gaussdb + 0xbe4c24] _Z7plannerP5QueryiP17ParamListInfoData + 0xd4

[bin/gaussdb + 0xe549b2] _Z13pg_plan_queryP5QueryiP17ParamListInfoDatab + 0xc2

[bin/gaussdb + 0xe54c5d] _Z15pg_plan_queriesP4ListiP17ParamListInfoData + 0x5d

[bin/gaussdb + 0xe55bff]0x1255bff

[bin/gaussdb + 0xe5adfd] _Z12PostgresMainiPPcPKcS2_ + 0x250d

[bin/gaussdb + 0xde344b]0x11e344b

[bin/gaussdb + 0xdf8fa4] _Z17GaussDbThreadMainIL15knl_thread_role2EEiP14knl_thread_arg + 0x294

[bin/gaussdb + 0xdea398]0x11ea398

[/lib64/libpthread.so.0 + 0x7dc5] start_thread + 0xc5

[/lib64/libc.so.6 + 0xfa50d] clone + 0x6d

 

create table t1(role_id int);

create table t2(sys_code int);

 

SELECT *

FROM

       (

              SELECT

                     1

              FROM

                     t1 r

              WHERE

                     (

                            (

                                   r.role_id IN

                                   (

                                          SELECT

                                                 1

                                          FROM

                                                 dual

                                   )

                            )

                            OR

                            (

                                   r.role_id IN

                                   (

                                          SELECT

                                                 1

                                          FROM

                                                 dual

                                   )

                            )

                     )

       )

       o

     , t2 m

;