ApplyBindings replaces all `BindVar` expressions in the given sql.Node with their corresponding sql.Expression entries in the provided |bindings| map.

FindForeignKeyColMapping returns the mapping from a given row to its equivalent index position, based on the matching foreign key columns.

FindIndexWithPrefix returns an index that has the given columns as a prefix.

GetChildParentMapping returns a mapping from the foreign key columns of a child schema to the parent schema.

GetColumnFromIndexExpr returns column from the table given using the expression string given, in the form "table.column".

GetColumnsAndPrepareExpressions extracts the unique columns required by all those expressions and fixes the indexes of the GetFields in the expressions to match a row with only the returned columns in that same order.

GetDatabaseCollation returns a database's collation.

GetDatabaseName attempts to fetch the database name from the node.

GetIndexLookup returns the sql.IndexLookup from an IndexedTableAccess.

GetIsUpdatableFromCreateView returns whether the view is updatable or not.

IsBinary returns whether the node is binary or not.

IsDualTable returns whether the given table is the "dual" table.

IsNoRowNode returns whether this are node interacts only with schema and the catalog, not with any table rows.

IsNullRejecting returns whether the expression always returns false for nil inputs.

IsSessionAutocommit returns true if the current session is using implicit transaction management through autocommit.

IsUnary returns whether the node is unary or not.

NewAlterDatabase returns a new AlterDB.

NewAlterDefaultDrop returns a *AlterDefaultDrop node.

NewAlterDefaultSet returns a *AlterDefaultSet node.

NewBeginEndBlock creates a new *BeginEndBlock node.

NewBlock creates a new *Block node.

NewCachedResults returns a cached results plan Node, which will use a RowCache to cache results generated by Child.RowIter() and return those results for future calls to RowIter.

NewCall returns a *Call node.

NewCaseStatement creates a new *NewCaseStatement or *IfElseBlock node.

NewCheckpointingTableEditorIter is similar to NewTableEditorIter except that it returns an iter that calls BeginStatement and CompleteStatement on |table| after every iter of |wrappedIter|.

NewClose returns a new *Close node.

NewCommit creates a new Commit node.

NewConcat creates a new Concat node with the given children.

NewCreateIndex creates a new CreateIndex node.

NewCreateProcedure returns a *CreateProcedure node.

NewCreateRole returns a new CreateRole node.

NewCreateSavepoint creates a new CreateSavepoint node.

NewCreateTable creates a new CreateTable node.

NewCreateTableLike creates a new CreateTable node for CREATE TABLE LIKE statements.

NewCreateTableSelect create a new CreateTable node for CREATE TABLE [AS] SELECT.

NewCreateView creates a CreateView node with the specified parameters, setting its catalog to nil.

NewDeallocateQuery executes a prepared statement.

NewDeclareCondition returns a *DeclareCondition node.

NewDeclareCursor returns a new *DeclareCursor node.

NewDeclareHandler returns a new *DeclareHandler node.

NewDeclareVariables returns a new *DeclareVariables node.

NewDefaultAuthentication returns the given password with the default authentication method.

NewDeleteFrom creates a DeleteFrom node.

NewDescribe creates a new Describe node.

NewDescribeQuery creates a new DescribeQuery node.

NewDistinct creates a new Distinct node.

NewDropConstraint returns a new DropConstraint node.

NewDropIndex creates a new DropIndex node.

NewDropProcedure creates a new *DropProcedure node.

NewDropRole returns a new DropRole node.

NewDropTable creates a new DropTable node.

NewDropTrigger creates a new NewDropTrigger node for DROP TRIGGER statements.

NewDropUser returns a new DropUser node.

NewDropView creates a DropView node with the specified parameters, setting its catalog to nil.

NewDualSqlTable creates a new Dual table.

NewDummyResolvedDB creates a new dummy database with the given name.

NewExchange creates a new Exchange node.

NewExecuteQuery executes a prepared statement.

NewExistsSubquery created an ExistsSubquery expression.

NewFetch returns a new *Fetch node.

NewFilter creates a new filter node.

NewFilterIter creates a new FilterIter.

NewFlushPrivileges creates a new FlushPrivileges node.

