https://bugs.kde.org/show_bug.cgi?id=393094
Bug ID: 393094
Summary: Restore support for date constants in KEXI SQL
Product: KEXI
Version: 3.1.0
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Queries
Assignee: kexi-b...@kde.org
Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za
Target Milestone: ---
Previously KEXI (KDb SQL parser) accepted text argument such as '2018-04-13'
where date type is expected, e.g. in comparisons. Currently, since ~ 3.x it
detects incompatible type, text vs date.
The same applies to date/time and time.
To reproduce: assuming t.d is of date type, enter SQL query such as "SELECT d
FROM t WHERE d >= '2018-04-12'.
Result: incompatible types
Expected: any convenient way to write such expressions.
Forum thread:
Based on https://forum.kde.org/viewtopic.php?f=221&t=119757&p=397275#p397275
Restore support for date constants, based on ideas from the thread. Keep the
strict type check though.
Visual query designer should support date constants too.
--
You are receiving this mail because:
You are watching all bug changes.
