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

Option Update error #17

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Execute SELECT pl_namespace,pl_title FROM `pagelinks` WHERE pl_from = '1' 
FOR UPDATE

What is the expected output? What do you see instead?
I saw:
    [WHERE] => Array
        (
            [0] => Array
                (
                    [expr_type] => colref
                    [base_expr] => pl_from
                    [sub_tree] => 
                )

            [1] => Array
                (
                    [expr_type] => operator
                    [base_expr] => =
                    [sub_tree] => 
                )

            [2] => Array
                (
                    [expr_type] => const
                    [base_expr] => '1'
                    [sub_tree] => 
                )

            [3] => Array
                (
                    [expr_type] => reserved
                    [base_expr] => UPDATE
                    [sub_tree] => 
                )
        )

But i was expecting:
    [WHERE] => Array
        (
            [0] => Array
                (
                    [expr_type] => colref
                    [base_expr] => pl_from
                    [sub_tree] => 
                )

            [1] => Array
                (
                    [expr_type] => operator
                    [base_expr] => =
                    [sub_tree] => 
                )

            [2] => Array
                (
                    [expr_type] => const
                    [base_expr] => '1'
                    [sub_tree] => 
                )
        )

What version of the product are you using? On what operating system?
I am running Ubuntu 11.10. And using the version in the site in the Dec 7 2010

Please provide any additional information below.

Original issue reported on code.google.com by gchi...@gmail.com on 7 Dec 2011 at 1:51

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 
Try the current version.

Original comment by pho...@gmx.de on 13 Mar 2012 at 12:08