NewGrant returns a new Grant node.

NewGrantProxy returns a new GrantProxy node.

NewGrantRole returns a new GrantRole node.

NewGroupBy creates a new GroupBy node.

NewHashLookup returns a node that performs an indexed hash lookup of cached rows for fulfilling RowIter() calls.

NewHaving creates a new having node.

NewIfConditional creates a new *IfConditional node.

NewIfElse creates a new *IfElseBlock node.

NewIndexedAccessForResolvedTable creates an IndexedTableAccess node if the resolved table embeds an IndexAddressableTable, otherwise returns an error.

NewIndexedInSubqueryFilter returns an IndexedInSubqueryFilter sql.Node.

NewIndexedTableAccess returns a new IndexedTableAccess node that will use the LookupBuilder to build lookups.

NewInsertInto creates an InsertInto node.

NewInSubquery creates an InSubquery expression.

NewIterate returns a new *Iterate node.

NewJSONTable creates a new in memory table from the JSON formatted data, a jsonpath path string, and table spec.

NewLeave returns a new *Leave node.

NewLimit creates a new Limit node with the given size.

NewLockTables creates a new LockTables node.

An LookupJoin is a join that uses index lookups for the secondary table.

NewLoop returns a new *Loop node.

NewMergeJoin returns a node that performs a presorted merge join on two relations.

NaturalJoin is a join that automatically joins by all the columns with the same name.

NewNotInSubquery creates a new NotInSubquery expression.

NewOffset creates a new Offset node.

NewOpen returns a new *Open node.

NewOrderedDistinct creates a new OrderedDistinct node.

NewPrepareQuery creates a new PrepareQuery node.

NewProcedure returns a *Procedure.

NewProcedureResolvedTable returns a *ProcedureResolvedTable.

NewProcessIndexableTable returns a new ProcessIndexableTable.

NewProcessTable returns a new ProcessTable.

NewProject creates a new projection.

NewQueryProcess creates a new QueryProcess node.

NewReleaseSavepoint creates a new ReleaseSavepoint node.

NewRenameTable creates a new RenameTable node.

NewRenameUser returns a new RenameUser node.

NewRepeat returns a new *Repeat node.

NewResolvedDualTable creates a new instance of ResolvedTable.

NewResolvedTable creates a new instance of ResolvedTable.

NewRevoke returns a new Revoke node.

NewRevokeAll returns a new RevokeAll node.

NewRevokeProxy returns a new RevokeProxy node.

NewRevokeRole returns a new RevokeRole node.

NewRollback creates a new Rollback node.

NewRollbackSavepoint creates a new RollbackSavepoint node.

NewRowUpdateResult returns a new RowUpdateResult with the given node to wrap.

NewSet creates a new Set node.

NewShowCharset returns a new ShowCharset reference.

NewShowColumns creates a new ShowColumns node.

NewShowCreateDatabase creates a new ShowCreateDatabase node.

NewShowCreateProcedure creates a new ShowCreateProcedure node for SHOW CREATE PROCEDURE statements.

NewShowCreateTable creates a new ShowCreateTable node.

NewShowCreateTableWithAsOf creates a new ShowCreateTable node for a specific version of a table.

NewShowCreateTrigger creates a new ShowCreateTrigger node for SHOW CREATE TRIGGER statements.

NewShowDatabases creates a new show databases node.

NewShowGrants returns a new ShowGrants node.

NewShowIndexes creates a new ShowIndexes node.

NewShowPrivileges returns a new ShowPrivileges node.

NewShowProcessList creates a new ProcessList node.

NewShowStatus returns a new ShowStatus reference.

NewShowTables creates a new show tables node given a database.

NewShowTableStatus creates a new ShowTableStatus node.

NewShowCreateTrigger creates a new ShowCreateTrigger node for SHOW TRIGGER statements.

NewShowVariables returns a new ShowVariables reference.

NewSignal returns a *Signal node.

NewSignalName returns a *SignalName node.

NewSingleDropView creates a SingleDropView.

NewSort creates a new Sort node.

NewStartTransaction creates a new StartTransaction node.

NewStaticIndexedAccessForResolvedTable creates an IndexedTableAccess node if the resolved table embeds an IndexAddressableTable, otherwise returns an error.

NewStaticIndexedTableAccess returns a new IndexedTableAccess node with the indexlookup given.

NewSubquery returns a new subquery expression.

NewSubqueryAlias creates a new SubqueryAlias node.

NewTableAlias returns a new Table alias node.

NewTableEditorIter returns a new *tableEditorIter by wrapping the given iterator.

NewTopN creates a new TopN node.

NewTransactionCommittingNode returns a TransactionCommittingNode.

TransformedNamedNode is a wrapper for arbitrary logic to represent a table factor assembled from other nodes at some point in by the analyzer.

NewTriggerBeginEndBlock creates a new *TriggerBeginEndBlock node.

NewTruncate creates a Truncate node.

NewUnion creates a new Union node with the given children.

NewUnlockTables returns a new UnlockTables node.

NewUnresolvedTable creates a new Unresolved table.

NewUnresolvedTableAsOf creates a new Unresolved table with an AS OF expression.

NewUpdate creates an Update node.

NewUpdateJoin returns an *UpdateJoin node.

NewUpdateSource returns a new UpdateSource from the node and expressions given.

NewUse creates a new Use node.

NewValues creates a Values node with the given tuples.

NewWhile returns a new *While node.

NillaryNode is a node with no children.

OrderTriggers is a utility method that first sorts triggers into their precedence.

ProjectRow evaluates a set of projections.

ResolveForeignKey verifies the foreign key definition and resolves the foreign key, creating indexes and validating data as necessary.

DualTableName is empty string because no table with empty name can be created.

DynamicPrivilege_ReplicationSlaveAdmin is the dynamic privilege required to execute replication commands.

AntiJoin.

AntiHashJoin.

AntiLookupJoin.

AntiMergeJoin.

CrossJoin.

FullOuterJoin.

GroupByJoin.

HashJoin.

InnerJoin.

LeftOuterJoin.

LeftOuterHashJoin.

LeftOuterLookupJoin.

LeftOuterMergeJoin.

LookupJoin.

MergeJoin.

NaturalJoin.

RightJoin.

RightSemiJoin.

RightSemiLookupJoin.

SemiJoin.

SemiHashJoin.

SemiLookupJoin.

SemiMergeJoin.

UnknownJoin.

ProcedureParamDirection_In means the parameter passes its contained value to the stored procedure.

ProcedureParamDirection_Inout means the parameter passes its contained value to the stored procedure, while also modifying the given variable.

ProcedureParamDirection_Out means the parameter variable will be modified, but will not be read from within the stored procedure.

ProcedureSecurityContext_Definer uses the definer's security context.

ProcedureSecurityContext_Invoker uses the invoker's security context.

DescribeSchema is the schema returned by a DescribeQuery node.

DualTableSchema has a single column with empty name because no table can be created with empty string column name or no alias name can be empty string.

EmptyTable is a node representing an empty table.

ErrCheckViolated is returned when the check constraint evaluates to false.

ErrCreateIndexDuplicateColumn is returned when a CREATE INDEX statement has the same column multiple times.

ErrCreateIndexMissingColumns is returned when a CREATE INDEX statement does not provide any columns.

ErrCreateIndexNonExistentColumn is returned when a key is provided in the index that isn't in the table.

ErrExprTypeNotIndexable is returned when the expression type cannot be indexed, such as BLOB or JSON.

ErrGroupBy is returned when the aggregation is not supported.

ErrIndexActionNotImplemented is returned when the action has not been implemented.

ErrIndexNotAvailable is returned when trying to delete an index that is still not ready for usage.

ErrIndexNotFound is returned when the index cannot be found.

ErrInsertIntoNotSupported is thrown when a table doesn't support inserts.

ErrInvalidIndexDriver is returned when the index driver can't be found.

ErrNoCheckConstraintSupport is returned when the table does not support CONSTRAINT CHECK operations.

ErrNoPartitionable is returned when no Partitionable node is found in the Exchange tree.

ErrNoReplicationController is returned when replication commands are executed without a configured replication controller to dispatch the command to.

ErrNotIndexable is returned when the table is not indexable.

ErrNotPrimaryKeyAlterable is return when a table cannot be determined to be primary key alterable.

ErrTableNotLockable is returned whenever a lockable table can't be found.

ErrTableNotNameable is returned when the table is not nameable.

ErrTableNotValid is returned when the table is not valid.

ErrUnresolvedTable is thrown when a table cannot be resolved.

cc: https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sql-mode-strict The INSERT IGNORE syntax applies to these ignorable errors ER_BAD_NULL_ERROR - yes ER_DUP_ENTRY - yes ER_DUP_ENTRY_WITH_KEY_NAME - Yes ER_DUP_KEY - kinda ER_NO_PARTITION_FOR_GIVEN_VALUE - yes ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT - No ER_NO_REFERENCED_ROW_2 - Yes ER_ROW_DOES_NOT_MATCH_GIVEN_PARTITION_SET - No ER_ROW_IS_REFERENCED_2 - Yes ER_SUBQUERY_NO_1_ROW - yes ER_VIEW_CHECK_FAILED - No.

Nothing is a node that will return no rows.

AccountLimits represents the limits imposed upon an account.

AlterDB alters a database from the Catalog.

AlterDefaultDrop represents the ALTER COLUMN DROP DEFAULT statement.

AlterDefaultSet represents the ALTER COLUMN SET DEFAULT statement.

AuthenticatedUser represents a user with the relevant methods of authentication.

AuthenticationOther is an authentication type that represents plugin types other than "mysql_native_password".

BeginEndBlock represents a BEGIN/END block.

BinaryNode is a node with two children.

Block represents a collection of statements that should be executed in sequence.

CachedResults tees the child node iterator into an in-memory cache for faster subsequent retrieval.

CaseStatement represents CASE statements, which are different from CASE expressions.

ChangeReplicationFilter is a plan node for the "CHANGE REPLICATION FILTER" statement.

ChangeReplicationSource is the plan node for the "CHANGE REPLICATION SOURCE TO" statement.

Close represents the CLOSE statement, which closes a cursor.

Commit commits the changes performed in a transaction.

Concat is a node that returns everything in Left and then everything in Right, but it excludes any results in Right that already appeared in Left.

CreateDB creates an in memory database that lasts the length of the process only.

CreateIndex is a node to create an index.

CreateRole represents the statement CREATE ROLE.

CreateSavepoint creates a savepoint with the given name.

CreateTable is a node describing the creation of some table.

CreateUser represents the statement CREATE USER.

CreateView is a node representing the creation (or replacement) of a view, which is defined by the Child node.

DeallocateQuery is a node that prepares the query.

DeclareCondition represents the DECLARE ..

DeclareCursor represents the DECLARE ..

DeclareHandler represents the DECLARE ..

DeclareVariables represents the DECLARE statement for local variables.

DeleteFrom is a node describing a deletion from some table.

Describe is a node that describes its children.

DescribeQuery returns the description of the query plan.

Distinct is a node that ensures all rows that come from it are unique.

DropConstraint is a temporary node to handle dropping a named constraint on a table.

DropDB removes a databases from the Catalog and updates the active database if it gets removed itself.

DropIndex is a node to drop an index.

DropRole represents the statement DROP ROLE.

DropTable is a node describing dropping one or more tables.

DropUser represents the statement DROP USER.

DropView is a node representing the removal of a list of views, defined by the children member.

DummyResolvedDB is a transient database useful only for instances where a database is not available but required.

Exchange is a node that can parallelize the underlying tree iterating partitions concurrently.

ExecuteQuery is a node that prepares the query.

ExistsSubquery is an expression that checks that a subquery returns a non-empty result set.

ExternalProcedure is the sql.Node container for sql.ExternalStoredProcedureDetails.

Fetch represents the FETCH statement, which handles value acquisition from cursors.

Filter skips rows that don't match a certain expression.

FilterIter is an iterator that filters another iterator and skips rows that don't match the given condition.

FlushPrivileges reads privileges from mysql tables and registers any unregistered privileges found.

