Issue 11203

Title
Replace ilike by like on search on Reference field
Priority
feature
Status
resolved
Nosy list
ced, reviewbot, roundup-bot
Assigned to
ced
Keywords
review

Created on 2022-02-02.09:35:35 by ced, last changed 4 months ago by roundup-bot.

Messages

New changeset a6086ed74be4 by Cédric Krier in branch 'default':
Replace ilike operator by like on Reference
https://hg.tryton.org/tryton-env/rev/a6086ed74be4
New changeset 40122ebebce7 by Cédric Krier in branch 'default':
Replace ilike operator by like on Reference
https://hg.tryton.org/trytond/rev/40122ebebce7
New changeset ce77aff68339 by Cédric Krier in branch 'default':
Replace ilike operator by like on Reference
https://hg.tryton.org/modules/account_statement/rev/ce77aff68339
Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-02-02.09:35:33

The clause "reference" ilike 'model name,%' can not be optimized by an index but the form "reference" like 'model name,%' can with an index on reference with COLLATE "C".
So we should always use this form on reference because we know it is not case dependent.

History
Date User Action Args
2022-02-17 00:48:38roundup-botsetmessages: + msg74208
2022-02-17 00:48:35roundup-botsetmessages: + msg74207
2022-02-17 00:48:28roundup-botsetmessages: + msg74206
nosy: + roundup-bot
status: testing -> resolved
2022-02-02 09:43:02reviewbotsetmessages: + msg73707
nosy: + reviewbot
2022-02-02 09:36:12cedsetkeyword: + review
reviews: 395431002
status: in-progress -> testing
2022-02-02 09:35:35cedcreate

Showing 10 items. Show all history (warning: this could be VERY long)