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
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.