Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

变量-上月1日的日期表达式报错 #467

Closed
xuannanxan opened this issue Dec 27, 2021 · 0 comments
Closed

变量-上月1日的日期表达式报错 #467

xuannanxan opened this issue Dec 27, 2021 · 0 comments
Assignees
Labels
bug Something isn't working
Milestone

Comments

@xuannanxan
Copy link

xuannanxan commented Dec 27, 2021

Datart版本号
datart-server-1.0.0-alpha.3-install

错误描述
上月1日的日期表达式报错
TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL- DAY(CURDATE()) + 1 DAY))
DATE_ADD(CURDATE(), INTERVAL- DAY(CURDATE()) + 1 DAY)

如何重现
重现错误的步骤,例如:
1、数据视图
2、配置变量
3、日期
4、表达式
5、输入TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL- DAY(CURDATE()) + 1 DAY))
6、运行提示:未找到有效的查询语句

运行环境详情:(可选,取决于错误发生的具体位置)

  • OS: [centos7]
  • 数据源: [MySQL 5.7]
  • 浏览器: [chrome]

其他内容
改成 date_sub(curdate(),interval 1 day) 可以执行

@scottsut scottsut added the bug Something isn't working label Jan 12, 2022
@scottsut scottsut added this to the beta.1 milestone Jan 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants