"query 1" shows 2 filters, datas odf query 1 shows the result. in "query" I switched to fields to unvisibly. Then look at the "datas of query 2" No datas in "strasse_neu" present. Reproducible: Always Steps to Reproduce: 1. erasing the complet query and making a new one. 2.same steps 3.same result Actual Results: Look at the details Expected Results: showing the invisible datas Please let the last settings unchanged if you open settings of the query. till now, when i open the settings they look like in the beginning with unswiched fields (the red marks in "query 2"
Many thanks Albrecht. The best persistent place for attachment is under the link 'Add an attachment' below.
Albrecht, could you please also attach the .kexi file co we won't have to "invent" a copy again? I tried but failed.
Created attachment 92319 [details] reduced database for Bug 346839
Created attachment 92320 [details] 1 of 4 img.
Created attachment 92321 [details] 2. of 4 img.
Created attachment 92322 [details] 3. of 4 img.
Created attachment 92323 [details] 4. of 4 img.
Thanks for the files!
The bug concerns in every case the last row of the request. Today checked with version 2.9.3
Created attachment 92681 [details] bug reproduced in 2.9.4
The bug appears again in 2.9.9. I send some scrrenshots. picture 1+2 = all fields ar shown picture 3+4 (2 fields changed to unvisible) = the last field shows no datas
Created attachment 95477 [details] 1
Created attachment 95478 [details] 2
Created attachment 95479 [details] 3
Created attachment 95480 [details] 4
At the last day of 2015 I note, that the bug unfortunatly is NOT solved. It is very necessary. All my best wishes for you all.
Setting as fixes for 2.9.11 - just for YOU :)
Best wishes and happy Kexi using in 2016!
Confirmed. Another issue is that changes to the visibility flag is not retained.
Created attachment 96684 [details] Minimal .kexi test file
A fix for SQLite is almost ready: https://phabricator.kde.org/D829. Other backends would be fixed separately.
For MySQL: the same error - to be fixed For PostgreSQL: crash
Query Designer fixed for SQLite/MySQL/PostreSQL/Sybase. In review now.
Git commit 04017e15d00ba770cf82f9afc3f2d7de292468ea by Jaroslaw Staniek. Committed on 19/01/2016 at 20:51. Pushed by staniek into branch 'calligra/2.9'. Fix Kexi/CalligraDB: Switching off the visibility of query fields hides data in the last field Summary: This is a fix for Query Designer with SQLite/MySQL/PostreSQL/Sybase. See https://bugs.kde.org/attachment.cgi?id=96684 for test file FIXED-IN:2.9.11 Test Plan: Try the minimal example from https://bugs.kde.org/attachment.cgi?id=96684, open query1 in design mode, set Visible=off for id and a fields, switch to data view. Field b has data loaded after this fix. Reviewers: piggz Subscribers: Kexi-Devel-list Differential Revision: https://phabricator.kde.org/D829 M +12 -12 kexi/kexidb/drivers/mysql/mysqlcursor.cpp M +2 -3 kexi/kexidb/drivers/pqxx/pqxxcursor.cpp M +5 -5 kexi/kexidb/drivers/sybase/sybasecursor.cpp M +7 -7 libs/db/cursor.cpp M +2 -2 libs/db/cursor.h M +6 -18 libs/db/drivers/sqlite/sqlitecursor.cpp M +31 -17 libs/db/queryschema.cpp M +13 -3 libs/db/queryschema.h M +15 -1 libs/db/queryschema_p.cpp M +10 -1 libs/db/queryschema_p.h http://commits.kde.org/calligra/04017e15d00ba770cf82f9afc3f2d7de292468ea
Landed!
Git commit a1d47334f8ae29067c02a039d118eca3e5c4f58d by Jaroslaw Staniek. Committed on 29/02/2016 at 23:16. Pushed by staniek into branch 'master'. Fix: Switching off the visibility of query fields hides data in the last field This is a fix for Query Designer with SQLite/MySQL/PostreSQL/Sybase. See https://bugs.kde.org/attachment.cgi?id=96684 for test file FIXED-IN:2.9.11 Test Plan: Try the minimal example from https://bugs.kde.org/attachment.cgi?id=96684, open query1 in design mode, set Visible=off for id and a fields, switch to data view. Field b has data loaded after this fix. Differential Revision: https://phabricator.kde.org/D829 (from calligra.git) M +9 -8 src/KDbCursor.cpp M +3 -3 src/KDbCursor.h M +31 -16 src/KDbQuerySchema.cpp M +19 -3 src/KDbQuerySchema.h M +15 -1 src/KDbQuerySchema_p.cpp M +10 -1 src/KDbQuerySchema_p.h M +11 -12 src/drivers/mysql/MysqlCursor.cpp M +3 -3 src/drivers/postgresql/PostgresqlCursor.cpp M +6 -14 src/drivers/sqlite/SqliteCursor.cpp M +6 -5 src/drivers/sybase/SybaseCursor.cpp http://commits.kde.org/kdb/a1d47334f8ae29067c02a039d118eca3e5c4f58d