Bug #5755 :: Cannot handle select in form of tablename.*

Package home | Report new bug | New search | Development Roadmap

Status: Open | Feedback | All | Closed Since Version 0.7.0

Bug #5755	Cannot handle select in form of tablename.*
Submitted:	2005-10-22 16:34 UTC
From:	shannah at sfu dot ca	Assigned:	epte
Status:	Closed	Package:	SQL_Parser
PHP Version:	4.3.11	OS:	OS X
Roadmaps:	(Not assigned)
Subscription	Your email:

Comments Add Comment Add patch

[2005-10-22 16:34 UTC] shannah at sfu dot ca

Description:
------------
Trying to parse:
select Courses.* from Courses, Student_Courses where 
Courses.id=Student_Courses.courseid and 
Student_Courses.studentid='10'

It reads 'Courses.*' as simply 'Courses.'

Test script:
---------------
require_once 'SQL/Parser.php';
$sql = "select Courses.* from Courses, Student_Courses where Courses.id=Student_Courses.courseid and Student_Courses.studentid='10'";

$parser = new SQL_Parser();
$struct = $parser->parse($sql);

print_r($struct['column_names']);

Expected result:
----------------
Array
        (
            [0] => Courses.*
        )

Actual result:
--------------
Array
        (
            [0] => Courses.
        )

Comments

[2005-12-02 02:03 UTC] epte at php dot net

Thank you for the test script. :)

[2006-01-12 21:55 UTC] epte at php dot net

I have figured out the testing framework around SQL_Parser and have added your test.  In fact, there were several tests that were incorrectly being generated along the same lines as this bug.  Those have also been fixed.

[2006-04-03 05:22 UTC] epte at php dot net (Erich Enke)

This is fixed.  Closing.

Note that the correct behavior for this is not to have column_fields => Courses.*

Rather, the column_tables has the Courses portion, and column_fields is just *