Bug 346839

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