| chat.freenode.net #tryton log beginning Wed Feb 29 00:00:01 CET 2012 | ||
| corro | did you know that tryton has a problem with leap years? | 11:09 |
|---|---|---|
| corro | ValueError: day is out of range for month | 11:10 |
| bechamel | corro: yes, it is reported here https://bugs.tryton.org/issue2470 | 11:14 |
| corro | bechamel: ok, thx | 11:15 |
| cedk | need native english speaker for https://groups.google.com/d/topic/tryton/F_3UgElhJt4/discussion | 12:05 |
| andreasgrab | Hi, my clients under Windows and OS X (both 2.2.1) does not show images. Linux client work. XML: <field name="preview" widget="image" colspan="2"/>, Anny ideas why? | 13:50 |
| cedk | andreasgrab: gdk-pixbuf loarders should be wrongly registered | 13:52 |
| andreasgrab | Thanks! But i have no idea how to solve or even search | 14:01 |
| cedk | andreasgrab: gdk-pixbuf-query-loaders should give you the links | 14:13 |
| -!- andreasgrab(~andreas@2001:15c0:662b:6:223:18ff:fe99:3e8f) has left #tryton | 14:41 | |
| reichlich | cedk, am I wrong or is no SPLIT_PART function in the MySQL backend implementation? | 16:07 |
| cedk | reichlich: what do you mean? | 16:12 |
| reichlich | cedk, the SPLIT_PART function used by property for example. Is that function implemented for the MySQL backend? | 16:14 |
| cedk | reichlich: what do you name MySQL backend? | 16:15 |
| reichlich | cedk, the trytond backend implementations trytond/backend/mysql/* | 16:16 |
| reichlich | cedk, for sqlite in the backend implementation the SPLIT_PART function is added | 16:17 |
| cedk | reichlich: I will guess that MySQL support this SQL statement | 16:42 |
| reichlich | cedk, nope | 16:44 |
| cedk | reichlich: so how did it work for you? | 16:54 |
| -!- udono(~udono@ip-109-91-208-150.unitymediagroup.de) has left #tryton | 17:00 | |
| -!- udono(~udono@ip-109-91-208-150.unitymediagroup.de) has left #tryton | 17:01 | |
| sharoonthomas | cedk: will there be a package release of triton client with Issue2469 fixed ? | 17:04 |
| sharoonthomas | s/triton/tryton | 17:05 |
| reichlich | cedk, it did not. For some reason the tests ran with SQLite. Now I got the same error | 17:08 |
| cedk | sharoonthomas: yes but iany it will be fixed tomorrow :-) | 17:09 |
| cedk | reichlich: ok | 17:09 |
| cedk | reichlich: so we should add the functionnality to MySQL | 17:09 |
| sharoonthomas | cedk: what is the fastest workaround ? change search_value ? | 17:10 |
| reichlich | cedk, with a stored procedure? | 17:10 |
| cedk | sharoonthomas: yes but it is an XML record | 17:11 |
| cedk | reichlich: difficult to maintain | 17:11 |
| sharoonthomas | cedk: yes, SQL update :P | 17:11 |
| cedk | reichlich: I don't now if we can do the same as for sqlite | 17:13 |
| reichlich | cedk, I think we can not | 17:14 |
| cedk | reichlich: perhaps by using substring ? | 17:15 |
| cedk | reichlich: like we do for EXTRACT_EPOCH_PATTERN and CAST_VARCHAR_PATTERN | 17:17 |
| reichlich | cedk, maybe SUBSTRING_INDEX could do the job | 17:18 |
| cedk | reichlich: yes | 17:18 |
| reichlich | cedk, why is a SP difficult to maintain? | 17:20 |
| cedk | reichlich: how do you know you must change it? | 17:21 |
| cedk | reichlich: any way, I think you can replace split_part by substring_index with a regexp in mysql backend | 17:22 |
| reichlich | cedk, what about the CAST issues I wrote about on issue 2345? | 17:26 |
| cedk | I will never say that MySQL is bastar | 17:27 |
| cedk | reichlich: are you sure about the CAST issue? | 17:30 |
| cedk | reichlich: we used CAST in some other places without issue | 17:30 |
| reichlich | cedk, CAST('012' AS INTEGER) does not work | 17:31 |
| cedk | reichlich: I would prefer to fix it in mysql backend | 17:31 |
| reichlich | cedk, I think all other types have to be handled like with CAST_VARCHAR_PATTERN | 17:32 |
| cedk | reichlich: agree | 17:32 |
| reichlich | cedk, the way the SQL query manipulation is handled by now does not work in all situations, because of the QUOTE_SEPARATION | 17:51 |
| reichlich | cedk, if some string occurs within the CAST the EXTRACT_* patterns wont match | 17:52 |
| cedk | reichlich: I don't understand | 17:53 |
| reichlich | cedk, see http://pastebin.com/7RwRKVr2 | 17:55 |
| -!- Mayank1(~mayank@122.162.15.148) has left #tryton | 17:55 | |
| cedk | reichlich: we should go for python-sql | 17:57 |
| reichlich | cedk, yes | 17:58 |
| reichlich | cedk, do you think to leave that as is until python-sql? | 18:00 |
| cedk | reichlich: don't know, I don't care too much about MySQL | 18:00 |
| reichlich | cedk, when python-sql will be included? | 18:02 |
| cedk | reichlich: when it is ready | 18:03 |
Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!