ast_format_fast.go

// Code generated by ASTFmtGen. DO NOT EDIT.
/*
Copyright 2021 The Vitess Authors.

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/

package sqlparser

import (
	"fmt"

	"vitess.io/vitess/go/sqltypes"
)

// formatFast formats the node.
func (node *Select) formatFast(buf *TrackedBuffer) {
	if node.With != nil {
		node.With.formatFast(buf)
	}
	buf.WriteString("select ")
	node.Comments.formatFast(buf)

	if node.Distinct {
		buf.WriteString(DistinctStr)
	}
	if node.Cache != nil {
		if *node.Cache {
			buf.WriteString(SQLCacheStr)
		} else {
			buf.WriteString(SQLNoCacheStr)
		}
	}
	if node.StraightJoinHint {
		buf.WriteString(StraightJoinHint)
	}
	if node.SQLCalcFoundRows {
		buf.WriteString(SQLCalcFoundRowsStr)
	}

	node.SelectExprs.formatFast(buf)
	buf.WriteString(" from ")

	prefix := ""
	for _, expr := range node.From {
		buf.WriteString(prefix)
		expr.formatFast(buf)
		prefix = ", "
	}

	node.Where.formatFast(buf)

	node.GroupBy.formatFast(buf)

	node.Having.formatFast(buf)

	if node.Windows != nil {
		buf.WriteByte(' ')
		node.Windows.formatFast(buf)
	}

	node.OrderBy.formatFast(buf)

	node.Limit.formatFast(buf)
	buf.WriteString(node.Lock.ToString())
	node.Into.formatFast(buf)

}

// formatFast formats the node.
func (node *CommentOnly) formatFast(buf *TrackedBuffer) {
	for _, comment := range node.Comments {
		buf.WriteString(comment)
	}
}

// formatFast formats the node.
func (node *Union) formatFast(buf *TrackedBuffer) {
	if requiresParen(node.Left) {
		buf.WriteByte('(')
		node.Left.formatFast(buf)
		buf.WriteByte(')')
	} else {
		node.Left.formatFast(buf)
	}

	buf.WriteByte(' ')
	if node.Distinct {
		buf.WriteString(UnionStr)
	} else {
		buf.WriteString(UnionAllStr)
	}
	buf.WriteByte(' ')

	if requiresParen(node.Right) {
		buf.WriteByte('(')
		node.Right.formatFast(buf)
		buf.WriteByte(')')
	} else {
		node.Right.formatFast(buf)
	}

	node.OrderBy.formatFast(buf)
	node.Limit.formatFast(buf)
	buf.WriteString(node.Lock.ToString())
}

// formatFast formats the node.
func (node *VStream) formatFast(buf *TrackedBuffer) {
	buf.WriteString("vstream ")
	node.Comments.formatFast(buf)
	node.SelectExpr.formatFast(buf)
	buf.WriteString(" from ")
	node.Table.formatFast(buf)

}

// formatFast formats the node.
func (node *Stream) formatFast(buf *TrackedBuffer) {
	buf.WriteString("stream ")
	node.Comments.formatFast(buf)
	node.SelectExpr.formatFast(buf)
	buf.WriteString(" from ")
	node.Table.formatFast(buf)

}

// formatFast formats the node.
func (node *Insert) formatFast(buf *TrackedBuffer) {
	switch node.Action {
	case InsertAct:
		buf.WriteString(InsertStr)
		buf.WriteByte(' ')

		node.Comments.formatFast(buf)
		buf.WriteString(node.Ignore.ToString())
		buf.WriteString("into ")

		node.Table.Expr.formatFast(buf)

		node.Partitions.formatFast(buf)

		node.Columns.formatFast(buf)
		buf.WriteByte(' ')

		node.Rows.formatFast(buf)

		node.OnDup.formatFast(buf)

	case ReplaceAct:
		buf.WriteString(ReplaceStr)
		buf.WriteByte(' ')

		node.Comments.formatFast(buf)
		buf.WriteString(node.Ignore.ToString())
		buf.WriteString("into ")

		node.Table.Expr.formatFast(buf)

		node.Partitions.formatFast(buf)

		node.Columns.formatFast(buf)
		buf.WriteByte(' ')

		node.Rows.formatFast(buf)

		node.OnDup.formatFast(buf)

	default:
		buf.WriteString("Unkown Insert Action")
		buf.WriteByte(' ')

		node.Comments.formatFast(buf)
		buf.WriteString(node.Ignore.ToString())
		buf.WriteString("into ")

		node.Table.Expr.formatFast(buf)

		node.Partitions.formatFast(buf)

		node.Columns.formatFast(buf)
		buf.WriteByte(' ')

		node.Rows.formatFast(buf)

		node.OnDup.formatFast(buf)

	}

}

// formatFast formats the node.
func (node *With) formatFast(buf *TrackedBuffer) {
	if len(node.CTEs) == 0 {
		return
	}
	buf.WriteString("with ")

	if node.Recursive {
		buf.WriteString("recursive ")
	}
	ctesLength := len(node.CTEs)
	for i := 0; i < ctesLength-1; i++ {
		node.CTEs[i].formatFast(buf)
		buf.WriteString(", ")
	}
	node.CTEs[ctesLength-1].formatFast(buf)
}

// formatFast formats the node.
func (node *CommonTableExpr) formatFast(buf *TrackedBuffer) {
	node.ID.formatFast(buf)
	node.Columns.formatFast(buf)
	buf.WriteString(" as ")
	node.Subquery.formatFast(buf)
	buf.WriteByte(' ')
}

// formatFast formats the node.
func (node *Update) formatFast(buf *TrackedBuffer) {
	if node.With != nil {
		node.With.formatFast(buf)
	}
	buf.WriteString("update ")
	node.Comments.formatFast(buf)
	buf.WriteString(node.Ignore.ToString())
	node.TableExprs.formatFast(buf)
	buf.WriteString(" set ")

	node.Exprs.formatFast(buf)

	node.Where.formatFast(buf)

	node.OrderBy.formatFast(buf)

	node.Limit.formatFast(buf)

}

// formatFast formats the node.
func (node *Delete) formatFast(buf *TrackedBuffer) {
	if node.With != nil {
		node.With.formatFast(buf)
	}
	buf.WriteString("delete ")
	node.Comments.formatFast(buf)
	if node.Ignore {
		buf.WriteString("ignore ")
	}
	if node.Targets != nil {
		node.Targets.formatFast(buf)
		buf.WriteByte(' ')
	}
	buf.WriteString("from ")
	node.TableExprs.formatFast(buf)
	node.Partitions.formatFast(buf)
	node.Where.formatFast(buf)
	node.OrderBy.formatFast(buf)
	node.Limit.formatFast(buf)
}

// formatFast formats the node.
func (node *Set) formatFast(buf *TrackedBuffer) {
	buf.WriteString("set ")
	node.Comments.formatFast(buf)
	node.Exprs.formatFast(buf)
}

// formatFast formats the node.
func (node *DropDatabase) formatFast(buf *TrackedBuffer) {
	exists := ""
	if node.IfExists {
		exists = "if exists "
	}
	buf.WriteString(DropStr)
	buf.WriteByte(' ')
	node.Comments.formatFast(buf)
	buf.WriteString("database ")
	buf.WriteString(exists)
	node.DBName.formatFast(buf)
}

// formatFast formats the node.
func (node *Flush) formatFast(buf *TrackedBuffer) {
	buf.WriteString(FlushStr)
	if node.IsLocal {
		buf.WriteString(" local")
	}
	if len(node.FlushOptions) != 0 {
		prefix := " "
		for _, option := range node.FlushOptions {
			buf.WriteString(prefix)
			buf.WriteString(option)
			prefix = ", "
		}
	} else {
		buf.WriteString(" tables")
		if len(node.TableNames) != 0 {
			buf.WriteByte(' ')
			node.TableNames.formatFast(buf)
		}
		if node.ForExport {
			buf.WriteString(" for export")
		}
		if node.WithLock {
			buf.WriteString(" with read lock")
		}
	}
}

// formatFast formats the node.
func (node *AlterVschema) formatFast(buf *TrackedBuffer) {
	switch node.Action {
	case CreateVindexDDLAction:
		buf.WriteString("alter vschema create vindex ")
		node.Table.formatFast(buf)
		buf.WriteByte(' ')
		node.VindexSpec.formatFast(buf)
	case DropVindexDDLAction:
		buf.WriteString("alter vschema drop vindex ")
		node.Table.formatFast(buf)
	case AddVschemaTableDDLAction:
		buf.WriteString("alter vschema add table ")
		node.Table.formatFast(buf)
	case DropVschemaTableDDLAction:
		buf.WriteString("alter vschema drop table ")
		node.Table.formatFast(buf)
	case AddColVindexDDLAction:
		buf.WriteString("alter vschema on ")
		node.Table.formatFast(buf)
		buf.WriteString(" add vindex ")
		node.VindexSpec.Name.formatFast(buf)
		buf.WriteString(" (")
		for i, col := range node.VindexCols {
			if i != 0 {
				buf.WriteString(", ")
				col.formatFast(buf)
			} else {
				col.formatFast(buf)
			}
		}
		buf.WriteByte(')')
		if node.VindexSpec.Type.String() != "" {
			buf.WriteByte(' ')
			node.VindexSpec.formatFast(buf)
		}
	case DropColVindexDDLAction:
		buf.WriteString("alter vschema on ")
		node.Table.formatFast(buf)
		buf.WriteString(" drop vindex ")
		node.VindexSpec.Name.formatFast(buf)
	case AddSequenceDDLAction:
		buf.WriteString("alter vschema add sequence ")
		node.Table.formatFast(buf)
	case DropSequenceDDLAction:
		buf.WriteString("alter vschema drop sequence ")
		node.Table.formatFast(buf)
	case AddAutoIncDDLAction:
		buf.WriteString("alter vschema on ")
		node.Table.formatFast(buf)
		buf.WriteString(" add auto_increment ")
		node.AutoIncSpec.formatFast(buf)
	case DropAutoIncDDLAction:
		buf.WriteString("alter vschema on ")
		node.Table.formatFast(buf)
		buf.WriteString(" drop auto_increment ")
		node.AutoIncSpec.formatFast(buf)
	default:
		buf.WriteString(node.Action.ToString())
		buf.WriteString(" table ")
		node.Table.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *AlterMigration) formatFast(buf *TrackedBuffer) {
	buf.WriteString("alter vitess_migration")
	if node.UUID != "" {
		buf.WriteString(" '")
		buf.WriteString(node.UUID)
		buf.WriteByte('\'')
	}
	var alterType string
	switch node.Type {
	case RetryMigrationType:
		alterType = "retry"
	case CleanupMigrationType:
		alterType = "cleanup"
	case LaunchMigrationType:
		alterType = "launch"
	case LaunchAllMigrationType:
		alterType = "launch all"
	case CompleteMigrationType:
		alterType = "complete"
	case CompleteAllMigrationType:
		alterType = "complete all"
	case CancelMigrationType:
		alterType = "cancel"
	case CancelAllMigrationType:
		alterType = "cancel all"
	case ThrottleMigrationType:
		alterType = "throttle"
	case ThrottleAllMigrationType:
		alterType = "throttle all"
	case UnthrottleMigrationType:
		alterType = "unthrottle"
	case UnthrottleAllMigrationType:
		alterType = "unthrottle all"
	}
	buf.WriteByte(' ')
	buf.WriteString(alterType)
	if node.Expire != "" {
		buf.WriteString(" expire '")
		buf.WriteString(node.Expire)
		buf.WriteByte('\'')
	}
	if node.Ratio != nil {
		buf.WriteString(" ratio ")
		node.Ratio.formatFast(buf)
	}
	if node.Shards != "" {
		buf.WriteString(" vitess_shards '")
		buf.WriteString(node.Shards)
		buf.WriteByte('\'')
	}
}

// formatFast formats the node.
func (node *RevertMigration) formatFast(buf *TrackedBuffer) {
	buf.WriteString("revert ")
	node.Comments.formatFast(buf)
	buf.WriteString("vitess_migration '")
	buf.WriteString(node.UUID)
	buf.WriteByte('\'')
}

// formatFast formats the node.
func (node *ShowMigrationLogs) formatFast(buf *TrackedBuffer) {
	buf.WriteString("show vitess_migration '")
	buf.WriteString(node.UUID)
	buf.WriteString("' logs")
}

// formatFast formats the node.
func (node *ShowThrottledApps) formatFast(buf *TrackedBuffer) {
	buf.WriteString("show vitess_throttled_apps")
}

// formatFast formats the node.
func (node *ShowThrottlerStatus) formatFast(buf *TrackedBuffer) {
	buf.WriteString("show vitess_throttler status")
}

// formatFast formats the node.
func (node *OptLike) formatFast(buf *TrackedBuffer) {
	buf.WriteString("like ")
	node.LikeTable.formatFast(buf)
}

// formatFast formats the node.
func (node *PartitionSpec) formatFast(buf *TrackedBuffer) {
	switch node.Action {
	case ReorganizeAction:
		buf.WriteString(ReorganizeStr)
		buf.WriteByte(' ')
		for i, n := range node.Names {
			if i != 0 {
				buf.WriteString(", ")
			}
			n.formatFast(buf)
		}
		buf.WriteString(" into (")
		for i, pd := range node.Definitions {
			if i != 0 {
				buf.WriteString(", ")
			}
			pd.formatFast(buf)
		}
		buf.WriteByte(')')
	case AddAction:
		buf.WriteString(AddStr)
		buf.WriteString(" (")
		node.Definitions[0].formatFast(buf)
		buf.WriteByte(')')
	case DropAction:
		buf.WriteString(DropPartitionStr)
		buf.WriteByte(' ')
		for i, n := range node.Names {
			if i != 0 {
				buf.WriteString(", ")
			}
			n.formatFast(buf)
		}
	case DiscardAction:
		buf.WriteString(DiscardStr)
		buf.WriteByte(' ')
		if node.IsAll {
			buf.WriteString("all")
		} else {
			prefix := ""
			for _, n := range node.Names {
				buf.WriteString(prefix)
				n.formatFast(buf)
				prefix = ", "
			}
		}
		buf.WriteString(" tablespace")
	case ImportAction:
		buf.WriteString(ImportStr)
		buf.WriteByte(' ')
		if node.IsAll {
			buf.WriteString("all")
		} else {
			prefix := ""
			for _, n := range node.Names {
				buf.WriteString(prefix)
				n.formatFast(buf)
				prefix = ", "
			}
		}
		buf.WriteString(" tablespace")
	case TruncateAction:
		buf.WriteString(TruncatePartitionStr)
		buf.WriteByte(' ')
		if node.IsAll {
			buf.WriteString("all")
		} else {
			prefix := ""
			for _, n := range node.Names {
				buf.WriteString(prefix)
				n.formatFast(buf)
				prefix = ", "
			}
		}
	case CoalesceAction:
		buf.WriteString(CoalesceStr)
		buf.WriteByte(' ')
		node.Number.formatFast(buf)
	case ExchangeAction:
		buf.WriteString(ExchangeStr)
		buf.WriteByte(' ')
		node.Names[0].formatFast(buf)
		buf.WriteString(" with table ")
		node.TableName.formatFast(buf)
		if node.WithoutValidation {
			buf.WriteString(" without validation")
		}
	case AnalyzeAction:
		buf.WriteString(AnalyzePartitionStr)
		buf.WriteByte(' ')
		if node.IsAll {
			buf.WriteString("all")
		} else {
			prefix := ""
			for _, n := range node.Names {
				buf.WriteString(prefix)
				n.formatFast(buf)
				prefix = ", "
			}
		}
	case CheckAction:
		buf.WriteString(CheckStr)
		buf.WriteByte(' ')
		if node.IsAll {
			buf.WriteString("all")
		} else {
			prefix := ""
			for _, n := range node.Names {
				buf.WriteString(prefix)
				n.formatFast(buf)
				prefix = ", "
			}
		}
	case OptimizeAction:
		buf.WriteString(OptimizeStr)
		buf.WriteByte(' ')
		if node.IsAll {
			buf.WriteString("all")
		} else {
			prefix := ""
			for _, n := range node.Names {
				buf.WriteString(prefix)
				n.formatFast(buf)
				prefix = ", "
			}
		}
	case RebuildAction:
		buf.WriteString(RebuildStr)
		buf.WriteByte(' ')
		if node.IsAll {
			buf.WriteString("all")
		} else {
			prefix := ""
			for _, n := range node.Names {
				buf.WriteString(prefix)
				n.formatFast(buf)
				prefix = ", "
			}
		}
	case RepairAction:
		buf.WriteString(RepairStr)
		buf.WriteByte(' ')
		if node.IsAll {
			buf.WriteString("all")
		} else {
			prefix := ""
			for _, n := range node.Names {
				buf.WriteString(prefix)
				n.formatFast(buf)
				prefix = ", "
			}
		}
	case RemoveAction:
		buf.WriteString(RemoveStr)
	case UpgradeAction:
		buf.WriteString(UpgradeStr)
	default:
		panic("unimplemented")
	}
}

// formatFast formats the node
func (node *PartitionDefinition) formatFast(buf *TrackedBuffer) {
	buf.WriteString("partition ")
	node.Name.formatFast(buf)
	node.Options.formatFast(buf)
}

// formatFast formats the node
func (node *PartitionDefinitionOptions) formatFast(buf *TrackedBuffer) {
	if node.ValueRange != nil {
		buf.WriteByte(' ')
		node.ValueRange.formatFast(buf)
	}
	if node.Engine != nil {
		buf.WriteByte(' ')
		node.Engine.formatFast(buf)
	}
	if node.Comment != nil {
		buf.WriteString(" comment ")
		node.Comment.formatFast(buf)
	}
	if node.DataDirectory != nil {
		buf.WriteString(" data directory ")
		node.DataDirectory.formatFast(buf)
	}
	if node.IndexDirectory != nil {
		buf.WriteString(" index directory ")
		node.IndexDirectory.formatFast(buf)
	}
	if node.MaxRows != nil {
		buf.WriteString(" max_rows ")
		buf.WriteString(fmt.Sprintf("%d", *node.MaxRows))
	}
	if node.MinRows != nil {
		buf.WriteString(" min_rows ")
		buf.WriteString(fmt.Sprintf("%d", *node.MinRows))
	}
	if node.TableSpace != "" {
		buf.WriteString(" tablespace ")
		buf.WriteString(node.TableSpace)
	}
	if node.SubPartitionDefinitions != nil {
		buf.WriteString(" (")
		node.SubPartitionDefinitions.formatFast(buf)
		buf.WriteByte(')')
	}
}

// formatFast formats the node
func (node SubPartitionDefinitions) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node
func (node *SubPartitionDefinition) formatFast(buf *TrackedBuffer) {
	buf.WriteString("subpartition ")
	node.Name.formatFast(buf)
	node.Options.formatFast(buf)
}

// formatFast formats the node
func (node *SubPartitionDefinitionOptions) formatFast(buf *TrackedBuffer) {
	if node.Engine != nil {
		buf.WriteByte(' ')
		node.Engine.formatFast(buf)
	}
	if node.Comment != nil {
		buf.WriteString(" comment ")
		node.Comment.formatFast(buf)
	}
	if node.DataDirectory != nil {
		buf.WriteString(" data directory ")
		node.DataDirectory.formatFast(buf)
	}
	if node.IndexDirectory != nil {
		buf.WriteString(" index directory ")
		node.IndexDirectory.formatFast(buf)
	}
	if node.MaxRows != nil {
		buf.WriteString(" max_rows ")
		buf.WriteString(fmt.Sprintf("%d", *node.MaxRows))
	}
	if node.MinRows != nil {
		buf.WriteString(" min_rows ")
		buf.WriteString(fmt.Sprintf("%d", *node.MinRows))
	}
	if node.TableSpace != "" {
		buf.WriteString(" tablespace ")
		buf.WriteString(node.TableSpace)
	}
}

// formatFast formats the node
func (node *PartitionValueRange) formatFast(buf *TrackedBuffer) {
	buf.WriteString("values ")
	buf.WriteString(node.Type.ToString())
	if node.Maxvalue {
		buf.WriteString(" maxvalue")
	} else {
		buf.WriteByte(' ')
		node.Range.formatFast(buf)
	}
}

// formatFast formats the node
func (node *PartitionEngine) formatFast(buf *TrackedBuffer) {
	if node.Storage {
		buf.WriteString("storage ")
	}
	buf.WriteString("engine ")
	buf.WriteString(node.Name)
}

// formatFast formats the node.
func (node *PartitionOption) formatFast(buf *TrackedBuffer) {
	buf.WriteString("\npartition by")
	if node.IsLinear {
		buf.WriteString(" linear")
	}

	switch node.Type {
	case HashType:
		buf.WriteString(" hash (")
		node.Expr.formatFast(buf)
		buf.WriteByte(')')
	case KeyType:
		buf.WriteString(" key")
		if node.KeyAlgorithm != 0 {
			buf.WriteString(" algorithm = ")
			buf.WriteString(fmt.Sprintf("%d", node.KeyAlgorithm))
		}
		if len(node.ColList) == 0 {
			buf.WriteString(" ()")
		} else {
			buf.WriteByte(' ')
			node.ColList.formatFast(buf)
		}
	case RangeType, ListType:
		buf.WriteByte(' ')
		buf.WriteString(node.Type.ToString())
		if node.Expr != nil {
			buf.WriteString(" (")
			node.Expr.formatFast(buf)
			buf.WriteByte(')')
		} else {
			buf.WriteString(" columns ")
			node.ColList.formatFast(buf)
		}
	}

	if node.Partitions != -1 {
		buf.WriteString(" partitions ")
		buf.WriteString(fmt.Sprintf("%d", node.Partitions))
	}
	if node.SubPartition != nil {
		buf.WriteByte(' ')
		node.SubPartition.formatFast(buf)
	}
	if node.Definitions != nil {
		buf.WriteString("\n(")
		for i, pd := range node.Definitions {
			if i != 0 {
				buf.WriteString(",\n ")
			}
			pd.formatFast(buf)
		}
		buf.WriteByte(')')
	}
}

// formatFast formats the node.
func (node *SubPartition) formatFast(buf *TrackedBuffer) {
	buf.WriteString("subpartition by")
	if node.IsLinear {
		buf.WriteString(" linear")
	}

	switch node.Type {
	case HashType:
		buf.WriteString(" hash (")
		node.Expr.formatFast(buf)
		buf.WriteByte(')')
	case KeyType:
		buf.WriteString(" key")
		if node.KeyAlgorithm != 0 {
			buf.WriteString(" algorithm = ")
			buf.WriteString(fmt.Sprintf("%d", node.KeyAlgorithm))
		}
		if len(node.ColList) == 0 {
			buf.WriteString(" ()")
		} else {
			buf.WriteByte(' ')
			node.ColList.formatFast(buf)
		}
	}

	if node.SubPartitions != -1 {
		buf.WriteString(" subpartitions ")
		buf.WriteString(fmt.Sprintf("%d", node.SubPartitions))
	}
}

// formatFast formats the node.
func (ts *TableSpec) formatFast(buf *TrackedBuffer) {
	buf.WriteString("(\n")
	for i, col := range ts.Columns {
		if i == 0 {
			buf.WriteByte('\t')
			col.formatFast(buf)
		} else {
			buf.WriteString(",\n\t")
			col.formatFast(buf)
		}
	}
	for _, idx := range ts.Indexes {
		buf.WriteString(",\n\t")
		idx.formatFast(buf)
	}
	for _, c := range ts.Constraints {
		buf.WriteString(",\n\t")
		c.formatFast(buf)
	}

	buf.WriteString("\n)")
	for i, opt := range ts.Options {
		if i != 0 {
			buf.WriteString(",\n ")
		}
		buf.WriteByte(' ')
		buf.WriteString(opt.Name)
		if opt.String != "" {
			if opt.CaseSensitive {
				buf.WriteByte(' ')
				buf.WriteString(opt.String)
			} else {
				buf.WriteByte(' ')
				buf.WriteString(opt.String)
			}
		} else if opt.Value != nil {
			buf.WriteByte(' ')
			opt.Value.formatFast(buf)
		} else {
			buf.WriteString(" (")
			opt.Tables.formatFast(buf)
			buf.WriteByte(')')
		}
	}
	if ts.PartitionOption != nil {
		ts.PartitionOption.formatFast(buf)
	}
}

// formatFast formats the node.
func (col *ColumnDefinition) formatFast(buf *TrackedBuffer) {
	col.Name.formatFast(buf)
	buf.WriteByte(' ')
	col.Type.formatFast(buf)
}

// formatFast returns a canonical string representation of the type and all relevant options
func (ct *ColumnType) formatFast(buf *TrackedBuffer) {
	buf.WriteString(ct.Type)

	if ct.Length != nil && ct.Scale != nil {
		buf.WriteByte('(')
		ct.Length.formatFast(buf)
		buf.WriteByte(',')
		ct.Scale.formatFast(buf)
		buf.WriteByte(')')

	} else if ct.Length != nil {
		buf.WriteByte('(')
		ct.Length.formatFast(buf)
		buf.WriteByte(')')
	}

	if ct.EnumValues != nil {
		buf.WriteString("(")
		for i, enum := range ct.EnumValues {
			if i > 0 {
				buf.WriteString(", ")
			}
			buf.WriteString(enum)
		}
		buf.WriteString(")")
	}

	if ct.Unsigned {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[UNSIGNED])
	}
	if ct.Zerofill {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[ZEROFILL])
	}
	if ct.Charset.Name != "" {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[CHARACTER])
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[SET])
		buf.WriteByte(' ')
		buf.WriteString(ct.Charset.Name)
	}
	if ct.Charset.Binary {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[BINARY])
	}
	if ct.Options != nil {
		if ct.Options.Collate != "" {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[COLLATE])
			buf.WriteByte(' ')
			buf.WriteString(ct.Options.Collate)
		}
		if ct.Options.Null != nil && ct.Options.As == nil {
			if *ct.Options.Null {
				buf.WriteByte(' ')
				buf.WriteString(keywordStrings[NULL])
			} else {
				buf.WriteByte(' ')
				buf.WriteString(keywordStrings[NOT])
				buf.WriteByte(' ')
				buf.WriteString(keywordStrings[NULL])
			}
		}
		if ct.Options.Default != nil {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[DEFAULT])
			if ct.Options.DefaultLiteral {
				buf.WriteByte(' ')
				ct.Options.Default.formatFast(buf)
			} else {
				buf.WriteString(" (")
				ct.Options.Default.formatFast(buf)
				buf.WriteByte(')')
			}
		}
		if ct.Options.OnUpdate != nil {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[ON])
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[UPDATE])
			buf.WriteByte(' ')
			ct.Options.OnUpdate.formatFast(buf)
		}
		if ct.Options.As != nil {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[AS])
			buf.WriteString(" (")
			ct.Options.As.formatFast(buf)
			buf.WriteByte(')')

			if ct.Options.Storage == VirtualStorage {
				buf.WriteByte(' ')
				buf.WriteString(keywordStrings[VIRTUAL])
			} else if ct.Options.Storage == StoredStorage {
				buf.WriteByte(' ')
				buf.WriteString(keywordStrings[STORED])
			}
			if ct.Options.Null != nil {
				if *ct.Options.Null {
					buf.WriteByte(' ')
					buf.WriteString(keywordStrings[NULL])
				} else {
					buf.WriteByte(' ')
					buf.WriteString(keywordStrings[NOT])
					buf.WriteByte(' ')
					buf.WriteString(keywordStrings[NULL])
				}
			}
		}
		if ct.Options.Autoincrement {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[AUTO_INCREMENT])
		}
		if ct.Options.Comment != nil {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[COMMENT_KEYWORD])
			buf.WriteByte(' ')
			ct.Options.Comment.formatFast(buf)
		}
		if ct.Options.Invisible != nil {
			if *ct.Options.Invisible {
				buf.WriteByte(' ')
				buf.WriteString(keywordStrings[INVISIBLE])
			} else {
				buf.WriteByte(' ')
				buf.WriteString(keywordStrings[VISIBLE])
			}
		}
		if ct.Options.Format != UnspecifiedFormat {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[COLUMN_FORMAT])
			buf.WriteByte(' ')
			buf.WriteString(ct.Options.Format.ToString())
		}
		if ct.Options.EngineAttribute != nil {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[ENGINE_ATTRIBUTE])
			buf.WriteByte(' ')
			ct.Options.EngineAttribute.formatFast(buf)
		}
		if ct.Options.SecondaryEngineAttribute != nil {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[SECONDARY_ENGINE_ATTRIBUTE])
			buf.WriteByte(' ')
			ct.Options.SecondaryEngineAttribute.formatFast(buf)
		}
		if ct.Options.KeyOpt == ColKeyPrimary {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[PRIMARY])
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[KEY])
		}
		if ct.Options.KeyOpt == ColKeyUnique {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[UNIQUE])
		}
		if ct.Options.KeyOpt == ColKeyUniqueKey {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[UNIQUE])
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[KEY])
		}
		if ct.Options.KeyOpt == ColKeySpatialKey {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[SPATIAL])
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[KEY])
		}
		if ct.Options.KeyOpt == ColKeyFulltextKey {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[FULLTEXT])
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[KEY])
		}
		if ct.Options.KeyOpt == ColKey {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[KEY])
		}
		if ct.Options.Reference != nil {
			buf.WriteByte(' ')
			ct.Options.Reference.formatFast(buf)
		}
		if ct.Options.SRID != nil {
			buf.WriteByte(' ')
			buf.WriteString(keywordStrings[SRID])
			buf.WriteByte(' ')
			ct.Options.SRID.formatFast(buf)
		}
	}
}

// formatFast formats the node.
func (idx *IndexDefinition) formatFast(buf *TrackedBuffer) {
	idx.Info.formatFast(buf)
	buf.WriteString(" (")
	for i, col := range idx.Columns {
		if i != 0 {
			buf.WriteString(", ")
		}
		if col.Expression != nil {
			buf.WriteByte('(')
			col.Expression.formatFast(buf)
			buf.WriteByte(')')
		} else {
			col.Column.formatFast(buf)
			if col.Length != nil {
				buf.WriteByte('(')
				col.Length.formatFast(buf)
				buf.WriteByte(')')
			}
		}
		if col.Direction == DescOrder {
			buf.WriteString(" desc")
		}
	}
	buf.WriteByte(')')

	for _, opt := range idx.Options {
		buf.WriteByte(' ')
		buf.WriteString(opt.Name)
		if opt.String != "" {
			buf.WriteByte(' ')
			buf.WriteString(opt.String)
		} else if opt.Value != nil {
			buf.WriteByte(' ')
			opt.Value.formatFast(buf)
		}
	}
}

// formatFast formats the node.
func (ii *IndexInfo) formatFast(buf *TrackedBuffer) {
	if !ii.ConstraintName.IsEmpty() {
		buf.WriteString("constraint ")
		ii.ConstraintName.formatFast(buf)
		buf.WriteByte(' ')
	}
	switch ii.Type {
	case IndexTypePrimary:
		buf.WriteString(keywordStrings[PRIMARY])
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[KEY])
		return
	case IndexTypeDefault:
		buf.WriteString(keywordStrings[INDEX])
	case IndexTypeUnique:
		buf.WriteString(keywordStrings[UNIQUE])
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[INDEX])
	case IndexTypeSpatial:
		buf.WriteString(keywordStrings[SPATIAL])
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[INDEX])
	case IndexTypeFullText:
		buf.WriteString(keywordStrings[FULLTEXT])
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[INDEX])
	}
	if !ii.Name.IsEmpty() {
		buf.WriteByte(' ')
		ii.Name.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *AutoIncSpec) formatFast(buf *TrackedBuffer) {
	node.Column.formatFast(buf)
	buf.WriteByte(' ')
	buf.WriteString("using ")
	node.Sequence.formatFast(buf)
}

// formatFast formats the node. The "CREATE VINDEX" preamble was formatted in
// the containing DDL node Format, so this just prints the type, any
// parameters, and optionally the owner
func (node *VindexSpec) formatFast(buf *TrackedBuffer) {
	buf.WriteString("using ")
	node.Type.formatFast(buf)

	numParams := len(node.Params)
	if numParams != 0 {
		buf.WriteString(" with ")
		for i, p := range node.Params {
			if i != 0 {
				buf.WriteString(", ")
			}
			p.formatFast(buf)
		}
	}
}

// formatFast formats the node.
func (node VindexParam) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Key.String())
	buf.WriteByte('=')
	buf.WriteString(node.Val)
}

// formatFast formats the node.
func (c *ConstraintDefinition) formatFast(buf *TrackedBuffer) {
	if !c.Name.IsEmpty() {
		buf.WriteString("constraint ")
		c.Name.formatFast(buf)
		buf.WriteByte(' ')
	}
	c.Details.Format(buf)
}

// formatFast formats the node.
func (a ReferenceAction) formatFast(buf *TrackedBuffer) {
	switch a {
	case Restrict:
		buf.WriteString("restrict")
	case Cascade:
		buf.WriteString("cascade")
	case NoAction:
		buf.WriteString("no action")
	case SetNull:
		buf.WriteString("set null")
	case SetDefault:
		buf.WriteString("set default")
	}
}

// formatFast formats the node.
func (a MatchAction) formatFast(buf *TrackedBuffer) {
	switch a {
	case Full:
		buf.WriteString("full")
	case Simple:
		buf.WriteString("simple")
	case Partial:
		buf.WriteString("partial")
	}
}

// formatFast formats the node.
func (f *ForeignKeyDefinition) formatFast(buf *TrackedBuffer) {
	buf.WriteString("foreign key ")
	f.IndexName.formatFast(buf)
	f.Source.formatFast(buf)
	buf.WriteByte(' ')
	f.ReferenceDefinition.formatFast(buf)
}

// formatFast formats the node.
func (ref *ReferenceDefinition) formatFast(buf *TrackedBuffer) {
	buf.WriteString("references ")
	ref.ReferencedTable.formatFast(buf)
	buf.WriteByte(' ')
	ref.ReferencedColumns.formatFast(buf)
	if ref.Match != DefaultMatch {
		buf.WriteString(" match ")
		ref.Match.formatFast(buf)
	}
	if ref.OnDelete != DefaultAction {
		buf.WriteString(" on delete ")
		ref.OnDelete.formatFast(buf)
	}
	if ref.OnUpdate != DefaultAction {
		buf.WriteString(" on update ")
		ref.OnUpdate.formatFast(buf)
	}
}

// formatFast formats the node.
func (c *CheckConstraintDefinition) formatFast(buf *TrackedBuffer) {
	buf.WriteString("check (")
	c.Expr.formatFast(buf)
	buf.WriteByte(')')
	if !c.Enforced {
		buf.WriteString(" not enforced")
	}
}

// formatFast formats the node.
func (node *Show) formatFast(buf *TrackedBuffer) {
	node.Internal.formatFast(buf)
}

// formatFast formats the node.
func (node *ShowFilter) formatFast(buf *TrackedBuffer) {
	if node == nil {
		return
	}
	if node.Like != "" {
		buf.WriteString(" like ")
		sqltypes.BufEncodeStringSQL(buf.Builder, node.Like)
	} else {
		buf.WriteString(" where ")
		node.Filter.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *Use) formatFast(buf *TrackedBuffer) {
	if node.DBName.v != "" {
		buf.WriteString("use ")
		node.DBName.formatFast(buf)
	} else {
		buf.WriteString("use")
	}
}

// formatFast formats the node.
func (node *Commit) formatFast(buf *TrackedBuffer) {
	buf.WriteString("commit")
}

// formatFast formats the node.
func (node *Begin) formatFast(buf *TrackedBuffer) {
	if node.TxAccessModes == nil {
		buf.WriteString("begin")
		return
	}
	buf.WriteString("start transaction")
	for idx, accessMode := range node.TxAccessModes {
		if idx == 0 {
			buf.WriteByte(' ')
			buf.WriteString(accessMode.ToString())
			continue
		}
		buf.WriteString(", ")
		buf.WriteString(accessMode.ToString())
	}

}

// formatFast formats the node.
func (node *Rollback) formatFast(buf *TrackedBuffer) {
	buf.WriteString("rollback")
}

// formatFast formats the node.
func (node *SRollback) formatFast(buf *TrackedBuffer) {
	buf.WriteString("rollback to ")
	node.Name.formatFast(buf)
}

// formatFast formats the node.
func (node *Savepoint) formatFast(buf *TrackedBuffer) {
	buf.WriteString("savepoint ")
	node.Name.formatFast(buf)
}

// formatFast formats the node.
func (node *Release) formatFast(buf *TrackedBuffer) {
	buf.WriteString("release savepoint ")
	node.Name.formatFast(buf)
}

// formatFast formats the node.
func (node *ExplainStmt) formatFast(buf *TrackedBuffer) {
	format := ""
	switch node.Type {
	case EmptyType:
	case AnalyzeType:
		format = AnalyzeStr + " "
	default:
		format = "format = " + node.Type.ToString() + " "
	}
	buf.WriteString("explain ")
	node.Comments.formatFast(buf)
	buf.WriteString(format)
	node.Statement.formatFast(buf)
}

// formatFast formats the node.
func (node *VExplainStmt) formatFast(buf *TrackedBuffer) {
	buf.WriteString("vexplain ")
	node.Comments.formatFast(buf)
	buf.WriteString(node.Type.ToString())
	buf.WriteByte(' ')
	node.Statement.formatFast(buf)
}

// formatFast formats the node.
func (node *ExplainTab) formatFast(buf *TrackedBuffer) {
	buf.WriteString("explain ")
	node.Table.formatFast(buf)
	if node.Wild != "" {
		buf.WriteByte(' ')
		buf.WriteString(node.Wild)
	}
}

// formatFast formats the node.
func (node *PrepareStmt) formatFast(buf *TrackedBuffer) {
	buf.WriteString("prepare ")
	node.Comments.formatFast(buf)
	node.Name.formatFast(buf)
	buf.WriteString(" from ")
	if node.Statement != nil {
		node.Statement.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *ExecuteStmt) formatFast(buf *TrackedBuffer) {
	buf.WriteString("execute ")
	node.Comments.formatFast(buf)
	node.Name.formatFast(buf)
	if len(node.Arguments) > 0 {
		buf.WriteString(" using ")
	}
	var prefix string
	for _, n := range node.Arguments {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *DeallocateStmt) formatFast(buf *TrackedBuffer) {
	buf.WriteString("deallocate ")
	node.Comments.formatFast(buf)
	buf.WriteString("prepare ")
	node.Name.formatFast(buf)
}

// formatFast formats the node.
func (node *CallProc) formatFast(buf *TrackedBuffer) {
	buf.WriteString("call ")
	node.Name.formatFast(buf)
	buf.WriteByte('(')
	node.Params.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *Analyze) formatFast(buf *TrackedBuffer) {
	buf.WriteString("analyze ")
	if node.IsLocal {
		buf.WriteString("local ")
	}
	buf.WriteString("table ")
	node.Table.formatFast(buf)
}

// formatFast formats the node.
func (node *OtherAdmin) formatFast(buf *TrackedBuffer) {
	buf.WriteString("otheradmin")
}

// formatFast formats the node.
func (node *ParsedComments) formatFast(buf *TrackedBuffer) {
	if node == nil {
		return
	}
	for _, c := range node.comments {
		buf.WriteString(c)
		buf.WriteByte(' ')
	}
}

// formatFast formats the node.
func (node SelectExprs) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *StarExpr) formatFast(buf *TrackedBuffer) {
	if !node.TableName.IsEmpty() {
		node.TableName.formatFast(buf)
		buf.WriteByte('.')
	}
	buf.WriteByte('*')
}

// formatFast formats the node.
func (node *AliasedExpr) formatFast(buf *TrackedBuffer) {
	node.Expr.formatFast(buf)
	if !node.As.IsEmpty() {
		buf.WriteString(" as ")
		node.As.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *Nextval) formatFast(buf *TrackedBuffer) {
	buf.WriteString("next ")
	node.Expr.formatFast(buf)
	buf.WriteString(" values")
}

// formatFast formats the node.
func (node Columns) formatFast(buf *TrackedBuffer) {
	if node == nil {
		return
	}
	buf.WriteByte('(')
	prefix := ""
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node Partitions) formatFast(buf *TrackedBuffer) {
	if node == nil {
		return
	}
	prefix := " partition ("
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node TableExprs) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *AliasedTableExpr) formatFast(buf *TrackedBuffer) {
	node.Expr.formatFast(buf)
	node.Partitions.formatFast(buf)
	if !node.As.IsEmpty() {
		buf.WriteString(" as ")
		node.As.formatFast(buf)
		if len(node.Columns) != 0 {
			node.Columns.formatFast(buf)
		}
	}
	if node.Hints != nil {
		// Hint node provides the space padding.
		node.Hints.formatFast(buf)
	}
}

// formatFast formats the node.
func (node TableNames) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node TableName) formatFast(buf *TrackedBuffer) {
	if node.IsEmpty() {
		return
	}
	if !node.Qualifier.IsEmpty() {
		node.Qualifier.formatFast(buf)
		buf.WriteByte('.')
	}
	node.Name.formatFast(buf)
}

// formatFast formats the node.
func (node *ParenTableExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteByte('(')
	node.Exprs.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *JoinCondition) formatFast(buf *TrackedBuffer) {
	if node == nil {
		return
	}
	if node.On != nil {
		buf.WriteString(" on ")
		node.On.formatFast(buf)
	}
	if node.Using != nil {
		buf.WriteString(" using ")
		node.Using.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *JoinTableExpr) formatFast(buf *TrackedBuffer) {
	node.LeftExpr.formatFast(buf)
	buf.WriteByte(' ')
	buf.WriteString(node.Join.ToString())
	buf.WriteByte(' ')
	node.RightExpr.formatFast(buf)
	node.Condition.formatFast(buf)
}

// formatFast formats the node.
func (node IndexHints) formatFast(buf *TrackedBuffer) {
	for _, n := range node {
		n.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *IndexHint) formatFast(buf *TrackedBuffer) {
	buf.WriteByte(' ')
	buf.WriteString(node.Type.ToString())
	buf.WriteString("index ")
	if node.ForType != NoForType {
		buf.WriteString("for ")
		buf.WriteString(node.ForType.ToString())
		buf.WriteByte(' ')
	}
	if len(node.Indexes) == 0 {
		buf.WriteString("()")
	} else {
		prefix := "("
		for _, n := range node.Indexes {
			buf.WriteString(prefix)
			n.formatFast(buf)
			prefix = ", "
		}
		buf.WriteByte(')')
	}
}

// formatFast formats the node.
func (node *Where) formatFast(buf *TrackedBuffer) {
	if node == nil || node.Expr == nil {
		return
	}
	buf.WriteByte(' ')
	buf.WriteString(node.Type.ToString())
	buf.WriteByte(' ')
	node.Expr.formatFast(buf)
}

// formatFast formats the node.
func (node Exprs) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *AndExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Left, true)
	buf.WriteString(" and ")
	buf.printExpr(node, node.Right, false)
}

// formatFast formats the node.
func (node *OrExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Left, true)
	buf.WriteString(" or ")
	buf.printExpr(node, node.Right, false)
}

// formatFast formats the node.
func (node *XorExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Left, true)
	buf.WriteString(" xor ")
	buf.printExpr(node, node.Right, false)
}

// formatFast formats the node.
func (node *NotExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("not ")
	buf.printExpr(node, node.Expr, true)
}

// formatFast formats the node.
func (node *ComparisonExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Left, true)
	buf.WriteByte(' ')
	buf.WriteString(node.Operator.ToString())
	buf.WriteByte(' ')
	buf.printExpr(node, node.Right, false)
	if node.Escape != nil {
		buf.WriteString(" escape ")
		buf.printExpr(node, node.Escape, true)
	}
}

// formatFast formats the node.
func (node *BetweenExpr) formatFast(buf *TrackedBuffer) {
	if node.IsBetween {
		buf.printExpr(node, node.Left, true)
		buf.WriteString(" between ")
		buf.printExpr(node, node.From, true)
		buf.WriteString(" and ")
		buf.printExpr(node, node.To, false)
	} else {
		buf.printExpr(node, node.Left, true)
		buf.WriteString(" not between ")
		buf.printExpr(node, node.From, true)
		buf.WriteString(" and ")
		buf.printExpr(node, node.To, false)
	}
}

// formatFast formats the node.
func (node *IsExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Left, true)
	buf.WriteByte(' ')
	buf.WriteString(node.Right.ToString())
}

// formatFast formats the node.
func (node *ExistsExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("exists ")
	buf.printExpr(node, node.Subquery, true)
}

// formatFast formats the node.
func (node *AssignmentExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Left, true)
	buf.WriteString(" := ")
	buf.printExpr(node, node.Right, false)
}

// formatFast formats the node.
func (node *Literal) formatFast(buf *TrackedBuffer) {
	switch node.Type {
	case StrVal:
		sqltypes.MakeTrusted(sqltypes.VarBinary, node.Bytes()).EncodeSQL(buf)
	case IntVal, FloatVal, DecimalVal, HexNum:
		buf.WriteString(node.Val)
	case HexVal:
		buf.WriteString("X'")
		buf.WriteString(node.Val)
		buf.WriteByte('\'')
	case BitVal:
		buf.WriteString("B'")
		buf.WriteString(node.Val)
		buf.WriteByte('\'')
	case DateVal:
		buf.WriteString("date'")
		buf.WriteString(node.Val)
		buf.WriteByte('\'')
	case TimeVal:
		buf.WriteString("time'")
		buf.WriteString(node.Val)
		buf.WriteByte('\'')
	case TimestampVal:
		buf.WriteString("timestamp'")
		buf.WriteString(node.Val)
		buf.WriteByte('\'')
	default:
		panic("unexpected")
	}
}

// formatFast formats the node.
func (node *Argument) formatFast(buf *TrackedBuffer) {
	buf.WriteArg(":", node.Name)
	if node.Type >= 0 {
		// For bind variables that are statically typed, emit their type as an adjacent comment.
		// This comment will be ignored by older versions of Vitess (and by MySQL) but will provide
		// type safety when using the query as a cache key.
		buf.WriteString(" /* ")
		buf.WriteString(node.Type.String())
		buf.WriteString(" */")
	}
}

// formatFast formats the node.
func (node *NullVal) formatFast(buf *TrackedBuffer) {
	buf.WriteString("null")
}

// formatFast formats the node.
func (node BoolVal) formatFast(buf *TrackedBuffer) {
	if node {
		buf.WriteString("true")
	} else {
		buf.WriteString("false")
	}
}

// formatFast formats the node.
func (node *ColName) formatFast(buf *TrackedBuffer) {
	if !node.Qualifier.IsEmpty() {
		node.Qualifier.formatFast(buf)
		buf.WriteByte('.')
	}
	node.Name.formatFast(buf)
}

// formatFast formats the node.
func (node ValTuple) formatFast(buf *TrackedBuffer) {
	buf.WriteByte('(')
	Exprs(node).formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *Subquery) formatFast(buf *TrackedBuffer) {
	buf.WriteByte('(')
	node.Select.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *DerivedTable) formatFast(buf *TrackedBuffer) {
	if node.Lateral {
		buf.WriteString("lateral ")
	}
	buf.WriteByte('(')
	node.Select.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node ListArg) formatFast(buf *TrackedBuffer) {
	buf.WriteArg("::", string(node))
}

// formatFast formats the node.
func (node *BinaryExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Left, true)
	buf.WriteByte(' ')
	buf.WriteString(node.Operator.ToString())
	buf.WriteByte(' ')
	buf.printExpr(node, node.Right, false)
}

