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

             Bug #: 50849
           Summary: SIGSEGV:  ODBC to PostgreSQL, renaming column in
                    SELECT list
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO Master
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Database
        AssignedTo: [email protected]
        ReportedBy: [email protected]


Created attachment 62740
  --> https://bugs.freedesktop.org/attachment.cgi?id=62740
gdb output, including backtrace

summary
-------

BASE SIGSEGV:  ODBC to PostgreSQL, renaming column in SELECT list

description
-----------

Having a ODBC connection to a PostgreSQL database with data created by
the SQL statements that Heinz Repp provided in
https://bugs.freedesktop.org/show_bug.cgi?id=47520#c9, I tried in
Queries > "Create Query in SQL View ..." to run the query

    select number x, name from table1

The result is a SIGSEGV.  Backtrace attached.

For comparison:  using an explicit "as" in the rename avoids the crash
and results in the the expected display of the table contents.


A SIGSEGV also comes using LibreOffice supplied with ubuntu-natty
(11.04), which identifies itself as

    LibreOffice 3.3.4 
    OOO330m19 (Build:401)
    tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1


I have left default priority on this report, but perhaps the priority
should be lower, considering the age of this crash and the fact that I
was deliberately "looking for trouble".


My LibreOffice is master commit id 0752710, pulled around 2012-06-06
12:50 GMT, configured with

    --disable-mozilla
    --enable-symbols
    --enable-dbgutil
    --enable-crashdump
    --disable-build-mozilla
    --without-system-postgresql
    --enable-debug

built and running on ubuntu-natty (11.04).  Other possibly implicated
software includes

    package          version
    ---------------  ------------------- 
    unixodbc         2.2.14p2-2ubuntu1
    postgresql       8.4.12-0ubuntu11.04
    postgresql-8.4   8.4.12-0ubuntu11.04
    odbc-postgresql  1:08.03.0200-1.2

The relevant stanza from ~/.odbc.ini reads

    [psql_terry_ansi]
    Description        = PostgreSQL db terry, ansi version
    Driver        = PostgreSQL_ansi
    Trace        = Yes
    TraceFile        = /tmp/sql.log
    Database        = terry
    Servername        = localhost
    Username        = [redacted]
    Password        = [redacted]
    Port        = 5432
    Protocol        = 6.4
    ReadOnly        = No
    RowVersioning        = No
    ShowSystemTables        = No
    ShowOidColumn        = No
    FakeOidIndex        = No
    ConnSettings        =

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to