Hi All!
We are facing a problem, we used to work with mysql with the case insensitive. Now we have moved into MonetDB and we are facing a problem with this issue.
Some of our queries are not bringing any data because of the sensitive..
SELECT * FROM Country = 'jamaica' ... 0 Records SELECT * FROM Country = 'Jamaica' ... 10 Records
Some cases we solved it using the ILIKE, but we still have some code on our app that cannot be modified.
Does anybody know if there is any flag or setup or config for the Database in Monet to make it insensitive ?
Thanks in advance for the help!
Hi
MonetDB is case sensitive, except for those places where the SQL standard allows. Strings are therefore case sensitive. There is no knob to change that behavior.
regards, Martin
On 28/04/16 23:19, Ariel Abadi wrote:
Hi All!
We are facing a problem, we used to work with mysql with the case insensitive. Now we have moved into MonetDB and we are facing a problem with this issue.
Some of our queries are not bringing any data because of the sensitive..
SELECT * FROM Country = 'jamaica' ... 0 Records SELECT * FROM Country = 'Jamaica' ... 10 Records
Some cases we solved it using the ILIKE, but we still have some code on our app that cannot be modified.
Does anybody know if there is any flag or setup or config for the Database in Monet to make it insensitive ?
Thanks in advance for the help!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
hi, would
SELECT * FROM LCASE( Country ) = 'jamaica'
solve this problem?
On Fri, Apr 29, 2016 at 2:32 AM, Martin Kersten martin@monetdb.org wrote:
Hi
MonetDB is case sensitive, except for those places where the SQL standard allows. Strings are therefore case sensitive. There is no knob to change that behavior.
regards, Martin
On 28/04/16 23:19, Ariel Abadi wrote:
Hi All!
We are facing a problem, we used to work with mysql with the case insensitive. Now we have moved into MonetDB and we are facing a problem with this issue.
Some of our queries are not bringing any data because of the sensitive..
SELECT * FROM Country = 'jamaica' ... 0 Records SELECT * FROM Country = 'Jamaica' ... 10 Records
Some cases we solved it using the ILIKE, but we still have some code on our app that cannot be modified.
Does anybody know if there is any flag or setup or config for the Database in Monet to make it insensitive ?
Thanks in advance for the help!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Anthony, as Ariel said, in some cases we cannot modify the query.
Alberto Ferrari Email/Hangout: aferrari@starconnecting.com Skype: support-starconnecting
2016-04-29 3:41 GMT-03:00 Anthony Damico ajdamico@gmail.com:
hi, would
SELECT * FROM LCASE( Country ) = 'jamaica'
solve this problem?
On Fri, Apr 29, 2016 at 2:32 AM, Martin Kersten martin@monetdb.org wrote:
Hi
MonetDB is case sensitive, except for those places where the SQL standard allows. Strings are therefore case sensitive. There is no knob to change that behavior.
regards, Martin
On 28/04/16 23:19, Ariel Abadi wrote:
Hi All!
We are facing a problem, we used to work with mysql with the case insensitive. Now we have moved into MonetDB and we are facing a problem with this issue.
Some of our queries are not bringing any data because of the sensitive..
SELECT * FROM Country = 'jamaica' ... 0 Records SELECT * FROM Country = 'Jamaica' ... 10 Records
Some cases we solved it using the ILIKE, but we still have some code on our app that cannot be modified.
Does anybody know if there is any flag or setup or config for the Database in Monet to make it insensitive ?
Thanks in advance for the help!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
It's ugly, but if you compile from source, you could change the C-code to use case insensitive comparisons. Not sure if the same code is used by MonetDB itself to lookup tables etc.
-----Original Message----- From: Alberto Ferrari [aferrari@starconnecting.commailto:aferrari@starconnecting.com] Sent: Saturday, April 30, 2016 08:38 AM Eastern Standard Time To: Communication channel for MonetDB users Subject: Re: Case sensitive
Anthony, as Ariel said, in some cases we cannot modify the query.
Alberto Ferrari Email/Hangout: aferrari@starconnecting.com Skype: support-starconnecting
2016-04-29 3:41 GMT-03:00 Anthony Damico ajdamico@gmail.com:
hi, would
SELECT * FROM LCASE( Country ) = 'jamaica'
solve this problem?
On Fri, Apr 29, 2016 at 2:32 AM, Martin Kersten martin@monetdb.org wrote:
Hi
MonetDB is case sensitive, except for those places where the SQL standard allows. Strings are therefore case sensitive. There is no knob to change that behavior.
regards, Martin
On 28/04/16 23:19, Ariel Abadi wrote:
Hi All!
We are facing a problem, we used to work with mysql with the case insensitive. Now we have moved into MonetDB and we are facing a problem with this issue.
Some of our queries are not bringing any data because of the sensitive..
SELECT * FROM Country = 'jamaica' ... 0 Records SELECT * FROM Country = 'Jamaica' ... 10 Records
Some cases we solved it using the ILIKE, but we still have some code on our app that cannot be modified.
Does anybody know if there is any flag or setup or config for the Database in Monet to make it insensitive ?
Thanks in advance for the help!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
On 30/04/16 17:17, Anderson, David B wrote:
It's ugly, but if you compile from source, you could change the C-code to use case insensitive comparisons. Not sure if the same code is used by MonetDB itself to lookup tables etc.
It is. Bad luck with your mysql application.
Yes, the string comparison method is system wide. It complies with the SQL standard.
You might, after 'fixing' this issue, quickly hit on more incompatibilities.
This reference gives you a first glance... https://en.wikibooks.org/wiki/SQL_Dialects_Reference
regards, Martin
-----Original Message----- *From: *Alberto Ferrari [aferrari@starconnecting.com mailto:aferrari@starconnecting.com] *Sent: *Saturday, April 30, 2016 08:38 AM Eastern Standard Time *To: *Communication channel for MonetDB users *Subject: *Re: Case sensitive
Anthony, as Ariel said, in some cases we cannot modify the query.
Alberto Ferrari Email/Hangout: aferrari@starconnecting.com Skype: support-starconnecting
2016-04-29 3:41 GMT-03:00 Anthony Damico ajdamico@gmail.com:
hi, would
SELECT * FROM LCASE( Country ) = 'jamaica'
solve this problem?
On Fri, Apr 29, 2016 at 2:32 AM, Martin Kersten martin@monetdb.org wrote:
Hi
MonetDB is case sensitive, except for those places where the SQL standard allows. Strings are therefore case sensitive. There is no knob to change that behavior.
regards, Martin
On 28/04/16 23:19, Ariel Abadi wrote:
Hi All!
We are facing a problem, we used to work with mysql with the case insensitive. Now we have moved into MonetDB and we are facing a problem with this issue.
Some of our queries are not bringing any data because of the sensitive..
SELECT * FROM Country = 'jamaica' ... 0 Records SELECT * FROM Country = 'Jamaica' ... 10 Records
Some cases we solved it using the ILIKE, but we still have some code on our app that cannot be modified.
Does anybody know if there is any flag or setup or config for the Database in Monet to make it insensitive ?
Thanks in advance for the help!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
If you can't modify the queries in your application, you could intercept the query inside MonetDB before it gets passed into the parser and modify it there.
-----Original Message----- From: Martin Kersten [martin.kersten@cwi.nlmailto:martin.kersten@cwi.nl] Sent: Saturday, April 30, 2016 11:36 AM Eastern Standard Time To: users-list@monetdb.org Subject: Re: Case sensitive
On 30/04/16 17:17, Anderson, David B wrote:
It's ugly, but if you compile from source, you could change the C-code to use case insensitive comparisons. Not sure if the same code is used by MonetDB itself to lookup tables etc.
It is. Bad luck with your mysql application.
Yes, the string comparison method is system wide. It complies with the SQL standard.
You might, after 'fixing' this issue, quickly hit on more incompatibilities.
This reference gives you a first glance... https://en.wikibooks.org/wiki/SQL_Dialects_Reference
regards, Martin
-----Original Message----- *From: *Alberto Ferrari [aferrari@starconnecting.com mailto:aferrari@starconnecting.com] *Sent: *Saturday, April 30, 2016 08:38 AM Eastern Standard Time *To: *Communication channel for MonetDB users *Subject: *Re: Case sensitive
Anthony, as Ariel said, in some cases we cannot modify the query.
Alberto Ferrari Email/Hangout: aferrari@starconnecting.com Skype: support-starconnecting
2016-04-29 3:41 GMT-03:00 Anthony Damico ajdamico@gmail.com:
hi, would
SELECT * FROM LCASE( Country ) = 'jamaica'
solve this problem?
On Fri, Apr 29, 2016 at 2:32 AM, Martin Kersten martin@monetdb.org wrote:
Hi
MonetDB is case sensitive, except for those places where the SQL standard allows. Strings are therefore case sensitive. There is no knob to change that behavior.
regards, Martin
On 28/04/16 23:19, Ariel Abadi wrote:
Hi All!
We are facing a problem, we used to work with mysql with the case insensitive. Now we have moved into MonetDB and we are facing a problem with this issue.
Some of our queries are not bringing any data because of the sensitive..
SELECT * FROM Country = 'jamaica' ... 0 Records SELECT * FROM Country = 'Jamaica' ... 10 Records
Some cases we solved it using the ILIKE, but we still have some code on our app that cannot be modified.
Does anybody know if there is any flag or setup or config for the Database in Monet to make it insensitive ?
Thanks in advance for the help!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (6)
-
Alberto Ferrari -
Anderson, David B -
Anthony Damico -
Ariel Abadi -
Martin Kersten -
Martin Kersten