IRC logs of #tryton for Wednesday, 2012-02-29 #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
2012-02-29 11:15 <corro> bechamel: ok, thx
2012-02-29 12:05 <cedk> need native english speaker for
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( has left #tryton
2012-02-29 17:01 -!- udono( 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
2012-02-29 17:55 -!- Mayank1(~mayank@ 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 2.17.3 by Marius Gedminas - find it at!