.search() with like operator and underscore in search string problem
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Server (MOVED TO GITHUB) |
Invalid
|
Undecided
|
Unassigned |
Bug Description
The like/ilike operator seems to have problems when there are underscore(s) in the search string.
After some research i found that the underscore is special char for postgres and needs some escaping. However there seems to a problem with either openerp or psycopg.
The query i try to run:
self.pool.
After that i tried to do it via .execute():
cr.execute('select ir_model_fields.id from "ir_model_fields" where (ir_model_
when i turn on sql logs it gets transformed to:
sql:query: select ir_model_fields.id from "ir_model_fields" where (ir_model_
I can copy that sql and execute it just fine in postgres with the expected results, however in openerp i get a empty list back.
Hi,
I am keen to know if it affects the magento erp connector, since the example that has been cited is from the connector.
Thanks