上海山源电子科技有限公司

修改了 所属项目，旧值为 "0"，新值为 "16"。
修改了 重现步骤，区别为：

003-
003+
004- Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4 ### The error may exist in file [D:\Test\rydw\personposition\target\classes\mybatis\interfaces\PosiStayTimeMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: select a.tag_id,sum(case when a.leave_time is null then TIMESTAMPDIFF(minute,a.entry_time,now()) else case when stay_time is null then 0 else stay_time end end) stay_time from posi_stay_time a, (select tag_id,max(entry_time) entry_time from posi_stay_time where sub_ap not in () group by tag_id) b where a.tag_id=b.tag_id and a.entry_time > b.entry_time and a.sub_ap in () group by a.tag_id ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4
004+ Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4 ### The error may exist in file [D:\Test\rydw\personposition\target\classes\mybatis\interfaces\PosiStayTimeMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: select a.tag_id,sum(case when a.leave_time is null then TIMESTAMPDIFF(minute,a.entry_time,now()) else case when stay_time is null then 0 else stay_time end end) stay_time from posi_stay_time a, (select tag_id,max(entry_time) entry_time from posi_stay_time where sub_ap not in () group by tag_id) b where a.tag_id=b.tag_id and a.entry_time > b.entry_time and a.sub_ap in () group by a.tag_id ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4
005-
005+ [期望]
006- [期望]
006+
007-

003- <p>
003+ <p><br /></p>
004- </p><h2 class="el-notification__title" style="font-size:16px;color:#303133;">Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4 ### The error may exist in file [D:\Test\rydw\personposition\target\classes\mybatis\interfaces\PosiStayTimeMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: select a.tag_id,sum(case when a.leave_time is null then TIMESTAMPDIFF(minute,a.entry_time,now()) else case when stay_time is null then 0 else stay_time end end) stay_time from posi_stay_time a, (select tag_id,max(entry_time) entry_time from posi_stay_time where sub_ap not in () group by tag_id) b where a.tag_id=b.tag_id and a.entry_time &gt; b.entry_time and a.sub_ap in () group by a.tag_id ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4</h2>
004+ <h2 class="el-notification__title" style="font-size:16px;color:#303133;">Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4 ### The error may exist in file [D:\Test\rydw\personposition\target\classes\mybatis\interfaces\PosiStayTimeMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: select a.tag_id,sum(case when a.leave_time is null then TIMESTAMPDIFF(minute,a.entry_time,now()) else case when stay_time is null then 0 else stay_time end end) stay_time from posi_stay_time a, (select tag_id,max(entry_time) entry_time from posi_stay_time where sub_ap not in () group by tag_id) b where a.tag_id=b.tag_id and a.entry_time &gt; b.entry_time and a.sub_ap in () group by a.tag_id ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by tag_id) b where a.tag_id=b.tag_id and a.en' at line 4</h2>
005-
005+ <br /><p>[期望]</p>
006- <br /><p>[期望]</p>
006+ <br />
007- <br />

修改了 解决方案，旧值为 ""，新值为 "fixed"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2021-07-20 17:01:23"。
修改了 指派给 ，旧值为 "yanjianhua"，新值为 "zhangweina"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "yanjianhua"。

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "zhangweina"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "zhangweina"。
修改了 关闭日期，旧值为 ""，新值为 "2021-07-21 14:56:45"。