alibaba / wasp

megastore-like system
http://alibaba.github.io/wasp/
Apache License 2.0
189 stars 80 forks source link

compare condition not working right #10

Closed colorant closed 11 years ago

colorant commented 11 years ago

" > acting as >= " " and <= acting as <"

As following:

wasp(main):044:0> query "select * from Photo where user_id>3" +----------+-----------+-----------+-----------+----------------+-------+ | user_id | photo_id | time | full_url | thumbnail_url | tag | +----------+-----------+-----------+-----------+----------------+-------+ | 5 | 501 | 20130728 | fullurl2 | thumburl2 | tag2 | | 6 | 601 | 20130728 | fullurl2 | thumburl2 | tag2 | +----------+-----------+-----------+-----------+----------------+-------+

wasp(main):045:0> query "select * from Photo where user_id<=6" +----------+-----------+-----------+-----------+----------------+-------+ | user_id | photo_id | time | full_url | thumbnail_url | tag | +----------+-----------+-----------+-----------+----------------+-------+ | 5 | 501 | 20130728 | fullurl2 | thumburl2 | tag2 | +----------+-----------+-----------+-----------+----------------+-------+

wasp(main):046:0> query "select * from Photo where user_id>5" +----------+-----------+-----------+-----------+----------------+-------+ | user_id | photo_id | time | full_url | thumbnail_url | tag | +----------+-----------+-----------+-----------+----------------+-------+ | 5 | 501 | 20130728 | fullurl2 | thumburl2 | tag2 | | 6 | 601 | 20130728 | fullurl2 | thumburl2 | tag2 | +----------+-----------+-----------+-----------+----------------+-------+

jaywong85 commented 11 years ago

thx for reporting. I have fix the bug already push the code .:)