diff options
| -rw-r--r-- | src/test/regress/expected/create_index.out | 14 | ||||
| -rw-r--r-- | src/test/regress/expected/subselect.out | 71 | ||||
| -rw-r--r-- | src/test/regress/sql/subselect.sql | 6 |
3 files changed, 48 insertions, 43 deletions
diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out index 6b80fc40f3..8d0d6ef647 100644 --- a/src/test/regress/expected/create_index.out +++ b/src/test/regress/expected/create_index.out @@ -2975,12 +2975,16 @@ explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1,42,7) ORDER BY unique1; - QUERY PLAN -------------------------------------------------------------- + QUERY PLAN +------------------------------------------------------------------------- Remote Subquery Scan on all (datanode_1,datanode_2) - -> Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: (unique1 = ANY ('{1,42,7}'::integer[])) -(3 rows) + -> Sort + Sort Key: unique1 + -> Bitmap Heap Scan on tenk1 + Recheck Cond: (unique1 = ANY ('{1,42,7}'::integer[])) + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = ANY ('{1,42,7}'::integer[])) +(7 rows) SELECT unique1 FROM tenk1 WHERE unique1 IN (1,42,7) diff --git a/src/test/regress/expected/subselect.out b/src/test/regress/expected/subselect.out index a7f609874f..86ab675051 100644 --- a/src/test/regress/expected/subselect.out +++ b/src/test/regress/expected/subselect.out @@ -912,14 +912,11 @@ SELECT clientid::numeric(20), (ARRAY['A','B','C','D','E','F'])[(random()*5+1)::integer] as state, 0 as dim, ((ARRAY['Cat','Dog','Duck'])[(clientid / 10 )% 3 +1 ]) ::text as app_name, - md5(random()::text) as new_value, ((ARRAY['A','B'])[(clientid / 10 )% 2 +1 ]) ::text as platform FROM generate_series('2016-01-01'::timestamp,'2016-10-01'::timestamp,interval '15 day') cts , generate_series( 1000,2000,10) clientid , generate_series(1,6) t -ORDER BY new_value ; SELECT dates::timestamp as dates ,B.platform,B.app_name, B.clientid, B.userid, - B.cts, B.state as state, - B.new_value + B.state as state FROM ( VALUES ('2016.08.30. 08:52:43') ,('2016.08.29. 04:57:12') ,('2016.08.26. 08:15:05') , ('2016.08.24. 11:49:51') ,('2016.08.22. 08:45:29') ,('2016.08.21. 04:53:47') ,('2016.08.20. 08:44:03') @@ -945,36 +942,42 @@ INNER JOIN LATERAL ( and x.clientid = C.clientid ) B ON True ORDER BY dates desc, state; - dates | platform | app_name | clientid | userid | cts | state | new_value ---------------------------+----------+----------+----------+--------+---------------------------------+-------+---------------------------------- - Tue Aug 30 08:52:43 2016 | A | Dog | 1480 | 74 | Wed Jun 29 03:18:06.706316 2016 | A | 7e843b8fd42acc050eb49116e15006e1 - Tue Aug 30 08:52:43 2016 | B | Duck | 1490 | 74 | Sun Aug 28 23:00:45.390111 2016 | A | ecaed3db1bda049f61b22a59afeba67b - Tue Aug 30 08:52:43 2016 | A | Dog | 1480 | 74 | Sun Aug 28 20:02:57.919909 2016 | B | 217e610c59ec188e65e234a703d2b036 - Tue Aug 30 08:52:43 2016 | B | Duck | 1490 | 74 | Sat Aug 13 16:21:35.673224 2016 | B | 46085cbf5ea67a75a8f0d25265cf2c80 - Mon Aug 29 04:57:12 2016 | A | Dog | 1480 | 74 | Wed Jun 29 03:18:06.706316 2016 | A | 7e843b8fd42acc050eb49116e15006e1 - Mon Aug 29 04:57:12 2016 | B | Duck | 1490 | 74 | Sun Aug 28 23:00:45.390111 2016 | A | ecaed3db1bda049f61b22a59afeba67b - Mon Aug 29 04:57:12 2016 | A | Dog | 1480 | 74 | Sun Aug 28 20:02:57.919909 2016 | B | 217e610c59ec188e65e234a703d2b036 - Mon Aug 29 04:57:12 2016 | B | Duck | 1490 | 74 | Sat Aug 13 16:21:35.673224 2016 | B | 46085cbf5ea67a75a8f0d25265cf2c80 - Fri Aug 26 08:15:05 2016 | B | Duck | 1490 | 74 | Sat Aug 13 23:21:41.726407 2016 | A | 21b99ddb90745919d84bce594fd99882 - Fri Aug 26 08:15:05 2016 | A | Dog | 1480 | 74 | Wed Jun 29 03:18:06.706316 2016 | A | 7e843b8fd42acc050eb49116e15006e1 - Fri Aug 26 08:15:05 2016 | B | Duck | 1490 | 74 | Sat Aug 13 16:21:35.673224 2016 | B | 46085cbf5ea67a75a8f0d25265cf2c80 - Fri Aug 26 08:15:05 2016 | A | Dog | 1480 | 74 | Sat Aug 13 18:27:45.405411 2016 | B | 1c0506aaba048c5b3a4fa12b7d6a216c - Wed Aug 24 11:49:51 2016 | A | Dog | 1480 | 74 | Wed Jun 29 03:18:06.706316 2016 | A | 7e843b8fd42acc050eb49116e15006e1 - Wed Aug 24 11:49:51 2016 | B | Duck | 1490 | 74 | Sat Aug 13 23:21:41.726407 2016 | A | 21b99ddb90745919d84bce594fd99882 - Wed Aug 24 11:49:51 2016 | A | Dog | 1480 | 74 | Sat Aug 13 18:27:45.405411 2016 | B | 1c0506aaba048c5b3a4fa12b7d6a216c - Wed Aug 24 11:49:51 2016 | B | Duck | 1490 | 74 | Sat Aug 13 16:21:35.673224 2016 | B | 46085cbf5ea67a75a8f0d25265cf2c80 - Mon Aug 22 08:45:29 2016 | B | Duck | 1490 | 74 | Sat Aug 13 23:21:41.726407 2016 | A | 21b99ddb90745919d84bce594fd99882 - Mon Aug 22 08:45:29 2016 | A | Dog | 1480 | 74 | Wed Jun 29 03:18:06.706316 2016 | A | 7e843b8fd42acc050eb49116e15006e1 - Mon Aug 22 08:45:29 2016 | B | Duck | 1490 | 74 | Sat Aug 13 16:21:35.673224 2016 | B | 46085cbf5ea67a75a8f0d25265cf2c80 - Mon Aug 22 08:45:29 2016 | A | Dog | 1480 | 74 | Sat Aug 13 18:27:45.405411 2016 | B | 1c0506aaba048c5b3a4fa12b7d6a216c - Sun Aug 21 04:53:47 2016 | B | Duck | 1490 | 74 | Sat Aug 13 23:21:41.726407 2016 | A | 21b99ddb90745919d84bce594fd99882 - Sun Aug 21 04:53:47 2016 | A | Dog | 1480 | 74 | Wed Jun 29 03:18:06.706316 2016 | A | 7e843b8fd42acc050eb49116e15006e1 - Sun Aug 21 04:53:47 2016 | B | Duck | 1490 | 74 | Sat Aug 13 16:21:35.673224 2016 | B | 46085cbf5ea67a75a8f0d25265cf2c80 - Sun Aug 21 04:53:47 2016 | A | Dog | 1480 | 74 | Sat Aug 13 18:27:45.405411 2016 | B | 1c0506aaba048c5b3a4fa12b7d6a216c - Sat Aug 20 08:44:03 2016 | A | Dog | 1480 | 74 | Wed Jun 29 03:18:06.706316 2016 | A | 7e843b8fd42acc050eb49116e15006e1 - Sat Aug 20 08:44:03 2016 | B | Duck | 1490 | 74 | Sat Aug 13 23:21:41.726407 2016 | A | 21b99ddb90745919d84bce594fd99882 - Sat Aug 20 08:44:03 2016 | B | Duck | 1490 | 74 | Sat Aug 13 16:21:35.673224 2016 | B | 46085cbf5ea67a75a8f0d25265cf2c80 - Sat Aug 20 08:44:03 2016 | A | Dog | 1480 | 74 | Sat Aug 13 18:27:45.405411 2016 | B | 1c0506aaba048c5b3a4fa12b7d6a216c + dates | platform | app_name | clientid | userid | state +--------------------------+----------+----------+----------+--------+------- + Tue Aug 30 08:52:43 2016 | A | Dog | 1480 | 74 | A + Tue Aug 30 08:52:43 2016 | B | Duck | 1490 | 74 | A + Tue Aug 30 08:52:43 2016 | A | Dog | 1480 | 74 | B + Tue Aug 30 08:52:43 2016 | B | Duck | 1490 | 74 | B + Mon Aug 29 04:57:12 2016 | A | Dog | 1480 | 74 | A + Mon Aug 29 04:57:12 2016 | B | Duck | 1490 | 74 | A + Mon Aug 29 04:57:12 2016 | A | Dog | 1480 | 74 | B + Mon Aug 29 04:57:12 2016 | B | Duck | 1490 | 74 | B + Fri Aug 26 08:15:05 2016 | B | Duck | 1490 | 74 | A + Fri Aug 26 08:15:05 2016 | A | Dog | 1480 | 74 | A + Fri Aug 26 08:15:05 2016 | B | Duck | 1490 | 74 | B + Fri Aug 26 08:15:05 2016 | A | Dog | 1480 | 74 | B + Wed Aug 24 11:49:51 2016 | A | Dog | 1480 | 74 | A + Wed Aug 24 11:49:51 2016 | B | Duck | 1490 | 74 | A + Wed Aug 24 11:49:51 2016 | A | Dog | 1480 | 74 | B + Wed Aug 24 11:49:51 2016 | B | Duck | 1490 | 74 | B + Mon Aug 22 08:45:29 2016 | B | Duck | 1490 | 74 | A + Mon Aug 22 08:45:29 2016 | A | Dog | 1480 | 74 | A + Mon Aug 22 08:45:29 2016 | B | Duck | 1490 | 74 | B + Mon Aug 22 08:45:29 2016 | A | Dog | 1480 | 74 | B + Sun Aug 21 04:53:47 2016 | B | Duck | 1490 | 74 | A + Sun Aug 21 04:53:47 2016 | A | Dog | 1480 | 74 | A + Sun Aug 21 04:53:47 2016 | B | Duck | 1490 | 74 | B + Sun Aug 21 04:53:47 2016 | A | Dog | 1480 | 74 | B + Sat Aug 20 08:44:03 2016 | A | Dog | 1480 | 74 | A + Sat Aug 20 08:44:03 2016 | B | Duck | 1490 | 74 | A + Sat Aug 20 08:44:03 2016 | B | Duck | 1490 | 74 | B + Sat Aug 20 08:44:03 2016 | A | Dog | 1480 | 74 | B (28 rows) DROP TABLE asd; +SELECT setseed(0); + setseed +--------- + +(1 row) + diff --git a/src/test/regress/sql/subselect.sql b/src/test/regress/sql/subselect.sql index 710d817799..ce4019df9f 100644 --- a/src/test/regress/sql/subselect.sql +++ b/src/test/regress/sql/subselect.sql @@ -506,15 +506,12 @@ SELECT clientid::numeric(20), (ARRAY['A','B','C','D','E','F'])[(random()*5+1)::integer] as state, 0 as dim, ((ARRAY['Cat','Dog','Duck'])[(clientid / 10 )% 3 +1 ]) ::text as app_name, - md5(random()::text) as new_value, ((ARRAY['A','B'])[(clientid / 10 )% 2 +1 ]) ::text as platform FROM generate_series('2016-01-01'::timestamp,'2016-10-01'::timestamp,interval '15 day') cts , generate_series( 1000,2000,10) clientid , generate_series(1,6) t -ORDER BY new_value ; SELECT dates::timestamp as dates ,B.platform,B.app_name, B.clientid, B.userid, - B.cts, B.state as state, - B.new_value + B.state as state FROM ( VALUES ('2016.08.30. 08:52:43') ,('2016.08.29. 04:57:12') ,('2016.08.26. 08:15:05') , ('2016.08.24. 11:49:51') ,('2016.08.22. 08:45:29') ,('2016.08.21. 04:53:47') ,('2016.08.20. 08:44:03') @@ -542,3 +539,4 @@ INNER JOIN LATERAL ( ORDER BY dates desc, state; DROP TABLE asd; +SELECT setseed(0); |