ForeignKeyEditor handles update and delete operations, as they may have referential actions on other tables (such as cascading).

ForeignKeyHandler handles all referencing and cascading operations that would need to be executed for an operation on a table.

ForeignKeyRefActionData contains the mapper, editor, and child to parent mapping for processing referential actions.

ForeignKeyReferenceHandler handles references to any parent rows to verify they exist.

ForeignKeyRowMapper takes a source row and returns all matching rows on the contained table according to the row mapping from the source columns to the contained index's columns.

Grant represents the statement GRANT [privilege...] ON [item] TO [user...].

GrantProxy represents the statement GRANT PROXY.

GrantRole represents the statement GRANT [role...] TO [user...].

GrantUserAssumption represents the target user that the user executing the GRANT statement will assume the identity of.

GroupBy groups the rows by some expressions.

Having node is a filter that supports aggregate expressions.

IfConditional represents IF statements only.

IfElseBlock represents IF/ELSE IF/ELSE statements.

IndexedTableAccess represents an indexed lookup of a particular ResolvedTable.

InsertDestination is a wrapper for a table to be used with InsertInto.Destination that allows the schema to be overridden.

InsertInto is the top level node for INSERT INTO statements.

InSubquery is an expression that checks an expression is in the result of a subquery.

Into is a node to wrap the top-level node in a query plan so that any result will set user-defined or others variables given.

Iterate represents the ITERATE statement, which instructs a loop to continue to the next iteration.

JoinNode contains all the common data fields and implements the commom sql.Node getters for all join types.

Leave represents the LEAVE statement, which instructs a loop to end.

Limit is a node that only allows up to N rows to be retrieved.

LockTables will lock tables for the session in which it's executed.

LookupBuilder abstracts secondary table access for an LookupJoin.

Loop represents the LOOP statement, which loops over a set of statements.

Max1Row throws a runtime error if its child (usually subquery) tries to return more than one row.

NamedWindows is a list of WINDOW clause definitions to be resolved and merged into OVER clause sql.Window nodes.

Offset is a node that skips the first N rows.

Open represents the OPEN statement, which opens a cursor.

OrderedDistinct is a Distinct node optimized for sorted row sets.

PasswordOptions states how to handle a user's passwords.

PrepareInfo is the Info for OKResults returned by Update nodes.

PrepareQuery is a node that prepares the query.

Privilege specifies a privilege to be used in a GRANT or REVOKE statement.

PrivilegeLevel defines the level that a privilege applies to.

Procedure is a stored procedure that may be executed using the CALL statement.

ProcedureParam represents the parameter of a stored procedure.

ProcedureResolvedTable represents a resolved SQL Table inside of a stored procedure.

ProcessIndexableTable is a wrapper for sql.Tables inside a query process that support indexing.

ProcessTable is a wrapper for sql.Tables inside a query process.

Project is a projection of certain expression from the children node.

QueryProcess represents a running query process node.

RecursiveCte is defined by two subqueries connected with a union: ex => WITH RECURSIVE [name]([Columns]) as ([Init] UNION [Rec]) ..

RecursiveTable is a thin wrapper around an in memory buffer for use with recursiveCteIter.

ReleaseSavepoint releases the given savepoint.

RenameUser represents the statement RENAME USER.

Repeat represents the REPEAT statement, which loops over a set of statements until the condition is true.

ResetReplica is a plan node for the "RESET REPLICA" statement.

ResolvedTable represents a resolved SQL Table.

Revoke represents the statement REVOKE [privilege...] ON [item] FROM [user...].

RevokeAll represents the statement REVOKE ALL PRIVILEGES.

RevokeProxy represents the statement REVOKE PROXY.

RevokeRole represents the statement REVOKE [role...] FROM [user...].

Rollback undoes the changes performed in the current transaction.

RollbackSavepoint rolls back the current transaction to the given savepoint.

RowUpdateAccumulator wraps other nodes that update tables, and returns their results as OKResults with the appropriate fields set.

SelectSingleRel collapses table and filter nodes into one object.

Set represents a set statement.

ShowColumns shows the columns details of a table.

ShowCreateDatabase returns the SQL for creating a database.

