File: tests/expected/parser/issue131.serialized

Recommend this page to a friend!
  Classes of Michael Cummings  >  PHP SQL Parser Class  >  tests/expected/parser/issue131.serialized  >  Download  
File: tests/expected/parser/issue131.serialized
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP SQL Parser Class
Parse SQL to extract the SQL query structure
Author: By
Last change:
Date: 2 years ago
Size: 2,839 bytes
 

 

Contents

Class file image Download
a:2:{s:6:"CREATE";a:5:{s:9:"expr_type";s:5:"index";s:9:"base_expr";s:12:"unique index";s:10:"constraint";s:6:"UNIQUE";s:8:"sub_tree";a:2:{i:0;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:6:"unique";s:8:"position";i:7;}i:1;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:5:"index";s:8:"position";i:14;}}s:8:"position";i:7;}s:5:"INDEX";a:7:{s:9:"base_expr";s:2:"i1";s:4:"name";s:2:"i1";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:2:"i1";}}s:10:"index-type";a:5:{s:9:"expr_type";s:10:"index-type";s:9:"base_expr";s:11:"using BTREE";s:5:"using";s:5:"BTREE";s:8:"sub_tree";a:2:{i:0;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:5:"using";s:8:"position";i:23;}i:1;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:5:"BTREE";s:8:"position";i:29;}}s:8:"position";i:23;}s:2:"on";a:6:{s:9:"expr_type";s:5:"table";s:9:"base_expr";s:35:" on t1 (c1(5) DESC, `col 2`(8) ASC)";s:4:"name";s:2:"t1";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:2:"t1";}}s:8:"sub_tree";a:4:{s:9:"expr_type";s:11:"column-list";s:9:"base_expr";s:28:"(c1(5) DESC, `col 2`(8) ASC)";s:8:"sub_tree";a:2:{i:0;a:7:{s:9:"expr_type";s:12:"index-column";s:9:"base_expr";s:11:"c1(5) DESC,";s:4:"name";s:2:"c1";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:2:"c1";}}s:6:"length";s:1:"5";s:3:"dir";s:4:"DESC";s:8:"position";i:42;}i:1;a:7:{s:9:"expr_type";s:12:"index-column";s:9:"base_expr";s:15:" `col 2`(8) ASC";s:4:"name";s:7:"`col 2`";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:5:"col 2";}}s:6:"length";s:1:"8";s:3:"dir";s:3:"ASC";s:8:"position";i:53;}}s:8:"position";i:41;}s:8:"position";i:34;}s:7:"options";a:3:{i:0;a:5:{s:9:"expr_type";s:15:"index-algorithm";s:9:"base_expr";s:17:"ALGORITHM=DEFAULT";s:9:"algorithm";s:7:"DEFAULT";s:8:"sub_tree";a:3:{i:0;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:9:"ALGORITHM";s:8:"position";i:70;}i:1;a:3:{s:9:"expr_type";s:8:"operator";s:9:"base_expr";s:1:"=";s:8:"position";i:79;}i:2;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:7:"DEFAULT";s:8:"position";i:80;}}s:8:"position";i:70;}i:1;a:5:{s:9:"expr_type";s:10:"index-type";s:9:"base_expr";s:10:"using hash";s:5:"using";s:4:"HASH";s:8:"sub_tree";a:2:{i:0;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:5:"using";s:8:"position";i:88;}i:1;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:4:"hash";s:8:"position";i:94;}}s:8:"position";i:88;}i:2;a:5:{s:9:"expr_type";s:10:"index-lock";s:9:"base_expr";s:11:"LOCK=SHARED";s:4:"lock";s:6:"SHARED";s:8:"sub_tree";a:3:{i:0;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:4:"LOCK";s:8:"position";i:99;}i:1;a:3:{s:9:"expr_type";s:8:"operator";s:9:"base_expr";s:1:"=";s:8:"position";i:103;}i:2;a:3:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:6:"SHARED";s:8:"position";i:104;}}s:8:"position";i:99;}}s:8:"position";i:20;}}

For more information send a message to info at phpclasses dot org.