Reviewers: ,
Please review this at http://codereview.tryton.org/220002/ Affected files: M line.py Index: line.py =================================================================== --- a/line.py +++ b/line.py @@ -196,9 +196,9 @@ 'CAST(year AS ' + type_name + ') AS year, week, ' \ 'employee, hours ' \ 'FROM (' - 'SELECT EXTRACT(WEEK FROM date) + ' \ + 'SELECT CAST(EXTRACT(WEEK FROM date) + ' \ 'EXTRACT(YEAR FROM date) * 100 + ' \ - 'employee * 1000000 AS id, ' \ + 'employee * 1000000 AS integer) AS id, ' \ 'MAX(create_uid) AS create_uid, ' \ 'MAX(create_date) AS create_date, ' \ 'MAX(write_uid) AS write_uid, ' \ @@ -234,9 +234,9 @@ 'CAST(year AS ' + type_name + ') AS year, month, ' \ 'employee, hours ' \ 'FROM (' - 'SELECT EXTRACT(MONTH FROM date) + ' \ + 'SELECT CAST (EXTRACT(MONTH FROM date) + ' \ 'EXTRACT(YEAR FROM date) * 100 + ' \ - 'employee * 1000000 AS id, ' \ + 'employee * 1000000 AS integer) AS id, ' \ 'MAX(create_uid) AS create_uid, ' \ 'MAX(create_date) AS create_date, ' \ 'MAX(write_uid) AS write_uid, ' \ -- [email protected] mailing list
