search

chenster / 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

unparsed ref_clause on join #20

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
SELECT * FROM SURVEYS inner join SURVEYS_LANGUAGESETTINGS on 
(surveyls_survey_id=sid and surveyls_language=language) WHERE sid=74191

returns in the FROM clause:

[FROM] => Array
        (
            [0] => Array
                (
                    [table] => SURVEYS
                    [alias] => SURVEYS
                    [join_type] => JOIN
                    [ref_type] => 
                    [ref_clause] => 
                    [base_expr] => 
                    [sub_tree] => 
                )

            [1] => Array
                (
                    [table] => SURVEYS_LANGUAGESETTINGS
                    [alias] => SURVEYS_LANGUAGESETTINGS
                    [join_type] => JOIN
                    [ref_type] => ON
                    [ref_clause] => surveyls_survey_id=sid and surveyls_language=language
                    [base_expr] => 
                    [sub_tree] => 
                )

        )

Can you parse the ref_clause, that I will have colrefs?

Thanks a lot
Andre

Original issue reported on code.google.com by pho...@gmx.de on 20 Jan 2012 at 1:00

GoogleCodeExporter commented 8 years ago 
Solved in current version on http://www.phosco.info/php-sql-parser_current.zip

Original comment by pho...@gmx.de on 3 Feb 2012 at 1:02

GoogleCodeExporter commented 8 years ago 
Accepted fixed codebase.

Original comment by greenlion@gmail.com on 12 Mar 2012 at 10:54