AryaWu/sqlite

1BEGIN;2CREATE TABLE symbol(3  id INTEGER PRIMARY KEY,4  name TEXT NOT NULL,5  isTerminal BOOLEAN NOT NULL,6  fallback INTEGER REFERENCES symbol DEFERRABLE INITIALLY DEFERRED7);8INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(0,'$',TRUE,NULL);9INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(1,'SEMI',TRUE,NULL);10INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(2,'EXPLAIN',TRUE,60);11INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(3,'QUERY',TRUE,60);12INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(4,'PLAN',TRUE,60);13INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(5,'BEGIN',TRUE,60);14INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(6,'TRANSACTION',TRUE,NULL);15INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(7,'DEFERRED',TRUE,60);16INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(8,'IMMEDIATE',TRUE,60);17INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(9,'EXCLUSIVE',TRUE,60);18INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(10,'COMMIT',TRUE,NULL);19INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(11,'END',TRUE,60);20INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(12,'ROLLBACK',TRUE,60);21INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(13,'SAVEPOINT',TRUE,60);22INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(14,'RELEASE',TRUE,60);23INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(15,'TO',TRUE,NULL);24INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(16,'TABLE',TRUE,NULL);25INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(17,'CREATE',TRUE,NULL);26INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(18,'IF',TRUE,60);27INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(19,'NOT',TRUE,NULL);28INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(20,'EXISTS',TRUE,NULL);29INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(21,'TEMP',TRUE,60);30INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(22,'LP',TRUE,NULL);31INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(23,'RP',TRUE,NULL);32INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(24,'AS',TRUE,NULL);33INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(25,'COMMA',TRUE,NULL);34INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(26,'WITHOUT',TRUE,60);35INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(27,'ABORT',TRUE,60);36INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(28,'ACTION',TRUE,60);37INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(29,'AFTER',TRUE,60);38INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(30,'ANALYZE',TRUE,60);39INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(31,'ASC',TRUE,60);40INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(32,'ATTACH',TRUE,60);41INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(33,'BEFORE',TRUE,60);42INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(34,'BY',TRUE,60);43INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(35,'CASCADE',TRUE,60);44INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(36,'CAST',TRUE,60);45INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(37,'CONFLICT',TRUE,60);46INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(38,'DATABASE',TRUE,60);47INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(39,'DESC',TRUE,60);48INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(40,'DETACH',TRUE,60);49INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(41,'EACH',TRUE,60);50INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(42,'FAIL',TRUE,60);51INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(43,'OR',TRUE,NULL);52INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(44,'AND',TRUE,NULL);53INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(45,'IS',TRUE,NULL);54INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(46,'ISNOT',TRUE,NULL);55INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(47,'MATCH',TRUE,60);56INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(48,'LIKE_KW',TRUE,60);57INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(49,'BETWEEN',TRUE,NULL);58INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(50,'IN',TRUE,NULL);59INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(51,'ISNULL',TRUE,NULL);60INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(52,'NOTNULL',TRUE,NULL);61INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(53,'NE',TRUE,NULL);62INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(54,'EQ',TRUE,NULL);63INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(55,'GT',TRUE,NULL);64INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(56,'LE',TRUE,NULL);65INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(57,'LT',TRUE,NULL);66INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(58,'GE',TRUE,NULL);67INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(59,'ESCAPE',TRUE,NULL);68INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(60,'ID',TRUE,NULL);69INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(61,'COLUMNKW',TRUE,60);70INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(62,'DO',TRUE,60);71INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(63,'FOR',TRUE,60);72INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(64,'IGNORE',TRUE,60);73INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(65,'INITIALLY',TRUE,60);74INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(66,'INSTEAD',TRUE,60);75INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(67,'NO',TRUE,60);76INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(68,'KEY',TRUE,60);77INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(69,'OF',TRUE,60);78INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(70,'OFFSET',TRUE,60);79INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(71,'PRAGMA',TRUE,60);80INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(72,'RAISE',TRUE,60);81INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(73,'RECURSIVE',TRUE,60);82INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(74,'REPLACE',TRUE,60);83INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(75,'RESTRICT',TRUE,60);84INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(76,'ROW',TRUE,60);85INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(77,'ROWS',TRUE,60);86INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(78,'TRIGGER',TRUE,60);87INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(79,'VACUUM',TRUE,60);88INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(80,'VIEW',TRUE,60);89INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(81,'VIRTUAL',TRUE,60);90INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(82,'WITH',TRUE,60);91INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(83,'NULLS',TRUE,60);92INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(84,'FIRST',TRUE,60);93INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(85,'LAST',TRUE,60);94INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(86,'CURRENT',TRUE,60);95INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(87,'FOLLOWING',TRUE,60);96INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(88,'PARTITION',TRUE,60);97INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(89,'PRECEDING',TRUE,60);98INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(90,'RANGE',TRUE,60);99INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(91,'UNBOUNDED',TRUE,60);100INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(92,'EXCLUDE',TRUE,60);101INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(93,'GROUPS',TRUE,60);102INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(94,'OTHERS',TRUE,60);103INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(95,'TIES',TRUE,60);104INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(96,'GENERATED',TRUE,60);105INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(97,'ALWAYS',TRUE,60);106INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(98,'MATERIALIZED',TRUE,60);107INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(99,'REINDEX',TRUE,60);108INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(100,'RENAME',TRUE,60);109INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(101,'CTIME_KW',TRUE,60);110INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(102,'ANY',TRUE,NULL);111INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(103,'BITAND',TRUE,NULL);112INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(104,'BITOR',TRUE,NULL);113INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(105,'LSHIFT',TRUE,NULL);114INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(106,'RSHIFT',TRUE,NULL);115INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(107,'PLUS',TRUE,NULL);116INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(108,'MINUS',TRUE,NULL);117INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(109,'STAR',TRUE,NULL);118INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(110,'SLASH',TRUE,NULL);119INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(111,'REM',TRUE,NULL);120INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(112,'CONCAT',TRUE,NULL);121INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(113,'PTR',TRUE,NULL);122INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(114,'COLLATE',TRUE,NULL);123INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(115,'BITNOT',TRUE,NULL);124INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(116,'ON',TRUE,NULL);125INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(117,'INDEXED',TRUE,NULL);126INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(118,'STRING',TRUE,NULL);127INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(119,'JOIN_KW',TRUE,NULL);128INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(120,'CONSTRAINT',TRUE,NULL);129INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(121,'DEFAULT',TRUE,NULL);130INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(122,'NULL',TRUE,NULL);131INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(123,'PRIMARY',TRUE,NULL);132INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(124,'UNIQUE',TRUE,NULL);133INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(125,'CHECK',TRUE,NULL);134INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(126,'REFERENCES',TRUE,NULL);135INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(127,'AUTOINCR',TRUE,NULL);136INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(128,'INSERT',TRUE,NULL);137INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(129,'DELETE',TRUE,NULL);138INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(130,'UPDATE',TRUE,NULL);139INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(131,'SET',TRUE,NULL);140INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(132,'DEFERRABLE',TRUE,NULL);141INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(133,'FOREIGN',TRUE,NULL);142INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(134,'DROP',TRUE,NULL);143INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(135,'UNION',TRUE,NULL);144INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(136,'ALL',TRUE,NULL);145INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(137,'EXCEPT',TRUE,NULL);146INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(138,'INTERSECT',TRUE,NULL);147INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(139,'SELECT',TRUE,NULL);148INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(140,'VALUES',TRUE,NULL);149INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(141,'DISTINCT',TRUE,NULL);150INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(142,'DOT',TRUE,NULL);151INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(143,'FROM',TRUE,NULL);152INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(144,'JOIN',TRUE,NULL);153INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(145,'USING',TRUE,NULL);154INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(146,'ORDER',TRUE,NULL);155INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(147,'GROUP',TRUE,NULL);156INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(148,'HAVING',TRUE,NULL);157INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(149,'LIMIT',TRUE,NULL);158INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(150,'WHERE',TRUE,NULL);159INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(151,'RETURNING',TRUE,NULL);160INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(152,'INTO',TRUE,NULL);161INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(153,'NOTHING',TRUE,NULL);162INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(154,'FLOAT',TRUE,NULL);163INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(155,'BLOB',TRUE,NULL);164INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(156,'INTEGER',TRUE,NULL);165INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(157,'VARIABLE',TRUE,NULL);166INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(158,'CASE',TRUE,NULL);167INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(159,'WHEN',TRUE,NULL);168INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(160,'THEN',TRUE,NULL);169INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(161,'ELSE',TRUE,NULL);170INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(162,'INDEX',TRUE,NULL);171INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(163,'ALTER',TRUE,NULL);172INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(164,'ADD',TRUE,NULL);173INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(165,'WINDOW',TRUE,NULL);174INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(166,'OVER',TRUE,NULL);175INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(167,'FILTER',TRUE,NULL);176INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(168,'COLUMN',TRUE,NULL);177INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(169,'AGG_FUNCTION',TRUE,NULL);178INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(170,'AGG_COLUMN',TRUE,NULL);179INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(171,'TRUEFALSE',TRUE,NULL);180INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(172,'FUNCTION',TRUE,NULL);181INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(173,'UPLUS',TRUE,NULL);182INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(174,'UMINUS',TRUE,NULL);183INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(175,'TRUTH',TRUE,NULL);184INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(176,'REGISTER',TRUE,NULL);185INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(177,'VECTOR',TRUE,NULL);186INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(178,'SELECT_COLUMN',TRUE,NULL);187INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(179,'IF_NULL_ROW',TRUE,NULL);188INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(180,'ASTERISK',TRUE,NULL);189INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(181,'SPAN',TRUE,NULL);190INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(182,'ERROR',TRUE,NULL);191INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(183,'QNUMBER',TRUE,NULL);192INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(184,'SPACE',TRUE,NULL);193INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(185,'COMMENT',TRUE,NULL);194INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(186,'ILLEGAL',TRUE,NULL);195INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(187,'input',FALSE,NULL);196INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(188,'cmdlist',FALSE,NULL);197INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(189,'ecmd',FALSE,NULL);198INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(190,'cmdx',FALSE,NULL);199INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(191,'explain',FALSE,NULL);200INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(192,'cmd',FALSE,NULL);201INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(193,'transtype',FALSE,NULL);202INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(194,'trans_opt',FALSE,NULL);203INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(195,'nm',FALSE,NULL);204INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(196,'savepoint_opt',FALSE,NULL);205INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(197,'create_table',FALSE,NULL);206INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(198,'create_table_args',FALSE,NULL);207INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(199,'createkw',FALSE,NULL);208INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(200,'temp',FALSE,NULL);209INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(201,'ifnotexists',FALSE,NULL);210INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(202,'dbnm',FALSE,NULL);211INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(203,'columnlist',FALSE,NULL);212INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(204,'conslist_opt',FALSE,NULL);213INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(205,'table_option_set',FALSE,NULL);214INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(206,'select',FALSE,NULL);215INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(207,'table_option',FALSE,NULL);216INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(208,'columnname',FALSE,NULL);217INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(209,'carglist',FALSE,NULL);218INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(210,'typetoken',FALSE,NULL);219INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(211,'typename',FALSE,NULL);220INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(212,'signed',FALSE,NULL);221INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(213,'plus_num',FALSE,NULL);222INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(214,'minus_num',FALSE,NULL);223INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(215,'scanpt',FALSE,NULL);224INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(216,'scantok',FALSE,NULL);225INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(217,'ccons',FALSE,NULL);226INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(218,'term',FALSE,NULL);227INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(219,'expr',FALSE,NULL);228INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(220,'onconf',FALSE,NULL);229INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(221,'sortorder',FALSE,NULL);230INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(222,'autoinc',FALSE,NULL);231INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(223,'eidlist_opt',FALSE,NULL);232INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(224,'refargs',FALSE,NULL);233INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(225,'defer_subclause',FALSE,NULL);234INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(226,'generated',FALSE,NULL);235INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(227,'refarg',FALSE,NULL);236INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(228,'refact',FALSE,NULL);237INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(229,'init_deferred_pred_opt',FALSE,NULL);238INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(230,'conslist',FALSE,NULL);239INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(231,'tconscomma',FALSE,NULL);240INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(232,'tcons',FALSE,NULL);241INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(233,'sortlist',FALSE,NULL);242INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(234,'eidlist',FALSE,NULL);243INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(235,'defer_subclause_opt',FALSE,NULL);244INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(236,'orconf',FALSE,NULL);245INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(237,'resolvetype',FALSE,NULL);246INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(238,'raisetype',FALSE,NULL);247INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(239,'ifexists',FALSE,NULL);248INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(240,'fullname',FALSE,NULL);249INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(241,'selectnowith',FALSE,NULL);250INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(242,'oneselect',FALSE,NULL);251INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(243,'wqlist',FALSE,NULL);252INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(244,'multiselect_op',FALSE,NULL);253INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(245,'distinct',FALSE,NULL);254INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(246,'selcollist',FALSE,NULL);255INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(247,'from',FALSE,NULL);256INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(248,'where_opt',FALSE,NULL);257INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(249,'groupby_opt',FALSE,NULL);258INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(250,'having_opt',FALSE,NULL);259INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(251,'orderby_opt',FALSE,NULL);260INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(252,'limit_opt',FALSE,NULL);261INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(253,'window_clause',FALSE,NULL);262INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(254,'values',FALSE,NULL);263INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(255,'nexprlist',FALSE,NULL);264INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(256,'mvalues',FALSE,NULL);265INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(257,'sclp',FALSE,NULL);266INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(258,'as',FALSE,NULL);267INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(259,'seltablist',FALSE,NULL);268INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(260,'stl_prefix',FALSE,NULL);269INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(261,'joinop',FALSE,NULL);270INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(262,'on_using',FALSE,NULL);271INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(263,'indexed_by',FALSE,NULL);272INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(264,'exprlist',FALSE,NULL);273INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(265,'xfullname',FALSE,NULL);274INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(266,'idlist',FALSE,NULL);275INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(267,'indexed_opt',FALSE,NULL);276INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(268,'nulls',FALSE,NULL);277INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(269,'with',FALSE,NULL);278INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(270,'where_opt_ret',FALSE,NULL);279INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(271,'setlist',FALSE,NULL);280INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(272,'insert_cmd',FALSE,NULL);281INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(273,'idlist_opt',FALSE,NULL);282INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(274,'upsert',FALSE,NULL);283INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(275,'returning',FALSE,NULL);284INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(276,'filter_over',FALSE,NULL);285INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(277,'likeop',FALSE,NULL);286INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(278,'between_op',FALSE,NULL);287INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(279,'in_op',FALSE,NULL);288INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(280,'paren_exprlist',FALSE,NULL);289INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(281,'case_operand',FALSE,NULL);290INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(282,'case_exprlist',FALSE,NULL);291INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(283,'case_else',FALSE,NULL);292INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(284,'uniqueflag',FALSE,NULL);293INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(285,'collate',FALSE,NULL);294INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(286,'vinto',FALSE,NULL);295INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(287,'nmnum',FALSE,NULL);296INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(288,'trigger_decl',FALSE,NULL);297INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(289,'trigger_cmd_list',FALSE,NULL);298INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(290,'trigger_time',FALSE,NULL);299INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(291,'trigger_event',FALSE,NULL);300INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(292,'foreach_clause',FALSE,NULL);301INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(293,'when_clause',FALSE,NULL);302INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(294,'trigger_cmd',FALSE,NULL);303INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(295,'tridxby',FALSE,NULL);304INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(296,'database_kw_opt',FALSE,NULL);305INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(297,'key_opt',FALSE,NULL);306INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(298,'alter_add',FALSE,NULL);307INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(299,'kwcolumn_opt',FALSE,NULL);308INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(300,'create_vtab',FALSE,NULL);309INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(301,'vtabarglist',FALSE,NULL);310INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(302,'vtabarg',FALSE,NULL);311INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(303,'vtabargtoken',FALSE,NULL);312INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(304,'lp',FALSE,NULL);313INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(305,'anylist',FALSE,NULL);314INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(306,'wqitem',FALSE,NULL);315INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(307,'wqas',FALSE,NULL);316INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(308,'withnm',FALSE,NULL);317INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(309,'windowdefn_list',FALSE,NULL);318INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(310,'windowdefn',FALSE,NULL);319INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(311,'window',FALSE,NULL);320INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(312,'frame_opt',FALSE,NULL);321INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(313,'part_opt',FALSE,NULL);322INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(314,'filter_clause',FALSE,NULL);323INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(315,'over_clause',FALSE,NULL);324INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(316,'range_or_rows',FALSE,NULL);325INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(317,'frame_bound',FALSE,NULL);326INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(318,'frame_bound_s',FALSE,NULL);327INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(319,'frame_bound_e',FALSE,NULL);328INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(320,'frame_exclude_opt',FALSE,NULL);329INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(321,'frame_exclude',FALSE,NULL);330CREATE TABLE rule(331  ruleid INTEGER PRIMARY KEY,332  lhs INTEGER REFERENCES symbol(id),333  txt TEXT334);335CREATE TABLE rulerhs(336  ruleid INTEGER REFERENCES rule(ruleid),337  pos INTEGER,338  sym INTEGER REFERENCES symbol(id)339);340INSERT INTO rule(ruleid,lhs,txt)VALUES(0,191,'explain ::= EXPLAIN');341INSERT INTO rulerhs(ruleid,pos,sym)VALUES(0,0,2);342INSERT INTO rule(ruleid,lhs,txt)VALUES(1,191,'explain ::= EXPLAIN QUERY PLAN');343INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,0,2);344INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,1,3);345INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,2,4);346INSERT INTO rule(ruleid,lhs,txt)VALUES(2,190,'cmdx ::= cmd');347INSERT INTO rulerhs(ruleid,pos,sym)VALUES(2,0,192);348INSERT INTO rule(ruleid,lhs,txt)VALUES(3,192,'cmd ::= BEGIN transtype trans_opt');349INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,0,5);350INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,1,193);351INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,2,194);352INSERT INTO rule(ruleid,lhs,txt)VALUES(4,193,'transtype ::=');353INSERT INTO rule(ruleid,lhs,txt)VALUES(5,193,'transtype ::= DEFERRED');354INSERT INTO rulerhs(ruleid,pos,sym)VALUES(5,0,7);355INSERT INTO rule(ruleid,lhs,txt)VALUES(6,193,'transtype ::= IMMEDIATE');356INSERT INTO rulerhs(ruleid,pos,sym)VALUES(6,0,8);357INSERT INTO rule(ruleid,lhs,txt)VALUES(7,193,'transtype ::= EXCLUSIVE');358INSERT INTO rulerhs(ruleid,pos,sym)VALUES(7,0,9);359INSERT INTO rule(ruleid,lhs,txt)VALUES(8,192,'cmd ::= COMMIT|END trans_opt');360INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,0,10);361INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,0,11);362INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,1,194);363INSERT INTO rule(ruleid,lhs,txt)VALUES(9,192,'cmd ::= ROLLBACK trans_opt');364INSERT INTO rulerhs(ruleid,pos,sym)VALUES(9,0,12);365INSERT INTO rulerhs(ruleid,pos,sym)VALUES(9,1,194);366INSERT INTO rule(ruleid,lhs,txt)VALUES(10,192,'cmd ::= SAVEPOINT nm');367INSERT INTO rulerhs(ruleid,pos,sym)VALUES(10,0,13);368INSERT INTO rulerhs(ruleid,pos,sym)VALUES(10,1,195);369INSERT INTO rule(ruleid,lhs,txt)VALUES(11,192,'cmd ::= RELEASE savepoint_opt nm');370INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,0,14);371INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,1,196);372INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,2,195);373INSERT INTO rule(ruleid,lhs,txt)VALUES(12,192,'cmd ::= ROLLBACK trans_opt TO savepoint_opt nm');374INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,0,12);375INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,1,194);376INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,2,15);377INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,3,196);378INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,4,195);379INSERT INTO rule(ruleid,lhs,txt)VALUES(13,197,'create_table ::= createkw temp TABLE ifnotexists nm dbnm');380INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,0,199);381INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,1,200);382INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,2,16);383INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,3,201);384INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,4,195);385INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,5,202);386INSERT INTO rule(ruleid,lhs,txt)VALUES(14,199,'createkw ::= CREATE');387INSERT INTO rulerhs(ruleid,pos,sym)VALUES(14,0,17);388INSERT INTO rule(ruleid,lhs,txt)VALUES(15,201,'ifnotexists ::=');389INSERT INTO rule(ruleid,lhs,txt)VALUES(16,201,'ifnotexists ::= IF NOT EXISTS');390INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,0,18);391INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,1,19);392INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,2,20);393INSERT INTO rule(ruleid,lhs,txt)VALUES(17,200,'temp ::= TEMP');394INSERT INTO rulerhs(ruleid,pos,sym)VALUES(17,0,21);395INSERT INTO rule(ruleid,lhs,txt)VALUES(18,200,'temp ::=');396INSERT INTO rule(ruleid,lhs,txt)VALUES(19,198,'create_table_args ::= LP columnlist conslist_opt RP table_option_set');397INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,0,22);398INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,1,203);399INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,2,204);400INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,3,23);401INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,4,205);402INSERT INTO rule(ruleid,lhs,txt)VALUES(20,198,'create_table_args ::= AS select');403INSERT INTO rulerhs(ruleid,pos,sym)VALUES(20,0,24);404INSERT INTO rulerhs(ruleid,pos,sym)VALUES(20,1,206);405INSERT INTO rule(ruleid,lhs,txt)VALUES(21,205,'table_option_set ::=');406INSERT INTO rule(ruleid,lhs,txt)VALUES(22,205,'table_option_set ::= table_option_set COMMA table_option');407INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,0,205);408INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,1,25);409INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,2,207);410INSERT INTO rule(ruleid,lhs,txt)VALUES(23,207,'table_option ::= WITHOUT nm');411INSERT INTO rulerhs(ruleid,pos,sym)VALUES(23,0,26);412INSERT INTO rulerhs(ruleid,pos,sym)VALUES(23,1,195);413INSERT INTO rule(ruleid,lhs,txt)VALUES(24,207,'table_option ::= nm');414INSERT INTO rulerhs(ruleid,pos,sym)VALUES(24,0,195);415INSERT INTO rule(ruleid,lhs,txt)VALUES(25,208,'columnname ::= nm typetoken');416INSERT INTO rulerhs(ruleid,pos,sym)VALUES(25,0,195);417INSERT INTO rulerhs(ruleid,pos,sym)VALUES(25,1,210);418INSERT INTO rule(ruleid,lhs,txt)VALUES(26,210,'typetoken ::=');419INSERT INTO rule(ruleid,lhs,txt)VALUES(27,210,'typetoken ::= typename LP signed RP');420INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,0,211);421INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,1,22);422INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,2,212);423INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,3,23);424INSERT INTO rule(ruleid,lhs,txt)VALUES(28,210,'typetoken ::= typename LP signed COMMA signed RP');425INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,0,211);426INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,1,22);427INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,2,212);428INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,3,25);429INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,4,212);430INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,5,23);431INSERT INTO rule(ruleid,lhs,txt)VALUES(29,211,'typename ::= typename ID|STRING');432INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,0,211);433INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,1,60);434INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,1,118);435INSERT INTO rule(ruleid,lhs,txt)VALUES(30,215,'scanpt ::=');436INSERT INTO rule(ruleid,lhs,txt)VALUES(31,216,'scantok ::=');437INSERT INTO rule(ruleid,lhs,txt)VALUES(32,217,'ccons ::= CONSTRAINT nm');438INSERT INTO rulerhs(ruleid,pos,sym)VALUES(32,0,120);439INSERT INTO rulerhs(ruleid,pos,sym)VALUES(32,1,195);440INSERT INTO rule(ruleid,lhs,txt)VALUES(33,217,'ccons ::= DEFAULT scantok term');441INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,0,121);442INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,1,216);443INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,2,218);444INSERT INTO rule(ruleid,lhs,txt)VALUES(34,217,'ccons ::= DEFAULT LP expr RP');445INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,0,121);446INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,1,22);447INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,2,219);448INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,3,23);449INSERT INTO rule(ruleid,lhs,txt)VALUES(35,217,'ccons ::= DEFAULT PLUS scantok term');450INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,0,121);451INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,1,107);452INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,2,216);453INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,3,218);454INSERT INTO rule(ruleid,lhs,txt)VALUES(36,217,'ccons ::= DEFAULT MINUS scantok term');455INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,0,121);456INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,1,108);457INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,2,216);458INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,3,218);459INSERT INTO rule(ruleid,lhs,txt)VALUES(37,217,'ccons ::= DEFAULT scantok ID|INDEXED');460INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,0,121);461INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,1,216);462INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,2,60);463INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,2,117);464INSERT INTO rule(ruleid,lhs,txt)VALUES(38,217,'ccons ::= NOT NULL onconf');465INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,0,19);466INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,1,122);467INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,2,220);468INSERT INTO rule(ruleid,lhs,txt)VALUES(39,217,'ccons ::= PRIMARY KEY sortorder onconf autoinc');469INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,0,123);470INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,1,68);471INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,2,221);472INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,3,220);473INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,4,222);474INSERT INTO rule(ruleid,lhs,txt)VALUES(40,217,'ccons ::= UNIQUE onconf');475INSERT INTO rulerhs(ruleid,pos,sym)VALUES(40,0,124);476INSERT INTO rulerhs(ruleid,pos,sym)VALUES(40,1,220);477INSERT INTO rule(ruleid,lhs,txt)VALUES(41,217,'ccons ::= CHECK LP expr RP');478INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,0,125);479INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,1,22);480INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,2,219);481INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,3,23);482INSERT INTO rule(ruleid,lhs,txt)VALUES(42,217,'ccons ::= REFERENCES nm eidlist_opt refargs');483INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,0,126);484INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,1,195);485INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,2,223);486INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,3,224);487INSERT INTO rule(ruleid,lhs,txt)VALUES(43,217,'ccons ::= defer_subclause');488INSERT INTO rulerhs(ruleid,pos,sym)VALUES(43,0,225);489INSERT INTO rule(ruleid,lhs,txt)VALUES(44,217,'ccons ::= COLLATE ID|STRING');490INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,0,114);491INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,1,60);492INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,1,118);493INSERT INTO rule(ruleid,lhs,txt)VALUES(45,226,'generated ::= LP expr RP');494INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,0,22);495INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,1,219);496INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,2,23);497INSERT INTO rule(ruleid,lhs,txt)VALUES(46,226,'generated ::= LP expr RP ID');498INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,0,22);499INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,1,219);500INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,2,23);501INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,3,60);502INSERT INTO rule(ruleid,lhs,txt)VALUES(47,222,'autoinc ::=');503INSERT INTO rule(ruleid,lhs,txt)VALUES(48,222,'autoinc ::= AUTOINCR');504INSERT INTO rulerhs(ruleid,pos,sym)VALUES(48,0,127);505INSERT INTO rule(ruleid,lhs,txt)VALUES(49,224,'refargs ::=');506INSERT INTO rule(ruleid,lhs,txt)VALUES(50,224,'refargs ::= refargs refarg');507INSERT INTO rulerhs(ruleid,pos,sym)VALUES(50,0,224);508INSERT INTO rulerhs(ruleid,pos,sym)VALUES(50,1,227);509INSERT INTO rule(ruleid,lhs,txt)VALUES(51,227,'refarg ::= MATCH nm');510INSERT INTO rulerhs(ruleid,pos,sym)VALUES(51,0,47);511INSERT INTO rulerhs(ruleid,pos,sym)VALUES(51,1,195);512INSERT INTO rule(ruleid,lhs,txt)VALUES(52,227,'refarg ::= ON INSERT refact');513INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,0,116);514INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,1,128);515INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,2,228);516INSERT INTO rule(ruleid,lhs,txt)VALUES(53,227,'refarg ::= ON DELETE refact');517INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,0,116);518INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,1,129);519INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,2,228);520INSERT INTO rule(ruleid,lhs,txt)VALUES(54,227,'refarg ::= ON UPDATE refact');521INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,0,116);522INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,1,130);523INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,2,228);524INSERT INTO rule(ruleid,lhs,txt)VALUES(55,228,'refact ::= SET NULL');525INSERT INTO rulerhs(ruleid,pos,sym)VALUES(55,0,131);526INSERT INTO rulerhs(ruleid,pos,sym)VALUES(55,1,122);527INSERT INTO rule(ruleid,lhs,txt)VALUES(56,228,'refact ::= SET DEFAULT');528INSERT INTO rulerhs(ruleid,pos,sym)VALUES(56,0,131);529INSERT INTO rulerhs(ruleid,pos,sym)VALUES(56,1,121);530INSERT INTO rule(ruleid,lhs,txt)VALUES(57,228,'refact ::= CASCADE');531INSERT INTO rulerhs(ruleid,pos,sym)VALUES(57,0,35);532INSERT INTO rule(ruleid,lhs,txt)VALUES(58,228,'refact ::= RESTRICT');533INSERT INTO rulerhs(ruleid,pos,sym)VALUES(58,0,75);534INSERT INTO rule(ruleid,lhs,txt)VALUES(59,228,'refact ::= NO ACTION');535INSERT INTO rulerhs(ruleid,pos,sym)VALUES(59,0,67);536INSERT INTO rulerhs(ruleid,pos,sym)VALUES(59,1,28);537INSERT INTO rule(ruleid,lhs,txt)VALUES(60,225,'defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt');538INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,0,19);539INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,1,132);540INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,2,229);541INSERT INTO rule(ruleid,lhs,txt)VALUES(61,225,'defer_subclause ::= DEFERRABLE init_deferred_pred_opt');542INSERT INTO rulerhs(ruleid,pos,sym)VALUES(61,0,132);543INSERT INTO rulerhs(ruleid,pos,sym)VALUES(61,1,229);544INSERT INTO rule(ruleid,lhs,txt)VALUES(62,229,'init_deferred_pred_opt ::=');545INSERT INTO rule(ruleid,lhs,txt)VALUES(63,229,'init_deferred_pred_opt ::= INITIALLY DEFERRED');546INSERT INTO rulerhs(ruleid,pos,sym)VALUES(63,0,65);547INSERT INTO rulerhs(ruleid,pos,sym)VALUES(63,1,7);548INSERT INTO rule(ruleid,lhs,txt)VALUES(64,229,'init_deferred_pred_opt ::= INITIALLY IMMEDIATE');549INSERT INTO rulerhs(ruleid,pos,sym)VALUES(64,0,65);550INSERT INTO rulerhs(ruleid,pos,sym)VALUES(64,1,8);551INSERT INTO rule(ruleid,lhs,txt)VALUES(65,204,'conslist_opt ::=');552INSERT INTO rule(ruleid,lhs,txt)VALUES(66,231,'tconscomma ::= COMMA');553INSERT INTO rulerhs(ruleid,pos,sym)VALUES(66,0,25);554INSERT INTO rule(ruleid,lhs,txt)VALUES(67,232,'tcons ::= CONSTRAINT nm');555INSERT INTO rulerhs(ruleid,pos,sym)VALUES(67,0,120);556INSERT INTO rulerhs(ruleid,pos,sym)VALUES(67,1,195);557INSERT INTO rule(ruleid,lhs,txt)VALUES(68,232,'tcons ::= PRIMARY KEY LP sortlist autoinc RP onconf');558INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,0,123);559INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,1,68);560INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,2,22);561INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,3,233);562INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,4,222);563INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,5,23);564INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,6,220);565INSERT INTO rule(ruleid,lhs,txt)VALUES(69,232,'tcons ::= UNIQUE LP sortlist RP onconf');566INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,0,124);567INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,1,22);568INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,2,233);569INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,3,23);570INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,4,220);571INSERT INTO rule(ruleid,lhs,txt)VALUES(70,232,'tcons ::= CHECK LP expr RP onconf');572INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,0,125);573INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,1,22);574INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,2,219);575INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,3,23);576INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,4,220);577INSERT INTO rule(ruleid,lhs,txt)VALUES(71,232,'tcons ::= FOREIGN KEY LP eidlist RP REFERENCES nm eidlist_opt refargs defer_subclause_opt');578INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,0,133);579INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,1,68);580INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,2,22);581INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,3,234);582INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,4,23);583INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,5,126);584INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,6,195);585INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,7,223);586INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,8,224);587INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,9,235);588INSERT INTO rule(ruleid,lhs,txt)VALUES(72,235,'defer_subclause_opt ::=');589INSERT INTO rule(ruleid,lhs,txt)VALUES(73,220,'onconf ::=');590INSERT INTO rule(ruleid,lhs,txt)VALUES(74,220,'onconf ::= ON CONFLICT resolvetype');591INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,0,116);592INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,1,37);593INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,2,237);594INSERT INTO rule(ruleid,lhs,txt)VALUES(75,236,'orconf ::=');595INSERT INTO rule(ruleid,lhs,txt)VALUES(76,236,'orconf ::= OR resolvetype');596INSERT INTO rulerhs(ruleid,pos,sym)VALUES(76,0,43);597INSERT INTO rulerhs(ruleid,pos,sym)VALUES(76,1,237);598INSERT INTO rule(ruleid,lhs,txt)VALUES(77,237,'resolvetype ::= IGNORE');599INSERT INTO rulerhs(ruleid,pos,sym)VALUES(77,0,64);600INSERT INTO rule(ruleid,lhs,txt)VALUES(78,237,'resolvetype ::= REPLACE');601INSERT INTO rulerhs(ruleid,pos,sym)VALUES(78,0,74);602INSERT INTO rule(ruleid,lhs,txt)VALUES(79,192,'cmd ::= DROP TABLE ifexists fullname');603INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,0,134);604INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,1,16);605INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,2,239);606INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,3,240);607INSERT INTO rule(ruleid,lhs,txt)VALUES(80,239,'ifexists ::= IF EXISTS');608INSERT INTO rulerhs(ruleid,pos,sym)VALUES(80,0,18);609INSERT INTO rulerhs(ruleid,pos,sym)VALUES(80,1,20);610INSERT INTO rule(ruleid,lhs,txt)VALUES(81,239,'ifexists ::=');611INSERT INTO rule(ruleid,lhs,txt)VALUES(82,192,'cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select');612INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,0,199);613INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,1,200);614INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,2,80);615INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,3,201);616INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,4,195);617INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,5,202);618INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,6,223);619INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,7,24);620INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,8,206);621INSERT INTO rule(ruleid,lhs,txt)VALUES(83,192,'cmd ::= DROP VIEW ifexists fullname');622INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,0,134);623INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,1,80);624INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,2,239);625INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,3,240);626INSERT INTO rule(ruleid,lhs,txt)VALUES(84,192,'cmd ::= select');627INSERT INTO rulerhs(ruleid,pos,sym)VALUES(84,0,206);628INSERT INTO rule(ruleid,lhs,txt)VALUES(85,206,'select ::= WITH wqlist selectnowith');629INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,0,82);630INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,1,243);631INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,2,241);632INSERT INTO rule(ruleid,lhs,txt)VALUES(86,206,'select ::= WITH RECURSIVE wqlist selectnowith');633INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,0,82);634INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,1,73);635INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,2,243);636INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,3,241);637INSERT INTO rule(ruleid,lhs,txt)VALUES(87,206,'select ::= selectnowith');638INSERT INTO rulerhs(ruleid,pos,sym)VALUES(87,0,241);639INSERT INTO rule(ruleid,lhs,txt)VALUES(88,241,'selectnowith ::= selectnowith multiselect_op oneselect');640INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,0,241);641INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,1,244);642INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,2,242);643INSERT INTO rule(ruleid,lhs,txt)VALUES(89,244,'multiselect_op ::= UNION');644INSERT INTO rulerhs(ruleid,pos,sym)VALUES(89,0,135);645INSERT INTO rule(ruleid,lhs,txt)VALUES(90,244,'multiselect_op ::= UNION ALL');646INSERT INTO rulerhs(ruleid,pos,sym)VALUES(90,0,135);647INSERT INTO rulerhs(ruleid,pos,sym)VALUES(90,1,136);648INSERT INTO rule(ruleid,lhs,txt)VALUES(91,244,'multiselect_op ::= EXCEPT|INTERSECT');649INSERT INTO rulerhs(ruleid,pos,sym)VALUES(91,0,137);650INSERT INTO rulerhs(ruleid,pos,sym)VALUES(91,0,138);651INSERT INTO rule(ruleid,lhs,txt)VALUES(92,242,'oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt');652INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,0,139);653INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,1,245);654INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,2,246);655INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,3,247);656INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,4,248);657INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,5,249);658INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,6,250);659INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,7,251);660INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,8,252);661INSERT 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');662INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,0,139);663INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,1,245);664INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,2,246);665INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,3,247);666INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,4,248);667INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,5,249);668INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,6,250);669INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,7,253);670INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,8,251);671INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,9,252);672INSERT INTO rule(ruleid,lhs,txt)VALUES(94,254,'values ::= VALUES LP nexprlist RP');673INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,0,140);674INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,1,22);675INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,2,255);676INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,3,23);677INSERT INTO rule(ruleid,lhs,txt)VALUES(95,242,'oneselect ::= mvalues');678INSERT INTO rulerhs(ruleid,pos,sym)VALUES(95,0,256);679INSERT INTO rule(ruleid,lhs,txt)VALUES(96,256,'mvalues ::= values COMMA LP nexprlist RP');680INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,0,254);681INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,1,25);682INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,2,22);683INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,3,255);684INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,4,23);685INSERT INTO rule(ruleid,lhs,txt)VALUES(97,256,'mvalues ::= mvalues COMMA LP nexprlist RP');686INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,0,256);687INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,1,25);688INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,2,22);689INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,3,255);690INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,4,23);691INSERT INTO rule(ruleid,lhs,txt)VALUES(98,245,'distinct ::= DISTINCT');692INSERT INTO rulerhs(ruleid,pos,sym)VALUES(98,0,141);693INSERT INTO rule(ruleid,lhs,txt)VALUES(99,245,'distinct ::= ALL');694INSERT INTO rulerhs(ruleid,pos,sym)VALUES(99,0,136);695INSERT INTO rule(ruleid,lhs,txt)VALUES(100,245,'distinct ::=');696INSERT INTO rule(ruleid,lhs,txt)VALUES(101,257,'sclp ::=');697INSERT INTO rule(ruleid,lhs,txt)VALUES(102,246,'selcollist ::= sclp scanpt expr scanpt as');698INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,0,257);699INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,1,215);700INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,2,219);701INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,3,215);702INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,4,258);703INSERT INTO rule(ruleid,lhs,txt)VALUES(103,246,'selcollist ::= sclp scanpt STAR');704INSERT INTO rulerhs(ruleid,pos,sym)VALUES(103,0,257);705INSERT INTO rulerhs(ruleid,pos,sym)VALUES(103,1,215);706INSERT INTO rulerhs(ruleid,pos,sym)VALUES(103,2,109);707INSERT INTO rule(ruleid,lhs,txt)VALUES(104,246,'selcollist ::= sclp scanpt nm DOT STAR');708INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,0,257);709INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,1,215);710INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,2,195);711INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,3,142);712INSERT INTO rulerhs(ruleid,pos,sym)VALUES(104,4,109);713INSERT INTO rule(ruleid,lhs,txt)VALUES(105,258,'as ::= AS nm');714INSERT INTO rulerhs(ruleid,pos,sym)VALUES(105,0,24);715INSERT INTO rulerhs(ruleid,pos,sym)VALUES(105,1,195);716INSERT INTO rule(ruleid,lhs,txt)VALUES(106,258,'as ::=');717INSERT INTO rule(ruleid,lhs,txt)VALUES(107,247,'from ::=');718INSERT INTO rule(ruleid,lhs,txt)VALUES(108,247,'from ::= FROM seltablist');719INSERT INTO rulerhs(ruleid,pos,sym)VALUES(108,0,143);720INSERT INTO rulerhs(ruleid,pos,sym)VALUES(108,1,259);721INSERT INTO rule(ruleid,lhs,txt)VALUES(109,260,'stl_prefix ::= seltablist joinop');722INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,0,259);723INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,1,261);724INSERT INTO rule(ruleid,lhs,txt)VALUES(110,260,'stl_prefix ::=');725INSERT INTO rule(ruleid,lhs,txt)VALUES(111,259,'seltablist ::= stl_prefix nm dbnm as on_using');726INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,0,260);727INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,1,195);728INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,2,202);729INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,3,258);730INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,4,262);731INSERT INTO rule(ruleid,lhs,txt)VALUES(112,259,'seltablist ::= stl_prefix nm dbnm as indexed_by on_using');732INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,0,260);733INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,1,195);734INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,2,202);735INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,3,258);736INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,4,263);737INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,5,262);738INSERT INTO rule(ruleid,lhs,txt)VALUES(113,259,'seltablist ::= stl_prefix nm dbnm LP exprlist RP as on_using');739INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,0,260);740INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,1,195);741INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,2,202);742INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,3,22);743INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,4,264);744INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,5,23);745INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,6,258);746INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,7,262);747INSERT INTO rule(ruleid,lhs,txt)VALUES(114,259,'seltablist ::= stl_prefix LP select RP as on_using');748INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,0,260);749INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,1,22);750INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,2,206);751INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,3,23);752INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,4,258);753INSERT INTO rulerhs(ruleid,pos,sym)VALUES(114,5,262);754INSERT INTO rule(ruleid,lhs,txt)VALUES(115,259,'seltablist ::= stl_prefix LP seltablist RP as on_using');755INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,0,260);756INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,1,22);757INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,2,259);758INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,3,23);759INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,4,258);760INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,5,262);761INSERT INTO rule(ruleid,lhs,txt)VALUES(116,202,'dbnm ::=');762INSERT INTO rule(ruleid,lhs,txt)VALUES(117,202,'dbnm ::= DOT nm');763INSERT INTO rulerhs(ruleid,pos,sym)VALUES(117,0,142);764INSERT INTO rulerhs(ruleid,pos,sym)VALUES(117,1,195);765INSERT INTO rule(ruleid,lhs,txt)VALUES(118,240,'fullname ::= nm');766INSERT INTO rulerhs(ruleid,pos,sym)VALUES(118,0,195);767INSERT INTO rule(ruleid,lhs,txt)VALUES(119,240,'fullname ::= nm DOT nm');768INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,0,195);769INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,1,142);770INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,2,195);771INSERT INTO rule(ruleid,lhs,txt)VALUES(120,265,'xfullname ::= nm');772INSERT INTO rulerhs(ruleid,pos,sym)VALUES(120,0,195);773INSERT INTO rule(ruleid,lhs,txt)VALUES(121,265,'xfullname ::= nm DOT nm');774INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,0,195);775INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,1,142);776INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,2,195);777INSERT INTO rule(ruleid,lhs,txt)VALUES(122,265,'xfullname ::= nm AS nm');778INSERT INTO rulerhs(ruleid,pos,sym)VALUES(122,0,195);779INSERT INTO rulerhs(ruleid,pos,sym)VALUES(122,1,24);780INSERT INTO rulerhs(ruleid,pos,sym)VALUES(122,2,195);781INSERT INTO rule(ruleid,lhs,txt)VALUES(123,265,'xfullname ::= nm DOT nm AS nm');782INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,0,195);783INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,1,142);784INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,2,195);785INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,3,24);786INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,4,195);787INSERT INTO rule(ruleid,lhs,txt)VALUES(124,261,'joinop ::= COMMA|JOIN');788INSERT INTO rulerhs(ruleid,pos,sym)VALUES(124,0,25);789INSERT INTO rulerhs(ruleid,pos,sym)VALUES(124,0,144);790INSERT INTO rule(ruleid,lhs,txt)VALUES(125,261,'joinop ::= JOIN_KW JOIN');791INSERT INTO rulerhs(ruleid,pos,sym)VALUES(125,0,119);792INSERT INTO rulerhs(ruleid,pos,sym)VALUES(125,1,144);793INSERT INTO rule(ruleid,lhs,txt)VALUES(126,261,'joinop ::= JOIN_KW nm JOIN');794INSERT INTO rulerhs(ruleid,pos,sym)VALUES(126,0,119);795INSERT INTO rulerhs(ruleid,pos,sym)VALUES(126,1,195);796INSERT INTO rulerhs(ruleid,pos,sym)VALUES(126,2,144);797INSERT INTO rule(ruleid,lhs,txt)VALUES(127,261,'joinop ::= JOIN_KW nm nm JOIN');798INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,0,119);799INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,1,195);800INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,2,195);801INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,3,144);802INSERT INTO rule(ruleid,lhs,txt)VALUES(128,262,'on_using ::= ON expr');803INSERT INTO rulerhs(ruleid,pos,sym)VALUES(128,0,116);804INSERT INTO rulerhs(ruleid,pos,sym)VALUES(128,1,219);805INSERT INTO rule(ruleid,lhs,txt)VALUES(129,262,'on_using ::= USING LP idlist RP');806INSERT INTO rulerhs(ruleid,pos,sym)VALUES(129,0,145);807INSERT INTO rulerhs(ruleid,pos,sym)VALUES(129,1,22);808INSERT INTO rulerhs(ruleid,pos,sym)VALUES(129,2,266);809INSERT INTO rulerhs(ruleid,pos,sym)VALUES(129,3,23);810INSERT INTO rule(ruleid,lhs,txt)VALUES(130,262,'on_using ::=');811INSERT INTO rule(ruleid,lhs,txt)VALUES(131,267,'indexed_opt ::=');812INSERT INTO rule(ruleid,lhs,txt)VALUES(132,263,'indexed_by ::= INDEXED BY nm');813INSERT INTO rulerhs(ruleid,pos,sym)VALUES(132,0,117);814INSERT INTO rulerhs(ruleid,pos,sym)VALUES(132,1,34);815INSERT INTO rulerhs(ruleid,pos,sym)VALUES(132,2,195);816INSERT INTO rule(ruleid,lhs,txt)VALUES(133,263,'indexed_by ::= NOT INDEXED');817INSERT INTO rulerhs(ruleid,pos,sym)VALUES(133,0,19);818INSERT INTO rulerhs(ruleid,pos,sym)VALUES(133,1,117);819INSERT INTO rule(ruleid,lhs,txt)VALUES(134,251,'orderby_opt ::=');820INSERT INTO rule(ruleid,lhs,txt)VALUES(135,251,'orderby_opt ::= ORDER BY sortlist');821INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,0,146);822INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,1,34);823INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,2,233);824INSERT INTO rule(ruleid,lhs,txt)VALUES(136,233,'sortlist ::= sortlist COMMA expr sortorder nulls');825INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,0,233);826INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,1,25);827INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,2,219);828INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,3,221);829INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,4,268);830INSERT INTO rule(ruleid,lhs,txt)VALUES(137,233,'sortlist ::= expr sortorder nulls');831INSERT INTO rulerhs(ruleid,pos,sym)VALUES(137,0,219);832INSERT INTO rulerhs(ruleid,pos,sym)VALUES(137,1,221);833INSERT INTO rulerhs(ruleid,pos,sym)VALUES(137,2,268);834INSERT INTO rule(ruleid,lhs,txt)VALUES(138,221,'sortorder ::= ASC');835INSERT INTO rulerhs(ruleid,pos,sym)VALUES(138,0,31);836INSERT INTO rule(ruleid,lhs,txt)VALUES(139,221,'sortorder ::= DESC');837INSERT INTO rulerhs(ruleid,pos,sym)VALUES(139,0,39);838INSERT INTO rule(ruleid,lhs,txt)VALUES(140,221,'sortorder ::=');839INSERT INTO rule(ruleid,lhs,txt)VALUES(141,268,'nulls ::= NULLS FIRST');840INSERT INTO rulerhs(ruleid,pos,sym)VALUES(141,0,83);841INSERT INTO rulerhs(ruleid,pos,sym)VALUES(141,1,84);842INSERT INTO rule(ruleid,lhs,txt)VALUES(142,268,'nulls ::= NULLS LAST');843INSERT INTO rulerhs(ruleid,pos,sym)VALUES(142,0,83);844INSERT INTO rulerhs(ruleid,pos,sym)VALUES(142,1,85);845INSERT INTO rule(ruleid,lhs,txt)VALUES(143,268,'nulls ::=');846INSERT INTO rule(ruleid,lhs,txt)VALUES(144,249,'groupby_opt ::=');847INSERT INTO rule(ruleid,lhs,txt)VALUES(145,249,'groupby_opt ::= GROUP BY nexprlist');848INSERT INTO rulerhs(ruleid,pos,sym)VALUES(145,0,147);849INSERT INTO rulerhs(ruleid,pos,sym)VALUES(145,1,34);850INSERT INTO rulerhs(ruleid,pos,sym)VALUES(145,2,255);851INSERT INTO rule(ruleid,lhs,txt)VALUES(146,250,'having_opt ::=');852INSERT INTO rule(ruleid,lhs,txt)VALUES(147,250,'having_opt ::= HAVING expr');853INSERT INTO rulerhs(ruleid,pos,sym)VALUES(147,0,148);854INSERT INTO rulerhs(ruleid,pos,sym)VALUES(147,1,219);855INSERT INTO rule(ruleid,lhs,txt)VALUES(148,252,'limit_opt ::=');856INSERT INTO rule(ruleid,lhs,txt)VALUES(149,252,'limit_opt ::= LIMIT expr');857INSERT INTO rulerhs(ruleid,pos,sym)VALUES(149,0,149);858INSERT INTO rulerhs(ruleid,pos,sym)VALUES(149,1,219);859INSERT INTO rule(ruleid,lhs,txt)VALUES(150,252,'limit_opt ::= LIMIT expr OFFSET expr');860INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,0,149);861INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,1,219);862INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,2,70);863INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,3,219);864INSERT INTO rule(ruleid,lhs,txt)VALUES(151,252,'limit_opt ::= LIMIT expr COMMA expr');865INSERT INTO rulerhs(ruleid,pos,sym)VALUES(151,0,149);866INSERT INTO rulerhs(ruleid,pos,sym)VALUES(151,1,219);867INSERT INTO rulerhs(ruleid,pos,sym)VALUES(151,2,25);868INSERT INTO rulerhs(ruleid,pos,sym)VALUES(151,3,219);869INSERT INTO rule(ruleid,lhs,txt)VALUES(152,192,'cmd ::= with DELETE FROM xfullname indexed_opt where_opt_ret');870INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,0,269);871INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,1,129);872INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,2,143);873INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,3,265);874INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,4,267);875INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,5,270);876INSERT INTO rule(ruleid,lhs,txt)VALUES(153,248,'where_opt ::=');877INSERT INTO rule(ruleid,lhs,txt)VALUES(154,248,'where_opt ::= WHERE expr');878INSERT INTO rulerhs(ruleid,pos,sym)VALUES(154,0,150);879INSERT INTO rulerhs(ruleid,pos,sym)VALUES(154,1,219);880INSERT INTO rule(ruleid,lhs,txt)VALUES(155,270,'where_opt_ret ::=');881INSERT INTO rule(ruleid,lhs,txt)VALUES(156,270,'where_opt_ret ::= WHERE expr');882INSERT INTO rulerhs(ruleid,pos,sym)VALUES(156,0,150);883INSERT INTO rulerhs(ruleid,pos,sym)VALUES(156,1,219);884INSERT INTO rule(ruleid,lhs,txt)VALUES(157,270,'where_opt_ret ::= RETURNING selcollist');885INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,0,151);886INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,1,246);887INSERT INTO rule(ruleid,lhs,txt)VALUES(158,270,'where_opt_ret ::= WHERE expr RETURNING selcollist');888INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,0,150);889INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,1,219);890INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,2,151);891INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,3,246);892INSERT INTO rule(ruleid,lhs,txt)VALUES(159,192,'cmd ::= with UPDATE orconf xfullname indexed_opt SET setlist from where_opt_ret');893INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,0,269);894INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,1,130);895INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,2,236);896INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,3,265);897INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,4,267);898INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,5,131);899INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,6,271);900INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,7,247);901INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,8,270);902INSERT INTO rule(ruleid,lhs,txt)VALUES(160,271,'setlist ::= setlist COMMA nm EQ expr');903INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,0,271);904INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,1,25);905INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,2,195);906INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,3,54);907INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,4,219);908INSERT INTO rule(ruleid,lhs,txt)VALUES(161,271,'setlist ::= setlist COMMA LP idlist RP EQ expr');909INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,0,271);910INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,1,25);911INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,2,22);912INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,3,266);913INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,4,23);914INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,5,54);915INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,6,219);916INSERT INTO rule(ruleid,lhs,txt)VALUES(162,271,'setlist ::= nm EQ expr');917INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,0,195);918INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,1,54);919INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,2,219);920INSERT INTO rule(ruleid,lhs,txt)VALUES(163,271,'setlist ::= LP idlist RP EQ expr');921INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,0,22);922INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,1,266);923INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,2,23);924INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,3,54);925INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,4,219);926INSERT INTO rule(ruleid,lhs,txt)VALUES(164,192,'cmd ::= with insert_cmd INTO xfullname idlist_opt select upsert');927INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,0,269);928INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,1,272);929INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,2,152);930INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,3,265);931INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,4,273);932INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,5,206);933INSERT INTO rulerhs(ruleid,pos,sym)VALUES(164,6,274);934INSERT INTO rule(ruleid,lhs,txt)VALUES(165,192,'cmd ::= with insert_cmd INTO xfullname idlist_opt DEFAULT VALUES returning');935INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,0,269);936INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,1,272);937INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,2,152);938INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,3,265);939INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,4,273);940INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,5,121);941INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,6,140);942INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,7,275);943INSERT INTO rule(ruleid,lhs,txt)VALUES(166,274,'upsert ::=');944INSERT INTO rule(ruleid,lhs,txt)VALUES(167,274,'upsert ::= RETURNING selcollist');945INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,0,151);946INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,1,246);947INSERT INTO rule(ruleid,lhs,txt)VALUES(168,274,'upsert ::= ON CONFLICT LP sortlist RP where_opt DO UPDATE SET setlist where_opt upsert');948INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,0,116);949INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,1,37);950INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,2,22);951INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,3,233);952INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,4,23);953INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,5,248);954INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,6,62);955INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,7,130);956INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,8,131);957INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,9,271);958INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,10,248);959INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,11,274);960INSERT INTO rule(ruleid,lhs,txt)VALUES(169,274,'upsert ::= ON CONFLICT LP sortlist RP where_opt DO NOTHING upsert');961INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,0,116);962INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,1,37);963INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,2,22);964INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,3,233);965INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,4,23);966INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,5,248);967INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,6,62);968INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,7,153);969INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,8,274);970INSERT INTO rule(ruleid,lhs,txt)VALUES(170,274,'upsert ::= ON CONFLICT DO NOTHING returning');971INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,0,116);972INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,1,37);973INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,2,62);974INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,3,153);975INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,4,275);976INSERT INTO rule(ruleid,lhs,txt)VALUES(171,274,'upsert ::= ON CONFLICT DO UPDATE SET setlist where_opt returning');977INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,0,116);978INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,1,37);979INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,2,62);980INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,3,130);981INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,4,131);982INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,5,271);983INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,6,248);984INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,7,275);985INSERT INTO rule(ruleid,lhs,txt)VALUES(172,275,'returning ::= RETURNING selcollist');986INSERT INTO rulerhs(ruleid,pos,sym)VALUES(172,0,151);987INSERT INTO rulerhs(ruleid,pos,sym)VALUES(172,1,246);988INSERT INTO rule(ruleid,lhs,txt)VALUES(173,272,'insert_cmd ::= INSERT orconf');989INSERT INTO rulerhs(ruleid,pos,sym)VALUES(173,0,128);990INSERT INTO rulerhs(ruleid,pos,sym)VALUES(173,1,236);991INSERT INTO rule(ruleid,lhs,txt)VALUES(174,272,'insert_cmd ::= REPLACE');992INSERT INTO rulerhs(ruleid,pos,sym)VALUES(174,0,74);993INSERT INTO rule(ruleid,lhs,txt)VALUES(175,273,'idlist_opt ::=');994INSERT INTO rule(ruleid,lhs,txt)VALUES(176,273,'idlist_opt ::= LP idlist RP');995INSERT INTO rulerhs(ruleid,pos,sym)VALUES(176,0,22);996INSERT INTO rulerhs(ruleid,pos,sym)VALUES(176,1,266);997INSERT INTO rulerhs(ruleid,pos,sym)VALUES(176,2,23);998INSERT INTO rule(ruleid,lhs,txt)VALUES(177,266,'idlist ::= idlist COMMA nm');999INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,0,266);1000INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,1,25);1001INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,2,195);1002INSERT INTO rule(ruleid,lhs,txt)VALUES(178,266,'idlist ::= nm');1003INSERT INTO rulerhs(ruleid,pos,sym)VALUES(178,0,195);1004INSERT INTO rule(ruleid,lhs,txt)VALUES(179,219,'expr ::= LP expr RP');1005INSERT INTO rulerhs(ruleid,pos,sym)VALUES(179,0,22);1006INSERT INTO rulerhs(ruleid,pos,sym)VALUES(179,1,219);1007INSERT INTO rulerhs(ruleid,pos,sym)VALUES(179,2,23);1008INSERT INTO rule(ruleid,lhs,txt)VALUES(180,219,'expr ::= ID|INDEXED|JOIN_KW');1009INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,0,60);1010INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,0,117);1011INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,0,119);1012INSERT INTO rule(ruleid,lhs,txt)VALUES(181,219,'expr ::= nm DOT nm');1013INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,0,195);1014INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,1,142);1015INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,2,195);1016INSERT INTO rule(ruleid,lhs,txt)VALUES(182,219,'expr ::= nm DOT nm DOT nm');1017INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,0,195);1018INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,1,142);1019INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,2,195);1020INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,3,142);1021INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,4,195);1022INSERT INTO rule(ruleid,lhs,txt)VALUES(183,218,'term ::= NULL|FLOAT|BLOB');1023INSERT INTO rulerhs(ruleid,pos,sym)VALUES(183,0,122);1024INSERT INTO rulerhs(ruleid,pos,sym)VALUES(183,0,154);1025INSERT INTO rulerhs(ruleid,pos,sym)VALUES(183,0,155);1026INSERT INTO rule(ruleid,lhs,txt)VALUES(184,218,'term ::= STRING');1027INSERT INTO rulerhs(ruleid,pos,sym)VALUES(184,0,118);1028INSERT INTO rule(ruleid,lhs,txt)VALUES(185,218,'term ::= INTEGER');1029INSERT INTO rulerhs(ruleid,pos,sym)VALUES(185,0,156);1030INSERT INTO rule(ruleid,lhs,txt)VALUES(186,219,'expr ::= VARIABLE');1031INSERT INTO rulerhs(ruleid,pos,sym)VALUES(186,0,157);1032INSERT INTO rule(ruleid,lhs,txt)VALUES(187,219,'expr ::= expr COLLATE ID|STRING');1033INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,0,219);1034INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,1,114);1035INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,2,60);1036INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,2,118);1037INSERT INTO rule(ruleid,lhs,txt)VALUES(188,219,'expr ::= CAST LP expr AS typetoken RP');1038INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,0,36);1039INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,1,22);1040INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,2,219);1041INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,3,24);1042INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,4,210);1043INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,5,23);1044INSERT INTO rule(ruleid,lhs,txt)VALUES(189,219,'expr ::= ID|INDEXED|JOIN_KW LP distinct exprlist RP');1045INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,0,60);1046INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,0,117);1047INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,0,119);1048INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,1,22);1049INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,2,245);1050INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,3,264);1051INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,4,23);1052INSERT INTO rule(ruleid,lhs,txt)VALUES(190,219,'expr ::= ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP');1053INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,0,60);1054INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,0,117);1055INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,0,119);1056INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,1,22);1057INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,2,245);1058INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,3,264);1059INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,4,146);1060INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,5,34);1061INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,6,233);1062INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,7,23);1063INSERT INTO rule(ruleid,lhs,txt)VALUES(191,219,'expr ::= ID|INDEXED|JOIN_KW LP STAR RP');1064INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,0,60);1065INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,0,117);1066INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,0,119);1067INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,1,22);1068INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,2,109);1069INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,3,23);1070INSERT INTO rule(ruleid,lhs,txt)VALUES(192,219,'expr ::= ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over');1071INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,0,60);1072INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,0,117);1073INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,0,119);1074INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,1,22);1075INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,2,245);1076INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,3,264);1077INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,4,23);1078INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,5,276);1079INSERT INTO rule(ruleid,lhs,txt)VALUES(193,219,'expr ::= ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over');1080INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,0,60);1081INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,0,117);1082INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,0,119);1083INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,1,22);1084INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,2,245);1085INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,3,264);1086INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,4,146);1087INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,5,34);1088INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,6,233);1089INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,7,23);1090INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,8,276);1091INSERT INTO rule(ruleid,lhs,txt)VALUES(194,219,'expr ::= ID|INDEXED|JOIN_KW LP STAR RP filter_over');1092INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,0,60);1093INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,0,117);1094INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,0,119);1095INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,1,22);1096INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,2,109);1097INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,3,23);1098INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,4,276);1099INSERT INTO rule(ruleid,lhs,txt)VALUES(195,218,'term ::= CTIME_KW');1100INSERT INTO rulerhs(ruleid,pos,sym)VALUES(195,0,101);1101INSERT INTO rule(ruleid,lhs,txt)VALUES(196,219,'expr ::= LP nexprlist COMMA expr RP');1102INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,0,22);1103INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,1,255);1104INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,2,25);1105INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,3,219);1106INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,4,23);1107INSERT INTO rule(ruleid,lhs,txt)VALUES(197,219,'expr ::= expr AND expr');1108INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,0,219);1109INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,1,44);1110INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,2,219);1111INSERT INTO rule(ruleid,lhs,txt)VALUES(198,219,'expr ::= expr OR expr');1112INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,0,219);1113INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,1,43);1114INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,2,219);1115INSERT INTO rule(ruleid,lhs,txt)VALUES(199,219,'expr ::= expr LT|GT|GE|LE expr');1116INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,0,219);1117INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,57);1118INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,55);1119INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,58);1120INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,56);1121INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,2,219);1122INSERT INTO rule(ruleid,lhs,txt)VALUES(200,219,'expr ::= expr EQ|NE expr');1123INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,0,219);1124INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,1,54);1125INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,1,53);1126INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,2,219);1127INSERT INTO rule(ruleid,lhs,txt)VALUES(201,219,'expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr');1128INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,0,219);1129INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,103);1130INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,104);1131INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,105);1132INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,106);1133INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,2,219);1134INSERT INTO rule(ruleid,lhs,txt)VALUES(202,219,'expr ::= expr PLUS|MINUS expr');1135INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,0,219);1136INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,1,107);1137INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,1,108);1138INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,2,219);1139INSERT INTO rule(ruleid,lhs,txt)VALUES(203,219,'expr ::= expr STAR|SLASH|REM expr');1140INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,0,219);1141INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,1,109);1142INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,1,110);1143INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,1,111);1144INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,2,219);1145INSERT INTO rule(ruleid,lhs,txt)VALUES(204,219,'expr ::= expr CONCAT expr');1146INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,0,219);1147INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,1,112);1148INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,2,219);1149INSERT INTO rule(ruleid,lhs,txt)VALUES(205,277,'likeop ::= NOT LIKE_KW|MATCH');1150INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,0,19);1151INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,1,48);1152INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,1,47);1153INSERT INTO rule(ruleid,lhs,txt)VALUES(206,219,'expr ::= expr likeop expr');1154INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,0,219);1155INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,1,277);1156INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,2,219);1157INSERT INTO rule(ruleid,lhs,txt)VALUES(207,219,'expr ::= expr likeop expr ESCAPE expr');1158INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,0,219);1159INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,1,277);1160INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,2,219);1161INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,3,59);1162INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,4,219);1163INSERT INTO rule(ruleid,lhs,txt)VALUES(208,219,'expr ::= expr ISNULL|NOTNULL');1164INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,0,219);1165INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,1,51);1166INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,1,52);1167INSERT INTO rule(ruleid,lhs,txt)VALUES(209,219,'expr ::= expr NOT NULL');1168INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,0,219);1169INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,1,19);1170INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,2,122);1171INSERT INTO rule(ruleid,lhs,txt)VALUES(210,219,'expr ::= expr IS expr');1172INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,0,219);1173INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,1,45);1174INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,2,219);1175INSERT INTO rule(ruleid,lhs,txt)VALUES(211,219,'expr ::= expr IS NOT expr');1176INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,0,219);1177INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,1,45);1178INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,2,19);1179INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,3,219);1180INSERT INTO rule(ruleid,lhs,txt)VALUES(212,219,'expr ::= expr IS NOT DISTINCT FROM expr');1181INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,0,219);1182INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,1,45);1183INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,2,19);1184INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,3,141);1185INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,4,143);1186INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,5,219);1187INSERT INTO rule(ruleid,lhs,txt)VALUES(213,219,'expr ::= expr IS DISTINCT FROM expr');1188INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,0,219);1189INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,1,45);1190INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,2,141);1191INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,3,143);1192INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,4,219);1193INSERT INTO rule(ruleid,lhs,txt)VALUES(214,219,'expr ::= NOT expr');1194INSERT INTO rulerhs(ruleid,pos,sym)VALUES(214,0,19);1195INSERT INTO rulerhs(ruleid,pos,sym)VALUES(214,1,219);1196INSERT INTO rule(ruleid,lhs,txt)VALUES(215,219,'expr ::= BITNOT expr');1197INSERT INTO rulerhs(ruleid,pos,sym)VALUES(215,0,115);1198INSERT INTO rulerhs(ruleid,pos,sym)VALUES(215,1,219);1199INSERT INTO rule(ruleid,lhs,txt)VALUES(216,219,'expr ::= PLUS|MINUS expr');1200INSERT INTO rulerhs(ruleid,pos,sym)VALUES(216,0,107);

Showing the first 1,200 of 1908 lines. Download the file for the rest.