Bug#922764: libreoffice-base: schema not respected in copy/paste of calc_table to base_table

[Rene Engelhard <rene@debian.org>]

tag 922764 + moreinfo
thanks

Hi,

On Wed, Feb 20, 2019 at 01:04:16PM +0100, Wim Bertels wrote:
> U can use copy/paste between calc and base to create a database table form calc data.

Please don't use "U", ther's no real saving here compared to "You" and
it just looks bad.

> I tested this with postgresql
> 
> Backend setup:
> * pg server
> * user user1
> * database db1
> ** schema schema1
> ** schema schema2

And with -sdbc-postgresql? Or with ODBC? Just to rule that one out.

> When u paste the data (from calc) into the schema1 (in base) the schema is ignored or it will give an error.
> When u try the same with a different database client, this will work.
> 
> Given the error base gives, it seems it only reads the default search_path of the logged in user,
> and completely ignores the schema1 in which it was pasted. This allowing only to paste in a schema that is in the default path of user1.
> 
> PS: set search_path to schema1; is not recognized in base
> 
> Suggestion: make the paste command in base schema aware

Maybe, but given this is a suggestion this will NEVER be fixed in
stable. 5.2.x is end of life upstream since 2017. We only fix security
bugs or really critical bugs if feasible, neither of which this is.
(And you filed it against a version which is a dead-end anyway, and the
BTS knows that, too, so doesn't even mark buster etc. as affected, even
if it were.)

Please test with a supported version (stretch-backports contains a 6.1.5
rc1 - that will soon be end of life still, but...)

Regards,

Rene