Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2
-
None
-
10.2 0992be927e1c686c39c39fe53fc2a7869d55143d
Description
DROP TABLE IF EXISTS t1,t2; |
CREATE TABLE t1 (b CHAR(8)) ENGINE=RocksDB; |
INSERT INTO t1 VALUES ('u'),('c'),('d'),('e'); |
CREATE TABLE t2 (c CHAR(8)) ENGINE=RocksDB; |
INSERT INTO t2 VALUES ('u'),('c'),('d'),('e'); |
UPDATE t1, t2 SET b = 'upd2a', c = 'upd2b' WHERE c < b; |
SELECT * FROM t1; |
SELECT * FROM t2; |
DROP TABLE t1, t2; |
By simply repeating this set of queries over and over I am getting various results, typically in table t1.
This is more common (it is also a correct result):
MariaDB [test]> SELECT * FROM t1;
|
+-------+
|
| b |
|
+-------+
|
| upd2a |
|
| c |
|
| upd2a |
|
| upd2a |
|
+-------+
|
4 rows in set (0.00 sec)
|
This is less common (happens for me every 5-6 tries):
MariaDB [test]> SELECT * FROM t1;
|
+-------+
|
| b |
|
+-------+
|
| upd2a |
|
| c |
|
| d |
|
| e |
|
+-------+
|
4 rows in set (0.00 sec)
|