Kexi query parameters do not work in COLUMNS section,
e.g. this won't work ('invalid query' error appears):
SELECT [Param]
The parameters work only in the WHERE section,
e.g. SELECT 123 WHERE [Param] = 1
BUG:348473
Details
Details
Test the query in the attached db https://bugs.kde.org/show_bug.cgi?id=348473#c1
Diff Detail
Diff Detail
- Repository
- R8 Calligra
- Lint
Automatic diff as part of commit; lint not applicable. - Unit
Automatic diff as part of commit; unit tests not applicable.
Comment Actions
should such queries require a from clause? im thinking of oracle db that uses special 'dual' table to select such params from...in the case where no 'from' is used, how many rows are returned?
Comment Actions
FROM is not required in KDbSQL (ex KexiSQL). Our SQL parser is flexible, so we can be more liberal than db engines. A number of engines including SQLite allows to select without the FROM. Then 1 row is returned. This is a nice way to test expressions that don't need actual columns.