IFNULL(<Column Name>,<Value>) doesn't parsed properly about php-sql-parser

[GoogleCodeExporter]

Please use the current version of the parser (see 
http://code.google.com/p/php-sql-parser/wiki/Downloads). The parameters of a 
function are always separated by comma, so the builder will recreate the 
statement correctly.

Here is the output of the current version:

[WHERE] => Array
        (
            [0] => Array
                (
                    [expr_type] => function
                    [base_expr] => ifnull
                    [sub_tree] => Array
                        (
                            [0] => Array
                                (
                                    [expr_type] => colref
                                    [base_expr] => col_name
                                    [no_quotes] => Array
                                        (
                                            [delim] => 
                                            [parts] => Array
                                                (
                                                    [0] => col_name
                                                )

                                        )

                                    [sub_tree] => 
                                )

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

                        )

                )

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

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

        )

As you can see, the function has a subtree with two elements, which are 
separated by comma implicitly.

Original comment by [email protected] on 11 Sep 2014 at 6:54

• Changed state: WontFix