[KEXI] [Bug 393094] New: Restore support for date constants in KEXI SQL

[Jarosław Staniek]

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-bugs at kde.org
          Reporter: staniek at kde.org
                CC: adam at piggz.co.uk, inksi at 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 the assignee for the bug.