// formatFast formats the node.
func (node *UnaryExpr) formatFast(buf *TrackedBuffer) {
	if _, unary := node.Expr.(*UnaryExpr); unary {
		// They have same precedence so parenthesis is not required.
		buf.WriteString(node.Operator.ToString())
		buf.WriteByte(' ')
		buf.printExpr(node, node.Expr, true)
		return
	}
	buf.WriteString(node.Operator.ToString())
	buf.printExpr(node, node.Expr, true)
}

// formatFast formats the node.
func (node *IntroducerExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.CharacterSet)
	buf.WriteByte(' ')
	buf.printExpr(node, node.Expr, true)
}

// formatFast formats the node.
func (node *TimestampDiffExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("timestampdiff(")
	buf.WriteString(node.Unit.ToString())
	buf.WriteString(", ")
	buf.printExpr(node, node.Expr1, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Expr2, true)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *ExtractFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("extract(")
	buf.WriteString(node.IntervalType.ToString())
	buf.WriteString(" from ")
	buf.printExpr(node, node.Expr, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *RegexpInstrExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("regexp_instr(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Pattern, true)
	if node.Position != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Position, true)
	}
	if node.Occurrence != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Occurrence, true)
	}
	if node.ReturnOption != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.ReturnOption, true)
	}
	if node.MatchType != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.MatchType, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *RegexpLikeExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("regexp_like(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Pattern, true)
	if node.MatchType != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.MatchType, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *RegexpReplaceExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("regexp_replace(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Pattern, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Repl, true)
	if node.Position != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Position, true)
	}
	if node.Occurrence != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Occurrence, true)
	}
	if node.MatchType != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.MatchType, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *RegexpSubstrExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("regexp_substr(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Pattern, true)
	if node.Position != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Position, true)
	}
	if node.Occurrence != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Occurrence, true)
	}
	if node.MatchType != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.MatchType, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *IntervalDateExpr) formatFast(buf *TrackedBuffer) {
	switch node.Syntax {
	case IntervalDateExprAdddate, IntervalDateExprSubdate:
		if node.Unit == IntervalNone {
			buf.WriteString(node.FnName())
			buf.WriteByte('(')
			buf.printExpr(node, node.Date, true)
			buf.WriteString(", ")
			buf.printExpr(node, node.Interval, true)
			buf.WriteByte(')')
			return
		}
		fallthrough
	case IntervalDateExprDateAdd, IntervalDateExprDateSub:
		buf.WriteString(node.FnName())
		buf.WriteByte('(')
		buf.printExpr(node, node.Date, true)
		buf.WriteString(", interval ")
		buf.printExpr(node, node.Interval, true)
		buf.WriteByte(' ')
		buf.WriteString(node.Unit.ToString())
		buf.WriteByte(')')
	case IntervalDateExprBinaryAdd:
		buf.printExpr(node, node.Date, true)
		buf.WriteString(" + interval ")
		buf.printExpr(node, node.Interval, false)
		buf.WriteByte(' ')
		buf.WriteString(node.Unit.ToString())
	case IntervalDateExprBinaryAddLeft:
		buf.WriteString("interval ")
		buf.printExpr(node, node.Interval, true)
		buf.WriteByte(' ')
		buf.WriteString(node.Unit.ToString())
		buf.WriteString(" + ")
		buf.printExpr(node, node.Date, false)
	case IntervalDateExprBinarySub:
		buf.printExpr(node, node.Date, true)
		buf.WriteString(" - interval ")
		buf.printExpr(node, node.Interval, false)
		buf.WriteByte(' ')
		buf.WriteString(node.Unit.ToString())
	case IntervalDateExprTimestampadd:
		buf.WriteString("timestampadd(")
		buf.WriteString(node.Unit.ToString())
		buf.WriteString(", ")
		buf.printExpr(node, node.Interval, true)
		buf.WriteString(", ")
		buf.printExpr(node, node.Date, true)
		buf.WriteByte(')')
	}
}

// formatFast formats the node.
func (node *TrimFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.TrimFuncType.ToString())
	buf.WriteByte('(')
	if node.TrimFuncType == NormalTrimType {
		var from bool
		if node.Type != NoTrimType {
			buf.WriteString(node.Type.ToString())
			buf.WriteByte(' ')
			from = true
		}
		if node.TrimArg != nil {
			buf.printExpr(node, node.TrimArg, true)
			buf.WriteByte(' ')
			from = true
		}

		if from {
			buf.WriteString("from ")
		}
	}
	buf.printExpr(node, node.StringArg, true)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *WeightStringFuncExpr) formatFast(buf *TrackedBuffer) {
	if node.As != nil {
		buf.WriteString("weight_string(")
		buf.printExpr(node, node.Expr, true)
		buf.WriteString(" as ")
		node.As.formatFast(buf)
		buf.WriteByte(')')
	} else {
		buf.WriteString("weight_string(")
		buf.printExpr(node, node.Expr, true)
		buf.WriteByte(')')
	}
}

// formatFast formats the node.
func (node *CurTimeFuncExpr) formatFast(buf *TrackedBuffer) {
	if node.Fsp > 0 {
		buf.WriteString(node.Name.String())
		buf.WriteByte('(')
		buf.WriteString(fmt.Sprintf("%d", node.Fsp))
		buf.WriteByte(')')
	} else {
		buf.WriteString(node.Name.String())
		buf.WriteString("()")
	}
}

// formatFast formats the node.
func (node *CollateExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(" collate ")
	buf.WriteString(node.Collation)
}

// formatFast formats the node.
func (node *FuncExpr) formatFast(buf *TrackedBuffer) {
	if !node.Qualifier.IsEmpty() {
		node.Qualifier.formatFast(buf)
		buf.WriteByte('.')
	}
	// Function names should not be back-quoted even
	// if they match a reserved word, only if they contain illegal characters
	funcName := node.Name.String()

	if containEscapableChars(funcName, NoAt) {
		writeEscapedString(buf, funcName)
	} else {
		buf.WriteString(funcName)
	}
	buf.WriteByte('(')
	node.Exprs.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GroupConcatExpr) formatFast(buf *TrackedBuffer) {
	if node.Distinct {
		buf.WriteString("group_concat(")
		buf.WriteString(DistinctStr)
		node.Exprs.formatFast(buf)
		node.OrderBy.formatFast(buf)
	} else {
		buf.WriteString("group_concat(")
		node.Exprs.formatFast(buf)
		node.OrderBy.formatFast(buf)
	}
	if node.Separator != "" {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[SEPARATOR])
		buf.WriteByte(' ')
		buf.WriteString(node.Separator)
	}
	node.Limit.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *ValuesFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("values(")
	buf.printExpr(node, node.Name, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONPrettyExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_pretty(")
	buf.printExpr(node, node.JSONVal, true)
	buf.WriteByte(')')

}

// formatFast formats the node
func (node *JSONStorageFreeExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_storage_free(")
	buf.printExpr(node, node.JSONVal, true)
	buf.WriteByte(')')

}

// formatFast formats the node
func (node *JSONStorageSizeExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_storage_size(")
	buf.printExpr(node, node.JSONVal, true)
	buf.WriteByte(')')

}

// formatFast formats the node
func (node *OverClause) formatFast(buf *TrackedBuffer) {
	buf.WriteString("over")
	if !node.WindowName.IsEmpty() {
		buf.WriteByte(' ')
		node.WindowName.formatFast(buf)
	}
	if node.WindowSpec != nil {
		buf.WriteString(" (")
		node.WindowSpec.formatFast(buf)
		buf.WriteByte(')')
	}
}

// formatFast formats the node
func (node *WindowSpecification) formatFast(buf *TrackedBuffer) {
	if !node.Name.IsEmpty() {
		buf.WriteByte(' ')
		node.Name.formatFast(buf)
	}
	if node.PartitionClause != nil {
		buf.WriteString(" partition by ")
		node.PartitionClause.formatFast(buf)
	}
	if node.OrderClause != nil {
		node.OrderClause.formatFast(buf)
	}
	if node.FrameClause != nil {
		node.FrameClause.formatFast(buf)
	}
}

// formatFast formats the node
func (node *FrameClause) formatFast(buf *TrackedBuffer) {
	buf.WriteByte(' ')
	buf.WriteString(node.Unit.ToString())
	if node.End != nil {
		buf.WriteString(" between")
		node.Start.formatFast(buf)
		buf.WriteString(" and")
		node.End.formatFast(buf)
	} else {
		node.Start.formatFast(buf)
	}
}

// formatFast formats the node
func (node *NullTreatmentClause) formatFast(buf *TrackedBuffer) {
	buf.WriteByte(' ')
	buf.WriteString(node.Type.ToString())
}

// formatFast formats the node
func (node *FromFirstLastClause) formatFast(buf *TrackedBuffer) {
	buf.WriteByte(' ')
	buf.WriteString(node.Type.ToString())
}

// formatFast formats the node
func (node *FramePoint) formatFast(buf *TrackedBuffer) {
	if node.Expr != nil {
		if node.Unit != IntervalNone {
			buf.WriteString(" interval ")
			node.Expr.formatFast(buf)
			buf.WriteByte(' ')
			buf.WriteString(node.Unit.ToString())
		} else {
			buf.WriteByte(' ')
			node.Expr.formatFast(buf)
		}
	}
	buf.WriteByte(' ')
	buf.WriteString(node.Type.ToString())
}

// formatFast formats the node
func (node *ArgumentLessWindowExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteString("()")
	if node.OverClause != nil {
		buf.WriteByte(' ')
		node.OverClause.formatFast(buf)
	}
}

// formatFast formats the node
func (node *FirstOrLastValueExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.Expr, true)
	buf.WriteByte(')')
	if node.NullTreatmentClause != nil {
		node.NullTreatmentClause.formatFast(buf)
	}
	if node.OverClause != nil {
		buf.WriteByte(' ')
		node.OverClause.formatFast(buf)
	}
}

// formatFast formats the node
func (node *NtileExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("ntile(")
	buf.printExpr(node, node.N, true)
	buf.WriteString(")")
	if node.OverClause != nil {
		buf.WriteByte(' ')
		node.OverClause.formatFast(buf)
	}
}

// formatFast formats the node
func (node *NTHValueExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("nth_value(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.N, true)
	buf.WriteString(")")
	if node.FromFirstLastClause != nil {
		node.FromFirstLastClause.formatFast(buf)
	}
	if node.NullTreatmentClause != nil {
		node.NullTreatmentClause.formatFast(buf)
	}
	if node.OverClause != nil {
		buf.WriteByte(' ')
		node.OverClause.formatFast(buf)
	}
}

// formatFast formats the node
func (node *LagLeadExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.Expr, true)
	if node.N != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.N, true)
	}
	if node.Default != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Default, true)
	}
	buf.WriteString(")")
	if node.NullTreatmentClause != nil {
		node.NullTreatmentClause.formatFast(buf)
	}
	if node.OverClause != nil {
		buf.WriteByte(' ')
		node.OverClause.formatFast(buf)
	}
}

// formatFast formats the node
func (node *ExtractValueExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("extractvalue(")
	buf.printExpr(node, node.Fragment, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.XPathExpr, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *UpdateXMLExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("updatexml(")
	buf.printExpr(node, node.Target, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.XPathExpr, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.NewXML, true)
	buf.WriteByte(')')
}

func (node *PerformanceSchemaFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	if node.Argument != nil {
		buf.printExpr(node, node.Argument, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GTIDFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.Set1, true)
	if node.Set2 != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Set2, true)
	}
	if node.Timeout != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Timeout, true)
	}
	if node.Channel != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Channel, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *SubstrExpr) formatFast(buf *TrackedBuffer) {
	if node.To == nil {
		buf.WriteString("substr(")
		buf.printExpr(node, node.Name, true)
		buf.WriteString(", ")
		buf.printExpr(node, node.From, true)
		buf.WriteByte(')')
	} else {
		buf.WriteString("substr(")
		buf.printExpr(node, node.Name, true)
		buf.WriteString(", ")
		buf.printExpr(node, node.From, true)
		buf.WriteString(", ")
		buf.printExpr(node, node.To, true)
		buf.WriteByte(')')
	}
}

// formatFast formats the node.
func (node *InsertExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("insert(")
	buf.printExpr(node, node.Str, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Pos, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Len, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.NewStr, true)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *IntervalFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("interval(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(", ")
	node.Exprs.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *LocateExpr) formatFast(buf *TrackedBuffer) {
	if node.Pos != nil {
		buf.WriteString("locate(")
		buf.printExpr(node, node.SubStr, true)
		buf.WriteString(", ")
		buf.printExpr(node, node.Str, true)
		buf.WriteString(", ")
		buf.printExpr(node, node.Pos, true)
		buf.WriteByte(')')
	} else {
		buf.WriteString("locate(")
		buf.printExpr(node, node.SubStr, true)
		buf.WriteString(", ")
		buf.printExpr(node, node.Str, true)
		buf.WriteByte(')')
	}
}

// formatFast formats the node.
func (node *CharExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("char(")
	node.Exprs.formatFast(buf)
	if node.Charset != "" {
		buf.WriteString(" using ")
		buf.WriteString(node.Charset)
	}
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *NamedWindow) formatFast(buf *TrackedBuffer) {
	buf.WriteString("window ")
	node.Windows.formatFast(buf)
}

// formatFast formats the node.
func (node NamedWindows) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *WindowDefinition) formatFast(buf *TrackedBuffer) {
	node.Name.formatFast(buf)
	buf.WriteString(" AS (")
	node.WindowSpec.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node WindowDefinitions) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *CastExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("cast(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(" as ")
	node.Type.formatFast(buf)
	if node.Array {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[ARRAY])
	}
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *ConvertExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("convert(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(", ")
	node.Type.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *ConvertUsingExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("convert(")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(" using ")
	buf.WriteString(node.Type)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *ConvertType) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type)
	if node.Length != nil {
		buf.WriteByte('(')
		node.Length.formatFast(buf)
		if node.Scale != nil {
			buf.WriteString(", ")
			node.Scale.formatFast(buf)
		}
		buf.WriteByte(')')
	}
	if node.Charset.Name != "" {
		buf.WriteString(" character set ")
		buf.WriteString(node.Charset.Name)
	}
	if node.Charset.Binary {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[BINARY])
	}
}

// formatFast formats the node
func (node *MatchExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("match(")
	for i, col := range node.Columns {
		if i != 0 {
			buf.WriteString(", ")
			buf.printExpr(node, col, true)
		} else {
			buf.printExpr(node, col, true)
		}
	}
	buf.WriteString(") against (")
	buf.printExpr(node, node.Expr, true)
	buf.WriteString(node.Option.ToString())
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *CaseExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("case ")
	if node.Expr != nil {
		buf.printExpr(node, node.Expr, true)
		buf.WriteByte(' ')
	}
	for _, when := range node.Whens {
		when.formatFast(buf)
		buf.WriteByte(' ')
	}
	if node.Else != nil {
		buf.WriteString("else ")
		buf.printExpr(node, node.Else, true)
		buf.WriteByte(' ')
	}
	buf.WriteString("end")
}

// formatFast formats the node.
func (node *Default) formatFast(buf *TrackedBuffer) {
	buf.WriteString("default")
	if node.ColName != "" {
		buf.WriteByte('(')
		formatID(buf, node.ColName, NoAt)
		buf.WriteByte(')')
	}
}

// formatFast formats the node.
func (node *When) formatFast(buf *TrackedBuffer) {
	buf.WriteString("when ")
	node.Cond.formatFast(buf)
	buf.WriteString(" then ")
	node.Val.formatFast(buf)
}

// formatFast formats the node.
func (node GroupBy) formatFast(buf *TrackedBuffer) {
	prefix := " group by "
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node OrderBy) formatFast(buf *TrackedBuffer) {
	prefix := " order by "
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *Order) formatFast(buf *TrackedBuffer) {
	if node, ok := node.Expr.(*NullVal); ok {
		buf.printExpr(node, node, true)
		return
	}
	if node, ok := node.Expr.(*FuncExpr); ok {
		if node.Name.Lowered() == "rand" {
			buf.printExpr(node, node, true)
			return
		}
	}

	node.Expr.formatFast(buf)
	buf.WriteByte(' ')
	buf.WriteString(node.Direction.ToString())
}

// formatFast formats the node.
func (node *Limit) formatFast(buf *TrackedBuffer) {
	if node == nil {
		return
	}
	buf.WriteString(" limit ")
	if node.Offset != nil {
		node.Offset.formatFast(buf)
		buf.WriteString(", ")
	}
	node.Rowcount.formatFast(buf)
}

// formatFast formats the node.
func (node Values) formatFast(buf *TrackedBuffer) {
	prefix := "values "
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node UpdateExprs) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *UpdateExpr) formatFast(buf *TrackedBuffer) {
	node.Name.formatFast(buf)
	buf.WriteString(" = ")
	node.Expr.formatFast(buf)
}

