Description of problem:
VMs search option (UI). doesn't work. Getting SQL error.

In UI trying to find a VM among 100 Vms. Giving its name in search field does nothing. In engine log got the following error:

2013-08-25 17:05:55,586 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-6) Query SearchQuery failed. Exception message is StatementCallback; bad SQL grammar [SELECT * FROM (SELECT * FROM vms WHERE ( vm_guid IN (SELECT vms_with_tags.vm_guid FROM  vms_with_tags   WHERE  (  vms_with_tags.guest_cur_user_name LIKE '%clone%' OR  vms_with_tags.vm_name LIKE '%clone%' OR  vms_with_tags.quota_name LIKE '%clone%' OR  vms_with_tags.vm_pool_name LIKE '%clone%' OR  vms_with_tags.vm_ip LIKE '%clone%' OR  vms_with_tags.vm_host LIKE '%clone%' OR  vms_with_tags.vm_os LIKE '%clone%' OR  vms_with_tags.run_on_vds_name LIKE '%clone%' OR  vms_with_tags.storage_pool_name LIKE '%clone%' OR  vms_with_tags.vds_group_name LIKE '%clone%' OR  vms_with_tags.vm_comment LIKE '%clone%' OR  vms_with_tags.vm_domain LIKE '%clone%' OR  vms_with_tags.tag_name LIKE '%clone%' ) ))  ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer ~~ unknown
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 399


Other searches like stprage,DC,cluster,host - works fine. The problem only in VMs. Reproduced on several setups.




How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info: