queries

package

Go to main page

Versions in this module

v0

v0.19.0

Dec 19, 2024

Changes in this version

+ var CreateTableInSubroutineTests = []ScriptTest

+ var EventCreateInSubroutineTests = []ScriptTest

+ var NumericErrorQueries = []ScriptTest

+ var ProcedureCreateInSubroutineTests = []ScriptTest

+ var TriggerCreateInSubroutineTests = []ScriptTest

+ var VectorFunctionQueries = []ScriptTest

+ var VectorIndexQueries = []ScriptTest

+ var ViewCreateInSubroutineTests = []ScriptTest

type QueryTest

+ Dialect string

type ScriptTest

+ Dialect string

type ScriptTestAssertion

+ Dialect string

type ServerAuthenticationTestAssertion

+ ExpectedAuthPlugin string

type WriteQueryTest

+ Dialect string

+ Skip bool

v0.18.1

Apr 9, 2024

v0.18.0

Feb 28, 2024

Changes in this version

+ var AddColumnScripts = []ScriptTest

+ var AddDropPrimaryKeyScripts = []ScriptTest

+ var BrokenGeneratedColumnTests = []ScriptTest

+ var ChecksOnInsertScripts = []ScriptTest

+ var ColumnDefaultTests = []ScriptTest

+ var CreateDatabaseScripts = []ScriptTest

+ var CreateForeignKeyTests = []ScriptTest

+ var Dec15_1_30 = time.Date(2023, time.December, 15, 1, 30, 0, 0, time.UTC)

+ var DisallowedCheckConstraintsScripts = []ScriptTest

+ var DropCheckConstraintsScripts = []ScriptTest

+ var DropColumnKeylessTablesScripts = []ScriptTest

+ var DropColumnScripts = []ScriptTest

+ var DropDatabaseScripts = []ScriptTest

+ var DropForeignKeyTests = []ScriptTest

+ var GeneratedColumnPlanTests = []QueryPlanTest

+ var ImdbPlanTests = []QueryPlanTest

+ var Jan1Noon = time.Date(2000, time.January, 1, 12, 0, 0, 0, time.UTC)

+ var ModifyColumnScripts = []ScriptTest

+ var Oct2Midnight = time.Date(2020, time.October, 2, 0, 0, 0, 0, time.UTC)

+ var OnUpdateExprScripts = []ScriptTest

+ var RenameColumnScripts = []ScriptTest

+ var RenameTableScripts = []ScriptTest

+ var RowLimitTests = []ScriptTest

+ var SQLLogicJoinTests = []ScriptTest

+ var SQLLogicSubqueryTests = []ScriptTest

+ var StatsIndexTests = []ScriptTest

+ var SysbenchPlanTests = []QueryPlanTest

+ var TpccPlanTests = []QueryPlanTest

+ var TpcdsPlanTests = []QueryPlanTest

+ var TpchPlanTests = []QueryPlanTest

+ var ZeroTime = time.Date(0000, time.January, 1, 0, 0, 0, 0, time.UTC)

type CharsetCollationWireTestQuery

+ ExpectedCollations []sql.CollationID

type QueryPlanTest

+ ExpectedAnalysis string

+ ExpectedEstimates string

+ Skip bool

type QueryTest

+ SkipServerEngine bool

type ScriptTest

+ JoinTypes []plan.JoinType

type ScriptTestAssertion

+ CheckIndexedAccess bool

+ JoinTypes []plan.JoinType

+ NewSession bool

+ SkipResultCheckOnServerEngine bool

+ type StatsPlanTest struct

+ Expected []sql.Row

+ IndexName string

+ Name string

+ Query string

+ SetUpScript []string

type WriteQueryTest

+ SkipServerEngine bool

v0.17.0

Aug 23, 2023

Changes in this version

+ var AlterTableAddAutoIncrementScripts = []ScriptTest

+ var AnsiQuotesTests = []ScriptTest

+ var CallAsofScripts = []ScriptTest

+ var CreateTableAutoIncrementTests = []ScriptTest

+ var FulltextTests = []ScriptTest

+ var GeneratedColumnTests = []ScriptTest

+ var LateralJoinScriptTests = []ScriptTest

+ var MySqlDbTests = []ScriptTest

+ var ParallelismTests = []ParallelismTest

+ var TableFunctionScriptTests = []ScriptTest

+ func MustParseTime(layout, value string) time.Time

+ type ParallelismTest struct

+ Parallel bool

+ Query string

type ScriptTest

+ ExpectedIndexes []string

type ScriptTestAssertion

+ ExpectedIndexes []string

v0.16.0

Jun 29, 2023

Changes in this version

+ var AlterTableScripts = []ScriptTest

+ var CreateTableScriptTests = []ScriptTest

+ var RegexTests = []RegexTest

+ type RegexTest struct

+ Expected []sql.Row

+ ExpectedErr *errors.Kind

+ Query string

v0.15.0

Apr 18, 2023

Changes in this version

+ var BrokenCreateTableQueries = []WriteQueryTest

+ var CollationCoercionSetup = []string

+ var CollationCoercionTests = []CollationCoercionTest

+ var ConvertTests = []struct{ ... }

+ var DeleteJoinTests = []WriteQueryTest

+ var EventTests = []ScriptTest

+ var IndexPrefixQueries = []ScriptTest

+ var IndexQueries = []ScriptTest

+ var InsertDuplicateKeyKeyless = []ScriptTest

+ var JoinScriptTests = []ScriptTest

+ var NoDbProcedureTests = []ScriptTestAssertion

+ var PreparedScriptTests = []ScriptTest

+ var SkippedInfoSchemaScripts = []ScriptTest

+ var SpatialIndexScriptTests = []ScriptTest

+ var ViewScripts = []ScriptTest

+ type CollationCoercionTest struct

+ Coercibility int64

+ Collation sql.CollationID

+ Error bool

+ Parameters string

v0.14.0

Nov 1, 2022

Changes in this version

+ var BlobErrors = []QueryErrorTest

+ var BlobQueries = []QueryTest

+ var BlobUnsupported = []QueryTest

+ var BlobWriteQueries = []WriteQueryTest

+ var BrokenErrorQueries = []QueryErrorTest

+ var BrokenJSONTableScriptTests = []ScriptTest

+ var CharsetCollationEngineTests = []CharsetCollationEngineTest

+ var CharsetCollationWireTests = []CharsetCollationWireTest

+ var ChecksOnUpdateScriptTests = []ScriptTest

+ var DatabaseCollationWireTests = []CharsetCollationWireTest

+ var DerivedTableOuterScopeVisibilityQueries = []ScriptTest

+ var IgnoreWithDuplicateUniqueKeyKeylessScripts = []ScriptTest

+ var IntegrationPlanTests = []QueryPlanTest

+ var JSONTableQueryTests = []QueryTest

+ var JSONTableScriptTests = []ScriptTest

+ var OrderByGroupByScriptTests = []ScriptTest

+ var SkippedInfoSchemaQueries = []QueryTest

+ var SkippedJoinScripts = []ScriptTest

+ var StatisticsQueries = []ScriptTest

+ var UpdateIgnoreScripts = []ScriptTest

+ var UpdateIgnoreTests = []WriteQueryTest

+ type CharsetCollationEngineTest struct

+ Name string

+ Queries []CharsetCollationEngineTestQuery

+ SetUpScript []string

+ type CharsetCollationEngineTestQuery struct

+ ErrKind *errors.Kind

+ Error bool

+ Expected []sql.Row

+ Query string

+ type CharsetCollationWireTest struct

+ Name string

+ Queries []CharsetCollationWireTestQuery

+ SetUpScript []string

+ type CharsetCollationWireTestQuery struct

+ Error bool

+ Expected []sql.Row

+ Query string

+ type NoopPlaintextPlugin struct

+ func (p *NoopPlaintextPlugin) Authenticate(db *mysql_db.MySQLDb, user string, userEntry *mysql_db.User, pass string) (bool, error)

type ScriptTestAssertion

+ ExpectedColumns sql.Schema

+ Skip bool

type ServerAuthenticationTestAssertion

+ ExpectedErrKind *errors.Kind

+ ExpectedErrStr string

v0.12.0

Jun 12, 2022

Changes in this version

+ var BrokenQueries = []QueryTest

+ var BrokenScriptTests = []ScriptTest

+ var BrokenTriggerQueries = []ScriptTest

+ var ColumnAliasQueries = []QueryTest

+ var ComplexIndexQueries = []QueryTest

+ var CreateCheckConstraintsScripts = []ScriptTest

+ var CreateTableQueries = []WriteQueryTest

+ var DateParseQueries = []QueryTest

+ var DeleteErrorTests = []GenericErrorQueryTest

+ var DeleteTests = []WriteQueryTest

+ var ErrorQueries = []QueryErrorTest

+ var ExplodeQueries = []QueryTest

+ var ExternalProcedureTests = []ScriptTest

+ var ForeignKeyTests = []ScriptTest

+ var GenericUpdateErrorTests = []GenericErrorQueryTest

+ var IndexPlanTests = []QueryPlanTest

+ var InfoSchemaQueries = []QueryTest

+ var InfoSchemaScripts = []ScriptTest

+ var InsertBrokenScripts = []ScriptTest

+ var InsertErrorScripts = []ScriptTest

+ var InsertErrorTests = []GenericErrorQueryTest

+ var InsertIgnoreScripts = []ScriptTest

+ var InsertIntoKeylessUnique = []WriteQueryTest

+ var InsertIntoKeylessUniqueError = []GenericErrorQueryTest

+ var InsertQueries = []WriteQueryTest

+ var InsertScripts = []ScriptTest

+ var JoinQueryTests = []QueryTest

+ var JsonScripts = []ScriptTest

+ var KeylessQueries = []QueryTest

+ var LoadDataErrorScripts = []ScriptTest

+ var LoadDataFailingScripts = []ScriptTest

+ var LoadDataScripts = []ScriptTest

+ var NullRangeTests = []QueryTest

+ var OrdinalDDLQueries = []QueryTest

+ var OrdinalDDLWriteQueries = []WriteQueryTest

+ var PlanTests = []QueryPlanTest

+ var ProcedureCallTests = []ScriptTest

+ var ProcedureDropTests = []ScriptTest

+ var ProcedureLogicTests = []ScriptTest

+ var ProcedureShowCreate = []ScriptTest

+ var ProcedureShowStatus = []ScriptTest

+ var QueryPlanTODOs = []QueryPlanTest

+ var QueryTests = []QueryTest

+ var QuickPrivTests = []QuickPrivilegeTest

+ var ReplaceErrorTests = []GenericErrorQueryTest

+ var ReplaceQueries = []WriteQueryTest

+ var RollbackTriggerTests = []ScriptTest

+ var ScriptTests = []ScriptTest

+ var ServerAuthTests = []ServerAuthenticationTest

+ var ShowTableStatusQueries = []QueryTest

+ var SkippedJoinQueryTests = []QueryTest

+ var SkippedUpdateTests = []WriteQueryTest

+ var SpatialDeleteTests = []WriteQueryTest

+ var SpatialInsertQueries = []WriteQueryTest

+ var SpatialQueryTests = []QueryTest

+ var SpatialScriptTests = []ScriptTest

+ var SpatialUpdateTests = []WriteQueryTest

+ var TransactionTests = []TransactionTest

+ var TriggerErrorTests = []ScriptTest

+ var TriggerTests = []ScriptTest

+ var TypeWireTests = []TypeWireTest

+ var UpdateErrorScripts = []ScriptTest

+ var UpdateErrorTests = []QueryErrorTest

+ var UpdateTests = []WriteQueryTest

+ var UserPrivTests = []UserPrivilegeTest

+ var VariableErrorTests = []QueryErrorTest

+ var VariableQueries = []ScriptTest

+ var VersionedQueries = []QueryTest

+ var VersionedScripts = []ScriptTest

+ var VersionedViewTests = []QueryTest

+ var ViewTests = []QueryTest

+ type GenericErrorQueryTest struct

+ Bindings map[string]sql.Expression

+ Name string

+ Query string

+ type QueryErrorTest struct

+ Bindings map[string]sql.Expression

+ ExpectedErr *errors.Kind

+ ExpectedErrStr string

+ Query string

+ type QueryPlanTest struct

+ ExpectedPlan string

+ Query string

+ type QueryTest struct

+ Bindings map[string]sql.Expression

+ Expected []sql.Row

+ ExpectedColumns sql.Schema

+ Query string

+ SkipPrepared bool

+ type QuickPrivilegeTest struct

+ Expected []sql.Row

+ ExpectedErr *errors.Kind

+ ExpectingErr bool

+ Queries []string

+ type ScriptTest struct

+ Assertions []ScriptTestAssertion

+ Expected []sql.Row

+ ExpectedErr *errors.Kind

+ Name string

+ Query string

+ SetUpScript []string

+ SkipPrepared bool

+ type ScriptTestAssertion struct

+ Bindings map[string]sql.Expression

+ Expected []sql.Row

+ ExpectedErr *errors.Kind

+ ExpectedErrStr string

+ ExpectedWarning int

+ ExpectedWarningMessageSubstring string

+ ExpectedWarningsCount int

+ Query string

+ SkipResultsCheck bool

+ type ServerAuthenticationTest struct

+ Assertions []ServerAuthenticationTestAssertion

+ Name string

+ SetUpFunc func(ctx *sql.Context, t *testing.T, engine *sqle.Engine)

+ SetUpScript []string

+ type ServerAuthenticationTestAssertion struct

+ ExpectedErr bool

+ Password string

+ Query string

+ Username string

+ type TransactionTest struct

+ Assertions []ScriptTestAssertion

+ Name string

+ SetUpScript []string

+ type TypeWireTest struct

+ Name string

+ Queries []string

+ Results [][]sql.Row

+ SetUpScript []string

+ type UserPrivilegeTest struct

+ Assertions []UserPrivilegeTestAssertion

+ Name string

+ SetUpScript []string

+ type UserPrivilegeTestAssertion struct

+ Expected []sql.Row

+ ExpectedErr *errors.Kind

+ ExpectedErrStr string

+ Host string

+ Query string

+ User string

+ type WriteQueryTest struct

+ Bindings map[string]sql.Expression

+ ExpectedSelect []sql.Row

+ ExpectedWriteResult []sql.Row

+ SelectQuery string

+ WriteQuery string

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL