Mercurial > vim
annotate runtime/syntax/sqlanywhere.vim @ 28154:ae975c8d5438 v8.2.4601
patch 8.2.4601: Vim9: not enough test coverage for executing :def function
Commit: https://github.com/vim/vim/commit/efd73ae5d2a533670f562b6df5be2ffeb091185d
Author: Bram Moolenaar <Bram@vim.org>
Date: Sun Mar 20 18:51:00 2022 +0000
patch 8.2.4601: Vim9: not enough test coverage for executing :def function
Problem: Vim9: not enough test coverage for executing :def function.
Solution: Add a few more tests.
| author | Bram Moolenaar <Bram@vim.org> |
|---|---|
| date | Sun, 20 Mar 2022 20:00:03 +0100 |
| parents | 43efa4f5a8ea |
| children |
| rev | line source |
|---|---|
| 719 | 1 " Vim syntax file |
| 2 " Language: SQL, Adaptive Server Anywhere | |
| 3312 | 3 " Maintainer: David Fishburn <dfishburn dot vim at gmail dot com> |
| 4437 | 4 " Last Change: 2013 May 13 |
| 5 " Version: 16.0.0 | |
| 719 | 6 |
| 4437 | 7 " Description: Updated to Adaptive Server Anywhere 16.0.0 |
| 8 " Updated to Adaptive Server Anywhere 12.0.1 (including spatial data) | |
| 3312 | 9 " Updated to Adaptive Server Anywhere 11.0.1 |
| 2034 | 10 " Updated to Adaptive Server Anywhere 10.0.1 |
| 1621 | 11 " Updated to Adaptive Server Anywhere 9.0.2 |
| 12 " Updated to Adaptive Server Anywhere 9.0.1 | |
| 13 " Updated to Adaptive Server Anywhere 9.0.0 | |
| 719 | 14 " |
|
10048
43efa4f5a8ea
commit https://github.com/vim/vim/commit/89bcfda6834aba724d12554a34b9ed49f5789fd5
Christian Brabandt <cb@256bit.org>
parents:
4437
diff
changeset
|
15 " quit when a syntax file was already loaded |
|
43efa4f5a8ea
commit https://github.com/vim/vim/commit/89bcfda6834aba724d12554a34b9ed49f5789fd5
Christian Brabandt <cb@256bit.org>
parents:
4437
diff
changeset
|
16 if exists("b:current_syntax") |
| 719 | 17 finish |
| 18 endif | |
| 19 | |
| 20 syn case ignore | |
| 21 | |
| 22 " The SQL reserved words, defined as keywords. | |
| 23 | |
| 24 syn keyword sqlSpecial false null true | |
| 25 | |
| 26 " common functions | |
| 4437 | 27 syn keyword sqlFunction abs argn avg bintohex bintostr |
| 28 syn keyword sqlFunction byte_length byte_substr char_length | |
| 29 syn keyword sqlFunction compare count count_big datalength date | |
| 30 syn keyword sqlFunction date_format dateadd datediff datename | |
| 31 syn keyword sqlFunction datepart day dayname days debug_eng | |
| 32 syn keyword sqlFunction dense_rank density dialect difference | |
| 33 syn keyword sqlFunction dow estimate estimate_source evaluate | |
| 34 syn keyword sqlFunction experience_estimate explanation | |
| 35 syn keyword sqlFunction get_identity graphical_plan | |
| 36 syn keyword sqlFunction graphical_ulplan greater grouping | |
| 37 syn keyword sqlFunction hextobin hextoint hour hours identity | |
| 38 syn keyword sqlFunction ifnull index_estimate inttohex isdate | |
| 39 syn keyword sqlFunction isencrypted isnull isnumeric | |
| 40 syn keyword sqlFunction lang_message length lesser like_end | |
| 41 syn keyword sqlFunction like_start list long_ulplan lookup max | |
| 42 syn keyword sqlFunction min minute minutes month monthname | |
| 43 syn keyword sqlFunction months newid now nullif number | |
| 44 syn keyword sqlFunction percent_rank plan quarter rand rank | |
| 45 syn keyword sqlFunction regexp_compile regexp_compile_patindex | |
| 46 syn keyword sqlFunction remainder rewrite rowid second seconds | |
| 47 syn keyword sqlFunction short_ulplan similar sortkey soundex | |
| 48 syn keyword sqlFunction stddev stack_trace str string strtobin strtouuid stuff | |
| 49 syn keyword sqlFunction subpartition substr substring sum switchoffset sysdatetimeoffset | |
| 50 syn keyword sqlFunction textptr todate todatetimeoffset today totimestamp traceback transactsql | |
| 51 syn keyword sqlFunction ts_index_statistics ts_table_statistics | |
| 52 syn keyword sqlFunction tsequal ulplan user_id user_name utc_now | |
| 53 syn keyword sqlFunction uuidtostr varexists variance watcomsql | |
| 54 syn keyword sqlFunction weeks wsql_state year years ymd | |
| 719 | 55 |
| 56 " 9.0.1 functions | |
| 2034 | 57 syn keyword sqlFunction acos asin atan atn2 cast ceiling convert cos cot |
| 1621 | 58 syn keyword sqlFunction char_length coalesce dateformat datetime degrees exp |
| 2034 | 59 syn keyword sqlFunction floor getdate insertstr |
| 1621 | 60 syn keyword sqlFunction log log10 lower mod pi power |
| 2034 | 61 syn keyword sqlFunction property radians replicate round sign sin |
| 1621 | 62 syn keyword sqlFunction sqldialect tan truncate truncnum |
| 63 syn keyword sqlFunction base64_encode base64_decode | |
| 64 syn keyword sqlFunction hash compress decompress encrypt decrypt | |
| 719 | 65 |
| 2034 | 66 " 11.0.1 functions |
| 67 syn keyword sqlFunction connection_extended_property text_handle_vector_match | |
| 68 syn keyword sqlFunction read_client_file write_client_file | |
| 69 | |
| 3312 | 70 " 12.0.1 functions |
| 71 syn keyword sqlFunction http_response_header | |
| 72 | |
| 719 | 73 " string functions |
| 1621 | 74 syn keyword sqlFunction ascii char left ltrim repeat |
| 75 syn keyword sqlFunction space right rtrim trim lcase ucase | |
| 76 syn keyword sqlFunction locate charindex patindex replace | |
| 2034 | 77 syn keyword sqlFunction errormsg csconvert |
| 719 | 78 |
| 79 " property functions | |
| 1621 | 80 syn keyword sqlFunction db_id db_name property_name |
| 81 syn keyword sqlFunction property_description property_number | |
| 82 syn keyword sqlFunction next_connection next_database property | |
| 83 syn keyword sqlFunction connection_property db_property db_extended_property | |
| 84 syn keyword sqlFunction event_parmeter event_condition event_condition_name | |
| 719 | 85 |
| 86 " sa_ procedures | |
| 1621 | 87 syn keyword sqlFunction sa_add_index_consultant_analysis |
| 88 syn keyword sqlFunction sa_add_workload_query | |
| 89 syn keyword sqlFunction sa_app_deregister | |
| 90 syn keyword sqlFunction sa_app_get_infoStr | |
| 91 syn keyword sqlFunction sa_app_get_status | |
| 92 syn keyword sqlFunction sa_app_register | |
| 93 syn keyword sqlFunction sa_app_registration_unlock | |
| 94 syn keyword sqlFunction sa_app_set_infoStr | |
| 95 syn keyword sqlFunction sa_audit_string | |
| 96 syn keyword sqlFunction sa_check_commit | |
| 97 syn keyword sqlFunction sa_checkpoint_execute | |
| 98 syn keyword sqlFunction sa_conn_activity | |
| 99 syn keyword sqlFunction sa_conn_compression_info | |
| 100 syn keyword sqlFunction sa_conn_deregister | |
| 101 syn keyword sqlFunction sa_conn_info | |
| 102 syn keyword sqlFunction sa_conn_properties | |
| 103 syn keyword sqlFunction sa_conn_properties_by_conn | |
| 104 syn keyword sqlFunction sa_conn_properties_by_name | |
| 105 syn keyword sqlFunction sa_conn_register | |
| 106 syn keyword sqlFunction sa_conn_set_status | |
| 107 syn keyword sqlFunction sa_create_analysis_from_query | |
| 108 syn keyword sqlFunction sa_db_info | |
| 109 syn keyword sqlFunction sa_db_properties | |
| 110 syn keyword sqlFunction sa_disable_auditing_type | |
| 111 syn keyword sqlFunction sa_disable_index | |
| 112 syn keyword sqlFunction sa_disk_free_space | |
| 113 syn keyword sqlFunction sa_enable_auditing_type | |
| 114 syn keyword sqlFunction sa_enable_index | |
| 115 syn keyword sqlFunction sa_end_forward_to | |
| 116 syn keyword sqlFunction sa_eng_properties | |
| 117 syn keyword sqlFunction sa_event_schedules | |
| 118 syn keyword sqlFunction sa_exec_script | |
| 119 syn keyword sqlFunction sa_flush_cache | |
| 120 syn keyword sqlFunction sa_flush_statistics | |
| 121 syn keyword sqlFunction sa_forward_to | |
| 122 syn keyword sqlFunction sa_get_dtt | |
| 123 syn keyword sqlFunction sa_get_histogram | |
| 124 syn keyword sqlFunction sa_get_request_profile | |
| 125 syn keyword sqlFunction sa_get_request_profile_sub | |
| 126 syn keyword sqlFunction sa_get_request_times | |
| 127 syn keyword sqlFunction sa_get_server_messages | |
| 128 syn keyword sqlFunction sa_get_simulated_scale_factors | |
| 129 syn keyword sqlFunction sa_get_workload_capture_status | |
| 130 syn keyword sqlFunction sa_index_density | |
| 131 syn keyword sqlFunction sa_index_levels | |
| 132 syn keyword sqlFunction sa_index_statistics | |
| 133 syn keyword sqlFunction sa_internal_alter_index_ability | |
| 134 syn keyword sqlFunction sa_internal_create_analysis_from_query | |
| 135 syn keyword sqlFunction sa_internal_disk_free_space | |
| 136 syn keyword sqlFunction sa_internal_get_dtt | |
| 137 syn keyword sqlFunction sa_internal_get_histogram | |
| 138 syn keyword sqlFunction sa_internal_get_request_times | |
| 139 syn keyword sqlFunction sa_internal_get_simulated_scale_factors | |
| 140 syn keyword sqlFunction sa_internal_get_workload_capture_status | |
| 141 syn keyword sqlFunction sa_internal_index_density | |
| 142 syn keyword sqlFunction sa_internal_index_levels | |
| 143 syn keyword sqlFunction sa_internal_index_statistics | |
| 144 syn keyword sqlFunction sa_internal_java_loaded_classes | |
| 145 syn keyword sqlFunction sa_internal_locks | |
| 146 syn keyword sqlFunction sa_internal_pause_workload_capture | |
| 147 syn keyword sqlFunction sa_internal_procedure_profile | |
| 148 syn keyword sqlFunction sa_internal_procedure_profile_summary | |
| 149 syn keyword sqlFunction sa_internal_read_backup_history | |
| 150 syn keyword sqlFunction sa_internal_recommend_indexes | |
| 151 syn keyword sqlFunction sa_internal_reset_identity | |
| 152 syn keyword sqlFunction sa_internal_resume_workload_capture | |
| 153 syn keyword sqlFunction sa_internal_start_workload_capture | |
| 154 syn keyword sqlFunction sa_internal_stop_index_consultant | |
| 155 syn keyword sqlFunction sa_internal_stop_workload_capture | |
| 156 syn keyword sqlFunction sa_internal_table_fragmentation | |
| 157 syn keyword sqlFunction sa_internal_table_page_usage | |
| 158 syn keyword sqlFunction sa_internal_table_stats | |
| 159 syn keyword sqlFunction sa_internal_virtual_sysindex | |
| 160 syn keyword sqlFunction sa_internal_virtual_sysixcol | |
| 161 syn keyword sqlFunction sa_java_loaded_classes | |
| 162 syn keyword sqlFunction sa_jdk_version | |
| 163 syn keyword sqlFunction sa_locks | |
| 164 syn keyword sqlFunction sa_make_object | |
| 165 syn keyword sqlFunction sa_pause_workload_capture | |
| 166 syn keyword sqlFunction sa_proc_debug_attach_to_connection | |
| 167 syn keyword sqlFunction sa_proc_debug_connect | |
| 168 syn keyword sqlFunction sa_proc_debug_detach_from_connection | |
| 169 syn keyword sqlFunction sa_proc_debug_disconnect | |
| 170 syn keyword sqlFunction sa_proc_debug_get_connection_name | |
| 171 syn keyword sqlFunction sa_proc_debug_release_connection | |
| 172 syn keyword sqlFunction sa_proc_debug_request | |
| 173 syn keyword sqlFunction sa_proc_debug_version | |
| 174 syn keyword sqlFunction sa_proc_debug_wait_for_connection | |
| 175 syn keyword sqlFunction sa_procedure_profile | |
| 176 syn keyword sqlFunction sa_procedure_profile_summary | |
| 177 syn keyword sqlFunction sa_read_backup_history | |
| 178 syn keyword sqlFunction sa_recommend_indexes | |
| 179 syn keyword sqlFunction sa_recompile_views | |
| 180 syn keyword sqlFunction sa_remove_index_consultant_analysis | |
| 181 syn keyword sqlFunction sa_remove_index_consultant_workload | |
| 182 syn keyword sqlFunction sa_reset_identity | |
| 183 syn keyword sqlFunction sa_resume_workload_capture | |
| 184 syn keyword sqlFunction sa_server_option | |
| 185 syn keyword sqlFunction sa_set_simulated_scale_factor | |
| 186 syn keyword sqlFunction sa_setremoteuser | |
| 187 syn keyword sqlFunction sa_setsubscription | |
| 188 syn keyword sqlFunction sa_start_recording_commits | |
| 189 syn keyword sqlFunction sa_start_workload_capture | |
| 190 syn keyword sqlFunction sa_statement_text | |
| 191 syn keyword sqlFunction sa_stop_index_consultant | |
| 192 syn keyword sqlFunction sa_stop_recording_commits | |
| 193 syn keyword sqlFunction sa_stop_workload_capture | |
| 194 syn keyword sqlFunction sa_sync | |
| 195 syn keyword sqlFunction sa_sync_sub | |
| 196 syn keyword sqlFunction sa_table_fragmentation | |
| 197 syn keyword sqlFunction sa_table_page_usage | |
| 198 syn keyword sqlFunction sa_table_stats | |
| 199 syn keyword sqlFunction sa_update_index_consultant_workload | |
| 200 syn keyword sqlFunction sa_validate | |
| 201 syn keyword sqlFunction sa_virtual_sysindex | |
| 202 syn keyword sqlFunction sa_virtual_sysixcol | |
| 719 | 203 |
| 204 " sp_ procedures | |
| 1621 | 205 syn keyword sqlFunction sp_addalias |
| 206 syn keyword sqlFunction sp_addauditrecord | |
| 207 syn keyword sqlFunction sp_adddumpdevice | |
| 208 syn keyword sqlFunction sp_addgroup | |
| 209 syn keyword sqlFunction sp_addlanguage | |
| 210 syn keyword sqlFunction sp_addlogin | |
| 211 syn keyword sqlFunction sp_addmessage | |
| 212 syn keyword sqlFunction sp_addremotelogin | |
| 213 syn keyword sqlFunction sp_addsegment | |
| 214 syn keyword sqlFunction sp_addserver | |
| 215 syn keyword sqlFunction sp_addthreshold | |
| 216 syn keyword sqlFunction sp_addtype | |
| 217 syn keyword sqlFunction sp_adduser | |
| 218 syn keyword sqlFunction sp_auditdatabase | |
| 219 syn keyword sqlFunction sp_auditlogin | |
| 220 syn keyword sqlFunction sp_auditobject | |
| 221 syn keyword sqlFunction sp_auditoption | |
| 222 syn keyword sqlFunction sp_auditsproc | |
| 223 syn keyword sqlFunction sp_bindefault | |
| 224 syn keyword sqlFunction sp_bindmsg | |
| 225 syn keyword sqlFunction sp_bindrule | |
| 226 syn keyword sqlFunction sp_changedbowner | |
| 227 syn keyword sqlFunction sp_changegroup | |
| 228 syn keyword sqlFunction sp_checknames | |
| 229 syn keyword sqlFunction sp_checkperms | |
| 230 syn keyword sqlFunction sp_checkreswords | |
| 231 syn keyword sqlFunction sp_clearstats | |
| 232 syn keyword sqlFunction sp_column_privileges | |
| 233 syn keyword sqlFunction sp_columns | |
| 234 syn keyword sqlFunction sp_commonkey | |
| 235 syn keyword sqlFunction sp_configure | |
| 236 syn keyword sqlFunction sp_cursorinfo | |
| 237 syn keyword sqlFunction sp_databases | |
| 238 syn keyword sqlFunction sp_datatype_info | |
| 239 syn keyword sqlFunction sp_dboption | |
| 240 syn keyword sqlFunction sp_dbremap | |
| 241 syn keyword sqlFunction sp_depends | |
| 242 syn keyword sqlFunction sp_diskdefault | |
| 243 syn keyword sqlFunction sp_displaylogin | |
| 244 syn keyword sqlFunction sp_dropalias | |
| 245 syn keyword sqlFunction sp_dropdevice | |
| 246 syn keyword sqlFunction sp_dropgroup | |
| 247 syn keyword sqlFunction sp_dropkey | |
| 248 syn keyword sqlFunction sp_droplanguage | |
| 249 syn keyword sqlFunction sp_droplogin | |
| 250 syn keyword sqlFunction sp_dropmessage | |
| 251 syn keyword sqlFunction sp_dropremotelogin | |
| 252 syn keyword sqlFunction sp_dropsegment | |
| 253 syn keyword sqlFunction sp_dropserver | |
| 254 syn keyword sqlFunction sp_dropthreshold | |
| 255 syn keyword sqlFunction sp_droptype | |
| 256 syn keyword sqlFunction sp_dropuser | |
| 257 syn keyword sqlFunction sp_estspace | |
| 258 syn keyword sqlFunction sp_extendsegment | |
| 259 syn keyword sqlFunction sp_fkeys | |
| 260 syn keyword sqlFunction sp_foreignkey | |
| 261 syn keyword sqlFunction sp_getmessage | |
| 262 syn keyword sqlFunction sp_help | |
| 263 syn keyword sqlFunction sp_helpconstraint | |
| 264 syn keyword sqlFunction sp_helpdb | |
| 265 syn keyword sqlFunction sp_helpdevice | |
| 266 syn keyword sqlFunction sp_helpgroup | |
| 267 syn keyword sqlFunction sp_helpindex | |
| 268 syn keyword sqlFunction sp_helpjoins | |
| 269 syn keyword sqlFunction sp_helpkey | |
| 270 syn keyword sqlFunction sp_helplanguage | |
| 271 syn keyword sqlFunction sp_helplog | |
| 272 syn keyword sqlFunction sp_helpprotect | |
| 273 syn keyword sqlFunction sp_helpremotelogin | |
| 274 syn keyword sqlFunction sp_helpsegment | |
| 275 syn keyword sqlFunction sp_helpserver | |
| 276 syn keyword sqlFunction sp_helpsort | |
| 277 syn keyword sqlFunction sp_helptext | |
| 278 syn keyword sqlFunction sp_helpthreshold | |
| 279 syn keyword sqlFunction sp_helpuser | |
| 280 syn keyword sqlFunction sp_indsuspect | |
| 281 syn keyword sqlFunction sp_lock | |
| 282 syn keyword sqlFunction sp_locklogin | |
| 283 syn keyword sqlFunction sp_logdevice | |
| 284 syn keyword sqlFunction sp_login_environment | |
| 285 syn keyword sqlFunction sp_modifylogin | |
| 286 syn keyword sqlFunction sp_modifythreshold | |
| 287 syn keyword sqlFunction sp_monitor | |
| 288 syn keyword sqlFunction sp_password | |
| 289 syn keyword sqlFunction sp_pkeys | |
| 290 syn keyword sqlFunction sp_placeobject | |
| 291 syn keyword sqlFunction sp_primarykey | |
| 292 syn keyword sqlFunction sp_procxmode | |
| 293 syn keyword sqlFunction sp_recompile | |
| 294 syn keyword sqlFunction sp_remap | |
| 295 syn keyword sqlFunction sp_remote_columns | |
| 296 syn keyword sqlFunction sp_remote_exported_keys | |
| 297 syn keyword sqlFunction sp_remote_imported_keys | |
| 298 syn keyword sqlFunction sp_remote_pcols | |
| 299 syn keyword sqlFunction sp_remote_primary_keys | |
| 300 syn keyword sqlFunction sp_remote_procedures | |
| 301 syn keyword sqlFunction sp_remote_tables | |
| 302 syn keyword sqlFunction sp_remoteoption | |
| 303 syn keyword sqlFunction sp_rename | |
| 304 syn keyword sqlFunction sp_renamedb | |
| 305 syn keyword sqlFunction sp_reportstats | |
| 306 syn keyword sqlFunction sp_reset_tsql_environment | |
| 307 syn keyword sqlFunction sp_role | |
| 308 syn keyword sqlFunction sp_server_info | |
| 309 syn keyword sqlFunction sp_servercaps | |
| 310 syn keyword sqlFunction sp_serverinfo | |
| 311 syn keyword sqlFunction sp_serveroption | |
| 312 syn keyword sqlFunction sp_setlangalias | |
| 313 syn keyword sqlFunction sp_setreplicate | |
| 314 syn keyword sqlFunction sp_setrepproc | |
| 315 syn keyword sqlFunction sp_setreptable | |
| 316 syn keyword sqlFunction sp_spaceused | |
| 317 syn keyword sqlFunction sp_special_columns | |
| 318 syn keyword sqlFunction sp_sproc_columns | |
| 319 syn keyword sqlFunction sp_statistics | |
| 320 syn keyword sqlFunction sp_stored_procedures | |
| 321 syn keyword sqlFunction sp_syntax | |
| 322 syn keyword sqlFunction sp_table_privileges | |
| 323 syn keyword sqlFunction sp_tables | |
| 324 syn keyword sqlFunction sp_tsql_environment | |
| 325 syn keyword sqlFunction sp_tsql_feature_not_supported | |
| 326 syn keyword sqlFunction sp_unbindefault | |
| 327 syn keyword sqlFunction sp_unbindmsg | |
| 328 syn keyword sqlFunction sp_unbindrule | |
| 329 syn keyword sqlFunction sp_volchanged | |
| 330 syn keyword sqlFunction sp_who | |
| 331 syn keyword sqlFunction xp_scanf | |
| 332 syn keyword sqlFunction xp_sprintf | |
| 719 | 333 |
| 334 " server functions | |
| 1621 | 335 syn keyword sqlFunction col_length |
| 336 syn keyword sqlFunction col_name | |
| 337 syn keyword sqlFunction index_col | |
| 338 syn keyword sqlFunction object_id | |
| 339 syn keyword sqlFunction object_name | |
| 340 syn keyword sqlFunction proc_role | |
| 341 syn keyword sqlFunction show_role | |
| 342 syn keyword sqlFunction xp_cmdshell | |
| 343 syn keyword sqlFunction xp_msver | |
| 344 syn keyword sqlFunction xp_read_file | |
| 345 syn keyword sqlFunction xp_real_cmdshell | |
| 346 syn keyword sqlFunction xp_real_read_file | |
| 347 syn keyword sqlFunction xp_real_sendmail | |
| 348 syn keyword sqlFunction xp_real_startmail | |
| 349 syn keyword sqlFunction xp_real_startsmtp | |
| 350 syn keyword sqlFunction xp_real_stopmail | |
| 351 syn keyword sqlFunction xp_real_stopsmtp | |
| 352 syn keyword sqlFunction xp_real_write_file | |
| 353 syn keyword sqlFunction xp_scanf | |
| 354 syn keyword sqlFunction xp_sendmail | |
| 355 syn keyword sqlFunction xp_sprintf | |
| 356 syn keyword sqlFunction xp_startmail | |
| 357 syn keyword sqlFunction xp_startsmtp | |
| 358 syn keyword sqlFunction xp_stopmail | |
| 359 syn keyword sqlFunction xp_stopsmtp | |
| 360 syn keyword sqlFunction xp_write_file | |
| 719 | 361 |
| 362 " http functions | |
| 1621 | 363 syn keyword sqlFunction http_header http_variable |
| 3312 | 364 syn keyword sqlFunction next_http_header next_http_response_header next_http_variable |
| 1621 | 365 syn keyword sqlFunction sa_set_http_header sa_set_http_option |
| 366 syn keyword sqlFunction sa_http_variable_info sa_http_header_info | |
| 719 | 367 |
| 2034 | 368 " http functions 9.0.1 |
| 1621 | 369 syn keyword sqlFunction http_encode http_decode |
| 370 syn keyword sqlFunction html_encode html_decode | |
| 719 | 371 |
| 3312 | 372 " XML function support |
| 373 syn keyword sqlFunction openxml xmlelement xmlforest xmlgen xmlconcat xmlagg | |
| 374 syn keyword sqlFunction xmlattributes | |
| 375 | |
| 376 " Spatial Compatibility Functions | |
| 377 syn keyword sqlFunction ST_BdMPolyFromText | |
| 378 syn keyword sqlFunction ST_BdMPolyFromWKB | |
| 379 syn keyword sqlFunction ST_BdPolyFromText | |
| 380 syn keyword sqlFunction ST_BdPolyFromWKB | |
| 381 syn keyword sqlFunction ST_CPolyFromText | |
| 382 syn keyword sqlFunction ST_CPolyFromWKB | |
| 383 syn keyword sqlFunction ST_CircularFromTxt | |
| 384 syn keyword sqlFunction ST_CircularFromWKB | |
| 385 syn keyword sqlFunction ST_CompoundFromTxt | |
| 386 syn keyword sqlFunction ST_CompoundFromWKB | |
| 387 syn keyword sqlFunction ST_GeomCollFromTxt | |
| 388 syn keyword sqlFunction ST_GeomCollFromWKB | |
| 389 syn keyword sqlFunction ST_GeomFromText | |
| 390 syn keyword sqlFunction ST_GeomFromWKB | |
| 391 syn keyword sqlFunction ST_LineFromText | |
| 392 syn keyword sqlFunction ST_LineFromWKB | |
| 393 syn keyword sqlFunction ST_MCurveFromText | |
| 394 syn keyword sqlFunction ST_MCurveFromWKB | |
| 395 syn keyword sqlFunction ST_MLineFromText | |
| 396 syn keyword sqlFunction ST_MLineFromWKB | |
| 397 syn keyword sqlFunction ST_MPointFromText | |
| 398 syn keyword sqlFunction ST_MPointFromWKB | |
| 399 syn keyword sqlFunction ST_MPolyFromText | |
| 400 syn keyword sqlFunction ST_MPolyFromWKB | |
| 401 syn keyword sqlFunction ST_MSurfaceFromTxt | |
| 402 syn keyword sqlFunction ST_MSurfaceFromWKB | |
| 403 syn keyword sqlFunction ST_OrderingEquals | |
| 404 syn keyword sqlFunction ST_PointFromText | |
| 405 syn keyword sqlFunction ST_PointFromWKB | |
| 406 syn keyword sqlFunction ST_PolyFromText | |
| 407 syn keyword sqlFunction ST_PolyFromWKB | |
| 408 " Spatial Structural Methods | |
| 409 syn keyword sqlFunction ST_CoordDim | |
| 410 syn keyword sqlFunction ST_CurveN | |
| 411 syn keyword sqlFunction ST_Dimension | |
| 412 syn keyword sqlFunction ST_EndPoint | |
| 413 syn keyword sqlFunction ST_ExteriorRing | |
| 414 syn keyword sqlFunction ST_GeometryN | |
| 415 syn keyword sqlFunction ST_GeometryType | |
| 416 syn keyword sqlFunction ST_InteriorRingN | |
| 417 syn keyword sqlFunction ST_Is3D | |
| 418 syn keyword sqlFunction ST_IsClosed | |
| 419 syn keyword sqlFunction ST_IsEmpty | |
| 420 syn keyword sqlFunction ST_IsMeasured | |
| 421 syn keyword sqlFunction ST_IsRing | |
| 422 syn keyword sqlFunction ST_IsSimple | |
| 423 syn keyword sqlFunction ST_IsValid | |
| 424 syn keyword sqlFunction ST_NumCurves | |
| 425 syn keyword sqlFunction ST_NumGeometries | |
| 426 syn keyword sqlFunction ST_NumInteriorRing | |
| 427 syn keyword sqlFunction ST_NumPoints | |
| 428 syn keyword sqlFunction ST_PointN | |
| 429 syn keyword sqlFunction ST_StartPoint | |
| 430 "Spatial Computation | |
| 431 syn keyword sqlFunction ST_Length | |
| 432 syn keyword sqlFunction ST_Area | |
| 433 syn keyword sqlFunction ST_Centroid | |
| 434 syn keyword sqlFunction ST_Area | |
| 435 syn keyword sqlFunction ST_Centroid | |
| 436 syn keyword sqlFunction ST_IsWorld | |
| 437 syn keyword sqlFunction ST_Perimeter | |
| 438 syn keyword sqlFunction ST_PointOnSurface | |
| 439 syn keyword sqlFunction ST_Distance | |
| 440 " Spatial Input/Output | |
| 441 syn keyword sqlFunction ST_AsBinary | |
| 442 syn keyword sqlFunction ST_AsGML | |
| 443 syn keyword sqlFunction ST_AsGeoJSON | |
| 444 syn keyword sqlFunction ST_AsSVG | |
| 445 syn keyword sqlFunction ST_AsSVGAggr | |
| 446 syn keyword sqlFunction ST_AsText | |
| 447 syn keyword sqlFunction ST_AsWKB | |
| 448 syn keyword sqlFunction ST_AsWKT | |
| 449 syn keyword sqlFunction ST_AsXML | |
| 450 syn keyword sqlFunction ST_GeomFromBinary | |
| 451 syn keyword sqlFunction ST_GeomFromShape | |
| 452 syn keyword sqlFunction ST_GeomFromText | |
| 453 syn keyword sqlFunction ST_GeomFromWKB | |
| 454 syn keyword sqlFunction ST_GeomFromWKT | |
| 455 syn keyword sqlFunction ST_GeomFromXML | |
| 456 " Spatial Cast Methods | |
| 457 syn keyword sqlFunction ST_CurvePolyToPoly | |
| 458 syn keyword sqlFunction ST_CurveToLine | |
| 459 syn keyword sqlFunction ST_ToCircular | |
| 460 syn keyword sqlFunction ST_ToCompound | |
| 461 syn keyword sqlFunction ST_ToCurve | |
| 462 syn keyword sqlFunction ST_ToCurvePoly | |
| 463 syn keyword sqlFunction ST_ToGeomColl | |
| 464 syn keyword sqlFunction ST_ToLineString | |
| 465 syn keyword sqlFunction ST_ToMultiCurve | |
| 466 syn keyword sqlFunction ST_ToMultiLine | |
| 467 syn keyword sqlFunction ST_ToMultiPoint | |
| 468 syn keyword sqlFunction ST_ToMultiPolygon | |
| 469 syn keyword sqlFunction ST_ToMultiSurface | |
| 470 syn keyword sqlFunction ST_ToPoint | |
| 471 syn keyword sqlFunction ST_ToPolygon | |
| 472 syn keyword sqlFunction ST_ToSurface | |
| 473 | |
| 4437 | 474 " Array functions 16.x |
| 475 syn keyword sqlFunction array array_agg array_max_cardinality trim_array | |
| 476 syn keyword sqlFunction error_line error_message error_procedure | |
| 477 syn keyword sqlFunction error_sqlcode error_sqlstate error_stack_trace | |
| 478 | |
| 3312 | 479 |
| 719 | 480 " keywords |
| 4437 | 481 syn keyword sqlKeyword absolute accent access account action active activate add address admin |
| 482 syn keyword sqlKeyword aes_decrypt after aggregate algorithm allow_dup_row allow allowed alter | |
| 483 syn keyword sqlKeyword always and angular ansi_substring any as append apply | |
| 484 syn keyword sqlKeyword arbiter array asc ascii ase | |
| 485 syn keyword sqlKeyword assign at atan2 atomic attended | |
| 486 syn keyword sqlKeyword audit auditing authentication authorization axis | |
| 1621 | 487 syn keyword sqlKeyword autoincrement autostop batch bcp before |
| 2034 | 488 syn keyword sqlKeyword between bit_and bit_length bit_or bit_substr bit_xor |
| 489 syn keyword sqlKeyword blank blanks block | |
| 3312 | 490 syn keyword sqlKeyword both bottom unbounded breaker bufferpool |
| 1621 | 491 syn keyword sqlKeyword build bulk by byte bytes cache calibrate calibration |
| 4437 | 492 syn keyword sqlKeyword cancel capability cardinality cascade cast |
| 493 syn keyword sqlKeyword catalog catch ceil change changes char char_convert | |
| 494 syn keyword sqlKeyword check checkpointlog checksum class classes client cmp | |
| 2034 | 495 syn keyword sqlKeyword cluster clustered collation |
| 496 syn keyword sqlKeyword column columns | |
| 4437 | 497 syn keyword sqlKeyword command comments committed commitid comparisons |
| 1621 | 498 syn keyword sqlKeyword compatible component compressed compute computes |
| 2034 | 499 syn keyword sqlKeyword concat configuration confirm conflict connection |
| 1621 | 500 syn keyword sqlKeyword console consolidate consolidated |
| 4437 | 501 syn keyword sqlKeyword constraint constraints content |
| 3312 | 502 syn keyword sqlKeyword convert coordinate coordinator copy count count_set_bits |
| 4437 | 503 syn keyword sqlKeyword crc createtime critical cross cube cume_dist |
| 1621 | 504 syn keyword sqlKeyword current cursor data data database |
| 3312 | 505 syn keyword sqlKeyword current_timestamp current_user cycle |
| 2034 | 506 syn keyword sqlKeyword databases datatype dba dbfile |
| 507 syn keyword sqlKeyword dbspace dbspaces dbspacename debug decoupled | |
| 508 syn keyword sqlKeyword decrypted default defaults default_dbspace deferred | |
| 509 syn keyword sqlKeyword definer definition | |
| 1621 | 510 syn keyword sqlKeyword delay deleting delimited dependencies desc |
| 3312 | 511 syn keyword sqlKeyword description deterministic directory |
| 4437 | 512 syn keyword sqlKeyword disable disabled disallow distinct disksandbox disk_sandbox |
| 513 syn keyword sqlKeyword dn do domain download duplicate | |
| 514 syn keyword sqlKeyword dsetpass dttm dynamic each earth editproc effective ejb | |
| 515 syn keyword sqlKeyword elimination ellipsoid else elseif | |
| 516 syn keyword sqlKeyword email empty enable encapsulated encrypted encryption end | |
| 517 syn keyword sqlKeyword encoding endif engine environment erase error errors escape escapes event | |
| 3312 | 518 syn keyword sqlKeyword event_parameter every exception exclude excluded exclusive exec |
| 2034 | 519 syn keyword sqlKeyword existing exists expanded expiry express exprtype extended_property |
| 1621 | 520 syn keyword sqlKeyword external externlogin factor failover false |
| 3312 | 521 syn keyword sqlKeyword fastfirstrow feature fieldproc file files filler |
| 522 syn keyword sqlKeyword fillfactor final finish first first_keyword first_value | |
| 523 syn keyword sqlKeyword flattening | |
| 4437 | 524 syn keyword sqlKeyword following force foreign format forjson forxml forxml_sep fp frame |
| 525 syn keyword sqlKeyword free freepage french fresh full function | |
| 3312 | 526 syn keyword sqlKeyword gb generic get_bit go global grid |
| 2034 | 527 syn keyword sqlKeyword group handler hash having header hexadecimal |
| 528 syn keyword sqlKeyword hidden high history hg hng hold holdlock host | |
| 529 syn keyword sqlKeyword hours http_body http_session_timeout id identified identity ignore | |
| 1621 | 530 syn keyword sqlKeyword ignore_dup_key ignore_dup_row immediate |
| 3312 | 531 syn keyword sqlKeyword in inactiv inactive inactivity included increment incremental |
| 4437 | 532 syn keyword sqlKeyword index index_enabled index_lparen indexonly info information |
| 533 syn keyword sqlKeyword inheritance inline inner inout insensitive inserting | |
| 534 syn keyword sqlKeyword instead | |
| 535 syn keyword sqlKeyword internal intersection into introduced inverse invoker | |
| 3312 | 536 syn keyword sqlKeyword iq is isolation |
| 2034 | 537 syn keyword sqlKeyword jar java java_location java_main_userid java_vm_options |
| 4437 | 538 syn keyword sqlKeyword jconnect jdk join json kb key keys keep language last |
| 3312 | 539 syn keyword sqlKeyword last_keyword last_value lateral latitude |
| 4437 | 540 syn keyword sqlKeyword ld ldap left len linear lf ln level like |
| 541 syn keyword sqlKeyword limit local location log | |
| 3312 | 542 syn keyword sqlKeyword logging logical login logscan long longitude low lru ls |
| 4437 | 543 syn keyword sqlKeyword main major manage manual mark master |
| 544 syn keyword sqlKeyword match matched materialized max maxvalue maximum mb measure median membership | |
| 545 syn keyword sqlKeyword merge metadata methods migrate minimum minor minutes minvalue mirror | |
| 546 syn keyword sqlKeyword mode modify monitor move mru multiplex | |
| 547 syn keyword sqlKeyword name named namespaces national native natural new next nextval | |
| 3312 | 548 syn keyword sqlKeyword ngram no noholdlock nolock nonclustered none normal not |
| 4437 | 549 syn keyword sqlKeyword notify null nullable_constant nulls |
| 550 syn keyword sqlKeyword object objects oem_string of off offline offset olap | |
| 3312 | 551 syn keyword sqlKeyword old on online only openstring operator |
| 552 syn keyword sqlKeyword optimization optimizer option | |
| 4437 | 553 syn keyword sqlKeyword or order ordinality organization others out outer over owner |
| 1621 | 554 syn keyword sqlKeyword package packetsize padding page pages |
| 4437 | 555 syn keyword sqlKeyword paglock parallel parameter parent part partial |
| 556 syn keyword sqlKeyword partition partitions partner password path pctfree | |
| 557 syn keyword sqlKeyword permissions perms plan planar policy polygon populate port postfilter preceding | |
| 3312 | 558 syn keyword sqlKeyword precisionprefetch prefilter prefix preserve preview previous |
| 4437 | 559 syn keyword sqlKeyword primary prior priority priqty private privilege privileges procedure profile profiling |
| 2034 | 560 syn keyword sqlKeyword property_is_cumulative property_is_numeric public publication publish publisher |
| 561 syn keyword sqlKeyword quiesce quote quotes range readclientfile readcommitted reader readfile readonly | |
| 1621 | 562 syn keyword sqlKeyword readpast readuncommitted readwrite rebuild |
| 563 syn keyword sqlKeyword received recompile recover recursive references | |
| 3312 | 564 syn keyword sqlKeyword referencing regex regexp regexp_substr relative relocate |
| 4437 | 565 syn keyword sqlKeyword rename repeatable repeatableread replicate replication |
| 3312 | 566 syn keyword sqlKeyword requests request_timeout required rereceive resend reserve reset |
| 567 syn keyword sqlKeyword resizing resolve resource respect restart | |
| 4437 | 568 syn keyword sqlKeyword restrict result retain retries |
| 569 syn keyword sqlKeyword returns reverse right role roles | |
| 570 syn keyword sqlKeyword rollup root row row_number rowlock rows rowtype | |
| 2034 | 571 syn keyword sqlKeyword sa_index_hash sa_internal_fk_verify sa_internal_termbreak |
| 572 syn keyword sqlKeyword sa_order_preserving_hash sa_order_preserving_hash_big sa_order_preserving_hash_prefix | |
| 4437 | 573 syn keyword sqlKeyword sa_file_free_pages sa_internal_type_from_catalog sa_internal_valid_hash |
| 574 syn keyword sqlKeyword sa_internal_validate_value sa_json_element | |
| 575 syn keyword sqlKeyword scale schedule schema scope script scripted scroll search seconds secqty security | |
| 3312 | 576 syn keyword sqlKeyword semi send sensitive sent sequence serializable |
| 4437 | 577 syn keyword sqlKeyword server severity session set_bit set_bits sets |
| 3312 | 578 syn keyword sqlKeyword shapefile share side simple since site size skip |
| 4437 | 579 syn keyword sqlKeyword snap snapshot soapheader soap_header |
| 3312 | 580 syn keyword sqlKeyword spatial split some sorted_data |
| 581 syn keyword sqlKeyword sql sqlcode sqlid sqlflagger sqlstate sqrt square | |
| 4437 | 582 syn keyword sqlKeyword stacker stale state statement statistics status stddev_pop stddev_samp |
| 3312 | 583 syn keyword sqlKeyword stemmer stogroup stoplist storage store |
| 2034 | 584 syn keyword sqlKeyword strip stripesizekb striping subpages subscribe subscription |
| 4437 | 585 syn keyword sqlKeyword subtransaction suser_id suser_name suspend synchronization |
| 3312 | 586 syn keyword sqlKeyword syntax_error table tables tablock |
| 4437 | 587 syn keyword sqlKeyword tablockx target tb temp template temporary term then ties |
| 588 syn keyword sqlKeyword timezone timeout tls to to_char to_nchar tolerance top | |
| 589 syn keyword sqlKeyword trace traced_plan tracing | |
| 590 syn keyword sqlKeyword transfer transform transaction transactional treat tries | |
| 591 syn keyword sqlKeyword true try tsequal type tune uncommitted unconditionally | |
| 3312 | 592 syn keyword sqlKeyword unenforced unicode unique unistr unit unknown unlimited unload |
| 2034 | 593 syn keyword sqlKeyword unpartition unquiesce updatetime updating updlock upgrade upload |
| 3312 | 594 syn keyword sqlKeyword upper usage use user |
| 1621 | 595 syn keyword sqlKeyword using utc utilities validproc |
| 596 syn keyword sqlKeyword value values varchar variable | |
| 3312 | 597 syn keyword sqlKeyword varying var_pop var_samp vcat verbosity |
| 598 syn keyword sqlKeyword verify versions view virtual wait | |
| 599 syn keyword sqlKeyword warning wd web when where with with_auto | |
| 1621 | 600 syn keyword sqlKeyword with_auto with_cube with_rollup without |
| 2034 | 601 syn keyword sqlKeyword with_lparen within word work workload write writefile |
| 4437 | 602 syn keyword sqlKeyword writeclientfile writer writers writeserver xlock |
| 603 syn keyword sqlKeyword war xml zeros zone | |
| 604 " XML | |
| 1621 | 605 syn keyword sqlKeyword raw auto elements explicit |
| 719 | 606 " HTTP support |
| 2034 | 607 syn keyword sqlKeyword authorization secure url service next_soap_header |
| 719 | 608 " HTTP 9.0.2 new procedure keywords |
| 4437 | 609 syn keyword sqlKeyword namespace certificate certificates clientport proxy trusted_certificates_file |
| 719 | 610 " OLAP support 9.0.0 |
| 2034 | 611 syn keyword sqlKeyword covar_pop covar_samp corr regr_slope regr_intercept |
| 1621 | 612 syn keyword sqlKeyword regr_count regr_r2 regr_avgx regr_avgy |
| 613 syn keyword sqlKeyword regr_sxx regr_syy regr_sxy | |
| 719 | 614 |
| 615 " Alternate keywords | |
| 1621 | 616 syn keyword sqlKeyword character dec options proc reference |
| 2034 | 617 syn keyword sqlKeyword subtrans tran syn keyword |
| 719 | 618 |
| 4437 | 619 " Login Mode Options |
| 620 syn keyword sqlKeywordLogin standard integrated kerberos LDAPUA | |
| 621 syn keyword sqlKeywordLogin cloudadmin mixed | |
| 622 | |
| 3312 | 623 " Spatial Predicates |
| 624 syn keyword sqlKeyword ST_Contains | |
| 625 syn keyword sqlKeyword ST_ContainsFilter | |
| 626 syn keyword sqlKeyword ST_CoveredBy | |
| 627 syn keyword sqlKeyword ST_CoveredByFilter | |
| 628 syn keyword sqlKeyword ST_Covers | |
| 629 syn keyword sqlKeyword ST_CoversFilter | |
| 630 syn keyword sqlKeyword ST_Crosses | |
| 631 syn keyword sqlKeyword ST_Disjoint | |
| 632 syn keyword sqlKeyword ST_Equals | |
| 633 syn keyword sqlKeyword ST_EqualsFilter | |
| 634 syn keyword sqlKeyword ST_Intersects | |
| 635 syn keyword sqlKeyword ST_IntersectsFilter | |
| 636 syn keyword sqlKeyword ST_IntersectsRect | |
| 637 syn keyword sqlKeyword ST_OrderingEquals | |
| 638 syn keyword sqlKeyword ST_Overlaps | |
| 639 syn keyword sqlKeyword ST_Relate | |
| 640 syn keyword sqlKeyword ST_Touches | |
| 641 syn keyword sqlKeyword ST_Within | |
| 642 syn keyword sqlKeyword ST_WithinFilter | |
| 643 " Spatial Set operations | |
| 644 syn keyword sqlKeyword ST_Affine | |
| 645 syn keyword sqlKeyword ST_Boundary | |
| 646 syn keyword sqlKeyword ST_Buffer | |
| 647 syn keyword sqlKeyword ST_ConvexHull | |
| 648 syn keyword sqlKeyword ST_ConvexHullAggr | |
| 649 syn keyword sqlKeyword ST_Difference | |
| 650 syn keyword sqlKeyword ST_Intersection | |
| 651 syn keyword sqlKeyword ST_IntersectionAggr | |
| 652 syn keyword sqlKeyword ST_SymDifference | |
| 653 syn keyword sqlKeyword ST_Union | |
| 654 syn keyword sqlKeyword ST_UnionAggr | |
| 655 " Spatial Bounds | |
| 656 syn keyword sqlKeyword ST_Envelope | |
| 657 syn keyword sqlKeyword ST_EnvelopeAggr | |
| 658 syn keyword sqlKeyword ST_Lat | |
| 659 syn keyword sqlKeyword ST_LatMax | |
| 660 syn keyword sqlKeyword ST_LatMin | |
| 661 syn keyword sqlKeyword ST_Long | |
| 662 syn keyword sqlKeyword ST_LongMax | |
| 663 syn keyword sqlKeyword ST_LongMin | |
| 664 syn keyword sqlKeyword ST_M | |
| 665 syn keyword sqlKeyword ST_MMax | |
| 666 syn keyword sqlKeyword ST_MMin | |
| 667 syn keyword sqlKeyword ST_Point | |
| 668 syn keyword sqlKeyword ST_X | |
| 669 syn keyword sqlKeyword ST_XMax | |
| 670 syn keyword sqlKeyword ST_XMin | |
| 671 syn keyword sqlKeyword ST_Y | |
| 672 syn keyword sqlKeyword ST_YMax | |
| 673 syn keyword sqlKeyword ST_YMin | |
| 674 syn keyword sqlKeyword ST_Z | |
| 675 syn keyword sqlKeyword ST_ZMax | |
| 676 syn keyword sqlKeyword ST_ZMin | |
| 677 " Spatial Collection Aggregates | |
| 678 syn keyword sqlKeyword ST_GeomCollectionAggr | |
| 679 syn keyword sqlKeyword ST_LineStringAggr | |
| 680 syn keyword sqlKeyword ST_MultiCurveAggr | |
| 681 syn keyword sqlKeyword ST_MultiLineStringAggr | |
| 682 syn keyword sqlKeyword ST_MultiPointAggr | |
| 683 syn keyword sqlKeyword ST_MultiPolygonAggr | |
| 684 syn keyword sqlKeyword ST_MultiSurfaceAggr | |
| 685 syn keyword sqlKeyword ST_Perimeter | |
| 686 syn keyword sqlKeyword ST_PointOnSurface | |
| 687 " Spatial SRS | |
| 688 syn keyword sqlKeyword ST_CompareWKT | |
| 689 syn keyword sqlKeyword ST_FormatWKT | |
| 690 syn keyword sqlKeyword ST_ParseWKT | |
| 691 syn keyword sqlKeyword ST_TransformGeom | |
| 692 syn keyword sqlKeyword ST_GeometryTypeFromBaseType | |
| 693 syn keyword sqlKeyword ST_SnapToGrid | |
| 694 syn keyword sqlKeyword ST_Transform | |
| 695 syn keyword sqlKeyword ST_SRID | |
| 696 syn keyword sqlKeyword ST_SRIDFromBaseType | |
| 697 syn keyword sqlKeyword ST_LoadConfigurationData | |
| 698 " Spatial Indexes | |
| 699 syn keyword sqlKeyword ST_LinearHash | |
| 700 syn keyword sqlKeyword ST_LinearUnHash | |
| 719 | 701 |
| 1621 | 702 syn keyword sqlOperator in any some all between exists |
| 2034 | 703 syn keyword sqlOperator like escape not is and or |
| 3312 | 704 syn keyword sqlOperator minus |
| 4437 | 705 syn keyword sqlOperator prior distinct unnest |
| 719 | 706 |
| 4437 | 707 syn keyword sqlStatement allocate alter attach backup begin break call case catch |
| 3312 | 708 syn keyword sqlStatement checkpoint clear close comment commit configure connect |
| 709 syn keyword sqlStatement continue create deallocate declare delete describe | |
| 710 syn keyword sqlStatement detach disconnect drop except execute exit explain fetch | |
| 719 | 711 syn keyword sqlStatement for forward from get goto grant help if include |
| 3312 | 712 syn keyword sqlStatement input insert install intersect leave load lock loop |
| 713 syn keyword sqlStatement message open output parameters passthrough | |
| 714 syn keyword sqlStatement prepare print put raiserror read readtext refresh release | |
| 719 | 715 syn keyword sqlStatement remote remove reorganize resignal restore resume |
| 3312 | 716 syn keyword sqlStatement return revoke rollback save savepoint select |
| 719 | 717 syn keyword sqlStatement set setuser signal start stop synchronize |
| 4437 | 718 syn keyword sqlStatement system trigger truncate try union unload update |
| 3312 | 719 syn keyword sqlStatement validate waitfor whenever while window writetext |
| 719 | 720 |
| 721 | |
| 3312 | 722 syn keyword sqlType char nchar long varchar nvarchar text ntext uniqueidentifierstr xml |
| 723 syn keyword sqlType bigint bit decimal double varbit | |
| 724 syn keyword sqlType float int integer numeric | |
| 1621 | 725 syn keyword sqlType smallint tinyint real |
| 726 syn keyword sqlType money smallmoney | |
| 3312 | 727 syn keyword sqlType date datetime datetimeoffset smalldatetime time timestamp |
| 4437 | 728 syn keyword sqlType binary image varray varbinary uniqueidentifier |
| 3312 | 729 syn keyword sqlType unsigned |
| 730 " Spatial types | |
| 731 syn keyword sqlType st_geometry st_point st_curve st_surface st_geomcollection | |
| 732 syn keyword sqlType st_linestring st_circularstring st_compoundcurve | |
| 733 syn keyword sqlType st_curvepolygon st_polygon | |
| 734 syn keyword sqlType st_multipoint st_multicurve st_multisurface | |
| 735 syn keyword sqlType st_multilinestring st_multipolygon | |
| 719 | 736 |
| 1621 | 737 syn keyword sqlOption Allow_nulls_by_default |
| 2034 | 738 syn keyword sqlOption Allow_read_client_file |
| 739 syn keyword sqlOption Allow_snapshot_isolation | |
| 740 syn keyword sqlOption Allow_write_client_file | |
| 1621 | 741 syn keyword sqlOption Ansi_blanks |
| 742 syn keyword sqlOption Ansi_close_cursors_on_rollback | |
| 743 syn keyword sqlOption Ansi_permissions | |
| 2034 | 744 syn keyword sqlOption Ansi_substring |
| 1621 | 745 syn keyword sqlOption Ansi_update_constraints |
| 746 syn keyword sqlOption Ansinull | |
| 747 syn keyword sqlOption Auditing | |
| 748 syn keyword sqlOption Auditing_options | |
| 4437 | 749 syn keyword sqlOption Auto_commit_on_create_local_temp_index |
| 1621 | 750 syn keyword sqlOption Background_priority |
| 751 syn keyword sqlOption Blocking | |
| 4437 | 752 syn keyword sqlOption Blocking_others_timeout |
| 1621 | 753 syn keyword sqlOption Blocking_timeout |
| 754 syn keyword sqlOption Chained | |
| 755 syn keyword sqlOption Checkpoint_time | |
| 756 syn keyword sqlOption Cis_option | |
| 757 syn keyword sqlOption Cis_rowset_size | |
| 758 syn keyword sqlOption Close_on_endtrans | |
| 2034 | 759 syn keyword sqlOption Collect_statistics_on_dml_updates |
| 760 syn keyword sqlOption Conn_auditing | |
| 1621 | 761 syn keyword sqlOption Connection_authentication |
| 762 syn keyword sqlOption Continue_after_raiserror | |
| 763 syn keyword sqlOption Conversion_error | |
| 764 syn keyword sqlOption Cooperative_commit_timeout | |
| 765 syn keyword sqlOption Cooperative_commits | |
| 766 syn keyword sqlOption Database_authentication | |
| 767 syn keyword sqlOption Date_format | |
| 768 syn keyword sqlOption Date_order | |
| 4437 | 769 syn keyword sqlOption db_publisher |
| 1621 | 770 syn keyword sqlOption Debug_messages |
| 771 syn keyword sqlOption Dedicated_task | |
| 2034 | 772 syn keyword sqlOption Default_dbspace |
| 1621 | 773 syn keyword sqlOption Default_timestamp_increment |
| 774 syn keyword sqlOption Delayed_commit_timeout | |
| 775 syn keyword sqlOption Delayed_commits | |
| 3312 | 776 syn keyword sqlOption Divide_by_zero_error |
| 1621 | 777 syn keyword sqlOption Escape_character |
| 778 syn keyword sqlOption Exclude_operators | |
| 779 syn keyword sqlOption Extended_join_syntax | |
| 4437 | 780 syn keyword sqlOption Extern_login_credentials |
| 1621 | 781 syn keyword sqlOption Fire_triggers |
| 782 syn keyword sqlOption First_day_of_week | |
| 783 syn keyword sqlOption For_xml_null_treatment | |
| 784 syn keyword sqlOption Force_view_creation | |
| 785 syn keyword sqlOption Global_database_id | |
| 2034 | 786 syn keyword sqlOption Http_session_timeout |
| 4437 | 787 syn keyword sqlOption Http_connection_pool_basesize |
| 788 syn keyword sqlOption Http_connection_pool_timeout | |
| 1621 | 789 syn keyword sqlOption Integrated_server_name |
| 790 syn keyword sqlOption Isolation_level | |
| 4437 | 791 syn keyword sqlOption Java_class_path |
| 2034 | 792 syn keyword sqlOption Java_location |
| 793 syn keyword sqlOption Java_main_userid | |
| 794 syn keyword sqlOption Java_vm_options | |
| 1621 | 795 syn keyword sqlOption Lock_rejected_rows |
| 796 syn keyword sqlOption Log_deadlocks | |
| 797 syn keyword sqlOption Login_mode | |
| 798 syn keyword sqlOption Login_procedure | |
| 2034 | 799 syn keyword sqlOption Materialized_view_optimization |
| 800 syn keyword sqlOption Max_client_statements_cached | |
| 1621 | 801 syn keyword sqlOption Max_cursor_count |
| 802 syn keyword sqlOption Max_hash_size | |
| 803 syn keyword sqlOption Max_plans_cached | |
| 2034 | 804 syn keyword sqlOption Max_priority |
| 805 syn keyword sqlOption Max_query_tasks | |
| 1621 | 806 syn keyword sqlOption Max_recursive_iterations |
| 807 syn keyword sqlOption Max_statement_count | |
| 2034 | 808 syn keyword sqlOption Max_temp_space |
| 1621 | 809 syn keyword sqlOption Min_password_length |
| 4437 | 810 syn keyword sqlOption Min_role_admins |
| 1621 | 811 syn keyword sqlOption Nearest_century |
| 812 syn keyword sqlOption Non_keywords | |
| 2034 | 813 syn keyword sqlOption Odbc_describe_binary_as_varbinary |
| 814 syn keyword sqlOption Odbc_distinguish_char_and_varchar | |
| 815 syn keyword sqlOption Oem_string | |
| 816 syn keyword sqlOption On_charset_conversion_failure | |
| 1621 | 817 syn keyword sqlOption On_tsql_error |
| 818 syn keyword sqlOption Optimization_goal | |
| 819 syn keyword sqlOption Optimization_level | |
| 820 syn keyword sqlOption Optimization_workload | |
| 821 syn keyword sqlOption Pinned_cursor_percent_of_cache | |
| 2034 | 822 syn keyword sqlOption Post_login_procedure |
| 1621 | 823 syn keyword sqlOption Precision |
| 824 syn keyword sqlOption Prefetch | |
| 825 syn keyword sqlOption Preserve_source_format | |
| 826 syn keyword sqlOption Prevent_article_pkey_update | |
| 2034 | 827 syn keyword sqlOption Priority |
| 4437 | 828 syn keyword sqlOption Progress_messages |
| 2034 | 829 syn keyword sqlOption Query_mem_timeout |
| 1621 | 830 syn keyword sqlOption Quoted_identifier |
| 831 syn keyword sqlOption Read_past_deleted | |
| 832 syn keyword sqlOption Recovery_time | |
| 833 syn keyword sqlOption Remote_idle_timeout | |
| 834 syn keyword sqlOption Replicate_all | |
| 2034 | 835 syn keyword sqlOption Request_timeout |
| 4437 | 836 syn keyword sqlOption Reserved_keywords |
| 1621 | 837 syn keyword sqlOption Return_date_time_as_string |
| 838 syn keyword sqlOption Rollback_on_deadlock | |
| 839 syn keyword sqlOption Row_counts | |
| 840 syn keyword sqlOption Scale | |
| 2034 | 841 syn keyword sqlOption Secure_feature_key |
| 842 syn keyword sqlOption Sort_collation | |
| 843 syn keyword sqlOption Sql_flagger_error_level | |
| 844 syn keyword sqlOption Sql_flagger_warning_level | |
| 1621 | 845 syn keyword sqlOption String_rtruncation |
| 4437 | 846 syn keyword sqlOption st_geometry_asbinary_format |
| 847 syn keyword sqlOption st_geometry_astext_format | |
| 848 syn keyword sqlOption st_geometry_asxml_format | |
| 849 syn keyword sqlOption st_geometry_describe_type | |
| 850 syn keyword sqlOption st_geometry_interpolation | |
| 851 syn keyword sqlOption st_geometry_on_invalid | |
| 1621 | 852 syn keyword sqlOption Subsume_row_locks |
| 2034 | 853 syn keyword sqlOption Suppress_tds_debugging |
| 854 syn keyword sqlOption Synchronize_mirror_on_commit | |
| 855 syn keyword sqlOption Tds_empty_string_is_null | |
| 1621 | 856 syn keyword sqlOption Temp_space_limit_check |
| 857 syn keyword sqlOption Time_format | |
| 858 syn keyword sqlOption Time_zone_adjustment | |
| 859 syn keyword sqlOption Timestamp_format | |
| 4437 | 860 syn keyword sqlOption Timestamp_with_time_zone_format |
| 1621 | 861 syn keyword sqlOption Truncate_timestamp_values |
| 2034 | 862 syn keyword sqlOption Tsql_outer_joins |
| 1621 | 863 syn keyword sqlOption Tsql_variables |
| 2034 | 864 syn keyword sqlOption Updatable_statement_isolation |
| 1621 | 865 syn keyword sqlOption Update_statistics |
| 2034 | 866 syn keyword sqlOption Upgrade_database_capability |
| 1621 | 867 syn keyword sqlOption User_estimates |
| 3312 | 868 syn keyword sqlOption Uuid_has_hyphens |
| 2034 | 869 syn keyword sqlOption Verify_password_function |
| 1621 | 870 syn keyword sqlOption Wait_for_commit |
| 2034 | 871 syn keyword sqlOption Webservice_namespace_host |
| 4437 | 872 syn keyword sqlOption Webservice_sessionid_name |
| 719 | 873 |
| 874 " Strings and characters: | |
| 875 syn region sqlString start=+"+ end=+"+ contains=@Spell | |
| 876 syn region sqlString start=+'+ end=+'+ contains=@Spell | |
| 877 | |
| 878 " Numbers: | |
| 879 syn match sqlNumber "-\=\<\d*\.\=[0-9_]\>" | |
| 880 | |
| 881 " Comments: | |
| 882 syn region sqlDashComment start=/--/ end=/$/ contains=@Spell | |
| 883 syn region sqlSlashComment start=/\/\// end=/$/ contains=@Spell | |
| 884 syn region sqlMultiComment start="/\*" end="\*/" contains=sqlMultiComment,@Spell | |
| 885 syn cluster sqlComment contains=sqlDashComment,sqlSlashComment,sqlMultiComment,@Spell | |
| 886 syn sync ccomment sqlComment | |
| 887 syn sync ccomment sqlDashComment | |
| 888 syn sync ccomment sqlSlashComment | |
| 889 | |
| 4437 | 890 hi def link sqlDashComment Comment |
| 891 hi def link sqlSlashComment Comment | |
| 892 hi def link sqlMultiComment Comment | |
| 893 hi def link sqlNumber Number | |
| 894 hi def link sqlOperator Operator | |
| 895 hi def link sqlSpecial Special | |
| 896 hi def link sqlKeyword Keyword | |
| 897 hi def link sqlStatement Statement | |
| 898 hi def link sqlString String | |
| 899 hi def link sqlType Type | |
| 900 hi def link sqlFunction Function | |
| 901 hi def link sqlOption PreProc | |
| 719 | 902 |
| 903 let b:current_syntax = "sqlanywhere" | |
| 904 | |
| 1621 | 905 " vim:sw=4: |