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
  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

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.

Reply via email to