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

"WHERE id>1" not parsed correctly #7

Closed
GoogleCodeExporter opened this issue Jan 28, 2016 · 3 comments
Closed

"WHERE id>1" not parsed correctly #7

GoogleCodeExporter opened this issue Jan 28, 2016 · 3 comments

Comments

@GoogleCodeExporter
Copy link

What steps will reproduce the problem?
1. parse a query like "SELECT * FROM test WHERE id>1"

What is the expected output? What do you see instead?

Expected output is:

[WHERE] => Array ( 
    [0] => Array ( [expr_type] => colref [base_expr] => id [sub_tree] => ) 
    [1] => Array ( [expr_type] => operator [base_expr] => >  [sub_tree] => ) 
    [2] => Array ( [expr_type] => const [base_expr] => 1 [sub_tree] => ) 
) 

Instead we get: 

[WHERE] => Array ( 
    [0] => Array ( [expr_type] => colref [base_expr] => id [sub_tree] => ) 
    [1] => Array ( [expr_type] => colref [base_expr] => >1 [sub_tree] => ) 
)

What version of the product are you using? On what operating system?

I tested this with revision 36 on linux. Works ok with "WHERE id > 1"


Original issue reported on code.google.com by sophie.s...@gmail.com on 4 Apr 2011 at 12:52

@GoogleCodeExporter
Copy link
Author

Thank you for your report.  

Original comment by greenlion@gmail.com on 22 Apr 2011 at 4:29

  • Changed state: Accepted
  • Added labels: Component-Logic, Usability

@GoogleCodeExporter
Copy link
Author

This is fixed in my latest SVN checkin.

Added to test to t/gtltop.php 

Original comment by greenlion@gmail.com on 22 Apr 2011 at 5:50

  • Changed state: Verified

@GoogleCodeExporter
Copy link
Author

Thank you

Original comment by sophie.s...@gmail.com on 9 May 2011 at 5:24

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant