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.