Hi! May be some can help me. We are using the ILIKE operator to filter data. When we use a couple of "%" at a certain point the db stops filtering correctly.
We started with *ILIKE '%guate%' *it found 7 records, then we changed to *ILIKE '%guate%**com% *it found 1 record (which is ok)... finally we changed to *ILIKE '%guate%mo%**com%**' *and now it didn't find anything :'(
Please see the attached examples...
*A*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%'*; +---------------------------+ | nts_area_name | +===========================+ | Guatemala | | Guatemala-Mobile | | Guatemala-Mobile Comcel | | Guatemala-Mobile Movistar | | Guatemala-Mobile PCS | | Guatemala-Telgua | | Guatemala-Telefonica | +---------------------------+
*B*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%**com%;* +-------------------------+ | nts_area_name | +=========================+ | Guatemala-Mobile Comcel | +-------------------------+
*C*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%mo%**com%**'*; +---------------+ | nts_area_name | +===============+ +---------------+ 0 tuples
Hi Ariel,
What version of MonetDB are you using?
Best regards,
Panos
On 5/19/20 3:17 PM, Ariel Abadi wrote:
Hi! May be some can help me. We are using the ILIKE operator to filter data. When we use a couple of "%" at a certain point the db stops filtering correctly.
We started with *ILIKE '%guate%' *it found 7 records, then we changed to *ILIKE '%guate%**com% *it found 1 record (which is ok)... finally we changed to *ILIKE '%guate%mo%**com%**' *and now it didn't find anything :'(
Please see the attached examples...
*A*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%'*; +---------------------------+ | nts_area_name | +===========================+ | Guatemala | | Guatemala-Mobile | | Guatemala-Mobile Comcel | | Guatemala-Mobile Movistar | | Guatemala-Mobile PCS | | Guatemala-Telgua | | Guatemala-Telefonica | +---------------------------+
*B*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%**com%;* +-------------------------+ | nts_area_name | +=========================+ | Guatemala-Mobile Comcel | +-------------------------+
*C*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%mo%**com%**'*; +---------------+ | nts_area_name | +===============+ +---------------+ 0 tuples
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi!
The version Im using is: v11.35.19 (Nov2019-SP3)
Thks
Ariel
On Tue, May 19, 2020 at 10:57 AM Panagiotis Koutsourakis < panagiotis.koutsourakis@monetdbsolutions.com> wrote:
Hi Ariel,
What version of MonetDB are you using?
Best regards,
Panos On 5/19/20 3:17 PM, Ariel Abadi wrote:
Hi! May be some can help me. We are using the ILIKE operator to filter data. When we use a couple of "%" at a certain point the db stops filtering correctly.
We started with *ILIKE '%guate%' *it found 7 records, then we changed to *ILIKE '%guate%**com% *it found 1 record (which is ok)... finally we changed to *ILIKE '%guate%mo%**com%**' *and now it didn't find anything :'(
Please see the attached examples...
*A*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%'*; +---------------------------+ | nts_area_name | +===========================+ | Guatemala | | Guatemala-Mobile | | Guatemala-Mobile Comcel | | Guatemala-Mobile Movistar | | Guatemala-Mobile PCS | | Guatemala-Telgua | | Guatemala-Telefonica | +---------------------------+
*B*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%**com%;* +-------------------------+ | nts_area_name | +=========================+ | Guatemala-Mobile Comcel | +-------------------------+
*C*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%mo%**com%**'*; +---------------+ | nts_area_name | +===============+ +---------------+ 0 tuples
users-list mailing listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi Panos,
I was also curios so I tried on my Nov2019. I have the impression it misses strings with a dash:
sql>select * from t where s ilike '%u%e%s%'; +----------------------+ | s | +======================+ | Guinea-Bissau | | Turkmenistan | | United Arab Emirates | | United States | | Uzbekistan | +----------------------+ 5 tuples
-- This should return (also) 'Guinea-Bissau' sql>select * from t where s ilike '%u%e%b%s%'; +----------------------+ | s | +======================+ | United Arab Emirates | +----------------------+ 1 tuple
On Tue, 19 May 2020 at 15:57, Panagiotis Koutsourakis < panagiotis.koutsourakis@monetdbsolutions.com> wrote:
Hi Ariel,
What version of MonetDB are you using?
Best regards,
Panos On 5/19/20 3:17 PM, Ariel Abadi wrote:
Hi! May be some can help me. We are using the ILIKE operator to filter data. When we use a couple of "%" at a certain point the db stops filtering correctly.
We started with *ILIKE '%guate%' *it found 7 records, then we changed to *ILIKE '%guate%**com% *it found 1 record (which is ok)... finally we changed to *ILIKE '%guate%mo%**com%**' *and now it didn't find anything :'(
Please see the attached examples...
*A*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%'*; +---------------------------+ | nts_area_name | +===========================+ | Guatemala | | Guatemala-Mobile | | Guatemala-Mobile Comcel | | Guatemala-Mobile Movistar | | Guatemala-Mobile PCS | | Guatemala-Telgua | | Guatemala-Telefonica | +---------------------------+
*B*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%**com%;* +-------------------------+ | nts_area_name | +=========================+ | Guatemala-Mobile Comcel | +-------------------------+
*C*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%mo%**com%**'*; +---------------+ | nts_area_name | +===============+ +---------------+ 0 tuples
users-list mailing listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
I can reproduce this.
Please submit a bug report at https://bugs.monetdb.org (aka https://www.monetdb.org/bugzilla).
On 19/05/2020 16.02, Roberto Cornacchia wrote:
Hi Panos,
I was also curios so I tried on my Nov2019. I have the impression it misses strings with a dash:
sql>select * from t where s ilike '%u%e%s%'; +----------------------+ | s | +======================+ | Guinea-Bissau | | Turkmenistan | | United Arab Emirates | | United States | | Uzbekistan | +----------------------+ 5 tuples
-- This should return (also) 'Guinea-Bissau' sql>select * from t where s ilike '%u%e%b%s%'; +----------------------+ | s | +======================+ | United Arab Emirates | +----------------------+ 1 tuple
On Tue, 19 May 2020 at 15:57, Panagiotis Koutsourakis <panagiotis.koutsourakis@monetdbsolutions.com mailto:panagiotis.koutsourakis@monetdbsolutions.com> wrote:
Hi Ariel, What version of MonetDB are you using? Best regards, Panos On 5/19/20 3:17 PM, Ariel Abadi wrote:Hi! May be some can help me. We are using the ILIKE operator to filter data. When we use a couple of "%" at a certain point the db stops filtering correctly. We started with *ILIKE '%guate%' *it found 7 records, then we changed to *ILIKE '%guate%**com% *it found 1 record (which is ok)... finally we changed to *ILIKE '%guate%mo%**com%**' *and now it didn't find anything :'( Please see the attached examples... *A*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%'*; +---------------------------+ | nts_area_name | +===========================+ | Guatemala | | Guatemala-Mobile | | Guatemala-Mobile Comcel | | Guatemala-Mobile Movistar | | Guatemala-Mobile PCS | | Guatemala-Telgua | | Guatemala-Telefonica | +---------------------------+ *B*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%**com%;* +-------------------------+ | nts_area_name | +=========================+ | Guatemala-Mobile Comcel | +-------------------------+ *C*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%mo%**com%**'*; +---------------+ | nts_area_name | +===============+ +---------------+ 0 tuples _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list_______________________________________________ users-list mailing list users-list@monetdb.org <mailto: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
I have a fix, but please, submit a bug report so that I can refer to that.
And it has nothing to do with dashes. That would be weird. A dash is just another character. Nothing special about it.
On 19/05/2020 16.23, Sjoerd Mullender wrote:
I can reproduce this.
Please submit a bug report at https://bugs.monetdb.org (aka https://www.monetdb.org/bugzilla).
On 19/05/2020 16.02, Roberto Cornacchia wrote:
Hi Panos,
I was also curios so I tried on my Nov2019. I have the impression it misses strings with a dash:
sql>select * from t where s ilike '%u%e%s%'; +----------------------+ | s | +======================+ | Guinea-Bissau | | Turkmenistan | | United Arab Emirates | | United States | | Uzbekistan | +----------------------+ 5 tuples
-- This should return (also) 'Guinea-Bissau' sql>select * from t where s ilike '%u%e%b%s%'; +----------------------+ | s | +======================+ | United Arab Emirates | +----------------------+ 1 tuple
On Tue, 19 May 2020 at 15:57, Panagiotis Koutsourakis <panagiotis.koutsourakis@monetdbsolutions.com mailto:panagiotis.koutsourakis@monetdbsolutions.com> wrote:
Hi Ariel, What version of MonetDB are you using? Best regards, Panos On 5/19/20 3:17 PM, Ariel Abadi wrote:Hi! May be some can help me. We are using the ILIKE operator to filter data. When we use a couple of "%" at a certain point the db stops filtering correctly. We started with *ILIKE '%guate%' *it found 7 records, then we changed to *ILIKE '%guate%**com% *it found 1 record (which is ok)... finally we changed to *ILIKE '%guate%mo%**com%**' *and now it didn't find anything :'( Please see the attached examples... *A*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%'*; +---------------------------+ | nts_area_name | +===========================+ | Guatemala | | Guatemala-Mobile | | Guatemala-Mobile Comcel | | Guatemala-Mobile Movistar | | Guatemala-Mobile PCS | | Guatemala-Telgua | | Guatemala-Telefonica | +---------------------------+ *B*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%**com%;* +-------------------------+ | nts_area_name | +=========================+ | Guatemala-Mobile Comcel | +-------------------------+ *C*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%mo%**com%**'*; +---------------+ | nts_area_name | +===============+ +---------------+ 0 tuples _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list_______________________________________________ users-list mailing list users-list@monetdb.org <mailto: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
Created!
https://www.monetdb.org/bugzilla/show_bug.cgi?id=6865
On Tue, May 19, 2020 at 12:24 PM Sjoerd Mullender sjoerd@monetdb.org wrote:
I have a fix, but please, submit a bug report so that I can refer to that.
And it has nothing to do with dashes. That would be weird. A dash is just another character. Nothing special about it.
On 19/05/2020 16.23, Sjoerd Mullender wrote:
I can reproduce this.
Please submit a bug report at https://bugs.monetdb.org (aka https://www.monetdb.org/bugzilla).
On 19/05/2020 16.02, Roberto Cornacchia wrote:
Hi Panos,
I was also curios so I tried on my Nov2019. I have the impression it misses strings with a dash:
sql>select * from t where s ilike '%u%e%s%'; +----------------------+ | s | +======================+ | Guinea-Bissau | | Turkmenistan | | United Arab Emirates | | United States | | Uzbekistan | +----------------------+ 5 tuples
-- This should return (also) 'Guinea-Bissau' sql>select * from t where s ilike '%u%e%b%s%'; +----------------------+ | s | +======================+ | United Arab Emirates | +----------------------+ 1 tuple
On Tue, 19 May 2020 at 15:57, Panagiotis Koutsourakis <panagiotis.koutsourakis@monetdbsolutions.com mailto:panagiotis.koutsourakis@monetdbsolutions.com> wrote:
Hi Ariel, What version of MonetDB are you using? Best regards, Panos On 5/19/20 3:17 PM, Ariel Abadi wrote:Hi! May be some can help me. We are using the ILIKE operator to filter data. When we use a couple of "%" at a certain point the db stops filtering correctly. We started with *ILIKE '%guate%' *it found 7 records, then we changed to *ILIKE '%guate%**com% *it found 1 record (which is ok)... finally we changed to *ILIKE '%guate%mo%**com%**' *and now it didn't find anything :'( Please see the attached examples... *A*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%'*; +---------------------------+ | nts_area_name | +===========================+ | Guatemala | | Guatemala-Mobile | | Guatemala-Mobile Comcel | | Guatemala-Mobile Movistar | | Guatemala-Mobile PCS | | Guatemala-Telgua | | Guatemala-Telefonica | +---------------------------+ *B*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%**com%;* +-------------------------+ | nts_area_name | +=========================+ | Guatemala-Mobile Comcel | +-------------------------+ *C*) sql>SELECT DISTINCT nts_area_name FROM sb_rmsv.nts_nt_sum_report WHERE nts_area_name *ILIKE '%guate%mo%**com%**'*; +---------------+ | nts_area_name | +===============+ +---------------+ 0 tuples _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list_______________________________________________ users-list mailing list users-list@monetdb.org <mailto: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
-- Sjoerd Mullender _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (4)
-
Ariel Abadi -
Panagiotis Koutsourakis -
Roberto Cornacchia -
Sjoerd Mullender