github.com/square/finch@v0.0.0-20240412205204-6530c03e2b96/benchmarks/jcole-bug-97001/after.yaml (about)

     1  # https://bugs.mysql.com/bug.php?id=97001
     2  # https://blog.jcole.us/2019/09/30/reconsidering-access-paths-for-index-ordering-a-dangerous-optimization-and-a-fix/
     3  # https://hackmysql.com/post/infamous-order-by-limit-query-optimizer-bug/
     4  
     5  stage:
     6    trx:
     7      - file: shift-rows.sql # UPDATE t SET id=id+1000000 WHERE other_id = 555
     8      - file: get-1-row.sql
     9    workload:
    10      - group: shift
    11        trx: [shift-rows.sql]
    12        iter: 1
    13        disable-stats: true
    14  
    15      - group: after
    16        trx: [get-1-row.sql]
    17        iter: 2