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