mysql

Documentation

Index

• Constants
• Variables
• func EofChar() int
• func ExtractMysqlComment(sql string) (string, string)
• func Parse(ctx context.Context, sql string, lower int64) ([]tree.Statement, error)
• func ParseOne(ctx context.Context, sql string, lower int64) (tree.Statement, error)
• func PutScanner(scanner *Scanner)
• type Lexer
  • func NewLexer(dialectType dialect.DialectType, sql string, lower int64) *Lexer
  • func (l *Lexer) AppendStmt(stmt tree.Statement)
  • func (l *Lexer) Error(err string)
  • func (l *Lexer) GetDbOrTblName(origin string) string
  • func (l *Lexer) GetDbOrTblNameCStr(origin string) *tree.CStr
  • func (l *Lexer) GetParamIndex() int
  • func (l *Lexer) Lex(lval *yySymType) int
• type PositionedErr
  • func (p PositionedErr) Error() string
• type Scanner
  • func NewScanner(dialectType dialect.DialectType, sql string) *Scanner
  • func (s *Scanner) Scan() (int, string)
  • func (s *Scanner) ScanComment() (int, string)

Constants

const ACCOUNT = 57674

const ACCOUNTS = 57675

const ACTION = 57626

const ADD = 57560

const ADDDATE = 57871

const ADMIN_NAME = 57724

const AFTER = 57389

const AGAINST = 57861

const ALGORITHM = 57633

const ALL = 57374

const ALTER = 57556

const ANALYZE = 57559

const AND = 57453

const ANY = 57640

const APPROXNUM = 57717

const APPROX_COUNT = 57877

const APPROX_COUNT_DISTINCT = 57878

const APPROX_PERCENTILE = 57880

const ARROW = 57925

const AS = 57377

const ASC = 57379

const ASCII = 57684

const ASSIGNMENT = 57471

const ATTRIBUTE = 57727

const AT_AT_ID = 57427

const AT_ID = 57426

const AUTOEXTEND_SIZE = 57723

const AUTO_INCREMENT = 57716

const AUTO_RANDOM = 57620

const AVG = 57911

const AVG_ROW_LENGTH = 57596

const BACKEND = 57947

const BACKUP = 57954

const BEGIN = 57484

const BETWEEN = 57455

const BIGINT = 57503

const BINARY = 57479

const BINDINGS = 57934

const BIT = 57497

const BITMAP_BIT_POSITION = 57916

const BITMAP_BUCKET_NUMBER = 57917

const BITMAP_CONSTRUCT_AGG = 57919

const BITMAP_COUNT = 57918

const BITMAP_OR_AGG = 57920

const BIT_AND = 57872

const BIT_CAST = 57915

const BIT_LITERAL = 57442

const BIT_OR = 57873

const BIT_XOR = 57874

const BLOB = 57525

const BOOL = 57517

const BOOLEAN = 57862

const BOTH = 57667

const BSI = 57662

const BTREE = 57659

const BY = 57363

const CALL = 57942

const CANCEL = 57857

const CASCADE = 57625

const CASCADED = 57402

const CASE = 57456

const CAST = 57875

const CHAIN = 57492

const CHANGE = 57682

const CHAR = 57515

const CHARACTER = 57518

const CHARSET = 57447

const CHECK = 57629

const CHECKSUM = 57600

const CIPHER = 57739

const CLIENT = 57707

const CLUSTER = 57638

const CLUSTER_CENTERS = 57896

const COALESCE = 57685

const COLLATE = 57478

const COLLATION = 57686

const COLUMN = 57571

const COLUMNS = 57784

const COLUMN_FORMAT = 57619

const COLUMN_NUMBER = 57794

const COMMENT = 57431

const COMMENT_KEYWORD = 57432

const COMMIT = 57487

const COMMITTED = 57807

const COMPACT = 57617

const COMPRESSED = 57615

const COMPRESSION = 57601

const CONFIG = 57848

const CONNECT = 57367

const CONNECTION = 57756

const CONNECTOR = 57853

const CONNECTORS = 57854

const CONSISTENT = 57490

const CONSTRAINT = 57572

const CONVERT = 57822

const COPY = 57392

const COUNT = 57876

const CREATE = 57555

const CREDENTIALS = 57435

const CROSS = 57416

const CURDATE = 57881

const CURRENT = 57730

const CURRENT_DATE = 57825

const CURRENT_ROLE = 57827

const CURRENT_TIME = 57815

const CURRENT_TIMESTAMP = 57813

const CURRENT_USER = 57826

const CURRVAL = 57923

const CURTIME = 57882

const CYCLE = 57650

const DAEMON = 57855

const DATA = 57602

const DATABASE = 57814

const DATABASES = 57777

const DATE = 57580

const DATETIME = 57513

const DATE_ADD = 57883

const DATE_SUB = 57884

const DAY = 57677

const DAY_HOUR = 57837

const DAY_MICROSECOND = 57834

const DAY_MINUTE = 57836

const DAY_SECOND = 57835

const DEALLOCATE = 57646

const DECIMAL = 57508

const DECIMAL_VALUE = 57510

const DECLARE = 57936

const DEFAULT = 57383

const DEFINER = 57398

const DELAYED = 57554

const DELAY_KEY_WRITE = 57604

const DELETE = 57358

const DENSE_RANK = 57914

const DESC = 57380

const DESCRIBE = 57578

const DIRECTORY = 57603

const DISABLE = 57393

const DISCARD = 57770

const DISK = 57598

const DISTINCT = 57375

const DISTINCTROW = 57376

const DIV = 57475

const DO = 57935

const DOUBLE = 57506

const DRAINER = 57849

const DROP = 57557

const DUPLICATE = 57382

const DYNAMIC = 57614

const ELSE = 57459

const ELSEIF = 57461

const EMPTY = 57347

const ENABLE = 57394

const ENCLOSED = 57764

const ENCRYPTION = 57605

const END = 57460

const ENFORCED = 57630

const ENGINE = 57606

const ENGINES = 57721

const ENGINE_ATTRIBUTE = 57621

const ENUM = 57530

const ERRORS = 57786

const ESCAPE = 57581

const ESCAPED = 57765

const EVENT = 57713

const EVENTS = 57811

const EXCEPT = 57349

const EXCLUSIVE = 57749

const EXECUTE = 57700

const EXISTS = 57378

const EXPANSION = 57866

const EXPIRE = 57673

const EXPLAIN = 57579

const EXTENDED = 57780

const EXTENSION = 57648

const EXTERNAL = 57642

const EXTRACT = 57885

const FAILED_LOGIN_ATTEMPTS = 57732

const FALSE = 57445

const FIELDS = 57783

const FILE = 57710

const FILESYSTEM = 57955

const FILL = 57945

const FIRST = 57387

const FIXED = 57618

const FLOAT = 57440

const FLOAT_TYPE = 57507

const FOLLOWING = 57775

const FOR = 57366

const FORCE = 57419

const FORCE_QUOTE = 57930

const FOREIGN = 57575

const FORMAT = 57754

const FROM = 57359

const FULL = 57781

const FULLTEXT = 57574

const FUNCTION = 57697

const GE = 57464

const GEOMETRY = 57534

const GEOMETRYCOLLECTION = 57538

const GLOBAL = 57798

const GRANT = 57702

const GRANTS = 57369

const GROUP = 57361

const GROUPS = 57776

const GROUP_CONCAT = 57886

const HANDLER = 57949

const HASH = 57660

const HAVING = 57362

const HEADER = 57928

const HEADERS = 57852

const HEX = 57439

const HEXNUM = 57441

const HIGH_PRIORITY = 57553

const HISTORY = 57728

const HOUR = 57687

const HOUR_MICROSECOND = 57831

const HOUR_MINUTE = 57833

const HOUR_SECOND = 57832

const ID = 57425

const IDENTIFIED = 57738

const IF = 57569

const IGNORE = 57568

const ILIKE = 57472

const IMPORT = 57769

const IN = 57470

const INCREMENT = 57649

const INDEX = 57565

const INDEXES = 57788

const INFILE = 57761

const INLINE = 57760

const INNER = 57414

const INOUT = 57483

const INPLACE = 57391

const INSERT = 57356

const INSERT_METHOD = 57623

const INSTANT = 57390

const INT = 57501

const INT1 = 57542

const INT2 = 57543

const INT3 = 57544

const INT4 = 57545

const INT8 = 57546

const INTEGER = 57502

const INTEGRAL = 57438

const INTERSECT = 57350

const INTERVAL = 57481

const INTNUM = 57504

const INTO = 57381

const INVISIBLE = 57658

const INVOKER = 57399

const IS = 57467

const ISOLATION = 57801

const ISSUER = 57740

const ITERATE = 57940

const IVFFLAT = 57663

