--- Begin Message ---
- To: submit@bugs.debian.org
- Subject: Subject: libreoffice-base: Copying a query to a table fails with "<table> is no SQL conform identifier"
- From: John Talbut <jt@dpets.uk>
- Date: Thu, 25 Oct 2018 16:04:14 +0100
- Message-id: <2b12d1b5-9449-6314-6671-a2eda32fba40@dpets.uk>
Package: libreoffice-base
Version: 1:6.1.3~rc1-1
Severity: normal
I carry out the following steps, which I have done many times before
without any problem:
Copy Query <Query name>
Paste as table, <Table name>
Definition and data
Create primary key IDT
Next
At this point I get a message:
"<Table name> is no SQL conform identifier"
If I click for more information I get the message:
"Choose the option 'Append data' on the first page to append data to an
existing table."
Which is not what I am trying to do, I am trying to create a new table
from the query.
-- System Information:
Debian Release: buster/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 4.16.12-20180618 (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8),
LANGUAGE=en_GB:en (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages libreoffice-base depends on:
ii libc6 2.27-6
ii libgcc1 1:8.2.0-8
ii libreoffice-base-core 1:6.1.3~rc1-1
ii libreoffice-base-drivers 1:6.1.3~rc1-1
ii libreoffice-core 1:6.1.3~rc1-1
ii libstdc++6 8.2.0-8
ii uno-libs3 6.1.3~rc1-1
ii ure 6.1.3~rc1-1
Versions of packages libreoffice-base recommends:
ii default-jre [java6-runtime] 2:1.10-68
ii libreoffice-java-common 1:6.1.3~rc1-1
ii libreoffice-writer 1:6.1.3~rc1-1
ii openjdk-10-jre [java6-runtime] 10.0.2+13-1
Versions of packages libreoffice-base suggests:
ii libreoffice-report-builder 1:6.1.3~rc1-1
pn unixodbc <none>
Versions of packages libreoffice-core depends on:
ii fontconfig 2.13.1-1
ii fonts-opensymbol 2:102.10+LibO6.1.3~rc1-1
ii libboost-date-time1.62.0 1.62.0+dfsg-10
ii libboost-locale1.62.0 1.62.0+dfsg-10
ii libc6 2.27-6
ii libcairo2 1.16.0-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.8-5
ii libcurl3-gnutls 7.61.0-1
ii libdbus-1-3 1.12.10-1
ii libdbus-glib-1-2 0.110-3
ii libdconf1 0.30.0-1
ii libeot0 0.01-5
ii libepoxy0 1.5.3-0.1
ii libexpat1 2.2.6-1
ii libexttextcat-2.0-0 3.4.5-1
ii libfontconfig1 2.13.1-1
ii libfreetype6 2.8.1-2
ii libgcc1 1:8.2.0-8
ii libglib2.0-0 2.58.1-2
ii libgpgmepp6 1.12.0-4
ii libgraphite2-3 1.3.12-1
ii libharfbuzz-icu0 1.9.0-1
ii libharfbuzz0b 1.9.0-1
ii libhunspell-1.6-0 1.6.2-1+b1
ii libhyphen0 2.8.8-5
ii libice6 2:1.0.9-2
ii libicu60 60.2-6
ii libjpeg62-turbo 1:1.5.2-2+b1
ii liblcms2-2 2.9-3
ii libldap-2.4-2 2.4.46+dfsg-5
ii libmythes-1.2-0 2:1.2.4-3
ii libneon27-gnutls 0.30.2-2
ii libnspr4 2:4.20-1
ii libnss3 2:3.39-1
ii libnumbertext-1.0-0 1.0.5-1
ii libodfgen-0.1-1 0.1.7-1
ii liborcus-0.13-0 0.14.0+really0.13.4-1
ii libpng16-16 1.6.34-2
ii libpoppler74 0.63.0-2
ii librdf0 1.0.17-1.1
ii libreoffice-common 1:6.1.3~rc1-1
ii librevenge-0.0-0 0.0.4-6
ii libsm6 2:1.2.2-1+b3
ii libstdc++6 8.2.0-8
ii libx11-6 2:1.6.7-1
ii libxext6 2:1.3.3-1+b2
ii libxinerama1 2:1.1.4-1
ii libxml2 2.9.4+dfsg1-7+b1
ii libxmlsec1 1.2.26-3
ii libxmlsec1-nss 1.2.26-3
ii libxrandr2 2:1.5.1-1
ii libxrender1 1:0.9.10-1
ii libxslt1.1 1.1.32-2
ii uno-libs3 6.1.3~rc1-1
ii ure 6.1.3~rc1-1
ii zlib1g 1:1.2.11.dfsg-1
Versions of packages libreoffice-core recommends:
pn libpaper-utils <none>
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
--- End Message ---