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 DEFERRED 7); 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,59); 11INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(3,'QUERY',TRUE,59); 12INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(4,'PLAN',TRUE,59); 13INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(5,'BEGIN',TRUE,59); 14INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(6,'TRANSACTION',TRUE,NULL); 15INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(7,'DEFERRED',TRUE,59); 16INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(8,'IMMEDIATE',TRUE,59); 17INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(9,'EXCLUSIVE',TRUE,59); 18INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(10,'COMMIT',TRUE,NULL); 19INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(11,'END',TRUE,59); 20INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(12,'ROLLBACK',TRUE,59); 21INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(13,'SAVEPOINT',TRUE,59); 22INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(14,'RELEASE',TRUE,59); 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,59); 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,59); 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,59); 35INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(27,'ABORT',TRUE,59); 36INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(28,'ACTION',TRUE,59); 37INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(29,'AFTER',TRUE,59); 38INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(30,'ANALYZE',TRUE,59); 39INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(31,'ASC',TRUE,59); 40INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(32,'ATTACH',TRUE,59); 41INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(33,'BEFORE',TRUE,59); 42INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(34,'BY',TRUE,59); 43INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(35,'CASCADE',TRUE,59); 44INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(36,'CAST',TRUE,59); 45INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(37,'CONFLICT',TRUE,59); 46INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(38,'DATABASE',TRUE,59); 47INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(39,'DESC',TRUE,59); 48INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(40,'DETACH',TRUE,59); 49INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(41,'EACH',TRUE,59); 50INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(42,'FAIL',TRUE,59); 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,'MATCH',TRUE,59); 55INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(47,'LIKE_KW',TRUE,59); 56INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(48,'BETWEEN',TRUE,NULL); 57INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(49,'IN',TRUE,NULL); 58INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(50,'ISNULL',TRUE,NULL); 59INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(51,'NOTNULL',TRUE,NULL); 60INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(52,'NE',TRUE,NULL); 61INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(53,'EQ',TRUE,NULL); 62INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(54,'GT',TRUE,NULL); 63INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(55,'LE',TRUE,NULL); 64INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(56,'LT',TRUE,NULL); 65INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(57,'GE',TRUE,NULL); 66INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(58,'ESCAPE',TRUE,NULL); 67INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(59,'ID',TRUE,NULL); 68INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(60,'COLUMNKW',TRUE,59); 69INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(61,'DO',TRUE,59); 70INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(62,'FOR',TRUE,59); 71INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(63,'IGNORE',TRUE,59); 72INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(64,'INITIALLY',TRUE,59); 73INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(65,'INSTEAD',TRUE,59); 74INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(66,'NO',TRUE,59); 75INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(67,'KEY',TRUE,59); 76INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(68,'OF',TRUE,59); 77INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(69,'OFFSET',TRUE,59); 78INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(70,'PRAGMA',TRUE,59); 79INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(71,'RAISE',TRUE,59); 80INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(72,'RECURSIVE',TRUE,59); 81INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(73,'REPLACE',TRUE,59); 82INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(74,'RESTRICT',TRUE,59); 83INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(75,'ROW',TRUE,59); 84INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(76,'ROWS',TRUE,59); 85INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(77,'TRIGGER',TRUE,59); 86INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(78,'VACUUM',TRUE,59); 87INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(79,'VIEW',TRUE,59); 88INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(80,'VIRTUAL',TRUE,59); 89INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(81,'WITH',TRUE,59); 90INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(82,'NULLS',TRUE,59); 91INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(83,'FIRST',TRUE,59); 92INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(84,'LAST',TRUE,59); 93INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(85,'CURRENT',TRUE,59); 94INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(86,'FOLLOWING',TRUE,59); 95INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(87,'PARTITION',TRUE,59); 96INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(88,'PRECEDING',TRUE,59); 97INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(89,'RANGE',TRUE,59); 98INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(90,'UNBOUNDED',TRUE,59); 99INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(91,'EXCLUDE',TRUE,59); 100INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(92,'GROUPS',TRUE,59); 101INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(93,'OTHERS',TRUE,59); 102INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(94,'TIES',TRUE,59); 103INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(95,'GENERATED',TRUE,59); 104INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(96,'ALWAYS',TRUE,59); 105INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(97,'MATERIALIZED',TRUE,59); 106INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(98,'REINDEX',TRUE,59); 107INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(99,'RENAME',TRUE,59); 108INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(100,'CTIME_KW',TRUE,59); 109INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(101,'ANY',TRUE,NULL); 110INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(102,'BITAND',TRUE,NULL); 111INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(103,'BITOR',TRUE,NULL); 112INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(104,'LSHIFT',TRUE,NULL); 113INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(105,'RSHIFT',TRUE,NULL); 114INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(106,'PLUS',TRUE,NULL); 115INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(107,'MINUS',TRUE,NULL); 116INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(108,'STAR',TRUE,NULL); 117INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(109,'SLASH',TRUE,NULL); 118INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(110,'REM',TRUE,NULL); 119INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(111,'CONCAT',TRUE,NULL); 120INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(112,'PTR',TRUE,NULL); 121INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(113,'COLLATE',TRUE,NULL); 122INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(114,'BITNOT',TRUE,NULL); 123INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(115,'ON',TRUE,NULL); 124INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(116,'INDEXED',TRUE,NULL); 125INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(117,'STRING',TRUE,NULL); 126INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(118,'JOIN_KW',TRUE,NULL); 127INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(119,'CONSTRAINT',TRUE,NULL); 128INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(120,'DEFAULT',TRUE,NULL); 129INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(121,'NULL',TRUE,NULL); 130INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(122,'PRIMARY',TRUE,NULL); 131INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(123,'UNIQUE',TRUE,NULL); 132INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(124,'CHECK',TRUE,NULL); 133INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(125,'REFERENCES',TRUE,NULL); 134INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(126,'AUTOINCR',TRUE,NULL); 135INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(127,'INSERT',TRUE,NULL); 136INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(128,'DELETE',TRUE,NULL); 137INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(129,'UPDATE',TRUE,NULL); 138INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(130,'SET',TRUE,NULL); 139INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(131,'DEFERRABLE',TRUE,NULL); 140INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(132,'FOREIGN',TRUE,NULL); 141INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(133,'DROP',TRUE,NULL); 142INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(134,'UNION',TRUE,NULL); 143INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(135,'ALL',TRUE,NULL); 144INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(136,'EXCEPT',TRUE,NULL); 145INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(137,'INTERSECT',TRUE,NULL); 146INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(138,'SELECT',TRUE,NULL); 147INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(139,'VALUES',TRUE,NULL); 148INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(140,'DISTINCT',TRUE,NULL); 149INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(141,'DOT',TRUE,NULL); 150INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(142,'FROM',TRUE,NULL); 151INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(143,'JOIN',TRUE,NULL); 152INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(144,'USING',TRUE,NULL); 153INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(145,'ORDER',TRUE,NULL); 154INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(146,'GROUP',TRUE,NULL); 155INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(147,'HAVING',TRUE,NULL); 156INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(148,'LIMIT',TRUE,NULL); 157INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(149,'WHERE',TRUE,NULL); 158INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(150,'RETURNING',TRUE,NULL); 159INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(151,'INTO',TRUE,NULL); 160INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(152,'NOTHING',TRUE,NULL); 161INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(153,'FLOAT',TRUE,NULL); 162INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(154,'BLOB',TRUE,NULL); 163INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(155,'INTEGER',TRUE,NULL); 164INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(156,'VARIABLE',TRUE,NULL); 165INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(157,'CASE',TRUE,NULL); 166INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(158,'WHEN',TRUE,NULL); 167INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(159,'THEN',TRUE,NULL); 168INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(160,'ELSE',TRUE,NULL); 169INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(161,'INDEX',TRUE,NULL); 170INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(162,'ALTER',TRUE,NULL); 171INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(163,'ADD',TRUE,NULL); 172INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(164,'WINDOW',TRUE,NULL); 173INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(165,'OVER',TRUE,NULL); 174INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(166,'FILTER',TRUE,NULL); 175INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(167,'COLUMN',TRUE,NULL); 176INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(168,'AGG_FUNCTION',TRUE,NULL); 177INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(169,'AGG_COLUMN',TRUE,NULL); 178INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(170,'TRUEFALSE',TRUE,NULL); 179INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(171,'ISNOT',TRUE,NULL); 180INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(172,'FUNCTION',TRUE,NULL); 181INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(173,'UMINUS',TRUE,NULL); 182INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(174,'UPLUS',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,'SPACE',TRUE,NULL); 192INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(184,'ILLEGAL',TRUE,NULL); 193INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(185,'input',FALSE,NULL); 194INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(186,'cmdlist',FALSE,NULL); 195INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(187,'ecmd',FALSE,NULL); 196INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(188,'cmdx',FALSE,NULL); 197INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(189,'explain',FALSE,NULL); 198INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(190,'cmd',FALSE,NULL); 199INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(191,'transtype',FALSE,NULL); 200INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(192,'trans_opt',FALSE,NULL); 201INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(193,'nm',FALSE,NULL); 202INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(194,'savepoint_opt',FALSE,NULL); 203INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(195,'create_table',FALSE,NULL); 204INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(196,'create_table_args',FALSE,NULL); 205INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(197,'createkw',FALSE,NULL); 206INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(198,'temp',FALSE,NULL); 207INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(199,'ifnotexists',FALSE,NULL); 208INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(200,'dbnm',FALSE,NULL); 209INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(201,'columnlist',FALSE,NULL); 210INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(202,'conslist_opt',FALSE,NULL); 211INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(203,'table_option_set',FALSE,NULL); 212INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(204,'select',FALSE,NULL); 213INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(205,'table_option',FALSE,NULL); 214INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(206,'columnname',FALSE,NULL); 215INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(207,'carglist',FALSE,NULL); 216INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(208,'typetoken',FALSE,NULL); 217INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(209,'typename',FALSE,NULL); 218INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(210,'signed',FALSE,NULL); 219INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(211,'plus_num',FALSE,NULL); 220INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(212,'minus_num',FALSE,NULL); 221INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(213,'scanpt',FALSE,NULL); 222INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(214,'scantok',FALSE,NULL); 223INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(215,'ccons',FALSE,NULL); 224INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(216,'term',FALSE,NULL); 225INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(217,'expr',FALSE,NULL); 226INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(218,'onconf',FALSE,NULL); 227INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(219,'sortorder',FALSE,NULL); 228INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(220,'autoinc',FALSE,NULL); 229INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(221,'eidlist_opt',FALSE,NULL); 230INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(222,'refargs',FALSE,NULL); 231INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(223,'defer_subclause',FALSE,NULL); 232INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(224,'generated',FALSE,NULL); 233INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(225,'refarg',FALSE,NULL); 234INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(226,'refact',FALSE,NULL); 235INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(227,'init_deferred_pred_opt',FALSE,NULL); 236INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(228,'conslist',FALSE,NULL); 237INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(229,'tconscomma',FALSE,NULL); 238INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(230,'tcons',FALSE,NULL); 239INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(231,'sortlist',FALSE,NULL); 240INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(232,'eidlist',FALSE,NULL); 241INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(233,'defer_subclause_opt',FALSE,NULL); 242INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(234,'orconf',FALSE,NULL); 243INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(235,'resolvetype',FALSE,NULL); 244INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(236,'raisetype',FALSE,NULL); 245INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(237,'ifexists',FALSE,NULL); 246INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(238,'fullname',FALSE,NULL); 247INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(239,'selectnowith',FALSE,NULL); 248INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(240,'oneselect',FALSE,NULL); 249INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(241,'wqlist',FALSE,NULL); 250INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(242,'multiselect_op',FALSE,NULL); 251INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(243,'distinct',FALSE,NULL); 252INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(244,'selcollist',FALSE,NULL); 253INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(245,'from',FALSE,NULL); 254INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(246,'where_opt',FALSE,NULL); 255INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(247,'groupby_opt',FALSE,NULL); 256INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(248,'having_opt',FALSE,NULL); 257INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(249,'orderby_opt',FALSE,NULL); 258INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(250,'limit_opt',FALSE,NULL); 259INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(251,'window_clause',FALSE,NULL); 260INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(252,'values',FALSE,NULL); 261INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(253,'nexprlist',FALSE,NULL); 262INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(254,'sclp',FALSE,NULL); 263INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(255,'as',FALSE,NULL); 264INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(256,'seltablist',FALSE,NULL); 265INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(257,'stl_prefix',FALSE,NULL); 266INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(258,'joinop',FALSE,NULL); 267INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(259,'on_using',FALSE,NULL); 268INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(260,'indexed_by',FALSE,NULL); 269INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(261,'exprlist',FALSE,NULL); 270INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(262,'xfullname',FALSE,NULL); 271INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(263,'idlist',FALSE,NULL); 272INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(264,'indexed_opt',FALSE,NULL); 273INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(265,'nulls',FALSE,NULL); 274INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(266,'with',FALSE,NULL); 275INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(267,'where_opt_ret',FALSE,NULL); 276INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(268,'setlist',FALSE,NULL); 277INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(269,'insert_cmd',FALSE,NULL); 278INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(270,'idlist_opt',FALSE,NULL); 279INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(271,'upsert',FALSE,NULL); 280INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(272,'returning',FALSE,NULL); 281INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(273,'filter_over',FALSE,NULL); 282INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(274,'likeop',FALSE,NULL); 283INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(275,'between_op',FALSE,NULL); 284INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(276,'in_op',FALSE,NULL); 285INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(277,'paren_exprlist',FALSE,NULL); 286INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(278,'case_operand',FALSE,NULL); 287INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(279,'case_exprlist',FALSE,NULL); 288INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(280,'case_else',FALSE,NULL); 289INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(281,'uniqueflag',FALSE,NULL); 290INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(282,'collate',FALSE,NULL); 291INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(283,'vinto',FALSE,NULL); 292INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(284,'nmnum',FALSE,NULL); 293INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(285,'trigger_decl',FALSE,NULL); 294INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(286,'trigger_cmd_list',FALSE,NULL); 295INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(287,'trigger_time',FALSE,NULL); 296INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(288,'trigger_event',FALSE,NULL); 297INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(289,'foreach_clause',FALSE,NULL); 298INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(290,'when_clause',FALSE,NULL); 299INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(291,'trigger_cmd',FALSE,NULL); 300INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(292,'trnm',FALSE,NULL); 301INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(293,'tridxby',FALSE,NULL); 302INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(294,'database_kw_opt',FALSE,NULL); 303INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(295,'key_opt',FALSE,NULL); 304INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(296,'add_column_fullname',FALSE,NULL); 305INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(297,'kwcolumn_opt',FALSE,NULL); 306INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(298,'create_vtab',FALSE,NULL); 307INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(299,'vtabarglist',FALSE,NULL); 308INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(300,'vtabarg',FALSE,NULL); 309INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(301,'vtabargtoken',FALSE,NULL); 310INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(302,'lp',FALSE,NULL); 311INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(303,'anylist',FALSE,NULL); 312INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(304,'wqitem',FALSE,NULL); 313INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(305,'wqas',FALSE,NULL); 314INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(306,'windowdefn_list',FALSE,NULL); 315INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(307,'windowdefn',FALSE,NULL); 316INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(308,'window',FALSE,NULL); 317INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(309,'frame_opt',FALSE,NULL); 318INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(310,'part_opt',FALSE,NULL); 319INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(311,'filter_clause',FALSE,NULL); 320INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(312,'over_clause',FALSE,NULL); 321INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(313,'range_or_rows',FALSE,NULL); 322INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(314,'frame_bound',FALSE,NULL); 323INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(315,'frame_bound_s',FALSE,NULL); 324INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(316,'frame_bound_e',FALSE,NULL); 325INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(317,'frame_exclude_opt',FALSE,NULL); 326INSERT INTO symbol(id,name,isTerminal,fallback)VALUES(318,'frame_exclude',FALSE,NULL); 327CREATE TABLE rule( 328 ruleid INTEGER PRIMARY KEY, 329 lhs INTEGER REFERENCES symbol(id), 330 txt TEXT 331); 332CREATE TABLE rulerhs( 333 ruleid INTEGER REFERENCES rule(ruleid), 334 pos INTEGER, 335 sym INTEGER REFERENCES symbol(id) 336); 337INSERT INTO rule(ruleid,lhs,txt)VALUES(0,189,'explain ::= EXPLAIN'); 338INSERT INTO rulerhs(ruleid,pos,sym)VALUES(0,0,2); 339INSERT INTO rule(ruleid,lhs,txt)VALUES(1,189,'explain ::= EXPLAIN QUERY PLAN'); 340INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,0,2); 341INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,1,3); 342INSERT INTO rulerhs(ruleid,pos,sym)VALUES(1,2,4); 343INSERT INTO rule(ruleid,lhs,txt)VALUES(2,188,'cmdx ::= cmd'); 344INSERT INTO rulerhs(ruleid,pos,sym)VALUES(2,0,190); 345INSERT INTO rule(ruleid,lhs,txt)VALUES(3,190,'cmd ::= BEGIN transtype trans_opt'); 346INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,0,5); 347INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,1,191); 348INSERT INTO rulerhs(ruleid,pos,sym)VALUES(3,2,192); 349INSERT INTO rule(ruleid,lhs,txt)VALUES(4,191,'transtype ::='); 350INSERT INTO rule(ruleid,lhs,txt)VALUES(5,191,'transtype ::= DEFERRED'); 351INSERT INTO rulerhs(ruleid,pos,sym)VALUES(5,0,7); 352INSERT INTO rule(ruleid,lhs,txt)VALUES(6,191,'transtype ::= IMMEDIATE'); 353INSERT INTO rulerhs(ruleid,pos,sym)VALUES(6,0,8); 354INSERT INTO rule(ruleid,lhs,txt)VALUES(7,191,'transtype ::= EXCLUSIVE'); 355INSERT INTO rulerhs(ruleid,pos,sym)VALUES(7,0,9); 356INSERT INTO rule(ruleid,lhs,txt)VALUES(8,190,'cmd ::= COMMIT|END trans_opt'); 357INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,0,10); 358INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,0,11); 359INSERT INTO rulerhs(ruleid,pos,sym)VALUES(8,1,192); 360INSERT INTO rule(ruleid,lhs,txt)VALUES(9,190,'cmd ::= ROLLBACK trans_opt'); 361INSERT INTO rulerhs(ruleid,pos,sym)VALUES(9,0,12); 362INSERT INTO rulerhs(ruleid,pos,sym)VALUES(9,1,192); 363INSERT INTO rule(ruleid,lhs,txt)VALUES(10,190,'cmd ::= SAVEPOINT nm'); 364INSERT INTO rulerhs(ruleid,pos,sym)VALUES(10,0,13); 365INSERT INTO rulerhs(ruleid,pos,sym)VALUES(10,1,193); 366INSERT INTO rule(ruleid,lhs,txt)VALUES(11,190,'cmd ::= RELEASE savepoint_opt nm'); 367INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,0,14); 368INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,1,194); 369INSERT INTO rulerhs(ruleid,pos,sym)VALUES(11,2,193); 370INSERT INTO rule(ruleid,lhs,txt)VALUES(12,190,'cmd ::= ROLLBACK trans_opt TO savepoint_opt nm'); 371INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,0,12); 372INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,1,192); 373INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,2,15); 374INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,3,194); 375INSERT INTO rulerhs(ruleid,pos,sym)VALUES(12,4,193); 376INSERT INTO rule(ruleid,lhs,txt)VALUES(13,195,'create_table ::= createkw temp TABLE ifnotexists nm dbnm'); 377INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,0,197); 378INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,1,198); 379INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,2,16); 380INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,3,199); 381INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,4,193); 382INSERT INTO rulerhs(ruleid,pos,sym)VALUES(13,5,200); 383INSERT INTO rule(ruleid,lhs,txt)VALUES(14,197,'createkw ::= CREATE'); 384INSERT INTO rulerhs(ruleid,pos,sym)VALUES(14,0,17); 385INSERT INTO rule(ruleid,lhs,txt)VALUES(15,199,'ifnotexists ::='); 386INSERT INTO rule(ruleid,lhs,txt)VALUES(16,199,'ifnotexists ::= IF NOT EXISTS'); 387INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,0,18); 388INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,1,19); 389INSERT INTO rulerhs(ruleid,pos,sym)VALUES(16,2,20); 390INSERT INTO rule(ruleid,lhs,txt)VALUES(17,198,'temp ::= TEMP'); 391INSERT INTO rulerhs(ruleid,pos,sym)VALUES(17,0,21); 392INSERT INTO rule(ruleid,lhs,txt)VALUES(18,198,'temp ::='); 393INSERT INTO rule(ruleid,lhs,txt)VALUES(19,196,'create_table_args ::= LP columnlist conslist_opt RP table_option_set'); 394INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,0,22); 395INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,1,201); 396INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,2,202); 397INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,3,23); 398INSERT INTO rulerhs(ruleid,pos,sym)VALUES(19,4,203); 399INSERT INTO rule(ruleid,lhs,txt)VALUES(20,196,'create_table_args ::= AS select'); 400INSERT INTO rulerhs(ruleid,pos,sym)VALUES(20,0,24); 401INSERT INTO rulerhs(ruleid,pos,sym)VALUES(20,1,204); 402INSERT INTO rule(ruleid,lhs,txt)VALUES(21,203,'table_option_set ::='); 403INSERT INTO rule(ruleid,lhs,txt)VALUES(22,203,'table_option_set ::= table_option_set COMMA table_option'); 404INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,0,203); 405INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,1,25); 406INSERT INTO rulerhs(ruleid,pos,sym)VALUES(22,2,205); 407INSERT INTO rule(ruleid,lhs,txt)VALUES(23,205,'table_option ::= WITHOUT nm'); 408INSERT INTO rulerhs(ruleid,pos,sym)VALUES(23,0,26); 409INSERT INTO rulerhs(ruleid,pos,sym)VALUES(23,1,193); 410INSERT INTO rule(ruleid,lhs,txt)VALUES(24,205,'table_option ::= nm'); 411INSERT INTO rulerhs(ruleid,pos,sym)VALUES(24,0,193); 412INSERT INTO rule(ruleid,lhs,txt)VALUES(25,206,'columnname ::= nm typetoken'); 413INSERT INTO rulerhs(ruleid,pos,sym)VALUES(25,0,193); 414INSERT INTO rulerhs(ruleid,pos,sym)VALUES(25,1,208); 415INSERT INTO rule(ruleid,lhs,txt)VALUES(26,208,'typetoken ::='); 416INSERT INTO rule(ruleid,lhs,txt)VALUES(27,208,'typetoken ::= typename LP signed RP'); 417INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,0,209); 418INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,1,22); 419INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,2,210); 420INSERT INTO rulerhs(ruleid,pos,sym)VALUES(27,3,23); 421INSERT INTO rule(ruleid,lhs,txt)VALUES(28,208,'typetoken ::= typename LP signed COMMA signed RP'); 422INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,0,209); 423INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,1,22); 424INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,2,210); 425INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,3,25); 426INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,4,210); 427INSERT INTO rulerhs(ruleid,pos,sym)VALUES(28,5,23); 428INSERT INTO rule(ruleid,lhs,txt)VALUES(29,209,'typename ::= typename ID|STRING'); 429INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,0,209); 430INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,1,59); 431INSERT INTO rulerhs(ruleid,pos,sym)VALUES(29,1,117); 432INSERT INTO rule(ruleid,lhs,txt)VALUES(30,213,'scanpt ::='); 433INSERT INTO rule(ruleid,lhs,txt)VALUES(31,214,'scantok ::='); 434INSERT INTO rule(ruleid,lhs,txt)VALUES(32,215,'ccons ::= CONSTRAINT nm'); 435INSERT INTO rulerhs(ruleid,pos,sym)VALUES(32,0,119); 436INSERT INTO rulerhs(ruleid,pos,sym)VALUES(32,1,193); 437INSERT INTO rule(ruleid,lhs,txt)VALUES(33,215,'ccons ::= DEFAULT scantok term'); 438INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,0,120); 439INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,1,214); 440INSERT INTO rulerhs(ruleid,pos,sym)VALUES(33,2,216); 441INSERT INTO rule(ruleid,lhs,txt)VALUES(34,215,'ccons ::= DEFAULT LP expr RP'); 442INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,0,120); 443INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,1,22); 444INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,2,217); 445INSERT INTO rulerhs(ruleid,pos,sym)VALUES(34,3,23); 446INSERT INTO rule(ruleid,lhs,txt)VALUES(35,215,'ccons ::= DEFAULT PLUS scantok term'); 447INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,0,120); 448INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,1,106); 449INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,2,214); 450INSERT INTO rulerhs(ruleid,pos,sym)VALUES(35,3,216); 451INSERT INTO rule(ruleid,lhs,txt)VALUES(36,215,'ccons ::= DEFAULT MINUS scantok term'); 452INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,0,120); 453INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,1,107); 454INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,2,214); 455INSERT INTO rulerhs(ruleid,pos,sym)VALUES(36,3,216); 456INSERT INTO rule(ruleid,lhs,txt)VALUES(37,215,'ccons ::= DEFAULT scantok ID|INDEXED'); 457INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,0,120); 458INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,1,214); 459INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,2,59); 460INSERT INTO rulerhs(ruleid,pos,sym)VALUES(37,2,116); 461INSERT INTO rule(ruleid,lhs,txt)VALUES(38,215,'ccons ::= NOT NULL onconf'); 462INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,0,19); 463INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,1,121); 464INSERT INTO rulerhs(ruleid,pos,sym)VALUES(38,2,218); 465INSERT INTO rule(ruleid,lhs,txt)VALUES(39,215,'ccons ::= PRIMARY KEY sortorder onconf autoinc'); 466INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,0,122); 467INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,1,67); 468INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,2,219); 469INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,3,218); 470INSERT INTO rulerhs(ruleid,pos,sym)VALUES(39,4,220); 471INSERT INTO rule(ruleid,lhs,txt)VALUES(40,215,'ccons ::= UNIQUE onconf'); 472INSERT INTO rulerhs(ruleid,pos,sym)VALUES(40,0,123); 473INSERT INTO rulerhs(ruleid,pos,sym)VALUES(40,1,218); 474INSERT INTO rule(ruleid,lhs,txt)VALUES(41,215,'ccons ::= CHECK LP expr RP'); 475INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,0,124); 476INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,1,22); 477INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,2,217); 478INSERT INTO rulerhs(ruleid,pos,sym)VALUES(41,3,23); 479INSERT INTO rule(ruleid,lhs,txt)VALUES(42,215,'ccons ::= REFERENCES nm eidlist_opt refargs'); 480INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,0,125); 481INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,1,193); 482INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,2,221); 483INSERT INTO rulerhs(ruleid,pos,sym)VALUES(42,3,222); 484INSERT INTO rule(ruleid,lhs,txt)VALUES(43,215,'ccons ::= defer_subclause'); 485INSERT INTO rulerhs(ruleid,pos,sym)VALUES(43,0,223); 486INSERT INTO rule(ruleid,lhs,txt)VALUES(44,215,'ccons ::= COLLATE ID|STRING'); 487INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,0,113); 488INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,1,59); 489INSERT INTO rulerhs(ruleid,pos,sym)VALUES(44,1,117); 490INSERT INTO rule(ruleid,lhs,txt)VALUES(45,224,'generated ::= LP expr RP'); 491INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,0,22); 492INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,1,217); 493INSERT INTO rulerhs(ruleid,pos,sym)VALUES(45,2,23); 494INSERT INTO rule(ruleid,lhs,txt)VALUES(46,224,'generated ::= LP expr RP ID'); 495INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,0,22); 496INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,1,217); 497INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,2,23); 498INSERT INTO rulerhs(ruleid,pos,sym)VALUES(46,3,59); 499INSERT INTO rule(ruleid,lhs,txt)VALUES(47,220,'autoinc ::='); 500INSERT INTO rule(ruleid,lhs,txt)VALUES(48,220,'autoinc ::= AUTOINCR'); 501INSERT INTO rulerhs(ruleid,pos,sym)VALUES(48,0,126); 502INSERT INTO rule(ruleid,lhs,txt)VALUES(49,222,'refargs ::='); 503INSERT INTO rule(ruleid,lhs,txt)VALUES(50,222,'refargs ::= refargs refarg'); 504INSERT INTO rulerhs(ruleid,pos,sym)VALUES(50,0,222); 505INSERT INTO rulerhs(ruleid,pos,sym)VALUES(50,1,225); 506INSERT INTO rule(ruleid,lhs,txt)VALUES(51,225,'refarg ::= MATCH nm'); 507INSERT INTO rulerhs(ruleid,pos,sym)VALUES(51,0,46); 508INSERT INTO rulerhs(ruleid,pos,sym)VALUES(51,1,193); 509INSERT INTO rule(ruleid,lhs,txt)VALUES(52,225,'refarg ::= ON INSERT refact'); 510INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,0,115); 511INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,1,127); 512INSERT INTO rulerhs(ruleid,pos,sym)VALUES(52,2,226); 513INSERT INTO rule(ruleid,lhs,txt)VALUES(53,225,'refarg ::= ON DELETE refact'); 514INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,0,115); 515INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,1,128); 516INSERT INTO rulerhs(ruleid,pos,sym)VALUES(53,2,226); 517INSERT INTO rule(ruleid,lhs,txt)VALUES(54,225,'refarg ::= ON UPDATE refact'); 518INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,0,115); 519INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,1,129); 520INSERT INTO rulerhs(ruleid,pos,sym)VALUES(54,2,226); 521INSERT INTO rule(ruleid,lhs,txt)VALUES(55,226,'refact ::= SET NULL'); 522INSERT INTO rulerhs(ruleid,pos,sym)VALUES(55,0,130); 523INSERT INTO rulerhs(ruleid,pos,sym)VALUES(55,1,121); 524INSERT INTO rule(ruleid,lhs,txt)VALUES(56,226,'refact ::= SET DEFAULT'); 525INSERT INTO rulerhs(ruleid,pos,sym)VALUES(56,0,130); 526INSERT INTO rulerhs(ruleid,pos,sym)VALUES(56,1,120); 527INSERT INTO rule(ruleid,lhs,txt)VALUES(57,226,'refact ::= CASCADE'); 528INSERT INTO rulerhs(ruleid,pos,sym)VALUES(57,0,35); 529INSERT INTO rule(ruleid,lhs,txt)VALUES(58,226,'refact ::= RESTRICT'); 530INSERT INTO rulerhs(ruleid,pos,sym)VALUES(58,0,74); 531INSERT INTO rule(ruleid,lhs,txt)VALUES(59,226,'refact ::= NO ACTION'); 532INSERT INTO rulerhs(ruleid,pos,sym)VALUES(59,0,66); 533INSERT INTO rulerhs(ruleid,pos,sym)VALUES(59,1,28); 534INSERT INTO rule(ruleid,lhs,txt)VALUES(60,223,'defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt'); 535INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,0,19); 536INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,1,131); 537INSERT INTO rulerhs(ruleid,pos,sym)VALUES(60,2,227); 538INSERT INTO rule(ruleid,lhs,txt)VALUES(61,223,'defer_subclause ::= DEFERRABLE init_deferred_pred_opt'); 539INSERT INTO rulerhs(ruleid,pos,sym)VALUES(61,0,131); 540INSERT INTO rulerhs(ruleid,pos,sym)VALUES(61,1,227); 541INSERT INTO rule(ruleid,lhs,txt)VALUES(62,227,'init_deferred_pred_opt ::='); 542INSERT INTO rule(ruleid,lhs,txt)VALUES(63,227,'init_deferred_pred_opt ::= INITIALLY DEFERRED'); 543INSERT INTO rulerhs(ruleid,pos,sym)VALUES(63,0,64); 544INSERT INTO rulerhs(ruleid,pos,sym)VALUES(63,1,7); 545INSERT INTO rule(ruleid,lhs,txt)VALUES(64,227,'init_deferred_pred_opt ::= INITIALLY IMMEDIATE'); 546INSERT INTO rulerhs(ruleid,pos,sym)VALUES(64,0,64); 547INSERT INTO rulerhs(ruleid,pos,sym)VALUES(64,1,8); 548INSERT INTO rule(ruleid,lhs,txt)VALUES(65,202,'conslist_opt ::='); 549INSERT INTO rule(ruleid,lhs,txt)VALUES(66,229,'tconscomma ::= COMMA'); 550INSERT INTO rulerhs(ruleid,pos,sym)VALUES(66,0,25); 551INSERT INTO rule(ruleid,lhs,txt)VALUES(67,230,'tcons ::= CONSTRAINT nm'); 552INSERT INTO rulerhs(ruleid,pos,sym)VALUES(67,0,119); 553INSERT INTO rulerhs(ruleid,pos,sym)VALUES(67,1,193); 554INSERT INTO rule(ruleid,lhs,txt)VALUES(68,230,'tcons ::= PRIMARY KEY LP sortlist autoinc RP onconf'); 555INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,0,122); 556INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,1,67); 557INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,2,22); 558INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,3,231); 559INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,4,220); 560INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,5,23); 561INSERT INTO rulerhs(ruleid,pos,sym)VALUES(68,6,218); 562INSERT INTO rule(ruleid,lhs,txt)VALUES(69,230,'tcons ::= UNIQUE LP sortlist RP onconf'); 563INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,0,123); 564INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,1,22); 565INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,2,231); 566INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,3,23); 567INSERT INTO rulerhs(ruleid,pos,sym)VALUES(69,4,218); 568INSERT INTO rule(ruleid,lhs,txt)VALUES(70,230,'tcons ::= CHECK LP expr RP onconf'); 569INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,0,124); 570INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,1,22); 571INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,2,217); 572INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,3,23); 573INSERT INTO rulerhs(ruleid,pos,sym)VALUES(70,4,218); 574INSERT INTO rule(ruleid,lhs,txt)VALUES(71,230,'tcons ::= FOREIGN KEY LP eidlist RP REFERENCES nm eidlist_opt refargs defer_subclause_opt'); 575INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,0,132); 576INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,1,67); 577INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,2,22); 578INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,3,232); 579INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,4,23); 580INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,5,125); 581INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,6,193); 582INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,7,221); 583INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,8,222); 584INSERT INTO rulerhs(ruleid,pos,sym)VALUES(71,9,233); 585INSERT INTO rule(ruleid,lhs,txt)VALUES(72,233,'defer_subclause_opt ::='); 586INSERT INTO rule(ruleid,lhs,txt)VALUES(73,218,'onconf ::='); 587INSERT INTO rule(ruleid,lhs,txt)VALUES(74,218,'onconf ::= ON CONFLICT resolvetype'); 588INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,0,115); 589INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,1,37); 590INSERT INTO rulerhs(ruleid,pos,sym)VALUES(74,2,235); 591INSERT INTO rule(ruleid,lhs,txt)VALUES(75,234,'orconf ::='); 592INSERT INTO rule(ruleid,lhs,txt)VALUES(76,234,'orconf ::= OR resolvetype'); 593INSERT INTO rulerhs(ruleid,pos,sym)VALUES(76,0,43); 594INSERT INTO rulerhs(ruleid,pos,sym)VALUES(76,1,235); 595INSERT INTO rule(ruleid,lhs,txt)VALUES(77,235,'resolvetype ::= IGNORE'); 596INSERT INTO rulerhs(ruleid,pos,sym)VALUES(77,0,63); 597INSERT INTO rule(ruleid,lhs,txt)VALUES(78,235,'resolvetype ::= REPLACE'); 598INSERT INTO rulerhs(ruleid,pos,sym)VALUES(78,0,73); 599INSERT INTO rule(ruleid,lhs,txt)VALUES(79,190,'cmd ::= DROP TABLE ifexists fullname'); 600INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,0,133); 601INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,1,16); 602INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,2,237); 603INSERT INTO rulerhs(ruleid,pos,sym)VALUES(79,3,238); 604INSERT INTO rule(ruleid,lhs,txt)VALUES(80,237,'ifexists ::= IF EXISTS'); 605INSERT INTO rulerhs(ruleid,pos,sym)VALUES(80,0,18); 606INSERT INTO rulerhs(ruleid,pos,sym)VALUES(80,1,20); 607INSERT INTO rule(ruleid,lhs,txt)VALUES(81,237,'ifexists ::='); 608INSERT INTO rule(ruleid,lhs,txt)VALUES(82,190,'cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select'); 609INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,0,197); 610INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,1,198); 611INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,2,79); 612INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,3,199); 613INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,4,193); 614INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,5,200); 615INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,6,221); 616INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,7,24); 617INSERT INTO rulerhs(ruleid,pos,sym)VALUES(82,8,204); 618INSERT INTO rule(ruleid,lhs,txt)VALUES(83,190,'cmd ::= DROP VIEW ifexists fullname'); 619INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,0,133); 620INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,1,79); 621INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,2,237); 622INSERT INTO rulerhs(ruleid,pos,sym)VALUES(83,3,238); 623INSERT INTO rule(ruleid,lhs,txt)VALUES(84,190,'cmd ::= select'); 624INSERT INTO rulerhs(ruleid,pos,sym)VALUES(84,0,204); 625INSERT INTO rule(ruleid,lhs,txt)VALUES(85,204,'select ::= WITH wqlist selectnowith'); 626INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,0,81); 627INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,1,241); 628INSERT INTO rulerhs(ruleid,pos,sym)VALUES(85,2,239); 629INSERT INTO rule(ruleid,lhs,txt)VALUES(86,204,'select ::= WITH RECURSIVE wqlist selectnowith'); 630INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,0,81); 631INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,1,72); 632INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,2,241); 633INSERT INTO rulerhs(ruleid,pos,sym)VALUES(86,3,239); 634INSERT INTO rule(ruleid,lhs,txt)VALUES(87,204,'select ::= selectnowith'); 635INSERT INTO rulerhs(ruleid,pos,sym)VALUES(87,0,239); 636INSERT INTO rule(ruleid,lhs,txt)VALUES(88,239,'selectnowith ::= selectnowith multiselect_op oneselect'); 637INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,0,239); 638INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,1,242); 639INSERT INTO rulerhs(ruleid,pos,sym)VALUES(88,2,240); 640INSERT INTO rule(ruleid,lhs,txt)VALUES(89,242,'multiselect_op ::= UNION'); 641INSERT INTO rulerhs(ruleid,pos,sym)VALUES(89,0,134); 642INSERT INTO rule(ruleid,lhs,txt)VALUES(90,242,'multiselect_op ::= UNION ALL'); 643INSERT INTO rulerhs(ruleid,pos,sym)VALUES(90,0,134); 644INSERT INTO rulerhs(ruleid,pos,sym)VALUES(90,1,135); 645INSERT INTO rule(ruleid,lhs,txt)VALUES(91,242,'multiselect_op ::= EXCEPT|INTERSECT'); 646INSERT INTO rulerhs(ruleid,pos,sym)VALUES(91,0,136); 647INSERT INTO rulerhs(ruleid,pos,sym)VALUES(91,0,137); 648INSERT INTO rule(ruleid,lhs,txt)VALUES(92,240,'oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt'); 649INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,0,138); 650INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,1,243); 651INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,2,244); 652INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,3,245); 653INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,4,246); 654INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,5,247); 655INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,6,248); 656INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,7,249); 657INSERT INTO rulerhs(ruleid,pos,sym)VALUES(92,8,250); 658INSERT INTO rule(ruleid,lhs,txt)VALUES(93,240,'oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt'); 659INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,0,138); 660INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,1,243); 661INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,2,244); 662INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,3,245); 663INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,4,246); 664INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,5,247); 665INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,6,248); 666INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,7,251); 667INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,8,249); 668INSERT INTO rulerhs(ruleid,pos,sym)VALUES(93,9,250); 669INSERT INTO rule(ruleid,lhs,txt)VALUES(94,252,'values ::= VALUES LP nexprlist RP'); 670INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,0,139); 671INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,1,22); 672INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,2,253); 673INSERT INTO rulerhs(ruleid,pos,sym)VALUES(94,3,23); 674INSERT INTO rule(ruleid,lhs,txt)VALUES(95,252,'values ::= values COMMA LP nexprlist RP'); 675INSERT INTO rulerhs(ruleid,pos,sym)VALUES(95,0,252); 676INSERT INTO rulerhs(ruleid,pos,sym)VALUES(95,1,25); 677INSERT INTO rulerhs(ruleid,pos,sym)VALUES(95,2,22); 678INSERT INTO rulerhs(ruleid,pos,sym)VALUES(95,3,253); 679INSERT INTO rulerhs(ruleid,pos,sym)VALUES(95,4,23); 680INSERT INTO rule(ruleid,lhs,txt)VALUES(96,243,'distinct ::= DISTINCT'); 681INSERT INTO rulerhs(ruleid,pos,sym)VALUES(96,0,140); 682INSERT INTO rule(ruleid,lhs,txt)VALUES(97,243,'distinct ::= ALL'); 683INSERT INTO rulerhs(ruleid,pos,sym)VALUES(97,0,135); 684INSERT INTO rule(ruleid,lhs,txt)VALUES(98,243,'distinct ::='); 685INSERT INTO rule(ruleid,lhs,txt)VALUES(99,254,'sclp ::='); 686INSERT INTO rule(ruleid,lhs,txt)VALUES(100,244,'selcollist ::= sclp scanpt expr scanpt as'); 687INSERT INTO rulerhs(ruleid,pos,sym)VALUES(100,0,254); 688INSERT INTO rulerhs(ruleid,pos,sym)VALUES(100,1,213); 689INSERT INTO rulerhs(ruleid,pos,sym)VALUES(100,2,217); 690INSERT INTO rulerhs(ruleid,pos,sym)VALUES(100,3,213); 691INSERT INTO rulerhs(ruleid,pos,sym)VALUES(100,4,255); 692INSERT INTO rule(ruleid,lhs,txt)VALUES(101,244,'selcollist ::= sclp scanpt STAR'); 693INSERT INTO rulerhs(ruleid,pos,sym)VALUES(101,0,254); 694INSERT INTO rulerhs(ruleid,pos,sym)VALUES(101,1,213); 695INSERT INTO rulerhs(ruleid,pos,sym)VALUES(101,2,108); 696INSERT INTO rule(ruleid,lhs,txt)VALUES(102,244,'selcollist ::= sclp scanpt nm DOT STAR'); 697INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,0,254); 698INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,1,213); 699INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,2,193); 700INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,3,141); 701INSERT INTO rulerhs(ruleid,pos,sym)VALUES(102,4,108); 702INSERT INTO rule(ruleid,lhs,txt)VALUES(103,255,'as ::= AS nm'); 703INSERT INTO rulerhs(ruleid,pos,sym)VALUES(103,0,24); 704INSERT INTO rulerhs(ruleid,pos,sym)VALUES(103,1,193); 705INSERT INTO rule(ruleid,lhs,txt)VALUES(104,255,'as ::='); 706INSERT INTO rule(ruleid,lhs,txt)VALUES(105,245,'from ::='); 707INSERT INTO rule(ruleid,lhs,txt)VALUES(106,245,'from ::= FROM seltablist'); 708INSERT INTO rulerhs(ruleid,pos,sym)VALUES(106,0,142); 709INSERT INTO rulerhs(ruleid,pos,sym)VALUES(106,1,256); 710INSERT INTO rule(ruleid,lhs,txt)VALUES(107,257,'stl_prefix ::= seltablist joinop'); 711INSERT INTO rulerhs(ruleid,pos,sym)VALUES(107,0,256); 712INSERT INTO rulerhs(ruleid,pos,sym)VALUES(107,1,258); 713INSERT INTO rule(ruleid,lhs,txt)VALUES(108,257,'stl_prefix ::='); 714INSERT INTO rule(ruleid,lhs,txt)VALUES(109,256,'seltablist ::= stl_prefix nm dbnm as on_using'); 715INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,0,257); 716INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,1,193); 717INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,2,200); 718INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,3,255); 719INSERT INTO rulerhs(ruleid,pos,sym)VALUES(109,4,259); 720INSERT INTO rule(ruleid,lhs,txt)VALUES(110,256,'seltablist ::= stl_prefix nm dbnm as indexed_by on_using'); 721INSERT INTO rulerhs(ruleid,pos,sym)VALUES(110,0,257); 722INSERT INTO rulerhs(ruleid,pos,sym)VALUES(110,1,193); 723INSERT INTO rulerhs(ruleid,pos,sym)VALUES(110,2,200); 724INSERT INTO rulerhs(ruleid,pos,sym)VALUES(110,3,255); 725INSERT INTO rulerhs(ruleid,pos,sym)VALUES(110,4,260); 726INSERT INTO rulerhs(ruleid,pos,sym)VALUES(110,5,259); 727INSERT INTO rule(ruleid,lhs,txt)VALUES(111,256,'seltablist ::= stl_prefix nm dbnm LP exprlist RP as on_using'); 728INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,0,257); 729INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,1,193); 730INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,2,200); 731INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,3,22); 732INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,4,261); 733INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,5,23); 734INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,6,255); 735INSERT INTO rulerhs(ruleid,pos,sym)VALUES(111,7,259); 736INSERT INTO rule(ruleid,lhs,txt)VALUES(112,256,'seltablist ::= stl_prefix LP select RP as on_using'); 737INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,0,257); 738INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,1,22); 739INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,2,204); 740INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,3,23); 741INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,4,255); 742INSERT INTO rulerhs(ruleid,pos,sym)VALUES(112,5,259); 743INSERT INTO rule(ruleid,lhs,txt)VALUES(113,256,'seltablist ::= stl_prefix LP seltablist RP as on_using'); 744INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,0,257); 745INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,1,22); 746INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,2,256); 747INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,3,23); 748INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,4,255); 749INSERT INTO rulerhs(ruleid,pos,sym)VALUES(113,5,259); 750INSERT INTO rule(ruleid,lhs,txt)VALUES(114,200,'dbnm ::='); 751INSERT INTO rule(ruleid,lhs,txt)VALUES(115,200,'dbnm ::= DOT nm'); 752INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,0,141); 753INSERT INTO rulerhs(ruleid,pos,sym)VALUES(115,1,193); 754INSERT INTO rule(ruleid,lhs,txt)VALUES(116,238,'fullname ::= nm'); 755INSERT INTO rulerhs(ruleid,pos,sym)VALUES(116,0,193); 756INSERT INTO rule(ruleid,lhs,txt)VALUES(117,238,'fullname ::= nm DOT nm'); 757INSERT INTO rulerhs(ruleid,pos,sym)VALUES(117,0,193); 758INSERT INTO rulerhs(ruleid,pos,sym)VALUES(117,1,141); 759INSERT INTO rulerhs(ruleid,pos,sym)VALUES(117,2,193); 760INSERT INTO rule(ruleid,lhs,txt)VALUES(118,262,'xfullname ::= nm'); 761INSERT INTO rulerhs(ruleid,pos,sym)VALUES(118,0,193); 762INSERT INTO rule(ruleid,lhs,txt)VALUES(119,262,'xfullname ::= nm DOT nm'); 763INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,0,193); 764INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,1,141); 765INSERT INTO rulerhs(ruleid,pos,sym)VALUES(119,2,193); 766INSERT INTO rule(ruleid,lhs,txt)VALUES(120,262,'xfullname ::= nm DOT nm AS nm'); 767INSERT INTO rulerhs(ruleid,pos,sym)VALUES(120,0,193); 768INSERT INTO rulerhs(ruleid,pos,sym)VALUES(120,1,141); 769INSERT INTO rulerhs(ruleid,pos,sym)VALUES(120,2,193); 770INSERT INTO rulerhs(ruleid,pos,sym)VALUES(120,3,24); 771INSERT INTO rulerhs(ruleid,pos,sym)VALUES(120,4,193); 772INSERT INTO rule(ruleid,lhs,txt)VALUES(121,262,'xfullname ::= nm AS nm'); 773INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,0,193); 774INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,1,24); 775INSERT INTO rulerhs(ruleid,pos,sym)VALUES(121,2,193); 776INSERT INTO rule(ruleid,lhs,txt)VALUES(122,258,'joinop ::= COMMA|JOIN'); 777INSERT INTO rulerhs(ruleid,pos,sym)VALUES(122,0,25); 778INSERT INTO rulerhs(ruleid,pos,sym)VALUES(122,0,143); 779INSERT INTO rule(ruleid,lhs,txt)VALUES(123,258,'joinop ::= JOIN_KW JOIN'); 780INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,0,118); 781INSERT INTO rulerhs(ruleid,pos,sym)VALUES(123,1,143); 782INSERT INTO rule(ruleid,lhs,txt)VALUES(124,258,'joinop ::= JOIN_KW nm JOIN'); 783INSERT INTO rulerhs(ruleid,pos,sym)VALUES(124,0,118); 784INSERT INTO rulerhs(ruleid,pos,sym)VALUES(124,1,193); 785INSERT INTO rulerhs(ruleid,pos,sym)VALUES(124,2,143); 786INSERT INTO rule(ruleid,lhs,txt)VALUES(125,258,'joinop ::= JOIN_KW nm nm JOIN'); 787INSERT INTO rulerhs(ruleid,pos,sym)VALUES(125,0,118); 788INSERT INTO rulerhs(ruleid,pos,sym)VALUES(125,1,193); 789INSERT INTO rulerhs(ruleid,pos,sym)VALUES(125,2,193); 790INSERT INTO rulerhs(ruleid,pos,sym)VALUES(125,3,143); 791INSERT INTO rule(ruleid,lhs,txt)VALUES(126,259,'on_using ::= ON expr'); 792INSERT INTO rulerhs(ruleid,pos,sym)VALUES(126,0,115); 793INSERT INTO rulerhs(ruleid,pos,sym)VALUES(126,1,217); 794INSERT INTO rule(ruleid,lhs,txt)VALUES(127,259,'on_using ::= USING LP idlist RP'); 795INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,0,144); 796INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,1,22); 797INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,2,263); 798INSERT INTO rulerhs(ruleid,pos,sym)VALUES(127,3,23); 799INSERT INTO rule(ruleid,lhs,txt)VALUES(128,259,'on_using ::='); 800INSERT INTO rule(ruleid,lhs,txt)VALUES(129,264,'indexed_opt ::='); 801INSERT INTO rule(ruleid,lhs,txt)VALUES(130,260,'indexed_by ::= INDEXED BY nm'); 802INSERT INTO rulerhs(ruleid,pos,sym)VALUES(130,0,116); 803INSERT INTO rulerhs(ruleid,pos,sym)VALUES(130,1,34); 804INSERT INTO rulerhs(ruleid,pos,sym)VALUES(130,2,193); 805INSERT INTO rule(ruleid,lhs,txt)VALUES(131,260,'indexed_by ::= NOT INDEXED'); 806INSERT INTO rulerhs(ruleid,pos,sym)VALUES(131,0,19); 807INSERT INTO rulerhs(ruleid,pos,sym)VALUES(131,1,116); 808INSERT INTO rule(ruleid,lhs,txt)VALUES(132,249,'orderby_opt ::='); 809INSERT INTO rule(ruleid,lhs,txt)VALUES(133,249,'orderby_opt ::= ORDER BY sortlist'); 810INSERT INTO rulerhs(ruleid,pos,sym)VALUES(133,0,145); 811INSERT INTO rulerhs(ruleid,pos,sym)VALUES(133,1,34); 812INSERT INTO rulerhs(ruleid,pos,sym)VALUES(133,2,231); 813INSERT INTO rule(ruleid,lhs,txt)VALUES(134,231,'sortlist ::= sortlist COMMA expr sortorder nulls'); 814INSERT INTO rulerhs(ruleid,pos,sym)VALUES(134,0,231); 815INSERT INTO rulerhs(ruleid,pos,sym)VALUES(134,1,25); 816INSERT INTO rulerhs(ruleid,pos,sym)VALUES(134,2,217); 817INSERT INTO rulerhs(ruleid,pos,sym)VALUES(134,3,219); 818INSERT INTO rulerhs(ruleid,pos,sym)VALUES(134,4,265); 819INSERT INTO rule(ruleid,lhs,txt)VALUES(135,231,'sortlist ::= expr sortorder nulls'); 820INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,0,217); 821INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,1,219); 822INSERT INTO rulerhs(ruleid,pos,sym)VALUES(135,2,265); 823INSERT INTO rule(ruleid,lhs,txt)VALUES(136,219,'sortorder ::= ASC'); 824INSERT INTO rulerhs(ruleid,pos,sym)VALUES(136,0,31); 825INSERT INTO rule(ruleid,lhs,txt)VALUES(137,219,'sortorder ::= DESC'); 826INSERT INTO rulerhs(ruleid,pos,sym)VALUES(137,0,39); 827INSERT INTO rule(ruleid,lhs,txt)VALUES(138,219,'sortorder ::='); 828INSERT INTO rule(ruleid,lhs,txt)VALUES(139,265,'nulls ::= NULLS FIRST'); 829INSERT INTO rulerhs(ruleid,pos,sym)VALUES(139,0,82); 830INSERT INTO rulerhs(ruleid,pos,sym)VALUES(139,1,83); 831INSERT INTO rule(ruleid,lhs,txt)VALUES(140,265,'nulls ::= NULLS LAST'); 832INSERT INTO rulerhs(ruleid,pos,sym)VALUES(140,0,82); 833INSERT INTO rulerhs(ruleid,pos,sym)VALUES(140,1,84); 834INSERT INTO rule(ruleid,lhs,txt)VALUES(141,265,'nulls ::='); 835INSERT INTO rule(ruleid,lhs,txt)VALUES(142,247,'groupby_opt ::='); 836INSERT INTO rule(ruleid,lhs,txt)VALUES(143,247,'groupby_opt ::= GROUP BY nexprlist'); 837INSERT INTO rulerhs(ruleid,pos,sym)VALUES(143,0,146); 838INSERT INTO rulerhs(ruleid,pos,sym)VALUES(143,1,34); 839INSERT INTO rulerhs(ruleid,pos,sym)VALUES(143,2,253); 840INSERT INTO rule(ruleid,lhs,txt)VALUES(144,248,'having_opt ::='); 841INSERT INTO rule(ruleid,lhs,txt)VALUES(145,248,'having_opt ::= HAVING expr'); 842INSERT INTO rulerhs(ruleid,pos,sym)VALUES(145,0,147); 843INSERT INTO rulerhs(ruleid,pos,sym)VALUES(145,1,217); 844INSERT INTO rule(ruleid,lhs,txt)VALUES(146,250,'limit_opt ::='); 845INSERT INTO rule(ruleid,lhs,txt)VALUES(147,250,'limit_opt ::= LIMIT expr'); 846INSERT INTO rulerhs(ruleid,pos,sym)VALUES(147,0,148); 847INSERT INTO rulerhs(ruleid,pos,sym)VALUES(147,1,217); 848INSERT INTO rule(ruleid,lhs,txt)VALUES(148,250,'limit_opt ::= LIMIT expr OFFSET expr'); 849INSERT INTO rulerhs(ruleid,pos,sym)VALUES(148,0,148); 850INSERT INTO rulerhs(ruleid,pos,sym)VALUES(148,1,217); 851INSERT INTO rulerhs(ruleid,pos,sym)VALUES(148,2,69); 852INSERT INTO rulerhs(ruleid,pos,sym)VALUES(148,3,217); 853INSERT INTO rule(ruleid,lhs,txt)VALUES(149,250,'limit_opt ::= LIMIT expr COMMA expr'); 854INSERT INTO rulerhs(ruleid,pos,sym)VALUES(149,0,148); 855INSERT INTO rulerhs(ruleid,pos,sym)VALUES(149,1,217); 856INSERT INTO rulerhs(ruleid,pos,sym)VALUES(149,2,25); 857INSERT INTO rulerhs(ruleid,pos,sym)VALUES(149,3,217); 858INSERT INTO rule(ruleid,lhs,txt)VALUES(150,190,'cmd ::= with DELETE FROM xfullname indexed_opt where_opt_ret'); 859INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,0,266); 860INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,1,128); 861INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,2,142); 862INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,3,262); 863INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,4,264); 864INSERT INTO rulerhs(ruleid,pos,sym)VALUES(150,5,267); 865INSERT INTO rule(ruleid,lhs,txt)VALUES(151,246,'where_opt ::='); 866INSERT INTO rule(ruleid,lhs,txt)VALUES(152,246,'where_opt ::= WHERE expr'); 867INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,0,149); 868INSERT INTO rulerhs(ruleid,pos,sym)VALUES(152,1,217); 869INSERT INTO rule(ruleid,lhs,txt)VALUES(153,267,'where_opt_ret ::='); 870INSERT INTO rule(ruleid,lhs,txt)VALUES(154,267,'where_opt_ret ::= WHERE expr'); 871INSERT INTO rulerhs(ruleid,pos,sym)VALUES(154,0,149); 872INSERT INTO rulerhs(ruleid,pos,sym)VALUES(154,1,217); 873INSERT INTO rule(ruleid,lhs,txt)VALUES(155,267,'where_opt_ret ::= RETURNING selcollist'); 874INSERT INTO rulerhs(ruleid,pos,sym)VALUES(155,0,150); 875INSERT INTO rulerhs(ruleid,pos,sym)VALUES(155,1,244); 876INSERT INTO rule(ruleid,lhs,txt)VALUES(156,267,'where_opt_ret ::= WHERE expr RETURNING selcollist'); 877INSERT INTO rulerhs(ruleid,pos,sym)VALUES(156,0,149); 878INSERT INTO rulerhs(ruleid,pos,sym)VALUES(156,1,217); 879INSERT INTO rulerhs(ruleid,pos,sym)VALUES(156,2,150); 880INSERT INTO rulerhs(ruleid,pos,sym)VALUES(156,3,244); 881INSERT INTO rule(ruleid,lhs,txt)VALUES(157,190,'cmd ::= with UPDATE orconf xfullname indexed_opt SET setlist from where_opt_ret'); 882INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,0,266); 883INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,1,129); 884INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,2,234); 885INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,3,262); 886INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,4,264); 887INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,5,130); 888INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,6,268); 889INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,7,245); 890INSERT INTO rulerhs(ruleid,pos,sym)VALUES(157,8,267); 891INSERT INTO rule(ruleid,lhs,txt)VALUES(158,268,'setlist ::= setlist COMMA nm EQ expr'); 892INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,0,268); 893INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,1,25); 894INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,2,193); 895INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,3,53); 896INSERT INTO rulerhs(ruleid,pos,sym)VALUES(158,4,217); 897INSERT INTO rule(ruleid,lhs,txt)VALUES(159,268,'setlist ::= setlist COMMA LP idlist RP EQ expr'); 898INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,0,268); 899INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,1,25); 900INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,2,22); 901INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,3,263); 902INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,4,23); 903INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,5,53); 904INSERT INTO rulerhs(ruleid,pos,sym)VALUES(159,6,217); 905INSERT INTO rule(ruleid,lhs,txt)VALUES(160,268,'setlist ::= nm EQ expr'); 906INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,0,193); 907INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,1,53); 908INSERT INTO rulerhs(ruleid,pos,sym)VALUES(160,2,217); 909INSERT INTO rule(ruleid,lhs,txt)VALUES(161,268,'setlist ::= LP idlist RP EQ expr'); 910INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,0,22); 911INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,1,263); 912INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,2,23); 913INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,3,53); 914INSERT INTO rulerhs(ruleid,pos,sym)VALUES(161,4,217); 915INSERT INTO rule(ruleid,lhs,txt)VALUES(162,190,'cmd ::= with insert_cmd INTO xfullname idlist_opt select upsert'); 916INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,0,266); 917INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,1,269); 918INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,2,151); 919INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,3,262); 920INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,4,270); 921INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,5,204); 922INSERT INTO rulerhs(ruleid,pos,sym)VALUES(162,6,271); 923INSERT INTO rule(ruleid,lhs,txt)VALUES(163,190,'cmd ::= with insert_cmd INTO xfullname idlist_opt DEFAULT VALUES returning'); 924INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,0,266); 925INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,1,269); 926INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,2,151); 927INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,3,262); 928INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,4,270); 929INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,5,120); 930INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,6,139); 931INSERT INTO rulerhs(ruleid,pos,sym)VALUES(163,7,272); 932INSERT INTO rule(ruleid,lhs,txt)VALUES(164,271,'upsert ::='); 933INSERT INTO rule(ruleid,lhs,txt)VALUES(165,271,'upsert ::= RETURNING selcollist'); 934INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,0,150); 935INSERT INTO rulerhs(ruleid,pos,sym)VALUES(165,1,244); 936INSERT INTO rule(ruleid,lhs,txt)VALUES(166,271,'upsert ::= ON CONFLICT LP sortlist RP where_opt DO UPDATE SET setlist where_opt upsert'); 937INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,0,115); 938INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,1,37); 939INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,2,22); 940INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,3,231); 941INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,4,23); 942INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,5,246); 943INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,6,61); 944INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,7,129); 945INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,8,130); 946INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,9,268); 947INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,10,246); 948INSERT INTO rulerhs(ruleid,pos,sym)VALUES(166,11,271); 949INSERT INTO rule(ruleid,lhs,txt)VALUES(167,271,'upsert ::= ON CONFLICT LP sortlist RP where_opt DO NOTHING upsert'); 950INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,0,115); 951INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,1,37); 952INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,2,22); 953INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,3,231); 954INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,4,23); 955INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,5,246); 956INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,6,61); 957INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,7,152); 958INSERT INTO rulerhs(ruleid,pos,sym)VALUES(167,8,271); 959INSERT INTO rule(ruleid,lhs,txt)VALUES(168,271,'upsert ::= ON CONFLICT DO NOTHING returning'); 960INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,0,115); 961INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,1,37); 962INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,2,61); 963INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,3,152); 964INSERT INTO rulerhs(ruleid,pos,sym)VALUES(168,4,272); 965INSERT INTO rule(ruleid,lhs,txt)VALUES(169,271,'upsert ::= ON CONFLICT DO UPDATE SET setlist where_opt returning'); 966INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,0,115); 967INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,1,37); 968INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,2,61); 969INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,3,129); 970INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,4,130); 971INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,5,268); 972INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,6,246); 973INSERT INTO rulerhs(ruleid,pos,sym)VALUES(169,7,272); 974INSERT INTO rule(ruleid,lhs,txt)VALUES(170,272,'returning ::= RETURNING selcollist'); 975INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,0,150); 976INSERT INTO rulerhs(ruleid,pos,sym)VALUES(170,1,244); 977INSERT INTO rule(ruleid,lhs,txt)VALUES(171,269,'insert_cmd ::= INSERT orconf'); 978INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,0,127); 979INSERT INTO rulerhs(ruleid,pos,sym)VALUES(171,1,234); 980INSERT INTO rule(ruleid,lhs,txt)VALUES(172,269,'insert_cmd ::= REPLACE'); 981INSERT INTO rulerhs(ruleid,pos,sym)VALUES(172,0,73); 982INSERT INTO rule(ruleid,lhs,txt)VALUES(173,270,'idlist_opt ::='); 983INSERT INTO rule(ruleid,lhs,txt)VALUES(174,270,'idlist_opt ::= LP idlist RP'); 984INSERT INTO rulerhs(ruleid,pos,sym)VALUES(174,0,22); 985INSERT INTO rulerhs(ruleid,pos,sym)VALUES(174,1,263); 986INSERT INTO rulerhs(ruleid,pos,sym)VALUES(174,2,23); 987INSERT INTO rule(ruleid,lhs,txt)VALUES(175,263,'idlist ::= idlist COMMA nm'); 988INSERT INTO rulerhs(ruleid,pos,sym)VALUES(175,0,263); 989INSERT INTO rulerhs(ruleid,pos,sym)VALUES(175,1,25); 990INSERT INTO rulerhs(ruleid,pos,sym)VALUES(175,2,193); 991INSERT INTO rule(ruleid,lhs,txt)VALUES(176,263,'idlist ::= nm'); 992INSERT INTO rulerhs(ruleid,pos,sym)VALUES(176,0,193); 993INSERT INTO rule(ruleid,lhs,txt)VALUES(177,217,'expr ::= LP expr RP'); 994INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,0,22); 995INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,1,217); 996INSERT INTO rulerhs(ruleid,pos,sym)VALUES(177,2,23); 997INSERT INTO rule(ruleid,lhs,txt)VALUES(178,217,'expr ::= ID|INDEXED'); 998INSERT INTO rulerhs(ruleid,pos,sym)VALUES(178,0,59); 999INSERT INTO rulerhs(ruleid,pos,sym)VALUES(178,0,116); 1000INSERT INTO rule(ruleid,lhs,txt)VALUES(179,217,'expr ::= JOIN_KW'); 1001INSERT INTO rulerhs(ruleid,pos,sym)VALUES(179,0,118); 1002INSERT INTO rule(ruleid,lhs,txt)VALUES(180,217,'expr ::= nm DOT nm'); 1003INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,0,193); 1004INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,1,141); 1005INSERT INTO rulerhs(ruleid,pos,sym)VALUES(180,2,193); 1006INSERT INTO rule(ruleid,lhs,txt)VALUES(181,217,'expr ::= nm DOT nm DOT nm'); 1007INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,0,193); 1008INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,1,141); 1009INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,2,193); 1010INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,3,141); 1011INSERT INTO rulerhs(ruleid,pos,sym)VALUES(181,4,193); 1012INSERT INTO rule(ruleid,lhs,txt)VALUES(182,216,'term ::= NULL|FLOAT|BLOB'); 1013INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,0,121); 1014INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,0,153); 1015INSERT INTO rulerhs(ruleid,pos,sym)VALUES(182,0,154); 1016INSERT INTO rule(ruleid,lhs,txt)VALUES(183,216,'term ::= STRING'); 1017INSERT INTO rulerhs(ruleid,pos,sym)VALUES(183,0,117); 1018INSERT INTO rule(ruleid,lhs,txt)VALUES(184,216,'term ::= INTEGER'); 1019INSERT INTO rulerhs(ruleid,pos,sym)VALUES(184,0,155); 1020INSERT INTO rule(ruleid,lhs,txt)VALUES(185,217,'expr ::= VARIABLE'); 1021INSERT INTO rulerhs(ruleid,pos,sym)VALUES(185,0,156); 1022INSERT INTO rule(ruleid,lhs,txt)VALUES(186,217,'expr ::= expr COLLATE ID|STRING'); 1023INSERT INTO rulerhs(ruleid,pos,sym)VALUES(186,0,217); 1024INSERT INTO rulerhs(ruleid,pos,sym)VALUES(186,1,113); 1025INSERT INTO rulerhs(ruleid,pos,sym)VALUES(186,2,59); 1026INSERT INTO rulerhs(ruleid,pos,sym)VALUES(186,2,117); 1027INSERT INTO rule(ruleid,lhs,txt)VALUES(187,217,'expr ::= CAST LP expr AS typetoken RP'); 1028INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,0,36); 1029INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,1,22); 1030INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,2,217); 1031INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,3,24); 1032INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,4,208); 1033INSERT INTO rulerhs(ruleid,pos,sym)VALUES(187,5,23); 1034INSERT INTO rule(ruleid,lhs,txt)VALUES(188,217,'expr ::= ID|INDEXED LP distinct exprlist RP'); 1035INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,0,59); 1036INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,0,116); 1037INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,1,22); 1038INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,2,243); 1039INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,3,261); 1040INSERT INTO rulerhs(ruleid,pos,sym)VALUES(188,4,23); 1041INSERT INTO rule(ruleid,lhs,txt)VALUES(189,217,'expr ::= ID|INDEXED LP STAR RP'); 1042INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,0,59); 1043INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,0,116); 1044INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,1,22); 1045INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,2,108); 1046INSERT INTO rulerhs(ruleid,pos,sym)VALUES(189,3,23); 1047INSERT INTO rule(ruleid,lhs,txt)VALUES(190,217,'expr ::= ID|INDEXED LP distinct exprlist RP filter_over'); 1048INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,0,59); 1049INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,0,116); 1050INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,1,22); 1051INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,2,243); 1052INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,3,261); 1053INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,4,23); 1054INSERT INTO rulerhs(ruleid,pos,sym)VALUES(190,5,273); 1055INSERT INTO rule(ruleid,lhs,txt)VALUES(191,217,'expr ::= ID|INDEXED LP STAR RP filter_over'); 1056INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,0,59); 1057INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,0,116); 1058INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,1,22); 1059INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,2,108); 1060INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,3,23); 1061INSERT INTO rulerhs(ruleid,pos,sym)VALUES(191,4,273); 1062INSERT INTO rule(ruleid,lhs,txt)VALUES(192,216,'term ::= CTIME_KW'); 1063INSERT INTO rulerhs(ruleid,pos,sym)VALUES(192,0,100); 1064INSERT INTO rule(ruleid,lhs,txt)VALUES(193,217,'expr ::= LP nexprlist COMMA expr RP'); 1065INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,0,22); 1066INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,1,253); 1067INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,2,25); 1068INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,3,217); 1069INSERT INTO rulerhs(ruleid,pos,sym)VALUES(193,4,23); 1070INSERT INTO rule(ruleid,lhs,txt)VALUES(194,217,'expr ::= expr AND expr'); 1071INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,0,217); 1072INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,1,44); 1073INSERT INTO rulerhs(ruleid,pos,sym)VALUES(194,2,217); 1074INSERT INTO rule(ruleid,lhs,txt)VALUES(195,217,'expr ::= expr OR expr'); 1075INSERT INTO rulerhs(ruleid,pos,sym)VALUES(195,0,217); 1076INSERT INTO rulerhs(ruleid,pos,sym)VALUES(195,1,43); 1077INSERT INTO rulerhs(ruleid,pos,sym)VALUES(195,2,217); 1078INSERT INTO rule(ruleid,lhs,txt)VALUES(196,217,'expr ::= expr LT|GT|GE|LE expr'); 1079INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,0,217); 1080INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,1,56); 1081INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,1,54); 1082INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,1,57); 1083INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,1,55); 1084INSERT INTO rulerhs(ruleid,pos,sym)VALUES(196,2,217); 1085INSERT INTO rule(ruleid,lhs,txt)VALUES(197,217,'expr ::= expr EQ|NE expr'); 1086INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,0,217); 1087INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,1,53); 1088INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,1,52); 1089INSERT INTO rulerhs(ruleid,pos,sym)VALUES(197,2,217); 1090INSERT INTO rule(ruleid,lhs,txt)VALUES(198,217,'expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr'); 1091INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,0,217); 1092INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,1,102); 1093INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,1,103); 1094INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,1,104); 1095INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,1,105); 1096INSERT INTO rulerhs(ruleid,pos,sym)VALUES(198,2,217); 1097INSERT INTO rule(ruleid,lhs,txt)VALUES(199,217,'expr ::= expr PLUS|MINUS expr'); 1098INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,0,217); 1099INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,106); 1100INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,1,107); 1101INSERT INTO rulerhs(ruleid,pos,sym)VALUES(199,2,217); 1102INSERT INTO rule(ruleid,lhs,txt)VALUES(200,217,'expr ::= expr STAR|SLASH|REM expr'); 1103INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,0,217); 1104INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,1,108); 1105INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,1,109); 1106INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,1,110); 1107INSERT INTO rulerhs(ruleid,pos,sym)VALUES(200,2,217); 1108INSERT INTO rule(ruleid,lhs,txt)VALUES(201,217,'expr ::= expr CONCAT expr'); 1109INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,0,217); 1110INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,1,111); 1111INSERT INTO rulerhs(ruleid,pos,sym)VALUES(201,2,217); 1112INSERT INTO rule(ruleid,lhs,txt)VALUES(202,274,'likeop ::= NOT LIKE_KW|MATCH'); 1113INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,0,19); 1114INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,1,47); 1115INSERT INTO rulerhs(ruleid,pos,sym)VALUES(202,1,46); 1116INSERT INTO rule(ruleid,lhs,txt)VALUES(203,217,'expr ::= expr likeop expr'); 1117INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,0,217); 1118INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,1,274); 1119INSERT INTO rulerhs(ruleid,pos,sym)VALUES(203,2,217); 1120INSERT INTO rule(ruleid,lhs,txt)VALUES(204,217,'expr ::= expr likeop expr ESCAPE expr'); 1121INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,0,217); 1122INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,1,274); 1123INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,2,217); 1124INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,3,58); 1125INSERT INTO rulerhs(ruleid,pos,sym)VALUES(204,4,217); 1126INSERT INTO rule(ruleid,lhs,txt)VALUES(205,217,'expr ::= expr ISNULL|NOTNULL'); 1127INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,0,217); 1128INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,1,50); 1129INSERT INTO rulerhs(ruleid,pos,sym)VALUES(205,1,51); 1130INSERT INTO rule(ruleid,lhs,txt)VALUES(206,217,'expr ::= expr NOT NULL'); 1131INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,0,217); 1132INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,1,19); 1133INSERT INTO rulerhs(ruleid,pos,sym)VALUES(206,2,121); 1134INSERT INTO rule(ruleid,lhs,txt)VALUES(207,217,'expr ::= expr IS expr'); 1135INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,0,217); 1136INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,1,45); 1137INSERT INTO rulerhs(ruleid,pos,sym)VALUES(207,2,217); 1138INSERT INTO rule(ruleid,lhs,txt)VALUES(208,217,'expr ::= expr IS NOT expr'); 1139INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,0,217); 1140INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,1,45); 1141INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,2,19); 1142INSERT INTO rulerhs(ruleid,pos,sym)VALUES(208,3,217); 1143INSERT INTO rule(ruleid,lhs,txt)VALUES(209,217,'expr ::= expr IS NOT DISTINCT FROM expr'); 1144INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,0,217); 1145INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,1,45); 1146INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,2,19); 1147INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,3,140); 1148INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,4,142); 1149INSERT INTO rulerhs(ruleid,pos,sym)VALUES(209,5,217); 1150INSERT INTO rule(ruleid,lhs,txt)VALUES(210,217,'expr ::= expr IS DISTINCT FROM expr'); 1151INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,0,217); 1152INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,1,45); 1153INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,2,140); 1154INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,3,142); 1155INSERT INTO rulerhs(ruleid,pos,sym)VALUES(210,4,217); 1156INSERT INTO rule(ruleid,lhs,txt)VALUES(211,217,'expr ::= NOT expr'); 1157INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,0,19); 1158INSERT INTO rulerhs(ruleid,pos,sym)VALUES(211,1,217); 1159INSERT INTO rule(ruleid,lhs,txt)VALUES(212,217,'expr ::= BITNOT expr'); 1160INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,0,114); 1161INSERT INTO rulerhs(ruleid,pos,sym)VALUES(212,1,217); 1162INSERT INTO rule(ruleid,lhs,txt)VALUES(213,217,'expr ::= PLUS|MINUS expr'); 1163INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,0,106); 1164INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,0,107); 1165INSERT INTO rulerhs(ruleid,pos,sym)VALUES(213,1,217); 1166INSERT INTO rule(ruleid,lhs,txt)VALUES(214,217,'expr ::= expr PTR expr'); 1167INSERT INTO rulerhs(ruleid,pos,sym)VALUES(214,0,217); 1168INSERT INTO rulerhs(ruleid,pos,sym)VALUES(214,1,112); 1169INSERT INTO rulerhs(ruleid,pos,sym)VALUES(214,2,217); 1170INSERT INTO rule(ruleid,lhs,txt)VALUES(215,275,'between_op ::= BETWEEN'); 1171INSERT INTO rulerhs(ruleid,pos,sym)VALUES(215,0,48); 1172INSERT INTO rule(ruleid,lhs,txt)VALUES(216,275,'between_op ::= NOT BETWEEN'); 1173INSERT INTO rulerhs(ruleid,pos,sym)VALUES(216,0,19); 1174INSERT INTO rulerhs(ruleid,pos,sym)VALUES(216,1,48); 1175INSERT INTO rule(ruleid,lhs,txt)VALUES(217,217,'expr ::= expr between_op expr AND expr'); 1176INSERT INTO rulerhs(ruleid,pos,sym)VALUES(217,0,217); 1177INSERT INTO rulerhs(ruleid,pos,sym)VALUES(217,1,275); 1178INSERT INTO rulerhs(ruleid,pos,sym)VALUES(217,2,217); 1179INSERT INTO rulerhs(ruleid,pos,sym)VALUES(217,3,44); 1180INSERT INTO rulerhs(ruleid,pos,sym)VALUES(217,4,217); 1181INSERT INTO rule(ruleid,lhs,txt)VALUES(218,276,'in_op ::= IN'); 1182INSERT INTO rulerhs(ruleid,pos,sym)VALUES(218,0,49); 1183INSERT INTO rule(ruleid,lhs,txt)VALUES(219,276,'in_op ::= NOT IN'); 1184INSERT INTO rulerhs(ruleid,pos,sym)VALUES(219,0,19); 1185INSERT INTO rulerhs(ruleid,pos,sym)VALUES(219,1,49); 1186INSERT INTO rule(ruleid,lhs,txt)VALUES(220,217,'expr ::= expr in_op LP exprlist RP'); 1187INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,0,217); 1188INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,1,276); 1189INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,2,22); 1190INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,3,261); 1191INSERT INTO rulerhs(ruleid,pos,sym)VALUES(220,4,23); 1192INSERT INTO rule(ruleid,lhs,txt)VALUES(221,217,'expr ::= LP select RP'); 1193INSERT INTO rulerhs(ruleid,pos,sym)VALUES(221,0,22); 1194INSERT INTO rulerhs(ruleid,pos,sym)VALUES(221,1,204); 1195INSERT INTO rulerhs(ruleid,pos,sym)VALUES(221,2,23); 1196INSERT INTO rule(ruleid,lhs,txt)VALUES(222,217,'expr ::= expr in_op LP select RP'); 1197INSERT INTO rulerhs(ruleid,pos,sym)VALUES(222,0,217); 1198INSERT INTO rulerhs(ruleid,pos,sym)VALUES(222,1,276); 1199INSERT INTO rulerhs(ruleid,pos,sym)VALUES(222,2,22); 1200INSERT INTO rulerhs(ruleid,pos,sym)VALUES(222,3,204); 1201INSERT INTO rulerhs(ruleid,pos,sym)VALUES(222,4,23); 1202INSERT INTO rule(ruleid,lhs,txt)VALUES(223,217,'expr ::= expr in_op nm dbnm paren_exprlist'); 1203INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,0,217); 1204INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,1,276); 1205INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,2,193); 1206INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,3,200); 1207INSERT INTO rulerhs(ruleid,pos,sym)VALUES(223,4,277); 1208INSERT INTO rule(ruleid,lhs,txt)VALUES(224,217,'expr ::= EXISTS LP select RP'); 1209INSERT INTO rulerhs(ruleid,pos,sym)VALUES(224,0,20); 1210INSERT INTO rulerhs(ruleid,pos,sym)VALUES(224,1,22); 1211INSERT INTO rulerhs(ruleid,pos,sym)VALUES(224,2,204); 1212INSERT INTO rulerhs(ruleid,pos,sym)VALUES(224,3,23); 1213INSERT INTO rule(ruleid,lhs,txt)VALUES(225,217,'expr ::= CASE case_operand case_exprlist case_else END'); 1214INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,0,157); 1215INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,1,278); 1216INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,2,279); 1217INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,3,280); 1218INSERT INTO rulerhs(ruleid,pos,sym)VALUES(225,4,11); 1219INSERT INTO rule(ruleid,lhs,txt)VALUES(226,279,'case_exprlist ::= case_exprlist WHEN expr THEN expr'); 1220INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,0,279); 1221INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,1,158); 1222INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,2,217); 1223INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,3,159); 1224INSERT INTO rulerhs(ruleid,pos,sym)VALUES(226,4,217); 1225INSERT INTO rule(ruleid,lhs,txt)VALUES(227,279,'case_exprlist ::= WHEN expr THEN expr'); 1226INSERT INTO rulerhs(ruleid,pos,sym)VALUES(227,0,158); 1227INSERT INTO rulerhs(ruleid,pos,sym)VALUES(227,1,217); 1228INSERT INTO rulerhs(ruleid,pos,sym)VALUES(227,2,159); 1229INSERT INTO rulerhs(ruleid,pos,sym)VALUES(227,3,217); 1230INSERT INTO rule(ruleid,lhs,txt)VALUES(228,280,'case_else ::= ELSE expr'); 1231INSERT INTO rulerhs(ruleid,pos,sym)VALUES(228,0,160); 1232INSERT INTO rulerhs(ruleid,pos,sym)VALUES(228,1,217); 1233INSERT INTO rule(ruleid,lhs,txt)VALUES(229,280,'case_else ::='); 1234INSERT INTO rule(ruleid,lhs,txt)VALUES(230,278,'case_operand ::= expr'); 1235INSERT INTO rulerhs(ruleid,pos,sym)VALUES(230,0,217); 1236INSERT INTO rule(ruleid,lhs,txt)VALUES(231,278,'case_operand ::='); 1237INSERT INTO rule(ruleid,lhs,txt)VALUES(232,261,'exprlist ::='); 1238INSERT INTO rule(ruleid,lhs,txt)VALUES(233,253,'nexprlist ::= nexprlist COMMA expr'); 1239INSERT INTO rulerhs(ruleid,pos,sym)VALUES(233,0,253); 1240INSERT INTO rulerhs(ruleid,pos,sym)VALUES(233,1,25); 1241INSERT INTO rulerhs(ruleid,pos,sym)VALUES(233,2,217); 1242INSERT INTO rule(ruleid,lhs,txt)VALUES(234,253,'nexprlist ::= expr'); 1243INSERT INTO rulerhs(ruleid,pos,sym)VALUES(234,0,217); 1244INSERT INTO rule(ruleid,lhs,txt)VALUES(235,277,'paren_exprlist ::='); 1245INSERT INTO rule(ruleid,lhs,txt)VALUES(236,277,'paren_exprlist ::= LP exprlist RP'); 1246INSERT INTO rulerhs(ruleid,pos,sym)VALUES(236,0,22); 1247INSERT INTO rulerhs(ruleid,pos,sym)VALUES(236,1,261); 1248INSERT INTO rulerhs(ruleid,pos,sym)VALUES(236,2,23); 1249INSERT INTO rule(ruleid,lhs,txt)VALUES(237,190,'cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP sortlist RP where_opt'); 1250INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,0,197); 1251INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,1,281); 1252INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,2,161); 1253INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,3,199); 1254INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,4,193); 1255INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,5,200); 1256INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,6,115); 1257INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,7,193); 1258INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,8,22); 1259INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,9,231); 1260INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,10,23); 1261INSERT INTO rulerhs(ruleid,pos,sym)VALUES(237,11,246); 1262INSERT INTO rule(ruleid,lhs,txt)VALUES(238,281,'uniqueflag ::= UNIQUE'); 1263INSERT INTO rulerhs(ruleid,pos,sym)VALUES(238,0,123); 1264INSERT INTO rule(ruleid,lhs,txt)VALUES(239,281,'uniqueflag ::='); 1265INSERT INTO rule(ruleid,lhs,txt)VALUES(240,221,'eidlist_opt ::='); 1266INSERT INTO rule(ruleid,lhs,txt)VALUES(241,221,'eidlist_opt ::= LP eidlist RP'); 1267INSERT INTO rulerhs(ruleid,pos,sym)VALUES(241,0,22); 1268INSERT INTO rulerhs(ruleid,pos,sym)VALUES(241,1,232); 1269INSERT INTO rulerhs(ruleid,pos,sym)VALUES(241,2,23); 1270INSERT INTO rule(ruleid,lhs,txt)VALUES(242,232,'eidlist ::= eidlist COMMA nm collate sortorder'); 1271INSERT INTO rulerhs(ruleid,pos,sym)VALUES(242,0,232); 1272INSERT INTO rulerhs(ruleid,pos,sym)VALUES(242,1,25); 1273INSERT INTO rulerhs(ruleid,pos,sym)VALUES(242,2,193); 1274INSERT INTO rulerhs(ruleid,pos,sym)VALUES(242,3,282); 1275INSERT INTO rulerhs(ruleid,pos,sym)VALUES(242,4,219); 1276INSERT INTO rule(ruleid,lhs,txt)VALUES(243,232,'eidlist ::= nm collate sortorder'); 1277INSERT INTO rulerhs(ruleid,pos,sym)VALUES(243,0,193); 1278INSERT INTO rulerhs(ruleid,pos,sym)VALUES(243,1,282); 1279INSERT INTO rulerhs(ruleid,pos,sym)VALUES(243,2,219); 1280INSERT INTO rule(ruleid,lhs,txt)VALUES(244,282,'collate ::='); 1281INSERT INTO rule(ruleid,lhs,txt)VALUES(245,282,'collate ::= COLLATE ID|STRING'); 1282INSERT INTO rulerhs(ruleid,pos,sym)VALUES(245,0,113); 1283INSERT INTO rulerhs(ruleid,pos,sym)VALUES(245,1,59); 1284INSERT INTO rulerhs(ruleid,pos,sym)VALUES(245,1,117); 1285INSERT INTO rule(ruleid,lhs,txt)VALUES(246,190,'cmd ::= DROP INDEX ifexists fullname'); 1286INSERT INTO rulerhs(ruleid,pos,sym)VALUES(246,0,133); 1287INSERT INTO rulerhs(ruleid,pos,sym)VALUES(246,1,161); 1288INSERT INTO rulerhs(ruleid,pos,sym)VALUES(246,2,237); 1289INSERT INTO rulerhs(ruleid,pos,sym)VALUES(246,3,238); 1290INSERT INTO rule(ruleid,lhs,txt)VALUES(247,190,'cmd ::= VACUUM vinto'); 1291INSERT INTO rulerhs(ruleid,pos,sym)VALUES(247,0,78); 1292INSERT INTO rulerhs(ruleid,pos,sym)VALUES(247,1,283); 1293INSERT INTO rule(ruleid,lhs,txt)VALUES(248,190,'cmd ::= VACUUM nm vinto'); 1294INSERT INTO rulerhs(ruleid,pos,sym)VALUES(248,0,78); 1295INSERT INTO rulerhs(ruleid,pos,sym)VALUES(248,1,193); 1296INSERT INTO rulerhs(ruleid,pos,sym)VALUES(248,2,283); 1297INSERT INTO rule(ruleid,lhs,txt)VALUES(249,283,'vinto ::= INTO expr'); 1298INSERT INTO rulerhs(ruleid,pos,sym)VALUES(249,0,151); 1299INSERT INTO rulerhs(ruleid,pos,sym)VALUES(249,1,217); 1300INSERT INTO rule(ruleid,lhs,txt)VALUES(250,283,'vinto ::='); 1301INSERT INTO rule(ruleid,lhs,txt)VALUES(251,190,'cmd ::= PRAGMA nm dbnm'); 1302INSERT INTO rulerhs(ruleid,pos,sym)VALUES(251,0,70); 1303INSERT INTO rulerhs(ruleid,pos,sym)VALUES(251,1,193); 1304INSERT INTO rulerhs(ruleid,pos,sym)VALUES(251,2,200); 1305INSERT INTO rule(ruleid,lhs,txt)VALUES(252,190,'cmd ::= PRAGMA nm dbnm EQ nmnum'); 1306INSERT INTO rulerhs(ruleid,pos,sym)VALUES(252,0,70); 1307INSERT INTO rulerhs(ruleid,pos,sym)VALUES(252,1,193); 1308INSERT INTO rulerhs(ruleid,pos,sym)VALUES(252,2,200); 1309INSERT INTO rulerhs(ruleid,pos,sym)VALUES(252,3,53); 1310INSERT INTO rulerhs(ruleid,pos,sym)VALUES(252,4,284); 1311INSERT INTO rule(ruleid,lhs,txt)VALUES(253,190,'cmd ::= PRAGMA nm dbnm LP nmnum RP'); 1312INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,0,70); 1313INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,1,193); 1314INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,2,200); 1315INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,3,22); 1316INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,4,284); 1317INSERT INTO rulerhs(ruleid,pos,sym)VALUES(253,5,23); 1318INSERT INTO rule(ruleid,lhs,txt)VALUES(254,190,'cmd ::= PRAGMA nm dbnm EQ minus_num'); 1319INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,0,70); 1320INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,1,193); 1321INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,2,200); 1322INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,3,53); 1323INSERT INTO rulerhs(ruleid,pos,sym)VALUES(254,4,212); 1324INSERT INTO rule(ruleid,lhs,txt)VALUES(255,190,'cmd ::= PRAGMA nm dbnm LP minus_num RP'); 1325INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,0,70); 1326INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,1,193); 1327INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,2,200); 1328INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,3,22); 1329INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,4,212); 1330INSERT INTO rulerhs(ruleid,pos,sym)VALUES(255,5,23); 1331INSERT INTO rule(ruleid,lhs,txt)VALUES(256,211,'plus_num ::= PLUS INTEGER|FLOAT'); 1332INSERT INTO rulerhs(ruleid,pos,sym)VALUES(256,0,106); 1333INSERT INTO rulerhs(ruleid,pos,sym)VALUES(256,1,155); 1334INSERT INTO rulerhs(ruleid,pos,sym)VALUES(256,1,153); 1335INSERT INTO rule(ruleid,lhs,txt)VALUES(257,212,'minus_num ::= MINUS INTEGER|FLOAT'); 1336INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,0,107); 1337INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,1,155); 1338INSERT INTO rulerhs(ruleid,pos,sym)VALUES(257,1,153); 1339INSERT INTO rule(ruleid,lhs,txt)VALUES(258,190,'cmd ::= createkw trigger_decl BEGIN trigger_cmd_list END'); 1340INSERT INTO rulerhs(ruleid,pos,sym)VALUES(258,0,197); 1341INSERT INTO rulerhs(ruleid,pos,sym)VALUES(258,1,285); 1342INSERT INTO rulerhs(ruleid,pos,sym)VALUES(258,2,5); 1343INSERT INTO rulerhs(ruleid,pos,sym)VALUES(258,3,286); 1344INSERT INTO rulerhs(ruleid,pos,sym)VALUES(258,4,11); 1345INSERT INTO rule(ruleid,lhs,txt)VALUES(259,285,'trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause'); 1346INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,0,198); 1347INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,1,77); 1348INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,2,199); 1349INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,3,193); 1350INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,4,200); 1351INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,5,287); 1352INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,6,288); 1353INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,7,115); 1354INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,8,238); 1355INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,9,289); 1356INSERT INTO rulerhs(ruleid,pos,sym)VALUES(259,10,290); 1357INSERT INTO rule(ruleid,lhs,txt)VALUES(260,287,'trigger_time ::= BEFORE|AFTER'); 1358INSERT INTO rulerhs(ruleid,pos,sym)VALUES(260,0,33); 1359INSERT INTO rulerhs(ruleid,pos,sym)VALUES(260,0,29); 1360INSERT INTO rule(ruleid,lhs,txt)VALUES(261,287,'trigger_time ::= INSTEAD OF'); 1361INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,0,65); 1362INSERT INTO rulerhs(ruleid,pos,sym)VALUES(261,1,68); 1363INSERT INTO rule(ruleid,lhs,txt)VALUES(262,287,'trigger_time ::='); 1364INSERT INTO rule(ruleid,lhs,txt)VALUES(263,288,'trigger_event ::= DELETE|INSERT'); 1365INSERT INTO rulerhs(ruleid,pos,sym)VALUES(263,0,128); 1366INSERT INTO rulerhs(ruleid,pos,sym)VALUES(263,0,127); 1367INSERT INTO rule(ruleid,lhs,txt)VALUES(264,288,'trigger_event ::= UPDATE'); 1368INSERT INTO rulerhs(ruleid,pos,sym)VALUES(264,0,129); 1369INSERT INTO rule(ruleid,lhs,txt)VALUES(265,288,'trigger_event ::= UPDATE OF idlist'); 1370INSERT INTO rulerhs(ruleid,pos,sym)VALUES(265,0,129); 1371INSERT INTO rulerhs(ruleid,pos,sym)VALUES(265,1,68); 1372INSERT INTO rulerhs(ruleid,pos,sym)VALUES(265,2,263); 1373INSERT INTO rule(ruleid,lhs,txt)VALUES(266,290,'when_clause ::='); 1374INSERT INTO rule(ruleid,lhs,txt)VALUES(267,290,'when_clause ::= WHEN expr'); 1375INSERT INTO rulerhs(ruleid,pos,sym)VALUES(267,0,158); 1376INSERT INTO rulerhs(ruleid,pos,sym)VALUES(267,1,217); 1377INSERT INTO rule(ruleid,lhs,txt)VALUES(268,286,'trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI'); 1378INSERT INTO rulerhs(ruleid,pos,sym)VALUES(268,0,286); 1379INSERT INTO rulerhs(ruleid,pos,sym)VALUES(268,1,291); 1380INSERT INTO rulerhs(ruleid,pos,sym)VALUES(268,2,1); 1381INSERT INTO rule(ruleid,lhs,txt)VALUES(269,286,'trigger_cmd_list ::= trigger_cmd SEMI'); 1382INSERT INTO rulerhs(ruleid,pos,sym)VALUES(269,0,291); 1383INSERT INTO rulerhs(ruleid,pos,sym)VALUES(269,1,1); 1384INSERT INTO rule(ruleid,lhs,txt)VALUES(270,292,'trnm ::= nm DOT nm'); 1385INSERT INTO rulerhs(ruleid,pos,sym)VALUES(270,0,193); 1386INSERT INTO rulerhs(ruleid,pos,sym)VALUES(270,1,141); 1387INSERT INTO rulerhs(ruleid,pos,sym)VALUES(270,2,193); 1388INSERT INTO rule(ruleid,lhs,txt)VALUES(271,293,'tridxby ::= INDEXED BY nm'); 1389INSERT INTO rulerhs(ruleid,pos,sym)VALUES(271,0,116); 1390INSERT INTO rulerhs(ruleid,pos,sym)VALUES(271,1,34); 1391INSERT INTO rulerhs(ruleid,pos,sym)VALUES(271,2,193); 1392INSERT INTO rule(ruleid,lhs,txt)VALUES(272,293,'tridxby ::= NOT INDEXED'); 1393INSERT INTO rulerhs(ruleid,pos,sym)VALUES(272,0,19); 1394INSERT INTO rulerhs(ruleid,pos,sym)VALUES(272,1,116); 1395INSERT INTO rule(ruleid,lhs,txt)VALUES(273,291,'trigger_cmd ::= UPDATE orconf trnm tridxby SET setlist from where_opt scanpt'); 1396INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,0,129); 1397INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,1,234); 1398INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,2,292); 1399INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,3,293); 1400INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,4,130); 1401INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,5,268); 1402INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,6,245); 1403INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,7,246); 1404INSERT INTO rulerhs(ruleid,pos,sym)VALUES(273,8,213); 1405INSERT INTO rule(ruleid,lhs,txt)VALUES(274,291,'trigger_cmd ::= scanpt insert_cmd INTO trnm idlist_opt select upsert scanpt'); 1406INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,0,213); 1407INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,1,269); 1408INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,2,151); 1409INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,3,292); 1410INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,4,270); 1411INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,5,204); 1412INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,6,271); 1413INSERT INTO rulerhs(ruleid,pos,sym)VALUES(274,7,213); 1414INSERT INTO rule(ruleid,lhs,txt)VALUES(275,291,'trigger_cmd ::= DELETE FROM trnm tridxby where_opt scanpt'); 1415INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,0,128); 1416INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,1,142); 1417INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,2,292); 1418INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,3,293); 1419INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,4,246); 1420INSERT INTO rulerhs(ruleid,pos,sym)VALUES(275,5,213); 1421INSERT INTO rule(ruleid,lhs,txt)VALUES(276,291,'trigger_cmd ::= scanpt select scanpt'); 1422INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,0,213); 1423INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,1,204); 1424INSERT INTO rulerhs(ruleid,pos,sym)VALUES(276,2,213); 1425INSERT INTO rule(ruleid,lhs,txt)VALUES(277,217,'expr ::= RAISE LP IGNORE RP'); 1426INSERT INTO rulerhs(ruleid,pos,sym)VALUES(277,0,71); 1427INSERT INTO rulerhs(ruleid,pos,sym)VALUES(277,1,22); 1428INSERT INTO rulerhs(ruleid,pos,sym)VALUES(277,2,63); 1429INSERT INTO rulerhs(ruleid,pos,sym)VALUES(277,3,23); 1430INSERT INTO rule(ruleid,lhs,txt)VALUES(278,217,'expr ::= RAISE LP raisetype COMMA nm RP'); 1431INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,0,71); 1432INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,1,22); 1433INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,2,236); 1434INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,3,25); 1435INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,4,193); 1436INSERT INTO rulerhs(ruleid,pos,sym)VALUES(278,5,23); 1437INSERT INTO rule(ruleid,lhs,txt)VALUES(279,236,'raisetype ::= ROLLBACK'); 1438INSERT INTO rulerhs(ruleid,pos,sym)VALUES(279,0,12); 1439INSERT INTO rule(ruleid,lhs,txt)VALUES(280,236,'raisetype ::= ABORT'); 1440INSERT INTO rulerhs(ruleid,pos,sym)VALUES(280,0,27); 1441INSERT INTO rule(ruleid,lhs,txt)VALUES(281,236,'raisetype ::= FAIL'); 1442INSERT INTO rulerhs(ruleid,pos,sym)VALUES(281,0,42); 1443INSERT INTO rule(ruleid,lhs,txt)VALUES(282,190,'cmd ::= DROP TRIGGER ifexists fullname'); 1444INSERT INTO rulerhs(ruleid,pos,sym)VALUES(282,0,133); 1445INSERT INTO rulerhs(ruleid,pos,sym)VALUES(282,1,77); 1446INSERT INTO rulerhs(ruleid,pos,sym)VALUES(282,2,237); 1447INSERT INTO rulerhs(ruleid,pos,sym)VALUES(282,3,238); 1448INSERT INTO rule(ruleid,lhs,txt)VALUES(283,190,'cmd ::= ATTACH database_kw_opt expr AS expr key_opt'); 1449INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,0,32); 1450INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,1,294); 1451INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,2,217); 1452INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,3,24); 1453INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,4,217); 1454INSERT INTO rulerhs(ruleid,pos,sym)VALUES(283,5,295); 1455INSERT INTO rule(ruleid,lhs,txt)VALUES(284,190,'cmd ::= DETACH database_kw_opt expr'); 1456INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,0,40); 1457INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,1,294); 1458INSERT INTO rulerhs(ruleid,pos,sym)VALUES(284,2,217); 1459INSERT INTO rule(ruleid,lhs,txt)VALUES(285,295,'key_opt ::='); 1460INSERT INTO rule(ruleid,lhs,txt)VALUES(286,295,'key_opt ::= KEY expr'); 1461INSERT INTO rulerhs(ruleid,pos,sym)VALUES(286,0,67); 1462INSERT INTO rulerhs(ruleid,pos,sym)VALUES(286,1,217); 1463INSERT INTO rule(ruleid,lhs,txt)VALUES(287,190,'cmd ::= REINDEX'); 1464INSERT INTO rulerhs(ruleid,pos,sym)VALUES(287,0,98); 1465INSERT INTO rule(ruleid,lhs,txt)VALUES(288,190,'cmd ::= REINDEX nm dbnm'); 1466INSERT INTO rulerhs(ruleid,pos,sym)VALUES(288,0,98); 1467INSERT INTO rulerhs(ruleid,pos,sym)VALUES(288,1,193); 1468INSERT INTO rulerhs(ruleid,pos,sym)VALUES(288,2,200); 1469INSERT INTO rule(ruleid,lhs,txt)VALUES(289,190,'cmd ::= ANALYZE'); 1470INSERT INTO rulerhs(ruleid,pos,sym)VALUES(289,0,30); 1471INSERT INTO rule(ruleid,lhs,txt)VALUES(290,190,'cmd ::= ANALYZE nm dbnm'); 1472INSERT INTO rulerhs(ruleid,pos,sym)VALUES(290,0,30); 1473INSERT INTO rulerhs(ruleid,pos,sym)VALUES(290,1,193); 1474INSERT INTO rulerhs(ruleid,pos,sym)VALUES(290,2,200); 1475INSERT INTO rule(ruleid,lhs,txt)VALUES(291,190,'cmd ::= ALTER TABLE fullname RENAME TO nm'); 1476INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,0,162); 1477INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,1,16); 1478INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,2,238); 1479INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,3,99); 1480INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,4,15); 1481INSERT INTO rulerhs(ruleid,pos,sym)VALUES(291,5,193); 1482INSERT INTO rule(ruleid,lhs,txt)VALUES(292,190,'cmd ::= ALTER TABLE add_column_fullname ADD kwcolumn_opt columnname carglist'); 1483INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,0,162); 1484INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,1,16); 1485INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,2,296); 1486INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,3,163); 1487INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,4,297); 1488INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,5,206); 1489INSERT INTO rulerhs(ruleid,pos,sym)VALUES(292,6,207); 1490INSERT INTO rule(ruleid,lhs,txt)VALUES(293,190,'cmd ::= ALTER TABLE fullname DROP kwcolumn_opt nm'); 1491INSERT INTO rulerhs(ruleid,pos,sym)VALUES(293,0,162); 1492INSERT INTO rulerhs(ruleid,pos,sym)VALUES(293,1,16); 1493INSERT INTO rulerhs(ruleid,pos,sym)VALUES(293,2,238); 1494INSERT INTO rulerhs(ruleid,pos,sym)VALUES(293,3,133); 1495INSERT INTO rulerhs(ruleid,pos,sym)VALUES(293,4,297); 1496INSERT INTO rulerhs(ruleid,pos,sym)VALUES(293,5,193); 1497INSERT INTO rule(ruleid,lhs,txt)VALUES(294,296,'add_column_fullname ::= fullname'); 1498INSERT INTO rulerhs(ruleid,pos,sym)VALUES(294,0,238); 1499INSERT INTO rule(ruleid,lhs,txt)VALUES(295,190,'cmd ::= ALTER TABLE fullname RENAME kwcolumn_opt nm TO nm'); 1500INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,0,162); 1501INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,1,16); 1502INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,2,238); 1503INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,3,99); 1504INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,4,297); 1505INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,5,193); 1506INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,6,15); 1507INSERT INTO rulerhs(ruleid,pos,sym)VALUES(295,7,193); 1508INSERT INTO rule(ruleid,lhs,txt)VALUES(296,190,'cmd ::= create_vtab'); 1509INSERT INTO rulerhs(ruleid,pos,sym)VALUES(296,0,298); 1510INSERT INTO rule(ruleid,lhs,txt)VALUES(297,190,'cmd ::= create_vtab LP vtabarglist RP'); 1511INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,0,298); 1512INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,1,22); 1513INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,2,299); 1514INSERT INTO rulerhs(ruleid,pos,sym)VALUES(297,3,23); 1515INSERT INTO rule(ruleid,lhs,txt)VALUES(298,298,'create_vtab ::= createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm'); 1516INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,0,197); 1517INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,1,80); 1518INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,2,16); 1519INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,3,199); 1520INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,4,193); 1521INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,5,200); 1522INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,6,144); 1523INSERT INTO rulerhs(ruleid,pos,sym)VALUES(298,7,193); 1524INSERT INTO rule(ruleid,lhs,txt)VALUES(299,300,'vtabarg ::='); 1525INSERT INTO rule(ruleid,lhs,txt)VALUES(300,301,'vtabargtoken ::= ANY'); 1526INSERT INTO rulerhs(ruleid,pos,sym)VALUES(300,0,101); 1527INSERT INTO rule(ruleid,lhs,txt)VALUES(301,301,'vtabargtoken ::= lp anylist RP'); 1528INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,0,302); 1529INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,1,303); 1530INSERT INTO rulerhs(ruleid,pos,sym)VALUES(301,2,23); 1531INSERT INTO rule(ruleid,lhs,txt)VALUES(302,302,'lp ::= LP'); 1532INSERT INTO rulerhs(ruleid,pos,sym)VALUES(302,0,22); 1533INSERT INTO rule(ruleid,lhs,txt)VALUES(303,266,'with ::= WITH wqlist'); 1534INSERT INTO rulerhs(ruleid,pos,sym)VALUES(303,0,81); 1535INSERT INTO rulerhs(ruleid,pos,sym)VALUES(303,1,241); 1536INSERT INTO rule(ruleid,lhs,txt)VALUES(304,266,'with ::= WITH RECURSIVE wqlist'); 1537INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,0,81); 1538INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,1,72); 1539INSERT INTO rulerhs(ruleid,pos,sym)VALUES(304,2,241); 1540INSERT INTO rule(ruleid,lhs,txt)VALUES(305,305,'wqas ::= AS'); 1541INSERT INTO rulerhs(ruleid,pos,sym)VALUES(305,0,24); 1542INSERT INTO rule(ruleid,lhs,txt)VALUES(306,305,'wqas ::= AS MATERIALIZED'); 1543INSERT INTO rulerhs(ruleid,pos,sym)VALUES(306,0,24); 1544INSERT INTO rulerhs(ruleid,pos,sym)VALUES(306,1,97); 1545INSERT INTO rule(ruleid,lhs,txt)VALUES(307,305,'wqas ::= AS NOT MATERIALIZED'); 1546INSERT INTO rulerhs(ruleid,pos,sym)VALUES(307,0,24); 1547INSERT INTO rulerhs(ruleid,pos,sym)VALUES(307,1,19); 1548INSERT INTO rulerhs(ruleid,pos,sym)VALUES(307,2,97); 1549INSERT INTO rule(ruleid,lhs,txt)VALUES(308,304,'wqitem ::= nm eidlist_opt wqas LP select RP'); 1550INSERT INTO rulerhs(ruleid,pos,sym)VALUES(308,0,193); 1551INSERT INTO rulerhs(ruleid,pos,sym)VALUES(308,1,221); 1552INSERT INTO rulerhs(ruleid,pos,sym)VALUES(308,2,305); 1553INSERT INTO rulerhs(ruleid,pos,sym)VALUES(308,3,22); 1554INSERT INTO rulerhs(ruleid,pos,sym)VALUES(308,4,204); 1555INSERT INTO rulerhs(ruleid,pos,sym)VALUES(308,5,23); 1556INSERT INTO rule(ruleid,lhs,txt)VALUES(309,241,'wqlist ::= wqitem'); 1557INSERT INTO rulerhs(ruleid,pos,sym)VALUES(309,0,304); 1558INSERT INTO rule(ruleid,lhs,txt)VALUES(310,241,'wqlist ::= wqlist COMMA wqitem'); 1559INSERT INTO rulerhs(ruleid,pos,sym)VALUES(310,0,241); 1560INSERT INTO rulerhs(ruleid,pos,sym)VALUES(310,1,25); 1561INSERT INTO rulerhs(ruleid,pos,sym)VALUES(310,2,304); 1562INSERT INTO rule(ruleid,lhs,txt)VALUES(311,306,'windowdefn_list ::= windowdefn'); 1563INSERT INTO rulerhs(ruleid,pos,sym)VALUES(311,0,307); 1564INSERT INTO rule(ruleid,lhs,txt)VALUES(312,306,'windowdefn_list ::= windowdefn_list COMMA windowdefn'); 1565INSERT INTO rulerhs(ruleid,pos,sym)VALUES(312,0,306); 1566INSERT INTO rulerhs(ruleid,pos,sym)VALUES(312,1,25); 1567INSERT INTO rulerhs(ruleid,pos,sym)VALUES(312,2,307); 1568INSERT INTO rule(ruleid,lhs,txt)VALUES(313,307,'windowdefn ::= nm AS LP window RP'); 1569INSERT INTO rulerhs(ruleid,pos,sym)VALUES(313,0,193); 1570INSERT INTO rulerhs(ruleid,pos,sym)VALUES(313,1,24); 1571INSERT INTO rulerhs(ruleid,pos,sym)VALUES(313,2,22); 1572INSERT INTO rulerhs(ruleid,pos,sym)VALUES(313,3,308); 1573INSERT INTO rulerhs(ruleid,pos,sym)VALUES(313,4,23); 1574INSERT INTO rule(ruleid,lhs,txt)VALUES(314,308,'window ::= PARTITION BY nexprlist orderby_opt frame_opt'); 1575INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,0,87); 1576INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,1,34); 1577INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,2,253); 1578INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,3,249); 1579INSERT INTO rulerhs(ruleid,pos,sym)VALUES(314,4,309); 1580INSERT INTO rule(ruleid,lhs,txt)VALUES(315,308,'window ::= nm PARTITION BY nexprlist orderby_opt frame_opt'); 1581INSERT INTO rulerhs(ruleid,pos,sym)VALUES(315,0,193); 1582INSERT INTO rulerhs(ruleid,pos,sym)VALUES(315,1,87); 1583INSERT INTO rulerhs(ruleid,pos,sym)VALUES(315,2,34); 1584INSERT INTO rulerhs(ruleid,pos,sym)VALUES(315,3,253); 1585INSERT INTO rulerhs(ruleid,pos,sym)VALUES(315,4,249); 1586INSERT INTO rulerhs(ruleid,pos,sym)VALUES(315,5,309); 1587INSERT INTO rule(ruleid,lhs,txt)VALUES(316,308,'window ::= ORDER BY sortlist frame_opt'); 1588INSERT INTO rulerhs(ruleid,pos,sym)VALUES(316,0,145); 1589INSERT INTO rulerhs(ruleid,pos,sym)VALUES(316,1,34); 1590INSERT INTO rulerhs(ruleid,pos,sym)VALUES(316,2,231); 1591INSERT INTO rulerhs(ruleid,pos,sym)VALUES(316,3,309); 1592INSERT INTO rule(ruleid,lhs,txt)VALUES(317,308,'window ::= nm ORDER BY sortlist frame_opt'); 1593INSERT INTO rulerhs(ruleid,pos,sym)VALUES(317,0,193); 1594INSERT INTO rulerhs(ruleid,pos,sym)VALUES(317,1,145); 1595INSERT INTO rulerhs(ruleid,pos,sym)VALUES(317,2,34); 1596INSERT INTO rulerhs(ruleid,pos,sym)VALUES(317,3,231); 1597INSERT INTO rulerhs(ruleid,pos,sym)VALUES(317,4,309); 1598INSERT INTO rule(ruleid,lhs,txt)VALUES(318,308,'window ::= frame_opt'); 1599INSERT INTO rulerhs(ruleid,pos,sym)VALUES(318,0,309); 1600INSERT INTO rule(ruleid,lhs,txt)VALUES(319,308,'window ::= nm frame_opt'); 1601INSERT INTO rulerhs(ruleid,pos,sym)VALUES(319,0,193); 1602INSERT INTO rulerhs(ruleid,pos,sym)VALUES(319,1,309); 1603INSERT INTO rule(ruleid,lhs,txt)VALUES(320,309,'frame_opt ::='); 1604INSERT INTO rule(ruleid,lhs,txt)VALUES(321,309,'frame_opt ::= range_or_rows frame_bound_s frame_exclude_opt'); 1605INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,0,313); 1606INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,1,315); 1607INSERT INTO rulerhs(ruleid,pos,sym)VALUES(321,2,317); 1608INSERT INTO rule(ruleid,lhs,txt)VALUES(322,309,'frame_opt ::= range_or_rows BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt'); 1609INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,0,313); 1610INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,1,48); 1611INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,2,315); 1612INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,3,44); 1613INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,4,316); 1614INSERT INTO rulerhs(ruleid,pos,sym)VALUES(322,5,317); 1615INSERT INTO rule(ruleid,lhs,txt)VALUES(323,313,'range_or_rows ::= RANGE|ROWS|GROUPS'); 1616INSERT INTO rulerhs(ruleid,pos,sym)VALUES(323,0,89); 1617INSERT INTO rulerhs(ruleid,pos,sym)VALUES(323,0,76); 1618INSERT INTO rulerhs(ruleid,pos,sym)VALUES(323,0,92); 1619INSERT INTO rule(ruleid,lhs,txt)VALUES(324,315,'frame_bound_s ::= frame_bound'); 1620INSERT INTO rulerhs(ruleid,pos,sym)VALUES(324,0,314); 1621INSERT INTO rule(ruleid,lhs,txt)VALUES(325,315,'frame_bound_s ::= UNBOUNDED PRECEDING'); 1622INSERT INTO rulerhs(ruleid,pos,sym)VALUES(325,0,90); 1623INSERT INTO rulerhs(ruleid,pos,sym)VALUES(325,1,88); 1624INSERT INTO rule(ruleid,lhs,txt)VALUES(326,316,'frame_bound_e ::= frame_bound'); 1625INSERT INTO rulerhs(ruleid,pos,sym)VALUES(326,0,314); 1626INSERT INTO rule(ruleid,lhs,txt)VALUES(327,316,'frame_bound_e ::= UNBOUNDED FOLLOWING'); 1627INSERT INTO rulerhs(ruleid,pos,sym)VALUES(327,0,90); 1628INSERT INTO rulerhs(ruleid,pos,sym)VALUES(327,1,86); 1629INSERT INTO rule(ruleid,lhs,txt)VALUES(328,314,'frame_bound ::= expr PRECEDING|FOLLOWING'); 1630INSERT INTO rulerhs(ruleid,pos,sym)VALUES(328,0,217); 1631INSERT INTO rulerhs(ruleid,pos,sym)VALUES(328,1,88); 1632INSERT INTO rulerhs(ruleid,pos,sym)VALUES(328,1,86); 1633INSERT INTO rule(ruleid,lhs,txt)VALUES(329,314,'frame_bound ::= CURRENT ROW'); 1634INSERT INTO rulerhs(ruleid,pos,sym)VALUES(329,0,85); 1635INSERT INTO rulerhs(ruleid,pos,sym)VALUES(329,1,75); 1636INSERT INTO rule(ruleid,lhs,txt)VALUES(330,317,'frame_exclude_opt ::='); 1637INSERT INTO rule(ruleid,lhs,txt)VALUES(331,317,'frame_exclude_opt ::= EXCLUDE frame_exclude'); 1638INSERT INTO rulerhs(ruleid,pos,sym)VALUES(331,0,91); 1639INSERT INTO rulerhs(ruleid,pos,sym)VALUES(331,1,318); 1640INSERT INTO rule(ruleid,lhs,txt)VALUES(332,318,'frame_exclude ::= NO OTHERS'); 1641INSERT INTO rulerhs(ruleid,pos,sym)VALUES(332,0,66); 1642INSERT INTO rulerhs(ruleid,pos,sym)VALUES(332,1,93); 1643INSERT INTO rule(ruleid,lhs,txt)VALUES(333,318,'frame_exclude ::= CURRENT ROW'); 1644INSERT INTO rulerhs(ruleid,pos,sym)VALUES(333,0,85); 1645INSERT INTO rulerhs(ruleid,pos,sym)VALUES(333,1,75); 1646INSERT INTO rule(ruleid,lhs,txt)VALUES(334,318,'frame_exclude ::= GROUP|TIES'); 1647INSERT INTO rulerhs(ruleid,pos,sym)VALUES(334,0,146); 1648INSERT INTO rulerhs(ruleid,pos,sym)VALUES(334,0,94); 1649INSERT INTO rule(ruleid,lhs,txt)VALUES(335,251,'window_clause ::= WINDOW windowdefn_list'); 1650INSERT INTO rulerhs(ruleid,pos,sym)VALUES(335,0,164); 1651INSERT INTO rulerhs(ruleid,pos,sym)VALUES(335,1,306); 1652INSERT INTO rule(ruleid,lhs,txt)VALUES(336,273,'filter_over ::= filter_clause over_clause'); 1653INSERT INTO rulerhs(ruleid,pos,sym)VALUES(336,0,311); 1654INSERT INTO rulerhs(ruleid,pos,sym)VALUES(336,1,312); 1655INSERT INTO rule(ruleid,lhs,txt)VALUES(337,273,'filter_over ::= over_clause'); 1656INSERT INTO rulerhs(ruleid,pos,sym)VALUES(337,0,312); 1657INSERT INTO rule(ruleid,lhs,txt)VALUES(338,273,'filter_over ::= filter_clause'); 1658INSERT INTO rulerhs(ruleid,pos,sym)VALUES(338,0,311); 1659INSERT INTO rule(ruleid,lhs,txt)VALUES(339,312,'over_clause ::= OVER LP window RP'); 1660INSERT INTO rulerhs(ruleid,pos,sym)VALUES(339,0,165); 1661INSERT INTO rulerhs(ruleid,pos,sym)VALUES(339,1,22); 1662INSERT INTO rulerhs(ruleid,pos,sym)VALUES(339,2,308); 1663INSERT INTO rulerhs(ruleid,pos,sym)VALUES(339,3,23); 1664INSERT INTO rule(ruleid,lhs,txt)VALUES(340,312,'over_clause ::= OVER nm'); 1665INSERT INTO rulerhs(ruleid,pos,sym)VALUES(340,0,165); 1666INSERT INTO rulerhs(ruleid,pos,sym)VALUES(340,1,193); 1667INSERT INTO rule(ruleid,lhs,txt)VALUES(341,311,'filter_clause ::= FILTER LP WHERE expr RP'); 1668INSERT INTO rulerhs(ruleid,pos,sym)VALUES(341,0,166); 1669INSERT INTO rulerhs(ruleid,pos,sym)VALUES(341,1,22); 1670INSERT INTO rulerhs(ruleid,pos,sym)VALUES(341,2,149); 1671INSERT INTO rulerhs(ruleid,pos,sym)VALUES(341,3,217); 1672INSERT INTO rulerhs(ruleid,pos,sym)VALUES(341,4,23); 1673INSERT INTO rule(ruleid,lhs,txt)VALUES(342,185,'input ::= cmdlist'); 1674INSERT INTO rulerhs(ruleid,pos,sym)VALUES(342,0,186); 1675INSERT INTO rule(ruleid,lhs,txt)VALUES(343,186,'cmdlist ::= cmdlist ecmd'); 1676INSERT INTO rulerhs(ruleid,pos,sym)VALUES(343,0,186); 1677INSERT INTO rulerhs(ruleid,pos,sym)VALUES(343,1,187); 1678INSERT INTO rule(ruleid,lhs,txt)VALUES(344,186,'cmdlist ::= ecmd'); 1679INSERT INTO rulerhs(ruleid,pos,sym)VALUES(344,0,187); 1680INSERT INTO rule(ruleid,lhs,txt)VALUES(345,187,'ecmd ::= SEMI'); 1681INSERT INTO rulerhs(ruleid,pos,sym)VALUES(345,0,1); 1682INSERT INTO rule(ruleid,lhs,txt)VALUES(346,187,'ecmd ::= cmdx SEMI'); 1683INSERT INTO rulerhs(ruleid,pos,sym)VALUES(346,0,188); 1684INSERT INTO rulerhs(ruleid,pos,sym)VALUES(346,1,1); 1685INSERT INTO rule(ruleid,lhs,txt)VALUES(347,187,'ecmd ::= explain cmdx SEMI'); 1686INSERT INTO rulerhs(ruleid,pos,sym)VALUES(347,0,189); 1687INSERT INTO rulerhs(ruleid,pos,sym)VALUES(347,1,188); 1688INSERT INTO rulerhs(ruleid,pos,sym)VALUES(347,2,1); 1689INSERT INTO rule(ruleid,lhs,txt)VALUES(348,192,'trans_opt ::='); 1690INSERT INTO rule(ruleid,lhs,txt)VALUES(349,192,'trans_opt ::= TRANSACTION'); 1691INSERT INTO rulerhs(ruleid,pos,sym)VALUES(349,0,6); 1692INSERT INTO rule(ruleid,lhs,txt)VALUES(350,192,'trans_opt ::= TRANSACTION nm'); 1693INSERT INTO rulerhs(ruleid,pos,sym)VALUES(350,0,6); 1694INSERT INTO rulerhs(ruleid,pos,sym)VALUES(350,1,193); 1695INSERT INTO rule(ruleid,lhs,txt)VALUES(351,194,'savepoint_opt ::= SAVEPOINT'); 1696INSERT INTO rulerhs(ruleid,pos,sym)VALUES(351,0,13); 1697INSERT INTO rule(ruleid,lhs,txt)VALUES(352,194,'savepoint_opt ::='); 1698INSERT INTO rule(ruleid,lhs,txt)VALUES(353,190,'cmd ::= create_table create_table_args'); 1699INSERT INTO rulerhs(ruleid,pos,sym)VALUES(353,0,195); 1700INSERT INTO rulerhs(ruleid,pos,sym)VALUES(353,1,196); 1701INSERT INTO rule(ruleid,lhs,txt)VALUES(354,203,'table_option_set ::= table_option'); 1702INSERT INTO rulerhs(ruleid,pos,sym)VALUES(354,0,205); 1703INSERT INTO rule(ruleid,lhs,txt)VALUES(355,201,'columnlist ::= columnlist COMMA columnname carglist'); 1704INSERT INTO rulerhs(ruleid,pos,sym)VALUES(355,0,201); 1705INSERT INTO rulerhs(ruleid,pos,sym)VALUES(355,1,25); 1706INSERT INTO rulerhs(ruleid,pos,sym)VALUES(355,2,206); 1707INSERT INTO rulerhs(ruleid,pos,sym)VALUES(355,3,207); 1708INSERT INTO rule(ruleid,lhs,txt)VALUES(356,201,'columnlist ::= columnname carglist'); 1709INSERT INTO rulerhs(ruleid,pos,sym)VALUES(356,0,206); 1710INSERT INTO rulerhs(ruleid,pos,sym)VALUES(356,1,207); 1711INSERT INTO rule(ruleid,lhs,txt)VALUES(357,193,'nm ::= ID|INDEXED'); 1712INSERT INTO rulerhs(ruleid,pos,sym)VALUES(357,0,59); 1713INSERT INTO rulerhs(ruleid,pos,sym)VALUES(357,0,116); 1714INSERT INTO rule(ruleid,lhs,txt)VALUES(358,193,'nm ::= STRING'); 1715INSERT INTO rulerhs(ruleid,pos,sym)VALUES(358,0,117); 1716INSERT INTO rule(ruleid,lhs,txt)VALUES(359,193,'nm ::= JOIN_KW'); 1717INSERT INTO rulerhs(ruleid,pos,sym)VALUES(359,0,118); 1718INSERT INTO rule(ruleid,lhs,txt)VALUES(360,208,'typetoken ::= typename'); 1719INSERT INTO rulerhs(ruleid,pos,sym)VALUES(360,0,209); 1720INSERT INTO rule(ruleid,lhs,txt)VALUES(361,209,'typename ::= ID|STRING'); 1721INSERT INTO rulerhs(ruleid,pos,sym)VALUES(361,0,59); 1722INSERT INTO rulerhs(ruleid,pos,sym)VALUES(361,0,117); 1723INSERT INTO rule(ruleid,lhs,txt)VALUES(362,210,'signed ::= plus_num'); 1724INSERT INTO rulerhs(ruleid,pos,sym)VALUES(362,0,211); 1725INSERT INTO rule(ruleid,lhs,txt)VALUES(363,210,'signed ::= minus_num'); 1726INSERT INTO rulerhs(ruleid,pos,sym)VALUES(363,0,212); 1727INSERT INTO rule(ruleid,lhs,txt)VALUES(364,207,'carglist ::= carglist ccons'); 1728INSERT INTO rulerhs(ruleid,pos,sym)VALUES(364,0,207); 1729INSERT INTO rulerhs(ruleid,pos,sym)VALUES(364,1,215); 1730INSERT INTO rule(ruleid,lhs,txt)VALUES(365,207,'carglist ::='); 1731INSERT INTO rule(ruleid,lhs,txt)VALUES(366,215,'ccons ::= NULL onconf'); 1732INSERT INTO rulerhs(ruleid,pos,sym)VALUES(366,0,121); 1733INSERT INTO rulerhs(ruleid,pos,sym)VALUES(366,1,218); 1734INSERT INTO rule(ruleid,lhs,txt)VALUES(367,215,'ccons ::= GENERATED ALWAYS AS generated'); 1735INSERT INTO rulerhs(ruleid,pos,sym)VALUES(367,0,95); 1736INSERT INTO rulerhs(ruleid,pos,sym)VALUES(367,1,96); 1737INSERT INTO rulerhs(ruleid,pos,sym)VALUES(367,2,24); 1738INSERT INTO rulerhs(ruleid,pos,sym)VALUES(367,3,224); 1739INSERT INTO rule(ruleid,lhs,txt)VALUES(368,215,'ccons ::= AS generated'); 1740INSERT INTO rulerhs(ruleid,pos,sym)VALUES(368,0,24); 1741INSERT INTO rulerhs(ruleid,pos,sym)VALUES(368,1,224); 1742INSERT INTO rule(ruleid,lhs,txt)VALUES(369,202,'conslist_opt ::= COMMA conslist'); 1743INSERT INTO rulerhs(ruleid,pos,sym)VALUES(369,0,25); 1744INSERT INTO rulerhs(ruleid,pos,sym)VALUES(369,1,228); 1745INSERT INTO rule(ruleid,lhs,txt)VALUES(370,228,'conslist ::= conslist tconscomma tcons'); 1746INSERT INTO rulerhs(ruleid,pos,sym)VALUES(370,0,228); 1747INSERT INTO rulerhs(ruleid,pos,sym)VALUES(370,1,229); 1748INSERT INTO rulerhs(ruleid,pos,sym)VALUES(370,2,230); 1749INSERT INTO rule(ruleid,lhs,txt)VALUES(371,228,'conslist ::= tcons'); 1750INSERT INTO rulerhs(ruleid,pos,sym)VALUES(371,0,230); 1751INSERT INTO rule(ruleid,lhs,txt)VALUES(372,229,'tconscomma ::='); 1752INSERT INTO rule(ruleid,lhs,txt)VALUES(373,233,'defer_subclause_opt ::= defer_subclause'); 1753INSERT INTO rulerhs(ruleid,pos,sym)VALUES(373,0,223); 1754INSERT INTO rule(ruleid,lhs,txt)VALUES(374,235,'resolvetype ::= raisetype'); 1755INSERT INTO rulerhs(ruleid,pos,sym)VALUES(374,0,236); 1756INSERT INTO rule(ruleid,lhs,txt)VALUES(375,239,'selectnowith ::= oneselect'); 1757INSERT INTO rulerhs(ruleid,pos,sym)VALUES(375,0,240); 1758INSERT INTO rule(ruleid,lhs,txt)VALUES(376,240,'oneselect ::= values'); 1759INSERT INTO rulerhs(ruleid,pos,sym)VALUES(376,0,252); 1760INSERT INTO rule(ruleid,lhs,txt)VALUES(377,254,'sclp ::= selcollist COMMA'); 1761INSERT INTO rulerhs(ruleid,pos,sym)VALUES(377,0,244); 1762INSERT INTO rulerhs(ruleid,pos,sym)VALUES(377,1,25); 1763INSERT INTO rule(ruleid,lhs,txt)VALUES(378,255,'as ::= ID|STRING'); 1764INSERT INTO rulerhs(ruleid,pos,sym)VALUES(378,0,59); 1765INSERT INTO rulerhs(ruleid,pos,sym)VALUES(378,0,117); 1766INSERT INTO rule(ruleid,lhs,txt)VALUES(379,264,'indexed_opt ::= indexed_by'); 1767INSERT INTO rulerhs(ruleid,pos,sym)VALUES(379,0,260); 1768INSERT INTO rule(ruleid,lhs,txt)VALUES(380,272,'returning ::='); 1769INSERT INTO rule(ruleid,lhs,txt)VALUES(381,217,'expr ::= term'); 1770INSERT INTO rulerhs(ruleid,pos,sym)VALUES(381,0,216); 1771INSERT INTO rule(ruleid,lhs,txt)VALUES(382,274,'likeop ::= LIKE_KW|MATCH'); 1772INSERT INTO rulerhs(ruleid,pos,sym)VALUES(382,0,47); 1773INSERT INTO rulerhs(ruleid,pos,sym)VALUES(382,0,46); 1774INSERT INTO rule(ruleid,lhs,txt)VALUES(383,261,'exprlist ::= nexprlist'); 1775INSERT INTO rulerhs(ruleid,pos,sym)VALUES(383,0,253); 1776INSERT INTO rule(ruleid,lhs,txt)VALUES(384,284,'nmnum ::= plus_num'); 1777INSERT INTO rulerhs(ruleid,pos,sym)VALUES(384,0,211); 1778INSERT INTO rule(ruleid,lhs,txt)VALUES(385,284,'nmnum ::= nm'); 1779INSERT INTO rulerhs(ruleid,pos,sym)VALUES(385,0,193); 1780INSERT INTO rule(ruleid,lhs,txt)VALUES(386,284,'nmnum ::= ON'); 1781INSERT INTO rulerhs(ruleid,pos,sym)VALUES(386,0,115); 1782INSERT INTO rule(ruleid,lhs,txt)VALUES(387,284,'nmnum ::= DELETE'); 1783INSERT INTO rulerhs(ruleid,pos,sym)VALUES(387,0,128); 1784INSERT INTO rule(ruleid,lhs,txt)VALUES(388,284,'nmnum ::= DEFAULT'); 1785INSERT INTO rulerhs(ruleid,pos,sym)VALUES(388,0,120); 1786INSERT INTO rule(ruleid,lhs,txt)VALUES(389,211,'plus_num ::= INTEGER|FLOAT'); 1787INSERT INTO rulerhs(ruleid,pos,sym)VALUES(389,0,155); 1788INSERT INTO rulerhs(ruleid,pos,sym)VALUES(389,0,153); 1789INSERT INTO rule(ruleid,lhs,txt)VALUES(390,289,'foreach_clause ::='); 1790INSERT INTO rule(ruleid,lhs,txt)VALUES(391,289,'foreach_clause ::= FOR EACH ROW'); 1791INSERT INTO rulerhs(ruleid,pos,sym)VALUES(391,0,62); 1792INSERT INTO rulerhs(ruleid,pos,sym)VALUES(391,1,41); 1793INSERT INTO rulerhs(ruleid,pos,sym)VALUES(391,2,75); 1794INSERT INTO rule(ruleid,lhs,txt)VALUES(392,292,'trnm ::= nm'); 1795INSERT INTO rulerhs(ruleid,pos,sym)VALUES(392,0,193); 1796INSERT INTO rule(ruleid,lhs,txt)VALUES(393,293,'tridxby ::='); 1797INSERT INTO rule(ruleid,lhs,txt)VALUES(394,294,'database_kw_opt ::= DATABASE'); 1798INSERT INTO rulerhs(ruleid,pos,sym)VALUES(394,0,38); 1799INSERT INTO rule(ruleid,lhs,txt)VALUES(395,294,'database_kw_opt ::='); 1800INSERT INTO rule(ruleid,lhs,txt)VALUES(396,297,'kwcolumn_opt ::='); 1801INSERT INTO rule(ruleid,lhs,txt)VALUES(397,297,'kwcolumn_opt ::= COLUMNKW'); 1802INSERT INTO rulerhs(ruleid,pos,sym)VALUES(397,0,60); 1803INSERT INTO rule(ruleid,lhs,txt)VALUES(398,299,'vtabarglist ::= vtabarg'); 1804INSERT INTO rulerhs(ruleid,pos,sym)VALUES(398,0,300); 1805INSERT INTO rule(ruleid,lhs,txt)VALUES(399,299,'vtabarglist ::= vtabarglist COMMA vtabarg'); 1806INSERT INTO rulerhs(ruleid,pos,sym)VALUES(399,0,299); 1807INSERT INTO rulerhs(ruleid,pos,sym)VALUES(399,1,25); 1808INSERT INTO rulerhs(ruleid,pos,sym)VALUES(399,2,300); 1809INSERT INTO rule(ruleid,lhs,txt)VALUES(400,300,'vtabarg ::= vtabarg vtabargtoken'); 1810INSERT INTO rulerhs(ruleid,pos,sym)VALUES(400,0,300); 1811INSERT INTO rulerhs(ruleid,pos,sym)VALUES(400,1,301); 1812INSERT INTO rule(ruleid,lhs,txt)VALUES(401,303,'anylist ::='); 1813INSERT INTO rule(ruleid,lhs,txt)VALUES(402,303,'anylist ::= anylist LP anylist RP'); 1814INSERT INTO rulerhs(ruleid,pos,sym)VALUES(402,0,303); 1815INSERT INTO rulerhs(ruleid,pos,sym)VALUES(402,1,22); 1816INSERT INTO rulerhs(ruleid,pos,sym)VALUES(402,2,303); 1817INSERT INTO rulerhs(ruleid,pos,sym)VALUES(402,3,23); 1818INSERT INTO rule(ruleid,lhs,txt)VALUES(403,303,'anylist ::= anylist ANY'); 1819INSERT INTO rulerhs(ruleid,pos,sym)VALUES(403,0,303); 1820INSERT INTO rulerhs(ruleid,pos,sym)VALUES(403,1,101); 1821INSERT INTO rule(ruleid,lhs,txt)VALUES(404,266,'with ::='); 1822COMMIT; 1823