INSERT INTO test_mixed2row.t1 (b,c,d,z_comment) VALUES (UUID(), NULL, NULL, 'UUID()') INSERT INTO test_mixed2row.t1 (b,c,d,z_comment) VALUES (CURRENT_USER(), NULL, NULL, 'CURRENT_USER()') INSERT INTO test_mixed2row.t1 (b,c,d,z_comment) VALUES (NULL, ROW_COUNT(), NULL, 'ROW_COUNT()') INSERT INTO test_mixed2row.t1 (b,c,d,z_comment) VALUES (NULL, FOUND_ROWS(), NULL, 'FOUND_ROWS()') INSERT INTO test_mixed2row.t1 (b,c,d,z_comment) VALUES (NULL, TRUNCATE(1000*RAND(),0), NULL, 'RAND()') INSERT INTO test_mixed2row.t1 (b,c,d,z_comment) VALUES (NULL, NULL, SYSDATE(), 'SYSDATE()') INSERT INTO test_mixed2row.t2 SELECT * FROM test_mixed2row.t1 WHERE a > (5*RAND()) UPDATE test_mixed2row.t1 SET b = CURRENT_USER() WHERE a = 1 UPDATE test_mixed2row.t1 SET b = UUID() WHERE a = 2 UPDATE test_mixed2row.t1 SET c = FOUND_ROWS() WHERE a = 3 UPDATE test_mixed2row.t1 SET c = ROW_COUNT() WHERE a = 4 UPDATE test_mixed2row.t1 SET c = TRUNCATE(10000*RAND(),0) WHERE a = 5 UPDATE test_mixed2row.t1 SET d = SYSDATE() WHERE a = 6 DELETE FROM test_mixed2row.t1 WHERE b = CURRENT_USER() DELETE FROM test_mixed2row.t1 WHERE b = UUID() DELETE FROM test_mixed2row.t1 WHERE c = FOUND_ROWS() OR c = ROW_COUNT() DELETE FROM test_mixed2row.t1 WHERE d < SYSDATE() AND a > 3 CALL t3t4_proc INSERT INTO test_mixed2row.t3 VALUES() UPDATE test_mixed2row.t3 SET b = REPEAT('a', TRUNCATE(10*RAND(),0) + 1) DELETE FROM test_mixed2row.t3 WHERE a > 10*RAND()