Example for reducing a TLP query

tlp_reduce.sql

-- How to reduce a TLP query.

-- Below is an example where the TLP predicate is `true`.
-- Put this at the end of a failing tlp.log.
SELECT IF(
  (
    SELECT count(*) FROM (
      -- Count all rows in the table here.
      SELECT count(*) FROM t
      INTERSECT
      -- Count up the three TLP partitions here.
      SELECT count(*) FROM (
        -- TLP partition 1
        SELECT count(*) FROM t WHERE true
        UNION ALL
        -- TLP partition 2
        SELECT count(*) FROM t WHERE NOT true
        UNION ALL
        -- TLP partition 3
        SELECT count(*) FROM t WHERE true IS NULL
      )
    )
  ) = 1, 1, crdb_internal.force_panic('TLP FAILURE')
);

-- Then use the bin/reduce tool to reduce the tlp.log.
--
--   ./bin/reduce -contains 'crdb_internal' -binary ./cockroach -file tlp.log -v -chunk 15
--