Month interval bug
От | Andrew V. Gromozdin |
---|---|
Тема | Month interval bug |
Дата | |
Msg-id | 37F4BE46.ED099D96@dataforce.net обсуждение исходный текст |
Список | pgsql-bugs |
============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Andrew V. Gromozdin Your email address : ag@df.ru System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.38 ELF PostgreSQL version (example: PostgreSQL-6.4.2) : PostgreSQL-6.4.2 Compiler used (example: gcc 2.8.0) : gcc 2.7.2.3 Please enter a FULL description of your problem: ------------------------------------------------ QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime + '1month'::timespan as err or_date; error_date --------------------------------- Fri\ Oct\ 01\ 00:00:01\ 1999\ MSD (1 row) QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime + '2month'::timespan as err or_date; error_date --------------------------------- Sun\ Oct\ 31\ 23:00:01\ 1999\ MSK (1 row) QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime + '3month'::timespan as err or_date; error_date --------------------------------- Tue\ Nov\ 30\ 23:00:01\ 1999\ MSK (1 row) QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime + '4month'::timespan as err or_date; error_date --------------------------------- Fri\ Dec\ 31\ 23:00:01\ 1999\ MSK (1 row) QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime + '5month'::timespan as err or_date; error_date --------------------------------- Mon\ Jan\ 31\ 23:00:01\ 2000\ MSK (1 row) Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- run this query from psql If you know how this problem might be fixed, list the solution below: --------------------------------------------------------------------- I think it's because of unnormal defined MONTH interval -- Sincerely Your Andrew V. Gromozdin, DataForce ISP, Moscow, Russia
В списке pgsql-bugs по дате отправления: