18243888765

Committed 04 Oct 2025 11:45AM UTC coverage: 89.221% (-0.02%) from 89.241%

Build # 18243888765

Build Type

Pull #2073

gh-ci

Committed by

ostafen

Commit Message

chore(embedded/sql): Implement EXTRACT FROM TIMESTAMP expressions

Signed-off-by: Stefano Scafiti <stefano.scafiti96@gmail.com>

Pull Request Pull Request #2073: chore(embedded/sql): Implement EXTRACT FROM TIMESTAMP expressions

Run Details

357 of 402 new or added lines in 3 files covered. (88.81%)

1 existing line in 1 file now uncovered.

37909 of 42489 relevant lines covered (89.22%)

149222.03 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

93.56

/embedded/sql/sql_parser.go

// Code generated by goyacc -l -o sql_parser.go sql_grammar.y. DO NOT EDIT.
package sql

import __yyfmt__ "fmt"

import "fmt"

func setResult(l yyLexer, stmts []SQLStmt) {
        l.(*lexer).result = stmts
}

type yySymType struct {
        yys             int
        stmts           []SQLStmt
        stmt            SQLStmt
        datasource      DataSource
        colSpec         *ColSpec
        cols            []*ColSelector
        rows            []*RowSpec
        row             *RowSpec
        values          []ValueExp
        value           ValueExp
        id              string
        integer         uint64
        float           float64
        str             string
        boolean         bool
        blob            []byte
        keyword         string
        sqlType         SQLValueType
        aggFn           AggregateFn
        ids             []string
        col             *ColSelector
        sel             Selector
        targets         []TargetEntry
        jsonFields      []string
        distinct        bool
        ds              DataSource
        tableRef        *tableRef
        period          period
        openPeriod      *openPeriod
        periodInstant   periodInstant
        joins           []*JoinSpec
        join            *JoinSpec
        joinType        JoinType
        check           CheckConstraint
        exp             ValueExp
        binExp          ValueExp
        err             error
        ordexps         []*OrdExp
        opt_ord         bool
        logicOp         LogicOperator
        cmpOp           CmpOperator
        pparam          int
        update          *colUpdate
        updates         []*colUpdate
        onConflict      *OnConflictDo
        permission      Permission
        sqlPrivilege    SQLPrivilege
        sqlPrivileges   []SQLPrivilege
        whenThenClauses []whenThenClause
        tableElem       TableElem
        tableElems      []TableElem
        timestampField  TimestampFieldType
}

const CREATE = 57346
const DROP = 57347
const USE = 57348
const DATABASE = 57349
const USER = 57350
const WITH = 57351
const PASSWORD = 57352
const READ = 57353
const READWRITE = 57354
const ADMIN = 57355
const SNAPSHOT = 57356
const HISTORY = 57357
const SINCE = 57358
const AFTER = 57359
const BEFORE = 57360
const UNTIL = 57361
const TX = 57362
const OF = 57363
const INTEGER_TYPE = 57364
const BOOLEAN_TYPE = 57365
const VARCHAR_TYPE = 57366
const UUID_TYPE = 57367
const BLOB_TYPE = 57368
const TIMESTAMP_TYPE = 57369
const FLOAT_TYPE = 57370
const JSON_TYPE = 57371
const TABLE = 57372
const UNIQUE = 57373
const INDEX = 57374
const ON = 57375
const ALTER = 57376
const ADD = 57377
const RENAME = 57378
const TO = 57379
const COLUMN = 57380
const CONSTRAINT = 57381
const PRIMARY = 57382
const KEY = 57383
const CHECK = 57384
const GRANT = 57385
const REVOKE = 57386
const GRANTS = 57387
const FOR = 57388
const PRIVILEGES = 57389
const BEGIN = 57390
const TRANSACTION = 57391
const COMMIT = 57392
const ROLLBACK = 57393
const INSERT = 57394
const UPSERT = 57395
const INTO = 57396
const VALUES = 57397
const DELETE = 57398
const UPDATE = 57399
const SET = 57400
const CONFLICT = 57401
const DO = 57402
const NOTHING = 57403
const RETURNING = 57404
const SELECT = 57405
const DISTINCT = 57406
const FROM = 57407
const JOIN = 57408
const HAVING = 57409
const WHERE = 57410
const GROUP = 57411
const BY = 57412
const LIMIT = 57413
const OFFSET = 57414
const ORDER = 57415
const ASC = 57416
const DESC = 57417
const AS = 57418
const UNION = 57419
const ALL = 57420
const CASE = 57421
const WHEN = 57422
const THEN = 57423
const ELSE = 57424
const END = 57425
const NOT = 57426
const LIKE = 57427
const IF = 57428
const EXISTS = 57429
const IN = 57430
const IS = 57431
const AUTO_INCREMENT = 57432
const NULL = 57433
const CAST = 57434
const SCAST = 57435
const SHOW = 57436
const DATABASES = 57437
const TABLES = 57438
const USERS = 57439
const BETWEEN = 57440
const EXTRACT = 57441
const YEAR = 57442
const MONTH = 57443
const DAY = 57444
const HOUR = 57445
const MINUTE = 57446
const SECOND = 57447
const NPARAM = 57448
const PPARAM = 57449
const JOINTYPE = 57450
const AND = 57451
const OR = 57452
const CMPOP = 57453
const NOT_MATCHES_OP = 57454
const IDENTIFIER = 57455
const INTEGER_LIT = 57456
const FLOAT_LIT = 57457
const VARCHAR_LIT = 57458
const BOOLEAN_LIT = 57459
const BLOB_LIT = 57460
const AGGREGATE_FUNC = 57461
const ERROR = 57462
const DOT = 57463
const ARROW = 57464
const STMT_SEPARATOR = 57465

var yyToknames = [...]string{
        "$end",
        "error",
        "$unk",
        "CREATE",
        "DROP",
        "USE",
        "DATABASE",
        "USER",
        "WITH",
        "PASSWORD",
        "READ",
        "READWRITE",
        "ADMIN",
        "SNAPSHOT",
        "HISTORY",
        "SINCE",
        "AFTER",
        "BEFORE",
        "UNTIL",
        "TX",
        "OF",
        "INTEGER_TYPE",
        "BOOLEAN_TYPE",
        "VARCHAR_TYPE",
        "UUID_TYPE",
        "BLOB_TYPE",
        "TIMESTAMP_TYPE",
        "FLOAT_TYPE",
        "JSON_TYPE",
        "TABLE",
        "UNIQUE",
        "INDEX",
        "ON",
        "ALTER",
        "ADD",
        "RENAME",
        "TO",
        "COLUMN",
        "CONSTRAINT",
        "PRIMARY",
        "KEY",
        "CHECK",
        "GRANT",
        "REVOKE",
        "GRANTS",
        "FOR",
        "PRIVILEGES",
        "BEGIN",
        "TRANSACTION",
        "COMMIT",
        "ROLLBACK",
        "INSERT",
        "UPSERT",
        "INTO",
        "VALUES",
        "DELETE",
        "UPDATE",
        "SET",
        "CONFLICT",
        "DO",
        "NOTHING",
        "RETURNING",
        "SELECT",
        "DISTINCT",
        "FROM",
        "JOIN",
        "HAVING",
        "WHERE",
        "GROUP",
        "BY",
        "LIMIT",
        "OFFSET",
        "ORDER",
        "ASC",
        "DESC",
        "AS",
        "UNION",
        "ALL",
        "CASE",
        "WHEN",
        "THEN",
        "ELSE",
        "END",
        "NOT",
        "LIKE",
        "IF",
        "EXISTS",
        "IN",
        "IS",
        "AUTO_INCREMENT",
        "NULL",
        "CAST",
        "SCAST",
        "SHOW",
        "DATABASES",
        "TABLES",
        "USERS",
        "BETWEEN",
        "EXTRACT",
        "YEAR",
        "MONTH",
        "DAY",
        "HOUR",
        "MINUTE",
        "SECOND",
        "NPARAM",
        "PPARAM",
        "JOINTYPE",
        "AND",
        "OR",
        "CMPOP",
        "NOT_MATCHES_OP",
        "IDENTIFIER",
        "INTEGER_LIT",
        "FLOAT_LIT",
        "VARCHAR_LIT",
        "BOOLEAN_LIT",
        "BLOB_LIT",
        "AGGREGATE_FUNC",
        "ERROR",
        "DOT",
        "ARROW",
        "','",
        "'+'",
        "'-'",
        "'*'",
        "'/'",
        "'%'",
        "'.'",
        "STMT_SEPARATOR",
        "'('",
        "')'",
        "'['",
        "']'",
}

var yyStatenames = [...]string{}

const yyEofCode = 1
const yyErrCode = 2
const yyInitialStackSize = 16

