Bug 408852

Summary:	SQL query - filter that use values from secondary tables
Product:	[Applications] KEXI	Reporter:	Albrecht Will <albrecht.will>
Component:	Queries	Assignee:	Kexi Bugs <kexi-bugs>
Status:	REPORTED ---
Severity:	normal	CC:	adam, inksi, staniek
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	Other
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Albrecht Will 2019-06-17 21:01:22 UTC

SUMMARY
In a database I use secondary tables. One column of the main-table is named "land", using a secondary table "z_bundesland". See attachment Screenshot_table-design.png.

If I use a form, the graph works well and shows the value "land". Here see attachments Hueselitz.png and sentences_with_Column_given_by_form.png.

If I use the filter with a value from "z_land" as part of the secondary table "land", (SQL-land.png) then then the result is shown in attachment result_of_SQL.png. The column "land" is empty.

Searching for a reason, I found an early csv that I used as an ex- or import in or out of kexi. Could this be an invisible rudiment? Attachment Sentences_in_csv_2016.png. Currently these sentences have the invisible value "Sachsen-Anhalt".
Confused!

OBSERVED RESULT


EXPECTED RESULT


SOFTWARE/OS VERSIONS

Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 5.15.5
KDE Frameworks Version: 5.59.0
Qt Version: 5.12.3

ADDITIONAL INFORMATION

Attachments are privatly sent to Jaroslaw Staniek.