You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/12/27 07:07:15 UTC

[GitHub] [shardingsphere] zhougaole opened a new issue #14342: When there is a multiplication operation in the sql query field, the field after the operation will not be parsed

zhougaole opened a new issue #14342:
URL: https://github.com/apache/shardingsphere/issues/14342


   For example:
   SELECT 
       A.VOUCHERLISTID, 
       A.VOUCHERID, 
       A.MATERIALCODE, 
       A.UNITCODE, 
       A.UNITNAME, 
       A.MATERIALNAME, 
       A.EXTTXT, 
       A.NUM, 
       A.PRICE,
       A.PROVIDERID, 
       A.PROVIDERNAME, 
       A.REMARK, 
       A.BIZID, 
       A.BIZLISTID, 
       (A.PRICE*A.NUM) MONEY , 
       A.STOCKID,
       a.seriescodeid, 
       a.sheetlistid, 
       a.degree, 
       a.mssserialno, 
       a.brandname, 
       a.model, 
       a.terminal, 
       a.terminallist,
       A.SCMRETURNSTATUS, 
       a.prdha, 
       a.prdhaname, 
       a.storehouseid, 
       a.storehousename, 
       a.houseareaname, 
       a.houseareaid,
       a.itemid, 
       a.supplierid, 
       a.suppliername, 
       a.itemname,
       a.storelocalid, 
       a.storelocalname, 
       a.stocklistid,
       a.bktype, 
       a.zddlsh, 
       a.listRelationid, 
       a.outwarehouseid, 
       a.ACCOUNTTYPE, 
       a.OWNERTYPE
   FROM 
       test A
   
   Only the (A.PRICE*A.NUM) MONEY field can be parsed, and the following fields will not be parsed
   
   
   
   


-- 
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



[GitHub] [shardingsphere] tuichenchuxin commented on issue #14342: When there is a multiplication operation in the sql query field, the field after the operation will not be parsed

Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #14342:
URL: https://github.com/apache/shardingsphere/issues/14342#issuecomment-1005325520


   what is the mean can't be parsed? I use this sql , It can be parsed.


-- 
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



[GitHub] [shardingsphere] zhougaole commented on issue #14342: When there is a multiplication operation in the sql query field, the field after the operation will not be parsed

Posted by GitBox <gi...@apache.org>.
zhougaole commented on issue #14342:
URL: https://github.com/apache/shardingsphere/issues/14342#issuecomment-1005324860


   
   
       
   
   
   
       font{
           line-height: 1.6;
       }
       ul,ol{
           padding-left: 20px;
           list-style-position: inside;
       }
   
   
       
       
           shardingsphere-jdbc  5.0.0
           
       
           
               
           
       
       
        
       
           
                       ***@***.***
           
       
       
           签名由网易邮箱大师定制
       
    
   
       On 1/5/2022 ***@***.***> wrote: 
   
   
   
   which version have you used?
   
   —Reply to this email directly, view it on GitHub, or unsubscribe.Triage notifications on the go with GitHub Mobile for iOS or Android.
   You are receiving this because you authored the thread.Message ID: ***@***.***>


-- 
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



[GitHub] [shardingsphere] tuichenchuxin commented on issue #14342: When there is a multiplication operation in the sql query field, the field after the operation will not be parsed

Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #14342:
URL: https://github.com/apache/shardingsphere/issues/14342#issuecomment-1005324010


   which version have you used?


-- 
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



[GitHub] [shardingsphere] zhougaole commented on issue #14342: When there is a multiplication operation in the sql query field, the field after the operation will not be parsed

Posted by GitBox <gi...@apache.org>.
zhougaole commented on issue #14342:
URL: https://github.com/apache/shardingsphere/issues/14342#issuecomment-1005330338


   
   
       
   
   
   
       font{
           line-height: 1.6;
       }
       ul,ol{
           padding-left: 20px;
           list-style-position: inside;
       }
   
   
       
       
           
               SQL can be parsed, but the value of the following field is found to be null, in fact there is a value
           
       
       
           
               
           
       
       
        
       
           
                       ***@***.***
           
       
       
           签名由网易邮箱大师定制
       
    
   
       On 1/5/2022 ***@***.***> wrote: 
   
   
   
   what is the mean can't be parsed? I use this sql , It can be parsed.
   
   —Reply to this email directly, view it on GitHub, or unsubscribe.Triage notifications on the go with GitHub Mobile for iOS or Android.
   You are receiving this because you authored the thread.Message ID: ***@***.***>


-- 
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