BUG #13811: Default ordering colums

From: exru(at)mail(dot)ru
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13811: Default ordering colums
Date: 2015-12-10 12:52:03
Message-ID: 20151210125203.876.97836@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13811
Logged by: Vyacheslav
Email address: exru(at)mail(dot)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???

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2015-12-10 15:14:03 Re: BUG #13788: compile error in generic_msvc.h
Previous Message Peter Geoghegan 2015-12-09 22:36:08 Re: Incorrect UPDATE trigger invocation in the UPDATE clause of an UPSERT statement.