Bug 126580

Summary:	EDITING: Firebird - Create as View gives error but creates the view in the background.
Product:	LibreOffice	Reporter:	Robert Großkopf <robert>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	herman.viaene, iplaw67, lionel, xiscofauli
Priority:	medium
Version:	5.4 all versions
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=126578 https://bugs.documentfoundation.org/show_bug.cgi?id=126586 https://bugs.documentfoundation.org/show_bug.cgi?id=131330
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	51780

Description Robert Großkopf 2019-07-28 17:27:56 UTC

Open https://bugs.documentfoundation.org/attachment.cgi?id=153015
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 6.2.5.2, because there is no possibility to create a view through the contextmenue of a query any more with LO 6.3.0.2 - see bug 126579.

Comment 1 Alex Thurgood 2019-07-31 12:12:31 UTC

Confirming also with

Version: 6.2.4.2
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
Calc: threaded

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.

Comment 2 Alex Thurgood 2019-07-31 12:14:04 UTC

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

Comment 3 Xisco Faulí 2019-08-05 14:04:39 UTC

Also reproduced in

Version: 5.3.0.0.alpha1+
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...

Comment 4 Xisco Faulí 2019-08-05 14:06:01 UTC

*** Bug 126586 has been marked as a duplicate of this bug. ***

Comment 5 Robert Großkopf 2020-03-13 15:38:55 UTC

(In reply to Robert Großkopf from comment #0)


> Note: This bug will only appear up to LO 6.2.5.2, because there is no
> possibility to create a view through the contextmenue of a query any more
> with LO 6.3.0.2 - see bug 126579.

After bug 126579 is fixed this bug also appears in newer LO-versions like LO 6.4.2.1 on OpenSUSE 15.1 64bit rpm Linux

Comment 6 Robert Großkopf 2020-04-30 06:38:43 UTC

*** Bug 132522 has been marked as a duplicate of this bug. ***

Comment 7 Robert Großkopf 2022-02-09 10:06:25 UTC

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.

Tested with
Version: 7.4.0.0.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
Calc: threaded