Bug 517839

Summary: bitxor and bitor both mapped to single bitor function
Product: [Fedora] Fedora Reporter: Caolan McNamara <caolanm>
Component: hsqldbAssignee: Deepak Bhole <dbhole>
Status: CLOSED RAWHIDE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: low    
Version: rawhideCC: dbhole, dcantrell, dwmw2, fnasser, jprindiv, notting
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-10-29 08:42:17 UTC Type: ---
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: 473303    
Attachments:
Description Flags
patch to fix none

Description Caolan McNamara 2009-08-17 12:55:02 UTC
Created attachment 357648 [details]
patch to fix

Description of problem:
BITXOR behaves the same as BITOR

Version-Release number of selected component (if applicable):
hsqldb-1.8.0.10-2.fc11.i586

Comment 1 Jesse Keating 2009-10-21 22:02:44 UTC
Caolan, what does this break, and in what way is this a blocker, that we should delay the release for?

Comment 2 Caolan McNamara 2009-10-22 09:21:59 UTC
It breaks openoffice.org base, 
e.g. open an openoffice.org database, open a table that has an ID column.  Make a
column called "BID".  Go to Tools-SQL and run:
update "Events" set BID = BITXOR(ID, 1)
This will behave as:
update "Events" set BID = BITOR(ID, 1)
i.e. BITXOR incorrectly behaves as BITOR

Without the fix we're out of sync with vanilla OpenOffice.org 3.1.1. The patch is safe and was logged two months ago here in order to be possible to meet the blocker target easily

Comment 3 Jesse Keating 2009-10-22 17:58:31 UTC
http://koji.fedoraproject.org/koji/taskinfo?taskID=1763415 has the patches.  Please test and if good, request tagging for F12.

Comment 4 Caolan McNamara 2009-10-29 08:42:17 UTC
available in dist-f12