| Summary: | Embedded Firebird - Table can not renamed with the Gui | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Ulf <ulger> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTOURBUG | ||
| Severity: | normal | CC: | iplaw67, lionel, mapopa, robert, serval2412 |
| Priority: | medium | ||
| Version: | 5.0.0.0.alpha0+ Master | ||
| Hardware: | Other | ||
| OS: | All | ||
| URL: | http://www.firebirdfaq.org/faq363/ | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | screen shot | ||
I could confirm renaming of a firebird-table doesn't work. I have had a look at the description of Firebird and I didn't found any command like ALTER TABLE "table" RENAME TO "new_table"; So this doesn't seem to be a special LO - embedded firebird - bug. Could be someone else does know more about it. I would set this bug to "NOTOURBUG" ... Popa/Lionel: Noticing https://gerrit.libreoffice.org/#/c/15026/ and knowing there's an onprogress work to complete Firebird implementation, any thought? Confirmed by Robert ==>> NEW Also confirming on Version: 4.4.3.2 Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16 Locale : fr_ OSX 10.10.3 The Table object of the Firebird driver explicitly does not provide the com::sun::star::sdbcx::XRename interface, with a comment: // Firebird doesn't support this. Which suggests that table renaming is not supported in Firebird. Marius, if you could verify this and: 1) If it is true, then close this bug as NOTOURBUG (or WONTVFIX?). 2) Else, implement Table::rename and remove the line that "unsupports" com.sun.star.sdbcx.XRename in Table::queryInterface According to http://www.firebirdfaq.org/faq363/ and http://tracker.firebirdsql.org/browse/CORE-2486 (which depends on another issue, http://tracker.firebirdsql.org/browse/CORE-1015), it's not possible. BTW, the tracker shows no activity since 2011 (!!) About proposed options in FAQ, I think the first one may be quite slow if we've got a big table to rename, the second one is more than dirty (you don't rename the table, you use a view which uses the table). IMHO, we should consider this one as NOTOURBUG ("their enhancement") Thanks Julien for the research. Closing. |
Created attachment 115659 [details] screen shot Please open attached screen shot from a right-click on a table. I use the embedded Firebird Database and want to rename the table, but the <Rename> Button is missing. This works with the embedded HSQLDB I use Win 8.1 and attached a screen shot This is also in 4.4.3.1