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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
