Review Request 123952: Consistency: use ILIKE/NOT ILIKE operator instead of LIKE for PostgreSQL

[Jarosław Staniek]

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://git.reviewboard.kde.org/r/123952/
-----------------------------------------------------------

Review request for Calligra, Andrius da Costa Ribas, Kamil Łysik, Friedrich W. H. Kossebau, Adam Pigg, Roman Shtemberko, Radosław Wicik, and Wojciech Kosowicz.


Bugs: 348203
    http://bugs.kde.org/show_bug.cgi?id=348203


Repository: calligra


Description
-------

Consistency: use ILIKE/NOT ILIKE operator instead of LIKE for PostgreSQL

This fixes the issue "PostgreSQL uses case-sensitive search for LIKE
SQL operator, Kexi's default is case-insensitive"

The approach isn't generic enough for other expressions (the context
of connection could be better) but it's already much better than ignoring
differences between servers.


Diffs
-----

  kexi/kexidb/drivers/pqxx/pqxxdriver.cpp 83f655c56a7d58c6f0aca87786261d0a6571345a 
  kexi/plugins/queries/kexiquerydesignerguieditor.cpp 2943df6bef7a08312ff19deeb2a146f1da0f450b 
  kexi/widget/tableview/kexicomboboxpopup.cpp 1a0e0eca61f881e638242197dc6cbeef8c69200a 
  libs/db/connection.cpp af245efb17345f515cde3b4457f74e59a849077d 
  libs/db/driver.cpp c1277a8993ced0ec7e4019fed990df8d4a0f5d5f 
  libs/db/driver_p.h 4cdfb5bf051ba3888ffe96974eee19e18a22269c 
  libs/db/expression.h a7b0410a6172c7cc662213f540497855a97501ee 
  libs/db/expression.cpp 794732ea12830dfd09aac4cd0c16675e1ab6fedb 
  libs/db/parser/parser_p.cpp 5f11f4ea8ce947bf3e4e9dfd97e5f259776fc90b 

Diff: https://git.reviewboard.kde.org/r/123952/diff/


Testing
-------

Queries work now for pgsql as for sqlite/mysql


Thanks,

Jarosław Staniek

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/calligra-devel/attachments/20150530/8d26ac04/attachment.htm>