Hi, In the main window of a database, in tab "Tables" the function "Create view" does not exist. And in Insert menu, "View design" is grayed. Best regards, Bernard
Confirming also on Linux 64bit master 4.3 This is probably a not yet implemented feature. Adding Andrzej, Lionel to CC
Adding as blocker for making Firebird the default
Adding self to CC if not already on
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT: - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17
(In reply to ribotb from comment #0) > Hi, > > In the main window of a database, in tab "Tables" the function "Create view" > does not exist. And in Insert menu, "View design" is grayed. > Function "Create view" does not exist with : Version: 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; Locale : fr-FR (fr_FR) on Win7/x86 Bernard
This might be because the firebird driver does not provide the XAlterView and/or XViewsSupplier interfaces
Works for me, both "create view" and "insert" -> "View Design". Version: 5.3.0.0.alpha0+ Build ID: 6bdcb730faa5b996882b4648b86b7caf93b8f421 CPU Threads: 4; OS Version: Linux 4.4; Note that you have to select "Tables" tab at least once before using "View Design". I don't know if it's intentional.
OK for me with : Version: 5.3.0.0.alpha0+ Build ID: d4936e876b1b965505ee2e82efaa35eef65d2135 CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-10-08_07:31:22 Locale: fr-FR (fr_FR); Calc: group And it's also OK with LO 5.2.2.2 (!) I don't know for LO 5.2.1 (In reply to Tamas Bunth from comment #7) > Note that you have to select "Tables" tab at least once before using "View > Design". I don't know if it's intentional. It's the same thing witn no Firebird database and it's the same thing with previous release (5.2). For me, it's intentional. Bernard
I tried to take a query and get a view by the contextmenue. This is the errormessage I got: firebird_sdbc error: *unsuccessful metadata update *CREATE VIEW Dateadd failed *There is no privilege for this operation caused by 'CREATE VIEW "Dateadd" AS SELECT DATEADD(-6 DAY TO "Datum") AS "6TageVorher", "Datum", DATEADD(MONTH, 9, "Datum") FROM "Table1"' I get the same errormessage when I try to create a view trough Tables > Create view. You are not allowed to create a view. Only the menue isn't greyed out any more. So the bug still exists. Tested with Version: 5.3.0.0.alpha0+ Build-ID: 06f91e5c6d4528de00a188f0f8ba4b5678b94ad3 CPU-Threads: 4; BS-Version: Linux 4.1; UI-Render: Standard; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-10-08_00:41:09 Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Created attachment 127880 [details] Try to create a view from one of the queries. Try to create directly. Won#t work. Attached database would only work with LO 5.3, not 5.2, because the internal Firebird-database has been changed to Firebird 3. Try to create a view - the errormessages says, you won't have privilegies for this.
(In reply to ribotb from comment #8) > And it's also OK with LO 5.2.2.2 (!) I don't know for LO 5.2.1 It does not work with LO 5.2.0.2
(In reply to ribotb from comment #8) Hi Bernhard, > > And it's also OK with LO 5.2.2.2 (!) I don't know for LO 5.2.1 > > Bernard You are right. It works with LO 5.2.2.2. But when I tried with LO 5.3.0.0 it doesn't. Tamas has just assigned himself for this bug. Hope it could be fixed for the new LO 5.3.
Hi, seems to be a bigger problem with new internal Firebird. You aren't allowed to create a table, too.
(In reply to robert from comment #13) > Hi, > seems to be a bigger problem with new internal Firebird. You aren't allowed > to create a table, too. It seems, without a username specified, it uses OS username, that causes privilege error, when the database is opened from another OS. That comes with fb 3.0 I'm about to solve that with a default username specified, possibly "sysdba", or something like that. see: http://stackoverflow.com/questions/38395381/no-privilege-for-this-operation
(In reply to robert from comment #10) > Created attachment 127880 [details] > Try to create a view from one of the queries. Try to create directly. Won#t > work. > > Attached database would only work with LO 5.3, not 5.2, because the internal > Firebird-database has been changed to Firebird 3. Try to create a view - the > errormessages says, you won't have privilegies for this. With this database and LO 5.2 I can't open tab 'Tables' and queries do not works. Ok with LO 5.3 master. Windows 7/x86
Have tested a little bit more, because I could create a new Firebird 3.0 - database with LO in the past. So I detected, what I wrote down in bug 103373: It is possible to create a view with the new internal Firebird 3.0 - database. But this is only possible the first time you use this database. After you close it and reopen it you are not allowed to create a view or a table any more. So this bug has been gone, but a new bug appeared. Should we set this to Resolved ad Worksforme?
Have tested again, because it is now possible to change tables after reopening Firebird 3.0. I am able to create views trough Tables > Create View I have to set View > Refresh Tables to see the view afterwords. I am also able to create views from a query by the contextmenue, but at last a warning appears: "No table format could be found." When setting View > Refresh Tables the view has been created also. I am also able to create views from a query with alias for fields. The alias will be shown in the view. All this tested with Version: 5.3.0.0.alpha1+ Build ID: 5d39c2013374727b1c8f147b8b99d54402a7ff02 CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: gtk2; Layout Engine: old; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-11-02_00:55:24 Locale: de-DE (de_DE.UTF-8); Calc: group I will set this bug to Resolved and Worksforme.