Bug#585829: openoffice.org-base: SQL syntax error when accessing MySQL table using ODBC
Package: openoffice.org-base
Version: 1:3.2.0-10
Severity: important
I have a very simple (1 table) MySQL database that works fine with isql. When I
attempt to access it using a openoffice.org-base database under easy-debian/armel
I get the pop-up error message: 'The data could not be loaded. Syntax error in
SQL expression'. When I hit 'More' and look further, the SQL appears well-formed
('SELECT * from "Events"') but it returns 'SQL Status HY000 Error code: 1000'
and the additional message 'INVALIDSYMBOL, expecting $end, Invalid symbol'.
The same Openoffice build (9483) under debian/i686 works normally with the same files
so I presume the problem is connected with the armel build.
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: armel (armv7l)
Kernel: Linux 2.6.28.10power37 (PREEMPT)
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/bash
Versions of packages openoffice.org-base depends on:
ii libc6 2.11.1-3 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.4.4-4 GCC support library
ii libhsqldb-java 1.8.0.10-6.1 Java SQL database engine
ii libstdc++6 4.4.4-4 The GNU Standard C++ Library v3
ii openjdk-6-jre [java5-r 6b18-1.8-2 OpenJDK Java runtime, using Hotspo
ii openoffice.org-base-co 1:3.2.0-10 office productivity suite -- share
ii openoffice.org-core 1:3.2.0-10 office productivity suite -- arch-
ii openoffice.org-java-co 1:3.2.0-10 office productivity suite -- arch-
ii ure 1.6.0+OOo3.2.0-10 OpenOffice.org UNO runtime environ
openoffice.org-base recommends no packages.
Versions of packages openoffice.org-base suggests:
ii libmyodbc 5.1.6-1 the MySQL ODBC driver
pn libmysql-java | libpg-java | <none> (no description available)
ii libsqliteodbc 0.80-1 ODBC driver for SQLite embedded da
pn openoffice.org-gcj <none> (no description available)
pn openoffice.org-report-builder <none> (no description available)
ii unixodbc 2.2.14p2-1 ODBC tools libraries
Versions of packages openoffice.org-core depends on:
ii debconf [debconf-2.0] 1.5.32 Debian configuration management sy
ii fontconfig 2.8.0-2.1 generic font configuration library
ii libc6 2.11.1-3 Embedded GNU C Library: Shared lib
ii libcairo2 1.8.10-4 The Cairo 2D vector graphics libra
ii libcurl3-gnutls 7.20.1-2 Multi-protocol file transfer libra
ii libdb4.8 4.8.30-1 Berkeley v4.8 Database Libraries [
ii libexpat1 2.0.1-7 XML parsing C library - runtime li
ii libfreetype6 2.3.11-1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.4.4-4 GCC support library
ii libglib2.0-0 2.24.1-1 The GLib library of C routines
ii libgraphite3 1:2.3.1-0.2 SILGraphite - a "smart font" rende
ii libgstreamer-plugins-b 0.10.29-4 GStreamer libraries from the "base
ii libgstreamer0.10-0 0.10.29-1 Core GStreamer libraries and eleme
ii libgtk2.0-0 2.20.1-1 The GTK+ graphical user interface
ii libhunspell-1.2-0 1.2.11-1 spell checker and morphological an
ii libhyphen0 2.5-1 ALTLinux hyphenation library - sha
ii libice6 2:1.0.6-1 X11 Inter-Client Exchange library
ii libicu42 4.2.1-3 International Components for Unico
ii libjpeg62 6b-16.1 The Independent JPEG Group's JPEG
ii libmythes-1.2-0 2:1.2.0-4 simple thesaurus library
ii libneon27-gnutls 0.29.3-2 An HTTP and WebDAV client library
ii libnspr4-0d 4.8.4-1 NetScape Portable Runtime Library
ii libnss3-1d 3.12.6-2 Network Security Service libraries
ii librdf0 1.0.10-2 Redland Resource Description Frame
ii libsm6 2:1.1.1-1 X11 Session Management library
ii libssl0.9.8 0.9.8o-1 SSL shared libraries
ii libstdc++6 4.4.4-4 The GNU Standard C++ Library v3
ii libx11-6 2:1.3.3-3 X11 client-side library
ii libxaw7 2:1.0.7-1 X11 Athena Widget library
ii libxext6 2:1.1.1-3 X11 miscellaneous extension librar
ii libxml2 2.7.7.dfsg-2 GNOME XML library
ii libxrandr2 2:1.3.0-3 X11 RandR extension library
ii libxrender1 1:0.9.5-2 X Rendering Extension client libra
ii libxslt1.1 1.1.26-3 XSLT processing library - runtime
ii libxt6 1:1.0.7-1 X11 toolkit intrinsics library
ii libxtst6 2:1.1.0-2 X11 Testing -- Resource extension
ii openoffice.org-common 1:3.2.0-10 office productivity suite -- arch-
ii procps 1:3.2.8-9 /proc file system utilities
ii ttf-opensymbol 1:3.2.0-10 OpenSymbol TrueType font
ii ure 1.6.0+OOo3.2.0-10 OpenOffice.org UNO runtime environ
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
Versions of packages openoffice.org-base is related to:
ii libmyodbc 5.1.6-1 the MySQL ODBC driver
pn libmysql-java <none> (no description available)
pn libpg-java <none> (no description available)
pn libsapdbc-java <none> (no description available)
ii libsqliteodbc 0.80-1 ODBC driver for SQLite embedded da
pn mdbtools <none> (no description available)
pn odbc-postgresql <none> (no description available)
pn tdsodbc <none> (no description available)
ii unixodbc 2.2.14p2-1 ODBC tools libraries
-- debconf information:
shared/openofficeorg-running:
Reply to: