[GitHub] [shardingsphere] zhaojinchao95 opened a new issue, #25225: Column index out of range exception when single table use inner join query

["zhaojinchao95 (via GitHub)" <gi...@apache.org>]

zhaojinchao95 opened a new issue, #25225:
URL: https://github.com/apache/shardingsphere/issues/25225

   SQL : 
   
   ```
   select d.oid,d.o_status,d.is_del
   ,a.* 
   ,case when a.is_in = 1 then '是' else '否' end is_in
   from order_monthly a
   inner join p_in d
   on a.p_id=d.id
   inner join (
           select b.p_id,max(b.period) period
           from order_monthly b
           where b.biz_type=0
           group by b.p_id
   )c
   on a.p_id=c.p_id
   and a.period=c.period
   and a.biz_type=0
   where  EXISTS(
           SELECT id FROM p_in zb where '3a3a14e19b234471966cdb8f670e32d1' and d.id = zb.id
   )
   and (d.oid='' or '' = '')
   and (d.o_status='' or '' = '') 
   and (IFNULL(d.is_del,0)='' or '' = '')
   and d.project_name like CONCAT('%','','%')
   and IFNULL(a.province,'') like CONCAT('%','','%')
   and IFNULL(a.manager,'') like CONCAT('%','','%')
   and IFNULL(a.ct_start_date,'0000-00-00') >= ''
   order by d.oid asc,d.project_code asc
   ```
   
   
   `Column index out of range.; nested exception is java.sql.SQLException: Column index out of range. at....`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhaojinchao95 closed issue #25225: Column index out of range exception when single table use inner join query

["zhaojinchao95 (via GitHub)" <gi...@apache.org>]

zhaojinchao95 closed issue #25225: Column index out of range exception when single table use inner join query
URL: https://github.com/apache/shardingsphere/issues/25225


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org