diff options
Diffstat (limited to 'syntax/sql.vim')
| -rw-r--r-- | syntax/sql.vim | 266 |
1 files changed, 0 insertions, 266 deletions
diff --git a/syntax/sql.vim b/syntax/sql.vim deleted file mode 100644 index 58788cb0..00000000 --- a/syntax/sql.vim +++ /dev/null @@ -1,266 +0,0 @@ -if !exists('g:polyglot_disabled') || index(g:polyglot_disabled, 'sql') == -1 - -" Vim syntax file -" Language: SQL with SQLite and other additions. -" Maintainer: Jessica K McIntosh AT gmail DOT com -" Last Changed: Thu Jan 23 06:00 PM 2014 EST - -" More complete SQL matching with error reporting. -" Only matches types inside 'CREATE TABLE ();'. -" Highlights functions. Unknown functions are an error. -" Based on the SQL syntax files that come with Vim. - -" For version 5.x: Clear all syntax items -" For version 6.x: Quit when a syntax file was already loaded -if version < 600 - syntax clear -elseif exists("b:current_syntax") - finish -endif - -syn case ignore - -" All non-contained SQL syntax. -syn cluster sqlALL contains=TOP - -" Various error conditions. -"syn match sqlError "\<\w\+(" " Not a known function. -syn match sqlError ")" " Lonely closing paren. -syn match sqlError ",\(\_\s*[;)]\)\@=" " Comma before a paren or semicolon. -syn match sqlError " $" " Space at the end of a line. -" Comma before certain words. -syn match sqlError ",\_\s*\(\<\(asc\|desc\|exists\|for\|from\)\>\)\@=" -syn match sqlError ",\_\s*\(\<\(group by\|into\|limit\|order\)\>\)\@=" -syn match sqlError ",\_\s*\(\<\(table\|using\|where\)\>\)\@=" - -" Special words. -syn keyword sqlSpecial false null true - -" Keywords -syn keyword sqlKeyword access add after aggregate as asc authorization -syn keyword sqlKeyword begin by cache cascade check cluster collate -syn keyword sqlKeyword collation column compress conflict connect connection -syn keyword sqlKeyword constraint current cursor database debug decimal -syn keyword sqlKeyword default desc each else elsif escape exception -syn keyword sqlKeyword exclusive explain external file for foreign from function -syn keyword sqlKeyword group having identified if immediate increment index -syn keyword sqlKeyword initial inner into is join key left level loop -syn keyword sqlKeyword maxextents mode modify nocompress nowait object of -syn keyword sqlKeyword off offline on online option order outer pctfree -syn keyword sqlKeyword primary privileges procedure public references -syn keyword sqlKeyword referencing release resource return role row rowid -syn keyword sqlKeyword rowlabel rownum rows schema session share size -syn keyword sqlKeyword start successful synonym then to transaction trigger -syn keyword sqlKeyword uid user using validate values view virtual whenever -syn keyword sqlKeyword where with -syn match sqlKeyword "\<prompt\>" -syn match sqlKeyword "\<glob\>" -" Do special things with CREATE TABLE ( below. -syn match sqlKeyword "\<table\>" - -" SQLite Pragmas - Treat them as keywords. -syn keyword sqlKeyword auto_vacuum automatic_index cache_size -syn keyword sqlKeyword case_sensitive_like checkpoint_fullfsync -syn keyword sqlKeyword collation_list compile_options count_changes -syn keyword sqlKeyword database_list default_cache_size -syn keyword sqlKeyword empty_result_callbacks encoding foreign_key_list -syn keyword sqlKeyword foreign_keys freelist_count full_column_names -syn keyword sqlKeyword fullfsync ignore_check_constraints -syn keyword sqlKeyword incremental_vacuum index_info index_list -syn keyword sqlKeyword integrity_check journal_mode journal_size_limit -syn keyword sqlKeyword legacy_file_format locking_mode max_page_count -syn keyword sqlKeyword page_count page_size parser_trace quick_check -syn keyword sqlKeyword read_uncommitted recursive_triggers -syn keyword sqlKeyword reverse_unordered_selects schema_version -syn keyword sqlKeyword secure_delete short_column_names synchronous -syn keyword sqlKeyword table_info temp_store temp_store_directory -syn keyword sqlKeyword user_version vdbe_listing vdbe_trace -syn keyword sqlKeyword wal_autocheckpoint wal_checkpoint writable_schema - -" Operators -syn keyword sqlOperator all and any between case distinct elif else end -syn keyword sqlOperator exit exists if in intersect is like match matches -syn keyword sqlOperator minus not or out prior regexp some then union -syn keyword sqlOperator unique when -syn match sqlOperator "||\|:=" - -" Conditionals -syn match sqlConditional "=\|<\|>\|+\|-" - -" Unknown functions. -syn match sqlUnknownFunc "\<\w\+(\@=" - -" Functions - Only valid with a '(' after them. -syn match sqlFunction "\<\(abs\|acos\|asin\|atan2\?\|avg\|cardinality\)(\@=" -syn match sqlFunction "\<\(cast\|changes\|char_length\|character_length\)(\@=" -syn match sqlFunction "\<\(coalesce\|concat\|cos\|count\|\(date\)\?\(time\)\?\)(\@=" -syn match sqlFunction "\<\(exp\|filetoblob\|filetoclob\|floor\|glob\|group_concat\)(\@=" -syn match sqlFunction "\<\(hex\|ifnull\|initcap\|isnull\|julianday\|last_insert_rowid\)(\@=" -syn match sqlFunction "\<\(length\|log10\|logn\|lower\|lpad\|ltrin\|max\|min\)(\@=" -syn match sqlFunction "\<\(mod\|nullif\|octet_length\|pow\|quote\|random\)(\@=" -syn match sqlFunction "\<\(range\|replace\|root\|round\|rpad\|sin\|soundex\)(\@=" -syn match sqlFunction "\<\(sqrtstdev\|strftime\|substr\|substring\|sum\|sysdate\|tan\)(\@=" -syn match sqlFunction "\<\(to_char\|to_date\|to_number\|total\|trim\|trunc\|typeof\)(\@=" -syn match sqlFunction "\<\(upper\|variance\)(\@=" - -" Oracle DBMS functions. -syn match sqlFunction "\<dbms_\w\+\.\w\+(\@=" - -" Oracle Exception Functions. -syn match sqlFunction "\<raise_application_error(\@=" - -" SQLite Functions -syn match sqlFunction "\<\(last_insert_rowid\|load_extension\|randomblob\)(\@=" -syn match sqlFunction "\<\(sqlite_compileoption_get\|sqlite_compileoption_used\)(\@=" -syn match sqlFunction "\<\(sqlite_source_id\|sqlite_version\|sqlite_version\)(\@=" -syn match sqlFunction "\<\(zeroblob\|ltrim\|rtrim\)(\@=" - -" SQLite Command Line Client Functions -syn match sqlFunction "^\.\w\+" - -" Statements -syn keyword sqlStatement alter analyze audit begin comment commit delete -syn keyword sqlStatement drop execute explain grant insert lock noaudit -syn keyword sqlStatement rename revoke rollback savepoint select -syn keyword sqlStatement truncate update vacuum -syn match sqlStatement "\<\(replace\|create\)\>" - -" SQLite Statements -syn keyword sqlStatement attach detach indexed pragma reindex - -" Types - Only matched inside 'CREATE TABLE ();'. -syn keyword sqlType contained bigint bit blob bool boolean byte char -syn keyword sqlType contained clob date datetime dec decimal enum -syn keyword sqlType contained float int int8 integer interval long -syn keyword sqlType contained longblob longtext lvarchar mediumblob -syn keyword sqlType contained mediumint mediumtext mlslabel money -syn keyword sqlType contained multiset nchar number numeric nvarchar -syn keyword sqlType contained raw real rowid serial serial8 set -syn keyword sqlType contained smallfloat smallint text time -syn keyword sqlType contained timestamp tinyblob tinyint tinytext -syn keyword sqlType contained varchar varchar2 varray year -syn match sqlType contained "\<\(character\|double\|varying\)\>" -syn match sqlType contained "\<character\s\+varying\>" -syn match sqlType contained "\<double\s\+precision\>" - -" Oracle Variables -syn match sqlVariable "&\a\w\+" -syn match sqlVariable ":\w\+" -syn match sqlVariable "SQL%\w\+" - -" Strings -syn region sqlString start=+"+ skip=+\\\\\|\\"+ end=+"+ contains=sqlVariable -syn region sqlString start=+'+ skip=+\\\\\|\\'+ end=+'+ contains=sqlVariable -syn region sqlString start=+`+ skip=+\\\\\|\\`+ end=+`+ contains=sqlVariable - -" Numbers -syn match sqlNumber "-\=\<[0-9]*\>" -syn match sqlNumber "-\=\<[0-9]*\.[0-9]*\>" -syn match sqlNumber "-\=\<[0-9][0-9]*e[+-]\=[0-9]*\>" -syn match sqlNumber "-\=\<[0-9]*\.[0-9]*e[+-]\=[0-9]*\>" -syn match sqlNumber "\<0x[abcdef0-9]*\>" - -" Todo -syn keyword sqlTodo contained DEBUG FIXME NOTE TODO XXX - -" Comments -syn region sqlComment start="/\*" end="\*/" contains=sqlTodo -syn match sqlComment "--.*$" contains=sqlTodo -syn match sqlComment "\(^\|\s\)rem.*$" contains=sqlTodo - -" Mark correct paren use. Different colors for different purposes. -syn region sqlParens transparent matchgroup=sqlParen start="(" end=")" -syn match sqlParenEmpty "()" -syn region sqlParens transparent matchgroup=sqlParenFunc start="\(\<\w\+\>\)\@<=(" end=")" - -" Highlight types correctly inside create table and procedure statements. -" All other SQL is properly highlighted as well. -syn region sqlTypeParens contained matchgroup=sqlType start="(" end=")" contains=@sqlALL -syn match sqlTypeMatch contained "\(\(^\|[,(]\)\s*\S\+\s\+\)\@<=\w\+\(\s*([^)]\+)\)\?" contains=sqlType,sqlTypeParens -syn match sqlTypeMatch contained "\(\(^\|[,(]\)\s*\S\+\s\+\)\@<=character\s\+varying\s*([^)]\+)" contains=sqlType,sqlTypeParens -syn region sqlTypeRegion matchgroup=sqlParen start="\(create\s\+table\s\+[^(]\+\s\+\)\@<=(" end=")" contains=@sqlALL,sqlTypeMatch -syn region sqlTypeRegion matchgroup=sqlParen start="\(create\s\+\(or\s\+replace\s\+\)\?procedure\s\+[^(]\+\s*\)\@<=(" end=")" contains=@sqlALL,sqlTypeMatch - -" SQL Embedded in a statement. -syn region sqlquoteRegion matchgroup=sqlParen start="\(execute\s\+immediate\s*\)\@<=('" end="')" contains=@sqlALL - -" Special Oracle Statements -syn match sqlStatement "^\s*\(prompt\|spool\)\>" nextgroup=sqlAnyString -syn match sqlStatement "^\s*accept\s\+" nextgroup=sqlAnyVariable -syn match sqlStatement "declare\s\+" nextgroup=sqlDeclare -syn region sqlDeclare contained matchgroup=sqlVariable start="\a\w\+" end="$" contains=@sqlALL,sqlType -syn match sqlOperator "^@" nextgroup=sqlAnyString -syn match sqlAnyVariable contained "\a\w\+" -syn match sqlAnyString contained ".*" contains=sqlVariable - -syn region sqlSetRegion matchgroup=sqlStatement start="^\s*set\>" matchgroup=NONE end="$" contains=sqlSetOptions,sqlSetValues -syn keyword sqlSetOptions contained autorecovery colsep copytypecheck describe escchar flagger -syn keyword sqlSetOptions contained instance logsource long null recsep recsepchar -syn keyword sqlSetOptions contained -syn match sqlSetOptions contained "\<\(app\w*\|array\w*\|auto\w*\|autop\w*\)\>" -syn match sqlSetOptions contained "\<\(autot\w*\|blo\w*\|cmds\w*\|con\w*\|copyc\w*\)\>" -syn match sqlSetOptions contained "\<\(def\w*\|echo\|editf\w*\|emb\w*\|errorl\w*\|esc\w*\)\>" -syn match sqlSetOptions contained "\<\(feed\w*\|flu\w*\|hea\w*\|heads\w*\|lin\w*\)\>" -syn match sqlSetOptions contained "\<\(lobof\w*\|longc\w*\|mark\w*\|newp\w*\|numf\w*\)\>" -syn match sqlSetOptions contained "\<\(pages\w*\|pau\w*\|serverout\w*\|shift\w*\|show\w*\)\>" -syn match sqlSetOptions contained "\<\(sqlbl\w*\|sqlc\w*\|sqlco\w*\|sqln\w*\|sqlpluscompat\w*\)\>" -syn match sqlSetOptions contained "\<\(sqlpre\w*\|sqlp\w*\|sqlt\w*\|suf\w*\|tab\)\>" -syn match sqlSetOptions contained "\<\(term\w*\|timi\w*\|und\w*\|ver\w*\|wra\w\?\)\>" -syn match sqlSetOptions contained "\<\(xquery\s\+\(baseuri\|ordering\|node\|context\)\)\>" -syn keyword sqlSetValues contained all body byreference byvalue default -syn keyword sqlSetValues contained entry fill head html identifier indent -syn keyword sqlSetValues contained linenum local none off on size table truncate -syn match sqlSetValues contained "\<\(ea\w*\|wr\w*\|imm\w*\|trace\w*\|expl\w*\|stat\w*\)\>" -syn match sqlSetValues contained "\<\(intermed\w*\|pre\w*\|unl\w*\|for\w*\|wra\w*\|wor\w\?\)\>" -syn match sqlSetValues contained "\<\(vis\w*\|inv\w*\)\>" -syn match sqlSetValues contained "\<\(\(un\)\?ordered\)\>" - -" Stolen from sh.vim. -if !exists("sh_minlines") - let sh_minlines = 200 -endif -if !exists("sh_maxlines") - let sh_maxlines = 2 * sh_minlines -endif -exec "syn sync minlines=" . sh_minlines . " maxlines=" . sh_maxlines - -" Define the default highlighting. -" For version 5.7 and earlier: only when not done already -" For version 5.8 and later: only when an item doesn't have highlighting yet -if version >= 508 || !exists("did_sql_syn_inits") - if version < 508 - let did_sql_syn_inits = 1 - command -nargs=+ HiLink hi link <args> - else - command -nargs=+ HiLink hi def link <args> - endif - - HiLink sqlComment Comment - HiLink sqlError Error - HiLink sqlFunction Function - HiLink sqlUnknownFunc Exception - HiLink sqlKeyword Special - HiLink sqlConditional Conditional - HiLink sqlNumber Number - HiLink sqlOperator Operator - HiLink sqlParen Comment - HiLink sqlParenEmpty Operator - HiLink sqlParenFunc Function - HiLink sqlSpecial Keyword - HiLink sqlStatement Statement - HiLink sqlString String - HiLink sqlTodo Todo - HiLink sqlType Type - HiLink sqlVariable Identifier - - HiLink sqlAnyString sqlString - HiLink sqlAnyVariable sqlVariable - HiLink sqlSetOptions Operator - HiLink sqlSetValues Special - - delcommand HiLink -endif - -let b:current_syntax = "sql" - -endif |