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++6 6.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-common 1: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 <none>
ii libreoffice-report-builder 1:5.2.7-1+deb9u5
pn unixodbc <none>
Versions of packages libreoffice-core depends on:
ii fontconfig 2.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-contribs1v5 2.3.3.4+dfsg-1
ii libclucene-core1v5 2.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 libfontconfig1 2.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.0 2.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-3 1.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 libhyphen0 2.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-2 2.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-common 1:5.2.7-1+deb9u5
ii librevenge-0.0-0 0.0.4-6
ii libsm6 2:1.2.2-1+b3
ii libstdc++6 6.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 libxrandr2 2:1.5.1-1
ii libxrender1 1:0.9.10-1
ii libxslt1.1 1.1.29-2.1
ii uno-libs3 5.2.7-1+deb9u5
ii ure 5.2.7-1+deb9u5
ii zlib1g 1: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 <none>
pn libmysql-java <none>
pn libpg-java <none>
pn libsapdbc-java <none>
pn libsqliteodbc <none>
pn mdbtools <none>
pn odbc-postgresql <none>
pn tdsodbc <none>
pn unixodbc <none>
-- no debconf information
Reply to: