BUG #12885: The result of casting a double to an integer depends on the database version

Поиск
Список
Период
Сортировка
От rschaaf@commoninf.com
Тема BUG #12885: The result of casting a double to an integer depends on the database version
Дата
Msg-id 20150320194337.2573.72944@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #12885: The result of casting a double to an integer depends on the database version  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12885
Logged by:          Rich Schaaf
Email address:      rschaaf@commoninf.com
PostgreSQL version: 9.4.1
Operating system:   Windows 7
Description:

The result returned by the following query appears to depend on the
PostgreSQL database version.

The query is:
select column1 AS double_value, cast(column1 AS INT) AS int_value
  from (VALUES (-2.5::double precision),
               (-1.5::double precision),
               (-0.5::double precision),
               (0.5::double precision),
               (1.5::double precision),
               (2.5::double precision)) t;

In PostgreSQL 9.3.5, the query returns:
double_value, int_value
  -2.5, -3
  -1.5, -2
  -0.5, -1
  0.5, 1
  1.5, 2
  2.5, 3

PostgreSQL 9.4.1, the query returns:
  -2.5, -2
  -1.5, -2
  -0.5, 0
  0.5, 0
  1.5, 2
  2.5, 2

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Paragon Corporation"
Дата:
Сообщение: Re: BUG #12869: PostGIS 2.2 can't compile against 9.5 dev branch
Следующее
От: aleksmstu@mail.ru
Дата:
Сообщение: BUG #12888: Ignoring OPERATOR::RESTRICT=eqsel with subquery (pgsql-performance)