var yyExca = [...]int16{
        -1, 1,
        1, -1,
        -2, 0,
        -1, 137,
        85, 263,
        88, 263,
        -2, 247,
        -1, 347,
        66, 196,
        -2, 191,
        -1, 406,
        66, 196,
        -2, 193,
}

const yyPrivate = 57344

const yyLast = 1414

var yyAct = [...]int16{
        178, 508, 151, 399, 165, 260, 341, 159, 411, 316,
        266, 191, 200, 410, 376, 232, 294, 405, 257, 317,
        385, 106, 394, 194, 54, 233, 137, 234, 100, 163,
        6, 139, 101, 134, 142, 176, 133, 472, 381, 339,
        380, 339, 321, 373, 452, 339, 481, 480, 474, 339,
        468, 467, 462, 453, 438, 54, 54, 54, 389, 339,
        321, 473, 59, 466, 60, 465, 461, 459, 340, 320,
        57, 61, 377, 418, 416, 415, 413, 372, 58, 370,
        369, 362, 338, 293, 412, 384, 374, 361, 355, 62,
        378, 63, 64, 65, 354, 131, 66, 353, 67, 352,
        68, 69, 326, 246, 70, 71, 72, 73, 74, 75,
        229, 227, 226, 76, 77, 223, 78, 217, 190, 189,
        169, 214, 215, 216, 24, 359, 211, 212, 192, 507,
        501, 452, 373, 339, 199, 118, 201, 310, 39, 225,
        211, 212, 228, 79, 219, 179, 181, 221, 162, 158,
        368, 80, 335, 81, 49, 196, 150, 82, 83, 84,
        85, 86, 87, 160, 161, 328, 311, 436, 435, 205,
        164, 153, 154, 155, 156, 157, 152, 32, 245, 220,
        456, 111, 144, 264, 33, 213, 442, 441, 146, 440,
        207, 258, 417, 262, 239, 236, 397, 238, 195, 208,
        274, 334, 333, 54, 332, 263, 273, 275, 331, 259,
        243, 244, 206, 210, 471, 237, 327, 325, 255, 254,
        247, 240, 197, 180, 166, 211, 212, 126, 314, 313,
        318, 115, 114, 278, 113, 281, 101, 284, 277, 324,
        276, 110, 105, 285, 286, 104, 265, 203, 290, 287,
        288, 289, 204, 408, 323, 97, 91, 187, 315, 22,
        319, 112, 222, 434, 358, 329, 346, 351, 237, 344,
        433, 93, 347, 470, 231, 230, 330, 395, 201, 201,
        10, 12, 11, 31, 102, 22, 356, 357, 345, 348,
        21, 280, 98, 366, 282, 168, 167, 283, 279, 350,
        304, 305, 306, 307, 308, 309, 423, 349, 463, 360,
        13, 364, 292, 365, 426, 22, 21, 125, 88, 14,
        15, 89, 90, 92, 7, 371, 8, 9, 16, 17,
        509, 510, 18, 19, 494, 400, 342, 500, 488, 22,
        477, 192, 487, 401, 451, 383, 21, 375, 367, 198,
        52, 403, 95, 201, 492, 485, 391, 475, 123, 171,
        51, 409, 318, 398, 50, 424, 425, 25, 427, 396,
        21, 396, 117, 127, 429, 382, 491, 322, 484, 251,
        252, 421, 267, 437, 43, 47, 419, 248, 428, 390,
        430, 337, 420, 249, 250, 336, 498, 431, 444, 402,
        241, 446, 53, 439, 170, 119, 116, 448, 184, 445,
        343, 103, 414, 318, 48, 2, 449, 447, 201, 253,
        201, 201, 454, 201, 450, 242, 455, 464, 457, 458,
        185, 460, 44, 120, 121, 122, 46, 45, 182, 183,
        96, 36, 393, 42, 295, 296, 297, 298, 299, 300,
        301, 302, 26, 30, 175, 174, 54, 38, 40, 273,
        172, 479, 478, 34, 482, 35, 108, 109, 386, 387,
        388, 392, 188, 186, 261, 27, 29, 28, 23, 37,
        56, 303, 291, 41, 489, 443, 201, 193, 495, 483,
        209, 497, 432, 469, 490, 493, 504, 379, 130, 502,
        499, 505, 128, 503, 506, 141, 476, 59, 511, 60,
        145, 138, 136, 512, 132, 57, 61, 363, 147, 486,
        218, 235, 407, 58, 406, 404, 173, 107, 124, 94,
        224, 148, 149, 496, 62, 256, 63, 64, 65, 20,
        5, 66, 4, 67, 3, 68, 69, 1, 0, 70,
        71, 72, 73, 74, 75, 0, 0, 0, 76, 77,
        0, 78, 0, 0, 0, 22, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 143, 0, 0, 0, 0, 135, 0, 79, 140,
        0, 0, 0, 162, 158, 0, 422, 0, 81, 0,
        0, 150, 82, 83, 84, 85, 86, 87, 160, 161,
        0, 0, 0, 0, 0, 164, 153, 154, 155, 156,
        157, 152, 59, 0, 60, 0, 0, 144, 0, 0,
        57, 61, 0, 146, 0, 0, 0, 177, 58, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 62,
        0, 63, 64, 65, 0, 0, 66, 0, 67, 0,
        68, 69, 0, 0, 70, 71, 72, 73, 74, 75,
        0, 0, 0, 76, 77, 0, 78, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 143, 0, 0, 0,
        0, 135, 0, 79, 140, 0, 0, 0, 162, 158,
        0, 80, 0, 81, 0, 0, 150, 82, 83, 84,
        85, 86, 87, 160, 161, 0, 0, 0, 0, 0,
        164, 153, 154, 155, 156, 157, 152, 59, 0, 60,
        0, 0, 144, 0, 0, 57, 61, 0, 146, 0,
        0, 0, 0, 58, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 62, 0, 63, 64, 65, 0,
        0, 66, 0, 67, 0, 68, 69, 0, 0, 70,
        71, 72, 73, 74, 75, 0, 0, 0, 76, 77,
        0, 78, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 143, 0, 0, 0, 0, 135, 0, 79, 140,
        0, 0, 0, 162, 158, 0, 80, 0, 81, 0,
        0, 150, 82, 83, 84, 85, 86, 87, 160, 161,
        0, 0, 0, 0, 0, 164, 153, 154, 155, 156,
        157, 152, 59, 0, 60, 0, 0, 144, 129, 0,
        57, 61, 0, 146, 0, 0, 0, 0, 58, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 62,
        0, 63, 64, 65, 0, 0, 66, 0, 67, 0,
        68, 69, 0, 0, 70, 71, 72, 73, 74, 75,
        0, 0, 0, 76, 77, 0, 78, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 143, 0, 0, 0,
        0, 135, 0, 79, 140, 0, 0, 0, 162, 158,
        0, 80, 0, 81, 0, 0, 150, 82, 83, 84,
        85, 86, 87, 160, 161, 0, 0, 0, 0, 0,
        164, 153, 154, 155, 156, 157, 152, 59, 0, 60,
        0, 0, 144, 0, 0, 57, 61, 0, 146, 0,
        0, 0, 0, 58, 0, 0, 0, 0, 0, 0,
        0, 0, 271, 0, 62, 0, 63, 64, 65, 0,
        0, 66, 0, 67, 0, 68, 69, 0, 0, 70,
        71, 72, 73, 74, 75, 0, 0, 0, 76, 77,
        0, 78, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 79, 0,
        0, 0, 59, 0, 60, 0, 80, 269, 270, 272,
        57, 61, 82, 83, 84, 85, 86, 87, 58, 0,
        0, 0, 0, 0, 0, 164, 0, 0, 0, 62,
        0, 63, 64, 65, 0, 0, 66, 0, 67, 0,
        68, 69, 0, 268, 70, 71, 72, 73, 74, 75,
        0, 0, 0, 76, 77, 0, 78, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 79, 0, 0, 0, 0, 0, 0,
        0, 80, 0, 81, 0, 0, 0, 82, 83, 84,
        85, 86, 87, 59, 0, 60, 0, 0, 0, 0,
        55, 57, 61, 0, 0, 0, 0, 0, 0, 58,
        0, 0, 0, 312, 0, 0, 0, 0, 0, 0,
        62, 0, 63, 64, 65, 0, 0, 66, 0, 67,
        0, 68, 69, 0, 0, 70, 71, 72, 73, 74,
        75, 0, 0, 0, 76, 77, 0, 78, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 202, 0, 0, 0, 0, 59,
        0, 60, 0, 0, 79, 0, 0, 57, 61, 0,
        0, 0, 80, 0, 81, 58, 0, 0, 82, 83,
        84, 85, 86, 87, 0, 0, 62, 0, 63, 64,
        65, 55, 0, 66, 0, 67, 0, 68, 69, 0,
        0, 70, 71, 72, 73, 74, 75, 0, 0, 0,
        76, 77, 0, 78, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 59, 0, 60, 0, 0,
        79, 0, 0, 57, 61, 0, 0, 0, 80, 0,
        81, 58, 0, 0, 82, 83, 84, 85, 86, 87,
        0, 0, 62, 0, 63, 64, 65, 55, 0, 66,
        0, 67, 0, 68, 69, 0, 0, 70, 71, 72,
        73, 74, 75, 0, 0, 0, 76, 77, 0, 78,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 99, 0, 0, 0,
        0, 0, 0, 0, 80, 0, 81, 0, 0, 0,
        82, 83, 84, 85, 86, 87, 0, 0, 0, 0,
        0, 0, 0, 55,
}

