Description of problem: the Queries : "uptime < 1" or "uptime > 1" doesn't work. Version-Release number of selected component (if applicable): Red Hat Virtualization Manager Version: 4.1.0.1-0.1.el7 How reproducible: 100% Steps to Reproduce: 1.Select Vms Tab in webadmin 2.Type & select from autocomplete "Vms:uptime> or <" Actual results: The search hangs forever (because bad SQL query) Expected results: Additional info: error : Sun Jan 22 11:51:14 GMT+200 2017 org.ovirt.engine.ui.frontend.Frontend WARNING: Failure while invoking runQuery [StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms WHERE vms.elapsed_time < '86400' ) ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: column vms.elapsed_time does not exist Position: 58, StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms_* FROM vms WHERE vms_elapsed_time < '86400' ) ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org_postgresql_util_PSQLException: ERROR: column vms_elapsed_time does not exist Position: 58]
ugly SQL exception, should be fixed soon
This bug report has Keywords: Regression or TestBlocker. Since no regressions or test blockers are allowed between releases, it is also being identified as a blocker for this release. Please resolve ASAP.
*** This bug has been marked as a duplicate of bug 1416837 ***