wting1123 opened a new issue, #30530: URL: https://github.com/apache/shardingsphere/issues/30530
### version shardingsphere-jdbc-core-spring-boot-starter 5.2.1 ### config  ### table  ### Logic SQL SELECT count(0) FROM (SELECT id, alarm_no, alarm_content, alarm_time FROM device_alarm WHERE del_flag = 0 AND alarm_time <= ? AND mac_sn = ? UNION ALL SELECT id, alarm_no, alarm_content, alarm_time FROM device_alarm WHERE del_flag = 0 AND alarm_time >= ? AND alarm_time <= ? AND mac_sn = ? UNION ALL SELECT id, alarm_no, alarm_content, alarm_time FROM device_alarm WHERE del_flag = 0 AND alarm_time >= ? AND alarm_time <= ? AND mac_sn = ? UNION ALL SELECT id, alarm_no, alarm_content, alarm_time FROM device_alarm WHERE del_flag = 0 AND alarm_time >= ? AND alarm_time <= ? AND mac_sn = ? UNION ALL SELECT id, alarm_no, alarm_content, alarm_time FROM device_alarm WHERE del_flag = 0 AND alarm_time >= ? AND alarm_time <= ? AND mac_sn = ? UNION ALL SELECT id, alarm_no, alarm_content, alarm_time FROM device_alarm WHERE del_flag = 0 AND alarm_time >= ? AND mac_sn = ?) table_count  ### Actual SQL  -- 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]
