warriorsliuz edited a comment on issue #13698:
URL:
https://github.com/apache/shardingsphere/issues/13698#issuecomment-974579266
> java.sql.SQLException:Error while preparing seatment
@strongduanmu ：Intellij detailMessages “Error querying database. Cause:
java.sql.SQLException: Error while preparing statement【SELECT
dd.FullDateAlternateKey dataTime, IFNULL(rr.innum,0) innum, IFNULL(rr.jkl,0.00)
jkl
FROM dimdate dd .....】“
and the SQL is not work，same problem
```
SELECT
site.sitename AS NAME,
IFNULL(rsd.innum, 0) AS VALUE
FROM
`report_site_day` rsd
RIGHT JOIN
(SELECT
sr.id,
sai.sitename
FROM
site_relation sr
INNER JOIN site_all_info sai
ON sr.ChildId = sai.siteid
WHERE sr.parent300 = 'QBGC'
AND sr.parent400 IS NULL
AND sr.parent500 IS NULL
AND sr.parent600 IS NULL
AND sai.type = 700) site
ON site.id = rsd.relationid
AND rsd.datatime = '2021-11-19'
ORDER BY rsd.innum DESC
```
--
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]
