Bug 277869 - Cannot insert the same table twice in the Query Designer
Summary: Cannot insert the same table twice in the Query Designer
Alias: None
Product: KEXI
Classification: Unclassified
Component: Queries (show other bugs)
Version: 3.0.x
Platform: Compiled Sources Linux
: NOR wishlist (vote)
Target Milestone: ---
Assignee: Kexi Bugs
: 299031 (view as bug list)
Depends on:
Reported: 2011-07-15 23:51 UTC by Dimitrios T Tanis
Modified: 2014-12-03 01:49 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:

Sample database (11.00 KB, application/octet-stream)
2012-04-29 21:13 UTC, Jarosław Staniek

Note You need to log in before you can comment on or make changes to this bug.
Description Dimitrios T Tanis 2011-07-15 23:51:53 UTC
Version:           2.4 alpha2 (Calligra 2.4 alpha2) (using KDE 4.6.0) 
OS:                Linux

When designing a query, you cannot add a table two times.
That could be very useful, infact needed when dealing with tables that have self lookups (a classic example would be employees and the employee they report to).

Reproducible: Didn't try

Steps to Reproduce:
Open query designer. Pick a table, click insert.
Pick the same table again. Click insert.

Actual Results:  
The same table cannot be inserted twice.

Expected Results:  
There should not problem adding many instances of tables.
Comment 1 Jarosław Staniek 2011-07-17 22:13:35 UTC
Should be supported indeed. It is supported in the SQL view: e.g. [SELECT * FROM TABLE1 AS T, TABLE1 AS S WHERE ...] works, and we support this by allowing aliases in our parser. Using the SQL view for such queries is the current workaround.
Comment 2 Dimitrios T Tanis 2012-04-29 19:42:14 UTC
*** Bug 299031 has been marked as a duplicate of this bug. ***
Comment 3 Jarosław Staniek 2012-04-29 21:13:14 UTC
Created attachment 70765 [details]
Sample database

copied from report #299031 by Werner