[GitHub] [shardingsphere] warriorsliuz commented on issue #13698: SQL statement is not work

[GitBox <gi...@apache.org>]

warriorsliuz commented 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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org