21815: Remove UUID and hash columns from trigram indexes

[arvados.git] / services / api / app / models / arvados_model.rb

diff --git a/services/api/app/models/arvados_model.rb b/services/api/app/models/arvados_model.rb
index 9ee2cca410effaba81fbb4ce9d207354c5f1b3f8..3bd0e942432567a571737e7b5bb422f30a944316 100644 (file)
--- a/services/api/app/models/arvados_model.rb
+++ b/services/api/app/models/arvados_model.rb
@@ -539,7 +539,8 @@ class ArvadosModel < ApplicationRecord
 
   def self.full_text_searchable_columns
     self.columns.select do |col|
-      [:string, :text, :jsonb].include?(col.type)
+      [:string, :text, :jsonb].include?(col.type) and
+      col.name !~ /(^|_)(hash|uuid)$/
     end.map(&:name)
   end