CREATE TABLE t0 (v1 DOUBLE, v2 ENUM('red', 'green', 'blue'), v3 LONGBLOB);
INSERT INTO t0 (v1, v2, v3) VALUES (-44.335025353769055, 'blue', X'4E0242E7DECCE941B0CB');
INSERT INTO t0 (v1, v2, v3) VALUES (-43.81494557953573, 'blue', X'61E986B6FFEDD8E9C8E2');
INSERT INTO t0 (v1, v2, v3) VALUES (-101.43165015969208, 'red', X'1F2226EA76647D1505D2');
INSERT INTO t0 (v1, v2, v3) VALUES (-1.0261870221955576, 'green', X'BEA23A42DAF4347E604B');
INSERT INTO t0 (v1, v2, v3) VALUES (26.637587799314673, 'red', X'0AB8EF559E8D5FBBD587');
CREATE TABLE t1 (v1 LONGBLOB, v2 VARBINARY(3), v3 TINYBLOB, v4 GEOMETRY, v5 VARBINARY(6), v6 INT);
INSERT INTO t1 (v1, v2, v3, v4, v5, v6) VALUES (X'E51E9C153C5C64881765', X'', X'9D5B8DF1AE7D62FD7A95', ST_GeomFromText('POINT(65.66594525603058 45.46226801032779)'), X'D15D2E23', -1800450643);
INSERT INTO t1 (v1, v2, v3, v4, v5, v6) VALUES (X'67B953A3CC2F9FDE90D1', X'DF', X'F3AC3F792053FAD1FC7D', ST_GeomFromText('POINT(80.21402828911539 32.51604554628904)'), X'83F6EC0363', 1108905056);
CREATE TABLE t2 (v1 BINARY(4), v2 VARBINARY(3));
INSERT INTO t2 (v1, v2) VALUES (X'18', X'60B5');
INSERT INTO t2 (v1, v2) VALUES (X'7920', X'1AE402');
INSERT INTO t2 (v1, v2) VALUES (X'50AB', X'6041');
INSERT INTO t2 (v1, v2) VALUES (X'', X'BA');
INSERT INTO t2 (v1, v2) VALUES (X'EB7339', X'20DF');
CREATE TABLE t0 (v1 DOUBLE, v2 ENUM('red', 'green', 'blue'), v3 LONGBLOB);
CREATE TABLE t1 (v1 LONGBLOB, v2 VARBINARY(3), v3 TINYBLOB, v4 GEOMETRY, v5 VARBINARY(6), v6 INT);
CREATE TABLE t2 (v1 BINARY(4), v2 VARBINARY(3));
INSERT INTO t0 (v1, v2, v3) VALUES (1.5, 'red', 0x123456), (2.5, DEFAULT, NULL);
INSERT INTO t1 (v1, v2, v3, v4, v5, v6) VALUES (0xABCDEF, 0x123, 0x01, POINT(1, 2), 0x123456, 100);
INSERT INTO t2 (v1, v2) VALUES (0x1234, 0x567);
UPDATE t0 SET v1 = DEFAULT, v2 = DEFAULT WHERE v3 IS NOT NULL ORDER BY AVG(v1) IS NULL, v2 COLLATE utf8mb4_general_ci IS UNKNOWN AND v1 > 0 OR v1 < 10;
ANALYZE TABLE t0, t1 UPDATE HISTOGRAM ON v2, v3 WITH 2 BUCKETS DROP HISTOGRAM ON v1, v6;
LOAD DATA CONCURRENT LOCAL INFILE '/tmp/data.csv' INTO TABLE t2 PARTITION (v1, CHARSET_REVERSE_QOUTE_STRING) CHARACTER SET utf8mb4 FIELDS ENCLOSED BY '"' OPTIONALLY ENCLOSED BY '"' LINES STARTING BY 'row' IGNORE 0 LINES SET v1 = !!!(v1) AND v2 = DEFAULT;
SELECT STRAIGHT_JOIN SQL_BIG_RESULT * INTO DUMPFILE '/tmp/output.sql' FROM t0, t1 WHERE t0.v1 > 1.0 AND t1.v6 < 200 GROUP BY t0.v2, t1.v5 HAVING t0.v1 IS NOT NULL ORDER BY t1.v6 ASC, t0.v1 DESC LIMIT 2 OFFSET SUPER;
SHOW CREATE DATABASE test_db;
PURGE BINARY LOGS BEFORE '2024-01-01 00:00:00';
REPAIR TABLE t0, t1, t2 EXTENDED;
UNLOCK TABLES;