| Summary: | Crash when accessing a query with duplicated table names | ||
|---|---|---|---|
| Product: | [Applications] KEXI | Reporter: | robert leleu <robert.jean.leleu> |
| Component: | General | Assignee: | Jarosław Staniek <staniek> |
| Status: | CLOSED FIXED | ||
| Severity: | crash | ||
| Priority: | HI | ||
| Version: | 2.8.3 | ||
| Target Milestone: | 2.8.4 | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | http://commits.kde.org/calligra/eaefd12562da5b422ae175351423fa15fd1a2cb4 | Version Fixed In: | 2.8.4 |
| Sentry Crash Report: | |||
| Attachments: | adressesk.kexi.tar.gz | ||
|
Description
robert leleu
2013-02-27 15:22:58 UTC
Dear Robert, yes please sent the database file, can be sent to me privately if you prefer, or compressed with zip and attached below. Created attachment 77657 [details] adressesk.kexi.tar.gz compressed file attached the concerned query is «liensidentite» la 01/03/2013 00:33, Jarosław Staniek skribis (esperanto estas la unua internacia lingvo) > https://bugs.kde.org/show_bug.cgi?id=315852 > > Jarosław Staniek <staniek@kde.org> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > Status|UNCONFIRMED |NEEDSINFO > Resolution|--- |WAITINGFORINFO > > --- Comment #1 from Jarosław Staniek <staniek@kde.org> --- > Dear Robert, yes please sent the database file, can be sent to me privately if > you prefer, or compressed with zip and attached below. > Thanks for the sample. this bug is always here either with Version 2.8.2 or with Version 2.9 Pre-Alpha One year later, queries need a lot more of investment! Anyway, the SQL of the «liensidentite» query that crashes is: SELECT identite.idcleunik FROM lieide, identite, liens, localis, codecomm, pays, liens WHERE (identite.idcleunik = lieide.idcleunik AND pays.pacleunik = codecomm.pacleunik AND codecomm.cocleunik = localis.cocleunik AND localis.locleunik = identite.locleunik AND liens.licleunik = lieide.licleunik) AND (liens.licleunik = 982) it can be reduced it to this (and still crashes): SELECT liens.licleunik FROM liens, liens So the issue nailed here is as follows: using the same table in the FROM section two times (here: liens, liens) without aliasing one of them, then referencing the table (here by: liens.licleunik) either in the SELECT section or in the WHERE or JOIN sections. A fix for 2.8.4 in progress... Current workaround is to remove the extra unnecessary occurrence of the 'liens' table from the FROM section of the original query. This needs creation of a new query in the SQL view however because opening the original query even in the SQL View currently crashes. Git commit f8f807ebd94d9f9596977ba3a0a9973ede610eb0 by Jaroslaw Staniek. Committed on 04/06/2014 at 11:12. Pushed by staniek into branch 'master'. Fix crash when accessing a query with duplicated table names Example query that crashed: SELECT t.foo FROM t, t. Now error message is displayed so user can fix the statement. FIXED-IN:2.8.4 REVIEW:118519 M +5 -11 libs/db/expression.cpp http://commits.kde.org/calligra/f8f807ebd94d9f9596977ba3a0a9973ede610eb0 Git commit eaefd12562da5b422ae175351423fa15fd1a2cb4 by Jaroslaw Staniek. Committed on 04/06/2014 at 11:12. Pushed by staniek into branch 'calligra/2.8'. Fix crash when accessing a query with duplicated table names Example query that crashed: SELECT t.foo FROM t, t. Now error message is displayed so user can fix the statement. FIXED-IN:2.8.4 M +5 -11 libs/db/expression.cpp http://commits.kde.org/calligra/eaefd12562da5b422ae175351423fa15fd1a2cb4 |