Apache OpenOffice (AOO) Bugzilla – Issue 103528
SQL BITXOR behaves as BITOR
Last modified: 2017-05-20 11:42:03 UTC
To reproduce: Open a 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) (BITXOR behaves as BITOR)
Confirmed w/ 3.0.1 and DEV310m_15 Attaching bug doc - see sample queries
Created attachment 63534 [details] bug doc with example queris showing bitor, bitxor
assign to developer set intitial target
well, about time isn't it.
fs->atjensen: Did you intentionally assign this to yourself?
Sure - Assuming that's allowed. Ocke's on vacation - so Looked over the source file and it seems to be a simple typo in the libarary.java file .... functionMap.put("bitor", bitor); functionMap.put("bitxor", bitor); .... Checked that there is actually a bitxor function in the file - there is and it looks correct - I will go ahead and rebuiild a jar file here with what looks like a line (character) fix .... functionMap.put("bitor", bitor); functionMap.put("bitxor", bitxor); .... and if all works, attach a diff file to the issue. (don't worry I won't make a habit of this)
ah, great, no problem with this - thanks!
Changing the one line does seem to fix this issue and not to break anything else. Attached patch file. (probably not exactly the type of file you wanted - but hopefully it is ok)
Created attachment 63581 [details] patch file
ah, that's rather embaressing - seems that patch is backwards, isn't it...
Created attachment 63584 [details] the correct change
Fixed in cws dba32f
Adding cc
set target.
Please verify. Thanks. Before the patch the result for bitor and bitxor was the same.
Thanks, guys. Who verifies? Where do I get the patched version? Or do I just wait for OOo3.2?
Our QA verifies the issue in the CWS where it was fixed (http://wiki.services.openoffice.org/wiki/ChildWorkSpace). When the CWS gets approved by QA, it will be integrated into master builds, so one of the upcoming development milestones from http://download.openoffice.org/next/index.html will contain the fix.
add keyword new_implementation
forget the last comment about the new implementation verified in CWS dba32f find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32f
For the record, the fix is now included in the fix for bug 121754.