| 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) | ||
[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.
)