Queries like "SELECT id_t1 FROM t2" become "SELECT t2.id_t1 FROM t2" after save. Reproducible: Always Steps to Reproduce: 1. Open the attached test database. 2. Create query "SELECT id_t1 FROM t2" in the SQL view, save it; "q8" is such a query already created. 3. Close the view, reopen it in SQL view. Actual Results: The query becomes "SELECT t2.id_t1 FROM t2" Expected Results: No changes should are needed here. Fixing this issue would reduce number of unexpected changes Kexi makes to definitions created by the user.
Created attachment 85205 [details] Test database
Git commit 05639c4e7c885b4d4e1016c96156838ef8079974 by Jaroslaw Staniek. Committed on 17/02/2014 at 22:23. Pushed by staniek into branch 'master'. Do not add tablename in a generated SQL when not needed M +12 -5 libs/db/connection.cpp http://commits.kde.org/calligra/05639c4e7c885b4d4e1016c96156838ef8079974
Git commit 4f1f67623d438bfca7d5a917fda3aab7dd681d00 by Jaroslaw Staniek. Committed on 17/02/2014 at 22:23. Pushed by staniek into branch 'calligra/2.8'. Do not add tablename in a generated SQL when not needed REVIEW:115855 M +12 -5 libs/db/connection.cpp http://commits.kde.org/calligra/4f1f67623d438bfca7d5a917fda3aab7dd681d00