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

JDBC配置文件中quote-identifiers设置为false无效 #1917

Closed
allentern opened this issue Aug 21, 2022 · 0 comments
Closed

JDBC配置文件中quote-identifiers设置为false无效 #1917

allentern opened this issue Aug 21, 2022 · 0 comments
Assignees
Labels
status: validating Verify in dev/pre-release enironment. type: bug The behavior is not expected by design.

Comments

@allentern
Copy link

Datart版本号
版本: 1.0.0-rc.1

错误描述
新增JDBC数据源,配置文件中quote-identifiers设置为false无效。

如何重现

  1. Copy TDengineV3 JDBC驱动到lib
  2. 编辑jdbc-driver-ext.yml,新增TDENGINE数据源,按Restful方式配置连接字符串。
  3. quote-identifiers设置为false。
    image
  4. 测试连接OK。
  5. 建立数据视图,SQL方式,OK。
  6. 点“开始分析”,拖动任何字段到维度中,即报错:
    TDengine ERROR (2603): sql: SELECT DATART_VTABLE.tsASts, SUM(DATART_VTABLE.value) AS SUM(value) FROM ( select _wstart as ts, avg(value) AS valuefrom history.t_630102000005_d_C1_D1_p_00060139 where ts >= now -3d interval(5m) ) ASDATART_VTABLEGROUP BYDATART_VTABLE.ts LIMIT 100 OFFSET 0, desc: Table does not exist: DATART_VTABLE
    通过分析测试,发现原因是DATART_VTABLE外面加了引号。
    而quote-identifiers是false。

期望结果
修复问题,quote-identifiers设置为false生效。

截图
image

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

  • OS: datart部署环境:centos7,客户端:win11
  • 数据源: TDengineV3
  • 浏览器: [chrome 103]

其他内容
已群里与开发团队沟通汇报。

@tianlu-root tianlu-root mentioned this issue Aug 22, 2022
@Cuiyansong Cuiyansong added status: validating Verify in dev/pre-release enironment. type: bug The behavior is not expected by design. labels Aug 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status: validating Verify in dev/pre-release enironment. type: bug The behavior is not expected by design.
Projects
None yet
Development

No branches or pull requests

3 participants