const JOIN = 57410

const JSON = 57529

const JSONTYPE = 57771

const KEY = 57449

const KEYS = 57385

const KEY_BLOCK_SIZE = 57576

const KILL = 57953

const KMEANS = 57897

const LANGUAGE = 57863

const LAST = 57388

const LASTVAL = 57924

const LE = 57463

const LEADING = 57666

const LEAVE = 57939

const LEFT = 57412

const LESS = 57588

const LEVEL = 57802

const LEX_ERROR = 57346

const LIKE = 57468

const LIMIT = 57364

const LINEAR = 57634

const LINES = 57767

const LINESTRING = 57536

const LIST = 57632

const LISTS = 57670

const LIST_ARG = 57430

const LOAD = 57759

const LOCAL = 57810

const LOCALFILE = 57643

const LOCALTIME = 57816

const LOCALTIMESTAMP = 57817

const LOCK = 57384

const LOCKS = 57791

const LONGBLOB = 57528

const LONGTEXT = 57524

const LOOP = 57937

const LOWER_THAN_CHARSET = 57446

const LOWER_THAN_COMMA = 57354

const LOWER_THAN_EQ = 57462

const LOWER_THAN_ON = 57420

const LOWER_THAN_ORDER = 57352

const LOWER_THAN_SET = 57372

const LOWER_THAN_STRING = 57424

const LOW_CARDINALITY = 57722

const LOW_PRIORITY = 57552

const MANAGE = 57368

const MASTER = 57664

const MATCH = 57860

const MAX = 57887

const MAXVALUE = 57585

const MAX_CONNECTIONS_PER_HOUR = 57752

const MAX_FILE_SIZE = 57929

const MAX_QUERIES_PER_HOUR = 57750

const MAX_ROWS = 57607

const MAX_UPDATES_PER_HOUR = 57751

const MAX_USER_CONNECTIONS = 57753

const MEDIAN = 57895

const MEDIUMBLOB = 57527

const MEDIUMINT = 57500

const MEDIUMTEXT = 57523

const MEMORY = 57599

const MERGE = 57396

const MICROSECOND = 57688

const MID = 57888

const MIN = 57889

const MINUS = 57351

const MINUTE = 57689

const MINUTE_MICROSECOND = 57829

const MINUTE_SECOND = 57830

const MINVALUE = 57651

const MIN_ROWS = 57608

const MOD = 57476

const MODE = 57407

const MODIFY = 57681

const MODUMP = 57772

const MONTH = 57690

const MO_TS = 57952

const MULTILINESTRING = 57540

const MULTIPOINT = 57539

const MULTIPOLYGON = 57541

const MYSQL_COMPATIBILITY_MODE = 57680

const NAMES = 57797

const NATURAL = 57417

const NCHAR = 57520

const NE = 57465

const NEVER = 57678

const NEXT = 57404

const NEXTVAL = 57921

const NO = 57493

const NODE = 57790

const NONE = 57746

const NOT = 57454

const NOW = 57890

const NULL = 57443

const NULLS = 57386

const NULLX = 57715

const NULL_SAFE_EQUAL = 57466

const NUMERIC = 57509

const OFFSET = 57365

const ON = 57421

const ONLY = 57805

const OPEN = 57785

const OPTIMIZE = 57583

const OPTION = 57703

const OPTIONAL = 57731

const OPTIONALLY = 57763

const OP_TYPE = 57671

const OR = 57450

const ORDER = 57353

const OUT = 57482

const OUTER = 57415

const OUTFILE = 57927

const OVER = 57773

const OWNERSHIP = 57370

const PACK_KEYS = 57609

const PARALLEL = 57931

const PARALLELISM = 57956

const PARSER = 57656

const PARTIAL = 57627

const PARTITION = 57586

const PARTITIONS = 57635

const PASSWORD = 57747

const PASSWORD_LOCK_TIME = 57733

const PAUSE = 57856

const PERCENT = 57950

const PERSIST = 57799

const PIPE_CONCAT = 57451

const PLUGINS = 57812

const POINT = 57535

const POLYGON = 57537

const POSITION = 57891

const PRECEDING = 57774

const PREPARE = 57645

const PREV = 57943

const PRIMARY = 57570

const PRIORITY = 57495

const PRIVILEGES = 57698

const PROCEDURE = 57590

const PROCESSLIST = 57782

const PROFILES = 57758

const PROPERTIES = 57655

const PROXY = 57595

