[kexi] [Bug 348017] Add support for 'case insensitive' operator ILIKE for SQL queries

Ian Balchin inksi at fables.co.za
Tue Jun 2 15:15:56 UTC 2015


https://bugs.kde.org/show_bug.cgi?id=348017

--- Comment #3 from Ian Balchin <inksi at fables.co.za> ---
Hi there, 

i have been following the bugmails on this issue closely and see that the
solution is to force postgresql into downward compliance to case-insensitive
searches by default.

I naively thought that any query written in the SQL mode would be passed
through as written, sqlite queries being checked for sqlite-correctness, and
postgresql queries being checked for postgresql-correctness, and so on. As a
corollary I similarly imagined that the Design mode would generate an SQL query
in accordance with its programmed capabilities - which might or might not
include case-sensitive search. 

I feel that it is a pity that we have to go this way, after all choice of case
selection can be a big help in text searches. But I understand that there are
upstream design choices already implemented, and that if this has to be then
this has to be. We'll get by. 

But looking to the  future, the upshot of all this is that when the Design mode
is fully operational will the SQL mode be dispensed with? 
I don't see what purpose it will then serve since its functionality will be
limited to the capabilities coded into the Design mode. A small box at the
bottom could show the generated sql query (non-editable) for those users
seeking confirmation that the Design mode 'magick' has interpreted their
intentions correctly. I hate the thought of this, I have become very adept at
quick changes to my basic saved sql queries as sometimes needed and a line of
sql speaks to me more eloquently than a visual representation.

bestest regards
Ian

-- 
You are receiving this mail because:
You are the assignee for the bug.


More information about the Kexi-bugs mailing list