Horton
Menu

Proposal_OrderBy_insert.sql.out.patch

application/octet-stream

Download
Filename: Proposal_OrderBy_insert.sql.out.patch
Type: application/octet-stream
Part: 0
Message: [PROPOSAL] : Use of ORDER BY clause in insert.sql

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: unified
File+−
src/test/regress/expected/insert.out 9 9
src/test/regress/sql/insert.sql 2 2 
diff --git a/src/test/regress/expected/insert.out b/src/test/regress/expected/insert.out
index dd4354f..5f09654 100644
--- a/src/test/regress/expected/insert.out
+++ b/src/test/regress/expected/insert.out
@@ -287,17 +287,17 @@ insert into part_default_p2 values ('de', 35);
 insert into list_parted values ('ab', 21);
 insert into list_parted values ('xx', 1);
 insert into list_parted values ('yy', 2);
-select tableoid::regclass, * from list_parted;
+select tableoid::regclass, * from list_parted order by 1, 3;
       tableoid      | a  | b  
 --------------------+----+----
  part_cc_dd         | cC |  1
+ part_null          |    |  0
  part_ee_ff1        | ff |  1
  part_ee_ff2        | ff | 11
  part_xx_yy_p1      | xx |  1
  part_xx_yy_defpart | yy |  2
- part_null          |    |  0
- part_default_p1    | cd | 25
  part_default_p1    | ab | 21
+ part_default_p1    | cd | 25
  part_default_p2    | de | 35
 (9 rows)
 
@@ -361,21 +361,21 @@ DETAIL:  Partition key of the failing row contains (b) = (0).
 -- ok
 insert into list_parted values ('EE', 1);
 insert into part_ee_ff values ('EE', 10);
-select tableoid::regclass, * from list_parted;
+select tableoid::regclass, * from list_parted order by 1, 3;
       tableoid      | a  | b  
 --------------------+----+----
  part_aa_bb         | aA |   
  part_cc_dd         | cC |  1
- part_ee_ff1        | ff |  1
+ part_null          |    |  0
+ part_null          |    |  1
  part_ee_ff1        | EE |  1
- part_ee_ff2        | ff | 11
+ part_ee_ff1        | ff |  1
  part_ee_ff2        | EE | 10
+ part_ee_ff2        | ff | 11
  part_xx_yy_p1      | xx |  1
  part_xx_yy_defpart | yy |  2
- part_null          |    |  0
- part_null          |    |  1
- part_default_p1    | cd | 25
  part_default_p1    | ab | 21
+ part_default_p1    | cd | 25
  part_default_p2    | de | 35
 (13 rows)
 
diff --git a/src/test/regress/sql/insert.sql b/src/test/regress/sql/insert.sql
index bdcffd0..bb65135 100644
--- a/src/test/regress/sql/insert.sql
+++ b/src/test/regress/sql/insert.sql
@@ -190,7 +190,7 @@ insert into part_default_p2 values ('de', 35);
 insert into list_parted values ('ab', 21);
 insert into list_parted values ('xx', 1);
 insert into list_parted values ('yy', 2);
-select tableoid::regclass, * from list_parted;
+select tableoid::regclass, * from list_parted order by 1, 3;
 
 -- Check tuple routing for partitioned tables
 
@@ -228,7 +228,7 @@ insert into part_ee_ff values ('EE', 0);
 -- ok
 insert into list_parted values ('EE', 1);
 insert into part_ee_ff values ('EE', 10);
-select tableoid::regclass, * from list_parted;
+select tableoid::regclass, * from list_parted order by 1, 3;
 
 -- some more tests to exercise tuple-routing with multi-level partitioning
 create table part_gg partition of list_parted for values in ('gg') partition by range (b);