BEGIN; CREATE TABLE symbol( id INTEGER PRIMARY KEY, name TEXT NOT NULL, isTerminal BOOLEAN NOT NULL, fallback INTEGER REFERENCES symbol DEFERRABLE INITIALLY DEFERRED ); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(0,'$',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(1,'SEMI',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(2,'EXPLAIN',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(3,'QUERY',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(4,'PLAN',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(5,'BEGIN',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(6,'TRANSACTION',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(7,'DEFERRED',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(8,'IMMEDIATE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(9,'EXCLUSIVE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(10,'COMMIT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(11,'END',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(12,'ROLLBACK',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(13,'SAVEPOINT',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(14,'RELEASE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(15,'TO',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(16,'TABLE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(17,'CREATE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(18,'IF',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(19,'NOT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(20,'EXISTS',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(21,'TEMP',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(22,'LP',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(23,'RP',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(24,'AS',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(25,'COMMA',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(26,'WITHOUT',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(27,'ABORT',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(28,'ACTION',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(29,'AFTER',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(30,'ANALYZE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(31,'ASC',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(32,'ATTACH',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(33,'BEFORE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(34,'BY',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(35,'CASCADE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(36,'CAST',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(37,'CONFLICT',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(38,'DATABASE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(39,'DESC',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(40,'DETACH',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(41,'EACH',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(42,'FAIL',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(43,'OR',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(44,'AND',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(45,'IS',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(46,'ISNOT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(47,'MATCH',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(48,'LIKE_KW',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(49,'BETWEEN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(50,'IN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(51,'ISNULL',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(52,'NOTNULL',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(53,'NE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(54,'EQ',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(55,'GT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(56,'LE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(57,'LT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(58,'GE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(59,'ESCAPE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(60,'ID',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(61,'COLUMNKW',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(62,'DO',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(63,'FOR',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(64,'IGNORE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(65,'INITIALLY',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(66,'INSTEAD',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(67,'NO',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(68,'KEY',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(69,'OF',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(70,'OFFSET',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(71,'PRAGMA',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(72,'RAISE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(73,'RECURSIVE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(74,'REPLACE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(75,'RESTRICT',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(76,'ROW',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(77,'ROWS',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(78,'TRIGGER',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(79,'VACUUM',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(80,'VIEW',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(81,'VIRTUAL',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(82,'WITH',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(83,'NULLS',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(84,'FIRST',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(85,'LAST',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(86,'CURRENT',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(87,'FOLLOWING',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(88,'PARTITION',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(89,'PRECEDING',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(90,'RANGE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(91,'UNBOUNDED',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(92,'EXCLUDE',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(93,'GROUPS',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(94,'OTHERS',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(95,'TIES',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(96,'GENERATED',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(97,'ALWAYS',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(98,'MATERIALIZED',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(99,'REINDEX',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(100,'RENAME',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(101,'CTIME_KW',TRUE,60); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(102,'ANY',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(103,'BITAND',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(104,'BITOR',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(105,'LSHIFT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(106,'RSHIFT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(107,'PLUS',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(108,'MINUS',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(109,'STAR',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(110,'SLASH',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(111,'REM',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(112,'CONCAT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(113,'PTR',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(114,'COLLATE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(115,'BITNOT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(116,'ON',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(117,'INDEXED',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(118,'STRING',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(119,'JOIN_KW',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(120,'CONSTRAINT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(121,'DEFAULT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(122,'NULL',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(123,'PRIMARY',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(124,'UNIQUE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(125,'CHECK',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(126,'REFERENCES',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(127,'AUTOINCR',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(128,'INSERT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(129,'DELETE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(130,'UPDATE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(131,'SET',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(132,'DEFERRABLE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(133,'FOREIGN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(134,'DROP',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(135,'UNION',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(136,'ALL',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(137,'EXCEPT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(138,'INTERSECT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(139,'SELECT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(140,'VALUES',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(141,'DISTINCT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(142,'DOT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(143,'FROM',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(144,'JOIN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(145,'USING',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(146,'ORDER',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(147,'GROUP',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(148,'HAVING',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(149,'LIMIT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(150,'WHERE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(151,'RETURNING',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(152,'INTO',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(153,'NOTHING',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(154,'FLOAT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(155,'BLOB',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(156,'INTEGER',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(157,'VARIABLE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(158,'CASE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(159,'WHEN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(160,'THEN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(161,'ELSE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(162,'INDEX',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(163,'ALTER',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(164,'ADD',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(165,'WINDOW',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(166,'OVER',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(167,'FILTER',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(168,'COLUMN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(169,'AGG_FUNCTION',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(170,'AGG_COLUMN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(171,'TRUEFALSE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(172,'FUNCTION',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(173,'UPLUS',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(174,'UMINUS',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(175,'TRUTH',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(176,'REGISTER',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(177,'VECTOR',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(178,'SELECT_COLUMN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(179,'IF_NULL_ROW',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(180,'ASTERISK',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(181,'SPAN',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(182,'ERROR',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(183,'QNUMBER',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(184,'SPACE',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(185,'COMMENT',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(186,'ILLEGAL',TRUE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(187,'input',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(188,'cmdlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(189,'ecmd',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(190,'cmdx',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(191,'explain',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(192,'cmd',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(193,'transtype',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(194,'trans_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(195,'nm',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(196,'savepoint_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(197,'create_table',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(198,'create_table_args',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(199,'createkw',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(200,'temp',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(201,'ifnotexists',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(202,'dbnm',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(203,'columnlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(204,'conslist_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(205,'table_option_set',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(206,'select',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(207,'table_option',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(208,'columnname',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(209,'carglist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(210,'typetoken',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(211,'typename',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(212,'signed',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(213,'plus_num',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(214,'minus_num',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(215,'scanpt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(216,'scantok',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(217,'ccons',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(218,'term',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(219,'expr',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(220,'onconf',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(221,'sortorder',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(222,'autoinc',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(223,'eidlist_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(224,'refargs',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(225,'defer_subclause',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(226,'generated',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(227,'refarg',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(228,'refact',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(229,'init_deferred_pred_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(230,'conslist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(231,'tconscomma',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(232,'tcons',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(233,'sortlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(234,'eidlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(235,'defer_subclause_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(236,'orconf',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(237,'resolvetype',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(238,'raisetype',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(239,'ifexists',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(240,'fullname',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(241,'selectnowith',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(242,'oneselect',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(243,'wqlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(244,'multiselect_op',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(245,'distinct',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(246,'selcollist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(247,'from',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(248,'where_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(249,'groupby_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(250,'having_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(251,'orderby_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(252,'limit_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(253,'window_clause',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(254,'values',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(255,'nexprlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(256,'mvalues',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(257,'sclp',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(258,'as',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(259,'seltablist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(260,'stl_prefix',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(261,'joinop',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(262,'on_using',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(263,'indexed_by',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(264,'exprlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(265,'xfullname',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(266,'idlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(267,'indexed_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(268,'nulls',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(269,'with',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(270,'where_opt_ret',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(271,'setlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(272,'insert_cmd',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(273,'idlist_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(274,'upsert',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(275,'returning',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(276,'filter_over',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(277,'likeop',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(278,'between_op',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(279,'in_op',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(280,'paren_exprlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(281,'case_operand',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(282,'case_exprlist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(283,'case_else',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(284,'uniqueflag',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(285,'collate',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(286,'vinto',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(287,'nmnum',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(288,'trigger_decl',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(289,'trigger_cmd_list',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(290,'trigger_time',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(291,'trigger_event',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(292,'foreach_clause',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(293,'when_clause',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(294,'trigger_cmd',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(295,'tridxby',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(296,'database_kw_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(297,'key_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(298,'alter_add',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(299,'kwcolumn_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(300,'create_vtab',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(301,'vtabarglist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(302,'vtabarg',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(303,'vtabargtoken',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(304,'lp',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(305,'anylist',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(306,'wqitem',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(307,'wqas',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(308,'withnm',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(309,'windowdefn_list',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(310,'windowdefn',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(311,'window',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(312,'frame_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(313,'part_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(314,'filter_clause',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(315,'over_clause',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(316,'range_or_rows',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(317,'frame_bound',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(318,'frame_bound_s',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(319,'frame_bound_e',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(320,'frame_exclude_opt',FALSE,NULL); INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(321,'frame_exclude',FALSE,NULL); CREATE TABLE rule( ruleid INTEGER PRIMARY KEY, lhs INTEGER REFERENCES symbol(id), txt TEXT ); CREATE TABLE rulerhs( ruleid INTEGER REFERENCES rule(ruleid), pos INTEGER, sym INTEGER REFERENCES symbol(id) ); INSERT INTO rule(ruleid,lhs,txt)VALUES(0,191,'explain ::= EXPLAIN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(0,0,2); INSERT INTO rule(ruleid,lhs,txt)VALUES(1,191,'explain ::= EXPLAIN QUERY PLAN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,0,2); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,1,3); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,2,4); INSERT INTO rule(ruleid,lhs,txt)VALUES(2,190,'cmdx ::= cmd'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(2,0,192); INSERT INTO rule(ruleid,lhs,txt)VALUES(3,192,'cmd ::= BEGIN transtype trans_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,0,5); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,1,193); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,2,194); INSERT INTO rule(ruleid,lhs,txt)VALUES(4,193,'transtype ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(5,193,'transtype ::= DEFERRED'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(5,0,7); INSERT INTO rule(ruleid,lhs,txt)VALUES(6,193,'transtype ::= IMMEDIATE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(6,0,8); INSERT INTO rule(ruleid,lhs,txt)VALUES(7,193,'transtype ::= EXCLUSIVE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(7,0,9); INSERT INTO rule(ruleid,lhs,txt)VALUES(8,192,'cmd ::= COMMIT|END trans_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,0,10); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,0,11); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,1,194); INSERT INTO rule(ruleid,lhs,txt)VALUES(9,192,'cmd ::= ROLLBACK trans_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(9,0,12); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(9,1,194); INSERT INTO rule(ruleid,lhs,txt)VALUES(10,192,'cmd ::= SAVEPOINT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(10,0,13); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(10,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(11,192,'cmd ::= RELEASE savepoint_opt nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,0,14); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,1,196); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,2,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(12,192,'cmd ::= ROLLBACK trans_opt TO savepoint_opt nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,0,12); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,1,194); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,2,15); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,3,196); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,4,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(13,197,'create_table ::= createkw temp TABLE ifnotexists nm dbnm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,0,199); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,1,200); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,2,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,3,201); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,4,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,5,202); INSERT INTO rule(ruleid,lhs,txt)VALUES(14,199,'createkw ::= CREATE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(14,0,17); INSERT INTO rule(ruleid,lhs,txt)VALUES(15,201,'ifnotexists ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(16,201,'ifnotexists ::= IF NOT EXISTS'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,0,18); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,1,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,2,20); INSERT INTO rule(ruleid,lhs,txt)VALUES(17,200,'temp ::= TEMP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(17,0,21); INSERT INTO rule(ruleid,lhs,txt)VALUES(18,200,'temp ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(19,198,'create_table_args ::= LP columnlist conslist_opt RP table_option_set'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,1,203); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,2,204); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,3,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,4,205); INSERT INTO rule(ruleid,lhs,txt)VALUES(20,198,'create_table_args ::= AS select'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(20,0,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(20,1,206); INSERT INTO rule(ruleid,lhs,txt)VALUES(21,205,'table_option_set ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(22,205,'table_option_set ::= table_option_set COMMA table_option'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,0,205); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,2,207); INSERT INTO rule(ruleid,lhs,txt)VALUES(23,207,'table_option ::= WITHOUT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(23,0,26); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(23,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(24,207,'table_option ::= nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(24,0,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(25,208,'columnname ::= nm typetoken'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(25,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(25,1,210); INSERT INTO rule(ruleid,lhs,txt)VALUES(26,210,'typetoken ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(27,210,'typetoken ::= typename LP signed RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,0,211); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,2,212); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(28,210,'typetoken ::= typename LP signed COMMA signed RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,0,211); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,2,212); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,3,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,4,212); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,5,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(29,211,'typename ::= typename ID|STRING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,0,211); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,1,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,1,118); INSERT INTO rule(ruleid,lhs,txt)VALUES(30,215,'scanpt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(31,216,'scantok ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(32,217,'ccons ::= CONSTRAINT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(32,0,120); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(32,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(33,217,'ccons ::= DEFAULT scantok term'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,0,121); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,1,216); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,2,218); INSERT INTO rule(ruleid,lhs,txt)VALUES(34,217,'ccons ::= DEFAULT LP expr RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,0,121); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(35,217,'ccons ::= DEFAULT PLUS scantok term'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,0,121); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,1,107); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,2,216); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,3,218); INSERT INTO rule(ruleid,lhs,txt)VALUES(36,217,'ccons ::= DEFAULT MINUS scantok term'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,0,121); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,1,108); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,2,216); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,3,218); INSERT INTO rule(ruleid,lhs,txt)VALUES(37,217,'ccons ::= DEFAULT scantok ID|INDEXED'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,0,121); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,1,216); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,2,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,2,117); INSERT INTO rule(ruleid,lhs,txt)VALUES(38,217,'ccons ::= NOT NULL onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,0,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,1,122); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,2,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(39,217,'ccons ::= PRIMARY KEY sortorder onconf autoinc'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,0,123); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,1,68); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,2,221); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,3,220); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,4,222); INSERT INTO rule(ruleid,lhs,txt)VALUES(40,217,'ccons ::= UNIQUE onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(40,0,124); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(40,1,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(41,217,'ccons ::= CHECK LP expr RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,0,125); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(42,217,'ccons ::= REFERENCES nm eidlist_opt refargs'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,0,126); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,2,223); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,3,224); INSERT INTO rule(ruleid,lhs,txt)VALUES(43,217,'ccons ::= defer_subclause'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(43,0,225); INSERT INTO rule(ruleid,lhs,txt)VALUES(44,217,'ccons ::= COLLATE ID|STRING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,0,114); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,1,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,1,118); INSERT INTO rule(ruleid,lhs,txt)VALUES(45,226,'generated ::= LP expr RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,1,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,2,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(46,226,'generated ::= LP expr RP ID'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,1,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,2,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,3,60); INSERT INTO rule(ruleid,lhs,txt)VALUES(47,222,'autoinc ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(48,222,'autoinc ::= AUTOINCR'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(48,0,127); INSERT INTO rule(ruleid,lhs,txt)VALUES(49,224,'refargs ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(50,224,'refargs ::= refargs refarg'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(50,0,224); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(50,1,227); INSERT INTO rule(ruleid,lhs,txt)VALUES(51,227,'refarg ::= MATCH nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(51,0,47); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(51,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(52,227,'refarg ::= ON INSERT refact'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,1,128); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,2,228); INSERT INTO rule(ruleid,lhs,txt)VALUES(53,227,'refarg ::= ON DELETE refact'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,1,129); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,2,228); INSERT INTO rule(ruleid,lhs,txt)VALUES(54,227,'refarg ::= ON UPDATE refact'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,1,130); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,2,228); INSERT INTO rule(ruleid,lhs,txt)VALUES(55,228,'refact ::= SET NULL'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(55,0,131); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(55,1,122); INSERT INTO rule(ruleid,lhs,txt)VALUES(56,228,'refact ::= SET DEFAULT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(56,0,131); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(56,1,121); INSERT INTO rule(ruleid,lhs,txt)VALUES(57,228,'refact ::= CASCADE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(57,0,35); INSERT INTO rule(ruleid,lhs,txt)VALUES(58,228,'refact ::= RESTRICT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(58,0,75); INSERT INTO rule(ruleid,lhs,txt)VALUES(59,228,'refact ::= NO ACTION'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(59,0,67); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(59,1,28); INSERT INTO rule(ruleid,lhs,txt)VALUES(60,225,'defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,0,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,1,132); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,2,229); INSERT INTO rule(ruleid,lhs,txt)VALUES(61,225,'defer_subclause ::= DEFERRABLE init_deferred_pred_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(61,0,132); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(61,1,229); INSERT INTO rule(ruleid,lhs,txt)VALUES(62,229,'init_deferred_pred_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(63,229,'init_deferred_pred_opt ::= INITIALLY DEFERRED'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(63,0,65); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(63,1,7); INSERT INTO rule(ruleid,lhs,txt)VALUES(64,229,'init_deferred_pred_opt ::= INITIALLY IMMEDIATE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(64,0,65); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(64,1,8); INSERT INTO rule(ruleid,lhs,txt)VALUES(65,204,'conslist_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(66,231,'tconscomma ::= COMMA'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(66,0,25); INSERT INTO rule(ruleid,lhs,txt)VALUES(67,232,'tcons ::= CONSTRAINT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(67,0,120); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(67,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(68,232,'tcons ::= PRIMARY KEY LP sortlist autoinc RP onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,0,123); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,1,68); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,3,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,4,222); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,5,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,6,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(69,232,'tcons ::= UNIQUE LP sortlist RP onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,0,124); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,2,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,3,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,4,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(70,232,'tcons ::= CHECK LP expr RP onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,0,125); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,3,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,4,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(71,232,'tcons ::= FOREIGN KEY LP eidlist RP REFERENCES nm eidlist_opt refargs defer_subclause_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,0,133); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,1,68); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,3,234); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,4,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,5,126); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,6,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,7,223); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,8,224); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,9,235); INSERT INTO rule(ruleid,lhs,txt)VALUES(72,235,'defer_subclause_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(73,220,'onconf ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(74,220,'onconf ::= ON CONFLICT resolvetype'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,1,37); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,2,237); INSERT INTO rule(ruleid,lhs,txt)VALUES(75,236,'orconf ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(76,236,'orconf ::= OR resolvetype'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(76,0,43); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(76,1,237); INSERT INTO rule(ruleid,lhs,txt)VALUES(77,237,'resolvetype ::= IGNORE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(77,0,64); INSERT INTO rule(ruleid,lhs,txt)VALUES(78,237,'resolvetype ::= REPLACE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(78,0,74); INSERT INTO rule(ruleid,lhs,txt)VALUES(79,192,'cmd ::= DROP TABLE ifexists fullname'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,0,134); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,2,239); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,3,240); INSERT INTO rule(ruleid,lhs,txt)VALUES(80,239,'ifexists ::= IF EXISTS'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(80,0,18); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(80,1,20); INSERT INTO rule(ruleid,lhs,txt)VALUES(81,239,'ifexists ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(82,192,'cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,0,199); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,1,200); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,2,80); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,3,201); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,4,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,5,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,6,223); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,7,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,8,206); INSERT INTO rule(ruleid,lhs,txt)VALUES(83,192,'cmd ::= DROP VIEW ifexists fullname'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,0,134); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,1,80); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,2,239); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,3,240); INSERT INTO rule(ruleid,lhs,txt)VALUES(84,192,'cmd ::= select'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(84,0,206); INSERT INTO rule(ruleid,lhs,txt)VALUES(85,206,'select ::= WITH wqlist selectnowith'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,0,82); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,1,243); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,2,241); INSERT INTO rule(ruleid,lhs,txt)VALUES(86,206,'select ::= WITH RECURSIVE wqlist selectnowith'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,0,82); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,1,73); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,2,243); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,3,241); INSERT INTO rule(ruleid,lhs,txt)VALUES(87,206,'select ::= selectnowith'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(87,0,241); INSERT INTO rule(ruleid,lhs,txt)VALUES(88,241,'selectnowith ::= selectnowith multiselect_op oneselect'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,0,241); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,1,244); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,2,242); INSERT INTO rule(ruleid,lhs,txt)VALUES(89,244,'multiselect_op ::= UNION'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(89,0,135); INSERT INTO rule(ruleid,lhs,txt)VALUES(90,244,'multiselect_op ::= UNION ALL'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(90,0,135); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(90,1,136); INSERT INTO rule(ruleid,lhs,txt)VALUES(91,244,'multiselect_op ::= EXCEPT|INTERSECT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(91,0,137); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(91,0,138); INSERT INTO rule(ruleid,lhs,txt)VALUES(92,242,'oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,0,139); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,1,245); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,2,246); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,3,247); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,4,248); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,5,249); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,6,250); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,7,251); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,8,252); INSERT INTO rule(ruleid,lhs,txt)VALUES(93,242,'oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,0,139); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,1,245); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,2,246); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,3,247); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,4,248); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,5,249); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,6,250); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,7,253); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,8,251); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,9,252); INSERT INTO rule(ruleid,lhs,txt)VALUES(94,254,'values ::= VALUES LP nexprlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,0,140); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,2,255); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(95,242,'oneselect ::= mvalues'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(95,0,256); INSERT INTO rule(ruleid,lhs,txt)VALUES(96,256,'mvalues ::= values COMMA LP nexprlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,0,254); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,3,255); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,4,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(97,256,'mvalues ::= mvalues COMMA LP nexprlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,0,256); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,3,255); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,4,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(98,245,'distinct ::= DISTINCT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(98,0,141); INSERT INTO rule(ruleid,lhs,txt)VALUES(99,245,'distinct ::= ALL'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(99,0,136); INSERT INTO rule(ruleid,lhs,txt)VALUES(100,245,'distinct ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(101,257,'sclp ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(102,246,'selcollist ::= sclp scanpt expr scanpt as'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,0,257); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,1,215); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,3,215); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,4,258); INSERT INTO rule(ruleid,lhs,txt)VALUES(103,246,'selcollist ::= sclp scanpt STAR'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(103,0,257); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(103,1,215); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(103,2,109); INSERT INTO rule(ruleid,lhs,txt)VALUES(104,246,'selcollist ::= sclp scanpt nm DOT STAR'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,0,257); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,1,215); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,2,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,3,142); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,4,109); INSERT INTO rule(ruleid,lhs,txt)VALUES(105,258,'as ::= AS nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(105,0,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(105,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(106,258,'as ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(107,247,'from ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(108,247,'from ::= FROM seltablist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(108,0,143); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(108,1,259); INSERT INTO rule(ruleid,lhs,txt)VALUES(109,260,'stl_prefix ::= seltablist joinop'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,0,259); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,1,261); INSERT INTO rule(ruleid,lhs,txt)VALUES(110,260,'stl_prefix ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(111,259,'seltablist ::= stl_prefix nm dbnm as on_using'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,0,260); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,2,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,3,258); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,4,262); INSERT INTO rule(ruleid,lhs,txt)VALUES(112,259,'seltablist ::= stl_prefix nm dbnm as indexed_by on_using'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,0,260); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,2,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,3,258); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,4,263); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,5,262); INSERT INTO rule(ruleid,lhs,txt)VALUES(113,259,'seltablist ::= stl_prefix nm dbnm LP exprlist RP as on_using'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,0,260); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,2,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,3,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,4,264); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,5,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,6,258); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,7,262); INSERT INTO rule(ruleid,lhs,txt)VALUES(114,259,'seltablist ::= stl_prefix LP select RP as on_using'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,0,260); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,2,206); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,3,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,4,258); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,5,262); INSERT INTO rule(ruleid,lhs,txt)VALUES(115,259,'seltablist ::= stl_prefix LP seltablist RP as on_using'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,0,260); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,2,259); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,3,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,4,258); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,5,262); INSERT INTO rule(ruleid,lhs,txt)VALUES(116,202,'dbnm ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(117,202,'dbnm ::= DOT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(117,0,142); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(117,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(118,240,'fullname ::= nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(118,0,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(119,240,'fullname ::= nm DOT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,1,142); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,2,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(120,265,'xfullname ::= nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(120,0,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(121,265,'xfullname ::= nm DOT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,1,142); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,2,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(122,265,'xfullname ::= nm AS nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(122,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(122,1,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(122,2,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(123,265,'xfullname ::= nm DOT nm AS nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,1,142); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,2,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,3,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,4,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(124,261,'joinop ::= COMMA|JOIN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(124,0,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(124,0,144); INSERT INTO rule(ruleid,lhs,txt)VALUES(125,261,'joinop ::= JOIN_KW JOIN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(125,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(125,1,144); INSERT INTO rule(ruleid,lhs,txt)VALUES(126,261,'joinop ::= JOIN_KW nm JOIN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(126,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(126,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(126,2,144); INSERT INTO rule(ruleid,lhs,txt)VALUES(127,261,'joinop ::= JOIN_KW nm nm JOIN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,2,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,3,144); INSERT INTO rule(ruleid,lhs,txt)VALUES(128,262,'on_using ::= ON expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(128,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(128,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(129,262,'on_using ::= USING LP idlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(129,0,145); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(129,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(129,2,266); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(129,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(130,262,'on_using ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(131,267,'indexed_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(132,263,'indexed_by ::= INDEXED BY nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(132,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(132,1,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(132,2,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(133,263,'indexed_by ::= NOT INDEXED'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(133,0,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(133,1,117); INSERT INTO rule(ruleid,lhs,txt)VALUES(134,251,'orderby_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(135,251,'orderby_opt ::= ORDER BY sortlist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,0,146); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,1,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,2,233); INSERT INTO rule(ruleid,lhs,txt)VALUES(136,233,'sortlist ::= sortlist COMMA expr sortorder nulls'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,0,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,3,221); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,4,268); INSERT INTO rule(ruleid,lhs,txt)VALUES(137,233,'sortlist ::= expr sortorder nulls'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(137,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(137,1,221); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(137,2,268); INSERT INTO rule(ruleid,lhs,txt)VALUES(138,221,'sortorder ::= ASC'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(138,0,31); INSERT INTO rule(ruleid,lhs,txt)VALUES(139,221,'sortorder ::= DESC'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(139,0,39); INSERT INTO rule(ruleid,lhs,txt)VALUES(140,221,'sortorder ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(141,268,'nulls ::= NULLS FIRST'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(141,0,83); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(141,1,84); INSERT INTO rule(ruleid,lhs,txt)VALUES(142,268,'nulls ::= NULLS LAST'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(142,0,83); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(142,1,85); INSERT INTO rule(ruleid,lhs,txt)VALUES(143,268,'nulls ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(144,249,'groupby_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(145,249,'groupby_opt ::= GROUP BY nexprlist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(145,0,147); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(145,1,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(145,2,255); INSERT INTO rule(ruleid,lhs,txt)VALUES(146,250,'having_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(147,250,'having_opt ::= HAVING expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(147,0,148); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(147,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(148,252,'limit_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(149,252,'limit_opt ::= LIMIT expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(149,0,149); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(149,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(150,252,'limit_opt ::= LIMIT expr OFFSET expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,0,149); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,1,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,2,70); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,3,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(151,252,'limit_opt ::= LIMIT expr COMMA expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(151,0,149); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(151,1,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(151,2,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(151,3,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(152,192,'cmd ::= with DELETE FROM xfullname indexed_opt where_opt_ret'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,0,269); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,1,129); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,2,143); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,3,265); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,4,267); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,5,270); INSERT INTO rule(ruleid,lhs,txt)VALUES(153,248,'where_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(154,248,'where_opt ::= WHERE expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(154,0,150); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(154,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(155,270,'where_opt_ret ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(156,270,'where_opt_ret ::= WHERE expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(156,0,150); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(156,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(157,270,'where_opt_ret ::= RETURNING selcollist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,0,151); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,1,246); INSERT INTO rule(ruleid,lhs,txt)VALUES(158,270,'where_opt_ret ::= WHERE expr RETURNING selcollist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,0,150); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,1,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,2,151); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,3,246); INSERT INTO rule(ruleid,lhs,txt)VALUES(159,192,'cmd ::= with UPDATE orconf xfullname indexed_opt SET setlist from where_opt_ret'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,0,269); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,1,130); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,2,236); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,3,265); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,4,267); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,5,131); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,6,271); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,7,247); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,8,270); INSERT INTO rule(ruleid,lhs,txt)VALUES(160,271,'setlist ::= setlist COMMA nm EQ expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,0,271); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,2,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,3,54); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,4,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(161,271,'setlist ::= setlist COMMA LP idlist RP EQ expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,0,271); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,3,266); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,4,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,5,54); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,6,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(162,271,'setlist ::= nm EQ expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,1,54); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(163,271,'setlist ::= LP idlist RP EQ expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,1,266); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,2,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,3,54); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,4,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(164,192,'cmd ::= with insert_cmd INTO xfullname idlist_opt select upsert'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,0,269); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,1,272); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,2,152); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,3,265); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,4,273); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,5,206); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,6,274); INSERT INTO rule(ruleid,lhs,txt)VALUES(165,192,'cmd ::= with insert_cmd INTO xfullname idlist_opt DEFAULT VALUES returning'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,0,269); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,1,272); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,2,152); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,3,265); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,4,273); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,5,121); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,6,140); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,7,275); INSERT INTO rule(ruleid,lhs,txt)VALUES(166,274,'upsert ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(167,274,'upsert ::= RETURNING selcollist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,0,151); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,1,246); INSERT INTO rule(ruleid,lhs,txt)VALUES(168,274,'upsert ::= ON CONFLICT LP sortlist RP where_opt DO UPDATE SET setlist where_opt upsert'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,1,37); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,3,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,4,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,5,248); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,6,62); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,7,130); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,8,131); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,9,271); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,10,248); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,11,274); INSERT INTO rule(ruleid,lhs,txt)VALUES(169,274,'upsert ::= ON CONFLICT LP sortlist RP where_opt DO NOTHING upsert'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,1,37); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,3,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,4,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,5,248); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,6,62); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,7,153); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,8,274); INSERT INTO rule(ruleid,lhs,txt)VALUES(170,274,'upsert ::= ON CONFLICT DO NOTHING returning'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,1,37); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,2,62); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,3,153); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,4,275); INSERT INTO rule(ruleid,lhs,txt)VALUES(171,274,'upsert ::= ON CONFLICT DO UPDATE SET setlist where_opt returning'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,0,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,1,37); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,2,62); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,3,130); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,4,131); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,5,271); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,6,248); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,7,275); INSERT INTO rule(ruleid,lhs,txt)VALUES(172,275,'returning ::= RETURNING selcollist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(172,0,151); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(172,1,246); INSERT INTO rule(ruleid,lhs,txt)VALUES(173,272,'insert_cmd ::= INSERT orconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(173,0,128); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(173,1,236); INSERT INTO rule(ruleid,lhs,txt)VALUES(174,272,'insert_cmd ::= REPLACE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(174,0,74); INSERT INTO rule(ruleid,lhs,txt)VALUES(175,273,'idlist_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(176,273,'idlist_opt ::= LP idlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(176,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(176,1,266); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(176,2,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(177,266,'idlist ::= idlist COMMA nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,0,266); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,2,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(178,266,'idlist ::= nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(178,0,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(179,219,'expr ::= LP expr RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(179,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(179,1,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(179,2,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(180,219,'expr ::= ID|INDEXED|JOIN_KW'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,0,119); INSERT INTO rule(ruleid,lhs,txt)VALUES(181,219,'expr ::= nm DOT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,1,142); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,2,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(182,219,'expr ::= nm DOT nm DOT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,1,142); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,2,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,3,142); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,4,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(183,218,'term ::= NULL|FLOAT|BLOB'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(183,0,122); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(183,0,154); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(183,0,155); INSERT INTO rule(ruleid,lhs,txt)VALUES(184,218,'term ::= STRING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(184,0,118); INSERT INTO rule(ruleid,lhs,txt)VALUES(185,218,'term ::= INTEGER'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(185,0,156); INSERT INTO rule(ruleid,lhs,txt)VALUES(186,219,'expr ::= VARIABLE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(186,0,157); INSERT INTO rule(ruleid,lhs,txt)VALUES(187,219,'expr ::= expr COLLATE ID|STRING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,1,114); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,2,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,2,118); INSERT INTO rule(ruleid,lhs,txt)VALUES(188,219,'expr ::= CAST LP expr AS typetoken RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,0,36); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,3,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,4,210); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,5,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(189,219,'expr ::= ID|INDEXED|JOIN_KW LP distinct exprlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,2,245); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,3,264); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,4,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(190,219,'expr ::= ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,2,245); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,3,264); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,4,146); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,5,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,6,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,7,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(191,219,'expr ::= ID|INDEXED|JOIN_KW LP STAR RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,2,109); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(192,219,'expr ::= ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,2,245); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,3,264); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,4,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,5,276); INSERT INTO rule(ruleid,lhs,txt)VALUES(193,219,'expr ::= ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,2,245); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,3,264); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,4,146); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,5,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,6,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,7,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,8,276); INSERT INTO rule(ruleid,lhs,txt)VALUES(194,219,'expr ::= ID|INDEXED|JOIN_KW LP STAR RP filter_over'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,0,119); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,2,109); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,3,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,4,276); INSERT INTO rule(ruleid,lhs,txt)VALUES(195,218,'term ::= CTIME_KW'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(195,0,101); INSERT INTO rule(ruleid,lhs,txt)VALUES(196,219,'expr ::= LP nexprlist COMMA expr RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,1,255); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,2,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,3,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,4,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(197,219,'expr ::= expr AND expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,1,44); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(198,219,'expr ::= expr OR expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,1,43); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(199,219,'expr ::= expr LT|GT|GE|LE expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,57); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,55); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,58); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,56); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(200,219,'expr ::= expr EQ|NE expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,1,54); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,1,53); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(201,219,'expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,103); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,104); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,105); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,106); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(202,219,'expr ::= expr PLUS|MINUS expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,1,107); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,1,108); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(203,219,'expr ::= expr STAR|SLASH|REM expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,1,109); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,1,110); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,1,111); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(204,219,'expr ::= expr CONCAT expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,1,112); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(205,277,'likeop ::= NOT LIKE_KW|MATCH'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,0,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,1,48); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,1,47); INSERT INTO rule(ruleid,lhs,txt)VALUES(206,219,'expr ::= expr likeop expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,1,277); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(207,219,'expr ::= expr likeop expr ESCAPE expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,1,277); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,3,59); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,4,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(208,219,'expr ::= expr ISNULL|NOTNULL'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,1,51); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,1,52); INSERT INTO rule(ruleid,lhs,txt)VALUES(209,219,'expr ::= expr NOT NULL'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,1,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,2,122); INSERT INTO rule(ruleid,lhs,txt)VALUES(210,219,'expr ::= expr IS expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,1,45); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(211,219,'expr ::= expr IS NOT expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,1,45); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,2,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,3,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(212,219,'expr ::= expr IS NOT DISTINCT FROM expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,1,45); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,2,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,3,141); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,4,143); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,5,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(213,219,'expr ::= expr IS DISTINCT FROM expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,1,45); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,2,141); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,3,143); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,4,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(214,219,'expr ::= NOT expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(214,0,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(214,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(215,219,'expr ::= BITNOT expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(215,0,115); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(215,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(216,219,'expr ::= PLUS|MINUS expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(216,0,107); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(216,0,108); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(216,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(217,219,'expr ::= expr PTR expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(217,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(217,1,113); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(217,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(218,278,'between_op ::= BETWEEN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(218,0,49); INSERT INTO rule(ruleid,lhs,txt)VALUES(219,278,'between_op ::= NOT BETWEEN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(219,0,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(219,1,49); INSERT INTO rule(ruleid,lhs,txt)VALUES(220,219,'expr ::= expr between_op expr AND expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,1,278); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,3,44); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,4,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(221,279,'in_op ::= IN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(221,0,50); INSERT INTO rule(ruleid,lhs,txt)VALUES(222,279,'in_op ::= NOT IN'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(222,0,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(222,1,50); INSERT INTO rule(ruleid,lhs,txt)VALUES(223,219,'expr ::= expr in_op LP exprlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,1,279); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,3,264); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,4,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(224,219,'expr ::= LP select RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(224,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(224,1,206); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(224,2,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(225,219,'expr ::= expr in_op LP select RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,1,279); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,3,206); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,4,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(226,219,'expr ::= expr in_op nm dbnm paren_exprlist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,1,279); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,2,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,3,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,4,280); INSERT INTO rule(ruleid,lhs,txt)VALUES(227,219,'expr ::= EXISTS LP select RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(227,0,20); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(227,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(227,2,206); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(227,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(228,219,'expr ::= CASE case_operand case_exprlist case_else END'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(228,0,158); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(228,1,281); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(228,2,282); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(228,3,283); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(228,4,11); INSERT INTO rule(ruleid,lhs,txt)VALUES(229,282,'case_exprlist ::= case_exprlist WHEN expr THEN expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(229,0,282); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(229,1,159); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(229,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(229,3,160); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(229,4,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(230,282,'case_exprlist ::= WHEN expr THEN expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(230,0,159); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(230,1,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(230,2,160); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(230,3,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(231,283,'case_else ::= ELSE expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(231,0,161); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(231,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(232,283,'case_else ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(233,281,'case_operand ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(234,264,'exprlist ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(235,255,'nexprlist ::= nexprlist COMMA expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(235,0,255); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(235,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(235,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(236,255,'nexprlist ::= expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(236,0,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(237,280,'paren_exprlist ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(238,280,'paren_exprlist ::= LP exprlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(238,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(238,1,264); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(238,2,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(239,192,'cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP sortlist RP where_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,0,199); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,1,284); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,2,162); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,3,201); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,4,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,5,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,6,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,7,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,8,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,9,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,10,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(239,11,248); INSERT INTO rule(ruleid,lhs,txt)VALUES(240,284,'uniqueflag ::= UNIQUE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(240,0,124); INSERT INTO rule(ruleid,lhs,txt)VALUES(241,284,'uniqueflag ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(242,223,'eidlist_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(243,223,'eidlist_opt ::= LP eidlist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(243,0,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(243,1,234); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(243,2,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(244,234,'eidlist ::= eidlist COMMA nm collate sortorder'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(244,0,234); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(244,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(244,2,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(244,3,285); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(244,4,221); INSERT INTO rule(ruleid,lhs,txt)VALUES(245,234,'eidlist ::= nm collate sortorder'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(245,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(245,1,285); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(245,2,221); INSERT INTO rule(ruleid,lhs,txt)VALUES(246,285,'collate ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(247,285,'collate ::= COLLATE ID|STRING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(247,0,114); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(247,1,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(247,1,118); INSERT INTO rule(ruleid,lhs,txt)VALUES(248,192,'cmd ::= DROP INDEX ifexists fullname'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(248,0,134); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(248,1,162); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(248,2,239); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(248,3,240); INSERT INTO rule(ruleid,lhs,txt)VALUES(249,192,'cmd ::= VACUUM vinto'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(249,0,79); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(249,1,286); INSERT INTO rule(ruleid,lhs,txt)VALUES(250,192,'cmd ::= VACUUM nm vinto'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(250,0,79); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(250,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(250,2,286); INSERT INTO rule(ruleid,lhs,txt)VALUES(251,286,'vinto ::= INTO expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(251,0,152); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(251,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(252,286,'vinto ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(253,192,'cmd ::= PRAGMA nm dbnm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,0,71); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,2,202); INSERT INTO rule(ruleid,lhs,txt)VALUES(254,192,'cmd ::= PRAGMA nm dbnm EQ nmnum'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,0,71); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,2,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,3,54); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,4,287); INSERT INTO rule(ruleid,lhs,txt)VALUES(255,192,'cmd ::= PRAGMA nm dbnm LP nmnum RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,0,71); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,2,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,3,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,4,287); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,5,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(256,192,'cmd ::= PRAGMA nm dbnm EQ minus_num'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(256,0,71); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(256,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(256,2,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(256,3,54); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(256,4,214); INSERT INTO rule(ruleid,lhs,txt)VALUES(257,192,'cmd ::= PRAGMA nm dbnm LP minus_num RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,0,71); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,2,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,3,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,4,214); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,5,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(258,213,'plus_num ::= PLUS INTEGER|FLOAT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(258,0,107); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(258,1,156); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(258,1,154); INSERT INTO rule(ruleid,lhs,txt)VALUES(259,214,'minus_num ::= MINUS INTEGER|FLOAT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,0,108); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,1,156); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,1,154); INSERT INTO rule(ruleid,lhs,txt)VALUES(260,192,'cmd ::= createkw trigger_decl BEGIN trigger_cmd_list END'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(260,0,199); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(260,1,288); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(260,2,5); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(260,3,289); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(260,4,11); INSERT INTO rule(ruleid,lhs,txt)VALUES(261,288,'trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,0,200); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,1,78); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,2,201); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,3,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,4,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,5,290); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,6,291); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,7,116); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,8,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,9,292); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,10,293); INSERT INTO rule(ruleid,lhs,txt)VALUES(262,290,'trigger_time ::= BEFORE|AFTER'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(262,0,33); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(262,0,29); INSERT INTO rule(ruleid,lhs,txt)VALUES(263,290,'trigger_time ::= INSTEAD OF'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(263,0,66); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(263,1,69); INSERT INTO rule(ruleid,lhs,txt)VALUES(264,290,'trigger_time ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(265,291,'trigger_event ::= DELETE|INSERT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(265,0,129); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(265,0,128); INSERT INTO rule(ruleid,lhs,txt)VALUES(266,291,'trigger_event ::= UPDATE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(266,0,130); INSERT INTO rule(ruleid,lhs,txt)VALUES(267,291,'trigger_event ::= UPDATE OF idlist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(267,0,130); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(267,1,69); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(267,2,266); INSERT INTO rule(ruleid,lhs,txt)VALUES(268,293,'when_clause ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(269,293,'when_clause ::= WHEN expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(269,0,159); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(269,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(270,289,'trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(270,0,289); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(270,1,294); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(270,2,1); INSERT INTO rule(ruleid,lhs,txt)VALUES(271,289,'trigger_cmd_list ::= trigger_cmd SEMI'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(271,0,294); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(271,1,1); INSERT INTO rule(ruleid,lhs,txt)VALUES(272,295,'tridxby ::= INDEXED BY nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(272,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(272,1,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(272,2,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(273,295,'tridxby ::= NOT INDEXED'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,0,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,1,117); INSERT INTO rule(ruleid,lhs,txt)VALUES(274,294,'trigger_cmd ::= UPDATE orconf xfullname tridxby SET setlist from where_opt scanpt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,0,130); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,1,236); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,2,265); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,3,295); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,4,131); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,5,271); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,6,247); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,7,248); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,8,215); INSERT INTO rule(ruleid,lhs,txt)VALUES(275,294,'trigger_cmd ::= scanpt insert_cmd INTO xfullname idlist_opt select upsert scanpt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,0,215); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,1,272); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,2,152); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,3,265); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,4,273); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,5,206); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,6,274); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,7,215); INSERT INTO rule(ruleid,lhs,txt)VALUES(276,294,'trigger_cmd ::= DELETE FROM xfullname tridxby where_opt scanpt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,0,129); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,1,143); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,2,265); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,3,295); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,4,248); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,5,215); INSERT INTO rule(ruleid,lhs,txt)VALUES(277,294,'trigger_cmd ::= scanpt select scanpt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(277,0,215); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(277,1,206); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(277,2,215); INSERT INTO rule(ruleid,lhs,txt)VALUES(278,219,'expr ::= RAISE LP IGNORE RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,0,72); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,2,64); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(279,219,'expr ::= RAISE LP raisetype COMMA expr RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(279,0,72); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(279,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(279,2,238); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(279,3,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(279,4,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(279,5,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(280,238,'raisetype ::= ROLLBACK'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(280,0,12); INSERT INTO rule(ruleid,lhs,txt)VALUES(281,238,'raisetype ::= ABORT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(281,0,27); INSERT INTO rule(ruleid,lhs,txt)VALUES(282,238,'raisetype ::= FAIL'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(282,0,42); INSERT INTO rule(ruleid,lhs,txt)VALUES(283,192,'cmd ::= DROP TRIGGER ifexists fullname'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,0,134); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,1,78); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,2,239); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,3,240); INSERT INTO rule(ruleid,lhs,txt)VALUES(284,192,'cmd ::= ATTACH database_kw_opt expr AS expr key_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,0,32); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,1,296); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,2,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,3,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,4,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,5,297); INSERT INTO rule(ruleid,lhs,txt)VALUES(285,192,'cmd ::= DETACH database_kw_opt expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(285,0,40); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(285,1,296); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(285,2,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(286,297,'key_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(287,297,'key_opt ::= KEY expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(287,0,68); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(287,1,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(288,192,'cmd ::= REINDEX'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(288,0,99); INSERT INTO rule(ruleid,lhs,txt)VALUES(289,192,'cmd ::= REINDEX nm dbnm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(289,0,99); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(289,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(289,2,202); INSERT INTO rule(ruleid,lhs,txt)VALUES(290,192,'cmd ::= ANALYZE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(290,0,30); INSERT INTO rule(ruleid,lhs,txt)VALUES(291,192,'cmd ::= ANALYZE nm dbnm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,0,30); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,1,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,2,202); INSERT INTO rule(ruleid,lhs,txt)VALUES(292,192,'cmd ::= ALTER TABLE fullname RENAME TO nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,3,100); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,4,15); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,5,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(293,192,'cmd ::= alter_add carglist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(293,0,298); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(293,1,209); INSERT INTO rule(ruleid,lhs,txt)VALUES(294,298,'alter_add ::= ALTER TABLE fullname ADD kwcolumn_opt nm typetoken'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(294,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(294,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(294,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(294,3,164); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(294,4,299); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(294,5,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(294,6,210); INSERT INTO rule(ruleid,lhs,txt)VALUES(295,192,'cmd ::= ALTER TABLE fullname DROP kwcolumn_opt nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,3,134); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,4,299); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,5,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(296,192,'cmd ::= ALTER TABLE fullname RENAME kwcolumn_opt nm TO nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,3,100); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,4,299); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,5,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,6,15); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,7,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(297,192,'cmd ::= ALTER TABLE fullname DROP CONSTRAINT nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,3,134); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,4,120); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,5,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(298,192,'cmd ::= ALTER TABLE fullname ALTER kwcolumn_opt nm DROP NOT NULL'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,3,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,4,299); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,5,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,6,134); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,7,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,8,122); INSERT INTO rule(ruleid,lhs,txt)VALUES(299,192,'cmd ::= ALTER TABLE fullname ALTER kwcolumn_opt nm SET NOT NULL onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,3,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,4,299); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,5,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,6,131); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,7,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,8,122); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(299,9,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(300,192,'cmd ::= ALTER TABLE fullname ADD CONSTRAINT nm CHECK LP expr RP onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,3,164); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,4,120); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,5,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,6,125); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,7,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,8,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,9,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,10,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(301,192,'cmd ::= ALTER TABLE fullname ADD CHECK LP expr RP onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,0,163); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,1,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,2,240); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,3,164); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,4,125); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,5,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,6,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,7,23); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,8,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(302,192,'cmd ::= create_vtab'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(302,0,300); INSERT INTO rule(ruleid,lhs,txt)VALUES(303,192,'cmd ::= create_vtab LP vtabarglist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(303,0,300); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(303,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(303,2,301); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(303,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(304,300,'create_vtab ::= createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,0,199); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,1,81); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,2,16); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,3,201); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,4,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,5,202); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,6,145); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,7,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(305,302,'vtabarg ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(306,303,'vtabargtoken ::= ANY'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(306,0,102); INSERT INTO rule(ruleid,lhs,txt)VALUES(307,303,'vtabargtoken ::= lp anylist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(307,0,304); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(307,1,305); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(307,2,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(308,304,'lp ::= LP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(308,0,22); INSERT INTO rule(ruleid,lhs,txt)VALUES(309,269,'with ::= WITH wqlist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(309,0,82); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(309,1,243); INSERT INTO rule(ruleid,lhs,txt)VALUES(310,269,'with ::= WITH RECURSIVE wqlist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(310,0,82); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(310,1,73); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(310,2,243); INSERT INTO rule(ruleid,lhs,txt)VALUES(311,307,'wqas ::= AS'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(311,0,24); INSERT INTO rule(ruleid,lhs,txt)VALUES(312,307,'wqas ::= AS MATERIALIZED'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(312,0,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(312,1,98); INSERT INTO rule(ruleid,lhs,txt)VALUES(313,307,'wqas ::= AS NOT MATERIALIZED'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(313,0,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(313,1,19); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(313,2,98); INSERT INTO rule(ruleid,lhs,txt)VALUES(314,306,'wqitem ::= withnm eidlist_opt wqas LP select RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,0,308); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,1,223); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,2,307); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,3,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,4,206); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,5,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(315,308,'withnm ::= nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(315,0,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(316,243,'wqlist ::= wqitem'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(316,0,306); INSERT INTO rule(ruleid,lhs,txt)VALUES(317,243,'wqlist ::= wqlist COMMA wqitem'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(317,0,243); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(317,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(317,2,306); INSERT INTO rule(ruleid,lhs,txt)VALUES(318,309,'windowdefn_list ::= windowdefn_list COMMA windowdefn'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(318,0,309); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(318,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(318,2,310); INSERT INTO rule(ruleid,lhs,txt)VALUES(319,310,'windowdefn ::= nm AS LP window RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(319,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(319,1,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(319,2,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(319,3,311); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(319,4,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(320,311,'window ::= PARTITION BY nexprlist orderby_opt frame_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(320,0,88); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(320,1,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(320,2,255); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(320,3,251); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(320,4,312); INSERT INTO rule(ruleid,lhs,txt)VALUES(321,311,'window ::= nm PARTITION BY nexprlist orderby_opt frame_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,1,88); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,2,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,3,255); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,4,251); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,5,312); INSERT INTO rule(ruleid,lhs,txt)VALUES(322,311,'window ::= ORDER BY sortlist frame_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,0,146); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,1,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,2,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,3,312); INSERT INTO rule(ruleid,lhs,txt)VALUES(323,311,'window ::= nm ORDER BY sortlist frame_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(323,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(323,1,146); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(323,2,34); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(323,3,233); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(323,4,312); INSERT INTO rule(ruleid,lhs,txt)VALUES(324,311,'window ::= nm frame_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(324,0,195); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(324,1,312); INSERT INTO rule(ruleid,lhs,txt)VALUES(325,312,'frame_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(326,312,'frame_opt ::= range_or_rows frame_bound_s frame_exclude_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(326,0,316); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(326,1,318); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(326,2,320); INSERT INTO rule(ruleid,lhs,txt)VALUES(327,312,'frame_opt ::= range_or_rows BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(327,0,316); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(327,1,49); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(327,2,318); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(327,3,44); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(327,4,319); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(327,5,320); INSERT INTO rule(ruleid,lhs,txt)VALUES(328,316,'range_or_rows ::= RANGE|ROWS|GROUPS'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(328,0,90); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(328,0,77); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(328,0,93); INSERT INTO rule(ruleid,lhs,txt)VALUES(329,318,'frame_bound_s ::= frame_bound'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(329,0,317); INSERT INTO rule(ruleid,lhs,txt)VALUES(330,318,'frame_bound_s ::= UNBOUNDED PRECEDING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(330,0,91); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(330,1,89); INSERT INTO rule(ruleid,lhs,txt)VALUES(331,319,'frame_bound_e ::= frame_bound'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(331,0,317); INSERT INTO rule(ruleid,lhs,txt)VALUES(332,319,'frame_bound_e ::= UNBOUNDED FOLLOWING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(332,0,91); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(332,1,87); INSERT INTO rule(ruleid,lhs,txt)VALUES(333,317,'frame_bound ::= expr PRECEDING|FOLLOWING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(333,0,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(333,1,89); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(333,1,87); INSERT INTO rule(ruleid,lhs,txt)VALUES(334,317,'frame_bound ::= CURRENT ROW'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(334,0,86); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(334,1,76); INSERT INTO rule(ruleid,lhs,txt)VALUES(335,320,'frame_exclude_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(336,320,'frame_exclude_opt ::= EXCLUDE frame_exclude'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(336,0,92); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(336,1,321); INSERT INTO rule(ruleid,lhs,txt)VALUES(337,321,'frame_exclude ::= NO OTHERS'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(337,0,67); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(337,1,94); INSERT INTO rule(ruleid,lhs,txt)VALUES(338,321,'frame_exclude ::= CURRENT ROW'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(338,0,86); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(338,1,76); INSERT INTO rule(ruleid,lhs,txt)VALUES(339,321,'frame_exclude ::= GROUP|TIES'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(339,0,147); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(339,0,95); INSERT INTO rule(ruleid,lhs,txt)VALUES(340,253,'window_clause ::= WINDOW windowdefn_list'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(340,0,165); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(340,1,309); INSERT INTO rule(ruleid,lhs,txt)VALUES(341,276,'filter_over ::= filter_clause over_clause'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(341,0,314); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(341,1,315); INSERT INTO rule(ruleid,lhs,txt)VALUES(342,276,'filter_over ::= over_clause'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(342,0,315); INSERT INTO rule(ruleid,lhs,txt)VALUES(343,276,'filter_over ::= filter_clause'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(343,0,314); INSERT INTO rule(ruleid,lhs,txt)VALUES(344,315,'over_clause ::= OVER LP window RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(344,0,166); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(344,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(344,2,311); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(344,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(345,315,'over_clause ::= OVER nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(345,0,166); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(345,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(346,314,'filter_clause ::= FILTER LP WHERE expr RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(346,0,167); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(346,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(346,2,150); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(346,3,219); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(346,4,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(347,218,'term ::= QNUMBER'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(347,0,183); INSERT INTO rule(ruleid,lhs,txt)VALUES(348,187,'input ::= cmdlist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(348,0,188); INSERT INTO rule(ruleid,lhs,txt)VALUES(349,188,'cmdlist ::= cmdlist ecmd'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(349,0,188); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(349,1,189); INSERT INTO rule(ruleid,lhs,txt)VALUES(350,188,'cmdlist ::= ecmd'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(350,0,189); INSERT INTO rule(ruleid,lhs,txt)VALUES(351,189,'ecmd ::= SEMI'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(351,0,1); INSERT INTO rule(ruleid,lhs,txt)VALUES(352,189,'ecmd ::= cmdx SEMI'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(352,0,190); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(352,1,1); INSERT INTO rule(ruleid,lhs,txt)VALUES(353,189,'ecmd ::= explain cmdx SEMI'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(353,0,191); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(353,1,190); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(353,2,1); INSERT INTO rule(ruleid,lhs,txt)VALUES(354,194,'trans_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(355,194,'trans_opt ::= TRANSACTION'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(355,0,6); INSERT INTO rule(ruleid,lhs,txt)VALUES(356,194,'trans_opt ::= TRANSACTION nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(356,0,6); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(356,1,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(357,196,'savepoint_opt ::= SAVEPOINT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(357,0,13); INSERT INTO rule(ruleid,lhs,txt)VALUES(358,196,'savepoint_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(359,192,'cmd ::= create_table create_table_args'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(359,0,197); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(359,1,198); INSERT INTO rule(ruleid,lhs,txt)VALUES(360,205,'table_option_set ::= table_option'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(360,0,207); INSERT INTO rule(ruleid,lhs,txt)VALUES(361,203,'columnlist ::= columnlist COMMA columnname carglist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(361,0,203); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(361,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(361,2,208); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(361,3,209); INSERT INTO rule(ruleid,lhs,txt)VALUES(362,203,'columnlist ::= columnname carglist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(362,0,208); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(362,1,209); INSERT INTO rule(ruleid,lhs,txt)VALUES(363,195,'nm ::= ID|INDEXED|JOIN_KW'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(363,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(363,0,117); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(363,0,119); INSERT INTO rule(ruleid,lhs,txt)VALUES(364,195,'nm ::= STRING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(364,0,118); INSERT INTO rule(ruleid,lhs,txt)VALUES(365,210,'typetoken ::= typename'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(365,0,211); INSERT INTO rule(ruleid,lhs,txt)VALUES(366,211,'typename ::= ID|STRING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(366,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(366,0,118); INSERT INTO rule(ruleid,lhs,txt)VALUES(367,212,'signed ::= plus_num'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(367,0,213); INSERT INTO rule(ruleid,lhs,txt)VALUES(368,212,'signed ::= minus_num'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(368,0,214); INSERT INTO rule(ruleid,lhs,txt)VALUES(369,209,'carglist ::= carglist ccons'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(369,0,209); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(369,1,217); INSERT INTO rule(ruleid,lhs,txt)VALUES(370,209,'carglist ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(371,217,'ccons ::= NULL onconf'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(371,0,122); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(371,1,220); INSERT INTO rule(ruleid,lhs,txt)VALUES(372,217,'ccons ::= GENERATED ALWAYS AS generated'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(372,0,96); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(372,1,97); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(372,2,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(372,3,226); INSERT INTO rule(ruleid,lhs,txt)VALUES(373,217,'ccons ::= AS generated'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(373,0,24); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(373,1,226); INSERT INTO rule(ruleid,lhs,txt)VALUES(374,204,'conslist_opt ::= COMMA conslist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(374,0,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(374,1,230); INSERT INTO rule(ruleid,lhs,txt)VALUES(375,230,'conslist ::= conslist tconscomma tcons'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(375,0,230); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(375,1,231); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(375,2,232); INSERT INTO rule(ruleid,lhs,txt)VALUES(376,230,'conslist ::= tcons'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(376,0,232); INSERT INTO rule(ruleid,lhs,txt)VALUES(377,231,'tconscomma ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(378,235,'defer_subclause_opt ::= defer_subclause'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(378,0,225); INSERT INTO rule(ruleid,lhs,txt)VALUES(379,237,'resolvetype ::= raisetype'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(379,0,238); INSERT INTO rule(ruleid,lhs,txt)VALUES(380,241,'selectnowith ::= oneselect'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(380,0,242); INSERT INTO rule(ruleid,lhs,txt)VALUES(381,242,'oneselect ::= values'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(381,0,254); INSERT INTO rule(ruleid,lhs,txt)VALUES(382,257,'sclp ::= selcollist COMMA'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(382,0,246); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(382,1,25); INSERT INTO rule(ruleid,lhs,txt)VALUES(383,258,'as ::= ID|STRING'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(383,0,60); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(383,0,118); INSERT INTO rule(ruleid,lhs,txt)VALUES(384,267,'indexed_opt ::= indexed_by'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(384,0,263); INSERT INTO rule(ruleid,lhs,txt)VALUES(385,275,'returning ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(386,219,'expr ::= term'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(386,0,218); INSERT INTO rule(ruleid,lhs,txt)VALUES(387,277,'likeop ::= LIKE_KW|MATCH'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(387,0,48); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(387,0,47); INSERT INTO rule(ruleid,lhs,txt)VALUES(388,281,'case_operand ::= expr'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(388,0,219); INSERT INTO rule(ruleid,lhs,txt)VALUES(389,264,'exprlist ::= nexprlist'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(389,0,255); INSERT INTO rule(ruleid,lhs,txt)VALUES(390,287,'nmnum ::= plus_num'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(390,0,213); INSERT INTO rule(ruleid,lhs,txt)VALUES(391,287,'nmnum ::= nm'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(391,0,195); INSERT INTO rule(ruleid,lhs,txt)VALUES(392,287,'nmnum ::= ON'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(392,0,116); INSERT INTO rule(ruleid,lhs,txt)VALUES(393,287,'nmnum ::= DELETE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(393,0,129); INSERT INTO rule(ruleid,lhs,txt)VALUES(394,287,'nmnum ::= DEFAULT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(394,0,121); INSERT INTO rule(ruleid,lhs,txt)VALUES(395,213,'plus_num ::= INTEGER|FLOAT'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(395,0,156); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(395,0,154); INSERT INTO rule(ruleid,lhs,txt)VALUES(396,292,'foreach_clause ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(397,292,'foreach_clause ::= FOR EACH ROW'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(397,0,63); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(397,1,41); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(397,2,76); INSERT INTO rule(ruleid,lhs,txt)VALUES(398,295,'tridxby ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(399,296,'database_kw_opt ::= DATABASE'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(399,0,38); INSERT INTO rule(ruleid,lhs,txt)VALUES(400,296,'database_kw_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(401,299,'kwcolumn_opt ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(402,299,'kwcolumn_opt ::= COLUMNKW'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(402,0,61); INSERT INTO rule(ruleid,lhs,txt)VALUES(403,301,'vtabarglist ::= vtabarg'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(403,0,302); INSERT INTO rule(ruleid,lhs,txt)VALUES(404,301,'vtabarglist ::= vtabarglist COMMA vtabarg'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(404,0,301); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(404,1,25); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(404,2,302); INSERT INTO rule(ruleid,lhs,txt)VALUES(405,302,'vtabarg ::= vtabarg vtabargtoken'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(405,0,302); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(405,1,303); INSERT INTO rule(ruleid,lhs,txt)VALUES(406,305,'anylist ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(407,305,'anylist ::= anylist LP anylist RP'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(407,0,305); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(407,1,22); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(407,2,305); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(407,3,23); INSERT INTO rule(ruleid,lhs,txt)VALUES(408,305,'anylist ::= anylist ANY'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(408,0,305); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(408,1,102); INSERT INTO rule(ruleid,lhs,txt)VALUES(409,269,'with ::='); INSERT INTO rule(ruleid,lhs,txt)VALUES(410,309,'windowdefn_list ::= windowdefn'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(410,0,310); INSERT INTO rule(ruleid,lhs,txt)VALUES(411,311,'window ::= frame_opt'); INSERT INTO rulerhs(ruleid,pos,sym)VALUES(411,0,312); COMMIT;