BrokenQueries are queries that are known to be broken in the engine.

BrokenTriggerQueries contains trigger queries that should work but do not yet.

CharsetCollationEngineTests are used to ensure that character sets and collations have the correct behavior over the engine.

CharsetCollationWireTests are used to ensure that character sets and collations have the correct behavior over the wire.

DatabaseCollationWireTests are used to validate that CREATE DATABASE and ALTER DATABASE correctly handle having their character set and collations modified.

DeleteJoinTests contains tests for deletes that explicitly list the table from which to delete, and whose source may contain joined table relations.

DeleteTests contains tests for deletes that implicitly target the single table mentioned in the from clause.

ForeignKeyTests will run the following statements BEFORE the SetUpScript: CREATE TABLE parent (id INT PRIMARY KEY, v1 INT, v2 INT, INDEX v1 (v1), INDEX v2 (v2)); CREATE TABLE child (id INT PRIMARY KEY, v1 INT, v2 INT);.

IntegrationPlanTests is a test of generating the right query plans for more complex queries that closely represent real use cases by customers.

PlanTests is a test of generating the right query plans for different queries in the presence of indexes and other features.

QueryPlanTODOs are queries where the query planner produces a correct (results) but suboptimal plan.

QuickPrivTests are test that specifically attempt to test as many privileges against as many statements as possible, while being as succinct as possible.

TODO: none of these tests insert into tables without primary key columns, which have different semantics for REPLACE INTO queries.

RollbackTriggerTests are trigger tests that require rollback logic to work correctly.

ScriptTests are a set of test scripts to run.

ServerAuthTests test the server authentication system.

These tests return the correct select query answer but the wrong write result.

TypeWireTests are used to ensure that types are properly represented over the wire (vs being directly returned from the engine).

UserPrivTests test the user and privilege systems.

CharsetCollationEngineTest is used to test character sets.

CharsetCollationEngineTestQuery is a query within a CharsetCollationEngineTest.

CharsetCollationWireTest is used to test character sets.

CharsetCollationWireTestQuery is a query within a CharsetCollationWireTest.

GenericErrorQueryTest is a query test that is used to assert an error occurs for some query, without specifying what the error was.

NoopPlaintextPlugin is used to authenticate plaintext user plugins.

QuickPrivilegeTest specifically tests privileges on a predefined user (tester@localhost) using predefined tables and databases.

ServerAuthenticationTest is used to define a test on the server authentication system.

ServerAuthenticationTestAssertion is within a ServerAuthenticationTest to assert functionality.

TransactionTest is a script to test transaction correctness.

TypeWireTest is used to ensure that types are properly represented over the wire (vs being directly returned from the engine).

UserPrivilegeTest is used to define a test on the user and privilege systems.

UserPrivilegeTestAssertion is within a UserPrivilegeTest to assert functionality.

WriteQueryTest is a query test for INSERT, UPDATE, etc.