Bug 277869 - Cannot insert the same table twice in the Query Designer
Summary: Cannot insert the same table twice in the Query Designer
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Queries (show other bugs)
Version: 3.0.x
Platform: Compiled Sources Linux
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
: 299031 (view as bug list)
Depends on:
Blocks:
 
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:
Sentry Crash Report:

Attachments
Sample database (11.00 KB, application/octet-stream)
2012-04-29 21:13 UTC, Jarosław Staniek 		Details
View All Add an attachment

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