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

[Jarosław Staniek]

staniek added a comment.


  In D17336#382289 <https://phabricator.kde.org/D17336#382289>, @piggz wrote:
  
  > 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#
  
  
  @piggz
  
  Hi Adam, 
  From https://community.kde.org/Kexi/Plugins/Queries/SQL_Constants#Date_constants 
  "MSA's format such as #24 Dec 2014# is not supported"
  
  > 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#"
  
  Such things work for me, e.g. :
  "SELECT #12:13:01# AS expr1, #2018-11-27# AS expr2, date, time, dt FROM date AS d WHERE d.date < #1998-10-10#"
  
  F6509027: image.png <https://phabricator.kde.org/F6509027>

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/60949bea/attachment.html>