You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "LongWangXX (via GitHub)" <gi...@apache.org> on 2024/02/01 06:57:40 UTC
[I] [Bug] sql解析错误， FUNCTION isoc.days_sub does not exist [doris]
LongWangXX opened a new issue, #30692:
URL: https://github.com/apache/doris/issues/30692
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
2.0.3
### What's Wrong?
select DATE_FORMAT(date_sub(curdate(),INTERVAL WEEKDAY(curdate()) +7 DAY),'%Y-%m-%d'), DATE_FORMAT(date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 1 DAY),'%Y-%m-%d');
这条sql这样子跑可执行正确；date_sub可以识别成函数
这样子写则无法识别函数：
SELECT count(distinct iot_id) as sum from mysql_160.isoc.t_isoc_asset_black_list_day_count
where date>=DATE_FORMAT(date_sub(curdate(),INTERVAL WEEKDAY(curdate()) +7 DAY),'%Y-%m-%d')
and date<= DATE_FORMAT(date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 1 DAY),'%Y-%m-%d')
这样子写可以正常执行：
SELECT count(distinct iot_id) as sum from mysql_160.isoc.t_isoc_asset_black_list_day_count
### What You Expected?
解决该问题
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] sql解析错误， FUNCTION isoc.days_sub does not exist [doris]
Posted by "LongWangXX (via GitHub)" <gi...@apache.org>.
LongWangXX commented on issue #30692:
URL: https://github.com/apache/doris/issues/30692#issuecomment-1920750633
@LemonLiTree mysql client still reports an error
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] sql解析错误， FUNCTION isoc.days_sub does not exist [doris]
Posted by "LongWangXX (via GitHub)" <gi...@apache.org>.
LongWangXX commented on issue #30692:
URL: https://github.com/apache/doris/issues/30692#issuecomment-1920740288
@LemonLiTree doris web
mysql client
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] sql解析错误， FUNCTION isoc.days_sub does not exist [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on issue #30692:
URL: https://github.com/apache/doris/issues/30692#issuecomment-1923190960
I will fix it soon
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] sql解析错误， FUNCTION isoc.days_sub does not exist [doris]
Posted by "LemonLiTree (via GitHub)" <gi...@apache.org>.
LemonLiTree commented on issue #30692:
URL: https://github.com/apache/doris/issues/30692#issuecomment-1920734126
Try it in mysql client
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] sql解析错误， FUNCTION isoc.days_sub does not exist [doris]
Posted by "LongWangXX (via GitHub)" <gi...@apache.org>.
LongWangXX commented on issue #30692:
URL: https://github.com/apache/doris/issues/30692#issuecomment-1923197798
@zy-kkk Thanks
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] sql解析错误， FUNCTION isoc.days_sub does not exist [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk closed issue #30692: [Bug] sql解析错误， FUNCTION isoc.days_sub does not exist
URL: https://github.com/apache/doris/issues/30692
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org