Frank Kobzik has uploaded a new change for review.
Change subject: core: adjust test for searchquery
......................................................................
core: adjust test for searchquery
...when sorting by ip
Change-Id: I536f4fe82e2fde6057a032f943429373f24e50ad
Signed-off-by: Frantisek Kobzik <fkob...@redhat.com>
---
M
backend/manager/modules/searchbackend/src/test/java/org/ovirt/engine/core/searchbackend/SyntaxCheckerTest.java
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/81/38581/1
diff --git
a/backend/manager/modules/searchbackend/src/test/java/org/ovirt/engine/core/searchbackend/SyntaxCheckerTest.java
b/backend/manager/modules/searchbackend/src/test/java/org/ovirt/engine/core/searchbackend/SyntaxCheckerTest.java
index 72b118a..78c9c2d 100644
---
a/backend/manager/modules/searchbackend/src/test/java/org/ovirt/engine/core/searchbackend/SyntaxCheckerTest.java
+++
b/backend/manager/modules/searchbackend/src/test/java/org/ovirt/engine/core/searchbackend/SyntaxCheckerTest.java
@@ -187,7 +187,7 @@
"SELECT * FROM (SELECT * FROM vms WHERE ( vm_guid IN (SELECT
distinct vms_with_tags.vm_guid FROM vms_with_tags WHERE (
vms_with_tags.description LIKE '%mac=00:1a:4a:d4:53:94%' OR
vms_with_tags.free_text_comment LIKE '%mac=00:1a:4a:d4:53:94%' OR
vms_with_tags.guest_cur_user_name LIKE '%mac=00:1a:4a:d4:53:94%' OR
vms_with_tags.quota_name LIKE '%mac=00:1a:4a:d4:53:94%' OR
vms_with_tags.run_on_vds_name LIKE '%mac=00:1a:4a:d4:53:94%' OR
vms_with_tags.storage_pool_name LIKE '%mac=00:1a:4a:d4:53:94%' OR
vms_with_tags.tag_name LIKE '%mac=00:1a:4a:d4:53:94%' OR
vms_with_tags.vds_group_name LIKE '%mac=00:1a:4a:d4:53:94%' OR
vms_with_tags.vm_fqdn LIKE '%mac=00:1a:4a:d4:53:94%' OR vms_with_tags.vm_host
LIKE '%mac=00:1a:4a:d4:53:94%' OR vms_with_tags.vm_ip LIKE
'%mac=00:1a:4a:d4:53:94%' OR vms_with_tags.vm_name LIKE
'%mac=00:1a:4a:d4:53:94%' OR vms_with_tags.vm_pool_name LIKE
'%mac=00:1a:4a:d4:53:94%' ) )) ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMI!
T 0");
// Testing that in case that function is used in the ORDER BY clause
then no DISTINCT is generated
testValidSql("Vms: SORTBY IP DESC",
- "SELECT * FROM ((SELECT vms.* FROM vms ) ORDER BY
fn_get_comparable_ip_list(vm_ip) DESC NULLS LAST,vm_name ASC ) as T1 OFFSET (1
-1) LIMIT 0");
+ "SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY
vm_ip_inet_array DESC NULLS LAST,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 0");
}
--
To view, visit https://gerrit.ovirt.org/38581
To unsubscribe, visit https://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I536f4fe82e2fde6057a032f943429373f24e50ad
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Frank Kobzik <fkob...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
