D17336: Restore support for date/time constants in KEXI SQL

[Adam Pigg]

piggz added a comment.


  I tested a simple expression, such as
  select #date# as expr1
  and it worked
  But a more complex query such as
  SELECT mi_band_activity.*, timestamp_dt FROM mi_band_activity where timestamp_dt > #23-May-2018#
  does not work, gives the following output:
  org.kde.kdb.core: checking variable name:  "mi_band_activity.*"
  org.kde.kdb.core: checking variable name:  "timestamp_dt"
  org.kde.kdb.core: checking variable name:  "timestamp_dt"
  org.kde.kdb.core: error:  
  org.kde.kdb.core: at character  95  near tooken  "#"
  org.kde.kdb.core: KDbEscapedString:"SELECT mi_band_activity.*, timestamp_dt FROM mi_band_activity where timestamp_dt > #23-05-2018#"

REPOSITORY
  R15 KDb

REVISION DETAIL
  https://phabricator.kde.org/D17336

To: staniek, piggz, dczechowicz, wkosowicz
Cc: Kexi-Devel-list, barman, wicik, staniek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kexi-devel/attachments/20181225/cdacd4fd/attachment.html>