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   
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-10-29 04:42:17 EDT Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---
Bug Depends On:    
Bug Blocks: 473303    
Description Flags
patch to fix none

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

Description of problem:
BITXOR behaves the same as BITOR

Version-Release number of selected component (if applicable):
Comment 1 Jesse Keating 2009-10-21 18:02:44 EDT
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 05:21:59 EDT
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 13:58:31 EDT
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 04:42:17 EDT
available in dist-f12