search

rickywu-posh / php-sql-parser

Automatically exported from code.google.com/p/php-sql-parser
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

Line breaks making trouble detecting correct table name #43

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
Parse the following query:
SELECT title, introtext
FROM kj9un_content
WHERE `id`='159'

What is the expected output? What do you see instead?
$parsed['FROM'][0]['table'] = 'kj9un_content'
I get
$parsed['FROM'][0]['table'] = 'kj9un_content
WHERE'

Original issue reported on code.google.com by h.leith...@gmail.com on 20 Apr 2012 at 5:05

GoogleCodeExporter commented 8 years ago 
Hmm you can close this, the problem was that the prefix is #__tablename and 
thats not legal, I think in mysql.

Original comment by h.leith...@gmail.com on 21 Apr 2012 at 9:30

GoogleCodeExporter commented 8 years ago 
I have added a test case, but your reported error doesn't occur on REV 238. 
Please reopen an issue, if you see the problem again.

Original comment by pho...@gmx.de on 26 Apr 2012 at 6:44