Issue 118670 - Base crashes when connected to Spreadsheet and "SELECT DISTINCT" used
Summary: Base crashes when connected to Spreadsheet and "SELECT DISTINCT" used
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 3.4.0 Beta (OOo)
Hardware: PC Windows 7
: P3 Normal with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-12-06 14:55 UTC by r4zoli
Modified: 2013-11-28 07:32 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description r4zoli 2011-12-06 14:55:25 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:
Comment 1 hatsebutz 2013-11-07 17:11:01 UTC
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:
0x1e543208 connectivity::file::OResultSet::sortRows() + 344
0x1e544faf connectivity::file::OResultSet::OpenImpl() + 2655
0x1e556ae1 connectivity::file::OPreparedStatement::initResultSet() + 209
0x1e556bdb connectivity::file::OPreparedStatement::executeQuery() + 59
Comment 2 bubikolramios 2013-11-28 07:32:06 UTC
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.
  Locale ID:	1060
  Additional Information 1:	20fc
  Additional Information 2:	20fc896ac688798692f3d6a9f5b6e57a
  Additional Information 3:	c7b5
  Additional Information 4:	c7b507b93669769102439138ced89f20