AddColumn adds a column to the specified table.

AssertErr asserts that the given query returns an error during its execution, optionally specifying a type of error.

AssertErrPrepared asserts that the given query returns an error during its execution, optionally specifying a type of error.

AssertErrPreparedWithCtx is the same as AssertErr, but uses the context given instead of creating one from a harness.

AssertErrWithBindings asserts that the given query returns an error during its execution, optionally specifying a type of error.

AssertErrWithCtx is the same as AssertErr, but uses the context given instead of creating one from a harness.

AssertWarningAndTestQuery tests the query and asserts an expected warning code.

CreateVersionedTestData uses the provided harness to create test tables and data for many of the other tests.

NewBaseSession returns a new BaseSession compatible with these tests.

TODO: remove.

NewEngine creates an engine and sets it up for testing using harness, provider, and setup data given.

NewEngineWithProvider returns a new engine with the specified provider.

RunQuery runs the query given and asserts that it doesn't result in an error.

RunQueryTests runs the query tests given after setting up the engine.

RunQueryWithContext runs the query given and asserts that it doesn't result in an error.

RunSetupScripts runs the given setup scripts on the given engine, returning any error.

RunWriteQueryTest runs the specified |tt| WriteQueryTest using the specified harness.

RunWriteQueryTestWithEngine runs the specified |tt| WriteQueryTest, using the specified harness and engine.

todo(max): convert to WriteQueryTest.

todo(max): rewrite into []ScriptTest.

TestColumnAliases exercises the logic for naming and referring to column aliases, and unlike other tests in this file checks that the name of the columns in the result schema is correct.

TestConcurrentTransactions tests that two concurrent processes/transactions can successfully execute without early cancellation.

todo(max): rewrite this using info schema and []QueryTest.

todo(max): rewrite with []ScriptTest.

todo(max): convert to WriteQueryTest.

TestInfoSchema runs tests of the information_schema database.

TestInfoSchemaPrepared runs tests of the information_schema database.

TestJoinQueries tests join queries against a provided harness.

TestJoinQueriesPrepared tests join queries as prepared statements against a provided harness.

todo(max): convert to WriteQueryTest.

TestPreparedQuery runs a prepared query on the engine given and asserts that results are as expected.

TestQueries tests a variety of queries against databases and tables provided by the given harness.

TestQuery runs a query on the engine given and asserts that results are as expected.

TestQuery runs a query on the engine given and asserts that results are as expected.

TestQueryPlan analyzes the query given and asserts that its printed plan matches the expected one.

TestQueryPlans tests generating the correct query plans for various queries using databases and tables provided by the given harness.

TODO: collapse into TestQuery.

TestScript runs the test script given, making any assertions given.

TestScriptPrepared substitutes literals for bindvars, runs the test script given, and makes any assertions given.

TestScriptWithEngine runs the test script given with the engine provided.

TestScriptWithEnginePrepared runs the test script with bindvars substituted for literals using the engine provided.

Runs tests on SHOW TABLE STATUS queries.

TestSpatialQueries tests a variety of geometry queries against databases and tables provided by the given harness.

TestSpatialQueriesPrepared tests a variety of geometry queries against databases and tables provided by the given harness.

TestStatistics tests the statistics from ANALYZE TABLE.

TestStatisticsPrepared tests the statistics from ANALYZE TABLE.

TestTransactionScript runs the test script given, making any assertions given.

TestTransactionScriptWithEngine runs the transaction test script given with the engine provided.

TestVersionedQueries tests a variety of versioned queries.

Tests a variety of queries against databases and tables provided by the given harness.

See WidenRows.

For a variety of reasons, the widths of various primitive types can vary when passed through different SQL queries (and different database implementations).

ClientHarness allows for integrators to test user privileges, as mock clients are used to test functionality.

ForeignKeyHarness is an extension to Harness that lets an integrator test their implementation with foreign keys.

Harness provides a way for database integrators to validate their implementation against the standard set of queries used to develop and test the engine itself.

IndexDriverHarness is an extension to Harness that lets an integrator test their implementation alongside an index driver they provide.

IndexHarness is an extension to Harness that lets an integrator test their implementation with native (table-supplied) indexes.

KeylessTableHarness is an extension to Harness that lets an integrator test their implementation with keyless tables.

SkippingHarness provides a way for integrators to skip tests that are known to be broken.

VersionedDBHarness is an extension to Harness that lets an integrator test their implementation of versioned (AS OF) queries.