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.

CollationCoercionSetup is the setup that is run before every CollationCoercionTest.

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.

EventTests tests any EVENT related behavior.

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);.

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.

SQLLogicJoinTests is a list of all the logic tests that are run against the sql engine.

SQLLogicSubqueryTests is a list of all the logic tests that are run against the sql engine.

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.

CollationCoercionTest is used to test the resulting collation and coercion of a SQL expression.

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.