Package: libreoffice-base Version: 1:3.3.1-1 Severity: grave Justification: causes non-serious data loss
The data loss here is "non-serious" only because this is a trival
database. If i had this happen to a database that i cared about, i
would be unhappy.
To reproduce:
0) run "libreoffice"
1) click "Database"
2) choose "Create a new database", click "Next"
3) "Yes, register the database for me" (it's not clear what this
means), and "Open the database for editing"; click "Finish"
4) choose a file name ("test.odb") and click "Save"
5) "Create Table in Design View..."
6) (in design view) add 4 columns:
* id (Integer [INTEGER])
* testa (Text [VARCHAR])
* testb (Date [DATE])
* testc (Number [NUMERIC])
7) click "Save" on toolbar, accept default name "Test1"
8) on "No primary key: Should a primary key be created now" prompt,
choose "Yes" (i observe that it creates a column named "ID" in
addition to the "id" column that already exists. maybe this is
the root of the problem?)
9) (back in main window) right-click new Table1, choose "Open", enter
some example rows.
10) for testb, i entered "2011-02-03", and when i hit tab, it turned
into "40577". in testc, i put "123", and it gave me "40577"
Thanks for maintaining libreoffice in debian! I hope this can get
sorted out.
--dkg
PS i'm attaching the generated .odb file (i saved it) if it will help
with debugging.
-- System Information:
Debian Release: wheezy/sid
APT prefers testing
APT policy: (500, 'testing'), (200, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.37-2-686 (SMP w/1 CPU core)
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages libreoffice-base depends on:
ii gcj-4.4-jre [java5-run 4.4.5-9 Java runtime environment using GIJ
ii libc6 2.11.2-11 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.5.2-4 GCC support library
ii libhsqldb-java 1.8.0.10-9 Java SQL database engine
ii libreoffice-base-core 1:3.3.1-1 office productivity suite -- share
ii libreoffice-core 1:3.3.1-1 office productivity suite -- arch-
ii libreoffice-java-commo 1:3.3.1-1 office productivity suite -- arch-
ii libstdc++6 4.5.2-4 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-7 STLport C++ class library
ii ure 1.7.0+LibO3.3.1-1 LibreOffice UNO runtime environmen
libreoffice-base recommends no packages.
Versions of packages libreoffice-base suggests:
pn libmysql-java | libpg-java | <none> (no description available)
pn libreoffice-gcj <none> (no description available)
pn libreoffice-report-builder <none> (no description available)
ii libsqliteodbc 0.88-1 ODBC driver for SQLite embedded da
ii unixodbc 2.2.14p2-2 ODBC tools libraries
Versions of packages libreoffice-core depends on:
ii fontconfig 2.8.0-2.1 generic font configuration library
ii libatk1.0-0 1.30.0-1 The ATK accessibility toolkit
ii libc6 2.11.2-11 Embedded GNU C Library: Shared lib
ii libcairo2 1.8.10-6 The Cairo 2D vector graphics libra
ii libcurl3-gnutls 7.21.3-1 Multi-protocol file transfer libra
ii libdb4.8 4.8.30-4 Berkeley v4.8 Database Libraries [
ii libexpat1 2.0.1-7 XML parsing C library - runtime li
ii libfontconfig1 2.8.0-2.1 generic font configuration library
ii libfreetype6 2.4.4-1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.5.2-4 GCC support library
ii libglib2.0-0 2.28.1-1+b1 The GLib library of C routines
ii libgraphite3 1:2.3.1-0.2 SILGraphite - a "smart font" rende
ii libgstreamer-plugins 0.10.30-1 GStreamer libraries from the "base
ii libgstreamer0.10-0 0.10.30-1 Core GStreamer libraries and eleme
ii libgtk2.0-0 2.20.1-2 The GTK+ graphical user interface
ii libhunspell-1.2-0 1.2.14-4 spell checker and morphological an
ii libhyphen0 2.7.1-3 ALTLinux hyphenation library - sha
ii libice6 2:1.0.7-1 X11 Inter-Client Exchange library
ii libicu44 4.4.2-2 International Components for Unico
ii libjpeg62 6b1-1 The Independent JPEG Group's JPEG
ii libmythes-1.2-0 2:1.2.1-1 simple thesaurus library
ii libneon27-gnutls 0.29.5-3 An HTTP and WebDAV client library
ii libnspr4-0d 4.8.7-2 NetScape Portable Runtime Library
ii libnss3-1d 3.12.8-2 Network Security Service libraries
ii libpango1.0-0 1.28.3-1+squeeze1 Layout and rendering of internatio
ii libpng12-0 1.2.44-1 PNG library - runtime
ii librdf0 1.0.13-2 Redland Resource Description Frame
ii libreoffice-common 1:3.3.1-1 office productivity suite -- arch-
ii libsm6 2:1.2.0-1 X11 Session Management library
ii libssl0.9.8 0.9.8o-5 SSL shared libraries
ii libstdc++6 4.5.2-4 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-7 STLport C++ class library
ii libx11-6 2:1.4.1-5 X11 client-side library
ii libxaw7 2:1.0.9-2 X11 Athena Widget library
ii libxext6 2:1.2.0-2 X11 miscellaneous extension librar
ii libxinerama1 2:1.1.1-1 X11 Xinerama extension library
ii libxml2 2.7.8.dfsg-2 GNOME XML library
ii libxrandr2 2:1.3.1-1 X11 RandR extension library
ii libxrender1 1:0.9.6-1 X Rendering Extension client libra
ii libxslt1.1 1.1.26-6 XSLT 1.0 processing library - runt
ii libxt6 1:1.0.9-2 X11 toolkit intrinsics library
ii ttf-opensymbol 2:2.4.3+LibO3.3.1-1 OpenSymbol TrueType font
ii ure 1.7.0+LibO3.3.1-1 LibreOffice UNO runtime environmen
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
Versions of packages libreoffice-base is related to:
pn libmyodbc <none> (no description available)
pn libmysql-java <none> (no description available)
pn libpg-java <none> (no description available)
pn libsapdbc-java <none> (no description available)
ii libsqliteodbc 0.88-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-2 ODBC tools libraries
-- no debconf information
test.odb
Description: Binary data
