背景

mysql在navicat执行没问题。代码里确报错 sql injection violation.....expect PPAREN,actual AND pos 326,line 1,token And

简易sql如下

select r.segment24, r.segment2
          from (select r1.*
                  from (select jr.*
                          from  bgt_aaaa jr
                         where 1 = 1
                           and validity_flag = '0'
                        ) r1
          
              ) r
         where 1 = 1
           AND (exists
                (select 1 from sys_data))
            or (exists
                (select 1
                   from sys_data))
            or (exists
                (select 1
                   from sys_data_))
         group by r.segment24, r.segment2 

问题解决

在AND 后面的东西包一层括号