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: RESOLVED WORKSFORME
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: 2021-04-09 06:42 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
View All Add an attachment (proposed patch, testcase, etc.)

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.
Comment 2 QA Administrators 2021-04-09 03:47:09 UTC Comment hidden (obsolete)
Comment 3 Robert Großkopf 2021-04-09 06:42:49 UTC 
Crash doesn't appear any more in LO 7.1.2.2 on OpenSUSE 15.2 64bit rpm Linux. So I will set this one to WORKSFORME.