Bug 364811

Summary: Error opening table with missing visible column of lookup filed
Product: [Applications] KEXI Reporter: Jarosław Staniek <staniek>
Component: TablesAssignee: Kexi Bugs <kexi-bugs>
Status: ASSIGNED ---    
Severity: normal CC: adam, inksi
Priority: NOR    
Version: 2.9.11   
Target Milestone: ---   
Platform: Other   
OS: Linux   
URL: https://forum.kde.org/viewtopic.php?f=221&t=133426
Latest Commit: Version Fixed In:
Attachments: A file that fails

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