Issue 73710 - Base crash when importing data to fixed length text
Summary: Base crash when importing data to fixed length text
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.1
Hardware: PC Linux, all
: P2 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks: 20748
  Show dependency tree
 
Reported: 2007-01-21 14:58 UTC by jeanluc_thiebaut
Modified: 2008-03-12 09:35 UTC (History)
1 user (show)

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

Attachments
zip contains calc source & odb destination (table1 crash) (10.83 KB, text/plain)
2007-01-21 15:09 UTC, jeanluc_thiebaut 		no flags Details
error report generated when using the 2 files from 73710_example.zip (11.02 KB, text/plain)
2007-01-21 15:14 UTC, jeanluc_thiebaut 		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 jeanluc_thiebaut 2007-01-21 14:58:51 UTC 
1. a calc sheet that contains at least a column with fixed length text (n). 
2. an odb document with an existing table that contains a fixed length field
   a CHAR(n), not a VARCHAR(n)
3. Select and Copy  data from calc sheet
4. Paste in the odb document into the existing table;
   option : add data; check columns are corresponding calc <-> base
5. Result is unexpected crash in OpenOffice.org + recovery + error reporting,...

This occurs in Linux (Mandriva 2007.0). 
Under Windows, there is no crash, but data are not imported.

Misc Info  : 
- French Ooo version 2.1
- database type is HSQLDB
- tried with different fixed lengths and also 
  with fixed length in odb > length in calc (ex. 3 > 2)
Comment 1 jeanluc_thiebaut 2007-01-21 15:09:15 UTC 
Created attachment 42356 [details]
zip contains calc source & odb destination (table1 crash)
Comment 2 jeanluc_thiebaut 2007-01-21 15:14:26 UTC 
Created attachment 42357 [details]
error report generated when using the 2 files from 73710_example.zip
Comment 3 Frank Schönheit 2007-01-23 14:31:16 UTC 
as a crash, it's usually a P2 ...
Comment 4 Frank Schönheit 2007-01-25 13:25:42 UTC 
fs->oj: duplicate of issue 69831?
Comment 5 jeanluc_thiebaut 2007-01-27 06:32:53 UTC 
-> fs: not a duplicate for me. I've tried to import varchar and boolean 
       from calc to base without problem. I've used "i69831.odb" as destination
       and a calc sheet with text and boolean such as "Name", True.
       I didn't try to import "Name", Y. Boolean -> boolean; not text -> boolean.
Comment 6 Frank Schönheit 2007-01-29 07:51:04 UTC 
fs->jeanluc_thiebaut: yes, the descriptions are different, but I was more
talking about a "technical" duplicate - internally, the same things seem to
happen ...
Nonetheless, thanks for reporting back.
Comment 7 ocke.janssen 2007-08-03 09:13:18 UTC 
Fixed in cws dba24a.
Comment 8 Frank Schönheit 2007-09-03 11:18:44 UTC 
targeting to 2.4, since the fix is part of a CWS aiming for this release
Comment 9 ocke.janssen 2007-09-05 13:22:38 UTC 
Please verify. Thanks.
Comment 10 marc.neumann 2007-09-21 12:34:51 UTC 
verified in CWS dba24a

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=SRC680%2Fdba24a
Comment 11 drewjensen.inbox 2008-03-12 09:35:35 UTC 
Tested w/ Kubuntu 7.1, OOo m_10

closing