dstorm

var_dump of output of PMA_SQP_parse()

Jun 2nd, 2014
243
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.11 KB | None | 0 0
  1. array (size=62)
  2. 'raw' => string 'CREATE TRIGGER `BEFORE_inst_master_INSERT` BEFORE INSERT ON `inst_master`
  3. FOR EACH ROW BEGIN
  4. SET @cnt=(SELECT count(*) FROM inst_master WHERE inst_name=NEW.inst_name OR inst_code=NEW.inst_code LIMIT 1);
  5. IF @cnt<>0 THEN
  6. SET NEW.inst_id=1;
  7. END IF;
  8. END' (length=250)
  9. 0 =>
  10. array (size=4)
  11. 'type' => string 'alpha_reservedWord' (length=18)
  12. 'data' => string 'CREATE' (length=6)
  13. 'pos' => int 6
  14. 'forbidden' => boolean true
  15. 1 =>
  16. array (size=4)
  17. 'type' => string 'alpha_identifier' (length=16)
  18. 'data' => string 'TRIGGER' (length=7)
  19. 'pos' => int 14
  20. 'forbidden' => boolean false
  21. 2 =>
  22. array (size=3)
  23. 'type' => string 'quote_backtick' (length=14)
  24. 'data' => string '`BEFORE_inst_master_INSERT`' (length=27)
  25. 'pos' => int 0
  26. 3 =>
  27. array (size=4)
  28. 'type' => string 'alpha_identifier' (length=16)
  29. 'data' => string 'BEFORE' (length=6)
  30. 'pos' => int 49
  31. 'forbidden' => boolean false
  32. 4 =>
  33. array (size=4)
  34. 'type' => string 'alpha_reservedWord' (length=18)
  35. 'data' => string 'INSERT' (length=6)
  36. 'pos' => int 56
  37. 'forbidden' => boolean true
  38. 5 =>
  39. array (size=4)
  40. 'type' => string 'alpha_reservedWord' (length=18)
  41. 'data' => string 'ON' (length=2)
  42. 'pos' => int 59
  43. 'forbidden' => boolean true
  44. 6 =>
  45. array (size=3)
  46. 'type' => string 'quote_backtick' (length=14)
  47. 'data' => string '`inst_master`' (length=13)
  48. 'pos' => int 0
  49. 7 =>
  50. array (size=3)
  51. 'type' => string 'white_newline' (length=13)
  52. 'data' => string '' (length=0)
  53. 'pos' => int 0
  54. 8 =>
  55. array (size=4)
  56. 'type' => string 'alpha_reservedWord' (length=18)
  57. 'data' => string 'FOR' (length=3)
  58. 'pos' => int 78
  59. 'forbidden' => boolean true
  60. 9 =>
  61. array (size=4)
  62. 'type' => string 'alpha_identifier' (length=16)
  63. 'data' => string 'EACH' (length=4)
  64. 'pos' => int 83
  65. 'forbidden' => boolean false
  66. 10 =>
  67. array (size=4)
  68. 'type' => string 'alpha_reservedWord' (length=18)
  69. 'data' => string 'ROW' (length=3)
  70. 'pos' => int 87
  71. 'forbidden' => boolean false
  72. 11 =>
  73. array (size=4)
  74. 'type' => string 'alpha_reservedWord' (length=18)
  75. 'data' => string 'BEGIN' (length=5)
  76. 'pos' => int 93
  77. 'forbidden' => boolean false
  78. 12 =>
  79. array (size=3)
  80. 'type' => string 'white_newline' (length=13)
  81. 'data' => string '' (length=0)
  82. 'pos' => int 0
  83. 13 =>
  84. array (size=4)
  85. 'type' => string 'alpha_reservedWord' (length=18)
  86. 'data' => string 'SET' (length=3)
  87. 'pos' => int 97
  88. 'forbidden' => boolean true
  89. 14 =>
  90. array (size=3)
  91. 'type' => string 'alpha_variable' (length=14)
  92. 'data' => string '@cnt' (length=4)
  93. 'pos' => int 102
  94. 15 =>
  95. array (size=3)
  96. 'type' => string 'punct' (length=5)
  97. 'data' => string '=' (length=1)
  98. 'pos' => int 0
  99. 16 =>
  100. array (size=3)
  101. 'type' => string 'punct_bracket_open_round' (length=24)
  102. 'data' => string '(' (length=1)
  103. 'pos' => int 0
  104. 17 =>
  105. array (size=4)
  106. 'type' => string 'alpha_reservedWord' (length=18)
  107. 'data' => string 'SELECT' (length=6)
  108. 'pos' => int 110
  109. 'forbidden' => boolean true
  110. 18 =>
  111. array (size=4)
  112. 'type' => string 'alpha_functionName' (length=18)
  113. 'data' => string 'count' (length=5)
  114. 'pos' => int 116
  115. 'forbidden' => boolean false
  116. 19 =>
  117. array (size=3)
  118. 'type' => string 'punct_bracket_open_round' (length=24)
  119. 'data' => string '(' (length=1)
  120. 'pos' => int 0
  121. 20 =>
  122. array (size=3)
  123. 'type' => string 'punct' (length=5)
  124. 'data' => string '*' (length=1)
  125. 'pos' => int 0
  126. 21 =>
  127. array (size=3)
  128. 'type' => string 'punct_bracket_close_round' (length=25)
  129. 'data' => string ')' (length=1)
  130. 'pos' => int 0
  131. 22 =>
  132. array (size=4)
  133. 'type' => string 'alpha_reservedWord' (length=18)
  134. 'data' => string 'FROM' (length=4)
  135. 'pos' => int 124
  136. 'forbidden' => boolean true
  137. 23 =>
  138. array (size=4)
  139. 'type' => string 'alpha_identifier' (length=16)
  140. 'data' => string 'inst_master' (length=11)
  141. 'pos' => int 136
  142. 'forbidden' => boolean false
  143. 24 =>
  144. array (size=4)
  145. 'type' => string 'alpha_reservedWord' (length=18)
  146. 'data' => string 'WHERE' (length=5)
  147. 'pos' => int 142
  148. 'forbidden' => boolean true
  149. 25 =>
  150. array (size=4)
  151. 'type' => string 'alpha_identifier' (length=16)
  152. 'data' => string 'inst_name' (length=9)
  153. 'pos' => int 152
  154. 'forbidden' => boolean false
  155. 26 =>
  156. array (size=3)
  157. 'type' => string 'punct' (length=5)
  158. 'data' => string '=' (length=1)
  159. 'pos' => int 0
  160. 27 =>
  161. array (size=4)
  162. 'type' => string 'alpha_identifier' (length=16)
  163. 'data' => string 'NEW' (length=3)
  164. 'pos' => int 156
  165. 'forbidden' => boolean false
  166. 28 =>
  167. array (size=3)
  168. 'type' => string 'punct_qualifier' (length=15)
  169. 'data' => string '.' (length=1)
  170. 'pos' => int 0
  171. 29 =>
  172. array (size=4)
  173. 'type' => string 'alpha_identifier' (length=16)
  174. 'data' => string 'inst_name' (length=9)
  175. 'pos' => int 166
  176. 'forbidden' => boolean false
  177. 30 =>
  178. array (size=4)
  179. 'type' => string 'alpha_reservedWord' (length=18)
  180. 'data' => string 'OR' (length=2)
  181. 'pos' => int 169
  182. 'forbidden' => boolean true
  183. 31 =>
  184. array (size=4)
  185. 'type' => string 'alpha_identifier' (length=16)
  186. 'data' => string 'inst_code' (length=9)
  187. 'pos' => int 179
  188. 'forbidden' => boolean false
  189. 32 =>
  190. array (size=3)
  191. 'type' => string 'punct' (length=5)
  192. 'data' => string '=' (length=1)
  193. 'pos' => int 0
  194. 33 =>
  195. array (size=4)
  196. 'type' => string 'alpha_identifier' (length=16)
  197. 'data' => string 'NEW' (length=3)
  198. 'pos' => int 183
  199. 'forbidden' => boolean false
  200. 34 =>
  201. array (size=3)
  202. 'type' => string 'punct_qualifier' (length=15)
  203. 'data' => string '.' (length=1)
  204. 'pos' => int 0
  205. 35 =>
  206. array (size=4)
  207. 'type' => string 'alpha_identifier' (length=16)
  208. 'data' => string 'inst_code' (length=9)
  209. 'pos' => int 193
  210. 'forbidden' => boolean false
  211. 36 =>
  212. array (size=4)
  213. 'type' => string 'alpha_reservedWord' (length=18)
  214. 'data' => string 'LIMIT' (length=5)
  215. 'pos' => int 199
  216. 'forbidden' => boolean true
  217. 37 =>
  218. array (size=3)
  219. 'type' => string 'digit_integer' (length=13)
  220. 'data' => string '1' (length=1)
  221. 'pos' => int 201
  222. 38 =>
  223. array (size=3)
  224. 'type' => string 'punct_bracket_close_round' (length=25)
  225. 'data' => string ')' (length=1)
  226. 'pos' => int 0
  227. 39 =>
  228. array (size=3)
  229. 'type' => string 'punct_queryend' (length=14)
  230. 'data' => string ';' (length=1)
  231. 'pos' => int 0
  232. 40 =>
  233. array (size=3)
  234. 'type' => string 'white_newline' (length=13)
  235. 'data' => string '' (length=0)
  236. 'pos' => int 0
  237. 41 =>
  238. array (size=4)
  239. 'type' => string 'alpha_reservedWord' (length=18)
  240. 'data' => string 'IF' (length=2)
  241. 'pos' => int 206
  242. 'forbidden' => boolean true
  243. 42 =>
  244. array (size=3)
  245. 'type' => string 'alpha_variable' (length=14)
  246. 'data' => string '@cnt' (length=4)
  247. 'pos' => int 211
  248. 43 =>
  249. array (size=3)
  250. 'type' => string 'punct' (length=5)
  251. 'data' => string '<>' (length=2)
  252. 'pos' => int 0
  253. 44 =>
  254. array (size=3)
  255. 'type' => string 'digit_integer' (length=13)
  256. 'data' => string '0' (length=1)
  257. 'pos' => int 214
  258. 45 =>
  259. array (size=4)
  260. 'type' => string 'alpha_reservedWord' (length=18)
  261. 'data' => string 'THEN' (length=4)
  262. 'pos' => int 219
  263. 'forbidden' => boolean true
  264. 46 =>
  265. array (size=3)
  266. 'type' => string 'white_newline' (length=13)
  267. 'data' => string '' (length=0)
  268. 'pos' => int 0
  269. 47 =>
  270. array (size=4)
  271. 'type' => string 'alpha_reservedWord' (length=18)
  272. 'data' => string 'SET' (length=3)
  273. 'pos' => int 223
  274. 'forbidden' => boolean true
  275. 48 =>
  276. array (size=4)
  277. 'type' => string 'alpha_identifier' (length=16)
  278. 'data' => string 'NEW' (length=3)
  279. 'pos' => int 227
  280. 'forbidden' => boolean false
  281. 49 =>
  282. array (size=3)
  283. 'type' => string 'punct_qualifier' (length=15)
  284. 'data' => string '.' (length=1)
  285. 'pos' => int 0
  286. 50 =>
  287. array (size=4)
  288. 'type' => string 'alpha_identifier' (length=16)
  289. 'data' => string 'inst_id' (length=7)
  290. 'pos' => int 235
  291. 'forbidden' => boolean false
  292. 51 =>
  293. array (size=3)
  294. 'type' => string 'punct' (length=5)
  295. 'data' => string '=' (length=1)
  296. 'pos' => int 0
  297. 52 =>
  298. array (size=3)
  299. 'type' => string 'digit_integer' (length=13)
  300. 'data' => string '1' (length=1)
  301. 'pos' => int 237
  302. 53 =>
  303. array (size=3)
  304. 'type' => string 'punct_queryend' (length=14)
  305. 'data' => string ';' (length=1)
  306. 'pos' => int 0
  307. 54 =>
  308. array (size=3)
  309. 'type' => string 'white_newline' (length=13)
  310. 'data' => string '' (length=0)
  311. 'pos' => int 0
  312. 55 =>
  313. array (size=4)
  314. 'type' => string 'alpha_reservedWord' (length=18)
  315. 'data' => string 'END' (length=3)
  316. 'pos' => int 242
  317. 'forbidden' => boolean false
  318. 56 =>
  319. array (size=4)
  320. 'type' => string 'alpha_reservedWord' (length=18)
  321. 'data' => string 'IF' (length=2)
  322. 'pos' => int 245
  323. 'forbidden' => boolean true
  324. 57 =>
  325. array (size=3)
  326. 'type' => string 'punct_queryend' (length=14)
  327. 'data' => string ';' (length=1)
  328. 'pos' => int 0
  329. 58 =>
  330. array (size=3)
  331. 'type' => string 'white_newline' (length=13)
  332. 'data' => string '' (length=0)
  333. 'pos' => int 0
  334. 59 =>
  335. array (size=4)
  336. 'type' => string 'alpha_reservedWord' (length=18)
  337. 'data' => string 'END' (length=3)
  338. 'pos' => int 250
  339. 'forbidden' => boolean false
  340. 'len' => int 60
Add Comment
Please, Sign In to add comment