var yyPact = [...]int16{
        276, -1000, -1000, -6, -1000, -1000, -1000, 318, -1000, -1000,
        445, 170, 433, 449, 380, 380, 310, 306, 285, 1224,
        241, 226, 288, -1000, 276, -1000, 206, 1300, 206, 379,
        132, -1000, 129, 450, 128, 148, 121, 119, 118, 373,
        325, 12, -1000, -1000, -1000, -1000, -1000, -1000, -1000, 372,
        1224, 1224, 1224, 300, -1000, -1000, -1000, -1000, -1000, -1000,
        -1000, -1000, -1000, -1000, -1000, -1000, -1000, -1000, -1000, -1000,
        -1000, -1000, -1000, -1000, -1000, -1000, -1000, -1000, -1000, -1000,
        -1000, -1000, -1000, -1000, -1000, -1000, -1000, -1000, 239, -1000,
        -1000, 114, -1000, 327, 732, -1000, -1000, 111, 212, 211,
        -11, -1000, 371, 206, 451, -1000, -1000, 436, 617, 617,
        -1000, 110, 25, -1000, 403, 421, 466, -1000, 380, 465,
        -12, -13, 273, 85, 196, -1000, -1000, 109, 284, -1000,
        11, 1148, 137, 143, -1000, 847, -1000, 101, -1000, -5,
        -14, -1000, -1000, 847, 57, -1000, 847, 169, -1000, -1000,
        -16, 17, -19, -1000, -1000, -1000, -1000, -1000, -20, -1000,
        -1000, -1000, -1000, 21, -21, -1000, -1000, 188, 187, 155,
        108, 367, 415, -1000, 617, 617, -1000, 847, -1000, -1000,
        -28, 107, 349, 356, 341, 409, 106, -1000, 105, 78,
        78, 468, 847, 60, -1000, 135, -1000, -1000, 962, 847,
        -1000, -1000, 1224, 847, 847, -1000, 57, 207, 57, 209,
        57, 57, 57, -1000, 57, 57, 57, 196, 232, -1000,
        -1000, -49, 422, 200, 15, 50, 1047, 847, 1224, 847,
        -1000, 1224, -63, -1000, -1000, -1000, 336, 422, 847, 104,
        -29, 103, 49, -1000, -1000, -1000, 78, -1000, 102, 95,
        91, 89, 88, 36, 358, 354, -50, 10, -1000, -64,
        265, 378, -1000, 468, 85, 847, 468, 450, 252, -32,
        -34, -37, -43, 1148, 1148, -1000, 143, -1000, 2, -1000,
        173, 16, 57, -44, 2, -5, -5, -1000, -1000, -1000,
        -51, 231, 847, -1000, -1000, -1000, -1000, -1000, -1000, -1000,
        -1000, -1000, -1000, 283, -1000, -1000, -1000, -1000, -1000, -1000,
        34, -1000, -52, -53, 249, -1000, -55, 9, -1000, -45,
        -1000, 155, -41, -93, -1000, 333, 78, -46, 457, -74,
        -1000, -1000, 352, -1000, -1000, 457, 463, 434, 222, 83,
        222, 263, 847, 366, 265, -1000, -1000, 145, 1148, -47,
        -56, 391, -57, -58, 79, -59, -1000, -1000, -1000, 57,
        2, 502, -1000, 223, 847, 847, 233, 847, -1000, -1000,
        -1000, 422, -1000, 847, 155, -1000, -1000, -1000, 78, 179,
        54, 53, 847, -78, 78, -1000, -1000, -1000, -1000, -1000,
        76, -1000, 74, 73, 365, -47, -1000, -1000, -1000, -1000,
        847, -1000, -41, 263, 273, -1000, 145, 278, -1000, -1000,
        -79, -1000, 847, 1148, 67, 1148, 1148, -65, 1148, 2,
        -66, -80, 226, -1000, 227, -1000, 847, -67, -69, -1000,
        -81, -82, 183, -1000, 123, -97, -71, -1000, -1000, -84,
        -1000, -1000, -1000, -1000, 298, 8, -1000, -1000, -1000, 271,
        -1000, 962, -47, -1000, -85, -1000, -86, -1000, -1000, -1000,
        -1000, -1000, -1000, 847, -1000, -1000, -1000, -1000, -1000, 338,
        -1000, -1000, -1000, -1000, -1000, 295, 275, 268, 468, -1000,
        -1000, 1148, -1000, -1000, 335, 293, 261, 847, 1224, 363,
        -1000, -1000, -1000, 265, 267, -1000, 7, -1000, 847, 263,
        847, 1224, -1000, -1000, 6, 256, -1000, 847, -1000, -1000,
        -1000, 256, -1000,
}

var yyPgo = [...]int16{
        0, 547, 415, 544, 542, 540, 30, 539, 27, 18,
        14, 535, 533, 13, 8, 19, 9, 532, 7, 531,
        530, 2, 529, 528, 10, 22, 382, 21, 527, 526,
        35, 525, 17, 524, 522, 521, 25, 15, 0, 520,
        11, 519, 518, 517, 514, 36, 512, 511, 26, 33,
        31, 34, 510, 506, 6, 3, 505, 502, 498, 497,
        12, 496, 495, 1, 5, 255, 493, 492, 490, 489,
        23, 487, 485, 20, 483, 138, 482, 481, 16, 480,
        4, 28, 29, 478,
}

var yyR1 = [...]int8{
        0, 1, 2, 2, 83, 83, 3, 3, 3, 4,
        4, 4, 4, 4, 4, 4, 4, 4, 4, 4,
        4, 4, 4, 4, 4, 4, 4, 4, 4, 4,
        4, 4, 4, 4, 75, 75, 75, 74, 74, 74,
        74, 74, 74, 74, 73, 73, 73, 73, 65, 65,
        10, 10, 5, 5, 5, 5, 25, 25, 72, 72,
        71, 71, 70, 11, 11, 13, 13, 14, 9, 9,
        12, 12, 16, 16, 15, 15, 17, 17, 17, 17,
        17, 17, 17, 17, 17, 17, 78, 78, 78, 78,
        78, 78, 78, 78, 18, 37, 37, 36, 36, 36,
        8, 69, 69, 59, 59, 59, 66, 66, 67, 67,
        67, 6, 6, 6, 6, 6, 6, 6, 6, 7,
        7, 23, 23, 22, 22, 57, 57, 58, 58, 19,
        19, 19, 19, 20, 20, 21, 21, 81, 82, 80,
        80, 79, 79, 79, 79, 79, 79, 79, 79, 79,
        79, 79, 79, 79, 79, 79, 79, 79, 79, 79,
        79, 79, 79, 79, 79, 79, 79, 79, 79, 79,
        79, 79, 24, 24, 24, 24, 24, 24, 24, 24,
        24, 26, 27, 28, 28, 28, 29, 29, 29, 30,
        30, 31, 31, 32, 32, 33, 34, 34, 40, 40,
        53, 53, 41, 41, 54, 54, 55, 55, 62, 62,
        64, 64, 61, 61, 63, 63, 63, 60, 60, 60,
        35, 35, 39, 39, 56, 76, 76, 43, 43, 38,
        44, 44, 45, 45, 49, 49, 46, 46, 46, 46,
        46, 46, 46, 47, 47, 47, 47, 47, 48, 48,
        48, 50, 50, 50, 50, 51, 51, 52, 52, 42,
        42, 42, 42, 68, 68, 77, 77, 77, 77, 77,
        77,
}

var yyR2 = [...]int8{
        0, 1, 2, 3, 0, 1, 1, 1, 1, 2,
        1, 1, 1, 4, 2, 3, 3, 9, 6, 3,
        8, 9, 7, 5, 6, 6, 8, 6, 6, 7,
        7, 3, 8, 8, 2, 1, 3, 1, 1, 1,
        1, 1, 1, 1, 0, 1, 1, 1, 0, 3,
        1, 3, 8, 7, 7, 8, 2, 1, 0, 4,
        1, 3, 3, 0, 1, 1, 3, 3, 1, 3,
        1, 3, 0, 1, 1, 3, 1, 1, 1, 1,
        1, 6, 1, 1, 1, 1, 1, 1, 1, 1,
        1, 1, 1, 1, 4, 1, 3, 1, 1, 3,
        6, 0, 2, 0, 3, 3, 0, 1, 0, 1,
        2, 1, 4, 2, 2, 3, 2, 2, 4, 13,
        3, 0, 1, 0, 1, 1, 1, 2, 4, 1,
        2, 4, 4, 2, 3, 1, 3, 1, 1, 1,
        1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
        1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
        1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
        1, 1, 3, 4, 4, 4, 4, 4, 4, 2,
        6, 1, 2, 0, 2, 2, 0, 2, 2, 2,
        1, 0, 1, 1, 2, 6, 0, 1, 0, 2,
        0, 3, 0, 2, 0, 2, 0, 2, 0, 3,
        0, 4, 2, 4, 0, 1, 1, 0, 1, 2,
        2, 4, 0, 1, 5, 4, 5, 0, 2, 1,
        3, 1, 3, 1, 2, 1, 3, 3, 4, 5,
        4, 3, 1, 4, 6, 6, 1, 1, 3, 3,
        1, 3, 3, 3, 1, 2, 1, 3, 1, 1,
        1, 3, 6, 0, 1, 1, 1, 1, 1, 1,
        1,
}

var yyChk = [...]int16{
        -1000, -1, -2, -3, -4, -5, -6, 48, 50, 51,
        4, 6, 5, 34, 43, 44, 52, 53, 56, 57,
        -7, 94, 63, -83, 130, 49, 7, 30, 32, 31,
        8, 113, 7, 14, 30, 32, 8, 30, 8, -75,
        78, -74, 63, 4, 52, 57, 56, 5, 34, -75,
        54, 54, 65, -26, -80, 113, -79, 13, 21, 5,
        7, 14, 32, 34, 35, 36, 39, 41, 43, 44,
        47, 48, 49, 50, 51, 52, 56, 57, 59, 86,
        94, 96, 100, 101, 102, 103, 104, 105, 77, 95,
        96, 30, 97, 45, -22, 64, -2, -65, 86, 86,
        -81, -80, -65, 32, 113, 113, -27, -28, 16, 17,
        113, 33, 113, 113, 113, 113, 33, 47, 123, 33,
        -26, -26, -26, 58, -23, 78, 113, 46, -57, 126,
        -58, -38, -44, -45, -49, 84, -46, -48, -47, -50,
        87, -56, -51, 79, 125, -52, 131, -42, -19, -17,
        99, -21, 119, 114, 115, 116, 117, 118, 92, -18,
        106, 107, 91, -82, 113, -80, 113, 84, 84, 131,
        33, -65, 9, -29, 19, 18, -30, 20, -38, -30,
        113, 121, 35, 36, 5, 9, 7, -75, 7, 131,
        131, -40, 68, -71, -70, 113, -6, 113, 65, 123,
        -60, -80, 76, 110, 109, -49, 111, 89, 98, -68,
        112, 124, 125, 84, 126, 127, 128, 131, -39, -38,
        -51, -38, 93, 131, -20, 122, 131, 131, 121, 131,
        87, 87, -37, -36, -8, -35, 40, 113, 42, 39,
        113, 33, 10, -30, -30, -38, 131, 113, 38, 37,
        38, 38, 39, 10, 113, 113, -11, -9, 113, -9,
        -64, 6, -38, -40, 123, 111, -24, -26, 131, 95,
        96, 30, 97, -18, -38, -80, -45, -49, -48, 91,
        84, -48, 85, 88, -48, -50, -50, -51, -51, -51,
        -6, -76, 80, 132, -78, 22, 23, 24, 25, 26,
        27, 28, 29, -77, 100, 101, 102, 103, 104, 105,
        122, 116, 126, -21, -38, -82, -16, -15, -38, -81,
        132, 123, 41, -78, -38, 113, 131, 113, 116, -9,
        -8, 113, 113, 113, 113, 116, 37, 37, 132, 123,
        132, -54, 71, 32, -64, -70, -38, -64, -27, 55,
        -6, 15, 131, 131, 131, 131, -60, -60, 91, 109,
        -48, 131, 132, -43, 80, 82, -38, 65, 116, 132,
        132, 76, 132, 123, 131, -36, -10, 113, 131, -59,
        133, 131, 42, -9, 131, -73, 11, 12, 13, 132,
        37, -73, 8, 8, -25, 55, -6, 113, -25, -55,
        72, -38, 33, -54, -31, -32, -33, -34, 108, -60,
        -13, -14, 131, 132, 21, 132, 132, 113, 132, -48,
        -6, -15, 94, 83, -38, -38, 81, -38, -78, -38,
        -37, -9, -67, 91, 84, 114, 114, -38, 132, -9,
        113, 113, 113, -72, 33, -13, -38, -10, -55, -40,
        -32, 66, 123, 132, -16, -60, 113, -60, -60, 132,
        -60, 132, 132, 81, -38, 132, 132, 132, 132, -66,
        90, 91, 134, 132, 132, 59, -53, 69, -24, -14,
        132, 132, -38, -69, 40, 60, -41, 67, 70, -64,
        -60, 41, 61, -62, 73, -38, -12, -21, 33, -54,
        70, 123, -38, -55, -61, -38, -21, 123, -63, 74,
        75, -38, -63,
}

var yyDef = [...]int16{
        0, -2, 1, 4, 6, 7, 8, 10, 11, 12,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        111, 0, 123, 2, 5, 9, 48, 0, 48, 0,
        0, 14, 0, 183, 0, 0, 0, 0, 0, 0,
        0, 35, 37, 38, 39, 40, 41, 42, 43, 0,
        0, 0, 0, 0, 181, 139, 140, 141, 142, 143,
        144, 145, 146, 147, 148, 149, 150, 151, 152, 153,
        154, 155, 156, 157, 158, 159, 160, 161, 162, 163,
        164, 165, 166, 167, 168, 169, 170, 171, 121, 113,
        114, 0, 116, 117, 0, 124, 3, 0, 0, 163,
        0, 137, 0, 48, 0, 15, 16, 186, 0, 0,
        19, 0, 0, 31, 0, 0, 0, 34, 0, 0,
        0, 0, 198, 0, 0, 122, 115, 0, 120, 125,
        126, 217, 229, 231, 233, 0, 235, -2, 242, 250,
        0, 246, 254, 222, 0, 256, 0, 258, 259, 260,
        0, 129, 0, 76, 77, 78, 79, 80, 0, 82,
        83, 84, 85, 135, 139, 138, 13, 0, 0, 0,
        0, 0, 0, 182, 0, 0, 184, 0, 190, 185,
        0, 0, 0, 0, 0, 0, 0, 36, 0, 63,
        0, 210, 0, 198, 60, 0, 112, 118, 0, 0,
        127, 218, 0, 0, 0, 234, 0, 0, 0, 0,
        0, 0, 0, 264, 0, 0, 0, 0, 0, 223,
        255, 0, 0, 0, 130, 0, 0, 0, 0, 72,
        49, 0, 0, 95, 97, 98, 0, 0, 0, 0,
        0, 0, 0, 187, 188, 189, 0, 23, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 64, 68, 0,
        204, 0, 199, 210, 0, 0, 210, 183, 0, 0,
        165, 0, 0, 217, 217, 219, 230, 232, 236, 237,
        0, 0, 0, 0, 241, 248, 249, 251, 252, 253,
        0, 227, 0, 257, 261, 86, 87, 88, 89, 90,
        91, 92, 93, 0, 265, 266, 267, 268, 269, 270,
        0, 133, 0, 0, 0, 136, 0, 73, 74, 0,
        18, 0, 0, 103, 220, 0, 0, 0, 44, 0,
        24, 25, 0, 27, 28, 44, 0, 0, 0, 0,
        0, 206, 0, 0, 204, 61, 62, -2, 217, 0,
        0, 0, 0, 0, 0, 0, 179, 128, 238, 0,
        240, 0, 243, 0, 0, 0, 0, 0, 134, 131,
        132, 0, 94, 0, 0, 96, 99, 50, 0, 108,
        0, 0, 0, 0, 0, 29, 45, 46, 47, 22,
        0, 30, 0, 0, 58, 0, 57, 69, 53, 54,
        0, 205, 0, 206, 198, 192, -2, 0, 197, 172,
        0, 65, 72, 217, 0, 217, 217, 0, 217, 239,
        0, 0, 164, 224, 0, 228, 0, 0, 0, 75,
        0, 0, 106, 109, 0, 0, 0, 221, 20, 0,
        26, 32, 33, 52, 0, 56, 207, 211, 55, 200,
        194, 0, 0, 173, 0, 174, 0, 175, 176, 177,
        178, 244, 245, 0, 225, 262, 81, 17, 51, 101,
        107, 110, 104, 105, 21, 0, 202, 0, 210, 66,
        67, 217, 226, 100, 0, 0, 208, 0, 0, 0,
        180, 102, 59, 204, 0, 203, 201, 70, 0, 206,
        0, 0, 195, 119, 209, 214, 71, 0, 212, 215,
        216, 214, 213,
}

var yyTok1 = [...]uint8{
        1, 3, 3, 3, 3, 3, 3, 3, 3, 3,
        3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
        3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
        3, 3, 3, 3, 3, 3, 3, 128, 3, 3,
        131, 132, 126, 124, 123, 125, 129, 127, 3, 3,
        3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
        3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
        3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
        3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
        3, 133, 3, 134,
}

var yyTok2 = [...]uint8{
        2, 3, 4, 5, 6, 7, 8, 9, 10, 11,
        12, 13, 14, 15, 16, 17, 18, 19, 20, 21,
        22, 23, 24, 25, 26, 27, 28, 29, 30, 31,
        32, 33, 34, 35, 36, 37, 38, 39, 40, 41,
        42, 43, 44, 45, 46, 47, 48, 49, 50, 51,
        52, 53, 54, 55, 56, 57, 58, 59, 60, 61,
        62, 63, 64, 65, 66, 67, 68, 69, 70, 71,
        72, 73, 74, 75, 76, 77, 78, 79, 80, 81,
        82, 83, 84, 85, 86, 87, 88, 89, 90, 91,
        92, 93, 94, 95, 96, 97, 98, 99, 100, 101,
        102, 103, 104, 105, 106, 107, 108, 109, 110, 111,
        112, 113, 114, 115, 116, 117, 118, 119, 120, 121,
        122, 130,
}

var yyTok3 = [...]int8{
        0,
}

var yyErrorMessages = [...]struct {
        state int
        token int
        msg   string
}{}

/*        parser for yacc output        */

var (
        yyDebug        = 0
        yyErrorVerbose = false
)

type yyLexer interface {
        Lex(lval *yySymType) int
        Error(s string)
}

type yyParser interface {
        Parse(yyLexer) int
        Lookahead() int
}

type yyParserImpl struct {
        lval  yySymType
        stack [yyInitialStackSize]yySymType
        char  int
}

func (p *yyParserImpl) Lookahead() int {
        return p.char
}

func yyNewParser() yyParser {
        return &yyParserImpl{}
}

const yyFlag = -1000

func yyTokname(c int) string {
        if c >= 1 && c-1 < len(yyToknames) {
                if yyToknames[c-1] != "" {
                        return yyToknames[c-1]
                }
        }
        return __yyfmt__.Sprintf("tok-%v", c)
}

func yyStatname(s int) string {
        if s >= 0 && s < len(yyStatenames) {
                if yyStatenames[s] != "" {
                        return yyStatenames[s]
                }
        }
        return __yyfmt__.Sprintf("state-%v", s)
}

func yyErrorMessage(state, lookAhead int) string {
        const TOKSTART = 4

        if !yyErrorVerbose {
                return "syntax error"
        }

        for _, e := range yyErrorMessages {
                if e.state == state && e.token == lookAhead {
                        return "syntax error: " + e.msg
                }
        }

        res := "syntax error: unexpected " + yyTokname(lookAhead)

        // To match Bison, suggest at most four expected tokens.
        expected := make([]int, 0, 4)

        // Look for shiftable tokens.
        base := int(yyPact[state])
        for tok := TOKSTART; tok-1 < len(yyToknames); tok++ {
                if n := base + tok; n >= 0 && n < yyLast && int(yyChk[int(yyAct[n])]) == tok {
                        if len(expected) == cap(expected) {
                                return res
                        }
                        expected = append(expected, tok)
                }
        }

        if yyDef[state] == -2 {
                i := 0
                for yyExca[i] != -1 || int(yyExca[i+1]) != state {
                        i += 2
                }

                // Look for tokens that we accept or reduce.
                for i += 2; yyExca[i] >= 0; i += 2 {
                        tok := int(yyExca[i])
                        if tok < TOKSTART || yyExca[i+1] == 0 {
                                continue
                        }
                        if len(expected) == cap(expected) {
                                return res
                        }
                        expected = append(expected, tok)
                }

                // If the default action is to accept or reduce, give up.
                if yyExca[i+1] != 0 {
                        return res
                }
        }

        for i, tok := range expected {
                if i == 0 {
                        res += ", expecting "
                } else {
                        res += " or "
                }
                res += yyTokname(tok)
        }
        return res
}

func yylex1(lex yyLexer, lval *yySymType) (char, token int) {
        token = 0
        char = lex.Lex(lval)
        if char <= 0 {
                token = int(yyTok1[0])
                goto out
        }
        if char < len(yyTok1) {
                token = int(yyTok1[char])
                goto out
        }
        if char >= yyPrivate {
                if char < yyPrivate+len(yyTok2) {
                        token = int(yyTok2[char-yyPrivate])
                        goto out
                }
        }
        for i := 0; i < len(yyTok3); i += 2 {
                token = int(yyTok3[i+0])
                if token == char {
                        token = int(yyTok3[i+1])
                        goto out
                }
        }

out:
        if token == 0 {
                token = int(yyTok2[1]) /* unknown char */
        }
        if yyDebug >= 3 {
                __yyfmt__.Printf("lex %s(%d)\n", yyTokname(token), uint(char))
        }
        return char, token
}

func yyParse(yylex yyLexer) int {
        return yyNewParser().Parse(yylex)
}

func (yyrcvr *yyParserImpl) Parse(yylex yyLexer) int {
        var yyn int
        var yyVAL yySymType
        var yyDollar []yySymType
        _ = yyDollar // silence set and not used
        yyS := yyrcvr.stack[:]

        Nerrs := 0   /* number of errors */
        Errflag := 0 /* error recovery flag */
        yystate := 0
        yyrcvr.char = -1
        yytoken := -1 // yyrcvr.char translated into internal numbering
        defer func() {
                // Make sure we report no lookahead when not parsing.
                yystate = -1
                yyrcvr.char = -1
                yytoken = -1
        }()
        yyp := -1
        goto yystack

ret0:
        return 0

ret1:
        return 1

yystack:
        /* put a state and value onto the stack */
        if yyDebug >= 4 {
                __yyfmt__.Printf("char %v in %v\n", yyTokname(yytoken), yyStatname(yystate))
        }

        yyp++
        if yyp >= len(yyS) {
                nyys := make([]yySymType, len(yyS)*2)
                copy(nyys, yyS)
                yyS = nyys
        }
        yyS[yyp] = yyVAL
        yyS[yyp].yys = yystate

yynewstate:
        yyn = int(yyPact[yystate])
        if yyn <= yyFlag {
                goto yydefault /* simple state */
        }
        if yyrcvr.char < 0 {
                yyrcvr.char, yytoken = yylex1(yylex, &yyrcvr.lval)
        }
        yyn += yytoken
        if yyn < 0 || yyn >= yyLast {
                goto yydefault
        }
        yyn = int(yyAct[yyn])
        if int(yyChk[yyn]) == yytoken { /* valid shift */
                yyrcvr.char = -1
                yytoken = -1
                yyVAL = yyrcvr.lval
                yystate = yyn
                if Errflag > 0 {
                        Errflag--
                }
                goto yystack
        }

yydefault:
        /* default state action */
        yyn = int(yyDef[yystate])
        if yyn == -2 {
                if yyrcvr.char < 0 {
                        yyrcvr.char, yytoken = yylex1(yylex, &yyrcvr.lval)
                }

                /* look through exception table */
                xi := 0
                for {
                        if yyExca[xi+0] == -1 && int(yyExca[xi+1]) == yystate {
                                break
                        }
                        xi += 2
                }
                for xi += 2; ; xi += 2 {
                        yyn = int(yyExca[xi+0])
                        if yyn < 0 || yyn == yytoken {
                                break
                        }
                }
                yyn = int(yyExca[xi+1])
                if yyn < 0 {
                        goto ret0
                }
        }
        if yyn == 0 {
                /* error ... attempt to resume parsing */
                switch Errflag {
                case 0: /* brand new error */
                        yylex.Error(yyErrorMessage(yystate, yytoken))
                        Nerrs++
                        if yyDebug >= 1 {
                                __yyfmt__.Printf("%s", yyStatname(yystate))
                                __yyfmt__.Printf(" saw %s\n", yyTokname(yytoken))
                        }
                        fallthrough

                case 1, 2: /* incompletely recovered error ... try again */
                        Errflag = 3

                        /* find a state where "error" is a legal shift action */
                        for yyp >= 0 {
                                yyn = int(yyPact[yyS[yyp].yys]) + yyErrCode
                                if yyn >= 0 && yyn < yyLast {
                                        yystate = int(yyAct[yyn]) /* simulate a shift of "error" */
                                        if int(yyChk[yystate]) == yyErrCode {
                                                goto yystack
                                        }
                                }

                                /* the current p has no shift on "error", pop stack */
                                if yyDebug >= 2 {
                                        __yyfmt__.Printf("error recovery pops state %d\n", yyS[yyp].yys)
                                }
                                yyp--
                        }
                        /* there is no state on the stack with an error shift ... abort */
                        goto ret1

                case 3: /* no shift yet; clobber input char */
                        if yyDebug >= 2 {
                                __yyfmt__.Printf("error recovery discards %s\n", yyTokname(yytoken))
                        }
                        if yytoken == yyEofCode {
                                goto ret1
                        }
                        yyrcvr.char = -1
                        yytoken = -1
                        goto yynewstate /* try again in the same state */
                }
        }

        /* reduction by production yyn */
        if yyDebug >= 2 {
                __yyfmt__.Printf("reduce %v in:\n\t%v\n", yyn, yyStatname(yystate))
        }

        yynt := yyn
        yypt := yyp
        _ = yypt // guard against "declared and not used"

        yyp -= int(yyR2[yyn])
        // yyp is now the index of $0. Perform the default action. Iff the
        // reduced production is ε, $1 is possibly out of range.
        if yyp+1 >= len(yyS) {
                nyys := make([]yySymType, len(yyS)*2)
                copy(nyys, yyS)
                yyS = nyys
        }
        yyVAL = yyS[yyp+1]

        /* consult goto table to find next state */
        yyn = int(yyR1[yyn])
        yyg := int(yyPgo[yyn])
        yyj := yyg + yyS[yyp].yys + 1

        if yyj >= yyLast {
                yystate = int(yyAct[yyg])
        } else {
                yystate = int(yyAct[yyj])
                if int(yyChk[yystate]) != -yyn {
                        yystate = int(yyAct[yyg])
                }
        }
        // dummy call; replaced with literal code
        switch yynt {

        case 1:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.stmts = yyDollar[1].stmts
                        setResult(yylex, yyDollar[1].stmts)
                }
        case 2:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.stmts = []SQLStmt{yyDollar[1].stmt}
                }
        case 3:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.stmts = append([]SQLStmt{yyDollar[1].stmt}, yyDollar[3].stmts...)
                }
        case 4:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                }
        case 9:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.stmt = &BeginTransactionStmt{}
                }
        case 10:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.stmt = &BeginTransactionStmt{}
                }
        case 11:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.stmt = &CommitStmt{}
                }
        case 12:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.stmt = &RollbackStmt{}
                }
        case 13:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.stmt = &CreateDatabaseStmt{ifNotExists: yyDollar[3].boolean, DB: yyDollar[4].id}
                }
        case 14:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.stmt = &UseDatabaseStmt{DB: yyDollar[2].id}
                }
        case 15:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.stmt = &UseDatabaseStmt{DB: yyDollar[3].id}
                }
        case 16:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.stmt = &UseSnapshotStmt{period: yyDollar[3].period}
                }
        case 17:
                yyDollar = yyS[yypt-9 : yypt+1]
                {
                        yyVAL.stmt = newCreateTableStmt(yyDollar[6].str, yyDollar[8].tableElems, true)
                }
        case 18:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.stmt = newCreateTableStmt(yyDollar[3].str, yyDollar[5].tableElems, false)
                }
        case 19:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.stmt = &DropTableStmt{table: yyDollar[3].id}
                }
        case 20:
                yyDollar = yyS[yypt-8 : yypt+1]
                {
                        yyVAL.stmt = &CreateIndexStmt{ifNotExists: yyDollar[3].boolean, table: yyDollar[5].id, cols: yyDollar[7].ids}
                }
        case 21:
                yyDollar = yyS[yypt-9 : yypt+1]
                {
                        yyVAL.stmt = &CreateIndexStmt{unique: true, ifNotExists: yyDollar[4].boolean, table: yyDollar[6].id, cols: yyDollar[8].ids}
                }
        case 22:
                yyDollar = yyS[yypt-7 : yypt+1]
                {
                        yyVAL.stmt = &DropIndexStmt{table: yyDollar[4].id, cols: yyDollar[6].ids}
                }
        case 23:
                yyDollar = yyS[yypt-5 : yypt+1]
                {
                        yyVAL.stmt = &DropIndexStmt{table: yyDollar[3].id, cols: []string{yyDollar[5].id}}
                }
        case 24:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.stmt = &AddColumnStmt{table: yyDollar[3].id, colSpec: yyDollar[6].colSpec}
                }
        case 25:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.stmt = &RenameTableStmt{oldName: yyDollar[3].id, newName: yyDollar[6].id}
                }
        case 26:
                yyDollar = yyS[yypt-8 : yypt+1]
                {
                        yyVAL.stmt = &RenameColumnStmt{table: yyDollar[3].id, oldName: yyDollar[6].id, newName: yyDollar[8].id}
                }
        case 27:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.stmt = &DropColumnStmt{table: yyDollar[3].id, colName: yyDollar[6].id}
                }
        case 28:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.stmt = &DropConstraintStmt{table: yyDollar[3].id, constraintName: yyDollar[6].id}
                }
        case 29:
                yyDollar = yyS[yypt-7 : yypt+1]
                {
                        yyVAL.stmt = &CreateUserStmt{username: yyDollar[3].id, password: yyDollar[6].str, permission: yyDollar[7].permission}
                }
        case 30:
                yyDollar = yyS[yypt-7 : yypt+1]
                {
                        yyVAL.stmt = &AlterUserStmt{username: yyDollar[3].id, password: yyDollar[6].str, permission: yyDollar[7].permission}
                }
        case 31:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.stmt = &DropUserStmt{username: yyDollar[3].id}
                }
        case 32:
                yyDollar = yyS[yypt-8 : yypt+1]
                {
                        yyVAL.stmt = &AlterPrivilegesStmt{database: yyDollar[5].id, user: yyDollar[8].id, privileges: yyDollar[2].sqlPrivileges, isGrant: true}
                }
        case 33:
                yyDollar = yyS[yypt-8 : yypt+1]
                {
                        yyVAL.stmt = &AlterPrivilegesStmt{database: yyDollar[5].id, user: yyDollar[8].id, privileges: yyDollar[2].sqlPrivileges}
                }
        case 34:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.sqlPrivileges = allPrivileges
                }
        case 35:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlPrivileges = []SQLPrivilege{yyDollar[1].sqlPrivilege}
                }
        case 36:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.sqlPrivileges = append(yyDollar[3].sqlPrivileges, yyDollar[1].sqlPrivilege)
                }
        case 37:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlPrivilege = SQLPrivilegeSelect
                }
        case 38:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlPrivilege = SQLPrivilegeCreate
                }
        case 39:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlPrivilege = SQLPrivilegeInsert
                }
        case 40:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlPrivilege = SQLPrivilegeUpdate
                }
        case 41:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlPrivilege = SQLPrivilegeDelete
                }
        case 42:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlPrivilege = SQLPrivilegeDrop
                }
        case 43:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlPrivilege = SQLPrivilegeAlter
                }
        case 44:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.permission = PermissionReadWrite
                }
        case 45:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.permission = PermissionReadOnly
                }
        case 46:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.permission = PermissionReadWrite
                }
        case 47:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.permission = PermissionAdmin
                }
        case 48:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.boolean = false
                }
        case 49:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.boolean = true
                }
        case 50:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.ids = []string{yyDollar[1].id}
                }
        case 51:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.ids = yyDollar[2].ids
                }
        case 52:
                yyDollar = yyS[yypt-8 : yypt+1]
                {
                        yyVAL.stmt = &UpsertIntoStmt{isInsert: true, tableRef: yyDollar[3].tableRef, cols: yyDollar[5].ids, ds: yyDollar[7].ds, onConflict: yyDollar[8].onConflict}
                }
        case 53:
                yyDollar = yyS[yypt-7 : yypt+1]
                {
                        yyVAL.stmt = &UpsertIntoStmt{tableRef: yyDollar[3].tableRef, cols: yyDollar[5].ids, ds: yyDollar[7].ds}
                }
        case 54:
                yyDollar = yyS[yypt-7 : yypt+1]
                {
                        yyVAL.stmt = &DeleteFromStmt{tableRef: yyDollar[3].tableRef, where: yyDollar[4].exp, indexOn: yyDollar[5].ids, limit: yyDollar[6].exp, offset: yyDollar[7].exp}
                }
        case 55:
                yyDollar = yyS[yypt-8 : yypt+1]
                {
                        yyVAL.stmt = &UpdateStmt{tableRef: yyDollar[2].tableRef, updates: yyDollar[4].updates, where: yyDollar[5].exp, indexOn: yyDollar[6].ids, limit: yyDollar[7].exp, offset: yyDollar[8].exp}
                }
        case 56:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.ds = &valuesDataSource{rows: yyDollar[2].rows}
                }
        case 57:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.ds = yyDollar[1].stmt.(DataSource)
                }
        case 58:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.onConflict = nil
                }
        case 59:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.onConflict = &OnConflictDo{}
                }
        case 60:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.updates = []*colUpdate{yyDollar[1].update}
                }
        case 61:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.updates = append(yyDollar[1].updates, yyDollar[3].update)
                }
        case 62:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.update = &colUpdate{col: yyDollar[1].id, op: yyDollar[2].cmpOp, val: yyDollar[3].exp}
                }
        case 63:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.ids = nil
                }
        case 64:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.ids = yyDollar[1].ids
                }
        case 65:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.rows = []*RowSpec{yyDollar[1].row}
                }
        case 66:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.rows = append(yyDollar[1].rows, yyDollar[3].row)
                }
        case 67:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.row = &RowSpec{Values: yyDollar[2].values}
                }
        case 68:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.ids = []string{yyDollar[1].id}
                }
        case 69:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.ids = append(yyDollar[1].ids, yyDollar[3].id)
                }
        case 70:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.cols = []*ColSelector{yyDollar[1].col}
                }
        case 71:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.cols = append(yyDollar[1].cols, yyDollar[3].col)
                }
        case 72:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.values = nil
                }
        case 73:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.values = yyDollar[1].values
                }
        case 74:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.values = []ValueExp{yyDollar[1].exp}
                }
        case 75:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.values = append(yyDollar[1].values, yyDollar[3].exp)
                }
        case 76:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = &Integer{val: int64(yyDollar[1].integer)}
                }
        case 77:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = &Float64{val: float64(yyDollar[1].float)}
                }
        case 78:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = &Varchar{val: yyDollar[1].str}
                }
        case 79:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = &Bool{val: yyDollar[1].boolean}
                }
        case 80:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = &Blob{val: yyDollar[1].blob}
                }
        case 81:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.value = &Cast{val: yyDollar[3].exp, t: yyDollar[5].sqlType}
                }
        case 82:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = yyDollar[1].value
                }
        case 83:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = &Param{id: yyDollar[1].id}
                }
        case 84:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = &Param{id: fmt.Sprintf("param%d", yyDollar[1].pparam), pos: yyDollar[1].pparam}
                }
        case 85:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.value = &NullValue{t: AnyType}
                }
        case 86:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlType = IntegerType
                }
        case 87:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlType = BooleanType
                }
        case 88:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlType = VarcharType
                }
        case 89:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlType = UUIDType
                }
        case 90:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlType = BLOBType
                }
        case 91:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlType = TimestampType
                }
        case 92:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlType = Float64Type
                }
        case 93:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sqlType = JSONType
                }
        case 94:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.value = &FnCall{fn: yyDollar[1].id, params: yyDollar[3].values}
                }
        case 95:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.tableElems = []TableElem{yyDollar[1].tableElem}
                }
        case 96:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.tableElems = append(yyDollar[1].tableElems, yyDollar[3].tableElem)
                }
        case 97:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.tableElem = yyDollar[1].colSpec
                }
        case 98:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.tableElem = yyDollar[1].check
                }
        case 99:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.tableElem = PrimaryKeyConstraint(yyDollar[3].ids)
                }
        case 100:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.colSpec = &ColSpec{colName: yyDollar[1].id, colType: yyDollar[2].sqlType, maxLen: int(yyDollar[3].integer), notNull: yyDollar[4].boolean || yyDollar[6].boolean, autoIncrement: yyDollar[5].boolean, primaryKey: yyDollar[6].boolean}
                }
        case 101:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.boolean = false
                }
        case 102:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.boolean = true
                }
        case 103:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.integer = 0
                }
        case 104:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.integer = yyDollar[2].integer
                }
        case 105:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.integer = yyDollar[2].integer
                }
        case 106:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.boolean = false
                }
        case 107:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.boolean = true
                }
        case 108:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.boolean = false
                }
        case 109:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.boolean = false
                }
        case 110:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.boolean = true
                }
        case 111:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.stmt = yyDollar[1].stmt
                }
        case 112:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.stmt = &UnionStmt{
                                distinct: yyDollar[3].distinct,
                                left:     yyDollar[1].stmt.(DataSource),
                                right:    yyDollar[4].stmt.(DataSource),
                        }
                }
        case 113:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.stmt = &SelectStmt{
                                ds: &FnDataSourceStmt{fnCall: &FnCall{fn: "databases"}},
                        }
                }
        case 114:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.stmt = &SelectStmt{
                                ds: &FnDataSourceStmt{fnCall: &FnCall{fn: "tables"}},
                        }
                }
        case 115:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.stmt = &SelectStmt{
                                ds: &FnDataSourceStmt{fnCall: &FnCall{fn: "table", params: []ValueExp{&Varchar{val: yyDollar[3].id}}}},
                        }
                }
        case 116:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.stmt = &SelectStmt{
                                ds: &FnDataSourceStmt{fnCall: &FnCall{fn: "users"}},
                        }
                }
        case 117:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.stmt = &SelectStmt{
                                ds: &FnDataSourceStmt{fnCall: &FnCall{fn: "grants"}},
                        }
                }
        case 118:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.stmt = &SelectStmt{
                                ds: &FnDataSourceStmt{fnCall: &FnCall{fn: "grants", params: []ValueExp{&Varchar{val: yyDollar[4].id}}}},
                        }
                }
        case 119:
                yyDollar = yyS[yypt-13 : yypt+1]
                {
                        yyVAL.stmt = &SelectStmt{
                                distinct: yyDollar[2].distinct,
                                targets:  yyDollar[3].targets,
                                ds:       yyDollar[5].ds,
                                indexOn:  yyDollar[6].ids,
                                joins:    yyDollar[7].joins,
                                where:    yyDollar[8].exp,
                                groupBy:  yyDollar[9].cols,
                                having:   yyDollar[10].exp,
                                orderBy:  yyDollar[11].ordexps,
                                limit:    yyDollar[12].exp,
                                offset:   yyDollar[13].exp,
                        }
                }
        case 120:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.stmt = &SelectStmt{
                                distinct: yyDollar[2].distinct,
                                targets:  yyDollar[3].targets,
                                ds:       &valuesDataSource{rows: []*RowSpec{{}}},
                        }
                }
        case 121:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.distinct = true
                }
        case 122:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.distinct = false
                }
        case 123:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.distinct = false
                }
        case 124:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.distinct = true
                }
        case 125:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.targets = nil
                }
        case 126:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.targets = yyDollar[1].targets
                }
        case 127:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.targets = []TargetEntry{{Exp: yyDollar[1].exp, As: yyDollar[2].id}}
                }
        case 128:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.targets = append(yyDollar[1].targets, TargetEntry{Exp: yyDollar[3].exp, As: yyDollar[4].id})
                }
        case 129:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.sel = yyDollar[1].col
                }
        case 130:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.sel = &JSONSelector{ColSelector: yyDollar[1].col, fields: yyDollar[2].jsonFields}
                }
        case 131:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.sel = &AggColSelector{aggFn: yyDollar[1].aggFn, col: "*"}
                }
        case 132:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.sel = &AggColSelector{aggFn: yyDollar[1].aggFn, table: yyDollar[3].col.table, col: yyDollar[3].col.col}
                }
        case 133:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.jsonFields = []string{yyDollar[2].str}
                }
        case 134:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.jsonFields = append(yyVAL.jsonFields, yyDollar[3].str)
                }
        case 135:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.col = &ColSelector{col: yyDollar[1].str}
                }
        case 136:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.col = &ColSelector{table: yyDollar[1].str, col: yyDollar[3].str}
                }
        case 139:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.str = yyDollar[1].id
                }
        case 140:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.str = string(yyDollar[1].keyword)
                }
        case 172:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyDollar[1].tableRef.period = yyDollar[2].period
                        yyDollar[1].tableRef.as = yyDollar[3].id
                        yyVAL.ds = yyDollar[1].tableRef
                }
        case 173:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.ds = &valuesDataSource{inferTypes: true, rows: yyDollar[3].rows}
                }
        case 174:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyDollar[2].stmt.(*SelectStmt).as = yyDollar[4].id
                        yyVAL.ds = yyDollar[2].stmt.(DataSource)
                }
        case 175:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.ds = &FnDataSourceStmt{fnCall: &FnCall{fn: "databases"}, as: yyDollar[4].id}
                }
        case 176:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.ds = &FnDataSourceStmt{fnCall: &FnCall{fn: "tables"}, as: yyDollar[4].id}
                }
        case 177:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.ds = &FnDataSourceStmt{fnCall: &FnCall{fn: "table", params: []ValueExp{&Varchar{val: yyDollar[3].id}}}}
                }
        case 178:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.ds = &FnDataSourceStmt{fnCall: &FnCall{fn: "users"}, as: yyDollar[4].id}
                }
        case 179:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.ds = &FnDataSourceStmt{fnCall: yyDollar[1].value.(*FnCall), as: yyDollar[2].id}
                }
        case 180:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.ds = &tableRef{table: yyDollar[4].id, history: true, as: yyDollar[6].id}
                }
        case 181:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.tableRef = &tableRef{table: yyDollar[1].str}
                }
        case 182:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.period = period{start: yyDollar[1].openPeriod, end: yyDollar[2].openPeriod}
                }
        case 183:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.openPeriod = nil
                }
        case 184:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.openPeriod = &openPeriod{inclusive: true, instant: yyDollar[2].periodInstant}
                }
        case 185:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.openPeriod = &openPeriod{instant: yyDollar[2].periodInstant}
                }
        case 186:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.openPeriod = nil
                }
        case 187:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.openPeriod = &openPeriod{inclusive: true, instant: yyDollar[2].periodInstant}
                }
        case 188:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.openPeriod = &openPeriod{instant: yyDollar[2].periodInstant}
                }
        case 189:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.periodInstant = periodInstant{instantType: txInstant, exp: yyDollar[2].exp}
                }
        case 190:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.periodInstant = periodInstant{instantType: timeInstant, exp: yyDollar[1].exp}
                }
        case 191:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.joins = nil
                }
        case 192:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.joins = yyDollar[1].joins
                }
        case 193:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.joins = []*JoinSpec{yyDollar[1].join}
                }
        case 194:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.joins = append([]*JoinSpec{yyDollar[1].join}, yyDollar[2].joins...)
                }
        case 195:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.join = &JoinSpec{joinType: yyDollar[1].joinType, ds: yyDollar[3].ds, indexOn: yyDollar[4].ids, cond: yyDollar[6].exp}
                }
        case 196:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.joinType = InnerJoin
                }
        case 197:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.joinType = yyDollar[1].joinType
                }
        case 198:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.exp = nil
                }
        case 199:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.exp = yyDollar[2].exp
                }
        case 200:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.cols = nil
                }
        case 201:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.cols = yyDollar[3].cols
                }
        case 202:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.exp = nil
                }
        case 203:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.exp = yyDollar[2].exp
                }
        case 204:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.exp = nil
                }
        case 205:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.exp = yyDollar[2].exp
                }
        case 206:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.exp = nil
                }
        case 207:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.exp = yyDollar[2].exp
                }
        case 208:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.ordexps = nil
                }
        case 209:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.ordexps = yyDollar[3].ordexps
                }
        case 210:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.ids = nil
                }
        case 211:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.ids = yyDollar[4].ids
                }
        case 212:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.ordexps = []*OrdExp{{exp: yyDollar[1].exp, descOrder: yyDollar[2].opt_ord}}
                }
        case 213:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.ordexps = append(yyDollar[1].ordexps, &OrdExp{exp: yyDollar[3].exp, descOrder: yyDollar[4].opt_ord})
                }
        case 214:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.opt_ord = false
                }
        case 215:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.opt_ord = false
                }
        case 216:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.opt_ord = true
                }
        case 217:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.id = ""
                }
        case 218:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.id = yyDollar[1].str
                }
        case 219:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.id = yyDollar[2].str
                }
        case 220:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.check = CheckConstraint{exp: yyDollar[2].exp}
                }
        case 221:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.check = CheckConstraint{name: yyDollar[2].id, exp: yyDollar[4].exp}
                }
        case 222:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.exp = nil
                }
        case 223:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.exp = yyDollar[1].exp
                }
        case 224:
                yyDollar = yyS[yypt-5 : yypt+1]
                {
                        yyVAL.exp = &CaseWhenExp{
                                exp:      yyDollar[2].exp,
                                whenThen: yyDollar[3].whenThenClauses,
                                elseExp:  yyDollar[4].exp,
                        }
                }
        case 225:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.whenThenClauses = []whenThenClause{{when: yyDollar[2].exp, then: yyDollar[4].exp}}
                }
        case 226:
                yyDollar = yyS[yypt-5 : yypt+1]
                {
                        yyVAL.whenThenClauses = append(yyDollar[1].whenThenClauses, whenThenClause{when: yyDollar[3].exp, then: yyDollar[5].exp})
                }
        case 227:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.exp = nil
                }
        case 228:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.exp = yyDollar[2].exp
                }
        case 229:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.exp = yyDollar[1].exp
                }
        case 230:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &BinBoolExp{left: yyDollar[1].exp, op: Or, right: yyDollar[3].exp}
                }
        case 232:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &BinBoolExp{left: yyDollar[1].exp, op: And, right: yyDollar[3].exp}
                }
        case 234:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        yyVAL.exp = &NotBoolExp{exp: yyDollar[2].exp}
                }
        case 236:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &CmpBoolExp{left: yyDollar[1].exp, op: yyDollar[2].cmpOp, right: yyDollar[3].exp}
                }
        case 237:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &CmpBoolExp{left: yyDollar[1].exp, op: EQ, right: &NullValue{t: AnyType}}
                }
        case 238:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.exp = &CmpBoolExp{left: yyDollar[1].exp, op: NE, right: &NullValue{t: AnyType}}
                }
        case 239:
                yyDollar = yyS[yypt-5 : yypt+1]
                {
                        yyVAL.exp = &BinBoolExp{
                                left: &CmpBoolExp{
                                        left:  yyDollar[1].exp,
                                        op:    GE,
                                        right: yyDollar[3].exp,
                                },
                                op: And,
                                right: &CmpBoolExp{
                                        left:  yyDollar[1].exp,
                                        op:    LE,
                                        right: yyDollar[5].exp,
                                },
                        }
                }
        case 240:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.exp = &LikeBoolExp{val: yyDollar[1].exp, notLike: yyDollar[2].boolean, pattern: yyDollar[4].exp}
                }
        case 241:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &LikeBoolExp{val: yyDollar[1].exp, notLike: true, pattern: yyDollar[3].exp}
                }
        case 243:
                yyDollar = yyS[yypt-4 : yypt+1]
                {
                        yyVAL.exp = &ExistsBoolExp{q: (yyDollar[3].stmt).(DataSource)}
                }
        case 244:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.exp = &InSubQueryExp{val: yyDollar[1].exp, notIn: yyDollar[2].boolean, q: yyDollar[5].stmt.(*SelectStmt)}
                }
        case 245:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.exp = &InListExp{val: yyDollar[1].exp, notIn: yyDollar[2].boolean, values: yyDollar[5].values}
                }
        case 246:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.exp = yyDollar[1].exp
                }
        case 248:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &NumExp{left: yyDollar[1].exp, op: ADDOP, right: yyDollar[3].exp}
                }
        case 249:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &NumExp{left: yyDollar[1].exp, op: SUBSOP, right: yyDollar[3].exp}
                }
        case 251:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &NumExp{left: yyDollar[1].exp, op: MULTOP, right: yyDollar[3].exp}
                }
        case 252:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &NumExp{left: yyDollar[1].exp, op: DIVOP, right: yyDollar[3].exp}
                }
        case 253:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &NumExp{left: yyDollar[1].exp, op: MODOP, right: yyDollar[3].exp}
                }
        case 255:
                yyDollar = yyS[yypt-2 : yypt+1]
                {
                        i, isInt := yyDollar[2].exp.(*Integer)
                        if isInt {
                                i.val = -i.val
                                yyVAL.exp = i
                        } else {
                                yyVAL.exp = &NumExp{left: &Integer{val: 0}, op: SUBSOP, right: yyDollar[2].exp}
                        }
                }
        case 257:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = yyDollar[2].exp
                }
        case 259:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.exp = yyDollar[1].sel
                }
        case 260:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.exp = yyDollar[1].value
                }
        case 261:
                yyDollar = yyS[yypt-3 : yypt+1]
                {
                        yyVAL.exp = &Cast{val: yyDollar[1].exp, t: yyDollar[3].sqlType}
                }
        case 262:
                yyDollar = yyS[yypt-6 : yypt+1]
                {
                        yyVAL.exp = &ExtractFromTimestampExp{Field: yyDollar[3].timestampField, Exp: yyDollar[5].exp}
                }
        case 263:
                yyDollar = yyS[yypt-0 : yypt+1]
                {
                        yyVAL.boolean = false
                }
        case 264:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.boolean = true
                }
        case 265:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.timestampField = TimestampFieldTypeYear
                }
        case 266:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.timestampField = TimestampFieldTypeMonth
                }
        case 267:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.timestampField = TimestampFieldTypeDay
                }
        case 268:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.timestampField = TimestampFieldTypeHour
                }
        case 269:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.timestampField = TimestampFieldTypeMinute
                }
        case 270:
                yyDollar = yyS[yypt-1 : yypt+1]
                {
                        yyVAL.timestampField = TimestampFieldTypeSecond
                }
        }
        goto yystack /* stack new state and value */
}

codenotary / immudb / 18243888765

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous