Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

doesn't support sql parameter in set clause #202

Closed
18025341316 opened this issue Aug 15, 2018 · 2 comments
Closed

doesn't support sql parameter in set clause #202

18025341316 opened this issue Aug 15, 2018 · 2 comments
Assignees
Labels
enhancement kind/support A request for adding support
Milestone

Comments

@18025341316
Copy link

18025341316 commented Aug 15, 2018

When use parser to parse the sql like this:

  update tbl_customer t set t.`description`=:yp where t.id=1;

the parser failed.it seems the parser cann't handle sql parameter in the SET sub-clause.

@18025341316 18025341316 changed the title doesn't support use parameter in set clause doesn't support sql parameter in set clause Aug 15, 2018
@18025341316
Copy link
Author

18025341316 commented Aug 15, 2018

Here is the error message:

 [0] => Array
                                (
                                    [file] => C:\...\sqlparser\src\Components\SetOperation.php
                                    [line] => 117
                                    [function] => error
                                    [class] => PhpMyAdmin\SqlParser\Parser
                                    [type] => ->
                                    [args] => Array
                                        (
                                            [0] => Missing expression.
                                            [1] => PhpMyAdmin\SqlParser\Token Object
                                                (
                                                    [token] => :yp
                                                    [value] => yp
                                                    [keyword] => 
                                                    [type] => 8
                                                    [flags] => 16
                                                    [position] => 42
                                                )

                                        )

                                )

@jochendaum
Copy link

jochendaum commented Sep 25, 2018

I have the same problem. Last working version is 4.2.1

@williamdes williamdes added the bug label Apr 21, 2023
@williamdes williamdes added enhancement kind/support A request for adding support and removed bug labels Apr 21, 2023
MauricioFauth added a commit to MauricioFauth/sql-parser that referenced this issue Sep 26, 2023
- Fixes phpmyadmin#202
- Fixes phpmyadmin#412
- Fixes phpmyadmin#492
- Closes phpmyadmin#499
- Related to phpmyadmin#172

Signed-off-by: Maurício Meneghini Fauth <mauricio@fauth.dev>
@MauricioFauth MauricioFauth self-assigned this Sep 27, 2023
@MauricioFauth MauricioFauth added this to the 5.9.0 milestone Sep 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement kind/support A request for adding support
Projects
None yet
Development

No branches or pull requests

4 participants