Building and running tests

Building and running tests

To build and run tests, just run

make

To just just presubmit checks (golint etc):

make check

Running the tests for a package:

make test PKG=./sql

Verbose test output:

make test PKG=./sql TESTFLAGS='-v'

Running a particular test:

make test PKG=./sql TESTS=Logic

Running a subtest of the logic test:

make test PKG=./sql TESTS=Logic TESTFLAGS='-d ../../sqllogictest/test/index/orderby_nosort/10/slt_good_0.test'

Running the sql logic test with the bigtest datasets:

$ cd sql
$ cat Makefile 
.PHONY: bigtest
bigtest:
        go test -bigtest -timeout 24h -run '^TestLogic$$'
$ make

Finding commit that introduced a regression:

$ git bisect start
$ git bisect bad
$ git bisect good 59ee12f
Bisecting: 10 revisions left to test after this (roughly 4 steps)
...
$ git bisect run make test PKG=./sql TESTS=Logic TESTFLAGS='-d ../../sqllogictest/test/index/orderby_nosort/10/slt_good_0.test'
running make test PKG=./sql TESTS=Logic TESTFLAGS=-d ../../sqllogictest/test/index/orderby_nosort/10/slt_good_0.test
   ...

0d1bfc4b92a26f2d6688340b41f9830f4cfc77dc is the first bad commit