github.com/square/finch@v0.0.0-20240412205204-6530c03e2b96/benchmarks/sysbench/trx/read-only.sql (about)

     1  
     2  BEGIN
     3  
     4  -- prepare
     5  -- copies: 10
     6  SELECT c FROM sbtest1 WHERE id=@id
     7  
     8  -- prepare
     9  SELECT c FROM sbtest1 WHERE id BETWEEN @id_100 AND @PREV
    10  
    11  -- prepare
    12  SELECT SUM(k) FROM sbtest1 WHERE id BETWEEN @id_100 AND @PREV
    13  
    14  -- prepare
    15  SELECT c FROM sbtest1 WHERE id BETWEEN @id_100 AND @PREV ORDER BY c
    16  
    17  -- prepare
    18  SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN @id_100 AND @PREV ORDER BY c
    19  
    20  -- prepare
    21  COMMIT