Download it now!
Bug 124575 - EDITING: Query input in field of second table crashes LO, when two tables in the query.
Summary: EDITING: Query input in field of second table crashes LO, when two tables in ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-06 09:42 UTC by Robert Großkopf
Modified: 2019-04-09 15:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Open the query and insert a new row as described (3.54 KB, application/vnd.oasis.opendocument.database)
2019-04-06 09:42 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2019-04-06 09:42:30 UTC
Created attachment 150560 [details]
Open the query and insert a new row as described

Open the attached database-file.
Open the query, which has been created by the GUI.
Query shows the content of 2 table.
Write in new row
"ID_N"='3', "Name"='Robert', "Sport_ID"='1'
and change to next row.
"Name" 'Robert' will appear with "Sport" 'football'.
Write in new row
"ID_N"='4', "Name"='Else', "ID_S"='3', "Sport"='dancing'

LO will crash immediately, because the query couldn't handle the insert for two tables. If you try the same and set also "Sport_ID"='3' it doesen't crash buit leads to an error.

Expected behaviour: Show an errormessage. LO shouldn't crash.

This bug appears with LO 6.2.2.2 an embedded Firebird, but could also reproduced with embedded HSQLDB.

Tested with OpenSUSE 15 64bit rpm Linux
Comment 1 Terrence Enger 2019-04-09 15:09:28 UTC
I see a SIGABRT in bibisect-linux-64-6.3 repository source hashes
c8c0292c (2019-04-04) and a20a2d73 (2018-11-12) running on debian
buster.  I am setting status NEW.

In the newer of those versions, if I close and reopen the query
before the second update, upon leaving column Sport LO presents
msgbox:
    LibreOfficeDev Base
    Error inserting the new record
    firebird_sdbc error
    *violation of FOREIGN KEY constraint "INTEG_5" ON TABLE "tblName"
    *Foreign key reference target does not exist
    *Problematic key value is ("Sport_ID" = 3)
    caused by
    'isc_dsql_execute'

Funnily enough, a local build of of s-h 3abcd615 (2019-02-02),
configured
    CC=ccache /usr/bin/gcc
    CXX=ccache /usr/bin/g++
    CCFLAGS=-Wshadow
    --with-jdk-home=/usr/lib/jvm/default-java
    --enable-split-debug
    --enable-gdb-index
    --enable-ld=gold
    --enable-option-checking=fatal
    #--enable-dbgutil
    #--enable-debug
    --without-system-postgresql
    --without-myspell-dicts
    --with-extra-buildid
    --without-doxygen
    --with-external-tar=/home/terry/lo_hacking/git/src
    --without-package-format
built and running on debian buster, presents the msgbox even with both
updates performed within the same execution of the query.