Apache OpenOffice (AOO) Bugzilla – Issue 118670
Base crashes when connected to Spreadsheet and "SELECT DISTINCT" used
Last modified: 2013-11-28 07:32:06 UTC
If OOo Base 3.4Beta is connected to a spreadsheet, if you perform any SQL query that has "DISTINCT" in it, it will crash OOo. The crash not happens in OOo 3.3, same crash happens in LibO 3.4.4 see: https://bugs.freedesktop.org/show_bug.cgi?id=43479
Confirm: Openoffice 4.0.1 on Win, Openoffice 4.0.0 on Mac OS X 10.9: OOo Base with xls spreadsheet, as soon as a (simple) query with "SELECT DISTINCT ..." is performed, it crashes. Mac OS X: Exception Type: EXC_BAD_ACCESS (SIGBUS) Exception Codes: KERN_PROTECTION_FAILURE at 0x0000000000000012 Thread 0 Crashed:: Dispatch queue: com.apple.main-thread 0x1e543208 connectivity::file::OResultSet::sortRows() + 344 0x1e544faf connectivity::file::OResultSet::OpenImpl() + 2655 0x1e556ae1 connectivity::file::OPreparedStatement::initResultSet() + 209 0x1e556bdb connectivity::file::OPreparedStatement::executeQuery() + 59 [...]
Win 7 Problem signature: Problem Event Name: BEX Application Name: soffice.bin Application Version: 4.0.9714.500 Application Timestamp: 5237a093 Fault Module Name: MSVCR90.dll Fault Module Version: 9.0.30729.6161 Fault Module Timestamp: 4dace5b9 Exception Offset: 0006ccd5 Exception Code: c0000417 Exception Data: 00000000 OS Version: 6.1.7601.2.1.0.256.48 Locale ID: 1060 Additional Information 1: 20fc Additional Information 2: 20fc896ac688798692f3d6a9f5b6e57a Additional Information 3: c7b5 Additional Information 4: c7b507b93669769102439138ced89f20