Bug#922764: libreoffice-base: schema not respected in copy/paste of calc_table to base_table
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
Bug#922764: libreoffice-base: schema not respected in copy/paste of calc_table to base_table
Package: libreoffice-base Version: 1:5.2.7-1+deb9u5 Severity: normal Hallo, U can use copy/paste between calc and base to create a database table form calc data. I tested this with postgresql Backend setup: * pg server * user user1 * database db1 ** schema schema1 ** schema schema2 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 hth, Wim -- System Information: Debian Release: 9.7 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 4.9.0-8-amd64 (SMP w/2 CPU cores) Locale: LANG=nl_BE.utf8, LC_CTYPE=nl_BE.utf8 (charmap=UTF-8), LANGUAGE=nl_BE.utf8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages libreoffice-base depends on: ii dpkg 1.18.25 ii libc6 2.24-11+deb9u3 ii libgcc1 1:6.3.0-18+deb9u1 ii libreoffice-base-core 1:5.2.7-1+deb9u5 ii libreoffice-base-drivers 1:5.2.7-1+deb9u5 ii libreoffice-core 1:5.2.7-1+deb9u5 ii libstdc++66.3.0-18+deb9u1 ii uno-libs3 5.2.7-1+deb9u5 ii ure 5.2.7-1+deb9u5 Versions of packages libreoffice-base recommends: ii default-jre [java5-runtime]2:1.8-58 ii libreoffice-java-common1:5.2.7-1+deb9u5 ii libreoffice-writer 1:5.2.7-1+deb9u5 ii openjdk-8-jre [java5-runtime] 8u181-b13-2~deb9u1 Versions of packages libreoffice-base suggests: pn libreoffice-gcj ii libreoffice-report-builder 1:5.2.7-1+deb9u5 pn unixodbc Versions of packages libreoffice-core depends on: ii fontconfig2.11.0-6.7+b1 ii fonts-opensymbol 2:102.7+LibO5.2.7-1+deb9u5 ii libboost-date-time1.62.0 1.62.0+dfsg-4 ii libc6 2.24-11+deb9u3 ii libcairo2 1.14.8-1 ii libclucene-contribs1v52.3.3.4+dfsg-1 ii libclucene-core1v52.3.3.4+dfsg-1 ii libcmis-0.5-5v5 0.5.1+git20160603-3+b1 ii libcups2 2.2.1-8+deb9u2 ii libcurl3-gnutls 7.52.1-5+deb9u9 ii libdbus-1-3 1.10.26-0+deb9u1 ii libdbus-glib-1-2 0.108-2 ii libdconf1 0.26.0-2+b1 ii libeot0 0.01-4+b1 ii libexpat1 2.2.0-2+deb9u1 ii libexttextcat-2.0-0 3.4.4-2+b1 ii libfontconfig12.11.0-6.7+b1 ii libfreetype6 2.6.3-3.2 ii libgcc1 1:6.3.0-18+deb9u1 ii libgl1-mesa-glx [libgl1] 13.0.6-1+b2 ii libglew2.02.0.0-3+b1 ii libglib2.0-0 2.50.3-2 ii libgltf-0.0-0v5 0.0.2-5 ii libglu1-mesa [libglu1]9.0.0-2.1 ii libgraphite2-31.3.10-1 ii libharfbuzz-icu0 1.4.2-1 ii libharfbuzz0b 1.4.2-1 ii libhunspell-1.4-0 1.4.1-2+b2 ii libhyphen02.8.8-5 ii libice6 2:1.0.9-2 ii libicu57 57.1-6+deb9u2 ii libjpeg62-turbo 1:1.5.1-2 ii liblangtag1 0.6.2-1 ii liblcms2-22.8-4+deb9u1 ii libldap-2.4-2 2.4.44+dfsg-5+deb9u2 ii libmythes-1.2-0 2:1.2.4-3 ii libneon27-gnutls 0.30.2-2 ii libnspr4 2:4.12-6 ii libnss3 2:3.26.2-1.1+deb9u1 ii libodfgen-0.1-1 0.1.6-2 ii libpcre3 2:8.39-3 ii libpng16-16 1.6.28-1 ii librdf0 1.0.17-1.1 ii libreoffice-common1:5.2.7-1+deb9u5 ii librevenge-0.0-0 0.0.4-6 ii libsm62:1.2.2-1+b3 ii libstdc++66.3.0-18+deb9u1 ii libx11-6 2:1.6.4-3+deb9u1 ii libxext6 2:1.3.3-1+b2 ii libxinerama1 2:1.1.3-1+b3 ii libxml2 2.9.4+dfsg1-2.2+deb9u2 ii libxrandr22:1.5.1-1 ii libxrender1 1:0.9.10-1 ii libxslt1.11.1.29-2.1 ii uno-libs3 5.2.7-1+deb9u5 ii ure 5.2.7-1+deb9u5 ii zlib1g1:1.2.8.dfsg-5 Versions of packages libreoffice-core recommends: ii libpaper-utils 1.1.24+nmu5 Versions of packages libreoffice-base is related to: pn libmyodbc pn libmysql-java pn libpg-java pn libsapdbc-java pn libsqliteodbc pn mdbtools pn odbc-postgresql pn tdsodbc pn unixodbc -- no debconf information