emqx/changes/ee/fix-11266.en.md

21 lines
594 B
Markdown

Fix and improve support for TDEngine `insert` syntax.
1. Support inserting into multi-table in the template
For example:
`insert into table_1 values (${ts}, '${id}', '${topic}')
table_2 values (${ts}, '${id}', '${topic}')`
2. Support mixing prefixes/suffixes and placeholders in the template
For example:
`insert into table_${topic} values (${ts}, '${id}', '${topic}')`
Note: This is a breaking change. Previously the values of string type were quoted automatically, but now they must be quoted explicitly.
For example:
`insert into table values (${ts}, '${a_string}')`