Bug 821043

Summary: XMLRPC fault - Malformed sql query
Product: [Community] Bugzilla Reporter: Pavel Slama <pslama>
Component: WebServiceAssignee: Simon Green <sgreen>
Status: CLOSED DUPLICATE QA Contact:
Severity: high Docs Contact:
Priority: unspecified    
Version: develCC: ebaak, sgreen
Target Milestone: 4.2-1   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: 4.2.1-0.rc3 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-05-13 22:55:56 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 786624    
Attachments:
Description Flags
reproducer none

Description Pavel Slama 2012-05-11 15:52:21 UTC
Created attachment 583877 [details]
reproducer

Description of problem:
bugzilla.runQuery call faults with 'DBD::mysql::st execute failed: FUNCTION bugs.0AND does not exist

Version-Release number of selected component (if applicable):
devel

How reproducible:
100%

Steps to Reproduce:
reproducer script attached 


Actual results:
DBD::mysql::st execute failed: FUNCTION bugs.0AND does not exist 

* notice 0AND together in the statement

..(SELECT bug_id FROM flags INNER JOIN flagtypes ON flags.type_id = flagtypes.id WHERE INSTR(CONCAT(flagtypes.name, flags.status), \'jboss-brms-5.1.0\') > 0AND (flagtypes.view_group_id IS NULL..



Expected results:
no error

Additional info:

Comment 1 Simon Green 2012-05-13 22:55:56 UTC
Will be fixed in the next release (rc3)

*** This bug has been marked as a duplicate of bug 821155 ***