diff options
Diffstat (limited to 'test/unit/query_test.rb')
| -rw-r--r-- | test/unit/query_test.rb | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/test/unit/query_test.rb b/test/unit/query_test.rb index 55a67f26a..633edebb1 100644 --- a/test/unit/query_test.rb +++ b/test/unit/query_test.rb @@ -130,6 +130,21 @@ class QueryTest < ActiveSupport::TestCase assert query.statement.include?("CAST(custom_values.value AS decimal(60,3)) <= 30") find_issues_with_query(query) end + + def test_operator_between + query = Query.new(:project => Project.find(1), :name => '_') + query.add_filter('done_ratio', '><', ['30', '40']) + assert_include "#{Issue.table_name}.done_ratio BETWEEN 30 AND 40", query.statement + find_issues_with_query(query) + end + + def test_operator_between_on_custom_field + f = IssueCustomField.create!(:name => 'filter', :field_format => 'int', :is_filter => true, :is_for_all => true) + query = Query.new(:project => Project.find(1), :name => '_') + query.add_filter("cf_#{f.id}", '><', ['30', '40']) + assert_include "CAST(custom_values.value AS decimal(60,3)) BETWEEN 30 AND 40", query.statement + find_issues_with_query(query) + end def test_operator_in_more_than Issue.find(7).update_attribute(:due_date, (Date.today + 15)) |