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

supertable creation fails with batchfetch=true but succeeds without this parameter #25603

Open
jsk970 opened this issue Apr 30, 2024 · 3 comments
Labels
bug Something isn't working

Comments

@jsk970
Copy link

jsk970 commented Apr 30, 2024

使用JdbcTemplate创建超级表。
代码片段:
PreparedStatementSetter preparedStatementSetter = ps ->{
ps.setString(1,superTableName);
};
jdbcTemplate.update(sql.toString(), preparedStatementSetter);

image

预编译sql:
CREATE STABLE IF NOT EXISTS ? (ts timestamp,int_v int,float_v float,double_v double,bool_v bool,binary_v binary(1024),extend_json nchar(4000)) tags (device_uuid binary(1024))

版本信息:
服务版本:[tdengine/tdengine:3.2.3.0]
驱动版本:taos-jdbcdriver 3.2.10

异常信息:
Caused by: java.sql.SQLException: (0x2600):syntax error near "? (ts timestamp,int_v int,float_v float,double_v double,bool_v bool,binary_v binary(1024),extend_json nchar(4000)) tags (device_uuid binary(1024))"
at com.taosdata.jdbc.ws.TSWSPreparedStatement.executeUpdate(TSWSPreparedStatement.java:224)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3201)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1091)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3199)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:194)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:256)
at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:867)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
... 44 more

@jsk970 jsk970 added the bug Something isn't working label Apr 30, 2024
@jsk970
Copy link
Author

jsk970 commented Apr 30, 2024

image

@jsk970
Copy link
Author

jsk970 commented Apr 30, 2024

使用官方示例WSParameterBindingFullDemo
针对动态参数表名创建超级表 目前 异常报错 (0x22a):Stmt API usage error
image

@danielclow danielclow changed the title 添加batchfetch=true创建超级表失败,取消后正常 supertable creation fails with batchfetch=true but succeeds without this parameter May 4, 2024
@yu285
Copy link
Contributor

yu285 commented May 24, 2024

收到,我们看下

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

2 participants