Apache OpenOffice (AOO) Bugzilla – Issue 43526
Copy and Paste of text data in mysql db table crashes OOo
Last modified: 2006-05-31 14:29:06 UTC
Hi, Open up a mysql linked ODB document. Click on the Tables button, then navigate the hierarchy of tables (table tree view). Double click on a table to display the data. Navigate to any cell in the table containing text in a VARCHAR field. Press Ctrl-Del to cut the data, then navigate to another VARCHAR field of equal or greater length. Press Ctrl-Ins. Move up one row. Attempt to repeat the operation. OOo segfaults and dies. This is repeatable. Using m77, and MyODBC 3.51.09.
setting oooqa keyword
setting crash keyword
correct prio to 3 see http://www.openoffice.org/scdocs/ddIssues_EnterModify.html#priority for details.
hi, P3 says that it crashes only in exception circumstances. I see nothing exceptional about the circumstances I have described. This should be at least P2, but I set it to P1 because it means you can not test the module's functionality completely. Filling in data in the way described is basic functionality of the dba module, or ins't it ? alex
cannot reproduce - Alex, do you mind attaching a mysqldump of the table in question?
Just tried with beta 2.0 and MyODBC 3.51.11 Problem still occurs. Enclosing sql create statement, and the table only contains one row of data. If I try copying a value from one column to another of the same type in the same row, then hit the Cursor Down key, OOo crashes. Repeatable. CREATE TABLE `test_oa_calcul` ( `action_id` int(10) unsigned NOT NULL auto_increment, `action_type_id` tinyint(3) unsigned NOT NULL default '0', `action_date` date NOT NULL default '0000-00-00', `time_limit` tinyint(4) default NULL, `final_date` date default '0000-00-00', `add_period` tinyint(4) default NULL, `new_final_date` date default NULL, `case_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`action_id`) ) TYPE=MyISAM Single Data row : select * from test_oa_calcul; +-----------+----------------+-------------+------------+------------+------------+----------------+---------+ | action_id | action_type_id | action_date | time_limit | final_date | add_period | new_final_date | case_id | +-----------+----------------+-------------+------------+------------+------------+----------------+---------+ | 1 | 1 | 2003-04-24 | 4 | NULL | 4 | NULL | 2 | +-----------+----------------+-------------+------------+------------+------------+----------------+---------+ alex
reproducible. Hmm, me thinks I didn't try Linux before (sorry, I tend to overlook the "OS" field :-\ )
accepting
duplicate of issue 44333. Though the table structures are different, the fix for issue 44333 also fixes this one here. *** This issue has been marked as a duplicate of 44333 ***
re-opening for verification by QA
fs-> msc: please verify in CWS dba25
fixed in CWS dba25 *** This issue has been marked as a duplicate of 44333 ***
hi, verified in cws dba25 Bye Marc
close duplicate