[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

Tamas Bunth  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |btom...@gmail.com
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

--- Comment #11 from ribotb  ---
(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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

rob...@familiegrosskopf.de changed:

   What|Removed |Added

   Assignee|rob...@familiegrosskopf.de  |libreoffice-b...@lists.free
   ||desktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
   Assignee|libreoffice-b...@lists.free |rob...@familiegrosskopf.de
   |desktop.org |
 Ever confirmed|0   |1

--- Comment #10 from rob...@familiegrosskopf.de ---
Created attachment 127880
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127880=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

--- Comment #9 from rob...@familiegrosskopf.de ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

--- Comment #8 from ribotb  ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

Tamas Bunth  changed:

   What|Removed |Added

 Status|NEW |UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #7 from Tamas Bunth  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

--- Comment #6 from Lionel Elie Mamane  ---
This might be because the firebird driver does not provide the XAlterView
and/or XViewsSupplier interfaces

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

--- Comment #5 from ribotb  ---
(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

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76072

--- Comment #4 from QA Administrators  ---
** 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

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=76072

--- Comment #3 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=76072

--- Comment #2 from ribotb rib...@gmail.com ---
Adding as blocker for making Firebird the default

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=76072

ribotb rib...@gmail.com changed:

   What|Removed |Added

 Blocks||51780

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=76072

--- Comment #1 from Alex Thurgood ipla...@yahoo.co.uk ---
Confirming also on Linux 64bit master 4.3

This is probably a not yet implemented feature.

Adding Andrzej, Lionel to CC

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76072] Not allowed to create view with embedded Firebird ?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=76072

Alex Thurgood ipla...@yahoo.co.uk changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs