Bug 277869

Summary: Cannot insert the same table twice in the Query Designer
Product: KEXI Reporter: Dimitrios T Tanis <dimitrios.tanis>
Component: QueriesAssignee: Kexi Bugs <kexi-bugs>
Status: CONFIRMED ---    
Severity: wishlist CC: wllacer
Priority: NOR    
Version: 3.0.x   
Target Milestone: ---   
Platform: Compiled Sources   
OS: Linux   
Latest Commit: Version Fixed In:
Attachments: Sample database

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