1 Star 0 Fork 0

wenj91/sqls

加入 Gitee
与超过 1400万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
vertica.go 8.20 KB
一键复制 编辑 原始数据 按行查看 历史
Andreas Gerler 提交于 2022-03-17 19:34 +08:00 . add support for Vertica
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649
package dialect
// SELECT '"' || keyword || '",' FROM v_catalog.keywords WHERE reserved = 'R';
var verticaReservedWords = []string{
"ALL",
"AND",
"ANY",
"ARRAY",
"AS",
"ASC",
"AUTHORIZATION",
"BETWEEN",
"BIGINT",
"BINARY",
"BIT",
"BOOLEAN",
"BOTH",
"CASE",
"CAST",
"CHAR",
"CHAR_LENGTH",
"CHARACTER_LENGTH",
"CHECK",
"COLLATE",
"COLUMN",
"CONSTRAINT",
"CORRELATION",
"CREATE",
"CROSS",
"CURRENT_DATABASE",
"CURRENT_DATE",
"CURRENT_SCHEMA",
"CURRENT_TIME",
"CURRENT_TIMESTAMP",
"CURRENT_USER",
"DATEDIFF",
"DATETIME",
"DECIMAL",
"DECODE",
"DEFAULT",
"DEFERRABLE",
"DESC",
"DISTINCT",
"ELSE",
"ENCODED",
"END",
"EXCEPT",
"EXISTS",
"EXTRACT",
"FALSE",
"FLOAT",
"FOR",
"FOREIGN",
"FROM",
"FULL",
"GRANT",
"GROUP",
"HAVING",
"ILIKE",
"ILIKEB",
"IN",
"INITIALLY",
"INNER",
"INOUT",
"INT",
"INTEGER",
"INTERSECT",
"INTERVAL",
"INTERVALYM",
"INTO",
"IS",
"ISNULL",
"JOIN",
"KSAFE",
"LEADING",
"LEFT",
"LIKE",
"LIKEB",
"LIMIT",
"LOCALTIME",
"LOCALTIMESTAMP",
"MATCH",
"MINUS",
"MONEY",
"NATURAL",
"NCHAR",
"NEW",
"NONE",
"NOT",
"NOTNULL",
"NULL",
"NULLSEQUAL",
"NUMBER",
"NUMERIC",
"OFFSET",
"OLD",
"ON",
"ONLY",
"OR",
"ORDER",
"OUT",
"OUTER",
"OVER",
"OVERLAPS",
"OVERLAY",
"PINNED",
"POSITION",
"PRECISION",
"PRIMARY",
"REAL",
"REFERENCES",
"RIGHT",
"ROW",
"SCHEMA",
"SELECT",
"SESSION_USER",
"SIMILAR",
"SMALLDATETIME",
"SMALLINT",
"SOME",
"SUBSTRING",
"SYSDATE",
"TABLE",
"TEXT",
"THEN",
"TIME",
"TIMESERIES",
"TIMESTAMP",
"TIMESTAMPADD",
"TIMESTAMPDIFF",
"TIMESTAMPTZ",
"TIMETZ",
"TIMEZONE",
"TINYINT",
"TO",
"TRAILING",
"TREAT",
"TRIM",
"TRUE",
"UNBOUNDED",
"UNION",
"UNIQUE",
"USER",
"USING",
"UUID",
"VARBINARY",
"VARCHAR",
"VARCHAR2",
"WHEN",
"WHERE",
"WINDOW",
"WITH",
"WITHIN",
}
// SELECT '"' || keyword || '",' FROM v_catalog.keywords WHERE reserved = 'N';
var verticaKeywords = []string{
"ABORT",
"ABSOLUTE",
"ACCESS",
"ACCESSRANK",
"ACCOUNT",
"ACTION",
"ACTIVATE",
"ACTIVEPARTITIONCOUNT",
"ADD",
"ADDRESS",
"ADMIN",
"AFTER",
"AGGREGATE",
"ALSO",
"ALTER",
"ANALYSE",
"ANALYTIC",
"ANALYZE",
"ANNOTATED",
"ANTI",
"ASSERTION",
"ASSIGNMENT",
"AT",
"AUTHENTICATION",
"AUTO",
"AUTO_INCREMENT",
"AVAILABLE",
"BACKWARD",
"BALANCE",
"BASENAME",
"BATCH",
"BEFORE",
"BEGIN",
"BEST",
"BLOCK",
"BLOCK_DICT",
"BLOCKDICT_COMP",
"BROADCAST",
"BUNDLE",
"BY",
"BYTEA",
"BYTES",
"BZIP",
"BZIP_COMP",
"CA",
"CACHE",
"CALL",
"CALLED",
"CASCADE",
"CATALOGPATH",
"CERTIFICATE",
"CERTIFICATES",
"CHAIN",
"CHARACTER",
"CHARACTERISTICS",
"CHARACTERS",
"CHECKPOINT",
"CIPHER",
"CLASS",
"CLEAR",
"CLOSE",
"CLUSTER",
"COLLECTIONCLOSE",
"COLLECTIONDELIMITER",
"COLLECTIONENCLOSE",
"COLLECTIONNULLELEMENT",
"COLLECTIONOPEN",
"COLSIZES",
"COLUMNS_COUNT",
"COMMENT",
"COMMIT",
"COMMITTED",
"COMMONDELTA_COMP",
"COMMUNAL",
"COMPLEX",
"CONFIGURATION",
"CONNECT",
"CONSTRAINTS",
"CONTROL",
"COPY",
"CPUAFFINITYMODE",
"CPUAFFINITYSET",
"CREATEDB",
"CREATEUSER",
"CSV",
"CUBE",
"CURRENT",
"CURSOR",
"CUSTOM",
"CUSTOM_PARTITIONS",
"CYCLE",
"DATA",
"DATABASE",
"DATAPATH",
"DAY",
"DEACTIVATE",
"DEALLOCATE",
"DEBUG",
"DEC",
"DECLARE",
"DEFAULTS",
"DEFERRED",
"DEFINE",
"DEFINER",
"DELETE",
"DELIMITED",
"DELIMITER",
"DELIMITERS",
"DELTARANGE_COMP",
"DELTARANGE_COMP_SP",
"DELTAVAL",
"DEPENDS",
"DETERMINES",
"DIRECT",
"DIRECTCOLS",
"DIRECTED",
"DIRECTGROUPED",
"DIRECTPROJ",
"DISABLE",
"DISABLED",
"DISCONNECT",
"DISTVALINDEX",
"DO",
"DOMAIN",
"DOUBLE",
"DROP",
"DURABLE",
"EACH",
"ENABLE",
"ENABLED",
"ENCLOSED",
"ENCODING",
"ENCRYPTED",
"ENFORCELENGTH",
"EPHEMERAL",
"EPOCH",
"ERROR",
"ESCAPE",
"EVENT",
"EVENTS",
"EXCEPTION",
"EXCEPTIONS",
"EXCLUDE",
"EXCLUDING",
"EXCLUSIVE",
"EXECUTE",
"EXECUTIONPARALLELISM",
"EXPIRE",
"EXPLAIN",
"EXPORT",
"EXTEND",
"EXTENSIONS",
"EXTERNAL",
"FAILED_LOGIN_ATTEMPTS",
"FAULT",
"FENCED",
"FETCH",
"FILESYSTEM",
"FILLER",
"FILTER",
"FIRST",
"FIXEDWIDTH",
"FLEX",
"FLEXIBLE",
"FOLLOWING",
"FORCE",
"FORMAT",
"FORWARD",
"FREEZE",
"FUNCTION",
"FUNCTIONS",
"GCDDELTA",
"GET",
"GLOBAL",
"GRACEPERIOD",
"GROUPED",
"GROUPING",
"GZIP",
"GZIP_COMP",
"HANDLER",
"HCATALOG",
"HCATALOG_CONNECTION_TIMEOUT",
"HCATALOG_DB",
"HCATALOG_SCHEMA",
"HCATALOG_SLOW_TRANSFER_LIMIT",
"HCATALOG_SLOW_TRANSFER_TIME",
"HCATALOG_USER",
"HIGH",
"HIVESERVER2_HOSTNAME",
"HOLD",
"HOST",
"HOSTNAME",
"HOUR",
"HOURS",
"IDENTIFIED",
"IDENTITY",
"IDLESESSIONTIMEOUT",
"IF",
"IGNORE",
"IMMEDIATE",
"IMMUTABLE",
"IMPLICIT",
"INCLUDE",
"INCLUDING",
"INCREMENT",
"INDEX",
"INHERITS",
"INPUT",
"INSENSITIVE",
"INSERT",
"INSTEAD",
"INTERFACE",
"INTERPOLATE",
"INVOKER",
"ISOLATION",
"JSON",
"KEY",
"LABEL",
"LANCOMPILER",
"LANGUAGE",
"LARGE",
"LAST",
"LATEST",
"LENGTH",
"LESS",
"LEVEL",
"LIBRARY",
"LISTEN",
"LOAD",
"LOCAL",
"LOCATION",
"LOCK",
"LONG",
"LOW",
"LZO",
"MANAGED",
"MAP",
"MASK",
"MATCHED",
"MATERIALIZE",
"MAXCONCURRENCY",
"MAXCONCURRENCYGRACE",
"MAXCONNECTIONS",
"MAXMEMORYSIZE",
"MAXPAYLOAD",
"MAXQUERYMEMORYSIZE",
"MAXVALUE",
"MEDIUM",
"MEMORYCAP",
"MEMORYSIZE",
"MERGE",
"MERGEOUT",
"METHOD",
"MICROSECONDS",
"MILLISECONDS",
"MINUTE",
"MINUTES",
"MINVALUE",
"MODE",
"MODEL",
"MONTH",
"MOVE",
"MOVEOUT",
"NAME",
"NATIONAL",
"NATIVE",
"NETWORK",
"NEXT",
"NO",
"NOCREATEDB",
"NOCREATEUSER",
"NODE",
"NODES",
"NOTHING",
"NOTIFIER",
"NOTIFY",
"NOWAIT",
"NULLAWARE",
"NULLCOLS",
"NULLS",
"OBJECT",
"OCTETS",
"OF",
"OFF",
"OIDS",
"OPERATOR",
"OPT",
"OPTIMIZER",
"OPTION",
"OPTVER",
"ORC",
"OTHERS",
"OWNER",
"PARAMETER",
"PARAMETERS",
"PARQUET",
"PARSER",
"PARTIAL",
"PARTITION",
"PARTITIONING",
"PASSWORD",
"PASSWORD_GRACE_TIME",
"PASSWORD_LIFE_TIME",
"PASSWORD_LOCK_TIME",
"PASSWORD_MAX_LENGTH",
"PASSWORD_MIN_CHAR_CHANGE",
"PASSWORD_MIN_DIGITS",
"PASSWORD_MIN_LENGTH",
"PASSWORD_MIN_LETTERS",
"PASSWORD_MIN_LIFE_TIME",
"PASSWORD_MIN_LOWERCASE_LETTERS",
"PASSWORD_MIN_SYMBOLS",
"PASSWORD_MIN_UPPERCASE_LETTERS",
"PASSWORD_REUSE_MAX",
"PASSWORD_REUSE_TIME",
"PATTERN",
"PERCENT",
"PERMANENT",
"PLACING",
"PLANNEDCONCURRENCY",
"POLICY",
"POOL",
"PORT",
"PRECEDING",
"PREFER",
"PREPARE",
"PREPASS",
"PRESERVE",
"PREVIOUS",
"PRIOR",
"PRIORITY",
"PRIVILEGES",
"PROCEDURAL",
"PROCEDURE",
"PROFILE",
"PROJECTION",
"PROJECTIONS",
"PSDATE",
"QUERY",
"QUEUETIMEOUT",
"QUOTE",
"RANDOM",
"RANGE",
"RAW",
"READ",
"RECHECK",
"RECORD",
"RECOVER",
"RECURSIVE",
"REFRESH",
"REINDEX",
"REJECTED",
"REJECTMAX",
"RELATIVE",
"RELEASE",
"REMOVE",
"RENAME",
"REORGANIZE",
"REPEATABLE",
"REPLACE",
"RESET",
"RESOURCE",
"RESTART",
"RESTRICT",
"RESULTS",
"RETURN",
"RETURNREJECTED",
"REVOKE",
"RLE",
"ROLE",
"ROLES",
"ROLLBACK",
"ROLLUP",
"ROUTE",
"ROUTING",
"ROWS",
"RULE",
"RUNTIMECAP",
"RUNTIMEPRIORITY",
"RUNTIMEPRIORITYTHRESHOLD",
"RWITH",
"SALT",
"SAVE",
"SAVEPOINT",
"SCROLL",
"SEARCH_PATH",
"SECOND",
"SECONDARY",
"SECONDS",
"SECURITY",
"SECURITY_ALGORITHM",
"SEGMENTED",
"SEMI",
"SEMIALL",
"SEQUENCE",
"SEQUENCES",
"SERIALIZABLE",
"SESSION",
"SET",
"SETOF",
"SETS",
"SHARE",
"SHARED",
"SHOW",
"SIGNED",
"SIMPLE",
"SINGLEINITIATOR",
"SITE",
"SITES",
"SKIP",
"SOURCE",
"SPLIT",
"SSL_CONFIG",
"STABLE",
"STANDBY",
"START",
"STATEMENT",
"STATISTICS",
"STDIN",
"STDOUT",
"STEMMER",
"STORAGE",
"STREAM",
"STRENGTH",
"STRICT",
"SUBCLUSTER",
"SUBJECT",
"SUBNET",
"SUITES",
"SYSID",
"SYSTEM",
"TABLES",
"TABLESAMPLE",
"TABLESPACE",
"TEMP",
"TEMPLATE",
"TEMPORARY",
"TEMPSPACECAP",
"TERMINATOR",
"THAN",
"TIES",
"TLS",
"TLSMODE",
"TOAST",
"TOKENIZER",
"TOLERANCE",
"TRANSACTION",
"TRANSFORM",
"TRICKLE",
"TRIGGER",
"TRUNCATE",
"TRUSTED",
"TUNING",
"TYPE",
"UDPARAMETER",
"UNCOMMITTED",
"UNCOMPRESSED",
"UNI",
"UNINDEXED",
"UNKNOWN",
"UNLIMITED",
"UNLISTEN",
"UNLOCK",
"UNSEGMENTED",
"UPDATE",
"USAGE",
"VACUUM",
"VALID",
"VALIDATE",
"VALIDATOR",
"VALINDEX",
"VALUE",
"VALUES",
"VARYING",
"VERBOSE",
"VERTICA",
"VIEW",
"VOLATILE",
"WAIT",
"WEBHDFS_ADDRESS",
"WEBSERVICE_HOSTNAME",
"WEBSERVICE_PORT",
"WITHOUT",
"WORK",
"WRITE",
"YEAR",
"ZONE",
"ZSTD",
"ZSTD_COMP",
"ZSTD_FAST_COMP",
"ZSTD_HIGH_COMP",
}
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Go
1
https://gitee.com/wenj91/sqls.git
git@gitee.com:wenj91/sqls.git
wenj91
sqls
sqls
v1.0.1

搜索帮助