Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: sqlancer/sqlancer
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: main
Choose a base ref
...
head repository: sqlancer/sqlancer
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: update-mysql-9.7
Choose a head ref
Checking mergeability… Don’t worry, you can still create the pull request.
  • 16 commits
  • 10 files changed
  • 1 contributor

Commits on Jun 17, 2026

  1. Update MySQL CI to MySQL 9.7.0 and JDBC driver to mysql-connector-j 9… 

    ….7.0
    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    d2b7151 View commit details
    Browse the repository at this point in the history

  2. Add 'incorrect FLOAT value' as expected error following update to MyS… 

    …QL 9.7.0
    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    3efe71a View commit details
    Browse the repository at this point in the history

  3. Add 'incorrect DOUBLE value' as expected error following update to My… 

    …SQL 9.7.0
    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    725d31d View commit details
    Browse the repository at this point in the history

  4. Implement workaround for MySQL CREATE INDEX on integer column bug

    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    9dbefd9 View commit details
    Browse the repository at this point in the history

  5. Implement workaround for MySQL DECIMAL UNIQUE bug

    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    2112337 View commit details
    Browse the repository at this point in the history

  6. Make the workaround for MySQL insertion bugs more robust against stri… 

    …ng generation (which may implicitly cast to undesirable integer/double)
    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    f857438 View commit details
    Browse the repository at this point in the history

  7. Fix EXPLAIN format following change of default since previous version… 

    … of MySQL
    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    04b7549 View commit details
    Browse the repository at this point in the history

  8. Refactor workaround logic for MySQL insertion bugs for easier extension

    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    e004455 View commit details
    Browse the repository at this point in the history

  9. Implement workaround for MySQL CREATE INDEX between NULL inserts CERT… 

    … bug
    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    383d79c View commit details
    Browse the repository at this point in the history

  10. Implement workaround for oracles reporting inconsistency with ZEROFIL… 

    …L in MySQL despite the behaviour being expected
    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    2eced5c View commit details
    Browse the repository at this point in the history

  11. Add loop counter for MySQLInsertGenerator regeneration attempts

    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    4fad414 View commit details
    Browse the repository at this point in the history

  12. Format to pass CI tests

    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    5004bc5 View commit details
    Browse the repository at this point in the history

  13. Modify MySQLDQEOracle from TEXT to VARCHAR to prevent MEMORY-engine i… 

    …ncompatibility
    @tlmorgan24
    tlmorgan24 committed Jun 17, 2026
    Configuration menu
    Copy the full SHA
    df5f32e View commit details
    Browse the repository at this point in the history

Commits on Jun 18, 2026

  1. Fix MySQLDQEOracle false positives from non-deterministic ORDER BY LI… 

    …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).
    @tlmorgan24
    tlmorgan24 committed Jun 18, 2026
    Configuration menu
    Copy the full SHA
    f952b25 View commit details
    Browse the repository at this point in the history

Commits on Jun 19, 2026

  1. Move MySQLDQEOracle DML discrepancies into enum for maintainability

    @tlmorgan24
    tlmorgan24 committed Jun 19, 2026
    Configuration menu
    Copy the full SHA
    2d50787 View commit details
    Browse the repository at this point in the history

  2. Ignore expected prefix-key-on-partitioned-table error in MySQLIndexGe… 

    …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.
    @tlmorgan24
    tlmorgan24 committed Jun 19, 2026
    Configuration menu
    Copy the full SHA
    9efa585 View commit details
    Browse the repository at this point in the history
Loading