Bug 364811 - Error opening table with missing visible column of lookup filed
Summary: Error opening table with missing visible column of lookup filed
Status: ASSIGNED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 2.9.11
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Kexi Bugs
URL: https://forum.kde.org/viewtopic.php?f...
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-27 12:20 UTC by Jarosław Staniek
Modified: 2016-11-01 21:44 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
A file that fails (64.00 KB, application/x-kexiproject-sqlite2)
2016-06-27 12:22 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 Jarosław Staniek 2016-06-27 12:20:01 UTC 
Error opening table with missing visible column of lookup filed.

Reproducible: Always

Steps to Reproduce:
1. Create table that misses at least visible column in its lookup field but has bound column set
2. Go to the data view

Actual Results:  
"Switching to other view failed (Data View). Unspecified error encountered. SQL statement: SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE o_name='' AND o_type=1 LIMIT 1"

Expected result: the table should be open, the misconfigured lookup should just fail to work, but there should be no fatal error. When bound column is missing things work exactly this way.
Comment 1 Jarosław Staniek 2016-06-27 12:22:52 UTC 
Created attachment 99723 [details]
A file that fails

table.b is misconfigured (no visible column set) and causes the error