Try to create a view of "View_Bericht_Ware_gruppiert" through the context-menue of the query. Note: bug 126578!
There will appear an error:
"No table format could be found."
Go to pane "Tables".
No view will be shown, so you could think: No view has been created.
Go to View → Refresh Tables.
View will be shown and has been created.
Expected behaviour would be: No error will appear and the view will be shown after creating it through the GUI.
Note: This bug will only appear up to LO 188.8.131.52, because there is no possibility to create a view through the contextmenue of a query any more with LO 184.108.40.206 - see bug 126579.
Confirming also with
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 4; OS: Mac OS X 10.14.5; UI render: default; VCL: osx;
Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US
The Create as View menu entry seems to appear and disappear at random..., but when it does appear, I can confirm that the error message is produced when attempting to follow through with view creation.
I can also confirm that the view is only displayed in the Tables list after going through the menu Display > Refresh Tables (or I suppose, shutting down and restarting LO).
Also reproduced in
Build ID: 4136757b4e51c4e6f7cb4132c95538a7f831ef2c
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; VCL: gtk3; Layout Engine: new;
Locale: ca-ES (ca_ES.UTF-8); Calc: group
I don't understand why it has been tagged as a regression...
*** Bug 126586 has been marked as a duplicate of this bug. ***
(In reply to Robert Großkopf from comment #0)
> Note: This bug will only appear up to LO 220.127.116.11, because there is no
> possibility to create a view through the contextmenue of a query any more
> with LO 18.104.22.168 - see bug 126579.
After bug 126579 is fixed this bug also appears in newer LO-versions like LO 22.214.171.124 on OpenSUSE 15.1 64bit rpm Linux
*** Bug 132522 has been marked as a duplicate of this bug. ***
Seems the bug has been gone while fixing bug 126969.
I could create a new view from a query by right mouse click on the query. View will be shown directly in tables pane.
But another little bug appears: Deleting an old view and creating a new view with the same name is impossible without restarting LO. Will file a new bug for this.
Version: 126.96.36.199.alpha0+ / LibreOffice Community
Build ID: 703fb7739a5e604d90e147db6f67917b8d141150
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US