##// END OF EJS Templates
jro_apps » redmine
RSS
Cast as decimal(30,0) instead of integer (#21249)....
Jean-Philippe Lang -
r15815:14a98af864c1
parent child
Show More
Side by Side Unified
Context file:
r15815:14a98af864c1 Loading diff...:
Show file before | Show file after | Hide comments
@@ -976,7 +976,7 class Query < ActiveRecord::Base
976 976 "#{queried_table_name}.id #{not_in} IN (" +
977 977 "SELECT customized_id FROM #{CustomValue.table_name}" +
978 978 " WHERE customized_type='#{queried_class}' AND custom_field_id=#{custom_field_id}" +
979 " AND value <> '' AND CAST(value AS integer) IN (" +
979 " AND CAST(CASE value WHEN '' THEN '0' ELSE value END AS decimal(30,0)) IN (" +
980 980 " SELECT customized_id FROM #{CustomValue.table_name}" +
981 981 " WHERE customized_type='#{target_class}' AND custom_field_id=#{chained_custom_field_id}" +
982 982 " AND #{sql_for_field(field, operator, value, CustomValue.table_name, 'value')}))"
@@ -998,7 +998,7 class Query < ActiveRecord::Base
998 998 "#{queried_table_name}.id #{not_in} IN (" +
999 999 "SELECT customized_id FROM #{CustomValue.table_name}" +
1000 1000 " WHERE customized_type='#{queried_class}' AND custom_field_id=#{custom_field_id}" +
1001 " AND value <> '' AND CAST(value AS integer) IN (" +
1001 " AND CAST(CASE value WHEN '' THEN '0' ELSE value END AS decimal(30,0)) IN (" +
1002 1002 " SELECT id FROM #{target_table_name} WHERE #{sql_for_field(field, operator, value, filter[:field].format.target_class.table_name, attribute)}))"
1003 1003 end
1004 1004
General Comments 0
You need to be logged in to leave comments. Login now