BUG #13811: Default ordering colums
| От | exru@mail.ru |
|---|---|
| Тема | BUG #13811: Default ordering colums |
| Дата | |
| Msg-id | 20151210125203.876.97836@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #13811: Default ordering colums
Re: BUG #13811: Default ordering colums |
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13811
Logged by: Vyacheslav
Email address: exru@mail.ru
PostgreSQL version: 9.4.5
Operating system: Debian 8.1
Description:
--1) create table and make batch insert of values
CREATE TABLE auction
(
id serial NOT NULL primary key,
name text,
type smallint,
client_id integer,
description text,
category_id integer,
dt_start timestamp(0) without time zone,
dt_end timestamp(0) without time zone,
status smallint DEFAULT 1
);
INSERT INTO "auction" ("id", "name", "type", "client_id", "description",
"status", "category_id", "dt_start", "dt_end") VALUES (0, 'ÐÑкÑион1', 1, 1,
'ÐÑкÑион0', -1, 5, '2015-12-10 15:38:00', NULL), (1, 'ÐÑкÑион1', -1, 1,
'ÐÑкÑион1', 0, 5, '2015-12-10 15:38:00', NULL), (2, 'ÐÑкÑион2', 1, 1,
'ÐÑкÑион2', 1, 5, '2015-12-10 15:38:00', NULL), (3, 'ÐÑкÑион3', 1, 1,
'ÐÑкÑион3', 1, 5, '2015-12-10 15:38:00', NULL), (4, 'ÐÑкÑион4', 1, 1,
'ÐÑкÑион4', 3, 7, '2015-12-10 15:38:00', NULL), (5, 'ÐÑкÑион5', 1, 1,
'ÐÑкÑион5', 4, 5, '2015-12-10 15:38:00', NULL), (6, 'ÐÑкÑион6', 1, 1,
'ÐÑкÑион6', 5, 6, '2015-12-10 15:38:00', NULL), (7, 'ÐÑкÑион7', -1, 1,
'ÐÑкÑион7', 6, 6, '2015-12-10 15:38:00', NULL), (8, 'ÐÑкÑион7', 1, 1,
'ÐÑкÑион7', 7, 7, '2015-12-10 15:38:00', NULL);
2) then i maked a select (SELECT * FROM auction;) i've get the next rows
with orders:
0;"ÐÑкÑион1";1;1;"ÐÑкÑион0";5;"2015-12-10 15:38:00";"";-1
1;"ÐÑкÑион1";-1;1;"ÐÑкÑион1";5;"2015-12-10 15:38:00";"";0
2;"ÐÑкÑион2";1;1;"ÐÑкÑион2";5;"2015-12-10 15:38:00";"";1
3;"ÐÑкÑион3";1;1;"ÐÑкÑион3";5;"2015-12-10 15:38:00";"";1
4;"ÐÑкÑион4";1;1;"ÐÑкÑион4";7;"2015-12-10 15:38:00";"";3
5;"ÐÑкÑион5";1;1;"ÐÑкÑион5";5;"2015-12-10 15:38:00";"";4
6;"ÐÑкÑион6";1;1;"ÐÑкÑион6";6;"2015-12-10 15:38:00";"";5
7;"ÐÑкÑион7";-1;1;"ÐÑкÑион7";6;"2015-12-10 15:38:00";"";6
8;"ÐÑкÑион7";1;1;"ÐÑкÑион7";7;"2015-12-10 15:38:00";"";7
3) the make the:
UPDATE "auction" SET "type"=1, "client_id"=1, "dt_start"='2015-12-10
15:38:00', "status"=-1 WHERE "id"=0; //data in the raw was not changed bat
the (SELECT * FROM auction;) give me the next order of rows:
1;"ÐÑкÑион1";-1;1;"ÐÑкÑион1";5;"2015-12-10 15:38:00";"";0
2;"ÐÑкÑион2";1;1;"ÐÑкÑион2";5;"2015-12-10 15:38:00";"";1
3;"ÐÑкÑион3";1;1;"ÐÑкÑион3";5;"2015-12-10 15:38:00";"";1
4;"ÐÑкÑион4";1;1;"ÐÑкÑион4";7;"2015-12-10 15:38:00";"";3
5;"ÐÑкÑион5";1;1;"ÐÑкÑион5";5;"2015-12-10 15:38:00";"";4
6;"ÐÑкÑион6";1;1;"ÐÑкÑион6";6;"2015-12-10 15:38:00";"";5
7;"ÐÑкÑион7";-1;1;"ÐÑкÑион7";6;"2015-12-10 15:38:00";"";6
8;"ÐÑкÑион7";1;1;"ÐÑкÑион7";7;"2015-12-10 15:38:00";"";7
0;"ÐÑкÑион1";1;1;"ÐÑкÑион0";5;"2015-12-10 15:38:00";"";-1
4) There is no any orders by or any changes in sequences. Why do that???
В списке pgsql-bugs по дате отправления: