3 cmdlist ::= * cmdlist ecmd
6 ecmd ::= * explain cmdx SEMI
9 explain ::= * EXPLAIN QUERY PLAN
25 select ::= * oneselect
26 select ::= * select multiselect_op oneselect
27 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
34 expr ::= * nm DOT nm DOT nm
35 term ::= * INTEGER|FLOAT|BLOB
39 expr ::= * expr COLLATE ids
40 expr ::= * CAST LP expr AS typetoken RP
41 expr ::= * ID LP distinct exprlist RP
42 expr ::= * ID LP STAR RP
44 expr ::= * expr AND expr
45 expr ::= * expr OR expr
46 expr ::= * expr LT|GT|GE|LE expr
47 expr ::= * expr EQ|NE expr
48 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
49 expr ::= * expr PLUS|MINUS expr
50 expr ::= * expr STAR|SLASH|REM expr
51 expr ::= * expr CONCAT expr
52 expr ::= * expr likeop expr
53 expr ::= * expr likeop expr ESCAPE expr
54 expr ::= * expr ISNULL|NOTNULL
55 expr ::= * expr NOT NULL
56 expr ::= * expr IS expr
57 expr ::= * expr IS NOT expr
59 expr ::= * BITNOT expr
62 expr ::= * expr between_op expr AND expr
63 expr ::= * expr in_op LP exprlist RP
64 expr ::= expr in_op LP * exprlist RP
65 expr ::= * LP select RP
66 expr ::= * expr in_op LP select RP
67 expr ::= expr in_op LP * select RP
68 expr ::= * expr in_op nm dbnm
69 expr ::= * EXISTS LP select RP
70 expr ::= * CASE case_operand case_exprlist case_else END
71 exprlist ::= * nexprlist
73 nexprlist ::= * nexprlist COMMA expr
75 expr ::= * RAISE LP IGNORE RP
76 expr ::= * RAISE LP raisetype COMMA nm RP
110 ecmd ::= explain * cmdx SEMI
112 cmd ::= * BEGIN transtype trans_opt
113 cmd ::= * COMMIT trans_opt
114 cmd ::= * END trans_opt
115 cmd ::= * ROLLBACK trans_opt
116 cmd ::= * SAVEPOINT nm
117 cmd ::= * RELEASE savepoint_opt nm
118 cmd ::= * ROLLBACK trans_opt TO savepoint_opt nm
119 cmd ::= * create_table create_table_args
120 create_table ::= * createkw temp TABLE ifnotexists nm dbnm
121 createkw ::= * CREATE
122 cmd ::= * DROP TABLE ifexists fullname
123 cmd ::= * createkw temp VIEW ifnotexists nm dbnm AS select
124 cmd ::= * DROP VIEW ifexists fullname
126 select ::= * oneselect
127 select ::= * select multiselect_op oneselect
128 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
129 cmd ::= * DELETE FROM fullname indexed_opt where_opt
130 cmd ::= * UPDATE orconf fullname indexed_opt SET setlist where_opt
131 cmd ::= * insert_cmd INTO fullname inscollist_opt valuelist
132 cmd ::= * insert_cmd INTO fullname inscollist_opt select
133 cmd ::= * insert_cmd INTO fullname inscollist_opt DEFAULT VALUES
134 insert_cmd ::= * INSERT orconf
135 insert_cmd ::= * REPLACE
136 cmd ::= * createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP where_opt
137 cmd ::= * DROP INDEX ifexists fullname
140 cmd ::= * PRAGMA nm dbnm
141 cmd ::= * PRAGMA nm dbnm EQ nmnum
142 cmd ::= * PRAGMA nm dbnm LP nmnum RP
143 cmd ::= * PRAGMA nm dbnm EQ minus_num
144 cmd ::= * PRAGMA nm dbnm LP minus_num RP
145 cmd ::= * createkw trigger_decl BEGIN trigger_cmd_list END
146 cmd ::= * DROP TRIGGER ifexists fullname
147 cmd ::= * ATTACH database_kw_opt expr AS expr key_opt
148 cmd ::= * DETACH database_kw_opt expr
150 cmd ::= * REINDEX nm dbnm
152 cmd ::= * ANALYZE nm dbnm
153 cmd ::= * ALTER TABLE fullname RENAME TO nm
154 cmd ::= * ALTER TABLE add_column_fullname ADD kwcolumn_opt column
155 cmd ::= * create_vtab
156 cmd ::= * create_vtab LP vtabarglist RP
157 create_vtab ::= * createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm
181 create_table shift 236
186 create_vtab shift 331
194 select ::= * oneselect
195 select ::= * select multiselect_op oneselect
196 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
198 expr ::= * LP expr RP
199 expr ::= LP * expr RP
204 expr ::= * nm DOT nm DOT nm
205 term ::= * INTEGER|FLOAT|BLOB
209 expr ::= * expr COLLATE ids
210 expr ::= * CAST LP expr AS typetoken RP
211 expr ::= * ID LP distinct exprlist RP
212 expr ::= * ID LP STAR RP
214 expr ::= * expr AND expr
215 expr ::= * expr OR expr
216 expr ::= * expr LT|GT|GE|LE expr
217 expr ::= * expr EQ|NE expr
218 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
219 expr ::= * expr PLUS|MINUS expr
220 expr ::= * expr STAR|SLASH|REM expr
221 expr ::= * expr CONCAT expr
222 expr ::= * expr likeop expr
223 expr ::= * expr likeop expr ESCAPE expr
224 expr ::= * expr ISNULL|NOTNULL
225 expr ::= * expr NOT NULL
226 expr ::= * expr IS expr
227 expr ::= * expr IS NOT expr
229 expr ::= * BITNOT expr
230 expr ::= * MINUS expr
232 expr ::= * expr between_op expr AND expr
233 expr ::= * expr in_op LP exprlist RP
234 expr ::= * LP select RP
235 expr ::= LP * select RP
236 expr ::= * expr in_op LP select RP
237 expr ::= * expr in_op nm dbnm
238 expr ::= * EXISTS LP select RP
239 expr ::= * CASE case_operand case_exprlist case_else END
240 expr ::= * RAISE LP IGNORE RP
241 expr ::= * RAISE LP raisetype COMMA nm RP
277 valuelist ::= valuelist COMMA LP * exprlist RP
279 expr ::= * LP expr RP
284 expr ::= * nm DOT nm DOT nm
285 term ::= * INTEGER|FLOAT|BLOB
289 expr ::= * expr COLLATE ids
290 expr ::= * CAST LP expr AS typetoken RP
291 expr ::= * ID LP distinct exprlist RP
292 expr ::= * ID LP STAR RP
294 expr ::= * expr AND expr
295 expr ::= * expr OR expr
296 expr ::= * expr LT|GT|GE|LE expr
297 expr ::= * expr EQ|NE expr
298 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
299 expr ::= * expr PLUS|MINUS expr
300 expr ::= * expr STAR|SLASH|REM expr
301 expr ::= * expr CONCAT expr
302 expr ::= * expr likeop expr
303 expr ::= * expr likeop expr ESCAPE expr
304 expr ::= * expr ISNULL|NOTNULL
305 expr ::= * expr NOT NULL
306 expr ::= * expr IS expr
307 expr ::= * expr IS NOT expr
309 expr ::= * BITNOT expr
310 expr ::= * MINUS expr
312 expr ::= * expr between_op expr AND expr
313 expr ::= * expr in_op LP exprlist RP
314 expr ::= * LP select RP
315 expr ::= * expr in_op LP select RP
316 expr ::= * expr in_op nm dbnm
317 expr ::= * EXISTS LP select RP
318 expr ::= * CASE case_operand case_exprlist case_else END
319 exprlist ::= * nexprlist
321 nexprlist ::= * nexprlist COMMA expr
323 expr ::= * RAISE LP IGNORE RP
324 expr ::= * RAISE LP raisetype COMMA nm RP
361 expr ::= * LP expr RP
366 expr ::= * nm DOT nm DOT nm
367 term ::= * INTEGER|FLOAT|BLOB
371 expr ::= * expr COLLATE ids
372 expr ::= * CAST LP expr AS typetoken RP
373 expr ::= * ID LP distinct exprlist RP
374 expr ::= ID LP distinct * exprlist RP
375 expr ::= * ID LP STAR RP
377 expr ::= * expr AND expr
378 expr ::= * expr OR expr
379 expr ::= * expr LT|GT|GE|LE expr
380 expr ::= * expr EQ|NE expr
381 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
382 expr ::= * expr PLUS|MINUS expr
383 expr ::= * expr STAR|SLASH|REM expr
384 expr ::= * expr CONCAT expr
385 expr ::= * expr likeop expr
386 expr ::= * expr likeop expr ESCAPE expr
387 expr ::= * expr ISNULL|NOTNULL
388 expr ::= * expr NOT NULL
389 expr ::= * expr IS expr
390 expr ::= * expr IS NOT expr
392 expr ::= * BITNOT expr
393 expr ::= * MINUS expr
395 expr ::= * expr between_op expr AND expr
396 expr ::= * expr in_op LP exprlist RP
397 expr ::= * LP select RP
398 expr ::= * expr in_op LP select RP
399 expr ::= * expr in_op nm dbnm
400 expr ::= * EXISTS LP select RP
401 expr ::= * CASE case_operand case_exprlist case_else END
402 exprlist ::= * nexprlist
404 nexprlist ::= * nexprlist COMMA expr
406 expr ::= * RAISE LP IGNORE RP
407 expr ::= * RAISE LP raisetype COMMA nm RP
443 cmd ::= PRAGMA nm dbnm LP * nmnum RP
444 cmd ::= PRAGMA nm dbnm LP * minus_num RP
450 plus_num ::= * PLUS number
451 plus_num ::= * number
452 minus_num ::= * MINUS number
453 number ::= * INTEGER|FLOAT
479 cmd ::= PRAGMA nm dbnm EQ * nmnum
480 cmd ::= PRAGMA nm dbnm EQ * minus_num
486 plus_num ::= * PLUS number
487 plus_num ::= * number
488 minus_num ::= * MINUS number
489 number ::= * INTEGER|FLOAT
510 columnlist ::= columnlist COMMA * column
511 column ::= * columnid type carglist
518 conslist_opt ::= COMMA * conslist
519 conslist ::= * conslist tconscomma tcons
521 tcons ::= * CONSTRAINT nm
522 tcons ::= * PRIMARY KEY LP idxlist autoinc RP onconf
523 tcons ::= * UNIQUE LP idxlist RP onconf
524 tcons ::= * CHECK LP expr RP onconf
525 tcons ::= * FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt
545 selcollist ::= sclp expr * as
549 expr ::= expr * COLLATE ids
550 expr ::= expr * AND expr
551 expr ::= expr * OR expr
552 expr ::= expr * LT|GT|GE|LE expr
553 expr ::= expr * EQ|NE expr
554 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
555 expr ::= expr * PLUS|MINUS expr
556 expr ::= expr * STAR|SLASH|REM expr
557 expr ::= expr * CONCAT expr
559 likeop ::= * NOT LIKE_KW
561 likeop ::= * NOT MATCH
562 expr ::= expr * likeop expr
563 expr ::= expr * likeop expr ESCAPE expr
564 expr ::= expr * ISNULL|NOTNULL
565 expr ::= expr * NOT NULL
566 expr ::= expr * IS expr
567 expr ::= expr * IS NOT expr
568 between_op ::= * BETWEEN
569 between_op ::= * NOT BETWEEN
570 expr ::= expr * between_op expr AND expr
573 expr ::= expr * in_op LP exprlist RP
574 expr ::= expr * in_op LP select RP
575 expr ::= expr * in_op nm dbnm
620 valuelist ::= VALUES LP * nexprlist RP
622 expr ::= * LP expr RP
627 expr ::= * nm DOT nm DOT nm
628 term ::= * INTEGER|FLOAT|BLOB
632 expr ::= * expr COLLATE ids
633 expr ::= * CAST LP expr AS typetoken RP
634 expr ::= * ID LP distinct exprlist RP
635 expr ::= * ID LP STAR RP
637 expr ::= * expr AND expr
638 expr ::= * expr OR expr
639 expr ::= * expr LT|GT|GE|LE expr
640 expr ::= * expr EQ|NE expr
641 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
642 expr ::= * expr PLUS|MINUS expr
643 expr ::= * expr STAR|SLASH|REM expr
644 expr ::= * expr CONCAT expr
645 expr ::= * expr likeop expr
646 expr ::= * expr likeop expr ESCAPE expr
647 expr ::= * expr ISNULL|NOTNULL
648 expr ::= * expr NOT NULL
649 expr ::= * expr IS expr
650 expr ::= * expr IS NOT expr
652 expr ::= * BITNOT expr
653 expr ::= * MINUS expr
655 expr ::= * expr between_op expr AND expr
656 expr ::= * expr in_op LP exprlist RP
657 expr ::= * LP select RP
658 expr ::= * expr in_op LP select RP
659 expr ::= * expr in_op nm dbnm
660 expr ::= * EXISTS LP select RP
661 expr ::= * CASE case_operand case_exprlist case_else END
662 nexprlist ::= * nexprlist COMMA expr
664 expr ::= * RAISE LP IGNORE RP
665 expr ::= * RAISE LP raisetype COMMA nm RP
699 groupby_opt ::= GROUP BY * nexprlist
701 expr ::= * LP expr RP
706 expr ::= * nm DOT nm DOT nm
707 term ::= * INTEGER|FLOAT|BLOB
711 expr ::= * expr COLLATE ids
712 expr ::= * CAST LP expr AS typetoken RP
713 expr ::= * ID LP distinct exprlist RP
714 expr ::= * ID LP STAR RP
716 expr ::= * expr AND expr
717 expr ::= * expr OR expr
718 expr ::= * expr LT|GT|GE|LE expr
719 expr ::= * expr EQ|NE expr
720 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
721 expr ::= * expr PLUS|MINUS expr
722 expr ::= * expr STAR|SLASH|REM expr
723 expr ::= * expr CONCAT expr
724 expr ::= * expr likeop expr
725 expr ::= * expr likeop expr ESCAPE expr
726 expr ::= * expr ISNULL|NOTNULL
727 expr ::= * expr NOT NULL
728 expr ::= * expr IS expr
729 expr ::= * expr IS NOT expr
731 expr ::= * BITNOT expr
732 expr ::= * MINUS expr
734 expr ::= * expr between_op expr AND expr
735 expr ::= * expr in_op LP exprlist RP
736 expr ::= * LP select RP
737 expr ::= * expr in_op LP select RP
738 expr ::= * expr in_op nm dbnm
739 expr ::= * EXISTS LP select RP
740 expr ::= * CASE case_operand case_exprlist case_else END
741 nexprlist ::= * nexprlist COMMA expr
743 expr ::= * RAISE LP IGNORE RP
744 expr ::= * RAISE LP raisetype COMMA nm RP
778 orderby_opt ::= ORDER BY * sortlist
779 sortlist ::= * sortlist COMMA expr sortorder
780 sortlist ::= * expr sortorder
782 expr ::= * LP expr RP
787 expr ::= * nm DOT nm DOT nm
788 term ::= * INTEGER|FLOAT|BLOB
792 expr ::= * expr COLLATE ids
793 expr ::= * CAST LP expr AS typetoken RP
794 expr ::= * ID LP distinct exprlist RP
795 expr ::= * ID LP STAR RP
797 expr ::= * expr AND expr
798 expr ::= * expr OR expr
799 expr ::= * expr LT|GT|GE|LE expr
800 expr ::= * expr EQ|NE expr
801 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
802 expr ::= * expr PLUS|MINUS expr
803 expr ::= * expr STAR|SLASH|REM expr
804 expr ::= * expr CONCAT expr
805 expr ::= * expr likeop expr
806 expr ::= * expr likeop expr ESCAPE expr
807 expr ::= * expr ISNULL|NOTNULL
808 expr ::= * expr NOT NULL
809 expr ::= * expr IS expr
810 expr ::= * expr IS NOT expr
812 expr ::= * BITNOT expr
813 expr ::= * MINUS expr
815 expr ::= * expr between_op expr AND expr
816 expr ::= * expr in_op LP exprlist RP
817 expr ::= * LP select RP
818 expr ::= * expr in_op LP select RP
819 expr ::= * expr in_op nm dbnm
820 expr ::= * EXISTS LP select RP
821 expr ::= * CASE case_operand case_exprlist case_else END
822 expr ::= * RAISE LP IGNORE RP
823 expr ::= * RAISE LP raisetype COMMA nm RP
858 expr ::= * LP expr RP
863 expr ::= * nm DOT nm DOT nm
864 term ::= * INTEGER|FLOAT|BLOB
868 expr ::= * expr COLLATE ids
869 expr ::= * CAST LP expr AS typetoken RP
870 expr ::= * ID LP distinct exprlist RP
871 expr ::= * ID LP STAR RP
873 expr ::= * expr AND expr
874 expr ::= * expr OR expr
875 expr ::= * expr LT|GT|GE|LE expr
876 expr ::= * expr EQ|NE expr
877 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
878 expr ::= * expr PLUS|MINUS expr
879 expr ::= * expr STAR|SLASH|REM expr
880 expr ::= * expr CONCAT expr
881 expr ::= * expr likeop expr
882 expr ::= * expr likeop expr ESCAPE expr
883 expr ::= * expr ISNULL|NOTNULL
884 expr ::= * expr NOT NULL
885 expr ::= * expr IS expr
886 expr ::= * expr IS NOT expr
888 expr ::= * BITNOT expr
889 expr ::= * MINUS expr
891 expr ::= * expr between_op expr AND expr
892 expr ::= * expr in_op LP exprlist RP
893 expr ::= * LP select RP
894 expr ::= * expr in_op LP select RP
895 expr ::= * expr in_op nm dbnm
896 expr ::= * EXISTS LP select RP
897 expr ::= * CASE case_operand case_exprlist case_else END
898 expr ::= CASE * case_operand case_exprlist case_else END
899 case_operand ::= * expr
900 (237) case_operand ::= *
901 expr ::= * RAISE LP IGNORE RP
902 expr ::= * RAISE LP raisetype COMMA nm RP
928 case_operand shift 290
932 select ::= * oneselect
933 select ::= * select multiselect_op oneselect
934 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
935 insert_cmd ::= * INSERT orconf
936 insert_cmd ::= * REPLACE
937 cmd ::= createkw trigger_decl BEGIN * trigger_cmd_list END
938 trigger_cmd_list ::= * trigger_cmd_list trigger_cmd SEMI
939 trigger_cmd_list ::= * trigger_cmd SEMI
940 trigger_cmd ::= * UPDATE orconf trnm tridxby SET setlist where_opt
941 trigger_cmd ::= * insert_cmd INTO trnm inscollist_opt valuelist
942 trigger_cmd ::= * insert_cmd INTO trnm inscollist_opt select
943 trigger_cmd ::= * DELETE FROM trnm tridxby where_opt
944 trigger_cmd ::= * select
954 trigger_cmd_list shift 62
955 trigger_cmd shift 346
958 create_table_args ::= LP * columnlist conslist_opt RP
959 columnlist ::= * columnlist COMMA column
960 columnlist ::= * column
961 column ::= * columnid type carglist
980 sortlist ::= expr * sortorder
983 (157) sortorder ::= *
984 expr ::= expr * COLLATE ids
985 expr ::= expr * AND expr
986 expr ::= expr * OR expr
987 expr ::= expr * LT|GT|GE|LE expr
988 expr ::= expr * EQ|NE expr
989 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
990 expr ::= expr * PLUS|MINUS expr
991 expr ::= expr * STAR|SLASH|REM expr
992 expr ::= expr * CONCAT expr
994 likeop ::= * NOT LIKE_KW
996 likeop ::= * NOT MATCH
997 expr ::= expr * likeop expr
998 expr ::= expr * likeop expr ESCAPE expr
999 expr ::= expr * ISNULL|NOTNULL
1000 expr ::= expr * NOT NULL
1001 expr ::= expr * IS expr
1002 expr ::= expr * IS NOT expr
1003 between_op ::= * BETWEEN
1004 between_op ::= * NOT BETWEEN
1005 expr ::= expr * between_op expr AND expr
1008 expr ::= expr * in_op LP exprlist RP
1009 expr ::= expr * in_op LP select RP
1010 expr ::= expr * in_op nm dbnm
1045 {default} reduce 157
1048 sortlist ::= sortlist COMMA expr * sortorder
1050 sortorder ::= * DESC
1051 (157) sortorder ::= *
1052 expr ::= expr * COLLATE ids
1053 expr ::= expr * AND expr
1054 expr ::= expr * OR expr
1055 expr ::= expr * LT|GT|GE|LE expr
1056 expr ::= expr * EQ|NE expr
1057 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
1058 expr ::= expr * PLUS|MINUS expr
1059 expr ::= expr * STAR|SLASH|REM expr
1060 expr ::= expr * CONCAT expr
1061 likeop ::= * LIKE_KW
1062 likeop ::= * NOT LIKE_KW
1064 likeop ::= * NOT MATCH
1065 expr ::= expr * likeop expr
1066 expr ::= expr * likeop expr ESCAPE expr
1067 expr ::= expr * ISNULL|NOTNULL
1068 expr ::= expr * NOT NULL
1069 expr ::= expr * IS expr
1070 expr ::= expr * IS NOT expr
1071 between_op ::= * BETWEEN
1072 between_op ::= * NOT BETWEEN
1073 expr ::= expr * between_op expr AND expr
1076 expr ::= expr * in_op LP exprlist RP
1077 expr ::= expr * in_op LP select RP
1078 expr ::= expr * in_op nm dbnm
1113 {default} reduce 157
1116 expr ::= expr * COLLATE ids
1117 expr ::= expr * AND expr
1118 expr ::= expr * OR expr
1119 expr ::= expr * LT|GT|GE|LE expr
1120 expr ::= expr * EQ|NE expr
1121 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
1122 expr ::= expr * PLUS|MINUS expr
1123 expr ::= expr * STAR|SLASH|REM expr
1124 expr ::= expr * CONCAT expr
1125 likeop ::= * LIKE_KW
1126 likeop ::= * NOT LIKE_KW
1128 likeop ::= * NOT MATCH
1129 expr ::= expr * likeop expr
1130 expr ::= expr * likeop expr ESCAPE expr
1131 expr ::= expr * ISNULL|NOTNULL
1132 expr ::= expr * NOT NULL
1133 expr ::= expr * IS expr
1134 expr ::= expr * IS NOT expr
1135 between_op ::= * BETWEEN
1136 between_op ::= * NOT BETWEEN
1137 expr ::= expr * between_op expr AND expr
1140 expr ::= expr * in_op LP exprlist RP
1141 expr ::= expr * in_op LP select RP
1142 expr ::= expr * in_op nm dbnm
1143 cmd ::= ATTACH database_kw_opt expr AS expr * key_opt
1145 key_opt ::= * KEY expr
1179 {default} reduce 301
1187 selcollist ::= sclp * expr as
1188 selcollist ::= sclp * STAR
1189 selcollist ::= sclp * nm DOT STAR
1191 expr ::= * LP expr RP
1195 expr ::= * nm DOT nm
1196 expr ::= * nm DOT nm DOT nm
1197 term ::= * INTEGER|FLOAT|BLOB
1201 expr ::= * expr COLLATE ids
1202 expr ::= * CAST LP expr AS typetoken RP
1203 expr ::= * ID LP distinct exprlist RP
1204 expr ::= * ID LP STAR RP
1206 expr ::= * expr AND expr
1207 expr ::= * expr OR expr
1208 expr ::= * expr LT|GT|GE|LE expr
1209 expr ::= * expr EQ|NE expr
1210 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1211 expr ::= * expr PLUS|MINUS expr
1212 expr ::= * expr STAR|SLASH|REM expr
1213 expr ::= * expr CONCAT expr
1214 expr ::= * expr likeop expr
1215 expr ::= * expr likeop expr ESCAPE expr
1216 expr ::= * expr ISNULL|NOTNULL
1217 expr ::= * expr NOT NULL
1218 expr ::= * expr IS expr
1219 expr ::= * expr IS NOT expr
1221 expr ::= * BITNOT expr
1222 expr ::= * MINUS expr
1223 expr ::= * PLUS expr
1224 expr ::= * expr between_op expr AND expr
1225 expr ::= * expr in_op LP exprlist RP
1226 expr ::= * LP select RP
1227 expr ::= * expr in_op LP select RP
1228 expr ::= * expr in_op nm dbnm
1229 expr ::= * EXISTS LP select RP
1230 expr ::= * CASE case_operand case_exprlist case_else END
1231 expr ::= * RAISE LP IGNORE RP
1232 expr ::= * RAISE LP raisetype COMMA nm RP
1267 expr ::= * LP expr RP
1271 expr ::= * nm DOT nm
1272 expr ::= * nm DOT nm DOT nm
1273 term ::= * INTEGER|FLOAT|BLOB
1277 expr ::= * expr COLLATE ids
1278 expr ::= * CAST LP expr AS typetoken RP
1279 expr ::= * ID LP distinct exprlist RP
1280 expr ::= * ID LP STAR RP
1282 expr ::= * expr AND expr
1283 expr ::= * expr OR expr
1284 expr ::= * expr LT|GT|GE|LE expr
1285 expr ::= * expr EQ|NE expr
1286 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1287 expr ::= * expr PLUS|MINUS expr
1288 expr ::= * expr STAR|SLASH|REM expr
1289 expr ::= * expr CONCAT expr
1290 expr ::= * expr likeop expr
1291 expr ::= * expr likeop expr ESCAPE expr
1292 expr ::= * expr ISNULL|NOTNULL
1293 expr ::= * expr NOT NULL
1294 expr ::= * expr IS expr
1295 expr ::= * expr IS NOT expr
1297 expr ::= * BITNOT expr
1298 expr ::= * MINUS expr
1299 expr ::= * PLUS expr
1300 expr ::= * expr between_op expr AND expr
1301 expr ::= * expr in_op LP exprlist RP
1302 expr ::= * LP select RP
1303 expr ::= * expr in_op LP select RP
1304 expr ::= * expr in_op nm dbnm
1305 expr ::= * EXISTS LP select RP
1306 expr ::= * CASE case_operand case_exprlist case_else END
1307 expr ::= * RAISE LP IGNORE RP
1308 expr ::= * RAISE LP raisetype COMMA nm RP
1309 cmd ::= DETACH database_kw_opt * expr
1343 expr ::= * LP expr RP
1347 expr ::= * nm DOT nm
1348 expr ::= * nm DOT nm DOT nm
1349 term ::= * INTEGER|FLOAT|BLOB
1353 expr ::= * expr COLLATE ids
1354 expr ::= * CAST LP expr AS typetoken RP
1355 expr ::= * ID LP distinct exprlist RP
1356 expr ::= * ID LP STAR RP
1358 expr ::= * expr AND expr
1359 expr ::= * expr OR expr
1360 expr ::= * expr LT|GT|GE|LE expr
1361 expr ::= * expr EQ|NE expr
1362 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1363 expr ::= * expr PLUS|MINUS expr
1364 expr ::= * expr STAR|SLASH|REM expr
1365 expr ::= * expr CONCAT expr
1366 expr ::= * expr likeop expr
1367 expr ::= * expr likeop expr ESCAPE expr
1368 expr ::= * expr ISNULL|NOTNULL
1369 expr ::= * expr NOT NULL
1370 expr ::= * expr IS expr
1371 expr ::= * expr IS NOT expr
1373 expr ::= * BITNOT expr
1374 expr ::= * MINUS expr
1375 expr ::= * PLUS expr
1376 expr ::= * expr between_op expr AND expr
1377 expr ::= * expr in_op LP exprlist RP
1378 expr ::= * LP select RP
1379 expr ::= * expr in_op LP select RP
1380 expr ::= * expr in_op nm dbnm
1381 expr ::= * EXISTS LP select RP
1382 expr ::= * CASE case_operand case_exprlist case_else END
1383 expr ::= * RAISE LP IGNORE RP
1384 expr ::= * RAISE LP raisetype COMMA nm RP
1385 key_opt ::= KEY * expr
1419 expr ::= * LP expr RP
1423 expr ::= * nm DOT nm
1424 expr ::= * nm DOT nm DOT nm
1425 term ::= * INTEGER|FLOAT|BLOB
1429 expr ::= * expr COLLATE ids
1430 expr ::= * CAST LP expr AS typetoken RP
1431 expr ::= * ID LP distinct exprlist RP
1432 expr ::= * ID LP STAR RP
1434 expr ::= * expr AND expr
1435 expr ::= * expr OR expr
1436 expr ::= * expr LT|GT|GE|LE expr
1437 expr ::= * expr EQ|NE expr
1438 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1439 expr ::= * expr PLUS|MINUS expr
1440 expr ::= * expr STAR|SLASH|REM expr
1441 expr ::= * expr CONCAT expr
1442 expr ::= * expr likeop expr
1443 expr ::= * expr likeop expr ESCAPE expr
1444 expr ::= * expr ISNULL|NOTNULL
1445 expr ::= * expr NOT NULL
1446 expr ::= * expr IS expr
1447 expr ::= * expr IS NOT expr
1449 expr ::= * BITNOT expr
1450 expr ::= * MINUS expr
1451 expr ::= * PLUS expr
1452 expr ::= * expr between_op expr AND expr
1453 expr ::= * expr in_op LP exprlist RP
1454 expr ::= * LP select RP
1455 expr ::= * expr in_op LP select RP
1456 expr ::= * expr in_op nm dbnm
1457 expr ::= * EXISTS LP select RP
1458 expr ::= * CASE case_operand case_exprlist case_else END
1459 expr ::= * RAISE LP IGNORE RP
1460 expr ::= * RAISE LP raisetype COMMA nm RP
1461 cmd ::= ATTACH database_kw_opt expr AS * expr key_opt
1495 expr ::= * LP expr RP
1499 expr ::= * nm DOT nm
1500 expr ::= * nm DOT nm DOT nm
1501 term ::= * INTEGER|FLOAT|BLOB
1505 expr ::= * expr COLLATE ids
1506 expr ::= * CAST LP expr AS typetoken RP
1507 expr ::= * ID LP distinct exprlist RP
1508 expr ::= * ID LP STAR RP
1510 expr ::= * expr AND expr
1511 expr ::= * expr OR expr
1512 expr ::= * expr LT|GT|GE|LE expr
1513 expr ::= * expr EQ|NE expr
1514 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1515 expr ::= * expr PLUS|MINUS expr
1516 expr ::= * expr STAR|SLASH|REM expr
1517 expr ::= * expr CONCAT expr
1518 expr ::= * expr likeop expr
1519 expr ::= * expr likeop expr ESCAPE expr
1520 expr ::= * expr ISNULL|NOTNULL
1521 expr ::= * expr NOT NULL
1522 expr ::= * expr IS expr
1523 expr ::= * expr IS NOT expr
1525 expr ::= * BITNOT expr
1526 expr ::= * MINUS expr
1527 expr ::= * PLUS expr
1528 expr ::= * expr between_op expr AND expr
1529 expr ::= * expr in_op LP exprlist RP
1530 expr ::= * LP select RP
1531 expr ::= * expr in_op LP select RP
1532 expr ::= * expr in_op nm dbnm
1533 expr ::= * EXISTS LP select RP
1534 expr ::= * CASE case_operand case_exprlist case_else END
1535 expr ::= * RAISE LP IGNORE RP
1536 expr ::= * RAISE LP raisetype COMMA nm RP
1537 cmd ::= ATTACH database_kw_opt * expr AS expr key_opt
1570 setlist ::= nm EQ * expr
1572 expr ::= * LP expr RP
1576 expr ::= * nm DOT nm
1577 expr ::= * nm DOT nm DOT nm
1578 term ::= * INTEGER|FLOAT|BLOB
1582 expr ::= * expr COLLATE ids
1583 expr ::= * CAST LP expr AS typetoken RP
1584 expr ::= * ID LP distinct exprlist RP
1585 expr ::= * ID LP STAR RP
1587 expr ::= * expr AND expr
1588 expr ::= * expr OR expr
1589 expr ::= * expr LT|GT|GE|LE expr
1590 expr ::= * expr EQ|NE expr
1591 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1592 expr ::= * expr PLUS|MINUS expr
1593 expr ::= * expr STAR|SLASH|REM expr
1594 expr ::= * expr CONCAT expr
1595 expr ::= * expr likeop expr
1596 expr ::= * expr likeop expr ESCAPE expr
1597 expr ::= * expr ISNULL|NOTNULL
1598 expr ::= * expr NOT NULL
1599 expr ::= * expr IS expr
1600 expr ::= * expr IS NOT expr
1602 expr ::= * BITNOT expr
1603 expr ::= * MINUS expr
1604 expr ::= * PLUS expr
1605 expr ::= * expr between_op expr AND expr
1606 expr ::= * expr in_op LP exprlist RP
1607 expr ::= * LP select RP
1608 expr ::= * expr in_op LP select RP
1609 expr ::= * expr in_op nm dbnm
1610 expr ::= * EXISTS LP select RP
1611 expr ::= * CASE case_operand case_exprlist case_else END
1612 expr ::= * RAISE LP IGNORE RP
1613 expr ::= * RAISE LP raisetype COMMA nm RP
1646 setlist ::= setlist COMMA nm EQ * expr
1648 expr ::= * LP expr RP
1652 expr ::= * nm DOT nm
1653 expr ::= * nm DOT nm DOT nm
1654 term ::= * INTEGER|FLOAT|BLOB
1658 expr ::= * expr COLLATE ids
1659 expr ::= * CAST LP expr AS typetoken RP
1660 expr ::= * ID LP distinct exprlist RP
1661 expr ::= * ID LP STAR RP
1663 expr ::= * expr AND expr
1664 expr ::= * expr OR expr
1665 expr ::= * expr LT|GT|GE|LE expr
1666 expr ::= * expr EQ|NE expr
1667 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1668 expr ::= * expr PLUS|MINUS expr
1669 expr ::= * expr STAR|SLASH|REM expr
1670 expr ::= * expr CONCAT expr
1671 expr ::= * expr likeop expr
1672 expr ::= * expr likeop expr ESCAPE expr
1673 expr ::= * expr ISNULL|NOTNULL
1674 expr ::= * expr NOT NULL
1675 expr ::= * expr IS expr
1676 expr ::= * expr IS NOT expr
1678 expr ::= * BITNOT expr
1679 expr ::= * MINUS expr
1680 expr ::= * PLUS expr
1681 expr ::= * expr between_op expr AND expr
1682 expr ::= * expr in_op LP exprlist RP
1683 expr ::= * LP select RP
1684 expr ::= * expr in_op LP select RP
1685 expr ::= * expr in_op nm dbnm
1686 expr ::= * EXISTS LP select RP
1687 expr ::= * CASE case_operand case_exprlist case_else END
1688 expr ::= * RAISE LP IGNORE RP
1689 expr ::= * RAISE LP raisetype COMMA nm RP
1723 expr ::= * LP expr RP
1727 expr ::= * nm DOT nm
1728 expr ::= * nm DOT nm DOT nm
1729 term ::= * INTEGER|FLOAT|BLOB
1733 expr ::= * expr COLLATE ids
1734 expr ::= * CAST LP expr AS typetoken RP
1735 expr ::= * ID LP distinct exprlist RP
1736 expr ::= * ID LP STAR RP
1738 expr ::= * expr AND expr
1739 expr ::= * expr OR expr
1740 expr ::= * expr LT|GT|GE|LE expr
1741 expr ::= * expr EQ|NE expr
1742 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1743 expr ::= * expr PLUS|MINUS expr
1744 expr ::= * expr STAR|SLASH|REM expr
1745 expr ::= * expr CONCAT expr
1746 expr ::= * expr likeop expr
1747 expr ::= * expr likeop expr ESCAPE expr
1748 expr ::= * expr ISNULL|NOTNULL
1749 expr ::= * expr NOT NULL
1750 expr ::= * expr IS expr
1751 expr ::= * expr IS NOT expr
1753 expr ::= * BITNOT expr
1754 expr ::= * MINUS expr
1755 expr ::= * PLUS expr
1756 expr ::= * expr between_op expr AND expr
1757 expr ::= * expr in_op LP exprlist RP
1758 expr ::= * LP select RP
1759 expr ::= * expr in_op LP select RP
1760 expr ::= * expr in_op nm dbnm
1761 expr ::= * EXISTS LP select RP
1762 expr ::= * CASE case_operand case_exprlist case_else END
1763 when_clause ::= WHEN * expr
1764 expr ::= * RAISE LP IGNORE RP
1765 expr ::= * RAISE LP raisetype COMMA nm RP
1798 tcons ::= CHECK LP * expr RP onconf
1800 expr ::= * LP expr RP
1804 expr ::= * nm DOT nm
1805 expr ::= * nm DOT nm DOT nm
1806 term ::= * INTEGER|FLOAT|BLOB
1810 expr ::= * expr COLLATE ids
1811 expr ::= * CAST LP expr AS typetoken RP
1812 expr ::= * ID LP distinct exprlist RP
1813 expr ::= * ID LP STAR RP
1815 expr ::= * expr AND expr
1816 expr ::= * expr OR expr
1817 expr ::= * expr LT|GT|GE|LE expr
1818 expr ::= * expr EQ|NE expr
1819 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1820 expr ::= * expr PLUS|MINUS expr
1821 expr ::= * expr STAR|SLASH|REM expr
1822 expr ::= * expr CONCAT expr
1823 expr ::= * expr likeop expr
1824 expr ::= * expr likeop expr ESCAPE expr
1825 expr ::= * expr ISNULL|NOTNULL
1826 expr ::= * expr NOT NULL
1827 expr ::= * expr IS expr
1828 expr ::= * expr IS NOT expr
1830 expr ::= * BITNOT expr
1831 expr ::= * MINUS expr
1832 expr ::= * PLUS expr
1833 expr ::= * expr between_op expr AND expr
1834 expr ::= * expr in_op LP exprlist RP
1835 expr ::= * LP select RP
1836 expr ::= * expr in_op LP select RP
1837 expr ::= * expr in_op nm dbnm
1838 expr ::= * EXISTS LP select RP
1839 expr ::= * CASE case_operand case_exprlist case_else END
1840 expr ::= * RAISE LP IGNORE RP
1841 expr ::= * RAISE LP raisetype COMMA nm RP
1874 ccons ::= CHECK LP * expr RP
1876 expr ::= * LP expr RP
1880 expr ::= * nm DOT nm
1881 expr ::= * nm DOT nm DOT nm
1882 term ::= * INTEGER|FLOAT|BLOB
1886 expr ::= * expr COLLATE ids
1887 expr ::= * CAST LP expr AS typetoken RP
1888 expr ::= * ID LP distinct exprlist RP
1889 expr ::= * ID LP STAR RP
1891 expr ::= * expr AND expr
1892 expr ::= * expr OR expr
1893 expr ::= * expr LT|GT|GE|LE expr
1894 expr ::= * expr EQ|NE expr
1895 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1896 expr ::= * expr PLUS|MINUS expr
1897 expr ::= * expr STAR|SLASH|REM expr
1898 expr ::= * expr CONCAT expr
1899 expr ::= * expr likeop expr
1900 expr ::= * expr likeop expr ESCAPE expr
1901 expr ::= * expr ISNULL|NOTNULL
1902 expr ::= * expr NOT NULL
1903 expr ::= * expr IS expr
1904 expr ::= * expr IS NOT expr
1906 expr ::= * BITNOT expr
1907 expr ::= * MINUS expr
1908 expr ::= * PLUS expr
1909 expr ::= * expr between_op expr AND expr
1910 expr ::= * expr in_op LP exprlist RP
1911 expr ::= * LP select RP
1912 expr ::= * expr in_op LP select RP
1913 expr ::= * expr in_op nm dbnm
1914 expr ::= * EXISTS LP select RP
1915 expr ::= * CASE case_operand case_exprlist case_else END
1916 expr ::= * RAISE LP IGNORE RP
1917 expr ::= * RAISE LP raisetype COMMA nm RP
1950 on_opt ::= ON * expr
1952 expr ::= * LP expr RP
1956 expr ::= * nm DOT nm
1957 expr ::= * nm DOT nm DOT nm
1958 term ::= * INTEGER|FLOAT|BLOB
1962 expr ::= * expr COLLATE ids
1963 expr ::= * CAST LP expr AS typetoken RP
1964 expr ::= * ID LP distinct exprlist RP
1965 expr ::= * ID LP STAR RP
1967 expr ::= * expr AND expr
1968 expr ::= * expr OR expr
1969 expr ::= * expr LT|GT|GE|LE expr
1970 expr ::= * expr EQ|NE expr
1971 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
1972 expr ::= * expr PLUS|MINUS expr
1973 expr ::= * expr STAR|SLASH|REM expr
1974 expr ::= * expr CONCAT expr
1975 expr ::= * expr likeop expr
1976 expr ::= * expr likeop expr ESCAPE expr
1977 expr ::= * expr ISNULL|NOTNULL
1978 expr ::= * expr NOT NULL
1979 expr ::= * expr IS expr
1980 expr ::= * expr IS NOT expr
1982 expr ::= * BITNOT expr
1983 expr ::= * MINUS expr
1984 expr ::= * PLUS expr
1985 expr ::= * expr between_op expr AND expr
1986 expr ::= * expr in_op LP exprlist RP
1987 expr ::= * LP select RP
1988 expr ::= * expr in_op LP select RP
1989 expr ::= * expr in_op nm dbnm
1990 expr ::= * EXISTS LP select RP
1991 expr ::= * CASE case_operand case_exprlist case_else END
1992 expr ::= * RAISE LP IGNORE RP
1993 expr ::= * RAISE LP raisetype COMMA nm RP
2026 where_opt ::= WHERE * expr
2028 expr ::= * LP expr RP
2032 expr ::= * nm DOT nm
2033 expr ::= * nm DOT nm DOT nm
2034 term ::= * INTEGER|FLOAT|BLOB
2038 expr ::= * expr COLLATE ids
2039 expr ::= * CAST LP expr AS typetoken RP
2040 expr ::= * ID LP distinct exprlist RP
2041 expr ::= * ID LP STAR RP
2043 expr ::= * expr AND expr
2044 expr ::= * expr OR expr
2045 expr ::= * expr LT|GT|GE|LE expr
2046 expr ::= * expr EQ|NE expr
2047 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2048 expr ::= * expr PLUS|MINUS expr
2049 expr ::= * expr STAR|SLASH|REM expr
2050 expr ::= * expr CONCAT expr
2051 expr ::= * expr likeop expr
2052 expr ::= * expr likeop expr ESCAPE expr
2053 expr ::= * expr ISNULL|NOTNULL
2054 expr ::= * expr NOT NULL
2055 expr ::= * expr IS expr
2056 expr ::= * expr IS NOT expr
2058 expr ::= * BITNOT expr
2059 expr ::= * MINUS expr
2060 expr ::= * PLUS expr
2061 expr ::= * expr between_op expr AND expr
2062 expr ::= * expr in_op LP exprlist RP
2063 expr ::= * LP select RP
2064 expr ::= * expr in_op LP select RP
2065 expr ::= * expr in_op nm dbnm
2066 expr ::= * EXISTS LP select RP
2067 expr ::= * CASE case_operand case_exprlist case_else END
2068 expr ::= * RAISE LP IGNORE RP
2069 expr ::= * RAISE LP raisetype COMMA nm RP
2102 having_opt ::= HAVING * expr
2104 expr ::= * LP expr RP
2108 expr ::= * nm DOT nm
2109 expr ::= * nm DOT nm DOT nm
2110 term ::= * INTEGER|FLOAT|BLOB
2114 expr ::= * expr COLLATE ids
2115 expr ::= * CAST LP expr AS typetoken RP
2116 expr ::= * ID LP distinct exprlist RP
2117 expr ::= * ID LP STAR RP
2119 expr ::= * expr AND expr
2120 expr ::= * expr OR expr
2121 expr ::= * expr LT|GT|GE|LE expr
2122 expr ::= * expr EQ|NE expr
2123 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2124 expr ::= * expr PLUS|MINUS expr
2125 expr ::= * expr STAR|SLASH|REM expr
2126 expr ::= * expr CONCAT expr
2127 expr ::= * expr likeop expr
2128 expr ::= * expr likeop expr ESCAPE expr
2129 expr ::= * expr ISNULL|NOTNULL
2130 expr ::= * expr NOT NULL
2131 expr ::= * expr IS expr
2132 expr ::= * expr IS NOT expr
2134 expr ::= * BITNOT expr
2135 expr ::= * MINUS expr
2136 expr ::= * PLUS expr
2137 expr ::= * expr between_op expr AND expr
2138 expr ::= * expr in_op LP exprlist RP
2139 expr ::= * LP select RP
2140 expr ::= * expr in_op LP select RP
2141 expr ::= * expr in_op nm dbnm
2142 expr ::= * EXISTS LP select RP
2143 expr ::= * CASE case_operand case_exprlist case_else END
2144 expr ::= * RAISE LP IGNORE RP
2145 expr ::= * RAISE LP raisetype COMMA nm RP
2178 sortlist ::= sortlist COMMA * expr sortorder
2180 expr ::= * LP expr RP
2184 expr ::= * nm DOT nm
2185 expr ::= * nm DOT nm DOT nm
2186 term ::= * INTEGER|FLOAT|BLOB
2190 expr ::= * expr COLLATE ids
2191 expr ::= * CAST LP expr AS typetoken RP
2192 expr ::= * ID LP distinct exprlist RP
2193 expr ::= * ID LP STAR RP
2195 expr ::= * expr AND expr
2196 expr ::= * expr OR expr
2197 expr ::= * expr LT|GT|GE|LE expr
2198 expr ::= * expr EQ|NE expr
2199 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2200 expr ::= * expr PLUS|MINUS expr
2201 expr ::= * expr STAR|SLASH|REM expr
2202 expr ::= * expr CONCAT expr
2203 expr ::= * expr likeop expr
2204 expr ::= * expr likeop expr ESCAPE expr
2205 expr ::= * expr ISNULL|NOTNULL
2206 expr ::= * expr NOT NULL
2207 expr ::= * expr IS expr
2208 expr ::= * expr IS NOT expr
2210 expr ::= * BITNOT expr
2211 expr ::= * MINUS expr
2212 expr ::= * PLUS expr
2213 expr ::= * expr between_op expr AND expr
2214 expr ::= * expr in_op LP exprlist RP
2215 expr ::= * LP select RP
2216 expr ::= * expr in_op LP select RP
2217 expr ::= * expr in_op nm dbnm
2218 expr ::= * EXISTS LP select RP
2219 expr ::= * CASE case_operand case_exprlist case_else END
2220 expr ::= * RAISE LP IGNORE RP
2221 expr ::= * RAISE LP raisetype COMMA nm RP
2254 limit_opt ::= LIMIT expr COMMA * expr
2256 expr ::= * LP expr RP
2260 expr ::= * nm DOT nm
2261 expr ::= * nm DOT nm DOT nm
2262 term ::= * INTEGER|FLOAT|BLOB
2266 expr ::= * expr COLLATE ids
2267 expr ::= * CAST LP expr AS typetoken RP
2268 expr ::= * ID LP distinct exprlist RP
2269 expr ::= * ID LP STAR RP
2271 expr ::= * expr AND expr
2272 expr ::= * expr OR expr
2273 expr ::= * expr LT|GT|GE|LE expr
2274 expr ::= * expr EQ|NE expr
2275 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2276 expr ::= * expr PLUS|MINUS expr
2277 expr ::= * expr STAR|SLASH|REM expr
2278 expr ::= * expr CONCAT expr
2279 expr ::= * expr likeop expr
2280 expr ::= * expr likeop expr ESCAPE expr
2281 expr ::= * expr ISNULL|NOTNULL
2282 expr ::= * expr NOT NULL
2283 expr ::= * expr IS expr
2284 expr ::= * expr IS NOT expr
2286 expr ::= * BITNOT expr
2287 expr ::= * MINUS expr
2288 expr ::= * PLUS expr
2289 expr ::= * expr between_op expr AND expr
2290 expr ::= * expr in_op LP exprlist RP
2291 expr ::= * LP select RP
2292 expr ::= * expr in_op LP select RP
2293 expr ::= * expr in_op nm dbnm
2294 expr ::= * EXISTS LP select RP
2295 expr ::= * CASE case_operand case_exprlist case_else END
2296 expr ::= * RAISE LP IGNORE RP
2297 expr ::= * RAISE LP raisetype COMMA nm RP
2331 expr ::= * LP expr RP
2335 expr ::= * nm DOT nm
2336 expr ::= * nm DOT nm DOT nm
2337 term ::= * INTEGER|FLOAT|BLOB
2341 expr ::= * expr COLLATE ids
2342 expr ::= * CAST LP expr AS typetoken RP
2343 expr ::= * ID LP distinct exprlist RP
2344 expr ::= * ID LP STAR RP
2346 expr ::= * expr AND expr
2347 expr ::= * expr OR expr
2348 expr ::= * expr LT|GT|GE|LE expr
2349 expr ::= * expr EQ|NE expr
2350 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2351 expr ::= * expr PLUS|MINUS expr
2352 expr ::= * expr STAR|SLASH|REM expr
2353 expr ::= * expr CONCAT expr
2354 expr ::= * expr likeop expr
2355 expr ::= * expr likeop expr ESCAPE expr
2356 expr ::= * expr ISNULL|NOTNULL
2357 expr ::= * expr NOT NULL
2358 expr ::= * expr IS expr
2359 expr ::= * expr IS NOT expr
2360 expr ::= expr IS NOT * expr
2363 expr ::= * BITNOT expr
2364 expr ::= * MINUS expr
2365 expr ::= * PLUS expr
2366 expr ::= * expr between_op expr AND expr
2367 expr ::= * expr in_op LP exprlist RP
2368 expr ::= * LP select RP
2369 expr ::= * expr in_op LP select RP
2370 expr ::= * expr in_op nm dbnm
2371 expr ::= * EXISTS LP select RP
2372 expr ::= * CASE case_operand case_exprlist case_else END
2373 expr ::= * RAISE LP IGNORE RP
2374 expr ::= * RAISE LP raisetype COMMA nm RP
2408 expr ::= * LP expr RP
2412 expr ::= * nm DOT nm
2413 expr ::= * nm DOT nm DOT nm
2414 term ::= * INTEGER|FLOAT|BLOB
2418 expr ::= * expr COLLATE ids
2419 expr ::= * CAST LP expr AS typetoken RP
2420 expr ::= * ID LP distinct exprlist RP
2421 expr ::= * ID LP STAR RP
2423 expr ::= * expr AND expr
2424 expr ::= * expr OR expr
2425 expr ::= * expr LT|GT|GE|LE expr
2426 expr ::= * expr EQ|NE expr
2427 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2428 expr ::= * expr PLUS|MINUS expr
2429 expr ::= * expr STAR|SLASH|REM expr
2430 expr ::= * expr CONCAT expr
2431 expr ::= * expr likeop expr
2432 expr ::= * expr likeop expr ESCAPE expr
2433 expr ::= * expr ISNULL|NOTNULL
2434 expr ::= * expr NOT NULL
2435 expr ::= * expr IS expr
2436 expr ::= * expr IS NOT expr
2438 expr ::= * BITNOT expr
2439 expr ::= * MINUS expr
2440 expr ::= * PLUS expr
2441 expr ::= * expr between_op expr AND expr
2442 expr ::= * expr in_op LP exprlist RP
2443 expr ::= * LP select RP
2444 expr ::= * expr in_op LP select RP
2445 expr ::= * expr in_op nm dbnm
2446 expr ::= * EXISTS LP select RP
2447 expr ::= * CASE case_operand case_exprlist case_else END
2448 nexprlist ::= nexprlist COMMA * expr
2449 expr ::= * RAISE LP IGNORE RP
2450 expr ::= * RAISE LP raisetype COMMA nm RP
2484 expr ::= * LP expr RP
2488 expr ::= * nm DOT nm
2489 expr ::= * nm DOT nm DOT nm
2490 term ::= * INTEGER|FLOAT|BLOB
2494 expr ::= * expr COLLATE ids
2495 expr ::= * CAST LP expr AS typetoken RP
2496 expr ::= * ID LP distinct exprlist RP
2497 expr ::= * ID LP STAR RP
2499 expr ::= * expr AND expr
2500 expr ::= * expr OR expr
2501 expr ::= * expr LT|GT|GE|LE expr
2502 expr ::= * expr EQ|NE expr
2503 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2504 expr ::= * expr PLUS|MINUS expr
2505 expr ::= * expr STAR|SLASH|REM expr
2506 expr ::= * expr CONCAT expr
2507 expr ::= * expr likeop expr
2508 expr ::= * expr likeop expr ESCAPE expr
2509 expr ::= * expr ISNULL|NOTNULL
2510 expr ::= * expr NOT NULL
2511 expr ::= * expr IS expr
2512 expr ::= * expr IS NOT expr
2514 expr ::= * BITNOT expr
2515 expr ::= * MINUS expr
2516 expr ::= * PLUS expr
2517 expr ::= * expr between_op expr AND expr
2518 expr ::= * expr in_op LP exprlist RP
2519 expr ::= * LP select RP
2520 expr ::= * expr in_op LP select RP
2521 expr ::= * expr in_op nm dbnm
2522 expr ::= * EXISTS LP select RP
2523 expr ::= * CASE case_operand case_exprlist case_else END
2524 case_exprlist ::= WHEN expr THEN * expr
2525 expr ::= * RAISE LP IGNORE RP
2526 expr ::= * RAISE LP raisetype COMMA nm RP
2560 expr ::= * LP expr RP
2564 expr ::= * nm DOT nm
2565 expr ::= * nm DOT nm DOT nm
2566 term ::= * INTEGER|FLOAT|BLOB
2570 expr ::= * expr COLLATE ids
2571 expr ::= * CAST LP expr AS typetoken RP
2572 expr ::= * ID LP distinct exprlist RP
2573 expr ::= * ID LP STAR RP
2575 expr ::= * expr AND expr
2576 expr ::= * expr OR expr
2577 expr ::= * expr LT|GT|GE|LE expr
2578 expr ::= * expr EQ|NE expr
2579 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2580 expr ::= * expr PLUS|MINUS expr
2581 expr ::= * expr STAR|SLASH|REM expr
2582 expr ::= * expr CONCAT expr
2583 expr ::= * expr likeop expr
2584 expr ::= * expr likeop expr ESCAPE expr
2585 expr ::= * expr ISNULL|NOTNULL
2586 expr ::= * expr NOT NULL
2587 expr ::= * expr IS expr
2588 expr ::= * expr IS NOT expr
2590 expr ::= * BITNOT expr
2591 expr ::= * MINUS expr
2592 expr ::= * PLUS expr
2593 expr ::= * expr between_op expr AND expr
2594 expr ::= * expr in_op LP exprlist RP
2595 expr ::= * LP select RP
2596 expr ::= * expr in_op LP select RP
2597 expr ::= * expr in_op nm dbnm
2598 expr ::= * EXISTS LP select RP
2599 expr ::= * CASE case_operand case_exprlist case_else END
2600 case_exprlist ::= WHEN * expr THEN expr
2601 expr ::= * RAISE LP IGNORE RP
2602 expr ::= * RAISE LP raisetype COMMA nm RP
2636 expr ::= * LP expr RP
2640 expr ::= * nm DOT nm
2641 expr ::= * nm DOT nm DOT nm
2642 term ::= * INTEGER|FLOAT|BLOB
2646 expr ::= * expr COLLATE ids
2647 expr ::= * CAST LP expr AS typetoken RP
2648 expr ::= * ID LP distinct exprlist RP
2649 expr ::= * ID LP STAR RP
2651 expr ::= * expr AND expr
2652 expr ::= * expr OR expr
2653 expr ::= * expr LT|GT|GE|LE expr
2654 expr ::= * expr EQ|NE expr
2655 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2656 expr ::= * expr PLUS|MINUS expr
2657 expr ::= * expr STAR|SLASH|REM expr
2658 expr ::= * expr CONCAT expr
2659 expr ::= * expr likeop expr
2660 expr ::= * expr likeop expr ESCAPE expr
2661 expr ::= * expr ISNULL|NOTNULL
2662 expr ::= * expr NOT NULL
2663 expr ::= * expr IS expr
2664 expr ::= * expr IS NOT expr
2666 expr ::= * BITNOT expr
2667 expr ::= * MINUS expr
2668 expr ::= * PLUS expr
2669 expr ::= * expr between_op expr AND expr
2670 expr ::= * expr in_op LP exprlist RP
2671 expr ::= * LP select RP
2672 expr ::= * expr in_op LP select RP
2673 expr ::= * expr in_op nm dbnm
2674 expr ::= * EXISTS LP select RP
2675 expr ::= * CASE case_operand case_exprlist case_else END
2676 case_else ::= ELSE * expr
2677 expr ::= * RAISE LP IGNORE RP
2678 expr ::= * RAISE LP raisetype COMMA nm RP
2712 expr ::= * LP expr RP
2716 expr ::= * nm DOT nm
2717 expr ::= * nm DOT nm DOT nm
2718 term ::= * INTEGER|FLOAT|BLOB
2722 expr ::= * expr COLLATE ids
2723 expr ::= * CAST LP expr AS typetoken RP
2724 expr ::= * ID LP distinct exprlist RP
2725 expr ::= * ID LP STAR RP
2727 expr ::= * expr AND expr
2728 expr ::= * expr OR expr
2729 expr ::= * expr LT|GT|GE|LE expr
2730 expr ::= * expr EQ|NE expr
2731 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2732 expr ::= * expr PLUS|MINUS expr
2733 expr ::= * expr STAR|SLASH|REM expr
2734 expr ::= * expr CONCAT expr
2735 expr ::= * expr likeop expr
2736 expr ::= * expr likeop expr ESCAPE expr
2737 expr ::= * expr ISNULL|NOTNULL
2738 expr ::= * expr NOT NULL
2739 expr ::= * expr IS expr
2740 expr ::= * expr IS NOT expr
2742 expr ::= * BITNOT expr
2743 expr ::= * MINUS expr
2744 expr ::= * PLUS expr
2745 expr ::= * expr between_op expr AND expr
2746 expr ::= * expr in_op LP exprlist RP
2747 expr ::= * LP select RP
2748 expr ::= * expr in_op LP select RP
2749 expr ::= * expr in_op nm dbnm
2750 expr ::= * EXISTS LP select RP
2751 expr ::= * CASE case_operand case_exprlist case_else END
2752 case_exprlist ::= case_exprlist WHEN expr THEN * expr
2753 expr ::= * RAISE LP IGNORE RP
2754 expr ::= * RAISE LP raisetype COMMA nm RP
2788 expr ::= * LP expr RP
2792 expr ::= * nm DOT nm
2793 expr ::= * nm DOT nm DOT nm
2794 term ::= * INTEGER|FLOAT|BLOB
2798 expr ::= * expr COLLATE ids
2799 expr ::= * CAST LP expr AS typetoken RP
2800 expr ::= * ID LP distinct exprlist RP
2801 expr ::= * ID LP STAR RP
2803 expr ::= * expr AND expr
2804 expr ::= * expr OR expr
2805 expr ::= * expr LT|GT|GE|LE expr
2806 expr ::= * expr EQ|NE expr
2807 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2808 expr ::= * expr PLUS|MINUS expr
2809 expr ::= * expr STAR|SLASH|REM expr
2810 expr ::= * expr CONCAT expr
2811 expr ::= * expr likeop expr
2812 expr ::= * expr likeop expr ESCAPE expr
2813 expr ::= * expr ISNULL|NOTNULL
2814 expr ::= * expr NOT NULL
2815 expr ::= * expr IS expr
2816 expr ::= * expr IS NOT expr
2818 expr ::= * BITNOT expr
2819 expr ::= * MINUS expr
2820 expr ::= * PLUS expr
2821 expr ::= * expr between_op expr AND expr
2822 expr ::= * expr in_op LP exprlist RP
2823 expr ::= * LP select RP
2824 expr ::= * expr in_op LP select RP
2825 expr ::= * expr in_op nm dbnm
2826 expr ::= * EXISTS LP select RP
2827 expr ::= * CASE case_operand case_exprlist case_else END
2828 case_exprlist ::= case_exprlist WHEN * expr THEN expr
2829 expr ::= * RAISE LP IGNORE RP
2830 expr ::= * RAISE LP raisetype COMMA nm RP
2864 expr ::= * LP expr RP
2868 expr ::= * nm DOT nm
2869 expr ::= * nm DOT nm DOT nm
2870 term ::= * INTEGER|FLOAT|BLOB
2874 expr ::= * expr COLLATE ids
2875 expr ::= * CAST LP expr AS typetoken RP
2876 expr ::= * ID LP distinct exprlist RP
2877 expr ::= * ID LP STAR RP
2879 expr ::= * expr AND expr
2880 expr ::= * expr OR expr
2881 expr ::= * expr LT|GT|GE|LE expr
2882 expr ::= * expr EQ|NE expr
2883 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2884 expr ::= * expr PLUS|MINUS expr
2885 expr ::= * expr STAR|SLASH|REM expr
2886 expr ::= * expr CONCAT expr
2887 expr ::= * expr likeop expr
2888 expr ::= * expr likeop expr ESCAPE expr
2889 expr ::= * expr ISNULL|NOTNULL
2890 expr ::= * expr NOT NULL
2891 expr ::= * expr IS expr
2892 expr ::= * expr IS NOT expr
2894 expr ::= * BITNOT expr
2895 expr ::= * MINUS expr
2896 expr ::= * PLUS expr
2897 expr ::= PLUS * expr
2898 expr ::= * expr between_op expr AND expr
2899 expr ::= * expr in_op LP exprlist RP
2900 expr ::= * LP select RP
2901 expr ::= * expr in_op LP select RP
2902 expr ::= * expr in_op nm dbnm
2903 expr ::= * EXISTS LP select RP
2904 expr ::= * CASE case_operand case_exprlist case_else END
2905 expr ::= * RAISE LP IGNORE RP
2906 expr ::= * RAISE LP raisetype COMMA nm RP
2940 expr ::= * LP expr RP
2944 expr ::= * nm DOT nm
2945 expr ::= * nm DOT nm DOT nm
2946 term ::= * INTEGER|FLOAT|BLOB
2950 expr ::= * expr COLLATE ids
2951 expr ::= * CAST LP expr AS typetoken RP
2952 expr ::= * ID LP distinct exprlist RP
2953 expr ::= * ID LP STAR RP
2955 expr ::= * expr AND expr
2956 expr ::= * expr OR expr
2957 expr ::= * expr LT|GT|GE|LE expr
2958 expr ::= * expr EQ|NE expr
2959 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
2960 expr ::= * expr PLUS|MINUS expr
2961 expr ::= * expr STAR|SLASH|REM expr
2962 expr ::= * expr CONCAT expr
2963 expr ::= * expr likeop expr
2964 expr ::= * expr likeop expr ESCAPE expr
2965 expr ::= * expr ISNULL|NOTNULL
2966 expr ::= * expr NOT NULL
2967 expr ::= * expr IS expr
2968 expr ::= * expr IS NOT expr
2970 expr ::= * BITNOT expr
2971 expr ::= * MINUS expr
2972 expr ::= MINUS * expr
2973 expr ::= * PLUS expr
2974 expr ::= * expr between_op expr AND expr
2975 expr ::= * expr in_op LP exprlist RP
2976 expr ::= * LP select RP
2977 expr ::= * expr in_op LP select RP
2978 expr ::= * expr in_op nm dbnm
2979 expr ::= * EXISTS LP select RP
2980 expr ::= * CASE case_operand case_exprlist case_else END
2981 expr ::= * RAISE LP IGNORE RP
2982 expr ::= * RAISE LP raisetype COMMA nm RP
3016 expr ::= * LP expr RP
3020 expr ::= * nm DOT nm
3021 expr ::= * nm DOT nm DOT nm
3022 term ::= * INTEGER|FLOAT|BLOB
3026 expr ::= * expr COLLATE ids
3027 expr ::= * CAST LP expr AS typetoken RP
3028 expr ::= * ID LP distinct exprlist RP
3029 expr ::= * ID LP STAR RP
3031 expr ::= * expr AND expr
3032 expr ::= * expr OR expr
3033 expr ::= * expr LT|GT|GE|LE expr
3034 expr ::= * expr EQ|NE expr
3035 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3036 expr ::= * expr PLUS|MINUS expr
3037 expr ::= * expr STAR|SLASH|REM expr
3038 expr ::= * expr CONCAT expr
3039 expr ::= * expr likeop expr
3040 expr ::= * expr likeop expr ESCAPE expr
3041 expr ::= * expr ISNULL|NOTNULL
3042 expr ::= * expr NOT NULL
3043 expr ::= * expr IS expr
3044 expr ::= * expr IS NOT expr
3046 expr ::= * BITNOT expr
3047 expr ::= BITNOT * expr
3048 expr ::= * MINUS expr
3049 expr ::= * PLUS expr
3050 expr ::= * expr between_op expr AND expr
3051 expr ::= * expr in_op LP exprlist RP
3052 expr ::= * LP select RP
3053 expr ::= * expr in_op LP select RP
3054 expr ::= * expr in_op nm dbnm
3055 expr ::= * EXISTS LP select RP
3056 expr ::= * CASE case_operand case_exprlist case_else END
3057 expr ::= * RAISE LP IGNORE RP
3058 expr ::= * RAISE LP raisetype COMMA nm RP
3092 expr ::= * LP expr RP
3096 expr ::= * nm DOT nm
3097 expr ::= * nm DOT nm DOT nm
3098 term ::= * INTEGER|FLOAT|BLOB
3102 expr ::= * expr COLLATE ids
3103 expr ::= * CAST LP expr AS typetoken RP
3104 expr ::= * ID LP distinct exprlist RP
3105 expr ::= * ID LP STAR RP
3107 expr ::= * expr AND expr
3108 expr ::= * expr OR expr
3109 expr ::= * expr LT|GT|GE|LE expr
3110 expr ::= * expr EQ|NE expr
3111 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3112 expr ::= * expr PLUS|MINUS expr
3113 expr ::= * expr STAR|SLASH|REM expr
3114 expr ::= * expr CONCAT expr
3115 expr ::= * expr likeop expr
3116 expr ::= * expr likeop expr ESCAPE expr
3117 expr ::= * expr ISNULL|NOTNULL
3118 expr ::= * expr NOT NULL
3119 expr ::= * expr IS expr
3120 expr ::= * expr IS NOT expr
3123 expr ::= * BITNOT expr
3124 expr ::= * MINUS expr
3125 expr ::= * PLUS expr
3126 expr ::= * expr between_op expr AND expr
3127 expr ::= * expr in_op LP exprlist RP
3128 expr ::= * LP select RP
3129 expr ::= * expr in_op LP select RP
3130 expr ::= * expr in_op nm dbnm
3131 expr ::= * EXISTS LP select RP
3132 expr ::= * CASE case_operand case_exprlist case_else END
3133 expr ::= * RAISE LP IGNORE RP
3134 expr ::= * RAISE LP raisetype COMMA nm RP
3168 expr ::= * LP expr RP
3172 expr ::= * nm DOT nm
3173 expr ::= * nm DOT nm DOT nm
3174 term ::= * INTEGER|FLOAT|BLOB
3178 expr ::= * expr COLLATE ids
3179 expr ::= * CAST LP expr AS typetoken RP
3180 expr ::= CAST LP * expr AS typetoken RP
3181 expr ::= * ID LP distinct exprlist RP
3182 expr ::= * ID LP STAR RP
3184 expr ::= * expr AND expr
3185 expr ::= * expr OR expr
3186 expr ::= * expr LT|GT|GE|LE expr
3187 expr ::= * expr EQ|NE expr
3188 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3189 expr ::= * expr PLUS|MINUS expr
3190 expr ::= * expr STAR|SLASH|REM expr
3191 expr ::= * expr CONCAT expr
3192 expr ::= * expr likeop expr
3193 expr ::= * expr likeop expr ESCAPE expr
3194 expr ::= * expr ISNULL|NOTNULL
3195 expr ::= * expr NOT NULL
3196 expr ::= * expr IS expr
3197 expr ::= * expr IS NOT expr
3199 expr ::= * BITNOT expr
3200 expr ::= * MINUS expr
3201 expr ::= * PLUS expr
3202 expr ::= * expr between_op expr AND expr
3203 expr ::= * expr in_op LP exprlist RP
3204 expr ::= * LP select RP
3205 expr ::= * expr in_op LP select RP
3206 expr ::= * expr in_op nm dbnm
3207 expr ::= * EXISTS LP select RP
3208 expr ::= * CASE case_operand case_exprlist case_else END
3209 expr ::= * RAISE LP IGNORE RP
3210 expr ::= * RAISE LP raisetype COMMA nm RP
3244 expr ::= * LP expr RP
3248 expr ::= * nm DOT nm
3249 expr ::= * nm DOT nm DOT nm
3250 term ::= * INTEGER|FLOAT|BLOB
3254 expr ::= * expr COLLATE ids
3255 expr ::= * CAST LP expr AS typetoken RP
3256 expr ::= * ID LP distinct exprlist RP
3257 expr ::= * ID LP STAR RP
3259 expr ::= * expr AND expr
3260 expr ::= expr AND * expr
3261 expr ::= * expr OR expr
3262 expr ::= * expr LT|GT|GE|LE expr
3263 expr ::= * expr EQ|NE expr
3264 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3265 expr ::= * expr PLUS|MINUS expr
3266 expr ::= * expr STAR|SLASH|REM expr
3267 expr ::= * expr CONCAT expr
3268 expr ::= * expr likeop expr
3269 expr ::= * expr likeop expr ESCAPE expr
3270 expr ::= * expr ISNULL|NOTNULL
3271 expr ::= * expr NOT NULL
3272 expr ::= * expr IS expr
3273 expr ::= * expr IS NOT expr
3275 expr ::= * BITNOT expr
3276 expr ::= * MINUS expr
3277 expr ::= * PLUS expr
3278 expr ::= * expr between_op expr AND expr
3279 expr ::= expr between_op expr AND * expr
3280 expr ::= * expr in_op LP exprlist RP
3281 expr ::= * LP select RP
3282 expr ::= * expr in_op LP select RP
3283 expr ::= * expr in_op nm dbnm
3284 expr ::= * EXISTS LP select RP
3285 expr ::= * CASE case_operand case_exprlist case_else END
3286 expr ::= * RAISE LP IGNORE RP
3287 expr ::= * RAISE LP raisetype COMMA nm RP
3321 expr ::= * LP expr RP
3325 expr ::= * nm DOT nm
3326 expr ::= * nm DOT nm DOT nm
3327 term ::= * INTEGER|FLOAT|BLOB
3331 expr ::= * expr COLLATE ids
3332 expr ::= * CAST LP expr AS typetoken RP
3333 expr ::= * ID LP distinct exprlist RP
3334 expr ::= * ID LP STAR RP
3336 expr ::= * expr AND expr
3337 expr ::= * expr OR expr
3338 expr ::= * expr LT|GT|GE|LE expr
3339 expr ::= * expr EQ|NE expr
3340 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3341 expr ::= * expr PLUS|MINUS expr
3342 expr ::= * expr STAR|SLASH|REM expr
3343 expr ::= * expr CONCAT expr
3344 expr ::= * expr likeop expr
3345 expr ::= * expr likeop expr ESCAPE expr
3346 expr ::= * expr ISNULL|NOTNULL
3347 expr ::= * expr NOT NULL
3348 expr ::= * expr IS expr
3349 expr ::= * expr IS NOT expr
3351 expr ::= * BITNOT expr
3352 expr ::= * MINUS expr
3353 expr ::= * PLUS expr
3354 expr ::= * expr between_op expr AND expr
3355 expr ::= expr between_op * expr AND expr
3356 expr ::= * expr in_op LP exprlist RP
3357 expr ::= * LP select RP
3358 expr ::= * expr in_op LP select RP
3359 expr ::= * expr in_op nm dbnm
3360 expr ::= * EXISTS LP select RP
3361 expr ::= * CASE case_operand case_exprlist case_else END
3362 expr ::= * RAISE LP IGNORE RP
3363 expr ::= * RAISE LP raisetype COMMA nm RP
3397 expr ::= * LP expr RP
3401 expr ::= * nm DOT nm
3402 expr ::= * nm DOT nm DOT nm
3403 term ::= * INTEGER|FLOAT|BLOB
3407 expr ::= * expr COLLATE ids
3408 expr ::= * CAST LP expr AS typetoken RP
3409 expr ::= * ID LP distinct exprlist RP
3410 expr ::= * ID LP STAR RP
3412 expr ::= * expr AND expr
3413 expr ::= * expr OR expr
3414 expr ::= * expr LT|GT|GE|LE expr
3415 expr ::= * expr EQ|NE expr
3416 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3417 expr ::= * expr PLUS|MINUS expr
3418 expr ::= * expr STAR|SLASH|REM expr
3419 expr ::= * expr CONCAT expr
3420 expr ::= * expr likeop expr
3421 expr ::= * expr likeop expr ESCAPE expr
3422 expr ::= * expr ISNULL|NOTNULL
3423 expr ::= * expr NOT NULL
3424 expr ::= * expr IS expr
3425 expr ::= expr IS * expr
3426 expr ::= * expr IS NOT expr
3427 expr ::= expr IS * NOT expr
3429 expr ::= * BITNOT expr
3430 expr ::= * MINUS expr
3431 expr ::= * PLUS expr
3432 expr ::= * expr between_op expr AND expr
3433 expr ::= * expr in_op LP exprlist RP
3434 expr ::= * LP select RP
3435 expr ::= * expr in_op LP select RP
3436 expr ::= * expr in_op nm dbnm
3437 expr ::= * EXISTS LP select RP
3438 expr ::= * CASE case_operand case_exprlist case_else END
3439 expr ::= * RAISE LP IGNORE RP
3440 expr ::= * RAISE LP raisetype COMMA nm RP
3474 expr ::= * LP expr RP
3478 expr ::= * nm DOT nm
3479 expr ::= * nm DOT nm DOT nm
3480 term ::= * INTEGER|FLOAT|BLOB
3484 expr ::= * expr COLLATE ids
3485 expr ::= * CAST LP expr AS typetoken RP
3486 expr ::= * ID LP distinct exprlist RP
3487 expr ::= * ID LP STAR RP
3489 expr ::= * expr AND expr
3490 expr ::= * expr OR expr
3491 expr ::= * expr LT|GT|GE|LE expr
3492 expr ::= * expr EQ|NE expr
3493 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3494 expr ::= * expr PLUS|MINUS expr
3495 expr ::= * expr STAR|SLASH|REM expr
3496 expr ::= * expr CONCAT expr
3497 expr ::= * expr likeop expr
3498 expr ::= * expr likeop expr ESCAPE expr
3499 expr ::= expr likeop expr ESCAPE * expr
3500 expr ::= * expr ISNULL|NOTNULL
3501 expr ::= * expr NOT NULL
3502 expr ::= * expr IS expr
3503 expr ::= * expr IS NOT expr
3505 expr ::= * BITNOT expr
3506 expr ::= * MINUS expr
3507 expr ::= * PLUS expr
3508 expr ::= * expr between_op expr AND expr
3509 expr ::= * expr in_op LP exprlist RP
3510 expr ::= * LP select RP
3511 expr ::= * expr in_op LP select RP
3512 expr ::= * expr in_op nm dbnm
3513 expr ::= * EXISTS LP select RP
3514 expr ::= * CASE case_operand case_exprlist case_else END
3515 expr ::= * RAISE LP IGNORE RP
3516 expr ::= * RAISE LP raisetype COMMA nm RP
3550 expr ::= * LP expr RP
3554 expr ::= * nm DOT nm
3555 expr ::= * nm DOT nm DOT nm
3556 term ::= * INTEGER|FLOAT|BLOB
3560 expr ::= * expr COLLATE ids
3561 expr ::= * CAST LP expr AS typetoken RP
3562 expr ::= * ID LP distinct exprlist RP
3563 expr ::= * ID LP STAR RP
3565 expr ::= * expr AND expr
3566 expr ::= * expr OR expr
3567 expr ::= * expr LT|GT|GE|LE expr
3568 expr ::= * expr EQ|NE expr
3569 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3570 expr ::= * expr PLUS|MINUS expr
3571 expr ::= * expr STAR|SLASH|REM expr
3572 expr ::= * expr CONCAT expr
3573 expr ::= * expr likeop expr
3574 expr ::= expr likeop * expr
3575 expr ::= * expr likeop expr ESCAPE expr
3576 expr ::= expr likeop * expr ESCAPE expr
3577 expr ::= * expr ISNULL|NOTNULL
3578 expr ::= * expr NOT NULL
3579 expr ::= * expr IS expr
3580 expr ::= * expr IS NOT expr
3582 expr ::= * BITNOT expr
3583 expr ::= * MINUS expr
3584 expr ::= * PLUS expr
3585 expr ::= * expr between_op expr AND expr
3586 expr ::= * expr in_op LP exprlist RP
3587 expr ::= * LP select RP
3588 expr ::= * expr in_op LP select RP
3589 expr ::= * expr in_op nm dbnm
3590 expr ::= * EXISTS LP select RP
3591 expr ::= * CASE case_operand case_exprlist case_else END
3592 expr ::= * RAISE LP IGNORE RP
3593 expr ::= * RAISE LP raisetype COMMA nm RP
3627 expr ::= * LP expr RP
3631 expr ::= * nm DOT nm
3632 expr ::= * nm DOT nm DOT nm
3633 term ::= * INTEGER|FLOAT|BLOB
3637 expr ::= * expr COLLATE ids
3638 expr ::= * CAST LP expr AS typetoken RP
3639 expr ::= * ID LP distinct exprlist RP
3640 expr ::= * ID LP STAR RP
3642 expr ::= * expr AND expr
3643 expr ::= * expr OR expr
3644 expr ::= * expr LT|GT|GE|LE expr
3645 expr ::= * expr EQ|NE expr
3646 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3647 expr ::= * expr PLUS|MINUS expr
3648 expr ::= * expr STAR|SLASH|REM expr
3649 expr ::= * expr CONCAT expr
3650 expr ::= expr CONCAT * expr
3651 expr ::= * expr likeop expr
3652 expr ::= * expr likeop expr ESCAPE expr
3653 expr ::= * expr ISNULL|NOTNULL
3654 expr ::= * expr NOT NULL
3655 expr ::= * expr IS expr
3656 expr ::= * expr IS NOT expr
3658 expr ::= * BITNOT expr
3659 expr ::= * MINUS expr
3660 expr ::= * PLUS expr
3661 expr ::= * expr between_op expr AND expr
3662 expr ::= * expr in_op LP exprlist RP
3663 expr ::= * LP select RP
3664 expr ::= * expr in_op LP select RP
3665 expr ::= * expr in_op nm dbnm
3666 expr ::= * EXISTS LP select RP
3667 expr ::= * CASE case_operand case_exprlist case_else END
3668 expr ::= * RAISE LP IGNORE RP
3669 expr ::= * RAISE LP raisetype COMMA nm RP
3703 expr ::= * LP expr RP
3707 expr ::= * nm DOT nm
3708 expr ::= * nm DOT nm DOT nm
3709 term ::= * INTEGER|FLOAT|BLOB
3713 expr ::= * expr COLLATE ids
3714 expr ::= * CAST LP expr AS typetoken RP
3715 expr ::= * ID LP distinct exprlist RP
3716 expr ::= * ID LP STAR RP
3718 expr ::= * expr AND expr
3719 expr ::= * expr OR expr
3720 expr ::= * expr LT|GT|GE|LE expr
3721 expr ::= * expr EQ|NE expr
3722 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3723 expr ::= * expr PLUS|MINUS expr
3724 expr ::= * expr STAR|SLASH|REM expr
3725 expr ::= expr STAR|SLASH|REM * expr
3726 expr ::= * expr CONCAT expr
3727 expr ::= * expr likeop expr
3728 expr ::= * expr likeop expr ESCAPE expr
3729 expr ::= * expr ISNULL|NOTNULL
3730 expr ::= * expr NOT NULL
3731 expr ::= * expr IS expr
3732 expr ::= * expr IS NOT expr
3734 expr ::= * BITNOT expr
3735 expr ::= * MINUS expr
3736 expr ::= * PLUS expr
3737 expr ::= * expr between_op expr AND expr
3738 expr ::= * expr in_op LP exprlist RP
3739 expr ::= * LP select RP
3740 expr ::= * expr in_op LP select RP
3741 expr ::= * expr in_op nm dbnm
3742 expr ::= * EXISTS LP select RP
3743 expr ::= * CASE case_operand case_exprlist case_else END
3744 expr ::= * RAISE LP IGNORE RP
3745 expr ::= * RAISE LP raisetype COMMA nm RP
3779 expr ::= * LP expr RP
3783 expr ::= * nm DOT nm
3784 expr ::= * nm DOT nm DOT nm
3785 term ::= * INTEGER|FLOAT|BLOB
3789 expr ::= * expr COLLATE ids
3790 expr ::= * CAST LP expr AS typetoken RP
3791 expr ::= * ID LP distinct exprlist RP
3792 expr ::= * ID LP STAR RP
3794 expr ::= * expr AND expr
3795 expr ::= * expr OR expr
3796 expr ::= * expr LT|GT|GE|LE expr
3797 expr ::= * expr EQ|NE expr
3798 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3799 expr ::= * expr PLUS|MINUS expr
3800 expr ::= expr PLUS|MINUS * expr
3801 expr ::= * expr STAR|SLASH|REM expr
3802 expr ::= * expr CONCAT expr
3803 expr ::= * expr likeop expr
3804 expr ::= * expr likeop expr ESCAPE expr
3805 expr ::= * expr ISNULL|NOTNULL
3806 expr ::= * expr NOT NULL
3807 expr ::= * expr IS expr
3808 expr ::= * expr IS NOT expr
3810 expr ::= * BITNOT expr
3811 expr ::= * MINUS expr
3812 expr ::= * PLUS expr
3813 expr ::= * expr between_op expr AND expr
3814 expr ::= * expr in_op LP exprlist RP
3815 expr ::= * LP select RP
3816 expr ::= * expr in_op LP select RP
3817 expr ::= * expr in_op nm dbnm
3818 expr ::= * EXISTS LP select RP
3819 expr ::= * CASE case_operand case_exprlist case_else END
3820 expr ::= * RAISE LP IGNORE RP
3821 expr ::= * RAISE LP raisetype COMMA nm RP
3855 expr ::= * LP expr RP
3859 expr ::= * nm DOT nm
3860 expr ::= * nm DOT nm DOT nm
3861 term ::= * INTEGER|FLOAT|BLOB
3865 expr ::= * expr COLLATE ids
3866 expr ::= * CAST LP expr AS typetoken RP
3867 expr ::= * ID LP distinct exprlist RP
3868 expr ::= * ID LP STAR RP
3870 expr ::= * expr AND expr
3871 expr ::= * expr OR expr
3872 expr ::= * expr LT|GT|GE|LE expr
3873 expr ::= * expr EQ|NE expr
3874 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3875 expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT * expr
3876 expr ::= * expr PLUS|MINUS expr
3877 expr ::= * expr STAR|SLASH|REM expr
3878 expr ::= * expr CONCAT expr
3879 expr ::= * expr likeop expr
3880 expr ::= * expr likeop expr ESCAPE expr
3881 expr ::= * expr ISNULL|NOTNULL
3882 expr ::= * expr NOT NULL
3883 expr ::= * expr IS expr
3884 expr ::= * expr IS NOT expr
3886 expr ::= * BITNOT expr
3887 expr ::= * MINUS expr
3888 expr ::= * PLUS expr
3889 expr ::= * expr between_op expr AND expr
3890 expr ::= * expr in_op LP exprlist RP
3891 expr ::= * LP select RP
3892 expr ::= * expr in_op LP select RP
3893 expr ::= * expr in_op nm dbnm
3894 expr ::= * EXISTS LP select RP
3895 expr ::= * CASE case_operand case_exprlist case_else END
3896 expr ::= * RAISE LP IGNORE RP
3897 expr ::= * RAISE LP raisetype COMMA nm RP
3931 expr ::= * LP expr RP
3935 expr ::= * nm DOT nm
3936 expr ::= * nm DOT nm DOT nm
3937 term ::= * INTEGER|FLOAT|BLOB
3941 expr ::= * expr COLLATE ids
3942 expr ::= * CAST LP expr AS typetoken RP
3943 expr ::= * ID LP distinct exprlist RP
3944 expr ::= * ID LP STAR RP
3946 expr ::= * expr AND expr
3947 expr ::= * expr OR expr
3948 expr ::= * expr LT|GT|GE|LE expr
3949 expr ::= * expr EQ|NE expr
3950 expr ::= expr EQ|NE * expr
3951 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
3952 expr ::= * expr PLUS|MINUS expr
3953 expr ::= * expr STAR|SLASH|REM expr
3954 expr ::= * expr CONCAT expr
3955 expr ::= * expr likeop expr
3956 expr ::= * expr likeop expr ESCAPE expr
3957 expr ::= * expr ISNULL|NOTNULL
3958 expr ::= * expr NOT NULL
3959 expr ::= * expr IS expr
3960 expr ::= * expr IS NOT expr
3962 expr ::= * BITNOT expr
3963 expr ::= * MINUS expr
3964 expr ::= * PLUS expr
3965 expr ::= * expr between_op expr AND expr
3966 expr ::= * expr in_op LP exprlist RP
3967 expr ::= * LP select RP
3968 expr ::= * expr in_op LP select RP
3969 expr ::= * expr in_op nm dbnm
3970 expr ::= * EXISTS LP select RP
3971 expr ::= * CASE case_operand case_exprlist case_else END
3972 expr ::= * RAISE LP IGNORE RP
3973 expr ::= * RAISE LP raisetype COMMA nm RP
4007 expr ::= * LP expr RP
4011 expr ::= * nm DOT nm
4012 expr ::= * nm DOT nm DOT nm
4013 term ::= * INTEGER|FLOAT|BLOB
4017 expr ::= * expr COLLATE ids
4018 expr ::= * CAST LP expr AS typetoken RP
4019 expr ::= * ID LP distinct exprlist RP
4020 expr ::= * ID LP STAR RP
4022 expr ::= * expr AND expr
4023 expr ::= * expr OR expr
4024 expr ::= * expr LT|GT|GE|LE expr
4025 expr ::= expr LT|GT|GE|LE * expr
4026 expr ::= * expr EQ|NE expr
4027 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
4028 expr ::= * expr PLUS|MINUS expr
4029 expr ::= * expr STAR|SLASH|REM expr
4030 expr ::= * expr CONCAT expr
4031 expr ::= * expr likeop expr
4032 expr ::= * expr likeop expr ESCAPE expr
4033 expr ::= * expr ISNULL|NOTNULL
4034 expr ::= * expr NOT NULL
4035 expr ::= * expr IS expr
4036 expr ::= * expr IS NOT expr
4038 expr ::= * BITNOT expr
4039 expr ::= * MINUS expr
4040 expr ::= * PLUS expr
4041 expr ::= * expr between_op expr AND expr
4042 expr ::= * expr in_op LP exprlist RP
4043 expr ::= * LP select RP
4044 expr ::= * expr in_op LP select RP
4045 expr ::= * expr in_op nm dbnm
4046 expr ::= * EXISTS LP select RP
4047 expr ::= * CASE case_operand case_exprlist case_else END
4048 expr ::= * RAISE LP IGNORE RP
4049 expr ::= * RAISE LP raisetype COMMA nm RP
4083 expr ::= * LP expr RP
4087 expr ::= * nm DOT nm
4088 expr ::= * nm DOT nm DOT nm
4089 term ::= * INTEGER|FLOAT|BLOB
4093 expr ::= * expr COLLATE ids
4094 expr ::= * CAST LP expr AS typetoken RP
4095 expr ::= * ID LP distinct exprlist RP
4096 expr ::= * ID LP STAR RP
4098 expr ::= * expr AND expr
4099 expr ::= * expr OR expr
4100 expr ::= expr OR * expr
4101 expr ::= * expr LT|GT|GE|LE expr
4102 expr ::= * expr EQ|NE expr
4103 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
4104 expr ::= * expr PLUS|MINUS expr
4105 expr ::= * expr STAR|SLASH|REM expr
4106 expr ::= * expr CONCAT expr
4107 expr ::= * expr likeop expr
4108 expr ::= * expr likeop expr ESCAPE expr
4109 expr ::= * expr ISNULL|NOTNULL
4110 expr ::= * expr NOT NULL
4111 expr ::= * expr IS expr
4112 expr ::= * expr IS NOT expr
4114 expr ::= * BITNOT expr
4115 expr ::= * MINUS expr
4116 expr ::= * PLUS expr
4117 expr ::= * expr between_op expr AND expr
4118 expr ::= * expr in_op LP exprlist RP
4119 expr ::= * LP select RP
4120 expr ::= * expr in_op LP select RP
4121 expr ::= * expr in_op nm dbnm
4122 expr ::= * EXISTS LP select RP
4123 expr ::= * CASE case_operand case_exprlist case_else END
4124 expr ::= * RAISE LP IGNORE RP
4125 expr ::= * RAISE LP raisetype COMMA nm RP
4159 expr ::= * LP expr RP
4163 expr ::= * nm DOT nm
4164 expr ::= * nm DOT nm DOT nm
4165 term ::= * INTEGER|FLOAT|BLOB
4169 expr ::= * expr COLLATE ids
4170 expr ::= * CAST LP expr AS typetoken RP
4171 expr ::= * ID LP distinct exprlist RP
4172 expr ::= * ID LP STAR RP
4174 expr ::= * expr AND expr
4175 expr ::= expr AND * expr
4176 expr ::= * expr OR expr
4177 expr ::= * expr LT|GT|GE|LE expr
4178 expr ::= * expr EQ|NE expr
4179 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
4180 expr ::= * expr PLUS|MINUS expr
4181 expr ::= * expr STAR|SLASH|REM expr
4182 expr ::= * expr CONCAT expr
4183 expr ::= * expr likeop expr
4184 expr ::= * expr likeop expr ESCAPE expr
4185 expr ::= * expr ISNULL|NOTNULL
4186 expr ::= * expr NOT NULL
4187 expr ::= * expr IS expr
4188 expr ::= * expr IS NOT expr
4190 expr ::= * BITNOT expr
4191 expr ::= * MINUS expr
4192 expr ::= * PLUS expr
4193 expr ::= * expr between_op expr AND expr
4194 expr ::= * expr in_op LP exprlist RP
4195 expr ::= * LP select RP
4196 expr ::= * expr in_op LP select RP
4197 expr ::= * expr in_op nm dbnm
4198 expr ::= * EXISTS LP select RP
4199 expr ::= * CASE case_operand case_exprlist case_else END
4200 expr ::= * RAISE LP IGNORE RP
4201 expr ::= * RAISE LP raisetype COMMA nm RP
4234 limit_opt ::= LIMIT expr OFFSET * expr
4236 expr ::= * LP expr RP
4240 expr ::= * nm DOT nm
4241 expr ::= * nm DOT nm DOT nm
4242 term ::= * INTEGER|FLOAT|BLOB
4246 expr ::= * expr COLLATE ids
4247 expr ::= * CAST LP expr AS typetoken RP
4248 expr ::= * ID LP distinct exprlist RP
4249 expr ::= * ID LP STAR RP
4251 expr ::= * expr AND expr
4252 expr ::= * expr OR expr
4253 expr ::= * expr LT|GT|GE|LE expr
4254 expr ::= * expr EQ|NE expr
4255 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
4256 expr ::= * expr PLUS|MINUS expr
4257 expr ::= * expr STAR|SLASH|REM expr
4258 expr ::= * expr CONCAT expr
4259 expr ::= * expr likeop expr
4260 expr ::= * expr likeop expr ESCAPE expr
4261 expr ::= * expr ISNULL|NOTNULL
4262 expr ::= * expr NOT NULL
4263 expr ::= * expr IS expr
4264 expr ::= * expr IS NOT expr
4266 expr ::= * BITNOT expr
4267 expr ::= * MINUS expr
4268 expr ::= * PLUS expr
4269 expr ::= * expr between_op expr AND expr
4270 expr ::= * expr in_op LP exprlist RP
4271 expr ::= * LP select RP
4272 expr ::= * expr in_op LP select RP
4273 expr ::= * expr in_op nm dbnm
4274 expr ::= * EXISTS LP select RP
4275 expr ::= * CASE case_operand case_exprlist case_else END
4276 expr ::= * RAISE LP IGNORE RP
4277 expr ::= * RAISE LP raisetype COMMA nm RP
4310 limit_opt ::= LIMIT * expr
4311 limit_opt ::= LIMIT * expr OFFSET expr
4312 limit_opt ::= LIMIT * expr COMMA expr
4314 expr ::= * LP expr RP
4318 expr ::= * nm DOT nm
4319 expr ::= * nm DOT nm DOT nm
4320 term ::= * INTEGER|FLOAT|BLOB
4324 expr ::= * expr COLLATE ids
4325 expr ::= * CAST LP expr AS typetoken RP
4326 expr ::= * ID LP distinct exprlist RP
4327 expr ::= * ID LP STAR RP
4329 expr ::= * expr AND expr
4330 expr ::= * expr OR expr
4331 expr ::= * expr LT|GT|GE|LE expr
4332 expr ::= * expr EQ|NE expr
4333 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
4334 expr ::= * expr PLUS|MINUS expr
4335 expr ::= * expr STAR|SLASH|REM expr
4336 expr ::= * expr CONCAT expr
4337 expr ::= * expr likeop expr
4338 expr ::= * expr likeop expr ESCAPE expr
4339 expr ::= * expr ISNULL|NOTNULL
4340 expr ::= * expr NOT NULL
4341 expr ::= * expr IS expr
4342 expr ::= * expr IS NOT expr
4344 expr ::= * BITNOT expr
4345 expr ::= * MINUS expr
4346 expr ::= * PLUS expr
4347 expr ::= * expr between_op expr AND expr
4348 expr ::= * expr in_op LP exprlist RP
4349 expr ::= * LP select RP
4350 expr ::= * expr in_op LP select RP
4351 expr ::= * expr in_op nm dbnm
4352 expr ::= * EXISTS LP select RP
4353 expr ::= * CASE case_operand case_exprlist case_else END
4354 expr ::= * RAISE LP IGNORE RP
4355 expr ::= * RAISE LP raisetype COMMA nm RP
4388 ccons ::= DEFAULT LP * expr RP
4390 expr ::= * LP expr RP
4394 expr ::= * nm DOT nm
4395 expr ::= * nm DOT nm DOT nm
4396 term ::= * INTEGER|FLOAT|BLOB
4400 expr ::= * expr COLLATE ids
4401 expr ::= * CAST LP expr AS typetoken RP
4402 expr ::= * ID LP distinct exprlist RP
4403 expr ::= * ID LP STAR RP
4405 expr ::= * expr AND expr
4406 expr ::= * expr OR expr
4407 expr ::= * expr LT|GT|GE|LE expr
4408 expr ::= * expr EQ|NE expr
4409 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr
4410 expr ::= * expr PLUS|MINUS expr
4411 expr ::= * expr STAR|SLASH|REM expr
4412 expr ::= * expr CONCAT expr
4413 expr ::= * expr likeop expr
4414 expr ::= * expr likeop expr ESCAPE expr
4415 expr ::= * expr ISNULL|NOTNULL
4416 expr ::= * expr NOT NULL
4417 expr ::= * expr IS expr
4418 expr ::= * expr IS NOT expr
4420 expr ::= * BITNOT expr
4421 expr ::= * MINUS expr
4422 expr ::= * PLUS expr
4423 expr ::= * expr between_op expr AND expr
4424 expr ::= * expr in_op LP exprlist RP
4425 expr ::= * LP select RP
4426 expr ::= * expr in_op LP select RP
4427 expr ::= * expr in_op nm dbnm
4428 expr ::= * EXISTS LP select RP
4429 expr ::= * CASE case_operand case_exprlist case_else END
4430 expr ::= * RAISE LP IGNORE RP
4431 expr ::= * RAISE LP raisetype COMMA nm RP
4459 select ::= * oneselect
4460 select ::= * select multiselect_op oneselect
4461 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
4462 insert_cmd ::= * INSERT orconf
4463 insert_cmd ::= * REPLACE
4464 cmd ::= createkw trigger_decl BEGIN trigger_cmd_list * END
4465 trigger_cmd_list ::= trigger_cmd_list * trigger_cmd SEMI
4466 trigger_cmd ::= * UPDATE orconf trnm tridxby SET setlist where_opt
4467 trigger_cmd ::= * insert_cmd INTO trnm inscollist_opt valuelist
4468 trigger_cmd ::= * insert_cmd INTO trnm inscollist_opt select
4469 trigger_cmd ::= * DELETE FROM trnm tridxby where_opt
4470 trigger_cmd ::= * select
4480 insert_cmd shift 352
4481 trigger_cmd shift 359
4484 column ::= * columnid type carglist
4491 cmd ::= ALTER TABLE add_column_fullname ADD kwcolumn_opt * column
4508 fullname ::= * nm dbnm
4509 cmd ::= ALTER TABLE * fullname RENAME TO nm
4510 cmd ::= ALTER TABLE * add_column_fullname ADD kwcolumn_opt column
4511 add_column_fullname ::= * fullname
4520 add_column_fullname shift 332
4523 typetoken ::= typename LP signed COMMA * signed RP
4524 signed ::= * plus_num
4525 signed ::= * minus_num
4526 plus_num ::= * PLUS number
4527 plus_num ::= * number
4528 minus_num ::= * MINUS number
4529 number ::= * INTEGER|FLOAT
4541 typetoken ::= typename LP * signed RP
4542 typetoken ::= typename LP * signed COMMA signed RP
4543 signed ::= * plus_num
4544 signed ::= * minus_num
4545 plus_num ::= * PLUS number
4546 plus_num ::= * number
4547 minus_num ::= * MINUS number
4548 number ::= * INTEGER|FLOAT
4560 column ::= columnid * type carglist
4563 type ::= * typetoken
4564 typetoken ::= * typename
4565 typetoken ::= * typename LP signed RP
4566 typetoken ::= * typename LP signed COMMA signed RP
4568 typename ::= * typename ids
4579 select ::= * oneselect
4580 select ::= * select multiselect_op oneselect
4581 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
4582 stl_prefix ::= * seltablist joinop
4583 (133) stl_prefix ::= *
4584 seltablist ::= * stl_prefix nm dbnm as indexed_opt on_opt using_opt
4585 seltablist ::= * stl_prefix LP select RP as on_opt using_opt
4586 seltablist ::= stl_prefix LP * select RP as on_opt using_opt
4587 seltablist ::= * stl_prefix LP seltablist RP as on_opt using_opt
4588 seltablist ::= stl_prefix LP * seltablist RP as on_opt using_opt
4593 seltablist shift 197
4594 stl_prefix shift 143
4595 {default} reduce 133
4598 (163) limit_opt ::= LIMIT expr *
4599 limit_opt ::= LIMIT expr * OFFSET expr
4600 limit_opt ::= LIMIT expr * COMMA expr
4601 expr ::= expr * COLLATE ids
4602 expr ::= expr * AND expr
4603 expr ::= expr * OR expr
4604 expr ::= expr * LT|GT|GE|LE expr
4605 expr ::= expr * EQ|NE expr
4606 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
4607 expr ::= expr * PLUS|MINUS expr
4608 expr ::= expr * STAR|SLASH|REM expr
4609 expr ::= expr * CONCAT expr
4610 likeop ::= * LIKE_KW
4611 likeop ::= * NOT LIKE_KW
4613 likeop ::= * NOT MATCH
4614 expr ::= expr * likeop expr
4615 expr ::= expr * likeop expr ESCAPE expr
4616 expr ::= expr * ISNULL|NOTNULL
4617 expr ::= expr * NOT NULL
4618 expr ::= expr * IS expr
4619 expr ::= expr * IS NOT expr
4620 between_op ::= * BETWEEN
4621 between_op ::= * NOT BETWEEN
4622 expr ::= expr * between_op expr AND expr
4625 expr ::= expr * in_op LP exprlist RP
4626 expr ::= expr * in_op LP select RP
4627 expr ::= expr * in_op nm dbnm
4661 {default} reduce 163
4664 expr ::= expr * COLLATE ids
4665 expr ::= expr * AND expr
4666 expr ::= expr * OR expr
4667 expr ::= expr * LT|GT|GE|LE expr
4668 expr ::= expr * EQ|NE expr
4669 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
4670 expr ::= expr * PLUS|MINUS expr
4671 expr ::= expr * STAR|SLASH|REM expr
4672 expr ::= expr * CONCAT expr
4673 likeop ::= * LIKE_KW
4674 likeop ::= * NOT LIKE_KW
4676 likeop ::= * NOT MATCH
4677 expr ::= expr * likeop expr
4678 expr ::= expr * likeop expr ESCAPE expr
4679 expr ::= expr * ISNULL|NOTNULL
4680 expr ::= expr * NOT NULL
4681 expr ::= expr * IS expr
4682 expr ::= expr * IS NOT expr
4683 between_op ::= * BETWEEN
4684 between_op ::= * NOT BETWEEN
4685 expr ::= expr * between_op expr AND expr
4688 expr ::= expr * in_op LP exprlist RP
4689 expr ::= expr * in_op LP select RP
4690 expr ::= expr * in_op nm dbnm
4691 cmd ::= ATTACH database_kw_opt expr * AS expr key_opt
4726 tcons ::= CHECK LP expr * RP onconf
4727 expr ::= expr * COLLATE ids
4728 expr ::= expr * AND expr
4729 expr ::= expr * OR expr
4730 expr ::= expr * LT|GT|GE|LE expr
4731 expr ::= expr * EQ|NE expr
4732 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
4733 expr ::= expr * PLUS|MINUS expr
4734 expr ::= expr * STAR|SLASH|REM expr
4735 expr ::= expr * CONCAT expr
4736 likeop ::= * LIKE_KW
4737 likeop ::= * NOT LIKE_KW
4739 likeop ::= * NOT MATCH
4740 expr ::= expr * likeop expr
4741 expr ::= expr * likeop expr ESCAPE expr
4742 expr ::= expr * ISNULL|NOTNULL
4743 expr ::= expr * NOT NULL
4744 expr ::= expr * IS expr
4745 expr ::= expr * IS NOT expr
4746 between_op ::= * BETWEEN
4747 between_op ::= * NOT BETWEEN
4748 expr ::= expr * between_op expr AND expr
4751 expr ::= expr * in_op LP exprlist RP
4752 expr ::= expr * in_op LP select RP
4753 expr ::= expr * in_op nm dbnm
4788 ccons ::= CHECK LP expr * RP
4789 expr ::= expr * COLLATE ids
4790 expr ::= expr * AND expr
4791 expr ::= expr * OR expr
4792 expr ::= expr * LT|GT|GE|LE expr
4793 expr ::= expr * EQ|NE expr
4794 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
4795 expr ::= expr * PLUS|MINUS expr
4796 expr ::= expr * STAR|SLASH|REM expr
4797 expr ::= expr * CONCAT expr
4798 likeop ::= * LIKE_KW
4799 likeop ::= * NOT LIKE_KW
4801 likeop ::= * NOT MATCH
4802 expr ::= expr * likeop expr
4803 expr ::= expr * likeop expr ESCAPE expr
4804 expr ::= expr * ISNULL|NOTNULL
4805 expr ::= expr * NOT NULL
4806 expr ::= expr * IS expr
4807 expr ::= expr * IS NOT expr
4808 between_op ::= * BETWEEN
4809 between_op ::= * NOT BETWEEN
4810 expr ::= expr * between_op expr AND expr
4813 expr ::= expr * in_op LP exprlist RP
4814 expr ::= expr * in_op LP select RP
4815 expr ::= expr * in_op nm dbnm
4850 ccons ::= DEFAULT LP expr * RP
4851 expr ::= expr * COLLATE ids
4852 expr ::= expr * AND expr
4853 expr ::= expr * OR expr
4854 expr ::= expr * LT|GT|GE|LE expr
4855 expr ::= expr * EQ|NE expr
4856 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
4857 expr ::= expr * PLUS|MINUS expr
4858 expr ::= expr * STAR|SLASH|REM expr
4859 expr ::= expr * CONCAT expr
4860 likeop ::= * LIKE_KW
4861 likeop ::= * NOT LIKE_KW
4863 likeop ::= * NOT MATCH
4864 expr ::= expr * likeop expr
4865 expr ::= expr * likeop expr ESCAPE expr
4866 expr ::= expr * ISNULL|NOTNULL
4867 expr ::= expr * NOT NULL
4868 expr ::= expr * IS expr
4869 expr ::= expr * IS NOT expr
4870 between_op ::= * BETWEEN
4871 between_op ::= * NOT BETWEEN
4872 expr ::= expr * between_op expr AND expr
4875 expr ::= expr * in_op LP exprlist RP
4876 expr ::= expr * in_op LP select RP
4877 expr ::= expr * in_op nm dbnm
4912 expr ::= LP expr * RP
4913 expr ::= expr * COLLATE ids
4914 expr ::= expr * AND expr
4915 expr ::= expr * OR expr
4916 expr ::= expr * LT|GT|GE|LE expr
4917 expr ::= expr * EQ|NE expr
4918 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
4919 expr ::= expr * PLUS|MINUS expr
4920 expr ::= expr * STAR|SLASH|REM expr
4921 expr ::= expr * CONCAT expr
4922 likeop ::= * LIKE_KW
4923 likeop ::= * NOT LIKE_KW
4925 likeop ::= * NOT MATCH
4926 expr ::= expr * likeop expr
4927 expr ::= expr * likeop expr ESCAPE expr
4928 expr ::= expr * ISNULL|NOTNULL
4929 expr ::= expr * NOT NULL
4930 expr ::= expr * IS expr
4931 expr ::= expr * IS NOT expr
4932 between_op ::= * BETWEEN
4933 between_op ::= * NOT BETWEEN
4934 expr ::= expr * between_op expr AND expr
4937 expr ::= expr * in_op LP exprlist RP
4938 expr ::= expr * in_op LP select RP
4939 expr ::= expr * in_op nm dbnm
4974 expr ::= expr * COLLATE ids
4975 expr ::= expr * AND expr
4976 expr ::= expr * OR expr
4977 expr ::= expr * LT|GT|GE|LE expr
4978 expr ::= expr * EQ|NE expr
4979 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
4980 expr ::= expr * PLUS|MINUS expr
4981 expr ::= expr * STAR|SLASH|REM expr
4982 expr ::= expr * CONCAT expr
4983 likeop ::= * LIKE_KW
4984 likeop ::= * NOT LIKE_KW
4986 likeop ::= * NOT MATCH
4987 expr ::= expr * likeop expr
4988 expr ::= expr * likeop expr ESCAPE expr
4989 expr ::= expr * ISNULL|NOTNULL
4990 expr ::= expr * NOT NULL
4991 expr ::= expr * IS expr
4992 expr ::= expr * IS NOT expr
4993 between_op ::= * BETWEEN
4994 between_op ::= * NOT BETWEEN
4995 expr ::= expr * between_op expr AND expr
4998 expr ::= expr * in_op LP exprlist RP
4999 expr ::= expr * in_op LP select RP
5000 expr ::= expr * in_op nm dbnm
5001 case_exprlist ::= WHEN expr * THEN expr
5036 expr ::= expr * COLLATE ids
5037 expr ::= expr * AND expr
5038 expr ::= expr * OR expr
5039 expr ::= expr * LT|GT|GE|LE expr
5040 expr ::= expr * EQ|NE expr
5041 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5042 expr ::= expr * PLUS|MINUS expr
5043 expr ::= expr * STAR|SLASH|REM expr
5044 expr ::= expr * CONCAT expr
5045 likeop ::= * LIKE_KW
5046 likeop ::= * NOT LIKE_KW
5048 likeop ::= * NOT MATCH
5049 expr ::= expr * likeop expr
5050 expr ::= expr * likeop expr ESCAPE expr
5051 expr ::= expr * ISNULL|NOTNULL
5052 expr ::= expr * NOT NULL
5053 expr ::= expr * IS expr
5054 expr ::= expr * IS NOT expr
5055 between_op ::= * BETWEEN
5056 between_op ::= * NOT BETWEEN
5057 expr ::= expr * between_op expr AND expr
5060 expr ::= expr * in_op LP exprlist RP
5061 expr ::= expr * in_op LP select RP
5062 expr ::= expr * in_op nm dbnm
5063 case_exprlist ::= case_exprlist WHEN expr * THEN expr
5098 expr ::= expr * COLLATE ids
5099 expr ::= CAST LP expr * AS typetoken RP
5100 expr ::= expr * AND expr
5101 expr ::= expr * OR expr
5102 expr ::= expr * LT|GT|GE|LE expr
5103 expr ::= expr * EQ|NE expr
5104 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5105 expr ::= expr * PLUS|MINUS expr
5106 expr ::= expr * STAR|SLASH|REM expr
5107 expr ::= expr * CONCAT expr
5108 likeop ::= * LIKE_KW
5109 likeop ::= * NOT LIKE_KW
5111 likeop ::= * NOT MATCH
5112 expr ::= expr * likeop expr
5113 expr ::= expr * likeop expr ESCAPE expr
5114 expr ::= expr * ISNULL|NOTNULL
5115 expr ::= expr * NOT NULL
5116 expr ::= expr * IS expr
5117 expr ::= expr * IS NOT expr
5118 between_op ::= * BETWEEN
5119 between_op ::= * NOT BETWEEN
5120 expr ::= expr * between_op expr AND expr
5123 expr ::= expr * in_op LP exprlist RP
5124 expr ::= expr * in_op LP select RP
5125 expr ::= expr * in_op nm dbnm
5160 expr ::= expr * COLLATE ids
5161 expr ::= expr * AND expr
5162 expr ::= expr * OR expr
5163 expr ::= expr * LT|GT|GE|LE expr
5164 expr ::= expr * EQ|NE expr
5165 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5166 expr ::= expr * PLUS|MINUS expr
5167 expr ::= expr * STAR|SLASH|REM expr
5168 expr ::= expr * CONCAT expr
5169 likeop ::= * LIKE_KW
5170 likeop ::= * NOT LIKE_KW
5172 likeop ::= * NOT MATCH
5173 expr ::= expr * likeop expr
5174 expr ::= expr * likeop expr ESCAPE expr
5175 expr ::= expr * ISNULL|NOTNULL
5176 expr ::= expr * NOT NULL
5177 expr ::= expr * IS expr
5178 expr ::= expr * IS NOT expr
5179 between_op ::= * BETWEEN
5180 between_op ::= * NOT BETWEEN
5181 expr ::= expr * between_op expr AND expr
5184 expr ::= expr * in_op LP exprlist RP
5185 expr ::= expr * in_op LP select RP
5186 expr ::= expr * in_op nm dbnm
5187 (300) cmd ::= DETACH database_kw_opt expr *
5219 {default} reduce 300
5222 expr ::= expr * COLLATE ids
5223 expr ::= expr * AND expr
5224 expr ::= expr * OR expr
5225 expr ::= expr * LT|GT|GE|LE expr
5226 expr ::= expr * EQ|NE expr
5227 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5228 expr ::= expr * PLUS|MINUS expr
5229 expr ::= expr * STAR|SLASH|REM expr
5230 expr ::= expr * CONCAT expr
5231 likeop ::= * LIKE_KW
5232 likeop ::= * NOT LIKE_KW
5234 likeop ::= * NOT MATCH
5235 expr ::= expr * likeop expr
5236 expr ::= expr * likeop expr ESCAPE expr
5237 expr ::= expr * ISNULL|NOTNULL
5238 expr ::= expr * NOT NULL
5239 expr ::= expr * IS expr
5240 expr ::= expr * IS NOT expr
5241 between_op ::= * BETWEEN
5242 between_op ::= * NOT BETWEEN
5243 expr ::= expr * between_op expr AND expr
5246 expr ::= expr * in_op LP exprlist RP
5247 expr ::= expr * in_op LP select RP
5248 expr ::= expr * in_op nm dbnm
5249 (302) key_opt ::= KEY expr *
5281 {default} reduce 302
5284 (171) setlist ::= nm EQ expr *
5285 expr ::= expr * COLLATE ids
5286 expr ::= expr * AND expr
5287 expr ::= expr * OR expr
5288 expr ::= expr * LT|GT|GE|LE expr
5289 expr ::= expr * EQ|NE expr
5290 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5291 expr ::= expr * PLUS|MINUS expr
5292 expr ::= expr * STAR|SLASH|REM expr
5293 expr ::= expr * CONCAT expr
5294 likeop ::= * LIKE_KW
5295 likeop ::= * NOT LIKE_KW
5297 likeop ::= * NOT MATCH
5298 expr ::= expr * likeop expr
5299 expr ::= expr * likeop expr ESCAPE expr
5300 expr ::= expr * ISNULL|NOTNULL
5301 expr ::= expr * NOT NULL
5302 expr ::= expr * IS expr
5303 expr ::= expr * IS NOT expr
5304 between_op ::= * BETWEEN
5305 between_op ::= * NOT BETWEEN
5306 expr ::= expr * between_op expr AND expr
5309 expr ::= expr * in_op LP exprlist RP
5310 expr ::= expr * in_op LP select RP
5311 expr ::= expr * in_op nm dbnm
5343 {default} reduce 171
5346 (170) setlist ::= setlist COMMA nm EQ expr *
5347 expr ::= expr * COLLATE ids
5348 expr ::= expr * AND expr
5349 expr ::= expr * OR expr
5350 expr ::= expr * LT|GT|GE|LE expr
5351 expr ::= expr * EQ|NE expr
5352 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5353 expr ::= expr * PLUS|MINUS expr
5354 expr ::= expr * STAR|SLASH|REM expr
5355 expr ::= expr * CONCAT expr
5356 likeop ::= * LIKE_KW
5357 likeop ::= * NOT LIKE_KW
5359 likeop ::= * NOT MATCH
5360 expr ::= expr * likeop expr
5361 expr ::= expr * likeop expr ESCAPE expr
5362 expr ::= expr * ISNULL|NOTNULL
5363 expr ::= expr * NOT NULL
5364 expr ::= expr * IS expr
5365 expr ::= expr * IS NOT expr
5366 between_op ::= * BETWEEN
5367 between_op ::= * NOT BETWEEN
5368 expr ::= expr * between_op expr AND expr
5371 expr ::= expr * in_op LP exprlist RP
5372 expr ::= expr * in_op LP select RP
5373 expr ::= expr * in_op nm dbnm
5405 {default} reduce 170
5408 expr ::= expr * COLLATE ids
5409 expr ::= expr * AND expr
5410 expr ::= expr * OR expr
5411 expr ::= expr * LT|GT|GE|LE expr
5412 expr ::= expr * EQ|NE expr
5413 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5414 expr ::= expr * PLUS|MINUS expr
5415 expr ::= expr * STAR|SLASH|REM expr
5416 expr ::= expr * CONCAT expr
5417 likeop ::= * LIKE_KW
5418 likeop ::= * NOT LIKE_KW
5420 likeop ::= * NOT MATCH
5421 expr ::= expr * likeop expr
5422 expr ::= expr * likeop expr ESCAPE expr
5423 expr ::= expr * ISNULL|NOTNULL
5424 expr ::= expr * NOT NULL
5425 expr ::= expr * IS expr
5426 expr ::= expr * IS NOT expr
5427 between_op ::= * BETWEEN
5428 between_op ::= * NOT BETWEEN
5429 expr ::= expr * between_op expr AND expr
5432 expr ::= expr * in_op LP exprlist RP
5433 expr ::= expr * in_op LP select RP
5434 expr ::= expr * in_op nm dbnm
5435 (280) when_clause ::= WHEN expr *
5467 {default} reduce 280
5470 (144) on_opt ::= ON expr *
5471 expr ::= expr * COLLATE ids
5472 expr ::= expr * AND expr
5473 expr ::= expr * OR expr
5474 expr ::= expr * LT|GT|GE|LE expr
5475 expr ::= expr * EQ|NE expr
5476 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5477 expr ::= expr * PLUS|MINUS expr
5478 expr ::= expr * STAR|SLASH|REM expr
5479 expr ::= expr * CONCAT expr
5480 likeop ::= * LIKE_KW
5481 likeop ::= * NOT LIKE_KW
5483 likeop ::= * NOT MATCH
5484 expr ::= expr * likeop expr
5485 expr ::= expr * likeop expr ESCAPE expr
5486 expr ::= expr * ISNULL|NOTNULL
5487 expr ::= expr * NOT NULL
5488 expr ::= expr * IS expr
5489 expr ::= expr * IS NOT expr
5490 between_op ::= * BETWEEN
5491 between_op ::= * NOT BETWEEN
5492 expr ::= expr * between_op expr AND expr
5495 expr ::= expr * in_op LP exprlist RP
5496 expr ::= expr * in_op LP select RP
5497 expr ::= expr * in_op nm dbnm
5529 {default} reduce 144
5532 (168) where_opt ::= WHERE expr *
5533 expr ::= expr * COLLATE ids
5534 expr ::= expr * AND expr
5535 expr ::= expr * OR expr
5536 expr ::= expr * LT|GT|GE|LE expr
5537 expr ::= expr * EQ|NE expr
5538 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5539 expr ::= expr * PLUS|MINUS expr
5540 expr ::= expr * STAR|SLASH|REM expr
5541 expr ::= expr * CONCAT expr
5542 likeop ::= * LIKE_KW
5543 likeop ::= * NOT LIKE_KW
5545 likeop ::= * NOT MATCH
5546 expr ::= expr * likeop expr
5547 expr ::= expr * likeop expr ESCAPE expr
5548 expr ::= expr * ISNULL|NOTNULL
5549 expr ::= expr * NOT NULL
5550 expr ::= expr * IS expr
5551 expr ::= expr * IS NOT expr
5552 between_op ::= * BETWEEN
5553 between_op ::= * NOT BETWEEN
5554 expr ::= expr * between_op expr AND expr
5557 expr ::= expr * in_op LP exprlist RP
5558 expr ::= expr * in_op LP select RP
5559 expr ::= expr * in_op nm dbnm
5591 {default} reduce 168
5594 (161) having_opt ::= HAVING expr *
5595 expr ::= expr * COLLATE ids
5596 expr ::= expr * AND expr
5597 expr ::= expr * OR expr
5598 expr ::= expr * LT|GT|GE|LE expr
5599 expr ::= expr * EQ|NE expr
5600 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5601 expr ::= expr * PLUS|MINUS expr
5602 expr ::= expr * STAR|SLASH|REM expr
5603 expr ::= expr * CONCAT expr
5604 likeop ::= * LIKE_KW
5605 likeop ::= * NOT LIKE_KW
5607 likeop ::= * NOT MATCH
5608 expr ::= expr * likeop expr
5609 expr ::= expr * likeop expr ESCAPE expr
5610 expr ::= expr * ISNULL|NOTNULL
5611 expr ::= expr * NOT NULL
5612 expr ::= expr * IS expr
5613 expr ::= expr * IS NOT expr
5614 between_op ::= * BETWEEN
5615 between_op ::= * NOT BETWEEN
5616 expr ::= expr * between_op expr AND expr
5619 expr ::= expr * in_op LP exprlist RP
5620 expr ::= expr * in_op LP select RP
5621 expr ::= expr * in_op nm dbnm
5653 {default} reduce 161
5656 (165) limit_opt ::= LIMIT expr COMMA expr *
5657 expr ::= expr * COLLATE ids
5658 expr ::= expr * AND expr
5659 expr ::= expr * OR expr
5660 expr ::= expr * LT|GT|GE|LE expr
5661 expr ::= expr * EQ|NE expr
5662 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5663 expr ::= expr * PLUS|MINUS expr
5664 expr ::= expr * STAR|SLASH|REM expr
5665 expr ::= expr * CONCAT expr
5666 likeop ::= * LIKE_KW
5667 likeop ::= * NOT LIKE_KW
5669 likeop ::= * NOT MATCH
5670 expr ::= expr * likeop expr
5671 expr ::= expr * likeop expr ESCAPE expr
5672 expr ::= expr * ISNULL|NOTNULL
5673 expr ::= expr * NOT NULL
5674 expr ::= expr * IS expr
5675 expr ::= expr * IS NOT expr
5676 between_op ::= * BETWEEN
5677 between_op ::= * NOT BETWEEN
5678 expr ::= expr * between_op expr AND expr
5681 expr ::= expr * in_op LP exprlist RP
5682 expr ::= expr * in_op LP select RP
5683 expr ::= expr * in_op nm dbnm
5715 {default} reduce 165
5718 expr ::= expr * COLLATE ids
5719 expr ::= expr * AND expr
5720 expr ::= expr * OR expr
5721 expr ::= expr * LT|GT|GE|LE expr
5722 expr ::= expr * EQ|NE expr
5723 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5724 expr ::= expr * PLUS|MINUS expr
5725 expr ::= expr * STAR|SLASH|REM expr
5726 expr ::= expr * CONCAT expr
5727 likeop ::= * LIKE_KW
5728 likeop ::= * NOT LIKE_KW
5730 likeop ::= * NOT MATCH
5731 expr ::= expr * likeop expr
5732 expr ::= expr * likeop expr ESCAPE expr
5733 expr ::= expr * ISNULL|NOTNULL
5734 expr ::= expr * NOT NULL
5735 expr ::= expr * IS expr
5736 expr ::= expr * IS NOT expr
5737 between_op ::= * BETWEEN
5738 between_op ::= * NOT BETWEEN
5739 expr ::= expr * between_op expr AND expr
5742 expr ::= expr * in_op LP exprlist RP
5743 expr ::= expr * in_op LP select RP
5744 expr ::= expr * in_op nm dbnm
5745 (240) nexprlist ::= nexprlist COMMA expr *
5777 {default} reduce 240
5780 expr ::= expr * COLLATE ids
5781 expr ::= expr * AND expr
5782 expr ::= expr * OR expr
5783 expr ::= expr * LT|GT|GE|LE expr
5784 expr ::= expr * EQ|NE expr
5785 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5786 expr ::= expr * PLUS|MINUS expr
5787 expr ::= expr * STAR|SLASH|REM expr
5788 expr ::= expr * CONCAT expr
5789 likeop ::= * LIKE_KW
5790 likeop ::= * NOT LIKE_KW
5792 likeop ::= * NOT MATCH
5793 expr ::= expr * likeop expr
5794 expr ::= expr * likeop expr ESCAPE expr
5795 expr ::= expr * ISNULL|NOTNULL
5796 expr ::= expr * NOT NULL
5797 expr ::= expr * IS expr
5798 expr ::= expr * IS NOT expr
5799 between_op ::= * BETWEEN
5800 between_op ::= * NOT BETWEEN
5801 expr ::= expr * between_op expr AND expr
5804 expr ::= expr * in_op LP exprlist RP
5805 expr ::= expr * in_op LP select RP
5806 expr ::= expr * in_op nm dbnm
5807 (233) case_exprlist ::= WHEN expr THEN expr *
5839 {default} reduce 233
5842 expr ::= expr * COLLATE ids
5843 expr ::= expr * AND expr
5844 expr ::= expr * OR expr
5845 expr ::= expr * LT|GT|GE|LE expr
5846 expr ::= expr * EQ|NE expr
5847 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5848 expr ::= expr * PLUS|MINUS expr
5849 expr ::= expr * STAR|SLASH|REM expr
5850 expr ::= expr * CONCAT expr
5851 likeop ::= * LIKE_KW
5852 likeop ::= * NOT LIKE_KW
5854 likeop ::= * NOT MATCH
5855 expr ::= expr * likeop expr
5856 expr ::= expr * likeop expr ESCAPE expr
5857 expr ::= expr * ISNULL|NOTNULL
5858 expr ::= expr * NOT NULL
5859 expr ::= expr * IS expr
5860 expr ::= expr * IS NOT expr
5861 between_op ::= * BETWEEN
5862 between_op ::= * NOT BETWEEN
5863 expr ::= expr * between_op expr AND expr
5866 expr ::= expr * in_op LP exprlist RP
5867 expr ::= expr * in_op LP select RP
5868 expr ::= expr * in_op nm dbnm
5869 (234) case_else ::= ELSE expr *
5901 {default} reduce 234
5904 expr ::= expr * COLLATE ids
5905 expr ::= expr * AND expr
5906 expr ::= expr * OR expr
5907 expr ::= expr * LT|GT|GE|LE expr
5908 expr ::= expr * EQ|NE expr
5909 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5910 expr ::= expr * PLUS|MINUS expr
5911 expr ::= expr * STAR|SLASH|REM expr
5912 expr ::= expr * CONCAT expr
5913 likeop ::= * LIKE_KW
5914 likeop ::= * NOT LIKE_KW
5916 likeop ::= * NOT MATCH
5917 expr ::= expr * likeop expr
5918 expr ::= expr * likeop expr ESCAPE expr
5919 expr ::= expr * ISNULL|NOTNULL
5920 expr ::= expr * NOT NULL
5921 expr ::= expr * IS expr
5922 expr ::= expr * IS NOT expr
5923 between_op ::= * BETWEEN
5924 between_op ::= * NOT BETWEEN
5925 expr ::= expr * between_op expr AND expr
5928 expr ::= expr * in_op LP exprlist RP
5929 expr ::= expr * in_op LP select RP
5930 expr ::= expr * in_op nm dbnm
5931 (232) case_exprlist ::= case_exprlist WHEN expr THEN expr *
5963 {default} reduce 232
5966 expr ::= expr * COLLATE ids
5967 expr ::= expr * AND expr
5968 expr ::= expr * OR expr
5969 expr ::= expr * LT|GT|GE|LE expr
5970 expr ::= expr * EQ|NE expr
5971 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
5972 expr ::= expr * PLUS|MINUS expr
5973 expr ::= expr * STAR|SLASH|REM expr
5974 expr ::= expr * CONCAT expr
5975 likeop ::= * LIKE_KW
5976 likeop ::= * NOT LIKE_KW
5978 likeop ::= * NOT MATCH
5979 expr ::= expr * likeop expr
5980 expr ::= expr * likeop expr ESCAPE expr
5981 expr ::= expr * ISNULL|NOTNULL
5982 expr ::= expr * NOT NULL
5983 expr ::= expr * IS expr
5984 expr ::= expr * IS NOT expr
5985 between_op ::= * BETWEEN
5986 between_op ::= * NOT BETWEEN
5987 expr ::= expr * between_op expr AND expr
5990 expr ::= expr * in_op LP exprlist RP
5991 expr ::= expr * in_op LP select RP
5992 expr ::= expr * in_op nm dbnm
5993 (236) case_operand ::= expr *
6025 {default} reduce 236
6028 expr ::= expr * COLLATE ids
6029 expr ::= expr * AND expr
6030 expr ::= expr * OR expr
6031 expr ::= expr * LT|GT|GE|LE expr
6032 expr ::= expr * EQ|NE expr
6033 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6034 expr ::= expr * PLUS|MINUS expr
6035 expr ::= expr * STAR|SLASH|REM expr
6036 expr ::= expr * CONCAT expr
6037 likeop ::= * LIKE_KW
6038 likeop ::= * NOT LIKE_KW
6040 likeop ::= * NOT MATCH
6041 expr ::= expr * likeop expr
6042 expr ::= expr * likeop expr ESCAPE expr
6043 expr ::= expr * ISNULL|NOTNULL
6044 expr ::= expr * NOT NULL
6045 expr ::= expr * IS expr
6046 expr ::= expr * IS NOT expr
6047 between_op ::= * BETWEEN
6048 between_op ::= * NOT BETWEEN
6049 expr ::= expr * between_op expr AND expr
6052 expr ::= expr * in_op LP exprlist RP
6053 expr ::= expr * in_op LP select RP
6054 expr ::= expr * in_op nm dbnm
6055 (241) nexprlist ::= expr *
6087 {default} reduce 241
6090 expr ::= expr * COLLATE ids
6091 expr ::= expr * AND expr
6092 expr ::= expr * OR expr
6093 expr ::= expr * LT|GT|GE|LE expr
6094 expr ::= expr * EQ|NE expr
6095 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6096 expr ::= expr * PLUS|MINUS expr
6097 expr ::= expr * STAR|SLASH|REM expr
6098 expr ::= expr * CONCAT expr
6099 likeop ::= * LIKE_KW
6100 likeop ::= * NOT LIKE_KW
6102 likeop ::= * NOT MATCH
6103 expr ::= expr * likeop expr
6104 expr ::= expr * likeop expr ESCAPE expr
6105 expr ::= expr * ISNULL|NOTNULL
6106 expr ::= expr * NOT NULL
6107 expr ::= expr * IS expr
6108 expr ::= expr * IS NOT expr
6109 between_op ::= * BETWEEN
6110 between_op ::= * NOT BETWEEN
6111 expr ::= expr * between_op expr AND expr
6112 expr ::= expr between_op expr * AND expr
6115 expr ::= expr * in_op LP exprlist RP
6116 expr ::= expr * in_op LP select RP
6117 expr ::= expr * in_op nm dbnm
6151 (164) limit_opt ::= LIMIT expr OFFSET expr *
6152 expr ::= expr * COLLATE ids
6153 expr ::= expr * AND expr
6154 expr ::= expr * OR expr
6155 expr ::= expr * LT|GT|GE|LE expr
6156 expr ::= expr * EQ|NE expr
6157 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6158 expr ::= expr * PLUS|MINUS expr
6159 expr ::= expr * STAR|SLASH|REM expr
6160 expr ::= expr * CONCAT expr
6161 likeop ::= * LIKE_KW
6162 likeop ::= * NOT LIKE_KW
6164 likeop ::= * NOT MATCH
6165 expr ::= expr * likeop expr
6166 expr ::= expr * likeop expr ESCAPE expr
6167 expr ::= expr * ISNULL|NOTNULL
6168 expr ::= expr * NOT NULL
6169 expr ::= expr * IS expr
6170 expr ::= expr * IS NOT expr
6171 between_op ::= * BETWEEN
6172 between_op ::= * NOT BETWEEN
6173 expr ::= expr * between_op expr AND expr
6176 expr ::= expr * in_op LP exprlist RP
6177 expr ::= expr * in_op LP select RP
6178 expr ::= expr * in_op nm dbnm
6210 {default} reduce 164
6213 expr ::= expr * COLLATE ids
6214 expr ::= expr * AND expr
6215 expr ::= expr * OR expr
6216 (200) expr ::= expr OR expr *
6217 expr ::= expr * LT|GT|GE|LE expr
6218 expr ::= expr * EQ|NE expr
6219 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6220 expr ::= expr * PLUS|MINUS expr
6221 expr ::= expr * STAR|SLASH|REM expr
6222 expr ::= expr * CONCAT expr
6223 likeop ::= * LIKE_KW
6224 likeop ::= * NOT LIKE_KW
6226 likeop ::= * NOT MATCH
6227 expr ::= expr * likeop expr
6228 expr ::= expr * likeop expr ESCAPE expr
6229 expr ::= expr * ISNULL|NOTNULL
6230 expr ::= expr * NOT NULL
6231 expr ::= expr * IS expr
6232 expr ::= expr * IS NOT expr
6233 between_op ::= * BETWEEN
6234 between_op ::= * NOT BETWEEN
6235 expr ::= expr * between_op expr AND expr
6238 expr ::= expr * in_op LP exprlist RP
6239 expr ::= expr * in_op LP select RP
6240 expr ::= expr * in_op nm dbnm
6271 {default} reduce 200
6274 expr ::= expr * COLLATE ids
6275 expr ::= expr * AND expr
6276 expr ::= expr * OR expr
6277 expr ::= expr * LT|GT|GE|LE expr
6278 expr ::= expr * EQ|NE expr
6279 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6280 expr ::= expr * PLUS|MINUS expr
6281 expr ::= expr * STAR|SLASH|REM expr
6282 expr ::= expr * CONCAT expr
6283 likeop ::= * LIKE_KW
6284 likeop ::= * NOT LIKE_KW
6286 likeop ::= * NOT MATCH
6287 expr ::= expr * likeop expr
6288 expr ::= expr * likeop expr ESCAPE expr
6289 expr ::= expr * ISNULL|NOTNULL
6290 expr ::= expr * NOT NULL
6291 expr ::= expr * IS expr
6292 expr ::= expr * IS NOT expr
6293 (217) expr ::= NOT expr *
6294 between_op ::= * BETWEEN
6295 between_op ::= * NOT BETWEEN
6296 expr ::= expr * between_op expr AND expr
6299 expr ::= expr * in_op LP exprlist RP
6300 expr ::= expr * in_op LP select RP
6301 expr ::= expr * in_op nm dbnm
6331 {default} reduce 217
6334 expr ::= expr * COLLATE ids
6335 expr ::= expr * AND expr
6336 (199) expr ::= expr AND expr *
6337 expr ::= expr * OR expr
6338 expr ::= expr * LT|GT|GE|LE expr
6339 expr ::= expr * EQ|NE expr
6340 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6341 expr ::= expr * PLUS|MINUS expr
6342 expr ::= expr * STAR|SLASH|REM expr
6343 expr ::= expr * CONCAT expr
6344 likeop ::= * LIKE_KW
6345 likeop ::= * NOT LIKE_KW
6347 likeop ::= * NOT MATCH
6348 expr ::= expr * likeop expr
6349 expr ::= expr * likeop expr ESCAPE expr
6350 expr ::= expr * ISNULL|NOTNULL
6351 expr ::= expr * NOT NULL
6352 expr ::= expr * IS expr
6353 expr ::= expr * IS NOT expr
6354 between_op ::= * BETWEEN
6355 between_op ::= * NOT BETWEEN
6356 expr ::= expr * between_op expr AND expr
6359 expr ::= expr * in_op LP exprlist RP
6360 expr ::= expr * in_op LP select RP
6361 expr ::= expr * in_op nm dbnm
6391 {default} reduce 199
6394 expr ::= expr * COLLATE ids
6395 expr ::= expr * AND expr
6396 expr ::= expr * OR expr
6397 expr ::= expr * LT|GT|GE|LE expr
6398 expr ::= expr * EQ|NE expr
6399 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6400 expr ::= expr * PLUS|MINUS expr
6401 expr ::= expr * STAR|SLASH|REM expr
6402 expr ::= expr * CONCAT expr
6403 likeop ::= * LIKE_KW
6404 likeop ::= * NOT LIKE_KW
6406 likeop ::= * NOT MATCH
6407 expr ::= expr * likeop expr
6408 (211) expr ::= expr likeop expr *
6409 expr ::= expr * likeop expr ESCAPE expr
6410 expr ::= expr likeop expr * ESCAPE expr
6411 expr ::= expr * ISNULL|NOTNULL
6412 expr ::= expr * NOT NULL
6413 expr ::= expr * IS expr
6414 expr ::= expr * IS NOT expr
6415 between_op ::= * BETWEEN
6416 between_op ::= * NOT BETWEEN
6417 expr ::= expr * between_op expr AND expr
6420 expr ::= expr * in_op LP exprlist RP
6421 expr ::= expr * in_op LP select RP
6422 expr ::= expr * in_op nm dbnm
6443 {default} reduce 211
6446 expr ::= expr * COLLATE ids
6447 expr ::= expr * AND expr
6448 expr ::= expr * OR expr
6449 expr ::= expr * LT|GT|GE|LE expr
6450 expr ::= expr * EQ|NE expr
6451 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6452 expr ::= expr * PLUS|MINUS expr
6453 expr ::= expr * STAR|SLASH|REM expr
6454 expr ::= expr * CONCAT expr
6455 likeop ::= * LIKE_KW
6456 likeop ::= * NOT LIKE_KW
6458 likeop ::= * NOT MATCH
6459 expr ::= expr * likeop expr
6460 expr ::= expr * likeop expr ESCAPE expr
6461 expr ::= expr * ISNULL|NOTNULL
6462 expr ::= expr * NOT NULL
6463 expr ::= expr * IS expr
6464 expr ::= expr * IS NOT expr
6465 (216) expr ::= expr IS NOT expr *
6466 (217) expr ::= NOT expr *
6467 between_op ::= * BETWEEN
6468 between_op ::= * NOT BETWEEN
6469 expr ::= expr * between_op expr AND expr
6472 expr ::= expr * in_op LP exprlist RP
6473 expr ::= expr * in_op LP select RP
6474 expr ::= expr * in_op nm dbnm
6494 {default} reduce 216
6497 expr ::= expr * COLLATE ids
6498 expr ::= expr * AND expr
6499 (199) expr ::= expr AND expr *
6500 expr ::= expr * OR expr
6501 expr ::= expr * LT|GT|GE|LE expr
6502 expr ::= expr * EQ|NE expr
6503 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6504 expr ::= expr * PLUS|MINUS expr
6505 expr ::= expr * STAR|SLASH|REM expr
6506 expr ::= expr * CONCAT expr
6507 likeop ::= * LIKE_KW
6508 likeop ::= * NOT LIKE_KW
6510 likeop ::= * NOT MATCH
6511 expr ::= expr * likeop expr
6512 expr ::= expr * likeop expr ESCAPE expr
6513 expr ::= expr * ISNULL|NOTNULL
6514 expr ::= expr * NOT NULL
6515 expr ::= expr * IS expr
6516 expr ::= expr * IS NOT expr
6517 between_op ::= * BETWEEN
6518 between_op ::= * NOT BETWEEN
6519 expr ::= expr * between_op expr AND expr
6520 (223) expr ::= expr between_op expr AND expr *
6523 expr ::= expr * in_op LP exprlist RP
6524 expr ::= expr * in_op LP select RP
6525 expr ::= expr * in_op nm dbnm
6545 {default} reduce 223
6548 expr ::= expr * COLLATE ids
6549 expr ::= expr * AND expr
6550 expr ::= expr * OR expr
6551 expr ::= expr * LT|GT|GE|LE expr
6552 expr ::= expr * EQ|NE expr
6553 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6554 expr ::= expr * PLUS|MINUS expr
6555 expr ::= expr * STAR|SLASH|REM expr
6556 expr ::= expr * CONCAT expr
6557 likeop ::= * LIKE_KW
6558 likeop ::= * NOT LIKE_KW
6560 likeop ::= * NOT MATCH
6561 expr ::= expr * likeop expr
6562 expr ::= expr * likeop expr ESCAPE expr
6563 expr ::= expr * ISNULL|NOTNULL
6564 expr ::= expr * NOT NULL
6565 expr ::= expr * IS expr
6566 (215) expr ::= expr IS expr *
6567 expr ::= expr * IS NOT expr
6568 between_op ::= * BETWEEN
6569 between_op ::= * NOT BETWEEN
6570 expr ::= expr * between_op expr AND expr
6573 expr ::= expr * in_op LP exprlist RP
6574 expr ::= expr * in_op LP select RP
6575 expr ::= expr * in_op nm dbnm
6595 {default} reduce 215
6598 expr ::= expr * COLLATE ids
6599 expr ::= expr * AND expr
6600 expr ::= expr * OR expr
6601 expr ::= expr * LT|GT|GE|LE expr
6602 expr ::= expr * EQ|NE expr
6603 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6604 expr ::= expr * PLUS|MINUS expr
6605 expr ::= expr * STAR|SLASH|REM expr
6606 expr ::= expr * CONCAT expr
6607 likeop ::= * LIKE_KW
6608 likeop ::= * NOT LIKE_KW
6610 likeop ::= * NOT MATCH
6611 expr ::= expr * likeop expr
6612 expr ::= expr * likeop expr ESCAPE expr
6613 (212) expr ::= expr likeop expr ESCAPE expr *
6614 expr ::= expr * ISNULL|NOTNULL
6615 expr ::= expr * NOT NULL
6616 expr ::= expr * IS expr
6617 expr ::= expr * IS NOT expr
6618 between_op ::= * BETWEEN
6619 between_op ::= * NOT BETWEEN
6620 expr ::= expr * between_op expr AND expr
6623 expr ::= expr * in_op LP exprlist RP
6624 expr ::= expr * in_op LP select RP
6625 expr ::= expr * in_op nm dbnm
6645 {default} reduce 212
6648 expr ::= expr * COLLATE ids
6649 expr ::= expr * AND expr
6650 expr ::= expr * OR expr
6651 expr ::= expr * LT|GT|GE|LE expr
6652 expr ::= expr * EQ|NE expr
6653 (202) expr ::= expr EQ|NE expr *
6654 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6655 expr ::= expr * PLUS|MINUS expr
6656 expr ::= expr * STAR|SLASH|REM expr
6657 expr ::= expr * CONCAT expr
6658 likeop ::= * LIKE_KW
6659 likeop ::= * NOT LIKE_KW
6661 likeop ::= * NOT MATCH
6662 expr ::= expr * likeop expr
6663 expr ::= expr * likeop expr ESCAPE expr
6664 expr ::= expr * ISNULL|NOTNULL
6665 expr ::= expr * NOT NULL
6666 expr ::= expr * IS expr
6667 expr ::= expr * IS NOT expr
6668 between_op ::= * BETWEEN
6669 between_op ::= * NOT BETWEEN
6670 expr ::= expr * between_op expr AND expr
6673 expr ::= expr * in_op LP exprlist RP
6674 expr ::= expr * in_op LP select RP
6675 expr ::= expr * in_op nm dbnm
6695 {default} reduce 202
6698 expr ::= expr * COLLATE ids
6699 expr ::= expr * AND expr
6700 expr ::= expr * OR expr
6701 expr ::= expr * LT|GT|GE|LE expr
6702 (201) expr ::= expr LT|GT|GE|LE expr *
6703 expr ::= expr * EQ|NE expr
6704 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6705 expr ::= expr * PLUS|MINUS expr
6706 expr ::= expr * STAR|SLASH|REM expr
6707 expr ::= expr * CONCAT expr
6708 likeop ::= * LIKE_KW
6709 likeop ::= * NOT LIKE_KW
6711 likeop ::= * NOT MATCH
6712 expr ::= expr * likeop expr
6713 expr ::= expr * likeop expr ESCAPE expr
6714 expr ::= expr * ISNULL|NOTNULL
6715 expr ::= expr * NOT NULL
6716 expr ::= expr * IS expr
6717 expr ::= expr * IS NOT expr
6718 between_op ::= * BETWEEN
6719 between_op ::= * NOT BETWEEN
6720 expr ::= expr * between_op expr AND expr
6723 expr ::= expr * in_op LP exprlist RP
6724 expr ::= expr * in_op LP select RP
6725 expr ::= expr * in_op nm dbnm
6741 {default} reduce 201
6744 expr ::= expr * COLLATE ids
6745 expr ::= expr * AND expr
6746 expr ::= expr * OR expr
6747 expr ::= expr * LT|GT|GE|LE expr
6748 expr ::= expr * EQ|NE expr
6749 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6750 (203) expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr *
6751 expr ::= expr * PLUS|MINUS expr
6752 expr ::= expr * STAR|SLASH|REM expr
6753 expr ::= expr * CONCAT expr
6754 likeop ::= * LIKE_KW
6755 likeop ::= * NOT LIKE_KW
6757 likeop ::= * NOT MATCH
6758 expr ::= expr * likeop expr
6759 expr ::= expr * likeop expr ESCAPE expr
6760 expr ::= expr * ISNULL|NOTNULL
6761 expr ::= expr * NOT NULL
6762 expr ::= expr * IS expr
6763 expr ::= expr * IS NOT expr
6764 between_op ::= * BETWEEN
6765 between_op ::= * NOT BETWEEN
6766 expr ::= expr * between_op expr AND expr
6769 expr ::= expr * in_op LP exprlist RP
6770 expr ::= expr * in_op LP select RP
6771 expr ::= expr * in_op nm dbnm
6783 {default} reduce 203
6786 expr ::= expr * COLLATE ids
6787 expr ::= expr * AND expr
6788 expr ::= expr * OR expr
6789 expr ::= expr * LT|GT|GE|LE expr
6790 expr ::= expr * EQ|NE expr
6791 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
6792 expr ::= expr * PLUS|MINUS expr
6793 (204) expr ::= expr PLUS|MINUS expr *
6794 expr ::= expr * STAR|SLASH|REM expr
6795 expr ::= expr * CONCAT expr
6796 likeop ::= * LIKE_KW
6797 likeop ::= * NOT LIKE_KW
6799 likeop ::= * NOT MATCH
6800 expr ::= expr * likeop expr
6801 expr ::= expr * likeop expr ESCAPE expr
6802 expr ::= expr * ISNULL|NOTNULL
6803 expr ::= expr * NOT NULL
6804 expr ::= expr * IS expr
6805 expr ::= expr * IS NOT expr
6806 between_op ::= * BETWEEN
6807 between_op ::= * NOT BETWEEN
6808 expr ::= expr * between_op expr AND expr
6811 expr ::= expr * in_op LP exprlist RP
6812 expr ::= expr * in_op LP select RP
6813 expr ::= expr * in_op nm dbnm
6823 {default} reduce 204
6831 fullname ::= * nm dbnm
6832 cmd ::= insert_cmd INTO * fullname inscollist_opt valuelist
6833 cmd ::= insert_cmd INTO * fullname inscollist_opt select
6834 cmd ::= insert_cmd INTO * fullname inscollist_opt DEFAULT VALUES
6850 cmd ::= UPDATE orconf fullname indexed_opt SET * setlist where_opt
6851 setlist ::= * setlist COMMA nm EQ expr
6852 setlist ::= * nm EQ expr
6868 fullname ::= * nm dbnm
6869 cmd ::= UPDATE orconf * fullname indexed_opt SET setlist where_opt
6885 fullname ::= * nm dbnm
6886 cmd ::= DELETE FROM * fullname indexed_opt where_opt
6902 fullname ::= * nm dbnm
6903 cmd ::= DROP TRIGGER ifexists * fullname
6919 fullname ::= * nm dbnm
6920 cmd ::= DROP INDEX ifexists * fullname
6936 cmd ::= DROP VIEW ifexists * fullname
6937 fullname ::= * nm dbnm
6953 cmd ::= DROP TABLE ifexists * fullname
6954 fullname ::= * nm dbnm
6971 trnm ::= * nm DOT nm
6972 trigger_cmd ::= DELETE FROM * trnm tridxby where_opt
6988 inscollist_opt ::= LP * inscollist RP
6989 inscollist ::= * inscollist COMMA nm
6998 inscollist shift 319
7007 trnm ::= * nm DOT nm
7008 trigger_cmd ::= insert_cmd INTO * trnm inscollist_opt valuelist
7009 trigger_cmd ::= insert_cmd INTO * trnm inscollist_opt select
7025 setlist ::= * setlist COMMA nm EQ expr
7026 setlist ::= * nm EQ expr
7027 trigger_cmd ::= UPDATE orconf trnm tridxby SET * setlist where_opt
7044 trnm ::= * nm DOT nm
7045 trigger_cmd ::= UPDATE orconf * trnm tridxby SET setlist where_opt
7061 cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP * idxlist RP where_opt
7062 idxlist ::= * idxlist COMMA nm collate sortorder
7063 idxlist ::= * nm collate sortorder
7079 inscollist ::= * inscollist COMMA nm
7081 trigger_event ::= UPDATE OF * inscollist
7089 inscollist shift 365
7097 fullname ::= * nm dbnm
7098 trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON * fullname foreach_clause when_clause
7109 create_table ::= createkw * temp TABLE ifnotexists nm dbnm
7112 cmd ::= createkw * temp VIEW ifnotexists nm dbnm AS select
7113 cmd ::= createkw * uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP where_opt
7114 uniqueflag ::= * UNIQUE
7115 (244) uniqueflag ::= *
7116 cmd ::= createkw * trigger_decl BEGIN trigger_cmd_list END
7117 trigger_decl ::= * temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause
7118 create_vtab ::= createkw * VIRTUAL TABLE ifnotexists nm dbnm USING nm
7125 uniqueflag shift 363
7126 trigger_decl shift 360
7130 refargs ::= refargs * refarg
7131 refarg ::= * MATCH nm
7132 refarg ::= * ON INSERT refact
7133 refarg ::= * ON DELETE refact
7134 refarg ::= * ON UPDATE refact
7135 defer_subclause ::= * NOT DEFERRABLE init_deferred_pred_opt
7136 defer_subclause ::= * DEFERRABLE init_deferred_pred_opt
7137 tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs * defer_subclause_opt
7138 (98) defer_subclause_opt ::= *
7139 defer_subclause_opt ::= * defer_subclause
7144 DEFERRABLE shift 272
7145 defer_subclause shift 483
7147 defer_subclause_opt shift 484
7156 tcons ::= FOREIGN KEY LP * idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt
7157 idxlist ::= * idxlist COMMA nm collate sortorder
7158 idxlist ::= * nm collate sortorder
7174 tcons ::= UNIQUE LP * idxlist RP onconf
7175 idxlist ::= * idxlist COMMA nm collate sortorder
7176 idxlist ::= * nm collate sortorder
7192 tcons ::= PRIMARY KEY LP * idxlist autoinc RP onconf
7193 idxlist ::= * idxlist COMMA nm collate sortorder
7194 idxlist ::= * nm collate sortorder
7210 idxlist_opt ::= LP * idxlist RP
7211 idxlist ::= * idxlist COMMA nm collate sortorder
7212 idxlist ::= * nm collate sortorder
7228 using_opt ::= USING LP * inscollist RP
7229 inscollist ::= * inscollist COMMA nm
7238 inscollist shift 327
7241 select ::= * oneselect
7242 select ::= * select multiselect_op oneselect
7243 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
7244 cmd ::= insert_cmd INTO fullname inscollist_opt * valuelist
7245 cmd ::= insert_cmd INTO fullname inscollist_opt * select
7246 cmd ::= insert_cmd INTO fullname inscollist_opt * DEFAULT VALUES
7247 valuelist ::= * VALUES LP nexprlist RP
7248 valuelist ::= * valuelist COMMA LP exprlist RP
7258 select ::= * oneselect
7259 select ::= * select multiselect_op oneselect
7260 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
7261 valuelist ::= * VALUES LP nexprlist RP
7262 valuelist ::= * valuelist COMMA LP exprlist RP
7263 trigger_cmd ::= insert_cmd INTO trnm inscollist_opt * valuelist
7264 trigger_cmd ::= insert_cmd INTO trnm inscollist_opt * select
7274 typetoken ::= * typename
7275 typetoken ::= * typename LP signed RP
7276 typetoken ::= * typename LP signed COMMA signed RP
7278 typename ::= * typename ids
7279 expr ::= CAST LP expr AS * typetoken RP
7288 expr ::= expr * COLLATE ids
7289 expr ::= expr * AND expr
7290 expr ::= expr * OR expr
7291 expr ::= expr * LT|GT|GE|LE expr
7292 expr ::= expr * EQ|NE expr
7293 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
7294 expr ::= expr * PLUS|MINUS expr
7295 expr ::= expr * STAR|SLASH|REM expr
7296 (205) expr ::= expr STAR|SLASH|REM expr *
7297 expr ::= expr * CONCAT expr
7298 likeop ::= * LIKE_KW
7299 likeop ::= * NOT LIKE_KW
7301 likeop ::= * NOT MATCH
7302 expr ::= expr * likeop expr
7303 expr ::= expr * likeop expr ESCAPE expr
7304 expr ::= expr * ISNULL|NOTNULL
7305 expr ::= expr * NOT NULL
7306 expr ::= expr * IS expr
7307 expr ::= expr * IS NOT expr
7308 between_op ::= * BETWEEN
7309 between_op ::= * NOT BETWEEN
7310 expr ::= expr * between_op expr AND expr
7313 expr ::= expr * in_op LP exprlist RP
7314 expr ::= expr * in_op LP select RP
7315 expr ::= expr * in_op nm dbnm
7322 {default} reduce 205
7325 expr ::= expr * COLLATE ids
7326 expr ::= expr * AND expr
7327 expr ::= expr * OR expr
7328 expr ::= expr * LT|GT|GE|LE expr
7329 expr ::= expr * EQ|NE expr
7330 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
7331 expr ::= expr * PLUS|MINUS expr
7332 expr ::= expr * STAR|SLASH|REM expr
7333 expr ::= expr * CONCAT expr
7334 (206) expr ::= expr CONCAT expr *
7335 likeop ::= * LIKE_KW
7336 likeop ::= * NOT LIKE_KW
7338 likeop ::= * NOT MATCH
7339 expr ::= expr * likeop expr
7340 expr ::= expr * likeop expr ESCAPE expr
7341 expr ::= expr * ISNULL|NOTNULL
7342 expr ::= expr * NOT NULL
7343 expr ::= expr * IS expr
7344 expr ::= expr * IS NOT expr
7345 between_op ::= * BETWEEN
7346 between_op ::= * NOT BETWEEN
7347 expr ::= expr * between_op expr AND expr
7350 expr ::= expr * in_op LP exprlist RP
7351 expr ::= expr * in_op LP select RP
7352 expr ::= expr * in_op nm dbnm
7358 {default} reduce 206
7361 expr ::= expr * COLLATE ids
7362 expr ::= expr * AND expr
7363 expr ::= expr * OR expr
7364 expr ::= expr * LT|GT|GE|LE expr
7365 expr ::= expr * EQ|NE expr
7366 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
7367 expr ::= expr * PLUS|MINUS expr
7368 expr ::= expr * STAR|SLASH|REM expr
7369 expr ::= expr * CONCAT expr
7370 likeop ::= * LIKE_KW
7371 likeop ::= * NOT LIKE_KW
7373 likeop ::= * NOT MATCH
7374 expr ::= expr * likeop expr
7375 expr ::= expr * likeop expr ESCAPE expr
7376 expr ::= expr * ISNULL|NOTNULL
7377 expr ::= expr * NOT NULL
7378 expr ::= expr * IS expr
7379 expr ::= expr * IS NOT expr
7380 (220) expr ::= PLUS expr *
7381 between_op ::= * BETWEEN
7382 between_op ::= * NOT BETWEEN
7383 expr ::= expr * between_op expr AND expr
7386 expr ::= expr * in_op LP exprlist RP
7387 expr ::= expr * in_op LP select RP
7388 expr ::= expr * in_op nm dbnm
7393 {default} reduce 220
7396 expr ::= expr * COLLATE ids
7397 expr ::= expr * AND expr
7398 expr ::= expr * OR expr
7399 expr ::= expr * LT|GT|GE|LE expr
7400 expr ::= expr * EQ|NE expr
7401 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
7402 expr ::= expr * PLUS|MINUS expr
7403 expr ::= expr * STAR|SLASH|REM expr
7404 expr ::= expr * CONCAT expr
7405 likeop ::= * LIKE_KW
7406 likeop ::= * NOT LIKE_KW
7408 likeop ::= * NOT MATCH
7409 expr ::= expr * likeop expr
7410 expr ::= expr * likeop expr ESCAPE expr
7411 expr ::= expr * ISNULL|NOTNULL
7412 expr ::= expr * NOT NULL
7413 expr ::= expr * IS expr
7414 expr ::= expr * IS NOT expr
7415 (219) expr ::= MINUS expr *
7416 between_op ::= * BETWEEN
7417 between_op ::= * NOT BETWEEN
7418 expr ::= expr * between_op expr AND expr
7421 expr ::= expr * in_op LP exprlist RP
7422 expr ::= expr * in_op LP select RP
7423 expr ::= expr * in_op nm dbnm
7428 {default} reduce 219
7431 expr ::= expr * COLLATE ids
7432 expr ::= expr * AND expr
7433 expr ::= expr * OR expr
7434 expr ::= expr * LT|GT|GE|LE expr
7435 expr ::= expr * EQ|NE expr
7436 expr ::= expr * BITAND|BITOR|LSHIFT|RSHIFT expr
7437 expr ::= expr * PLUS|MINUS expr
7438 expr ::= expr * STAR|SLASH|REM expr
7439 expr ::= expr * CONCAT expr
7440 likeop ::= * LIKE_KW
7441 likeop ::= * NOT LIKE_KW
7443 likeop ::= * NOT MATCH
7444 expr ::= expr * likeop expr
7445 expr ::= expr * likeop expr ESCAPE expr
7446 expr ::= expr * ISNULL|NOTNULL
7447 expr ::= expr * NOT NULL
7448 expr ::= expr * IS expr
7449 expr ::= expr * IS NOT expr
7450 (218) expr ::= BITNOT expr *
7451 between_op ::= * BETWEEN
7452 between_op ::= * NOT BETWEEN
7453 expr ::= expr * between_op expr AND expr
7456 expr ::= expr * in_op LP exprlist RP
7457 expr ::= expr * in_op LP select RP
7458 expr ::= expr * in_op nm dbnm
7463 {default} reduce 218
7468 ccons ::= DEFAULT * term
7469 ccons ::= DEFAULT * LP expr RP
7470 ccons ::= DEFAULT * PLUS term
7471 ccons ::= DEFAULT * MINUS term
7472 ccons ::= DEFAULT * id
7474 term ::= * INTEGER|FLOAT|BLOB
7493 (36) column ::= columnid type carglist *
7494 carglist ::= carglist * ccons
7495 ccons ::= * CONSTRAINT nm
7496 ccons ::= * DEFAULT term
7497 ccons ::= * DEFAULT LP expr RP
7498 ccons ::= * DEFAULT PLUS term
7499 ccons ::= * DEFAULT MINUS term
7500 ccons ::= * DEFAULT id
7501 ccons ::= * NULL onconf
7502 ccons ::= * NOT NULL onconf
7503 ccons ::= * PRIMARY KEY sortorder onconf autoinc
7504 ccons ::= * UNIQUE onconf
7505 ccons ::= * CHECK LP expr RP
7506 ccons ::= * REFERENCES nm idxlist_opt refargs
7507 ccons ::= * defer_subclause
7508 ccons ::= * COLLATE ids
7509 defer_subclause ::= * NOT DEFERRABLE init_deferred_pred_opt
7510 defer_subclause ::= * DEFERRABLE init_deferred_pred_opt
7514 CONSTRAINT shift 176
7520 REFERENCES shift 168
7521 DEFERRABLE shift 272
7523 defer_subclause shift 494
7527 orconf ::= OR * resolvetype
7528 resolvetype ::= * raisetype
7529 resolvetype ::= * IGNORE
7530 resolvetype ::= * REPLACE
7531 raisetype ::= * ROLLBACK
7532 raisetype ::= * ABORT
7533 raisetype ::= * FAIL
7540 resolvetype shift 467
7544 onconf ::= ON CONFLICT * resolvetype
7545 resolvetype ::= * raisetype
7546 resolvetype ::= * IGNORE
7547 resolvetype ::= * REPLACE
7548 raisetype ::= * ROLLBACK
7549 raisetype ::= * ABORT
7550 raisetype ::= * FAIL
7557 resolvetype shift 520
7566 selcollist ::= sclp nm DOT * STAR
7567 expr ::= nm DOT * nm
7568 expr ::= nm DOT * nm DOT nm
7584 seltablist ::= stl_prefix * nm dbnm as indexed_opt on_opt using_opt
7585 seltablist ::= stl_prefix * LP select RP as on_opt using_opt
7586 seltablist ::= stl_prefix * LP seltablist RP as on_opt using_opt
7602 joinop ::= JOIN_KW nm * JOIN
7603 joinop ::= JOIN_KW nm * nm JOIN
7619 joinop ::= JOIN_KW * JOIN
7620 joinop ::= JOIN_KW * nm JOIN
7621 joinop ::= JOIN_KW * nm nm JOIN
7637 expr ::= expr in_op * LP exprlist RP
7638 expr ::= expr in_op * LP select RP
7639 expr ::= expr in_op * nm dbnm
7650 (317) vtabarglist ::= vtabarg *
7651 vtabarg ::= vtabarg * vtabargtoken
7652 vtabargtoken ::= * ANY
7653 vtabargtoken ::= * lp anylist RP
7660 vtabargtoken shift 425
7664 (318) vtabarglist ::= vtabarglist COMMA vtabarg *
7665 vtabarg ::= vtabarg * vtabargtoken
7666 vtabargtoken ::= * ANY
7667 vtabargtoken ::= * lp anylist RP
7674 vtabargtoken shift 425
7683 cmd ::= ALTER TABLE fullname RENAME TO * nm
7698 (307) cmd ::= ANALYZE *
7699 cmd ::= ANALYZE * nm dbnm
7707 {default} reduce 307
7715 (305) cmd ::= REINDEX *
7716 cmd ::= REINDEX * nm dbnm
7724 {default} reduce 305
7732 cmd ::= PRAGMA * nm dbnm
7733 cmd ::= PRAGMA * nm dbnm EQ nmnum
7734 cmd ::= PRAGMA * nm dbnm LP nmnum RP
7735 cmd ::= PRAGMA * nm dbnm EQ minus_num
7736 cmd ::= PRAGMA * nm dbnm LP minus_num RP
7751 (252) cmd ::= VACUUM *
7760 {default} reduce 252
7768 create_vtab ::= createkw VIRTUAL TABLE ifnotexists nm dbnm USING * nm
7783 create_vtab ::= createkw VIRTUAL TABLE ifnotexists * nm dbnm USING nm
7798 setlist ::= setlist COMMA * nm EQ expr
7813 tridxby ::= INDEXED BY * nm
7828 trnm ::= nm DOT * nm
7843 cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON * nm LP idxlist RP where_opt
7858 cmd ::= createkw uniqueflag INDEX ifnotexists * nm dbnm ON nm LP idxlist RP where_opt
7873 trigger_decl ::= temp TRIGGER ifnotexists * nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause
7888 cmd ::= createkw temp VIEW ifnotexists * nm dbnm AS select
7898 create_table ::= createkw temp TABLE ifnotexists * nm dbnm
7918 tcons ::= FOREIGN KEY LP idxlist RP REFERENCES * nm idxlist_opt refargs defer_subclause_opt
7933 tcons ::= CONSTRAINT * nm
7948 idxlist ::= idxlist COMMA * nm collate sortorder
7963 refarg ::= MATCH * nm
7978 ccons ::= REFERENCES * nm idxlist_opt refargs
7993 indexed_opt ::= INDEXED BY * nm
8008 inscollist ::= inscollist COMMA * nm
8053 expr ::= RAISE LP raisetype COMMA * nm RP
8068 expr ::= nm DOT nm DOT * nm
8083 expr ::= nm DOT * nm
8084 expr ::= nm DOT * nm DOT nm
8099 ccons ::= CONSTRAINT * nm
8109 cmd ::= RELEASE savepoint_opt * nm
8124 cmd ::= SAVEPOINT * nm
8139 cmd ::= ROLLBACK trans_opt TO savepoint_opt * nm
8154 (11) trans_opt ::= TRANSACTION *
8155 trans_opt ::= TRANSACTION * nm
8175 seltablist ::= stl_prefix LP seltablist RP * as on_opt using_opt
8182 {default} reduce 129
8189 seltablist ::= stl_prefix LP select RP * as on_opt using_opt
8196 {default} reduce 129
8203 seltablist ::= stl_prefix nm dbnm * as indexed_opt on_opt using_opt
8210 {default} reduce 129
8213 (0) input ::= cmdlist *
8214 cmdlist ::= cmdlist * ecmd
8216 ecmd ::= * explain cmdx SEMI
8218 explain ::= * EXPLAIN
8219 explain ::= * EXPLAIN QUERY PLAN
8229 cmd ::= createkw temp VIEW ifnotexists nm dbnm AS * select
8230 select ::= * oneselect
8231 select ::= * select multiselect_op oneselect
8232 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
8239 create_table_args ::= AS * select
8240 select ::= * oneselect
8241 select ::= * select multiselect_op oneselect
8242 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
8249 select ::= * oneselect
8250 select ::= * select multiselect_op oneselect
8251 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
8252 expr ::= EXISTS LP * select RP
8259 cmd ::= create_vtab LP * vtabarglist RP
8260 vtabarglist ::= * vtabarg
8261 vtabarglist ::= * vtabarglist COMMA vtabarg
8263 vtabarg ::= * vtabarg vtabargtoken
8265 vtabarglist shift 316
8267 {default} reduce 319
8270 from ::= FROM * seltablist
8271 stl_prefix ::= * seltablist joinop
8272 (133) stl_prefix ::= *
8273 seltablist ::= * stl_prefix nm dbnm as indexed_opt on_opt using_opt
8274 seltablist ::= * stl_prefix LP select RP as on_opt using_opt
8275 seltablist ::= * stl_prefix LP seltablist RP as on_opt using_opt
8277 seltablist shift 211
8278 stl_prefix shift 143
8279 {default} reduce 133
8282 oneselect ::= SELECT distinct * selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
8283 sclp ::= * selcollist COMMA
8285 selcollist ::= * sclp expr as
8286 selcollist ::= * sclp STAR
8287 selcollist ::= * sclp nm DOT STAR
8289 selcollist shift 234
8291 {default} reduce 123
8294 ccons ::= DEFAULT MINUS * term
8296 term ::= * INTEGER|FLOAT|BLOB
8309 ccons ::= DEFAULT PLUS * term
8311 term ::= * INTEGER|FLOAT|BLOB
8324 conslist ::= conslist tconscomma * tcons
8325 tcons ::= * CONSTRAINT nm
8326 tcons ::= * PRIMARY KEY LP idxlist autoinc RP onconf
8327 tcons ::= * UNIQUE LP idxlist RP onconf
8328 tcons ::= * CHECK LP expr RP onconf
8329 tcons ::= * FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt
8331 CONSTRAINT shift 165
8339 refarg ::= ON UPDATE * refact
8340 refact ::= * SET NULL
8341 refact ::= * SET DEFAULT
8342 refact ::= * CASCADE
8343 refact ::= * RESTRICT
8344 refact ::= * NO ACTION
8353 refarg ::= ON DELETE * refact
8354 refact ::= * SET NULL
8355 refact ::= * SET DEFAULT
8356 refact ::= * CASCADE
8357 refact ::= * RESTRICT
8358 refact ::= * NO ACTION
8367 refarg ::= ON INSERT * refact
8368 refact ::= * SET NULL
8369 refact ::= * SET DEFAULT
8370 refact ::= * CASCADE
8371 refact ::= * RESTRICT
8372 refact ::= * NO ACTION
8381 stl_prefix ::= seltablist * joinop
8382 seltablist ::= stl_prefix LP seltablist * RP as on_opt using_opt
8383 joinop ::= * COMMA|JOIN
8384 joinop ::= * JOIN_KW JOIN
8385 joinop ::= * JOIN_KW nm JOIN
8386 joinop ::= * JOIN_KW nm nm JOIN
8395 select ::= select * multiselect_op oneselect
8396 multiselect_op ::= * UNION
8397 multiselect_op ::= * UNION ALL
8398 multiselect_op ::= * EXCEPT|INTERSECT
8399 seltablist ::= stl_prefix LP select * RP as on_opt using_opt
8405 multiselect_op shift 296
8408 expr ::= RAISE LP * IGNORE RP
8409 expr ::= RAISE LP * raisetype COMMA nm RP
8410 raisetype ::= * ROLLBACK
8411 raisetype ::= * ABORT
8412 raisetype ::= * FAIL
8421 select ::= select * multiselect_op oneselect
8422 multiselect_op ::= * UNION
8423 multiselect_op ::= * UNION ALL
8424 multiselect_op ::= * EXCEPT|INTERSECT
8425 expr ::= EXISTS LP select * RP
8431 multiselect_op shift 296
8434 select ::= select * multiselect_op oneselect
8435 multiselect_op ::= * UNION
8436 multiselect_op ::= * UNION ALL
8437 multiselect_op ::= * EXCEPT|INTERSECT
8438 expr ::= expr in_op LP select * RP
8444 multiselect_op shift 296
8447 select ::= select * multiselect_op oneselect
8448 multiselect_op ::= * UNION
8449 multiselect_op ::= * UNION ALL
8450 multiselect_op ::= * EXCEPT|INTERSECT
8451 expr ::= LP select * RP
8457 multiselect_op shift 296
8460 select ::= select * multiselect_op oneselect
8461 multiselect_op ::= * UNION
8462 multiselect_op ::= * UNION ALL
8463 multiselect_op ::= * EXCEPT|INTERSECT
8464 (173) cmd ::= insert_cmd INTO fullname inscollist_opt select *
8469 multiselect_op shift 296
8470 {default} reduce 173
8473 (112) cmd ::= select *
8474 select ::= select * multiselect_op oneselect
8475 multiselect_op ::= * UNION
8476 multiselect_op ::= * UNION ALL
8477 multiselect_op ::= * EXCEPT|INTERSECT
8482 multiselect_op shift 296
8483 {default} reduce 112
8486 select ::= select * multiselect_op oneselect
8487 multiselect_op ::= * UNION
8488 multiselect_op ::= * UNION ALL
8489 multiselect_op ::= * EXCEPT|INTERSECT
8490 (290) trigger_cmd ::= insert_cmd INTO trnm inscollist_opt select *
8495 multiselect_op shift 296
8496 {default} reduce 290
8499 select ::= select * multiselect_op oneselect
8500 multiselect_op ::= * UNION
8501 multiselect_op ::= * UNION ALL
8502 multiselect_op ::= * EXCEPT|INTERSECT
8503 (292) trigger_cmd ::= select *
8508 multiselect_op shift 296
8509 {default} reduce 292
8512 trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time * trigger_event ON fullname foreach_clause when_clause
8513 trigger_event ::= * DELETE|INSERT
8514 trigger_event ::= * UPDATE
8515 trigger_event ::= * UPDATE OF inscollist
8520 trigger_event shift 369
8523 trigger_decl ::= temp TRIGGER ifnotexists nm dbnm * trigger_time trigger_event ON fullname foreach_clause when_clause
8524 trigger_time ::= * BEFORE
8525 trigger_time ::= * AFTER
8526 trigger_time ::= * INSTEAD OF
8527 (273) trigger_time ::= *
8532 trigger_time shift 207
8533 {default} reduce 273
8536 (110) cmd ::= createkw temp VIEW ifnotexists nm dbnm AS select *
8537 select ::= select * multiselect_op oneselect
8538 multiselect_op ::= * UNION
8539 multiselect_op ::= * UNION ALL
8540 multiselect_op ::= * EXCEPT|INTERSECT
8545 multiselect_op shift 296
8546 {default} reduce 110
8549 (33) create_table_args ::= AS select *
8550 select ::= select * multiselect_op oneselect
8551 multiselect_op ::= * UNION
8552 multiselect_op ::= * UNION ALL
8553 multiselect_op ::= * EXCEPT|INTERSECT
8558 multiselect_op shift 296
8562 (131) from ::= FROM seltablist *
8563 stl_prefix ::= seltablist * joinop
8564 joinop ::= * COMMA|JOIN
8565 joinop ::= * JOIN_KW JOIN
8566 joinop ::= * JOIN_KW nm JOIN
8567 joinop ::= * JOIN_KW nm nm JOIN
8573 {default} reduce 131
8577 (46) typetoken ::= typename *
8578 typetoken ::= typename * LP signed RP
8579 typetoken ::= typename * LP signed COMMA signed RP
8580 typename ::= typename * ids
8589 distinct ::= * DISTINCT
8591 (121) distinct ::= *
8592 expr ::= ID LP * distinct exprlist RP
8593 expr ::= ID LP * STAR RP
8599 {default} reduce 121
8602 cmd ::= BEGIN * transtype trans_opt
8603 (13) transtype ::= *
8604 transtype ::= * DEFERRED
8605 transtype ::= * IMMEDIATE
8606 transtype ::= * EXCLUSIVE
8615 (167) where_opt ::= *
8616 where_opt ::= * WHERE expr
8617 cmd ::= UPDATE orconf fullname indexed_opt SET setlist * where_opt
8618 setlist ::= setlist * COMMA nm EQ expr
8623 {default} reduce 167
8626 (146) indexed_opt ::= *
8627 indexed_opt ::= * INDEXED BY nm
8628 indexed_opt ::= * NOT INDEXED
8629 cmd ::= UPDATE orconf fullname * indexed_opt SET setlist where_opt
8633 indexed_opt shift 341
8634 {default} reduce 146
8637 (146) indexed_opt ::= *
8638 indexed_opt ::= * INDEXED BY nm
8639 indexed_opt ::= * NOT INDEXED
8640 cmd ::= DELETE FROM fullname * indexed_opt where_opt
8644 indexed_opt shift 245
8645 {default} reduce 146
8649 tridxby ::= * INDEXED BY nm
8650 tridxby ::= * NOT INDEXED
8651 trigger_cmd ::= DELETE FROM trnm * tridxby where_opt
8656 {default} reduce 285
8659 (167) where_opt ::= *
8660 where_opt ::= * WHERE expr
8661 setlist ::= setlist * COMMA nm EQ expr
8662 trigger_cmd ::= UPDATE orconf trnm tridxby SET setlist * where_opt
8667 {default} reduce 167
8671 tridxby ::= * INDEXED BY nm
8672 tridxby ::= * NOT INDEXED
8673 trigger_cmd ::= UPDATE orconf trnm * tridxby SET setlist where_opt
8678 {default} reduce 285
8682 autoinc ::= * AUTOINCR
8683 tcons ::= PRIMARY KEY LP idxlist * autoinc RP onconf
8684 idxlist ::= idxlist * COMMA nm collate sortorder
8692 (88) conslist_opt ::= COMMA conslist *
8693 conslist ::= conslist * tconscomma tcons
8694 tconscomma ::= * COMMA
8695 (92) tconscomma ::= *
8699 tconscomma shift 193
8704 ccons ::= COLLATE * ids
8712 sortorder ::= * DESC
8713 (157) sortorder ::= *
8714 idxlist ::= nm collate * sortorder
8719 {default} reduce 157
8723 collate ::= COLLATE * ids
8731 sortorder ::= * DESC
8732 (157) sortorder ::= *
8733 idxlist ::= idxlist COMMA nm collate * sortorder
8738 {default} reduce 157
8741 (66) ccons ::= REFERENCES nm idxlist_opt refargs *
8742 refargs ::= refargs * refarg
8743 refarg ::= * MATCH nm
8744 refarg ::= * ON INSERT refact
8745 refarg ::= * ON DELETE refact
8746 refarg ::= * ON UPDATE refact
8754 ccons ::= PRIMARY KEY * sortorder onconf autoinc
8756 sortorder ::= * DESC
8757 (157) sortorder ::= *
8762 {default} reduce 157
8765 seltablist ::= stl_prefix nm dbnm as * indexed_opt on_opt using_opt
8766 (146) indexed_opt ::= *
8767 indexed_opt ::= * INDEXED BY nm
8768 indexed_opt ::= * NOT INDEXED
8772 indexed_opt shift 287
8773 {default} reduce 146
8776 expr ::= CASE case_operand case_exprlist * case_else END
8777 case_exprlist ::= case_exprlist * WHEN expr THEN expr
8778 case_else ::= * ELSE expr
8779 (235) case_else ::= *
8784 {default} reduce 235
8787 minus_num ::= MINUS * number
8788 number ::= * INTEGER|FLOAT
8795 plus_num ::= PLUS * number
8796 number ::= * INTEGER|FLOAT
8804 expr ::= expr COLLATE * ids
8811 oneselect ::= SELECT distinct selcollist * from where_opt groupby_opt having_opt orderby_opt limit_opt
8812 sclp ::= selcollist * COMMA
8814 from ::= * FROM seltablist
8819 {default} reduce 130
8822 oneselect ::= SELECT * distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
8823 distinct ::= * DISTINCT
8825 (121) distinct ::= *
8830 {default} reduce 121
8833 cmd ::= create_table * create_table_args
8834 create_table_args ::= * LP columnlist conslist_opt RP
8835 create_table_args ::= * AS select
8839 create_table_args shift 607
8842 cmd ::= ALTER TABLE add_column_fullname ADD * kwcolumn_opt column
8843 (312) kwcolumn_opt ::= *
8844 kwcolumn_opt ::= * COLUMNKW
8847 kwcolumn_opt shift 63
8848 {default} reduce 312
8853 cmd ::= ANALYZE nm * dbnm
8857 {default} reduce 137
8862 cmd ::= REINDEX nm * dbnm
8866 {default} reduce 137
8869 cmd ::= DETACH * database_kw_opt expr
8870 database_kw_opt ::= * DATABASE
8871 (304) database_kw_opt ::= *
8874 database_kw_opt shift 20
8875 {default} reduce 304
8878 cmd ::= ATTACH * database_kw_opt expr AS expr key_opt
8879 database_kw_opt ::= * DATABASE
8880 (304) database_kw_opt ::= *
8883 database_kw_opt shift 23
8884 {default} reduce 304
8889 cmd ::= PRAGMA nm * dbnm
8890 cmd ::= PRAGMA nm * dbnm EQ nmnum
8891 cmd ::= PRAGMA nm * dbnm LP nmnum RP
8892 cmd ::= PRAGMA nm * dbnm EQ minus_num
8893 cmd ::= PRAGMA nm * dbnm LP minus_num RP
8897 {default} reduce 137
8900 cmd ::= insert_cmd INTO fullname * inscollist_opt valuelist
8901 cmd ::= insert_cmd INTO fullname * inscollist_opt select
8902 cmd ::= insert_cmd INTO fullname * inscollist_opt DEFAULT VALUES
8903 (179) inscollist_opt ::= *
8904 inscollist_opt ::= * LP inscollist RP
8907 inscollist_opt shift 130
8908 {default} reduce 179
8912 orconf ::= * OR resolvetype
8913 cmd ::= UPDATE * orconf fullname indexed_opt SET setlist where_opt
8917 {default} reduce 102
8920 cmd ::= DELETE FROM fullname indexed_opt * where_opt
8921 (167) where_opt ::= *
8922 where_opt ::= * WHERE expr
8926 {default} reduce 167
8929 ifexists ::= * IF EXISTS
8930 (109) ifexists ::= *
8931 cmd ::= DROP TRIGGER * ifexists fullname
8935 {default} reduce 109
8938 ifexists ::= * IF EXISTS
8939 (109) ifexists ::= *
8940 cmd ::= DROP INDEX * ifexists fullname
8944 {default} reduce 109
8947 ifexists ::= * IF EXISTS
8948 (109) ifexists ::= *
8949 cmd ::= DROP VIEW * ifexists fullname
8953 {default} reduce 109
8956 cmd ::= DROP TABLE * ifexists fullname
8957 ifexists ::= * IF EXISTS
8958 (109) ifexists ::= *
8962 {default} reduce 109
8967 create_vtab ::= createkw VIRTUAL TABLE ifnotexists nm * dbnm USING nm
8971 {default} reduce 137
8974 (28) ifnotexists ::= *
8975 ifnotexists ::= * IF NOT EXISTS
8976 create_vtab ::= createkw VIRTUAL TABLE * ifnotexists nm dbnm USING nm
8979 ifnotexists shift 155
8983 (167) where_opt ::= *
8984 where_opt ::= * WHERE expr
8985 trigger_cmd ::= DELETE FROM trnm tridxby * where_opt
8989 {default} reduce 167
8992 (179) inscollist_opt ::= *
8993 inscollist_opt ::= * LP inscollist RP
8994 trigger_cmd ::= insert_cmd INTO trnm * inscollist_opt valuelist
8995 trigger_cmd ::= insert_cmd INTO trnm * inscollist_opt select
8998 inscollist_opt shift 131
8999 {default} reduce 179
9003 orconf ::= * OR resolvetype
9004 trigger_cmd ::= UPDATE * orconf trnm tridxby SET setlist where_opt
9008 {default} reduce 102
9012 orconf ::= * OR resolvetype
9013 insert_cmd ::= INSERT * orconf
9017 {default} reduce 102
9020 (167) where_opt ::= *
9021 where_opt ::= * WHERE expr
9022 cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP * where_opt
9026 {default} reduce 167
9031 cmd ::= createkw uniqueflag INDEX ifnotexists nm * dbnm ON nm LP idxlist RP where_opt
9035 {default} reduce 137
9038 (28) ifnotexists ::= *
9039 ifnotexists ::= * IF NOT EXISTS
9040 cmd ::= createkw uniqueflag INDEX * ifnotexists nm dbnm ON nm LP idxlist RP where_opt
9043 ifnotexists shift 160
9047 trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause * when_clause
9048 (279) when_clause ::= *
9049 when_clause ::= * WHEN expr
9052 when_clause shift 476
9053 {default} reduce 279
9056 trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname * foreach_clause when_clause
9057 (277) foreach_clause ::= *
9058 foreach_clause ::= * FOR EACH ROW
9061 foreach_clause shift 259
9062 {default} reduce 277
9067 fullname ::= nm * dbnm
9071 {default} reduce 137
9076 trigger_decl ::= temp TRIGGER ifnotexists nm * dbnm trigger_time trigger_event ON fullname foreach_clause when_clause
9080 {default} reduce 137
9083 (28) ifnotexists ::= *
9084 ifnotexists ::= * IF NOT EXISTS
9085 trigger_decl ::= temp TRIGGER * ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause
9088 ifnotexists shift 161
9092 cmd ::= createkw temp VIEW ifnotexists nm * dbnm AS select
9098 {default} reduce 137
9101 (28) ifnotexists ::= *
9102 ifnotexists ::= * IF NOT EXISTS
9103 cmd ::= createkw temp VIEW * ifnotexists nm dbnm AS select
9106 ifnotexists shift 162
9110 create_table ::= createkw temp TABLE ifnotexists nm * dbnm
9116 {default} reduce 137
9119 create_table ::= createkw temp TABLE * ifnotexists nm dbnm
9120 (28) ifnotexists ::= *
9121 ifnotexists ::= * IF NOT EXISTS
9124 ifnotexists shift 163
9128 tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm * idxlist_opt refargs defer_subclause_opt
9129 (245) idxlist_opt ::= *
9130 idxlist_opt ::= * LP idxlist RP
9133 idxlist_opt shift 307
9134 {default} reduce 245
9137 tcons ::= CHECK LP expr RP * onconf
9139 onconf ::= * ON CONFLICT resolvetype
9143 {default} reduce 100
9146 tcons ::= UNIQUE LP idxlist RP * onconf
9148 onconf ::= * ON CONFLICT resolvetype
9152 {default} reduce 100
9155 tcons ::= PRIMARY KEY LP idxlist autoinc RP * onconf
9157 onconf ::= * ON CONFLICT resolvetype
9161 {default} reduce 100
9164 defer_subclause ::= DEFERRABLE * init_deferred_pred_opt
9165 (84) init_deferred_pred_opt ::= *
9166 init_deferred_pred_opt ::= * INITIALLY DEFERRED
9167 init_deferred_pred_opt ::= * INITIALLY IMMEDIATE
9170 init_deferred_pred_opt shift 492
9174 idxlist ::= nm * collate sortorder
9176 collate ::= * COLLATE ids
9180 {default} reduce 249
9183 idxlist ::= idxlist COMMA nm * collate sortorder
9185 collate ::= * COLLATE ids
9189 {default} reduce 249
9192 ccons ::= REFERENCES nm * idxlist_opt refargs
9193 (245) idxlist_opt ::= *
9194 idxlist_opt ::= * LP idxlist RP
9197 idxlist_opt shift 308
9198 {default} reduce 245
9201 ccons ::= UNIQUE * onconf
9203 onconf ::= * ON CONFLICT resolvetype
9207 {default} reduce 100
9210 ccons ::= PRIMARY KEY sortorder onconf * autoinc
9212 autoinc ::= * AUTOINCR
9219 ccons ::= PRIMARY KEY sortorder * onconf autoinc
9221 onconf ::= * ON CONFLICT resolvetype
9225 {default} reduce 100
9228 defer_subclause ::= NOT DEFERRABLE * init_deferred_pred_opt
9229 (84) init_deferred_pred_opt ::= *
9230 init_deferred_pred_opt ::= * INITIALLY DEFERRED
9231 init_deferred_pred_opt ::= * INITIALLY IMMEDIATE
9234 init_deferred_pred_opt shift 515
9238 ccons ::= NOT NULL * onconf
9240 onconf ::= * ON CONFLICT resolvetype
9244 {default} reduce 100
9247 ccons ::= NULL * onconf
9249 onconf ::= * ON CONFLICT resolvetype
9253 {default} reduce 100
9256 seltablist ::= stl_prefix LP seltablist RP as on_opt * using_opt
9257 using_opt ::= * USING LP inscollist RP
9258 (150) using_opt ::= *
9262 {default} reduce 150
9265 seltablist ::= stl_prefix LP seltablist RP as * on_opt using_opt
9266 on_opt ::= * ON expr
9271 {default} reduce 145
9274 seltablist ::= stl_prefix LP select RP as on_opt * using_opt
9275 using_opt ::= * USING LP inscollist RP
9276 (150) using_opt ::= *
9280 {default} reduce 150
9283 seltablist ::= stl_prefix LP select RP as * on_opt using_opt
9284 on_opt ::= * ON expr
9289 {default} reduce 145
9292 seltablist ::= stl_prefix nm dbnm as indexed_opt on_opt * using_opt
9293 using_opt ::= * USING LP inscollist RP
9294 (150) using_opt ::= *
9298 {default} reduce 150
9301 seltablist ::= stl_prefix nm dbnm as indexed_opt * on_opt using_opt
9302 on_opt ::= * ON expr
9307 {default} reduce 145
9310 seltablist ::= stl_prefix nm * dbnm as indexed_opt on_opt using_opt
9316 {default} reduce 137
9321 expr ::= expr in_op nm * dbnm
9325 {default} reduce 137
9328 expr ::= CASE case_operand * case_exprlist case_else END
9329 case_exprlist ::= * case_exprlist WHEN expr THEN expr
9330 case_exprlist ::= * WHEN expr THEN expr
9333 case_exprlist shift 230
9336 oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt * limit_opt
9337 (162) limit_opt ::= *
9338 limit_opt ::= * LIMIT expr
9339 limit_opt ::= * LIMIT expr OFFSET expr
9340 limit_opt ::= * LIMIT expr COMMA expr
9344 {default} reduce 162
9347 oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt * orderby_opt limit_opt
9348 (151) orderby_opt ::= *
9349 orderby_opt ::= * ORDER BY sortlist
9352 orderby_opt shift 291
9353 {default} reduce 151
9356 oneselect ::= SELECT distinct selcollist from where_opt groupby_opt * having_opt orderby_opt limit_opt
9357 (160) having_opt ::= *
9358 having_opt ::= * HAVING expr
9361 having_opt shift 292
9362 {default} reduce 160
9365 oneselect ::= SELECT distinct selcollist from where_opt * groupby_opt having_opt orderby_opt limit_opt
9366 (158) groupby_opt ::= *
9367 groupby_opt ::= * GROUP BY nexprlist
9370 groupby_opt shift 293
9371 {default} reduce 158
9374 oneselect ::= SELECT distinct selcollist from * where_opt groupby_opt having_opt orderby_opt limit_opt
9375 (167) where_opt ::= *
9376 where_opt ::= * WHERE expr
9380 {default} reduce 167
9383 select ::= select multiselect_op * oneselect
9384 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt
9390 create_table_args ::= LP columnlist * conslist_opt RP
9391 columnlist ::= columnlist * COMMA column
9392 (87) conslist_opt ::= *
9393 conslist_opt ::= * COMMA conslist
9396 conslist_opt shift 415
9400 savepoint_opt ::= * SAVEPOINT
9401 (21) savepoint_opt ::= *
9402 cmd ::= RELEASE * savepoint_opt nm
9405 savepoint_opt shift 177
9409 savepoint_opt ::= * SAVEPOINT
9410 (21) savepoint_opt ::= *
9411 cmd ::= ROLLBACK trans_opt TO * savepoint_opt nm
9414 savepoint_opt shift 179
9418 (10) trans_opt ::= *
9419 trans_opt ::= * TRANSACTION
9420 trans_opt ::= * TRANSACTION nm
9421 cmd ::= ROLLBACK * trans_opt
9422 cmd ::= ROLLBACK * trans_opt TO savepoint_opt nm
9424 TRANSACTION shift 180
9429 (10) trans_opt ::= *
9430 trans_opt ::= * TRANSACTION
9431 trans_opt ::= * TRANSACTION nm
9432 cmd ::= END * trans_opt
9434 TRANSACTION shift 180
9439 (10) trans_opt ::= *
9440 trans_opt ::= * TRANSACTION
9441 trans_opt ::= * TRANSACTION nm
9442 cmd ::= COMMIT * trans_opt
9444 TRANSACTION shift 180
9449 cmd ::= BEGIN transtype * trans_opt
9450 (10) trans_opt ::= *
9451 trans_opt ::= * TRANSACTION
9452 trans_opt ::= * TRANSACTION nm
9454 TRANSACTION shift 180
9460 anylist ::= * anylist LP anylist RP
9461 anylist ::= anylist LP * anylist RP
9462 anylist ::= * anylist ANY
9465 {default} reduce 324
9468 vtabargtoken ::= lp * anylist RP
9470 anylist ::= * anylist LP anylist RP
9471 anylist ::= * anylist ANY
9474 {default} reduce 324
9477 vtabarglist ::= vtabarglist COMMA * vtabarg
9479 vtabarg ::= * vtabarg vtabargtoken
9482 {default} reduce 319
9486 refargs ::= * refargs refarg
9487 tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt * refargs defer_subclause_opt
9493 ccons ::= REFERENCES nm idxlist_opt * refargs
9495 refargs ::= * refargs refarg
9501 column ::= columnid type * carglist
9502 carglist ::= * carglist ccons
9509 likeop ::= NOT * LIKE_KW
9510 likeop ::= NOT * MATCH
9511 expr ::= expr NOT * NULL
9512 between_op ::= NOT * BETWEEN
9522 cmd ::= DROP * TABLE ifexists fullname
9523 cmd ::= DROP * VIEW ifexists fullname
9524 cmd ::= DROP * INDEX ifexists fullname
9525 cmd ::= DROP * TRIGGER ifexists fullname
9533 anylist ::= anylist * LP anylist RP
9534 anylist ::= anylist LP anylist * RP
9535 anylist ::= anylist * ANY
9542 vtabargtoken ::= lp anylist * RP
9543 anylist ::= anylist * LP anylist RP
9544 anylist ::= anylist * ANY
9551 create_table ::= createkw temp * TABLE ifnotexists nm dbnm
9552 cmd ::= createkw temp * VIEW ifnotexists nm dbnm AS select
9553 trigger_decl ::= temp * TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause
9560 refarg ::= ON * INSERT refact
9561 refarg ::= ON * DELETE refact
9562 refarg ::= ON * UPDATE refact
9569 cmd ::= create_vtab LP vtabarglist * RP
9570 vtabarglist ::= vtabarglist * COMMA vtabarg
9576 (254) cmd ::= PRAGMA nm dbnm *
9577 cmd ::= PRAGMA nm dbnm * EQ nmnum
9578 cmd ::= PRAGMA nm dbnm * LP nmnum RP
9579 cmd ::= PRAGMA nm dbnm * EQ minus_num
9580 cmd ::= PRAGMA nm dbnm * LP minus_num RP
9584 {default} reduce 254
9587 valuelist ::= VALUES LP nexprlist * RP
9588 nexprlist ::= nexprlist * COMMA expr
9594 inscollist_opt ::= LP inscollist * RP
9595 inscollist ::= inscollist * COMMA nm
9601 cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist * RP where_opt
9602 idxlist ::= idxlist * COMMA nm collate sortorder
9608 tcons ::= FOREIGN KEY LP idxlist * RP REFERENCES nm idxlist_opt refargs defer_subclause_opt
9609 idxlist ::= idxlist * COMMA nm collate sortorder
9615 tcons ::= UNIQUE LP idxlist * RP onconf
9616 idxlist ::= idxlist * COMMA nm collate sortorder
9622 idxlist_opt ::= LP idxlist * RP
9623 idxlist ::= idxlist * COMMA nm collate sortorder
9629 refact ::= SET * NULL
9630 refact ::= SET * DEFAULT
9636 init_deferred_pred_opt ::= INITIALLY * DEFERRED
9637 init_deferred_pred_opt ::= INITIALLY * IMMEDIATE
9643 ccons ::= NOT * NULL onconf
9644 defer_subclause ::= NOT * DEFERRABLE init_deferred_pred_opt
9647 DEFERRABLE shift 279
9650 using_opt ::= USING LP inscollist * RP
9651 inscollist ::= inscollist * COMMA nm
9657 typetoken ::= typename LP signed * RP
9658 typetoken ::= typename LP signed * COMMA signed RP
9664 explain ::= EXPLAIN QUERY * PLAN
9669 (6) explain ::= EXPLAIN *
9670 explain ::= EXPLAIN * QUERY PLAN
9676 (314) cmd ::= create_vtab *
9677 cmd ::= create_vtab * LP vtabarglist RP
9680 {default} reduce 314
9683 cmd ::= ALTER TABLE add_column_fullname * ADD kwcolumn_opt column
9688 cmd ::= ALTER TABLE fullname RENAME * TO nm
9693 cmd ::= ALTER TABLE fullname * RENAME TO nm
9694 (311) add_column_fullname ::= fullname *
9697 {default} reduce 311
9700 cmd ::= ALTER * TABLE fullname RENAME TO nm
9701 cmd ::= ALTER * TABLE add_column_fullname ADD kwcolumn_opt column
9706 cmd ::= PRAGMA nm dbnm LP minus_num * RP
9711 cmd ::= PRAGMA nm dbnm LP nmnum * RP
9716 cmd ::= insert_cmd INTO fullname inscollist_opt DEFAULT * VALUES
9721 (172) cmd ::= insert_cmd INTO fullname inscollist_opt valuelist *
9722 valuelist ::= valuelist * COMMA LP exprlist RP
9725 {default} reduce 172
9728 cmd ::= insert_cmd * INTO fullname inscollist_opt valuelist
9729 cmd ::= insert_cmd * INTO fullname inscollist_opt select
9730 cmd ::= insert_cmd * INTO fullname inscollist_opt DEFAULT VALUES
9735 cmd ::= UPDATE orconf fullname indexed_opt * SET setlist where_opt
9740 cmd ::= DELETE * FROM fullname indexed_opt where_opt
9745 ifexists ::= IF * EXISTS
9750 create_vtab ::= createkw VIRTUAL TABLE ifnotexists nm dbnm * USING nm
9755 create_vtab ::= createkw VIRTUAL * TABLE ifnotexists nm dbnm USING nm
9760 trigger_cmd_list ::= trigger_cmd * SEMI
9765 trigger_cmd ::= DELETE * FROM trnm tridxby where_opt
9770 valuelist ::= valuelist COMMA LP exprlist * RP
9775 valuelist ::= valuelist COMMA * LP exprlist RP
9780 valuelist ::= valuelist * COMMA LP exprlist RP
9781 (289) trigger_cmd ::= insert_cmd INTO trnm inscollist_opt valuelist *
9784 {default} reduce 289
9787 valuelist ::= VALUES * LP nexprlist RP
9792 trigger_cmd ::= insert_cmd * INTO trnm inscollist_opt valuelist
9793 trigger_cmd ::= insert_cmd * INTO trnm inscollist_opt select
9798 setlist ::= nm * EQ expr
9803 setlist ::= setlist COMMA nm * EQ expr
9808 trigger_cmd ::= UPDATE orconf trnm tridxby * SET setlist where_opt
9813 tridxby ::= NOT * INDEXED
9818 tridxby ::= INDEXED * BY nm
9824 trnm ::= nm * DOT nm
9827 {default} reduce 283
9830 trigger_cmd_list ::= trigger_cmd_list trigger_cmd * SEMI
9835 cmd ::= createkw trigger_decl * BEGIN trigger_cmd_list END
9840 cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm * LP idxlist RP where_opt
9845 cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm * ON nm LP idxlist RP where_opt
9850 cmd ::= createkw uniqueflag * INDEX ifnotexists nm dbnm ON nm LP idxlist RP where_opt
9855 trigger_time ::= INSTEAD * OF
9860 inscollist ::= inscollist * COMMA nm
9861 (276) trigger_event ::= UPDATE OF inscollist *
9864 {default} reduce 276
9867 (275) trigger_event ::= UPDATE *
9868 trigger_event ::= UPDATE * OF inscollist
9871 {default} reduce 275
9874 foreach_clause ::= FOR EACH * ROW
9879 foreach_clause ::= FOR * EACH ROW
9884 trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event * ON fullname foreach_clause when_clause
9889 cmd ::= createkw temp VIEW ifnotexists nm dbnm * AS select
9894 ifnotexists ::= IF NOT * EXISTS
9899 ifnotexists ::= IF * NOT EXISTS
9904 defer_subclause ::= NOT * DEFERRABLE init_deferred_pred_opt
9906 DEFERRABLE shift 279
9909 tcons ::= FOREIGN KEY LP idxlist RP * REFERENCES nm idxlist_opt refargs defer_subclause_opt
9911 REFERENCES shift 164
9914 tcons ::= FOREIGN KEY * LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt
9919 tcons ::= FOREIGN * KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt
9924 tcons ::= CHECK * LP expr RP onconf
9929 tcons ::= UNIQUE * LP idxlist RP onconf
9934 tcons ::= PRIMARY KEY LP idxlist autoinc * RP onconf
9939 tcons ::= PRIMARY KEY * LP idxlist autoinc RP onconf
9944 tcons ::= PRIMARY * KEY LP idxlist autoinc RP onconf
9949 refact ::= NO * ACTION
9954 ccons ::= CHECK * LP expr RP
9959 ccons ::= PRIMARY * KEY sortorder onconf autoinc
9964 onconf ::= ON * CONFLICT resolvetype
9969 expr ::= ID LP STAR * RP
9974 expr ::= ID LP distinct exprlist * RP
9979 selcollist ::= sclp nm * DOT STAR
9980 expr ::= nm * DOT nm
9981 expr ::= nm * DOT nm DOT nm
9986 indexed_opt ::= NOT * INDEXED
9991 indexed_opt ::= INDEXED * BY nm
9996 using_opt ::= USING * LP inscollist RP
10001 joinop ::= JOIN_KW nm nm * JOIN
10006 (159) groupby_opt ::= GROUP BY nexprlist *
10007 nexprlist ::= nexprlist * COMMA expr
10010 {default} reduce 159
10013 groupby_opt ::= GROUP * BY nexprlist
10018 (152) orderby_opt ::= ORDER BY sortlist *
10019 sortlist ::= sortlist * COMMA expr sortorder
10022 {default} reduce 152
10025 orderby_opt ::= ORDER * BY sortlist
10030 (238) exprlist ::= nexprlist *
10031 nexprlist ::= nexprlist * COMMA expr
10034 {default} reduce 238
10037 expr ::= expr in_op LP exprlist * RP
10042 expr ::= RAISE LP raisetype COMMA nm * RP
10047 expr ::= RAISE LP raisetype * COMMA nm RP
10052 expr ::= RAISE LP IGNORE * RP
10057 expr ::= RAISE * LP IGNORE RP
10058 expr ::= RAISE * LP raisetype COMMA nm RP
10063 expr ::= CASE case_operand case_exprlist case_else * END
10068 expr ::= EXISTS * LP select RP
10073 expr ::= CAST LP expr AS typetoken * RP
10078 typetoken ::= typename LP signed COMMA signed * RP
10083 expr ::= CAST * LP expr AS typetoken RP
10088 (115) multiselect_op ::= UNION *
10089 multiselect_op ::= UNION * ALL
10092 {default} reduce 115
10095 (188) expr ::= nm DOT nm *
10096 expr ::= nm DOT nm * DOT nm
10099 {default} reduce 188
10102 expr ::= nm * DOT nm
10103 expr ::= nm * DOT nm DOT nm
10108 (43) nm ::= JOIN_KW *
10109 (187) expr ::= JOIN_KW *
10112 {default} reduce 187
10115 (42) nm ::= STRING *
10116 (191) term ::= STRING *
10119 {default} reduce 191
10123 (186) expr ::= id *
10126 {default} reduce 186
10130 expr ::= ID * LP distinct exprlist RP
10131 expr ::= ID * LP STAR RP
10134 {default} reduce 38
10137 create_table_args ::= LP columnlist conslist_opt * RP
10142 (19) cmd ::= ROLLBACK trans_opt *
10143 cmd ::= ROLLBACK trans_opt * TO savepoint_opt nm
10146 {default} reduce 19
10149 ecmd ::= explain cmdx * SEMI
10154 (2) cmdlist ::= ecmd *
10159 (7) explain ::= EXPLAIN QUERY PLAN *
10166 {default} reduce 323
10169 (326) anylist ::= anylist ANY *
10171 {default} reduce 326
10174 (325) anylist ::= anylist LP anylist RP *
10176 {default} reduce 325
10179 (322) vtabargtoken ::= lp anylist RP *
10181 {default} reduce 322
10184 (321) vtabargtoken ::= ANY *
10186 {default} reduce 321
10189 (320) vtabarg ::= vtabarg vtabargtoken *
10191 {default} reduce 320
10194 (315) cmd ::= create_vtab LP vtabarglist RP *
10196 {default} reduce 315
10199 (313) kwcolumn_opt ::= COLUMNKW *
10201 {default} reduce 313
10204 (310) cmd ::= ALTER TABLE add_column_fullname ADD kwcolumn_opt column *
10206 {default} reduce 310
10209 (309) cmd ::= ALTER TABLE fullname RENAME TO nm *
10211 {default} reduce 309
10214 (308) cmd ::= ANALYZE nm dbnm *
10216 {default} reduce 308
10219 (306) cmd ::= REINDEX nm dbnm *
10221 {default} reduce 306
10224 (303) database_kw_opt ::= DATABASE *
10226 {default} reduce 303
10229 (299) cmd ::= ATTACH database_kw_opt expr AS expr key_opt *
10231 {default} reduce 299
10234 (258) cmd ::= PRAGMA nm dbnm LP minus_num RP *
10236 {default} reduce 258
10239 (256) cmd ::= PRAGMA nm dbnm LP nmnum RP *
10241 {default} reduce 256
10244 (263) nmnum ::= DEFAULT *
10246 {default} reduce 263
10249 (262) nmnum ::= DELETE *
10251 {default} reduce 262
10254 (261) nmnum ::= ON *
10256 {default} reduce 261
10259 (260) nmnum ::= nm *
10261 {default} reduce 260
10264 (259) nmnum ::= plus_num *
10266 {default} reduce 259
10269 (257) cmd ::= PRAGMA nm dbnm EQ minus_num *
10271 {default} reduce 257
10274 (255) cmd ::= PRAGMA nm dbnm EQ nmnum *
10276 {default} reduce 255
10279 (253) cmd ::= VACUUM nm *
10281 {default} reduce 253
10284 (174) cmd ::= insert_cmd INTO fullname inscollist_opt DEFAULT VALUES *
10286 {default} reduce 174
10289 (169) cmd ::= UPDATE orconf fullname indexed_opt SET setlist where_opt *
10291 {default} reduce 169
10294 (166) cmd ::= DELETE FROM fullname indexed_opt where_opt *
10296 {default} reduce 166
10299 (298) cmd ::= DROP TRIGGER ifexists fullname *
10301 {default} reduce 298
10304 (251) cmd ::= DROP INDEX ifexists fullname *
10306 {default} reduce 251
10309 (111) cmd ::= DROP VIEW ifexists fullname *
10311 {default} reduce 111
10314 (108) ifexists ::= IF EXISTS *
10316 {default} reduce 108
10319 (107) cmd ::= DROP TABLE ifexists fullname *
10321 {default} reduce 107
10324 (27) createkw ::= CREATE *
10326 {default} reduce 27
10329 (316) create_vtab ::= createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm *
10331 {default} reduce 316
10334 (282) trigger_cmd_list ::= trigger_cmd SEMI *
10336 {default} reduce 282
10339 (291) trigger_cmd ::= DELETE FROM trnm tridxby where_opt *
10341 {default} reduce 291
10344 (178) valuelist ::= valuelist COMMA LP exprlist RP *
10346 {default} reduce 178
10349 (177) valuelist ::= VALUES LP nexprlist RP *
10351 {default} reduce 177
10354 (180) inscollist_opt ::= LP inscollist RP *
10356 {default} reduce 180
10359 (288) trigger_cmd ::= UPDATE orconf trnm tridxby SET setlist where_opt *
10361 {default} reduce 288
10364 (287) tridxby ::= NOT INDEXED *
10366 {default} reduce 287
10369 (286) tridxby ::= INDEXED BY nm *
10371 {default} reduce 286
10374 (284) trnm ::= nm DOT nm *
10376 {default} reduce 284
10379 (281) trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI *
10381 {default} reduce 281
10384 (268) cmd ::= createkw trigger_decl BEGIN trigger_cmd_list END *
10386 {default} reduce 268
10389 (176) insert_cmd ::= REPLACE *
10391 {default} reduce 176
10394 (175) insert_cmd ::= INSERT orconf *
10396 {default} reduce 175
10399 (103) orconf ::= OR resolvetype *
10401 {default} reduce 103
10404 (243) uniqueflag ::= UNIQUE *
10406 {default} reduce 243
10409 (242) cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP where_opt *
10411 {default} reduce 242
10414 (30) temp ::= TEMP *
10416 {default} reduce 30
10419 (272) trigger_time ::= INSTEAD OF *
10421 {default} reduce 272
10424 (271) trigger_time ::= AFTER *
10426 {default} reduce 271
10429 (270) trigger_time ::= BEFORE *
10431 {default} reduce 270
10434 (274) trigger_event ::= DELETE|INSERT *
10436 {default} reduce 274
10439 (278) foreach_clause ::= FOR EACH ROW *
10441 {default} reduce 278
10444 (269) trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause *
10446 {default} reduce 269
10449 (139) fullname ::= nm dbnm *
10451 {default} reduce 139
10454 (29) ifnotexists ::= IF NOT EXISTS *
10456 {default} reduce 29
10459 (26) create_table ::= createkw temp TABLE ifnotexists nm dbnm *
10461 {default} reduce 26
10464 (35) columnlist ::= column *
10466 {default} reduce 35
10469 (90) conslist ::= tcons *
10471 {default} reduce 90
10474 (91) tconscomma ::= COMMA *
10476 {default} reduce 91
10479 (99) defer_subclause_opt ::= defer_subclause *
10481 {default} reduce 99
10484 (97) tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt *
10486 {default} reduce 97
10489 (96) tcons ::= CHECK LP expr RP onconf *
10491 {default} reduce 96
10494 (95) tcons ::= UNIQUE LP idxlist RP onconf *
10496 {default} reduce 95
10499 (94) tcons ::= PRIMARY KEY LP idxlist autoinc RP onconf *
10501 {default} reduce 94
10504 (93) tcons ::= CONSTRAINT nm *
10506 {default} reduce 93
10509 (89) conslist ::= conslist tconscomma tcons *
10511 {default} reduce 89
10514 (37) columnid ::= nm *
10516 {default} reduce 37
10519 (45) type ::= typetoken *
10521 {default} reduce 45
10524 (83) defer_subclause ::= DEFERRABLE init_deferred_pred_opt *
10526 {default} reduce 83
10529 (68) ccons ::= COLLATE ids *
10531 {default} reduce 68
10534 (67) ccons ::= defer_subclause *
10536 {default} reduce 67
10539 (248) idxlist ::= nm collate sortorder *
10541 {default} reduce 248
10544 (250) collate ::= COLLATE ids *
10546 {default} reduce 250
10549 (247) idxlist ::= idxlist COMMA nm collate sortorder *
10551 {default} reduce 247
10554 (246) idxlist_opt ::= LP idxlist RP *
10556 {default} reduce 246
10559 (76) refarg ::= ON UPDATE refact *
10561 {default} reduce 76
10564 (75) refarg ::= ON DELETE refact *
10566 {default} reduce 75
10569 (81) refact ::= NO ACTION *
10571 {default} reduce 81
10574 (80) refact ::= RESTRICT *
10576 {default} reduce 80
10579 (79) refact ::= CASCADE *
10581 {default} reduce 79
10584 (78) refact ::= SET DEFAULT *
10586 {default} reduce 78
10589 (77) refact ::= SET NULL *
10591 {default} reduce 77
10594 (74) refarg ::= ON INSERT refact *
10596 {default} reduce 74
10599 (73) refarg ::= MATCH nm *
10601 {default} reduce 73
10604 (72) refargs ::= refargs refarg *
10606 {default} reduce 72
10609 (65) ccons ::= CHECK LP expr RP *
10611 {default} reduce 65
10614 (64) ccons ::= UNIQUE onconf *
10616 {default} reduce 64
10619 (70) autoinc ::= AUTOINCR *
10621 {default} reduce 70
10624 (63) ccons ::= PRIMARY KEY sortorder onconf autoinc *
10626 {default} reduce 63
10629 (86) init_deferred_pred_opt ::= INITIALLY IMMEDIATE *
10631 {default} reduce 86
10634 (85) init_deferred_pred_opt ::= INITIALLY DEFERRED *
10636 {default} reduce 85
10639 (82) defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt *
10641 {default} reduce 82
10644 (62) ccons ::= NOT NULL onconf *
10646 {default} reduce 62
10649 (106) resolvetype ::= REPLACE *
10651 {default} reduce 106
10654 (105) resolvetype ::= IGNORE *
10656 {default} reduce 105
10659 (104) resolvetype ::= raisetype *
10661 {default} reduce 104
10664 (101) onconf ::= ON CONFLICT resolvetype *
10666 {default} reduce 101
10669 (61) ccons ::= NULL onconf *
10671 {default} reduce 61
10674 (60) ccons ::= DEFAULT id *
10676 {default} reduce 60
10679 (59) ccons ::= DEFAULT MINUS term *
10681 {default} reduce 59
10684 (191) term ::= STRING *
10686 {default} reduce 191
10689 (58) ccons ::= DEFAULT PLUS term *
10691 {default} reduce 58
10694 (57) ccons ::= DEFAULT LP expr RP *
10696 {default} reduce 57
10699 (197) expr ::= ID LP STAR RP *
10701 {default} reduce 197
10704 (196) expr ::= ID LP distinct exprlist RP *
10706 {default} reduce 196
10709 (184) expr ::= LP expr RP *
10711 {default} reduce 184
10714 (227) expr ::= LP select RP *
10716 {default} reduce 227
10719 (126) selcollist ::= sclp nm DOT STAR *
10721 {default} reduce 126
10724 (125) selcollist ::= sclp STAR *
10726 {default} reduce 125
10729 (124) selcollist ::= sclp expr as *
10731 {default} reduce 124
10734 (136) seltablist ::= stl_prefix LP seltablist RP as on_opt using_opt *
10736 {default} reduce 136
10739 (135) seltablist ::= stl_prefix LP select RP as on_opt using_opt *
10741 {default} reduce 135
10744 (148) indexed_opt ::= NOT INDEXED *
10746 {default} reduce 148
10749 (147) indexed_opt ::= INDEXED BY nm *
10751 {default} reduce 147
10754 (182) inscollist ::= nm *
10756 {default} reduce 182
10759 (181) inscollist ::= inscollist COMMA nm *
10761 {default} reduce 181
10764 (149) using_opt ::= USING LP inscollist RP *
10766 {default} reduce 149
10769 (134) seltablist ::= stl_prefix nm dbnm as indexed_opt on_opt using_opt *
10771 {default} reduce 134
10776 {default} reduce 128
10779 (127) as ::= AS nm *
10781 {default} reduce 127
10784 (143) joinop ::= JOIN_KW nm nm JOIN *
10786 {default} reduce 143
10789 (142) joinop ::= JOIN_KW nm JOIN *
10791 {default} reduce 142
10794 (141) joinop ::= JOIN_KW JOIN *
10796 {default} reduce 141
10799 (140) joinop ::= COMMA|JOIN *
10801 {default} reduce 140
10804 (132) stl_prefix ::= seltablist joinop *
10806 {default} reduce 132
10809 (122) sclp ::= selcollist COMMA *
10811 {default} reduce 122
10814 (154) sortlist ::= expr sortorder *
10816 {default} reduce 154
10819 (156) sortorder ::= DESC *
10821 {default} reduce 156
10824 (155) sortorder ::= ASC *
10826 {default} reduce 155
10829 (153) sortlist ::= sortlist COMMA expr sortorder *
10831 {default} reduce 153
10834 (229) expr ::= expr in_op nm dbnm *
10836 {default} reduce 229
10839 (138) dbnm ::= DOT nm *
10841 {default} reduce 138
10844 (226) expr ::= expr in_op LP exprlist RP *
10846 {default} reduce 226
10849 (297) raisetype ::= FAIL *
10851 {default} reduce 297
10854 (296) raisetype ::= ABORT *
10856 {default} reduce 296
10859 (295) raisetype ::= ROLLBACK *
10861 {default} reduce 295
10864 (294) expr ::= RAISE LP raisetype COMMA nm RP *
10866 {default} reduce 294
10869 (293) expr ::= RAISE LP IGNORE RP *
10871 {default} reduce 293
10874 (231) expr ::= CASE case_operand case_exprlist case_else END *
10876 {default} reduce 231
10879 (230) expr ::= EXISTS LP select RP *
10881 {default} reduce 230
10884 (198) term ::= CTIME_KW *
10886 {default} reduce 198
10889 (195) expr ::= CAST LP expr AS typetoken RP *
10891 {default} reduce 195
10894 (49) typename ::= ids *
10896 {default} reduce 49
10899 (50) typename ::= typename ids *
10901 {default} reduce 50
10904 (266) minus_num ::= MINUS number *
10906 {default} reduce 266
10909 (265) plus_num ::= number *
10911 {default} reduce 265
10914 (267) number ::= INTEGER|FLOAT *
10916 {default} reduce 267
10919 (264) plus_num ::= PLUS number *
10921 {default} reduce 264
10924 (52) signed ::= minus_num *
10926 {default} reduce 52
10929 (51) signed ::= plus_num *
10931 {default} reduce 51
10934 (48) typetoken ::= typename LP signed COMMA signed RP *
10936 {default} reduce 48
10939 (47) typetoken ::= typename LP signed RP *
10941 {default} reduce 47
10944 (228) expr ::= expr in_op LP select RP *
10946 {default} reduce 228
10949 (117) multiselect_op ::= EXCEPT|INTERSECT *
10951 {default} reduce 117
10954 (116) multiselect_op ::= UNION ALL *
10956 {default} reduce 116
10959 (224) in_op ::= IN *
10961 {default} reduce 224
10964 (221) between_op ::= BETWEEN *
10966 {default} reduce 221
10969 (213) expr ::= expr ISNULL|NOTNULL *
10971 {default} reduce 213
10974 (209) likeop ::= MATCH *
10976 {default} reduce 209
10979 (225) in_op ::= NOT IN *
10981 {default} reduce 225
10984 (222) between_op ::= NOT BETWEEN *
10986 {default} reduce 222
10989 (214) expr ::= expr NOT NULL *
10991 {default} reduce 214
10994 (210) likeop ::= NOT MATCH *
10996 {default} reduce 210
10999 (208) likeop ::= NOT LIKE_KW *
11001 {default} reduce 208
11004 (207) likeop ::= LIKE_KW *
11006 {default} reduce 207
11009 (193) expr ::= VARIABLE *
11011 {default} reduce 193
11014 (192) expr ::= REGISTER *
11016 {default} reduce 192
11019 (190) term ::= INTEGER|FLOAT|BLOB *
11021 {default} reduce 190
11024 (189) expr ::= nm DOT nm DOT nm *
11026 {default} reduce 189
11029 (185) term ::= NULL *
11031 {default} reduce 185
11034 (194) expr ::= expr COLLATE ids *
11036 {default} reduce 194
11039 (40) ids ::= ID|STRING *
11041 {default} reduce 40
11044 (118) oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt *
11046 {default} reduce 118
11049 (114) select ::= select multiselect_op oneselect *
11051 {default} reduce 114
11054 (113) select ::= oneselect *
11056 {default} reduce 113
11059 (183) expr ::= term *
11061 {default} reduce 183
11064 (120) distinct ::= ALL *
11066 {default} reduce 120
11069 (119) distinct ::= DISTINCT *
11071 {default} reduce 119
11074 (56) ccons ::= DEFAULT term *
11076 {default} reduce 56
11079 (55) ccons ::= CONSTRAINT nm *
11081 {default} reduce 55
11084 (53) carglist ::= carglist ccons *
11086 {default} reduce 53
11089 (34) columnlist ::= columnlist COMMA column *
11091 {default} reduce 34
11094 (32) create_table_args ::= LP columnlist conslist_opt RP *
11096 {default} reduce 32
11099 (25) cmd ::= create_table create_table_args *
11101 {default} reduce 25
11104 (23) cmd ::= RELEASE savepoint_opt nm *
11106 {default} reduce 23
11109 (22) cmd ::= SAVEPOINT nm *
11111 {default} reduce 22
11114 (24) cmd ::= ROLLBACK trans_opt TO savepoint_opt nm *
11116 {default} reduce 24
11119 (20) savepoint_opt ::= SAVEPOINT *
11121 {default} reduce 20
11124 (18) cmd ::= END trans_opt *
11126 {default} reduce 18
11129 (17) cmd ::= COMMIT trans_opt *
11131 {default} reduce 17
11134 (16) transtype ::= EXCLUSIVE *
11136 {default} reduce 16
11139 (15) transtype ::= IMMEDIATE *
11141 {default} reduce 15
11144 (14) transtype ::= DEFERRED *
11146 {default} reduce 14
11149 (43) nm ::= JOIN_KW *
11151 {default} reduce 43
11154 (42) nm ::= STRING *
11156 {default} reduce 42
11161 {default} reduce 41
11164 (39) id ::= INDEXED *
11166 {default} reduce 39
11171 {default} reduce 38
11174 (12) trans_opt ::= TRANSACTION nm *
11176 {default} reduce 12
11179 (9) cmd ::= BEGIN transtype trans_opt *
11189 (4) ecmd ::= explain cmdx SEMI *
11194 (3) ecmd ::= SEMI *
11199 (1) cmdlist ::= cmdlist ecmd *
11203 ----------------------------------------------------
11347 142: input: SEMI EXPLAIN BEGIN COMMIT END ROLLBACK SAVEPOINT RELEASE CREATE ANALYZE ATTACH DETACH PRAGMA REPLACE VACUUM REINDEX INSERT DELETE UPDATE DROP SELECT ALTER
11348 143: cmdlist: SEMI EXPLAIN BEGIN COMMIT END ROLLBACK SAVEPOINT RELEASE CREATE ANALYZE ATTACH DETACH PRAGMA REPLACE VACUUM REINDEX INSERT DELETE UPDATE DROP SELECT ALTER
11349 144: ecmd: SEMI EXPLAIN BEGIN COMMIT END ROLLBACK SAVEPOINT RELEASE CREATE ANALYZE ATTACH DETACH PRAGMA REPLACE VACUUM REINDEX INSERT DELETE UPDATE DROP SELECT ALTER
11350 145: explain: <lambda> EXPLAIN
11351 146: cmdx: BEGIN COMMIT END ROLLBACK SAVEPOINT RELEASE CREATE ANALYZE ATTACH DETACH PRAGMA REPLACE VACUUM REINDEX INSERT DELETE UPDATE DROP SELECT ALTER
11352 147: cmd: BEGIN COMMIT END ROLLBACK SAVEPOINT RELEASE CREATE ANALYZE ATTACH DETACH PRAGMA REPLACE VACUUM REINDEX INSERT DELETE UPDATE DROP SELECT ALTER
11353 148: transtype: <lambda> DEFERRED IMMEDIATE EXCLUSIVE
11354 149: trans_opt: <lambda> TRANSACTION
11355 150: nm: ID INDEXED STRING JOIN_KW
11356 151: savepoint_opt: <lambda> SAVEPOINT
11357 152: create_table: CREATE
11358 153: create_table_args: LP AS
11359 154: createkw: CREATE
11360 155: temp: <lambda> TEMP
11361 156: ifnotexists: <lambda> IF
11362 157: dbnm: <lambda> DOT
11363 158: columnlist: ID INDEXED STRING JOIN_KW
11364 159: conslist_opt: <lambda> COMMA
11365 160: select: SELECT
11366 161: column: ID INDEXED STRING JOIN_KW
11367 162: columnid: ID INDEXED STRING JOIN_KW
11368 163: type: <lambda> ID STRING
11369 164: carglist: <lambda> NOT COLLATE CONSTRAINT DEFAULT NULL PRIMARY UNIQUE CHECK REFERENCES DEFERRABLE
11370 165: id: ID INDEXED
11371 166: ids: ID STRING
11372 167: typetoken: ID STRING
11373 168: typename: ID STRING
11374 169: signed: PLUS MINUS INTEGER FLOAT
11375 170: plus_num: PLUS INTEGER FLOAT
11376 171: minus_num: MINUS
11377 172: ccons: NOT COLLATE CONSTRAINT DEFAULT NULL PRIMARY UNIQUE CHECK REFERENCES DEFERRABLE
11378 173: term: CTIME_KW STRING NULL INTEGER FLOAT BLOB
11379 174: expr: NOT EXISTS LP ID INDEXED CAST RAISE CTIME_KW PLUS MINUS BITNOT STRING JOIN_KW NULL INTEGER FLOAT BLOB REGISTER VARIABLE CASE
11380 175: onconf: <lambda> ON
11381 176: sortorder: <lambda> ASC DESC
11382 177: autoinc: <lambda> AUTOINCR
11383 178: idxlist_opt: <lambda> LP
11384 179: refargs: <lambda> MATCH ON
11385 180: defer_subclause: NOT DEFERRABLE
11386 181: refarg: MATCH ON
11387 182: refact: CASCADE NO RESTRICT SET
11388 183: init_deferred_pred_opt: <lambda> INITIALLY
11389 184: conslist: CONSTRAINT PRIMARY UNIQUE CHECK FOREIGN
11390 185: tconscomma: <lambda> COMMA
11391 186: tcons: CONSTRAINT PRIMARY UNIQUE CHECK FOREIGN
11392 187: idxlist: ID INDEXED STRING JOIN_KW
11393 188: defer_subclause_opt: <lambda> NOT DEFERRABLE
11394 189: orconf: <lambda> OR
11395 190: resolvetype: ROLLBACK ABORT FAIL IGNORE REPLACE
11396 191: raisetype: ROLLBACK ABORT FAIL
11397 192: ifexists: <lambda> IF
11398 193: fullname: ID INDEXED STRING JOIN_KW
11399 194: oneselect: SELECT
11400 195: multiselect_op: UNION EXCEPT INTERSECT
11401 196: distinct: <lambda> ALL DISTINCT
11402 197: selcollist: NOT EXISTS LP ID INDEXED CAST RAISE CTIME_KW PLUS MINUS STAR BITNOT STRING JOIN_KW NULL INTEGER FLOAT BLOB REGISTER VARIABLE CASE
11403 198: from: <lambda> FROM
11404 199: where_opt: <lambda> WHERE
11405 200: groupby_opt: <lambda> GROUP
11406 201: having_opt: <lambda> HAVING
11407 202: orderby_opt: <lambda> ORDER
11408 203: limit_opt: <lambda> LIMIT
11409 204: sclp: <lambda> NOT EXISTS LP ID INDEXED CAST RAISE CTIME_KW PLUS MINUS STAR BITNOT STRING JOIN_KW NULL INTEGER FLOAT BLOB REGISTER VARIABLE CASE
11410 205: as: <lambda> AS ID STRING
11411 206: seltablist: LP ID INDEXED STRING JOIN_KW
11412 207: stl_prefix: <lambda> LP ID INDEXED STRING JOIN_KW
11413 208: joinop: COMMA JOIN_KW JOIN
11414 209: indexed_opt: <lambda> NOT INDEXED
11415 210: on_opt: <lambda> ON
11416 211: using_opt: <lambda> USING
11418 213: inscollist: ID INDEXED STRING JOIN_KW
11419 214: sortlist: NOT EXISTS LP ID INDEXED CAST RAISE CTIME_KW PLUS MINUS BITNOT STRING JOIN_KW NULL INTEGER FLOAT BLOB REGISTER VARIABLE CASE
11420 215: nexprlist: NOT EXISTS LP ID INDEXED CAST RAISE CTIME_KW PLUS MINUS BITNOT STRING JOIN_KW NULL INTEGER FLOAT BLOB REGISTER VARIABLE CASE
11421 216: setlist: ID INDEXED STRING JOIN_KW
11422 217: insert_cmd: REPLACE INSERT
11423 218: inscollist_opt: <lambda> LP
11424 219: valuelist: VALUES
11425 220: exprlist: <lambda> NOT EXISTS LP ID INDEXED CAST RAISE CTIME_KW PLUS MINUS BITNOT STRING JOIN_KW NULL INTEGER FLOAT BLOB REGISTER VARIABLE CASE
11426 221: likeop: NOT LIKE_KW MATCH
11427 222: between_op: NOT BETWEEN
11429 224: case_operand: <lambda> NOT EXISTS LP ID INDEXED CAST RAISE CTIME_KW PLUS MINUS BITNOT STRING JOIN_KW NULL INTEGER FLOAT BLOB REGISTER VARIABLE CASE
11430 225: case_exprlist: WHEN
11431 226: case_else: <lambda> ELSE
11432 227: uniqueflag: <lambda> UNIQUE
11433 228: collate: <lambda> COLLATE
11434 229: nmnum: ID INDEXED PLUS STRING JOIN_KW DEFAULT ON DELETE INTEGER FLOAT
11435 230: number: INTEGER FLOAT
11436 231: trigger_decl: TEMP TRIGGER
11437 232: trigger_cmd_list: REPLACE INSERT DELETE UPDATE SELECT
11438 233: trigger_time: <lambda> AFTER BEFORE INSTEAD
11439 234: trigger_event: INSERT DELETE UPDATE
11440 235: foreach_clause: <lambda> FOR
11441 236: when_clause: <lambda> WHEN
11442 237: trigger_cmd: REPLACE INSERT DELETE UPDATE SELECT
11443 238: trnm: ID INDEXED STRING JOIN_KW
11444 239: tridxby: <lambda> NOT INDEXED
11445 240: database_kw_opt: <lambda> DATABASE
11446 241: key_opt: <lambda> KEY
11447 242: add_column_fullname: ID INDEXED STRING JOIN_KW
11448 243: kwcolumn_opt: <lambda> COLUMNKW
11449 244: create_vtab: CREATE
11450 245: vtabarglist: <lambda> LP COMMA ANY
11451 246: vtabarg: <lambda> LP ANY
11452 247: vtabargtoken: LP ANY
11454 249: anylist: <lambda> LP ANY