NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit9199853

committed

Revert "Temporarily add some probes of tenk1's relallvisible in create_index.sql."

This reverts commit5bb2b6a.Not needed anymore.

1 parentf7a605f commit9199853Copy full SHA for 9199853

File tree

2 files changed

-71

lines changed

src/test/regress
- expected
  - create_index.out
- sql
  - create_index.sql

2 files changed

-71

lines changed

`‎src/test/regress/expected/create_index.out`

Lines changed: 0 additions & 49 deletions

Original file line number	Diff line number	Diff line change
`@@ -17,45 +17,10 @@ LINE 1: CREATE INDEX IF NOT EXISTS ON onek USING btree(unique1 int4_...`
`17`	`17`	`CREATE INDEX onek_unique2 ON onek USING btree(unique2 int4_ops);`
`18`	`18`	`CREATE INDEX onek_hundred ON onek USING btree(hundred int4_ops);`
`19`	`19`	`CREATE INDEX onek_stringu1 ON onek USING btree(stringu1 name_ops);`
`20`		`-select relallvisible::float8/relpages as visfrac`
`21`		`-from pg_class where relname = 'tenk1';`
`22`		`- visfrac`
`23`		`----------`
`24`		`- 1`
`25`		`-(1 row)`
`26`		`-`
`27`	`20`	`CREATE INDEX tenk1_unique1 ON tenk1 USING btree(unique1 int4_ops);`
`28`		`-select relallvisible::float8/relpages as visfrac`
`29`		`-from pg_class where relname = 'tenk1';`
`30`		`- visfrac`
`31`		`----------`
`32`		`- 1`
`33`		`-(1 row)`
`34`		`-`
`35`	`21`	`CREATE INDEX tenk1_unique2 ON tenk1 USING btree(unique2 int4_ops);`
`36`		`-select relallvisible::float8/relpages as visfrac`
`37`		`-from pg_class where relname = 'tenk1';`
`38`		`- visfrac`
`39`		`----------`
`40`		`- 1`
`41`		`-(1 row)`
`42`		`-`
`43`	`22`	`CREATE INDEX tenk1_hundred ON tenk1 USING btree(hundred int4_ops);`
`44`		`-select relallvisible::float8/relpages as visfrac`
`45`		`-from pg_class where relname = 'tenk1';`
`46`		`- visfrac`
`47`		`----------`
`48`		`- 1`
`49`		`-(1 row)`
`50`		`-`
`51`	`23`	`CREATE INDEX tenk1_thous_tenthous ON tenk1 (thousand, tenthous);`
`52`		`-select relallvisible::float8/relpages as visfrac`
`53`		`-from pg_class where relname = 'tenk1';`
`54`		`- visfrac`
`55`		`----------`
`56`		`- 1`
`57`		`-(1 row)`
`58`		`-`
`59`	`24`	`CREATE INDEX tenk2_unique1 ON tenk2 USING btree(unique1 int4_ops);`
`60`	`25`	`CREATE INDEX tenk2_unique2 ON tenk2 USING btree(unique2 int4_ops);`
`61`	`26`	`CREATE INDEX tenk2_hundred ON tenk2 USING btree(hundred int4_ops);`
`@@ -1251,13 +1216,6 @@ DROP TABLE unlogged_hash_table;`
`1251`	`1216`	`-- maintenance_work_mem setting and fillfactor:`
`1252`	`1217`	`SET maintenance_work_mem = '1MB';`
`1253`	`1218`	`CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);`
`1254`		`-select relallvisible::float8/relpages as visfrac`
`1255`		`-from pg_class where relname = 'tenk1';`
`1256`		`- visfrac`
`1257`		`----------`
`1258`		`- 1`
`1259`		`-(1 row)`
`1260`		`-`
`1261`	`1219`	`EXPLAIN (COSTS OFF)`
`1262`	`1220`	`SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';`
`1263`	`1221`	`QUERY PLAN`
`@@ -1945,13 +1903,6 @@ SELECT count(*) FROM dupindexcols`
`1945`	`1903`	`97`
`1946`	`1904`	`(1 row)`
`1947`	`1905`
`1948`		`-select relallvisible::float8/relpages as visfrac`
`1949`		`-from pg_class where relname = 'tenk1';`
`1950`		`- visfrac`
`1951`		`----------`
`1952`		`- 1`
`1953`		`-(1 row)`
`1954`		`-`
`1955`	`1906`	`--`
`1956`	`1907`	`-- Check ordering of =ANY indexqual results (bug in 9.2.0)`
`1957`	`1908`	`--`

`‎src/test/regress/sql/create_index.sql`

Lines changed: 0 additions & 22 deletions

Original file line number	Diff line number	Diff line change
`@@ -21,29 +21,14 @@ CREATE INDEX onek_hundred ON onek USING btree(hundred int4_ops);`
`21`	`21`
`22`	`22`	`CREATEINDEXonek_stringu1ON onek USING btree(stringu1 name_ops);`
`23`	`23`
`24`		`-select relallvisible::float8/relpagesas visfrac`
`25`		`-from pg_classwhere relname='tenk1';`
`26`		`-`
`27`	`24`	`CREATEINDEXtenk1_unique1ON tenk1 USING btree(unique1 int4_ops);`
`28`	`25`
`29`		`-select relallvisible::float8/relpagesas visfrac`
`30`		`-from pg_classwhere relname='tenk1';`
`31`		`-`
`32`	`26`	`CREATEINDEXtenk1_unique2ON tenk1 USING btree(unique2 int4_ops);`
`33`	`27`
`34`		`-select relallvisible::float8/relpagesas visfrac`
`35`		`-from pg_classwhere relname='tenk1';`
`36`		`-`
`37`	`28`	`CREATEINDEXtenk1_hundredON tenk1 USING btree(hundred int4_ops);`
`38`	`29`
`39`		`-select relallvisible::float8/relpagesas visfrac`
`40`		`-from pg_classwhere relname='tenk1';`
`41`		`-`
`42`	`30`	`CREATEINDEXtenk1_thous_tenthousON tenk1 (thousand, tenthous);`
`43`	`31`
`44`		`-select relallvisible::float8/relpagesas visfrac`
`45`		`-from pg_classwhere relname='tenk1';`
`46`		`-`
`47`	`32`	`CREATEINDEXtenk2_unique1ON tenk2 USING btree(unique1 int4_ops);`
`48`	`33`
`49`	`34`	`CREATEINDEXtenk2_unique2ON tenk2 USING btree(unique2 int4_ops);`
`@@ -384,10 +369,6 @@ DROP TABLE unlogged_hash_table;`
`384`	`369`	`-- maintenance_work_mem setting and fillfactor:`
`385`	`370`	`SET maintenance_work_mem='1MB';`
`386`	`371`	`CREATEINDEXhash_tuplesort_idxON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor=10);`
`387`		`-`
`388`		`-select relallvisible::float8/relpagesas visfrac`
`389`		`-from pg_classwhere relname='tenk1';`
`390`		`-`
`391`	`372`	`EXPLAIN (COSTS OFF)`
`392`	`373`	`SELECTcount(*)FROM tenk1WHERE stringu1='TVAAAA';`
`393`	`374`	`SELECTcount(*)FROM tenk1WHERE stringu1='TVAAAA';`
`@@ -765,9 +746,6 @@ EXPLAIN (COSTS OFF)`
`765`	`746`	`SELECTcount(*)FROM dupindexcols`
`766`	`747`	`WHERE f1 BETWEEN'WA'AND'ZZZ'and id<1000and f1 ~<~'YX';`
`767`	`748`
`768`		`-select relallvisible::float8/relpagesas visfrac`
`769`		`-from pg_classwhere relname='tenk1';`
`770`		`-`
`771`	`749`	`--`
`772`	`750`	`-- Check ordering of =ANY indexqual results (bug in 9.2.0)`
`773`	`751`	`--`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit9199853

File tree

2 files changed

2 files changed

`‎src/test/regress/expected/create_index.out`

`‎src/test/regress/sql/create_index.sql`

0 commit comments