2 ms·
How does append (a) map onto actual SQL operations on the given tables? Are the TEXT fields being used as lists? Also… I’ve been issues in MySQL repeatable re
by amluto 3y ago
How does append (a) map onto actual SQL operations on the given tables? Are the TEXT fields being used as lists?
Also… I’ve been issues in MySQL repeatable read mode where a single SELECT, selecting a single row, returned impossible results. I think it was:
SELECT min(value), max(value) FROM table WHERE id = 1;
where id is a primary key. I got two different values for min and max. That was a fun one.
- deleted 3y ago[deleted]
- aphyr 3y agoYup! See https://jepsen.io/analyses/mysql-8.0.34#list-append https://jepsen.io/analyses/mysql-8.0.34#list-append, which also has a link to the code: https://github.com/jepsen-io/mysql/blob/4c239cb5c66a7f1a55fa02ce4c9f43b7a70e9d0b/src/jepsen/mysql/append.clj#L33 https://github.com/jepsen-io/mysql/blob/4c239cb5c66a7f1a55fa... This isn't CONCAT-specific, BTW--we just use CONCAT because it allows us to infer anomalies in linear, rather than exponential time. Same kinds of behaviors manifest with plain old read/write registers.