LiveView inherits the reserved word lists from StreamSQL and the StreamBase expression language. amd then adds a few of its own. When you name fields and other identifiers in LiveView queries, do not use words from any of these lists.
- StreamSQL Reserved Words
-
The terms in the following list of are sorted alphabetically across, then down.
advance always and apply as asc between bsort by constant create declare default delete desc duplicate error every except extends false foreach from gather group having heartbeat if implements import index input insert into join key limit lock lockset materialized merge metronome not null offset on or order outer output parallel parameters partition pattern predicate primary private public replace returning schema secondary select set size slack stream table then time timeout true truncate tuples union unlock update using valid vjoin where window with within - StreamBase Expression Language Reserved Words
-
The StreamBase expression language has the following reserved words:
and as between else false function if or not null then true Most of these reserved words duplicate words in the StreamSQL list. The following expression language reserved words are reserved in LiveView in addition to the StreamSQL reserved words:
else function - LiveView Additional Reserved Words
-
LiveView has the following additional reserved words:
command key old publisherid publishersn Finally, no LiveView column name can begin with
CQSor an underscore (_).