My SQL: select * from meters order by ts;
Here's the retult from TDengine-server-3.0.2.0-Linux-x64
| ts | tv | cs | th | report_time | device_no |
|---|---|---|---|---|---|
| 2022-12-02 09:22:22.249 | 30 | 1 | 50 | 2022-12-02 09:22:22.249 | d001 |
| 2022-12-02 09:59:54.664 | 27 | 2 | 20 | 2022-12-02 09:59:54.664 | d001 |
| 2022-12-02 15:55:01.473 | 29 | 3 | 33 | 2022-12-02 15:55:01.473 | d001 |
| 2022-12-02 18:25:01.494 | 15 | 4 | 44 | 2022-12-02 18:25:01.494 | d001 |
| 2022-12-02 18:25:01.559 | 15 | 4 | 44 | 2022-12-02 18:25:01.559 | d002 |
| 2022-12-03 14:36:37.775 | 15 | 4 | 44 | 2022-12-03 14:36:37.775 | d002 |
but the result from TDengine-client-3.0.2.0-Windows-x64 is different.
| ts | tv | cs | th | report_time | device_no |
|---|---|---|---|---|---|
| 2022-12-01 17:22:22.249 | 30 | 1 | 50 | 2022-12-01 17:22:22.249 | d001 |
| 2022-12-01 17:59:54.664 | 27 | 2 | 20 | 2022-12-01 17:59:54.664 | d001 |
| 2022-12-01 23:55:01.473 | 29 | 3 | 33 | 2022-12-01 23:55:01.473 | d001 |
| 2022-12-02 02:25:01.494 | 15 | 4 | 44 | 2022-12-02 02:25:01.494 | d001 |
| 2022-12-02 02:25:01.559 | 15 | 4 | 44 | 2022-12-02 02:25:01.559 | d002 |
| 2022-12-02 22:36:37.775 | 15 | 4 | 44 | 2022-12-02 22:36:37.775 | d002 |
The problem of upgrading to the latest 3.0.2.1 version still exists.
This is init data SQL:
CREATE STABLE meters(
ts timestamp,
tv SMALLINT UNSIGNED,
cs TINYINT UNSIGNED,
th SMALLINT UNSIGNED,
report_time timestamp
) TAGS(
device_no BINARY(60)
);
INSERT INTO d001 USING meters TAGS('d001') VALUES('2022-12-02 09:22:22.249',30,1,50,'2022-12-02 09:22:22.249');
INSERT INTO d001 USING meters TAGS('d001') VALUES('2022-12-02 09:59:54.664',27,2,20,'2022-12-02 09:59:54.664');
INSERT INTO d001 USING meters TAGS('d001') VALUES('2022-12-02 15:55:01.473',29,3,33,'2022-12-02 15:55:01.473');
INSERT INTO d001 USING meters TAGS('d001') VALUES('2022-12-02 18:25:01.494',15,4,44,'2022-12-02 18:25:01.494');
INSERT INTO d002 USING meters TAGS('d002') VALUES('2022-12-02 18:25:01.559',15,4,44,'2022-12-02 18:25:01.559');
INSERT INTO d002 USING meters TAGS('d002') VALUES('2022-12-03 14:36:37.775',15,4,44,'2022-12-03 14:36:37.775');