const PUBLICATION = 57652

const PUBLICATIONS = 57654

const PUMP = 57679

const QUARTER = 57691

const QUERY = 57865

const QUERY_RESULT = 57958

const QUICK = 57496

const QUOTE_ID = 57433

const RANDOM = 57725

const RANGE = 57631

const RANK = 57912

const READ = 57803

const REAL = 57505

const RECURSIVE = 57847

const REDUNDANT = 57616

const REFERENCE = 57371

const REFERENCES = 57704

const REGEXP = 57469

const REINDEX = 57672

const RELEASE = 57494

const RELOAD = 57709

const RENAME = 57558

const REORGANIZE = 57587

const REPAIR = 57582

const REPEAT = 57692

const REPEATABLE = 57806

const REPLACE = 57821

const REPLICATION = 57705

const REQUIRE = 57744

const RESET = 57647

const RESTORE = 57957

const RESTRICT = 57624

const RESTRICTED = 57736

const RESUME = 57859

const RETRY = 57870

const RETURNS = 57561

const REUSE = 57729

const REVERSE = 57693

const REVOKE = 57696

const RIGHT = 57413

const ROLE = 57594

const ROLES = 57792

const ROLLBACK = 57488

const ROUTINE = 57712

const ROW = 57926

const ROWS = 57768

const ROW_COUNT = 57694

const ROW_FORMAT = 57610

const ROW_NUMBER = 57913

const RTREE = 57661

const S3OPTION = 57547

const SAMPLE = 57951

const SAN = 57743

const SCHEMA = 57562

const SCHEMAS = 57789

const SECOND = 57683

const SECONDARY = 57735

const SECONDARY_ENGINE_ATTRIBUTE = 57622

const SECOND_MICROSECOND = 57828

const SECURITY = 57401

const SELECT = 57355

const SEPARATOR = 57823

const SEQUENCE = 57564

const SEQUENCES = 57779

const SERIALIZABLE = 57809

const SERIAL_EXTRACT = 57879

const SERVERS = 57948

const SESSION = 57800

const SESSION_USER = 57892

const SET = 57373

const SETVAL = 57922

const SHARE = 57406

const SHARED = 57748

const SHIFT_LEFT = 57473

const SHIFT_RIGHT = 57474

const SHOW = 57577

const SHUTDOWN = 57714

const SIGNED = 57718

const SIMPLE = 57628

const SLAVE = 57706

const SLIDING = 57944

const SMALLINT = 57499

const SNAPSHOT = 57491

const SNAPSHOTS = 57437

const SOME = 57641

const SOURCE = 57850

const SPATIAL = 57573

const SPBEGIN = 57946

const SQL = 57400

const SQL_BIG_RESULT = 57550

const SQL_BUFFER_RESULT = 57551

const SQL_CACHE = 57409

const SQL_NO_CACHE = 57408

const SQL_SMALL_RESULT = 57549

const SQL_TSI_DAY = 57840

const SQL_TSI_HOUR = 57839

const SQL_TSI_MINUTE = 57846

const SQL_TSI_MONTH = 57842

const SQL_TSI_QUARTER = 57843

const SQL_TSI_SECOND = 57845

const SQL_TSI_WEEK = 57841

const SQL_TSI_YEAR = 57844

const SSL = 57745

const STAGE = 57434

const STAGEOPTION = 57548

const STAGES = 57436

const START = 57485

const STARTING = 57766

const STATS_AUTO_RECALC = 57611

const STATS_PERSISTENT = 57612

const STATS_SAMPLE_PAGES = 57613

const STATUS = 57592

const STD = 57893

const STDDEV = 57894

const STDDEV_POP = 57898

const STDDEV_SAMP = 57899

const STORAGE = 57597

const STRAIGHT_JOIN = 57411

const STREAM = 57851

const STRICT = 57932

const STRING = 57428

const SUBDATE = 57900

const SUBJECT = 57742

const SUBPARTITION = 57636

const SUBPARTITIONS = 57637

const SUBQUERY_AS_EXPR = 57423

const SUBSCRIPTIONS = 57653

const SUBSTR = 57901

const SUBSTRING = 57902

const SUM = 57903

const SUPER = 57701

const SUSPEND = 57726

const SYSDATE = 57904

const SYSTEM_USER = 57905

const TABLE = 57563

const TABLES = 57778

const TABLESPACE = 57699

const TABLE_NUMBER = 57793

const TABLE_SIZE = 57796

const TABLE_VALUES = 57795

const TASK = 57858

const TEMPORARY = 57711

const TEMPTABLE = 57397

const TERMINATED = 57762

const TEXT = 57521

const THAN = 57589

const THEN = 57458

const TIME = 57511

const TIMESTAMP = 57512

const TIMESTAMPDIFF = 57824

const TINYBLOB = 57526

const TINYINT = 57498

const TINYTEXT = 57522

const TO = 57567

const TRAILING = 57668

const TRANSACTION = 57486

const TRANSLATE = 57906

const TRIGGER = 57591

const TRIGGERS = 57757

const TRIM = 57907

const TRUE = 57444

const TRUNCATE = 57584

const TYPE = 57639

const UNARY = 57477

const UNBOUNDED = 57734

const UNCOMMITTED = 57808

const UNDEFINED = 57395

const UNDERSCORE_BINARY = 57480

const UNION = 57348

const UNIQUE = 57448

const UNKNOWN = 57669

const UNLOCK = 57676

const UNSIGNED = 57719

const UNTIL = 57941

const UNUSED = 57933

const UPDATE = 57357

const UPGRADE = 57869

const URL = 57644

const USAGE = 57708

const USE = 57418

const USER = 57737

const USING = 57422

const UTC_DATE = 57818

const UTC_TIME = 57819

const UTC_TIMESTAMP = 57820

const UUID = 57531

const VALIDATION = 57868

const VALUE = 57405

const VALUES = 57403

const VALUE_ARG = 57429

const VARBINARY = 57519

const VARCHAR = 57516

const VARIABLES = 57593

const VARIANCE = 57908

const VAR_POP = 57909

const VAR_SAMP = 57910

const VECF32 = 57532

const VECF64 = 57533

const VERBOSE = 57755

const VIEW = 57566

const VISIBLE = 57657

const WARNINGS = 57787

const WEEK = 57695

const WHEN = 57457

const WHERE = 57360

const WHILE = 57938

const WITH = 57864

const WITHOUT = 57867

const WORK = 57489

const WRITE = 57804

const X509 = 57741

const XOR = 57452

const YEAR = 57514

const YEAR_MONTH = 57838

const ZEROFILL = 57720

const ZONEMAP = 57665

Variables

var CaseInsensitiveDbs = []string{"information_schema", "mysql"}

Functions

func EofChar

func EofChar() int

func ExtractMysqlComment

func ExtractMysqlComment(sql string) (string, string)

ExtractMysqlComment extracts the version and SQL from a comment-only query such as /*!50708 sql here */

func Parse

func Parse(ctx context.Context, sql string, lower int64) ([]tree.Statement, error)

func ParseOne

func ParseOne(ctx context.Context, sql string, lower int64) (tree.Statement, error)

func PutScanner

func PutScanner(scanner *Scanner)

Types

type Lexer

type Lexer struct {
	// contains filtered or unexported fields
}

func NewLexer

func NewLexer(dialectType dialect.DialectType, sql string, lower int64) *Lexer

func (*Lexer) AppendStmt

func (l *Lexer) AppendStmt(stmt tree.Statement)

func (*Lexer) Error

func (l *Lexer) Error(err string)

func (*Lexer) GetDbOrTblName

func (l *Lexer) GetDbOrTblName(origin string) string

func (*Lexer) GetDbOrTblNameCStr

func (l *Lexer) GetDbOrTblNameCStr(origin string) *tree.CStr

func (*Lexer) GetParamIndex

func (l *Lexer) GetParamIndex() int

func (*Lexer) Lex

func (l *Lexer) Lex(lval *yySymType) int

type PositionedErr

type PositionedErr struct {
	Err    string
	Line   int
	Col    int
	Near   string
	LenStr string
}

PositionedErr holds context related to parser errros

func (PositionedErr) Error

func (p PositionedErr) Error() string

type Scanner

type Scanner struct {
	LastToken string
	LastError error

	MysqlSpecialComment *Scanner

	CommentFlag bool
	Pos         int
	Line        int
	Col         int
	PrePos      int
	// contains filtered or unexported fields
}

func NewScanner

func NewScanner(dialectType dialect.DialectType, sql string) *Scanner

func (*Scanner) Scan

func (s *Scanner) Scan() (int, string)

func (*Scanner) ScanComment

func (s *Scanner) ScanComment() (int, string)

ScanComment finds all Comment (/* */, //) until gets EOF or LEX_ERROR