Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Database is not accessible after rename tables | ||||||
---|---|---|---|---|---|---|---|
Product: | Base | Reporter: | helenrussian | ||||
Component: | code | Assignee: | marc.neumann | ||||
Status: | CLOSED FIXED | QA Contact: | issues@dba <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P2 | CC: | frank.schoenheit, issues, kpalagin, mechtilde, rb.henschel | ||||
Version: | OOo 3.0 RC3 | Keywords: | oooqa, regression, release_blocker | ||||
Target Milestone: | OOo 3.0 | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Issue Depends on: | |||||||
Issue Blocks: | 88888 | ||||||
Attachments: |
|
Description
helenrussian
2008-09-29 15:52:52 UTC
Created attachment 56902 [details]
testbase
How do you create your database? Please give a step-by-step description. The status bar shows me "JDBC". It must show something with HSQL. So I can't see which database backend you use. Confirm bug. OO.o 3.0 RC1 @mechtilde
> Please give a step-by-step description.
Run OOo Base.
In Wizard select «Create a new database» - > Finish
Save the database As Base4.odb -> OK.
New database opens.
Switch to the «Tables» container
Select «Create Table in Design View...»
Enter names for first field as «text1» and second field as «text2». Types field
leaves as default «Text [Varchar]».
Save table. Enter name table as «Table1» -> OK
To ask «Should be a primary Key?» select «Yes»
Close table.
Close OOo Base.
Run OOo Base.
In Wizard select «Open an existing database file», in «Recently used» Base4 ->
Finish.
Base4.odb opens (status bar shows "HSQL" yet).
Switch to the «Tables» container. Look «table1».
Select «table1», right mouse click select «Rename». Rename table «table1» ->
«table12». OK.
Save Base4.odb, Close OOo Base.
Run OOo Base.
In Wizard select «Open an existing database file», in «Recently used» Base4 - >
Finish.
Base4.odb opens (status bar shows "JDBC").
Switch to the «Tables» container.
Look Error message.
> How do you create your database?
OO.o Base - > Database Wizard -> Create a new database - > (Next) -> (Finish)
(use OO.o database format)
Save file
Tables - > Create table in Design View - > ......
Close OO.o
ReOpen attached database.
Rename any tables.
Save and close the database.
Open the database document again.
Switch to the "Tables" container.
I can reproduce the error as described with German OOo3.0RC3 on WinXP. It happens also with existing database with embedded HSQL. Rename table, save, close, reopen. Typ has changes to JDBC. The content.xml is empty. Files have wrong time. I can reproduce it with RC3 under Debian sigh ... for the record: The bug is present in DEV300m20 already, but not in DEV300m15. Not sure when it was introduced, though ... Thanks for taking this one. fixed in CWS dba30y. Builds running. Note: issue 94455 is the DEV300-version of this issue. We fixed the problem on the OOO300 branch with a less-than-optimal solution, but will provide a better fix for 3.1. fs->msc: please verify in CWS dba30y fs: Does your comment about issue 94455 mean that this CWS (dba30y) may not or even must not get cloned for DEV300 workspace? If so, please state that in an CWS comment, as per default all OOO300-childworkspaces get cloned for DEV300. verified in CWS dba30z 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=OOO300%2Fdba30z fs->rt: yes, you're right, the CWS is not intended for DEV300. Sorry, planned to add a note in EIS, but got distracted by some meetings ... :-\ FYI, it's reproductible on RC3 MacOSX Native. verified in OOO300_m9 -> closed |