// formatFast formats the node.
func (node SetExprs) formatFast(buf *TrackedBuffer) {
	var prefix string
	for _, n := range node {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node.
func (node *SetExpr) formatFast(buf *TrackedBuffer) {
	// We don't have to backtick set variable names.
	switch {
	case node.Var.Name.EqualString("charset") || node.Var.Name.EqualString("names"):
		buf.WriteString(node.Var.Name.String())
		buf.WriteByte(' ')
		node.Expr.formatFast(buf)
	default:
		node.Var.formatFast(buf)
		buf.WriteString(" = ")
		node.Expr.formatFast(buf)
	}
}

// formatFast formats the node.
func (node OnDup) formatFast(buf *TrackedBuffer) {
	if node == nil {
		return
	}
	buf.WriteString(" on duplicate key update ")
	UpdateExprs(node).formatFast(buf)
}

// formatFast formats the node.
func (node IdentifierCI) formatFast(buf *TrackedBuffer) {
	if node.IsEmpty() {
		return
	}
	formatID(buf, node.val, NoAt)
}

// formatFast formats the node.
func (node IdentifierCS) formatFast(buf *TrackedBuffer) {
	formatID(buf, node.v, NoAt)
}

// formatFast formats the node.
func (node *Load) formatFast(buf *TrackedBuffer) {
	buf.WriteString("AST node missing for Load type")
}

// formatFast formats the node.
func (node *ShowBasic) formatFast(buf *TrackedBuffer) {
	buf.WriteString("show")
	if node.Full {
		buf.WriteString(" full")
	}
	buf.WriteString(node.Command.ToString())
	if !node.Tbl.IsEmpty() {
		buf.WriteString(" from ")
		node.Tbl.formatFast(buf)
	}
	if !node.DbName.IsEmpty() {
		buf.WriteString(" from ")
		node.DbName.formatFast(buf)
	}
	node.Filter.formatFast(buf)
}

// formatFast formats the node.
func (node *ShowCreate) formatFast(buf *TrackedBuffer) {
	buf.WriteString("show")
	buf.WriteString(node.Command.ToString())
	buf.WriteByte(' ')
	node.Op.formatFast(buf)
}

// formatFast formats the node.
func (node *ShowOther) formatFast(buf *TrackedBuffer) {
	buf.WriteString("show ")
	buf.WriteString(node.Command)
}

// formatFast formats the node.
func (node *SelectInto) formatFast(buf *TrackedBuffer) {
	if node == nil {
		return
	}
	buf.WriteString(node.Type.ToString())
	buf.WriteString(node.FileName)
	if node.Charset.Name != "" {
		buf.WriteString(" character set ")
		buf.WriteString(node.Charset.Name)
	}
	buf.WriteString(node.FormatOption)
	buf.WriteString(node.ExportOption)
	buf.WriteString(node.Manifest)
	buf.WriteString(node.Overwrite)
}

// formatFast formats the node.
func (node *CreateDatabase) formatFast(buf *TrackedBuffer) {
	buf.WriteString("create database ")
	node.Comments.formatFast(buf)
	if node.IfNotExists {
		buf.WriteString("if not exists ")
	}
	node.DBName.formatFast(buf)
	if node.CreateOptions != nil {
		for _, createOption := range node.CreateOptions {
			if createOption.IsDefault {
				buf.WriteString(" default")
			}
			buf.WriteString(createOption.Type.ToString())
			buf.WriteByte(' ')
			buf.WriteString(createOption.Value)
		}
	}
}

// formatFast formats the node.
func (node *AlterDatabase) formatFast(buf *TrackedBuffer) {
	buf.WriteString("alter database")
	if !node.DBName.IsEmpty() {
		buf.WriteByte(' ')
		node.DBName.formatFast(buf)
	}
	if node.UpdateDataDirectory {
		buf.WriteString(" upgrade data directory name")
	}
	if node.AlterOptions != nil {
		for _, createOption := range node.AlterOptions {
			if createOption.IsDefault {
				buf.WriteString(" default")
			}
			buf.WriteString(createOption.Type.ToString())
			buf.WriteByte(' ')
			buf.WriteString(createOption.Value)
		}
	}
}

// formatFast formats the node.
func (node *CreateTable) formatFast(buf *TrackedBuffer) {
	buf.WriteString("create ")
	node.Comments.formatFast(buf)
	if node.Temp {
		buf.WriteString("temporary ")
	}
	buf.WriteString("table ")

	if node.IfNotExists {
		buf.WriteString("if not exists ")
	}
	node.Table.formatFast(buf)

	if node.OptLike != nil {
		buf.WriteByte(' ')
		node.OptLike.formatFast(buf)
	}
	if node.TableSpec != nil {
		buf.WriteByte(' ')
		node.TableSpec.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *CreateView) formatFast(buf *TrackedBuffer) {
	buf.WriteString("create ")
	node.Comments.formatFast(buf)
	if node.IsReplace {
		buf.WriteString("or replace ")
	}
	if node.Algorithm != "" {
		buf.WriteString("algorithm = ")
		buf.WriteString(node.Algorithm)
		buf.WriteByte(' ')
	}
	if node.Definer != nil {
		buf.WriteString("definer = ")
		node.Definer.formatFast(buf)
		buf.WriteByte(' ')
	}
	if node.Security != "" {
		buf.WriteString("sql security ")
		buf.WriteString(node.Security)
		buf.WriteByte(' ')
	}
	buf.WriteString("view ")
	node.ViewName.formatFast(buf)
	node.Columns.formatFast(buf)
	buf.WriteString(" as ")
	node.Select.formatFast(buf)
	if node.CheckOption != "" {
		buf.WriteString(" with ")
		buf.WriteString(node.CheckOption)
		buf.WriteString(" check option")
	}
}

// formatFast formats the LockTables node.
func (node *LockTables) formatFast(buf *TrackedBuffer) {
	buf.WriteString("lock tables ")
	node.Tables[0].Table.formatFast(buf)
	buf.WriteByte(' ')
	buf.WriteString(node.Tables[0].Lock.ToString())
	for i := 1; i < len(node.Tables); i++ {
		buf.WriteString(", ")
		node.Tables[i].Table.formatFast(buf)
		buf.WriteByte(' ')
		buf.WriteString(node.Tables[i].Lock.ToString())
	}
}

// formatFast formats the UnlockTables node.
func (node *UnlockTables) formatFast(buf *TrackedBuffer) {
	buf.WriteString("unlock tables")
}

// formatFast formats the node.
func (node *AlterView) formatFast(buf *TrackedBuffer) {
	buf.WriteString("alter ")
	node.Comments.formatFast(buf)
	if node.Algorithm != "" {
		buf.WriteString("algorithm = ")
		buf.WriteString(node.Algorithm)
		buf.WriteByte(' ')
	}
	if node.Definer != nil {
		buf.WriteString("definer = ")
		node.Definer.formatFast(buf)
		buf.WriteByte(' ')
	}
	if node.Security != "" {
		buf.WriteString("sql security ")
		buf.WriteString(node.Security)
		buf.WriteByte(' ')
	}
	buf.WriteString("view ")
	node.ViewName.formatFast(buf)
	node.Columns.formatFast(buf)
	buf.WriteString(" as ")
	node.Select.formatFast(buf)
	if node.CheckOption != "" {
		buf.WriteString(" with ")
		buf.WriteString(node.CheckOption)
		buf.WriteString(" check option")
	}
}

func (definer *Definer) formatFast(buf *TrackedBuffer) {
	buf.WriteString(definer.Name)
	if definer.Address != "" {
		buf.WriteByte('@')
		buf.WriteString(definer.Address)
	}
}

// formatFast formats the node.
func (node *DropTable) formatFast(buf *TrackedBuffer) {
	temp := ""
	if node.Temp {
		temp = "temporary "
	}
	exists := ""
	if node.IfExists {
		exists = " if exists"
	}
	buf.WriteString("drop ")
	node.Comments.formatFast(buf)
	buf.WriteString(temp)
	buf.WriteString("table")
	buf.WriteString(exists)
	buf.WriteByte(' ')
	node.FromTables.formatFast(buf)
}

// formatFast formats the node.
func (node *DropView) formatFast(buf *TrackedBuffer) {
	buf.WriteString("drop ")
	node.Comments.formatFast(buf)
	exists := ""
	if node.IfExists {
		exists = " if exists"
	}
	buf.WriteString("view")
	buf.WriteString(exists)
	buf.WriteByte(' ')
	node.FromTables.formatFast(buf)
}

// formatFast formats the AlterTable node.
func (node *AlterTable) formatFast(buf *TrackedBuffer) {
	buf.WriteString("alter ")
	node.Comments.formatFast(buf)
	buf.WriteString("table ")
	node.Table.formatFast(buf)
	prefix := ""
	for i, option := range node.AlterOptions {
		if i != 0 {
			buf.WriteByte(',')
		}
		buf.WriteByte(' ')
		option.formatFast(buf)
		if node.PartitionSpec != nil && node.PartitionSpec.Action != RemoveAction {
			prefix = ","
		}
	}
	if node.PartitionSpec != nil {
		buf.WriteString(prefix)
		buf.WriteByte(' ')
		node.PartitionSpec.formatFast(buf)
	}
	if node.PartitionOption != nil {
		buf.WriteString(prefix)
		buf.WriteByte(' ')
		node.PartitionOption.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *AddConstraintDefinition) formatFast(buf *TrackedBuffer) {
	buf.WriteString("add ")
	node.ConstraintDefinition.formatFast(buf)
}

func (node *AlterCheck) formatFast(buf *TrackedBuffer) {
	buf.WriteString("alter check ")
	node.Name.formatFast(buf)
	if node.Enforced {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[ENFORCED])
	} else {
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[NOT])
		buf.WriteByte(' ')
		buf.WriteString(keywordStrings[ENFORCED])
	}
}

// formatFast formats the node.
func (node *AddIndexDefinition) formatFast(buf *TrackedBuffer) {
	buf.WriteString("add ")
	node.IndexDefinition.formatFast(buf)
}

// formatFast formats the node.
func (node *AddColumns) formatFast(buf *TrackedBuffer) {

	if len(node.Columns) == 1 {
		buf.WriteString("add column ")
		node.Columns[0].formatFast(buf)
		if node.First {
			buf.WriteString(" first")
		}
		if node.After != nil {
			buf.WriteString(" after ")
			node.After.formatFast(buf)
		}
	} else {
		for i, col := range node.Columns {
			if i == 0 {
				buf.WriteString("add column (")
				col.formatFast(buf)
			} else {
				buf.WriteString(", ")
				col.formatFast(buf)
			}
		}
		buf.WriteByte(')')
	}
}

// formatFast formats the node.
func (node AlgorithmValue) formatFast(buf *TrackedBuffer) {
	buf.WriteString("algorithm = ")
	buf.WriteString(string(node))
}

// formatFast formats the node
func (node *AlterColumn) formatFast(buf *TrackedBuffer) {
	buf.WriteString("alter column ")
	node.Column.formatFast(buf)
	if node.DropDefault {
		buf.WriteString(" drop default")
	} else if node.DefaultVal != nil {
		if node.DefaultLiteral {
			buf.WriteString(" set default ")
			node.DefaultVal.formatFast(buf)
		} else {
			buf.WriteString(" set default (")
			node.DefaultVal.formatFast(buf)
			buf.WriteByte(')')
		}
	}
	if node.Invisible != nil {
		if *node.Invisible {
			buf.WriteString(" set invisible")
		} else {
			buf.WriteString(" set visible")
		}
	}
}

// formatFast formats the node
func (node *AlterIndex) formatFast(buf *TrackedBuffer) {
	buf.WriteString("alter index ")
	node.Name.formatFast(buf)
	if node.Invisible {
		buf.WriteString(" invisible")
	} else {
		buf.WriteString(" visible")
	}
}

// formatFast formats the node
func (node *ChangeColumn) formatFast(buf *TrackedBuffer) {
	buf.WriteString("change column ")
	node.OldColumn.formatFast(buf)
	buf.WriteByte(' ')
	node.NewColDefinition.formatFast(buf)
	if node.First {
		buf.WriteString(" first")
	}
	if node.After != nil {
		buf.WriteString(" after ")
		node.After.formatFast(buf)
	}
}

// formatFast formats the node
func (node *ModifyColumn) formatFast(buf *TrackedBuffer) {
	buf.WriteString("modify column ")
	node.NewColDefinition.formatFast(buf)
	if node.First {
		buf.WriteString(" first")
	}
	if node.After != nil {
		buf.WriteString(" after ")
		node.After.formatFast(buf)
	}
}

// formatFast formats the node
func (node *RenameColumn) formatFast(buf *TrackedBuffer) {
	buf.WriteString("rename column ")
	node.OldName.formatFast(buf)
	buf.WriteString(" to ")
	node.NewName.formatFast(buf)
}

// formatFast formats the node
func (node *AlterCharset) formatFast(buf *TrackedBuffer) {
	buf.WriteString("convert to character set ")
	buf.WriteString(node.CharacterSet)
	if node.Collate != "" {
		buf.WriteString(" collate ")
		buf.WriteString(node.Collate)
	}
}

// formatFast formats the node
func (node *KeyState) formatFast(buf *TrackedBuffer) {
	if node.Enable {
		buf.WriteString("enable keys")
	} else {
		buf.WriteString("disable keys")
	}

}

// formatFast formats the node
func (node *TablespaceOperation) formatFast(buf *TrackedBuffer) {
	if node.Import {
		buf.WriteString("import tablespace")
	} else {
		buf.WriteString("discard tablespace")
	}
}

// formatFast formats the node
func (node *DropColumn) formatFast(buf *TrackedBuffer) {
	buf.WriteString("drop column ")
	node.Name.formatFast(buf)
}

// formatFast formats the node
func (node *DropKey) formatFast(buf *TrackedBuffer) {
	buf.WriteString("drop ")
	buf.WriteString(node.Type.ToString())
	if !node.Name.IsEmpty() {
		buf.WriteByte(' ')
		node.Name.formatFast(buf)
	}
}

// formatFast formats the node
func (node *Force) formatFast(buf *TrackedBuffer) {
	buf.WriteString("force")
}

// formatFast formats the node
func (node *LockOption) formatFast(buf *TrackedBuffer) {
	buf.WriteString("lock ")
	buf.WriteString(node.Type.ToString())
}

// formatFast formats the node
func (node *OrderByOption) formatFast(buf *TrackedBuffer) {
	buf.WriteString("order by ")
	prefix := ""
	for _, n := range node.Cols {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
}

// formatFast formats the node
func (node *RenameTableName) formatFast(buf *TrackedBuffer) {
	buf.WriteString("rename ")
	node.Table.formatFast(buf)
}

// formatFast formats the node
func (node *RenameIndex) formatFast(buf *TrackedBuffer) {
	buf.WriteString("rename index ")
	node.OldName.formatFast(buf)
	buf.WriteString(" to ")
	node.NewName.formatFast(buf)
}

// formatFast formats the node
func (node *Validation) formatFast(buf *TrackedBuffer) {
	if node.With {
		buf.WriteString("with validation")
	} else {
		buf.WriteString("without validation")
	}
}

// formatFast formats the node
func (node TableOptions) formatFast(buf *TrackedBuffer) {
	for i, option := range node {
		if i != 0 {
			buf.WriteByte(' ')
		}
		buf.WriteString(option.Name)
		switch {
		case option.String != "":
			if option.CaseSensitive {
				buf.WriteByte(' ')
				buf.WriteString(option.String)
			} else {
				buf.WriteByte(' ')
				buf.WriteString(option.String)
			}
		case option.Value != nil:
			buf.WriteByte(' ')
			option.Value.formatFast(buf)
		default:
			buf.WriteString(" (")
			option.Tables.formatFast(buf)
			buf.WriteByte(')')
		}
	}
}

// formatFast formats the node
func (node *TruncateTable) formatFast(buf *TrackedBuffer) {
	buf.WriteString("truncate table ")
	node.Table.formatFast(buf)
}

// formatFast formats the node.
func (node *RenameTable) formatFast(buf *TrackedBuffer) {
	buf.WriteString("rename table")
	prefix := " "
	for _, pair := range node.TablePairs {
		buf.WriteString(prefix)
		pair.FromTable.formatFast(buf)
		buf.WriteString(" to ")
		pair.ToTable.formatFast(buf)
		prefix = ", "
	}
}

func (node *JSONTableExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_table(")
	node.Expr.formatFast(buf)
	buf.WriteString(", ")
	node.Filter.formatFast(buf)
	buf.WriteString(" columns(\n")
	sz := len(node.Columns)

	for i := 0; i < sz-1; i++ {
		buf.WriteByte('\t')
		node.Columns[i].formatFast(buf)
		buf.WriteString(",\n")
	}
	buf.WriteByte('\t')
	node.Columns[sz-1].formatFast(buf)
	buf.WriteByte('\n')
	buf.WriteString("\t)\n) as ")
	node.Alias.formatFast(buf)
}

func (node *JtColumnDefinition) formatFast(buf *TrackedBuffer) {
	if node.JtOrdinal != nil {
		node.JtOrdinal.Name.formatFast(buf)
		buf.WriteString(" for ordinality")
	} else if node.JtNestedPath != nil {
		buf.WriteString("nested path ")
		node.JtNestedPath.Path.formatFast(buf)
		buf.WriteString(" columns(\n")
		sz := len(node.JtNestedPath.Columns)

		for i := 0; i < sz-1; i++ {
			buf.WriteByte('\t')
			node.JtNestedPath.Columns[i].formatFast(buf)
			buf.WriteString(",\n")
		}
		buf.WriteByte('\t')
		node.JtNestedPath.Columns[sz-1].formatFast(buf)
		buf.WriteString("\n)")
	} else if node.JtPath != nil {
		node.JtPath.Name.formatFast(buf)
		buf.WriteByte(' ')
		node.JtPath.Type.formatFast(buf)
		buf.WriteByte(' ')
		if node.JtPath.JtColExists {
			buf.WriteString("exists ")
		}
		buf.WriteString("path ")
		node.JtPath.Path.formatFast(buf)
		buf.WriteByte(' ')

		if node.JtPath.EmptyOnResponse != nil {
			node.JtPath.EmptyOnResponse.formatFast(buf)
			buf.WriteString(" on empty ")
		}

		if node.JtPath.ErrorOnResponse != nil {
			node.JtPath.ErrorOnResponse.formatFast(buf)
			buf.WriteString(" on error ")
		}
	}
}

func (node *JtOnResponse) formatFast(buf *TrackedBuffer) {
	switch node.ResponseType {
	case ErrorJSONType:
		buf.WriteString("error")
	case NullJSONType:
		buf.WriteString("null")
	case DefaultJSONType:
		buf.WriteString("default ")
		node.Expr.formatFast(buf)
	}
}

// formatFast formats the node.
func (node *Offset) formatFast(buf *TrackedBuffer) {
	buf.WriteByte(':')
	buf.WriteString(fmt.Sprintf("%d", node.V))
}

// formatFast formats the node.
func (node *JSONSchemaValidFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_schema_valid(")
	buf.printExpr(node, node.Schema, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Document, true)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *JSONSchemaValidationReportFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_schema_validation_report(")
	buf.printExpr(node, node.Schema, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Document, true)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *JSONArrayExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_array(")
	if len(node.Params) > 0 {
		var prefix string
		for _, n := range node.Params {
			buf.WriteString(prefix)
			buf.printExpr(node, n, true)
			prefix = ", "
		}
	}
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *JSONObjectExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_object(")
	if len(node.Params) > 0 {
		for i, p := range node.Params {
			if i != 0 {
				buf.WriteString(", ")

			}
			p.formatFast(buf)
		}
	}
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *JSONObjectParam) formatFast(buf *TrackedBuffer) {
	node.Key.formatFast(buf)
	buf.WriteString(", ")
	node.Value.formatFast(buf)
}

// formatFast formats the node.
func (node *JSONQuoteExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_quote(")
	buf.printExpr(node, node.StringArg, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONContainsExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_contains(")
	buf.printExpr(node, node.Target, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Candidate, true)
	if len(node.PathList) > 0 {
		buf.WriteString(", ")
	}
	var prefix string
	for _, n := range node.PathList {
		buf.WriteString(prefix)
		buf.printExpr(node, n, true)
		prefix = ", "
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONContainsPathExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_contains_path(")
	buf.printExpr(node, node.JSONDoc, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.OneOrAll, true)
	buf.WriteString(", ")
	var prefix string
	for _, n := range node.PathList {
		buf.WriteString(prefix)
		buf.printExpr(node, n, true)
		prefix = ", "
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONExtractExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_extract(")
	buf.printExpr(node, node.JSONDoc, true)
	buf.WriteString(", ")
	var prefix string
	for _, n := range node.PathList {
		buf.WriteString(prefix)
		buf.printExpr(node, n, true)
		prefix = ", "
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONKeysExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_keys(")
	buf.printExpr(node, node.JSONDoc, true)
	if node.Path != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Path, true)
		buf.WriteByte(')')
		return
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONOverlapsExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_overlaps(")
	buf.printExpr(node, node.JSONDoc1, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.JSONDoc2, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONSearchExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_search(")
	buf.printExpr(node, node.JSONDoc, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.OneOrAll, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.SearchStr, true)
	if node.EscapeChar != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.EscapeChar, true)
	}
	if len(node.PathList) > 0 {
		buf.WriteString(", ")
	}
	var prefix string
	for _, n := range node.PathList {
		buf.WriteString(prefix)
		buf.printExpr(node, n, true)
		prefix = ", "
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONValueExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_value(")
	buf.printExpr(node, node.JSONDoc, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Path, true)

	if node.ReturningType != nil {
		buf.WriteString(" returning ")
		node.ReturningType.formatFast(buf)
	}

	if node.EmptyOnResponse != nil {
		buf.WriteByte(' ')
		node.EmptyOnResponse.formatFast(buf)
		buf.WriteString(" on empty")
	}

	if node.ErrorOnResponse != nil {
		buf.WriteByte(' ')
		node.ErrorOnResponse.formatFast(buf)
		buf.WriteString(" on error")
	}

	buf.WriteByte(')')
}

// formatFast formats the node
func (node *MemberOfExpr) formatFast(buf *TrackedBuffer) {
	buf.printExpr(node, node.Value, true)
	buf.WriteString(" member of (")
	buf.printExpr(node, node.JSONArr, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *JSONAttributesExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.JSONDoc, true)
	if node.Path != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Path, true)
	}
	buf.WriteString(")")
}

// formatFast formats the node.
func (node *JSONValueModifierExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.JSONDoc, true)
	buf.WriteString(", ")
	var prefix string
	for _, n := range node.Params {
		buf.WriteString(prefix)
		n.formatFast(buf)
		prefix = ", "
	}
	buf.WriteString(")")
}

// formatFast formats the node.
func (node *JSONValueMergeExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.JSONDoc, true)
	buf.WriteString(", ")
	var prefix string
	for _, n := range node.JSONDocList {
		buf.WriteString(prefix)
		buf.printExpr(node, n, true)
		prefix = ", "
	}
	buf.WriteString(")")
}

// formatFast formats the node.
func (node *JSONRemoveExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_remove(")
	buf.printExpr(node, node.JSONDoc, true)
	buf.WriteString(", ")
	var prefix string
	for _, n := range node.PathList {
		buf.WriteString(prefix)
		buf.printExpr(node, n, true)
		prefix = ", "
	}
	buf.WriteString(")")
}

// formatFast formats the node.
func (node *JSONUnquoteExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("json_unquote(")
	buf.printExpr(node, node.JSONValue, true)
	buf.WriteString(")")
}

func (node *Count) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.AggrName())
	buf.WriteByte('(')
	if node.Distinct {
		buf.WriteString(DistinctStr)
	}
	node.Args.formatFast(buf)
	buf.WriteByte(')')
}

func (node *CountStar) formatFast(buf *TrackedBuffer) {
	buf.WriteString("count(*)")
}

func (node *AnyValue) formatFast(buf *TrackedBuffer) {
	buf.WriteString("any_value(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *Avg) formatFast(buf *TrackedBuffer) {
	buf.WriteString("avg(")
	if node.Distinct {
		buf.WriteString(DistinctStr)
	}
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *Max) formatFast(buf *TrackedBuffer) {
	buf.WriteString("max(")
	if node.Distinct {
		buf.WriteString(DistinctStr)
	}
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *Min) formatFast(buf *TrackedBuffer) {
	buf.WriteString("min(")
	if node.Distinct {
		buf.WriteString(DistinctStr)
	}
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *Sum) formatFast(buf *TrackedBuffer) {
	buf.WriteString("sum(")
	if node.Distinct {
		buf.WriteString(DistinctStr)
	}
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *BitAnd) formatFast(buf *TrackedBuffer) {
	buf.WriteString("bit_and(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *BitOr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("bit_or(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *BitXor) formatFast(buf *TrackedBuffer) {
	buf.WriteString("bit_xor(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *Std) formatFast(buf *TrackedBuffer) {
	buf.WriteString("std(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *StdDev) formatFast(buf *TrackedBuffer) {
	buf.WriteString("stddev(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *StdPop) formatFast(buf *TrackedBuffer) {
	buf.WriteString("stddev_pop(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *StdSamp) formatFast(buf *TrackedBuffer) {
	buf.WriteString("stddev_samp(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *VarPop) formatFast(buf *TrackedBuffer) {
	buf.WriteString("var_pop(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *VarSamp) formatFast(buf *TrackedBuffer) {
	buf.WriteString("var_samp(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

func (node *Variance) formatFast(buf *TrackedBuffer) {
	buf.WriteString("variance(")
	buf.printExpr(node, node.Arg, true)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *LockingFunc) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString() + "(")
	if node.Type != ReleaseAllLocks {
		buf.printExpr(node, node.Name, true)
	}
	if node.Type == GetLock {
		buf.WriteString(", ")
		buf.printExpr(node, node.Timeout, true)
	}
	buf.WriteString(")")
}

// formatFast formats the node.
func (node *Variable) formatFast(buf *TrackedBuffer) {
	switch node.Scope {
	case VariableScope:
		buf.WriteString("@")
	case SessionScope:
		if node.Name.EqualString(TransactionIsolationStr) || node.Name.EqualString(TransactionReadOnlyStr) {
			// @@ without session have `next transaction` scope for these system variables.
			// so if they are in session scope it has to be printed explicitly.
			buf.WriteString("@@")
			buf.WriteString(node.Scope.ToString())
			buf.WriteByte('.')
			break
		}
		buf.WriteString("@@")
	case GlobalScope, PersistSysScope, PersistOnlySysScope:
		buf.WriteString("@@")
		buf.WriteString(node.Scope.ToString())
		buf.WriteByte('.')
	case NextTxScope:
		buf.WriteString("@@")
	}
	node.Name.formatFast(buf)
}

// formatFast formats the node.
func (node *PointExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("point(")
	buf.printExpr(node, node.XCordinate, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.YCordinate, true)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *LineStringExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("linestring(")
	node.PointParams.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *PolygonExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("polygon(")
	node.LinestringParams.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *PurgeBinaryLogs) formatFast(buf *TrackedBuffer) {
	buf.WriteString("purge binary logs")
	if node.To != "" {
		buf.WriteString(" to '")
		buf.WriteString(node.To)
		buf.WriteByte('\'')
	} else {
		buf.WriteString(" before '")
		buf.WriteString(node.Before)
		buf.WriteByte('\'')
	}
}

func (node *MultiPolygonExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("multipolygon(")
	node.PolygonParams.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *MultiPointExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("multipoint(")
	node.PointParams.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node.
func (node *MultiLinestringExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("multilinestring(")
	node.LinestringParams.formatFast(buf)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeomFromTextExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.WktText, true)
	if node.Srid != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Srid, true)
	}
	if node.AxisOrderOpt != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.AxisOrderOpt, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeomFromWKBExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Type.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.WkbBlob, true)
	if node.Srid != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Srid, true)
	}
	if node.AxisOrderOpt != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.AxisOrderOpt, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeomFormatExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.FormatType.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.Geom, true)
	if node.AxisOrderOpt != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.AxisOrderOpt, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeomPropertyFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Property.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.Geom, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *PointPropertyFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Property.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.Point, true)
	if node.ValueToSet != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.ValueToSet, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *LinestrPropertyFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Property.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.Linestring, true)
	if node.PropertyDefArg != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.PropertyDefArg, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *PolygonPropertyFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Property.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.Polygon, true)
	if node.PropertyDefArg != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.PropertyDefArg, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeomCollPropertyFuncExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.Property.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.GeomColl, true)
	if node.PropertyDefArg != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.PropertyDefArg, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeomFromGeoHashExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString(node.GeomType.ToString())
	buf.WriteByte('(')
	buf.printExpr(node, node.GeoHash, true)
	if node.SridOpt != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.SridOpt, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeoHashFromLatLongExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("st_geohash(")
	buf.printExpr(node, node.Longitude, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.Latitude, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.MaxLength, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeoHashFromPointExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("st_geohash(")
	buf.printExpr(node, node.Point, true)
	buf.WriteString(", ")
	buf.printExpr(node, node.MaxLength, true)
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeoJSONFromGeomExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("st_asgeojson(")
	buf.printExpr(node, node.Geom, true)
	if node.MaxDecimalDigits != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.MaxDecimalDigits, true)
	}
	if node.Bitmask != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Bitmask, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the node
func (node *GeomFromGeoJSONExpr) formatFast(buf *TrackedBuffer) {
	buf.WriteString("st_geomfromgeojson(")
	buf.printExpr(node, node.GeoJSON, true)
	if node.HigherDimHandlerOpt != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.HigherDimHandlerOpt, true)
	}
	if node.Srid != nil {
		buf.WriteString(", ")
		buf.printExpr(node, node.Srid, true)
	}
	buf.WriteByte(')')
}

// formatFast formats the kill statement
func (node *Kill) formatFast(buf *TrackedBuffer) {
	buf.WriteString("kill ")
	buf.WriteString(node.Type.ToString())
	buf.WriteByte(' ')
	buf.WriteString(fmt.Sprintf("%d", node.ProcesslistID))
}