Bug ID: 393094
Summary: Restore support for date constants in KEXI SQL
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.
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.