Eli Mesika has uploaded a new change for review.

Change subject: core: fix tests
......................................................................

core: fix tests

This fixes a test regression occurred while [1] was merged after [2] has
successful tests and was rebased and merged

[1] https://gerrit.ovirt.org/#/c/36946/
[2] https://gerrit.ovirt.org/#/c/38459/

Change-Id: I140abf53675a945088f75d671a4f48179fc5ab0d
Signed-off-by: emesika <[email protected]>
---
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/76/38576/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/38576
To unsubscribe, visit https://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I140abf53675a945088f75d671a4f48179fc5ab0d
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to