39991.patch - Redmine

Defect #39991 » 39991.patch

Go MAEDA, 2024-01-01 06:08

           sql += " OR #{db_table}.#{db_field} = ''" if is_custom_filter || [:text, :string].include?(type_for(field))
         when "*"
           sql = "#{db_table}.#{db_field} IS NOT NULL"
           sql += " AND #{db_table}.#{db_field} <> ''" if is_custom_filter
           sql += " AND #{db_table}.#{db_field} <> ''" if is_custom_filter || [:text, :string].include?(type_for(field))
         when ">="
           if [:date, :date_past].include?(type_for(field))
             sql = date_clause(db_table, db_field, parse_date(value.first), nil, is_custom_filter)

         assert issues.all? {|i| i.custom_field_value(2).blank?}
       end
       def test_operator_none_for_text
       def test_operator_none_for_blank_text
         query = IssueQuery.new(:name => '_')
         query.add_filter('status_id', '*', [''])
         query.add_filter('description', '!*', [''])
-...
         assert_equal [11, 12], issues.map(&:id).sort
       end
       def test_operator_any_for_blank_text
         Issue.where(id: [1, 2]).update_all(description: '')
         query = IssueQuery.new(:name => '_')
         query.add_filter('status_id', '*', [''])
         query.add_filter('description', '*', [''])
         assert query.has_filter?('description')
         issues = find_issues_with_query(query)
         assert issues.any?
         assert issues.all? {|i| i.description.present?}
         assert_empty issues.map(&:id) & [1, 2]
       end
       def test_operator_all
         query = IssueQuery.new(:project => Project.find(1), :name => '_')
         query.add_filter('fixed_version_id', '*', [''])

(2-2/2)