CREATE OR REPLACE TABLE t49 (c1 CHAR, c2 NUMERIC UNSIGNED, PRIMARY KEY (c1, c2)) MAX_ROWS = 3460717693; CREATE TABLE t1 (c1 NUMERIC UNSIGNED, c2 CHARACTER NOT NULL, FOREIGN KEY (c2) REFERENCES t49(c1) MATCH FULL ON UPDATE CASCADE) DELAY_KEY_WRITE = 0; CREATE OR REPLACE INDEX i0 ON t1(c1 DESC) ALGORITHM = COPY; INSERT IGNORE INTO t49 (c1,c2) VALUES ('L',-53); INSERT IGNORE INTO t49 (c1,c2) VALUES ('ohFKa2gNCM',1.009); INSERT HIGH_PRIORITY IGNORE INTO t49 (c1,c2) VALUES ('iE6NtMVyKO',1.009); CREATE OR REPLACE VIEW v1 AS SELECT ca6 AS ca1, ca4 AS ca2, ca5 AS ca3 FROM (SELECT c1 AS ca4, c1 AS ca5, c1 AS ca6 FROM t1) AS ta1 WHERE ((((((BINARY (WEEKOFYEAR('2011-06-18') - FALSE)) NOT IN (SELECT ca9 AS ca7 FROM (SELECT c1 AS ca8, c1 AS ca9, c2 AS ca10 FROM t1) AS ta2)) < ANY (SELECT ca13 AS ca11 FROM (SELECT c2 AS ca12, c2 AS ca13, c1 AS ca14 FROM t49) AS ta3)) IS NOT UNKNOWN) || ((((SELECT ca18 AS ca15 FROM (SELECT c2 AS ca16, c1 AS ca17, c2 AS ca18 FROM t49) AS ta4)) RLIKE (EXISTS (SELECT ca22 AS ca19 FROM (SELECT c2 AS ca20, c2 AS ca21, c2 AS ca22 FROM t49) AS ta5))) BETWEEN ((ca6) IS NOT NULL) AND ((('2021-02' + INTERVAL '19' HOUR)) SOUNDS LIKE ((NOT (EXISTS (SELECT ca24 AS ca23 FROM (SELECT c1 AS ca24, c2 AS ca25, c1 AS ca26 FROM t49) AS ta6) >> ('11:00' + INTERVAL '05 17:18:00' DAY_SECOND)))))))); INSERT INTO t49 (c1,c2) VALUES ('f',1.009); INSERT LOW_PRIORITY IGNORE INTO t49 (c1,c2) VALUES ('C',-9.183); INSERT IGNORE INTO t1 (c1,c2) VALUES (12.991,null); INSERT HIGH_PRIORITY IGNORE INTO t49 (c1,c2) VALUES (null,null); UPDATE IGNORE t49 SET c2 = 1.009, c1 = 'B'; UPDATE LOW_PRIORITY t1 SET c2 = 'X'; UPDATE IGNORE t1 SET c1 = 118, c2 = 'm4OGBvgTLA' WHERE (((((SELECT ca3 AS ca1 FROM (SELECT c2 AS ca3 FROM t1) AS ta1)) IN (SELECT ca6 AS ca5 FROM (SELECT c2 AS ca6, c2 AS ca7, c1 AS ca8 FROM t1) AS ta2)) = SOME (SELECT ca11 AS ca9 FROM (SELECT c2 AS ca10, c2 AS ca11, c1 AS ca12 FROM t49) AS ta3))); UPDATE IGNORE t1 SET c1 = null; INSERT IGNORE INTO t1 (c1,c2) VALUES (-9.183,null); UPDATE LOW_PRIORITY t1 SET c2 = 'W', c1 = 89.1058; DELETE QUICK IGNORE FROM t1; INSERT INTO t49 (c1,c2) VALUES ('D',1.009); UPDATE IGNORE t1 SET c2 = null, c1 = 14338; CREATE OR REPLACE ALGORITHM = TEMPTABLE VIEW v2 AS SELECT ca5 AS ca1, ca6 AS ca2, ca4 AS ca3 FROM (SELECT c1 AS ca4, c2 AS ca5, c2 AS ca6 FROM t1) AS ta1; INSERT LOW_PRIORITY IGNORE INTO t1 (c1,c2) VALUES (51,null); CREATE OR REPLACE VIEW v3 AS SELECT ca6 AS ca1, ca4 AS ca2, ca5 AS ca3 FROM (SELECT c2 AS ca4, c2 AS ca5, c2 AS ca6 FROM t1) AS ta1; INSERT LOW_PRIORITY IGNORE INTO t49 (c1,c2) VALUES (null,-117); UPDATE t1 SET c2 = 'ILy1g5DJWv', c1 = -1389 WHERE (((((('03:53:45' + INTERVAL '59' MINUTE) << (EXISTS (SELECT ca4 AS ca1 FROM (SELECT c1 AS ca2, c1 AS ca3, c1 AS ca4 FROM t49) AS ta1) * EXISTS (SELECT ca7 AS ca5 FROM (SELECT c2 AS ca6, c2 AS ca7, c1 AS ca8 FROM t1) AS ta2)))) NOT LIKE ((EXISTS (SELECT ca11 AS ca9 FROM (SELECT c1 AS ca10, c2 AS ca11, c2 AS ca12 FROM t49) AS ta3) MOD ((SELECT ca16 AS ca13 FROM (SELECT c1 AS ca14, c1 AS ca15, c2 AS ca16 FROM t1) AS ta4) MOD ('11:00' + INTERVAL '2021-02' YEAR_MONTH))))) NOT IN (((((SELECT ca19 AS ca17 FROM (SELECT c1 AS ca18, c1 AS ca19, c1 AS ca20 FROM t1) AS ta5)) SOUNDS LIKE ((TRUE - c2))) IS FALSE)))); INSERT HIGH_PRIORITY IGNORE INTO t1 (c1,c2) VALUES (15.1310,null); INSERT LOW_PRIORITY INTO t49 (c1,c2) VALUES ('P',12.991); UPDATE IGNORE t1 SET c1 = -122; UPDATE t49 SET c1 = 'T', c2 = 7350 WHERE ((! (((BINARY (+ EXISTS (SELECT ca4 AS ca1 FROM (SELECT c2 AS ca2, c1 AS ca3, c1 AS ca4 FROM t1) AS ta1))) NOT BETWEEN (c2) AND ((EXISTS (SELECT ca7 AS ca5 FROM (SELECT c2 AS ca6, c1 AS ca7, c2 AS ca8 FROM t49) AS ta2) + BINARY 14697))) SOUNDS LIKE (((CASE c1 WHEN '2020-11-21 02:23:32' THEN (CAST((DATEDIFF('13:40:51', 'PCCTJJiHS7')) AS DATETIME)) WHEN '2011-06-18' THEN (MICROSECOND('2011-06-18')) END)) NOT IN ((('GPgZb1EJhR') IS NOT TRUE)))))); UPDATE LOW_PRIORITY IGNORE t49 SET c1 = null, c2 = 56.1029 WHERE (((((c1) LIKE (BINARY (SELECT ca3 AS ca1 FROM (SELECT c2 AS ca2, c2 AS ca3, c1 AS ca4 FROM t49) AS ta1))) SOUNDS LIKE ((((c1 & EXISTS (SELECT ca7 AS ca5 FROM (SELECT c2 AS ca6, c1 AS ca7, c1 AS ca8 FROM t1) AS ta2)) + ('54.331414' - INTERVAL '2021-02' YEAR_MONTH))) IN (SELECT ca11 AS ca9 FROM (SELECT c1 AS ca10, c2 AS ca11, c2 AS ca12 FROM t49) AS ta3))) IS NOT TRUE)); UPDATE LOW_PRIORITY IGNORE t49 SET c1 = 'C'; INSERT IGNORE INTO t1 (c1,c2) VALUES (7721,null); UPDATE LOW_PRIORITY t49 SET c2 = null WHERE (((NOT (((c2) NOT REGEXP (EXISTS (SELECT ca3 AS ca1 FROM (SELECT c1 AS ca2, c1 AS ca3, c1 AS ca4 FROM t1) AS ta1))) SOUNDS LIKE ((NAME_CONST('', 167)) IS NULL))) && (NOT (((c2) IS NOT NULL) SOUNDS LIKE (((SELECT ca7 AS ca5 FROM (SELECT c2 AS ca6, c2 AS ca7, c1 AS ca8 FROM t49) AS ta2)) NOT LIKE (FALSE)))))); DELETE LOW_PRIORITY QUICK IGNORE FROM t1; INSERT HIGH_PRIORITY IGNORE INTO t49 (c1,c2) VALUES ('n',85.1421); INSERT IGNORE INTO t49 (c1,c2) VALUES ('h',-9.183); CREATE OR REPLACE FULLTEXT INDEX i1 ON t1(c2 DESC) ALGORITHM DEFAULT; UPDATE IGNORE t49 SET c1 = null; UPDATE t49 SET c2 = 1.009 WHERE ((((CONVERT(c1 USING latin1)) REGEXP ((! (- DAY(c2))))) NOT IN (((((9 - INTERVAL '2021' YEAR)) IN (SELECT ca4 AS ca1 FROM (SELECT c1 AS ca2, c1 AS ca3, c2 AS ca4 FROM t1) AS ta1)))))); INSERT LOW_PRIORITY IGNORE INTO t49 (c1,c2) VALUES ('BRfEFRQCrs',1.009); DELETE QUICK IGNORE FROM t49 ORDER BY c2, c1; CREATE OR REPLACE INDEX i2 ON t1(c2 ASC) ALGORITHM = COPY; INSERT IGNORE INTO t1 (c1,c2) VALUES (-9.183,'fri2k9roHI'); UPDATE LOW_PRIORITY IGNORE t49 SET c2 = 12.991, c1 = 'J'; REPLACE INTO t49 (c1,c2) VALUES ('h',21.0438); UPDATE LOW_PRIORITY IGNORE t49 SET c1 = null; CREATE OR REPLACE VIEW v4 AS SELECT ca5 AS ca1, ca4 AS ca2, ca4 AS ca3 FROM (SELECT c2 AS ca4, c1 AS ca5, c2 AS ca6 FROM t49) AS ta1; INSERT HIGH_PRIORITY IGNORE INTO t49 (c1,c2) VALUES ('6IOiJbHgg2',-44); UPDATE LOW_PRIORITY IGNORE t1 SET c2 = 'wdIH4255d2', c1 = -9.183; INSERT IGNORE INTO t1 (c1,c2) VALUES (5617,null);