https://bugs.freedesktop.org/show_bug.cgi?id=63897

          Priority: medium
            Bug ID: 63897
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: assertions when save created table from Design View,
                    ODBC to SQLite3
          Severity: normal
    Classification: Unclassified
                OS: Linux (All)
          Reporter: lo_b...@iseries-guru.com
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.1.0.0.alpha0+ Master
         Component: contrib
           Product: LibreOffice

For interpretation of the steps below, note the following points about
my setup:

(*) Definition of the driver name, from /etc/odbcinst.ini:

        [SQLite3]
        Description        = SQLite3 ODBC Driver
        Driver        = /usr/lib/odbc/libsqlite3odbc.so
        Driver64        = 
        Setup        = /usr/lib/odbc/libsqlite3odbc.so
        Setup64        = 
        UsageCount        = 1
        CPTimeout        = 
        CPReuse        = 

(*) Definition of the DSN, from my ~/.odbc.ini.:

        [ODBCTEST2]
        Description        = sqlite3 file in tmp/
        Driver        = SQLite3
        Database        = /tmp/TestDB
        Timeout        = 100000
        StepAPI        = No
        ShortNames        = No
        FKSupport        = No
        SyncPragma        = NORMAL
        JournalMode        = DELETE
        LoadExt        = 


To reproduce the problem

( 1) Start with fresh database

        rm -f /tmp/TestDB

( 2) Run soffice from the terminal with parameters --norestore --base.
     Program displays Database Wizard Step 1 "Select database".

( 3) For "What do you want to do?" click "Connect to to an exising
     database", from the dropdown menu select ODBC", and click <Next>.
     Program displays Database Wizard Step 2 "Set up ODBC connection".

( 4) For "Name of the ODBC data source on your system", type
     ODBCTEST2, and click <Next>.  Program presents Database Wizard
     Step 3 "Set up user authentication".

( 5) Click <Test Connection>.  Program displays dialog box saying
     "... The connection was established successfully."

( 6) Click <OK>.  Program gives focus to the window Database Wizard.

( 7) Click <Next>.  Program displays Database Wizard Step 4 "Decide
     how to proceed after saving the database".

( 8) Click "No, do not register the database", leave "Open the
     database for editing" selected, and click <Finish>.  Program
     presents dialog "Save" with Name initialized to "New Database".

( 9) Under heading "Places", click tmp/, and click <Save>.  Program
     displays window "New Database.odb"; in left pane <Tables> is
     selected, and upper right pane displays enabled options "Create
     Table in Design View...", "Use Wizard to Create Table...", and
     "Create View...".

(10) In upper-right pane double-click "Create Table in Design View".
     Program presents window "New Database.odb : Table1".

(11) In first row, enter Field Name "number" and select field type
     Integer.

(12) In second row, enter field name "word"

(13) To the left of field number, right-click and from the popup menu
     select "Primary Key".  Program displays a "key" icon at the left
     end of the row.

(14) In the toolbar, click the <Save> icon.

     Expected program action: no visible result.

     Actual program action: in the terminal, the program displays
     messages ...

       
warn:legacy.osl:20105:1:dbaccess/source/ui/tabledesign/TableController.cxx:358:
OTableController::doSaveDoc: nothing is expected to happen here!
       
warn:legacy.osl:20105:1:connectivity/source/commontools/dbtools.cxx:847:
impl_doComposeTableName : at least the name should be non-empty !
       
warn:legacy.osl:20105:1:dbaccess/source/ui/tabledesign/TableController.cxx:448:
caught an exception!
        in function:sal_Bool dbaui::OTableController::doSaveDoc(sal_Bool)
        type: com.sun.star.lang.DisposedException

     and does not save the table.

(15) X-close the window "New Database.odb : Table1".

     Expected program action: to close that window and return focus to
     window "New Database.odb".

     Actual program action: display dialog "The table has been
     chnaged.  Do you wnat to save the changes?".

(16) Click <No>.  Program closes Design View and returns focus to "New
     Database.odb".

     Note that the list of tables in the lower right pane is empty.


My LibreOffice is master commit 6faa622, pulled 2013-04-19, configured as 

    --enable-option-checking=fatal
    --enable-dbgutil
    --enable-crashdump
    --without-system-postgresql
    --without-myspell-dicts
    --without-help
    --with-extra-buildid

built and running on ubuntu-natty (11.04)

    $ uname -a
    Linux cougar-natty 2.6.38-16-generic #67-Ubuntu SMP Thu Sep 6 18:00:43 UTC
2012 i686 athlon i386 GNU/Linux

    $ gcc --version
    gcc (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2
    Copyright (C) 2010 Free Software Foundation, Inc.
    This is free software; see the source for copying conditions.  There is NO
    warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

    $ java -version
    java version "1.6.0_24"
    OpenJDK Runtime Environment (IcedTea6 1.11.5)
(6b24-1.11.5-0ubuntu1~11.04.1)
    OpenJDK Client VM (build 20.0-b12, mixed mode, sharing)

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to