TDengine
TDengine copied to clipboard
in-clause with parameter placehoder
say: select * from t where name in (?,?,?)
does this kind of parameterized-statement could be used via taos_stmt_xxxx APIs?
Yes, we support this usage.
thx
but seems like the following fails with errmsg "Invalid column name: col_d" in taos_stmt_bind_param_batch
select * from (select col_d from t) x where col_d in (?,?)
please confirm if the problem exists.
btw,
select * from t where col_d in (?, ?)
works just fine.