Issue 115072 - OOo crash when Base connected to text file ad run one query
Summary: OOo crash when Base connected to text file ad run one query
Status: CLOSED DUPLICATE of issue 114770
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO330m9
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-15 08:52 UTC by r4zoli
Modified: 2010-10-15 10:35 UTC (History)
2 users (show)

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

Attachments
zipped csv and odb file (2.61 KB, application/octet-stream)
2010-10-15 08:54 UTC, r4zoli 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description r4zoli 2010-10-15 08:52:38 UTC 
This is an issue OOO330m10, not m9, the m10 is missing version. This happens on
win7, and only tested on it.

odb file connected to csv file, which contain id and dates in ISO format.

if you run query: SELECT "dates".*, YEAR( "date" ) FROM "dates" OOo crash.
If I run: SELECT YEAR( "date" ) FROM "dates", then runs without problem.
If I run: SELECT *, YEAR( "date" ) FROM "dates" it gives syntax error.

This not happens in OOo 3.2.1 regression (in this case similar results,
exception in first case the YEAR("dates") create empty result sets.
Possibly blocker. 

Error report:  r2dn36n

Assign developer.
Comment 1 r4zoli 2010-10-15 08:54:46 UTC 
Created attachment 72056 [details]
zipped csv and odb file
Comment 2 Frank Schönheit 2010-10-15 10:18:41 UTC 
sounds like a duplicate of issue 114770, fixed for 3.4 in CWS dba34a. The only
thing which confuses me is that you claim the bug does not happen in m9.
Comment 3 ocke.janssen 2010-10-15 10:30:50 UTC 
I just tested a m6 in crashes as well.
Comment 4 r4zoli 2010-10-15 10:31:36 UTC 
No.
I can not report it as m10 because no such version can be selected in issue
tracker. 
And yes it is duplicate of that issue. 

*** This issue has been marked as a duplicate of 114770 ***
Comment 5 r4zoli 2010-10-15 10:32:22 UTC 
duplicate -> Closing.
Comment 6 ocke.janssen 2010-10-15 10:35:03 UTC 
So closing.