You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In random cases the supertable allow to insert duplicated values with the same TS and TAGS.
Expected Behavior
I would like to not have duplicate value for the same TS and TAGS in the supertable.
Screenshots
Table Description
taos> describe boat;
field
type
length
note
ts
TIMESTAMP
8
variable_value_float
FLOAT
4
variable_value_string
VARCHAR
100
original_ts
TIMESTAMP
8
boat_uuid
VARCHAR
36
TAG
variable_name
VARCHAR
50
TAG
Query OK, 6 row(s) in set (0.001758s)
Query of duplicated data
taos> select ts, count(* ) from hdata.boat where boat_uuid="d17bb161-4732-4115-b2c5-7f0bf07e2034" and variable_name= 'Alert 3' and ts < '2023-12-30' and ts > '2023-09-01' group by ts having count(*) > 1;
ts
count(* )
2023-11-20 13:15:50.000000
2
2023-10-23 10:42:35.000000
2
Query OK, 2 row(s) in set (14.703768s)
Detail of duplicated data
taos> select TAGS TBNAME, *, CHAR_LENGTH(variable_name), LENGTH(variable_name), CHAR_LENGTH(boat_uuid), LENGTH(boat_uuid), CHAR_LENGTH(TBNAME), LENGTH(TBNAME) from boat where ts = '2023-11-20 13:15:50.000000' and boat_uuid="d17bb161-4732-4115-b2c5-7f0bf07e2034" and variable_name= 'Alert 3'\G;
Environment (please complete the following information):
OS: 22.04.1-Ubuntu
Memory, CPU, current Disk Space: 16GB, 4vCPU, Available 629G of Space (as main node)
TDengine Version 3.1.1.0
Additional Context
Originally we had a different version of the database (3.0.0) and we updated TDEngine (with a data re-upload) trying to solve the issue.
The text was updated successfully, but these errors were encountered:
Bug Description
In random cases the supertable allow to insert duplicated values with the same TS and TAGS.
Expected Behavior
I would like to not have duplicate value for the same TS and TAGS in the supertable.
Screenshots
Table Description
taos>
describe boat;
Query of duplicated data
taos>
select ts, count(* ) from hdata.boat where boat_uuid="d17bb161-4732-4115-b2c5-7f0bf07e2034" and variable_name= 'Alert 3' and ts < '2023-12-30' and ts > '2023-09-01' group by ts having count(*) > 1;
Detail of duplicated data
taos>
select TAGS TBNAME, *, CHAR_LENGTH(variable_name), LENGTH(variable_name), CHAR_LENGTH(boat_uuid), LENGTH(boat_uuid), CHAR_LENGTH(TBNAME), LENGTH(TBNAME) from boat where ts = '2023-11-20 13:15:50.000000' and boat_uuid="d17bb161-4732-4115-b2c5-7f0bf07e2034" and variable_name= 'Alert 3'\G;
*************************** 1.row ***************************
*************************** 2.row ***************************
Environment (please complete the following information):
Additional Context
Originally we had a different version of the database (3.0.0) and we updated TDEngine (with a data re-upload) trying to solve the issue.
The text was updated successfully, but these errors were encountered: