FIXED-IN:3.0.1
BUG:376970
T5473
Note: the code in form view has been updated too but because (like in 2.9.x) autofields are disabled it's still not functional.
FIXED-IN:3.0.1
BUG:376970
T5473
Note: the code in form view has been updated too but because (like in 2.9.x) autofields are disabled it's still not functional.
Create a new query design, insert 2 or more tables, add relation using drag and drop, add fields to the query. Move to the data view and SQL view. Expected: correct data result, SQL is present with WHERE condition.
No Linters Available |
No Unit Test Coverage |
Tested on 3.0 branch. Works fine.
One question. Why is the generated SQL in the form 'WHERE x.x = x.x' and not an INNER JOIN?
One question. Why is the generated SQL in the form 'WHERE x.x = x.x' and not an INNER JOIN?
It's a trace of the old SQLite driver (version 2?). Because it's internally used we will be able to switch to INNER JOIN without breaking compatibility. It would be just good to also add xxx JOIN construct to the KexiSQL parser in one go. (related wish and recent request: https://bugs.kde.org/show_bug.cgi?id=141345#c3).