uchenily commented on issue #70427:
URL: https://github.com/apache/doris/issues/70427#issuecomment-6763893099
Also using Doris 4.1.3, but can't reproduce this issue.
```sql
mysql> select @@version_comment;
+--------------------------------------------+
| @@version_comment |
+--------------------------------------------+
| doris version doris-4.1.3-rc02-50b19c535fa |
+--------------------------------------------+
1 row in set (0.01 sec)
mysql> show variables where Changed = 1;
Empty set (0.05 sec)
mysql> show global variables where Changed = 1;
Empty set (0.09 sec)
mysql> drop table if exists base_series;
Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE `base_series` (
-> `id` varchar(50) NOT NULL,
-> `type` varchar(50) NOT NULL
-> )
-> ENGINE=OLAP
-> UNIQUE KEY(`id`)
-> DISTRIBUTED BY HASH(`id`) BUCKETS 1
-> PROPERTIES (
-> "replication_allocation" = "tag.location.default: 1",
-> "enable_unique_key_merge_on_write" = "true",
-> "store_row_column" = "true",
-> "row_store_page_size" = "4096"
-> );
Query OK, 0 rows affected (0.02 sec)
mysql>
mysql> INSERT INTO base_series (id, type) VALUES ('test_id', 'A');
Query OK, 1 row affected (0.08 sec)
{'label':'label_2ec62fb94304655_a3d19e168be6722b', 'status':'VISIBLE',
'txnId':'30'}
mysql> UPDATE base_series SET type = 'B' WHERE id = 'test_id';
Query OK, 1 row affected (0.11 sec)
{'label':'label_5f1f76cf7bb49a0_a713d5fe6d7a8686', 'status':'VISIBLE',
'txnId':'31'}
mysql>
mysql> SELECT * FROM base_series WHERE id = 'test_id';
+---------+------+
| id | type |
+---------+------+
| test_id | B |
+---------+------+
1 row in set (0.01 sec)
mysql> SELECT * FROM base_series WHERE id = 'test_id' LIMIT 1;
+---------+------+
| id | type |
+---------+------+
| test_id | B |
+---------+------+
1 row in set (0.01 sec
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
