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.