ShowCreateTable is a node that shows the CREATE TABLE statement for a table.

ShowDatabases is a node that shows the databases.

ShowGrants represents the statement SHOW GRANTS.

ShowIndexes is a node that shows the indexes on a table.

ShowPrivileges represents the statement SHOW PRIVILEGES.

ShowProcessList shows a list of all current running processes.

ShowReplicaStatus is the plan node for the "SHOW REPLICA STATUS" statement.

ShowStatus implements the SHOW STATUS MySQL command.

ShowTables is a node that shows the database tables.

ShowTableStatus returns the status of the tables in a database.

ShowVariables is a node that shows the global and session variables.

Signal represents the SIGNAL statement with a set SQLSTATE.

SignalInfo represents a piece of information for a SIGNAL statement.

SignalName represents the SIGNAL statement with a condition name.

Sort is the sort node.

StartReplica is a plan node for the "START REPLICA" statement.

StartTransaction explicitly starts a transaction.

StopReplica is the plan node for the "STOP REPLICA" statement.

Subquery is as an expression whose value is derived by executing a subquery.

SubqueryAlias is a node that gives a subquery a name.

TableAlias is a node that acts as a table with a given name.

TableCopier is a supporting node that allows for the optimization of copying tables.

TableLock is a read or write lock on a table.

TableSpec is a node describing the schema of a table.

TLSOptions represents a user's TLS options.

TopN was a sort node that has a limit.

TransactionCommittingNode implements autocommit logic.

TriggerBeginEndBlock represents a BEGIN/END block specific to TRIGGER execution, which has special considerations regarding logic execution through the RowIter function.

TriggerExecutor is node that wraps, or is wrapped by, an INSERT, UPDATE, or DELETE node to execute defined trigger logic either before or after that operation.

TriggerRollback is a node that wraps the entire tree iff it contains a trigger, creates a savepoint, and performs a rollback if something went wrong during execution.

Truncate is a node describing the deletion of all rows from some table.

UnaryNode is a node that has only one child.

Union is a node that returns everything in Left and then everything in Right.

UnlockTables will release all locks for the current session.

UnresolvedTable is a table that has not been resolved yet but whose name is known.

Update is a node for updating rows on tables.

UpdateInfo is the Info for OKResults returned by Update nodes.

UpdateSource is the source of updates for an Update node.

Use changes the current database.

UserName represents either a user or role name.

Values represents a set of tuples of expressions.

While represents the WHILE statement, which loops over a set of statements while the condition is true.

With is a node to wrap the top-level node in a query plan so that any common table expressions can be applied in analysis.

Authentication represents an authentication method for a user.

BinlogReplicaControllerCommand represents a SQL statement that requires a BinlogReplicaController (e.g.

BlockRowIter is an iterator that produces rows.

DisjointedChildrenNode is a sql.Node that contains multiple, disjointed groupings of child nodes.

RepresentsBlock is an interface that defines whether a node contains a Block node, or contains multiple child statements similar to a block node.

RepresentsLabeledBlock is an interface that defines whether a node represents a Block node, while also carrying a label that may be referenced by statements within the block (such as LEAVE, ITERATE, etc.).

RepresentsScope is an interface that defines whether a node represents a new scope.

Versionable represents a plan that contains an AsOf expression.

AuthenticationMysqlNativePassword is an authentication type that represents "mysql_native_password".

Characteristic represents a characteristic that is defined on either a stored procedure or stored function.

ChildParentMapping is a mapping from the foreign key columns of a child schema to the parent schema.

GrantUserAssumptionType is the assumption type that the user executing the GRANT statement will use.

NamedNotifyFunc is a function to notify about some event with a string argument.

NotifyFunc is a function to notify about some event.

ObjectType represents the object type that the GRANT or REVOKE statement will apply to.

PrivilegeType is the type of privilege that is being granted or revoked.

ProcedureParamDirection represents the use case of the stored procedure parameter.

ProcedureSecurityContext determines whether the stored procedure is executed using the privileges of the definer or the invoker.

ShowWarnings is a node that shows the session warnings.

SignalConditionItemName represents the item name for the set conditions of a SIGNAL statement.