Update from MySQL 8.4 to MySQL 9.7 by tlmorgan24 · Pull Request #1344 · sqlancer/sqlancer

tlmorgan24

…ng generation (which may implicitly cast to undesirable integer/double)

…L in MySQL despite the behaviour being expected

…MIT and known SELECT/DML error discrepancies

Appends rowId as an ORDER BY tiebreaker to eliminate non-determinism when user columns contain duplicate values (e.g. NULLs) under LIMIT. Introduces isKnownSelectDMLDiscrepancy to suppress false positives from error codes that MySQL legitimately raises in UPDATE/DELETE but not SELECT (or vice versa) due to differing execution paths: WHERE-clause type coercion (1292, 1366), functional index maintenance (1030, 3751), and range optimizer memory limits (3170).

…nerator

MySQL rejects CREATE INDEX with a prefix key part (e.g. c0(3)) on a
column that participates in PARTITION BY KEY(). MySQLIndexGenerator
generated these without checking partition membership and did not
include this error in ExpectedErrors, causing checkException to
escalate it to a fatal AssertionError. Adds the error substring to
the expected errors list.