Open a Firebird database. Go to Tables > Create View... Create a simple view of a table with the view (query) editor. Save the view. The editor will close automatically. The view won't be shown in the "Tables" section. Go to View > Refresh Tables and click on it. The view will be shown. Expected behavior: The vie will directly be shown after I have created it by the view. Refresh tables should only be needed for creating views (or tables) by Tools > SQL
On pc Debian x86-64 with master sources updated today, I could reproduce this. I noticed this on console: warn:dbaccess:180512:180512:dbaccess/source/ui/browser/genericcontroller.cxx:990: DBG_UNHANDLED_EXCEPTION in void dbaui::OGenericUnoController::OnAsyncCloseTask(void *) exception: com.sun.star.uno.RuntimeException message: unsatisfied query for interface of type com.sun.star.util.XCloseable!
Contrary to embedded hsqldb, with Firebird we enter in the if: 1408 // if we successfully saved a view we were creating, then close the designer 1409 if ( bSuccess && editingView() && !m_xAlterView.is() ) 1410 { 1411 closeTask(); 1412 } See https://opengrok.libreoffice.org/xref/core/dbaccess/source/ui/querydesign/querycontroller.cxx?r=131d5cdb#1408 because m_xAlterView.is() is false. It's due to the fact that: 1374 if ( xElements->hasByName( m_sName ) ) 1375 m_xAlterView.set( xElements->getByName( m_sName ), UNO_QUERY ); it doesn't set m_xAlterView If I replace "UNO_QUERY" by "UNO_QUERY_THROW", I get: warn:dbaccess:185477:185477:dbaccess/source/ui/querydesign/querycontroller.cxx:1411: DBG_UNHANDLED_EXCEPTION in bool dbaui::OQueryController::doSaveAsDoc(bool) exception: com.sun.star.uno.RuntimeException message: unsatisfied query for interface of type com.sun.star.sdbcx.XAlterView! In brief, XAlterView should be implemented
I gave a try here: https://gerrit.libreoffice.org/c/core/+/129011
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0adff3f2476f797843fb62d6810de90bfb333e10 tdf#126960, tdf#131330: FB make views editable+refresh auto after creation It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
For 7.3, patch waiting for review here: https://gerrit.libreoffice.org/c/core/+/129067
The patch doesn't build on 7.3 branch and don't want to dig so I abandoned it. If someone wants to try, don't hesitate.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/e7c652b90c44d9615a89e88ad3aa195b1fa6fbf7 tdf#126960, tdf#131330: FB make views editable+refresh auto after creation It will be available in 7.3.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.