{ "query": "-- create first view\nCREATE VIEW withclause AS\n\nWITH cte AS (\n SELECT p.name, p.shape\n FROM gis_all as p\n)\n\nSELECT cte.*\nFROM cte\nCROSS JOIN gis_all;\n-- create second view\nCREATE VIEW withclause2 AS\n\nWITH cte AS (\n SELECT p.name, p.shape\n FROM gis_all as p\n), cte2 AS (\n SELECT p.name as n2, p.shape as sh2\n FROM gis_all as p\n)\n\nSELECT cte.*,cte2.*\nFROM cte,cte2\nCROSS JOIN gis_all;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "-- create first view\nCREATE VIEW withclause AS\n\nWITH cte AS (\n SELECT p.name, p.shape\n FROM gis_all as p\n)\n\nSELECT cte.*\nFROM cte\nCROSS JOIN gis_all;\n-- create second view\nCREATE VIEW withclause2 AS\n\nWITH cte AS (\n SELECT p.name, p.shape\n FROM gis_all as p\n), cte2 AS (\n SELECT p.name as n2, p.shape as sh2\n FROM gis_all as p\n)\n\nSELECT cte.*,cte2.*\nFROM cte,cte2\nCROSS JOIN gis_all;", "len": 388, "last": 388, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- create first view", "value": "-- create first view", "keyword": null, "type": 4, "flags": 4, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 20 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 21 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VIEW", "value": "VIEW", "keyword": "VIEW", "type": 1, "flags": 1, "position": 28 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 32 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "withclause", "value": "withclause", "keyword": null, "type": 0, "flags": 0, "position": 33 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 43 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 46 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WITH", "value": "WITH", "keyword": "WITH", "type": 1, "flags": 3, "position": 48 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 52 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte", "value": "cte", "keyword": null, "type": 0, "flags": 0, "position": 53 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 56 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 57 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 59 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 61 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 64 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "name", "value": "name", "keyword": "NAME", "type": 0, "flags": 0, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 79 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 80 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "shape", "value": "shape", "keyword": null, "type": 0, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 86 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 89 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 93 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "gis_all", "value": "gis_all", "keyword": null, "type": 0, "flags": 0, "position": 94 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 101 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "as", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 102 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 104 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 105 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 106 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 107 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 108 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 110 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 116 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte", "value": "cte", "keyword": null, "type": 0, "flags": 0, "position": 117 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 120 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*", "value": "*", "keyword": null, "type": 2, "flags": 16, "position": 121 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 122 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 123 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 127 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte", "value": "cte", "keyword": null, "type": 0, "flags": 0, "position": 128 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CROSS JOIN", "value": "CROSS JOIN", "keyword": "CROSS JOIN", "type": 1, "flags": 7, "position": 132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 142 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "gis_all", "value": "gis_all", "keyword": null, "type": 0, "flags": 0, "position": 143 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 150 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- create second view", "value": "-- create second view", "keyword": null, "type": 4, "flags": 4, "position": 152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 173 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 174 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 180 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VIEW", "value": "VIEW", "keyword": "VIEW", "type": 1, "flags": 1, "position": 181 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 185 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "withclause2", "value": "withclause2", "keyword": null, "type": 0, "flags": 0, "position": 186 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 197 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 198 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 200 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WITH", "value": "WITH", "keyword": "WITH", "type": 1, "flags": 3, "position": 202 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 206 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte", "value": "cte", "keyword": null, "type": 0, "flags": 0, "position": 207 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 210 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 211 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 213 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 214 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 215 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 218 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 224 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 225 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 226 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "name", "value": "name", "keyword": "NAME", "type": 0, "flags": 0, "position": 227 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 231 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 232 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 233 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 234 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "shape", "value": "shape", "keyword": null, "type": 0, "flags": 0, "position": 235 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 240 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 243 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 247 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "gis_all", "value": "gis_all", "keyword": null, "type": 0, "flags": 0, "position": 248 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 255 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "as", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 256 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 258 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 259 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 260 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 261 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 262 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 263 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte2", "value": "cte2", "keyword": null, "type": 0, "flags": 0, "position": 264 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 268 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 269 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 271 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 272 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 273 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 276 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 282 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 283 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 284 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "name", "value": "name", "keyword": "NAME", "type": 0, "flags": 0, "position": 285 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 289 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "as", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 290 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 292 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "n2", "value": "n2", "keyword": null, "type": 0, "flags": 0, "position": 293 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 295 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 296 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 297 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 298 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "shape", "value": "shape", "keyword": null, "type": 0, "flags": 0, "position": 299 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 304 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "as", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 305 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 307 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "sh2", "value": "sh2", "keyword": null, "type": 0, "flags": 0, "position": 308 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 311 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 314 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 318 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "gis_all", "value": "gis_all", "keyword": null, "type": 0, "flags": 0, "position": 319 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 326 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "as", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 327 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 329 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p", "value": "p", "keyword": null, "type": 0, "flags": 0, "position": 330 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 331 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 332 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 333 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 335 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 341 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte", "value": "cte", "keyword": null, "type": 0, "flags": 0, "position": 342 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 345 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*", "value": "*", "keyword": null, "type": 2, "flags": 16, "position": 346 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 347 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte2", "value": "cte2", "keyword": null, "type": 0, "flags": 0, "position": 348 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 352 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*", "value": "*", "keyword": null, "type": 2, "flags": 16, "position": 353 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 354 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 355 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 359 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte", "value": "cte", "keyword": null, "type": 0, "flags": 0, "position": 360 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 363 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "cte2", "value": "cte2", "keyword": null, "type": 0, "flags": 0, "position": 364 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 368 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CROSS JOIN", "value": "CROSS JOIN", "keyword": "CROSS JOIN", "type": 1, "flags": 7, "position": 369 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 379 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "gis_all", "value": "gis_all", "keyword": null, "type": 0, "flags": 0, "position": 380 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 387 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 150, "idx": 150 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "withclause", "column": null, "expr": "withclause", "alias": null, "function": null, "subquery": null }, "entityOptions": null, "fields": null, "with": { "@type": "PhpMyAdmin\\SqlParser\\Statements\\WithStatement", "withers": { "cte": { "@type": "PhpMyAdmin\\SqlParser\\Components\\WithKeyword", "name": "cte", "columns": [], "statement": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@19" }, { "@type": "@20" }, { "@type": "@21" }, { "@type": "@22" }, { "@type": "@23" }, { "@type": "@24" }, { "@type": "@25" }, { "@type": "@26" }, { "@type": "@27" }, { "@type": "@28" }, { "@type": "@29" }, { "@type": "@30" }, { "@type": "@31" }, { "@type": "@32" }, { "@type": "@33" }, { "@type": "@34" }, { "@type": "@35" }, { "@type": "@36" }, { "@type": "@37" }, { "@type": "@38" } ], "count": 20, "idx": 20 }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "p", "column": "name", "expr": "p.name", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "p", "column": "shape", "expr": "p.shape", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "gis_all", "column": null, "expr": "gis_all", "alias": "p", "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "group": null, "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": null, "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 19 } ], "brackets": 0, "strict": false, "errors": [] } } }, "cteStatementParser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@41" }, { "@type": "@42" }, { "@type": "@43" }, { "@type": "@44" }, { "@type": "@45" }, { "@type": "@46" }, { "@type": "@47" }, { "@type": "@48" }, { "@type": "@49" }, { "@type": "@50" }, { "@type": "@51" }, { "@type": "@52" }, { "@type": "@53" }, { "@type": "@54" }, { "@type": "@55" }, { "@type": "@56" }, { "@type": "@57" }, { "@type": "@58" }, { "@type": "@59" }, { "@type": "@60" }, { "@type": "@61" }, { "@type": "@62" }, { "@type": "@63" }, { "@type": "@64" }, { "@type": "@65" }, { "@type": "@66" }, { "@type": "@67" }, { "@type": "@68" }, { "@type": "@69" }, { "@type": "@70" }, { "@type": "@71" }, { "@type": "@72" }, { "@type": "@73" }, { "@type": "@74" }, { "@type": "@75" }, { "@type": "@76" }, { "@type": "@77" }, { "@type": "@78" }, { "@type": "@79" }, { "@type": "@80" }, { "@type": "@81" }, { "@type": "@82" }, { "@type": "@83" }, { "@type": "@84" }, { "@type": "@85" }, { "@type": "@86" }, { "@type": "@87" }, { "@type": "@88" }, { "@type": "@89" }, { "@type": "@90" }, { "@type": "@91" }, { "@type": "@92" }, { "@type": "@93" }, { "@type": "@94" }, { "@type": "@95" }, { "@type": "@96" }, { "@type": "@97" }, { "@type": "@98" }, { "@type": "@99" }, { "@type": "@100" }, { "@type": "@101" }, { "@type": "@102" }, { "@type": "@103" }, { "@type": "@104" }, { "@type": "@105" }, { "@type": "@106" }, { "@type": "@107" }, { "@type": "@108" }, { "@type": "@109" }, { "@type": "@110" }, { "@type": "@111" }, { "@type": "@112" }, { "@type": "@113" }, { "@type": "@114" }, { "@type": "@115" }, { "@type": "@116" }, { "@type": "@117" }, { "@type": "@118" }, { "@type": "@119" }, { "@type": "@120" }, { "@type": "@121" }, { "@type": "@122" }, { "@type": "@123" }, { "@type": "@124" }, { "@type": "@125" }, { "@type": "@126" }, { "@type": "@127" }, { "@type": "@128" }, { "@type": "@129" }, { "@type": "@130" }, { "@type": "@131" }, { "@type": "@132" }, { "@type": "@133" }, { "@type": "@134" }, { "@type": "@135" }, { "@type": "@136" }, { "@type": "@137" }, { "@type": "@138" }, { "@type": "@139" }, { "@type": "@140" }, { "@type": "@141" }, { "@type": "@142" }, { "@type": "@143" }, { "@type": "@144" }, { "@type": "@145" }, { "@type": "@146" }, { "@type": "@147" }, { "@type": "@148" }, { "@type": "@149" }, { "@type": "@150" }, { "@type": "@151" } ], "count": 111, "idx": 111 }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "cte", "column": null, "expr": "cte.*", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "cte", "column": null, "expr": "cte", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "group": null, "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "type": "CROSS", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "gis_all", "column": null, "expr": "gis_all", "alias": null, "function": null, "subquery": null }, "on": null, "using": null } ], "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 12 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "withclause2", "column": null, "expr": "withclause2", "alias": null, "function": null, "subquery": null }, "entityOptions": null, "fields": null, "with": { "@type": "PhpMyAdmin\\SqlParser\\Statements\\WithStatement", "withers": { "cte": { "@type": "PhpMyAdmin\\SqlParser\\Components\\WithKeyword", "name": "cte", "columns": [], "statement": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@73" }, { "@type": "@74" }, { "@type": "@75" }, { "@type": "@76" }, { "@type": "@77" }, { "@type": "@78" }, { "@type": "@79" }, { "@type": "@80" }, { "@type": "@81" }, { "@type": "@82" }, { "@type": "@83" }, { "@type": "@84" }, { "@type": "@85" }, { "@type": "@86" }, { "@type": "@87" }, { "@type": "@88" }, { "@type": "@89" }, { "@type": "@90" }, { "@type": "@91" }, { "@type": "@92" } ], "count": 20, "idx": 20 }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "p", "column": "name", "expr": "p.name", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "p", "column": "shape", "expr": "p.shape", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "gis_all", "column": null, "expr": "gis_all", "alias": "p", "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "group": null, "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": null, "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 19 } ], "brackets": 0, "strict": false, "errors": [] } }, "cte2": { "@type": "PhpMyAdmin\\SqlParser\\Components\\WithKeyword", "name": "cte2", "columns": [], "statement": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@101" }, { "@type": "@102" }, { "@type": "@103" }, { "@type": "@104" }, { "@type": "@105" }, { "@type": "@106" }, { "@type": "@107" }, { "@type": "@108" }, { "@type": "@109" }, { "@type": "@110" }, { "@type": "@111" }, { "@type": "@112" }, { "@type": "@113" }, { "@type": "@114" }, { "@type": "@115" }, { "@type": "@116" }, { "@type": "@117" }, { "@type": "@118" }, { "@type": "@119" }, { "@type": "@120" }, { "@type": "@121" }, { "@type": "@122" }, { "@type": "@123" }, { "@type": "@124" }, { "@type": "@125" }, { "@type": "@126" }, { "@type": "@127" }, { "@type": "@128" } ], "count": 28, "idx": 28 }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "p", "column": "name", "expr": "p.name", "alias": "n2", "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "p", "column": "shape", "expr": "p.shape", "alias": "sh2", "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "gis_all", "column": null, "expr": "gis_all", "alias": "p", "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "group": null, "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": null, "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 27 } ], "brackets": 0, "strict": false, "errors": [] } } }, "cteStatementParser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@131" }, { "@type": "@132" }, { "@type": "@133" }, { "@type": "@134" }, { "@type": "@135" }, { "@type": "@136" }, { "@type": "@137" }, { "@type": "@138" }, { "@type": "@139" }, { "@type": "@140" }, { "@type": "@141" }, { "@type": "@142" }, { "@type": "@143" }, { "@type": "@144" }, { "@type": "@145" }, { "@type": "@146" }, { "@type": "@147" }, { "@type": "@148" }, { "@type": "@149" }, { "@type": "@150" }, { "@type": "@151" } ], "count": 21, "idx": 21 }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "cte", "column": null, "expr": "cte.*", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "cte2", "column": null, "expr": "cte2.*", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "cte", "column": null, "expr": "cte", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "cte2", "column": null, "expr": "cte2", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "group": null, "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "type": "CROSS", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "gis_all", "column": null, "expr": "gis_all", "alias": null, "function": null, "subquery": null }, "on": null, "using": null } ], "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 18 } ], "brackets": 0, "strict": false, "errors": [] }, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": null, "last": null }, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": null, "parameters": null, "body": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "VIEW" } }, "first": 13, "last": 109 } ], "brackets": 0, "strict": false, "errors": [] }, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": null, "last": null }, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": null, "parameters": null, "body": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "VIEW" } }, "first": 0, "last": 148 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }