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