#1419 Parser doesn't handle nested selects

[Anonymous]

I use phpMyAdmin-2.5.6
Here is a query I get from my bookmarks.

SELECT items.itemID, serialNumber, partNumber, S1.notes
AS ACTIONNote, room, shelf,
LEVEL , employees.firstName
FROM items
LEFT JOIN actions S1 ON S1.itemID = items.itemID
LEFT JOIN locationInt ON locationInt.locationID =
S1.locationIntID
LEFT JOIN ToolsCommonDB.employees ON
employees.employeeID = desk
WHERE owner
LIKE 'CS' AND tmsp = (
SELECT max( S2.tmsp )
FROM actions S2
WHERE S1.itemID = S2.itemID )

I use the 'export' link at the bottom of the page.

When the page is displayed, the query has been changed to :
SELECT max( S2 . tmsp ) FROM actions S2 WHERE S1 .
itemID = S2 . itemID )

My email is wilfried.kopp@wanadoo.fr

Best regards,
Will

[Michal Čihař]

Logged In: YES
user_id=192186

Could you please post here structure of these tables and
some testing data?

[Michal Čihař]

Logged In: YES
user_id=192186

Any chance to get these?

[Michal Čihař]

Logged In: YES
user_id=192186

Export of this query fixed, however SQL parser should handle
this situation correctly, so leaving open.

[Marc Delisle]

Ticket moved from /p/phpmyadmin/bugs/1249/

[Madhura Jayaratne]

Assigning to Marc since there is a proposed GSoC project on parser rewrite mentored by Marc.