Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

参数没有完全解析bug #4

Open
YWeiYuan opened this issue Aug 30, 2022 · 1 comment
Open

参数没有完全解析bug #4

YWeiYuan opened this issue Aug 30, 2022 · 1 comment

Comments

@YWeiYuan
Copy link

YWeiYuan commented Aug 30, 2022

image
image

iShot_2022-08-30_13.59.11.mp4

原始日志为:
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@54150c67] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@930199905 wrapping com.mysql.cj.jdbc.ConnectionImpl@60a10cf2] will not be managed by Spring
==> Preparing: SELECT DISTINCT t2.area_code FROM base_group_car t LEFT JOIN base_car t1 ON t1.id = t.car_id AND t1.deleted = 0 LEFT JOIN base_company t2 ON t2.id = t1.comp_id AND t2.deleted = 0 WHERE t.group_id = ? AND t2.area_code IS NOT NULL
==> Parameters: 1539892375719923714(Long)
<== Columns: area_code
<== Row: 350300
<== Row: 350100
<== Total: 2
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@54150c67]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@109191f6] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1822151095 wrapping com.mysql.cj.jdbc.ConnectionImpl@60a10cf2] will not be managed by Spring
==> Preparing: select distinct t.alarm_Type from sys_alarm_settings t WHERE t.area_code in (?,?)
==> Parameters: 350300(String), 350100(String)
<== Columns: alarm_Type
<== Row: ALAT0028_ALAS0002
<== Row: ALAT0057_ALAS0004

解析后的日志:
SELECT DISTINCT t2.area_code FROM base_group_car t LEFT JOIN base_car t1 ON t1.id = t.car_id AND t1.deleted = 0 LEFT JOIN base_company t2 ON t2.id = t1.comp_id AND t2.deleted = 0 WHERE t.group_id = 1544612448196055041 AND t2.area_code IS NOT NULL;
select distinct t.alarm_Type from sys_alarm_settings t WHERE t.area_code in (1539892375719923714,{});

@pg-liudong
Copy link
Owner

image

并未复现,是否在线程的场景下使用了呢?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants