NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit86b64ba

committed

Use fipshash in brin_multi test

This fixes some md5() calls that snuck in in0457109 after we hadremoved them all in208bf36.Reviewed-by: Tomas Vondra <tomas.vondra@enterprisedb.com>Discussion:https://www.postgresql.org/message-id/a35eaf0f-b19c-7797-e296-7b7e2adc473e@eisentraut.org

1 parentc1ec02b commit86b64baCopy full SHA for 86b64ba

File tree

2 files changed

+30

-30

lines changed

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

2 files changed

+30

-30

lines changed

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

Lines changed: 16 additions & 16 deletions

Original file line number	Diff line number	Diff line change
`@@ -740,40 +740,40 @@ RESET enable_seqscan;`
`740`	`740`	`-- do some inequality tests for varlena data types`
`741`	`741`	`CREATE TABLE brin_test_multi_2 (a UUID) WITH (fillfactor=10);`
`742`	`742`	`INSERT INTO brin_test_multi_2`
`743`		`-SELECT v::uuid FROM (SELECT row_number() OVER (ORDER BY v) c, v FROM (SELECTmd5((i/13)::text) AS v FROM generate_series(1,1000) s(i)) foo) bar ORDER BY c + 25 * random();`
	`743`	`+SELECT v::uuid FROM (SELECT row_number() OVER (ORDER BY v) c, v FROM (SELECTfipshash((i/13)::text) AS v FROM generate_series(1,1000) s(i)) foo) bar ORDER BY c + 25 * random();`
`744`	`744`	`CREATE INDEX brin_test_multi_2_idx ON brin_test_multi_2 USING brin (a uuid_minmax_multi_ops) WITH (pages_per_range=5);`
`745`	`745`	`SET enable_seqscan=off;`
`746`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a < '33e75ff0-9dd6-01bb-e69f-351039152189';`
	`746`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a < '3d914f93-48c9-cc0f-f8a7-9716700b9fcd';`
`747`	`747`	`count`
`748`	`748`	`-------`
`749`	`749`	`195`
`750`	`750`	`(1 row)`
`751`	`751`
`752`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a > '33e75ff0-9dd6-01bb-e69f-351039152189';`
	`752`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a > '3d914f93-48c9-cc0f-f8a7-9716700b9fcd';`
`753`	`753`	`count`
`754`	`754`	`-------`
`755`	`755`	`792`
`756`	`756`	`(1 row)`
`757`	`757`
`758`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a <= 'f457c545-a9de-d88f-18ec-ee47145a72c0';`
	`758`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a <= 'f369cb89-fc62-7e66-8987-007d121ed1ea';`
`759`	`759`	`count`
`760`	`760`	`-------`
`761`	`761`	`961`
`762`	`762`	`(1 row)`
`763`	`763`
`764`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a >= 'c51ce410-c124-a10e-0db5-e4b97fc2af39';`
	`764`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a >= 'aea92132-c4cb-eb26-3e6a-c2bf6c183b5d';`
`765`	`765`	`count`
`766`	`766`	`-------`
`767`		`-272`
	`767`	`+273`
`768`	`768`	`(1 row)`
`769`	`769`
`770`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = 'cfcd2084-95d5-65ef-66e7-dff9f98764da';`
	`770`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = '5feceb66-ffc8-6f38-d952-786c6d696c79';`
`771`	`771`	`count`
`772`	`772`	`-------`
`773`	`773`	`12`
`774`	`774`	`(1 row)`
`775`	`775`
`776`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = 'aab32389-22bc-c25a-6f60-6eb525ffdc56';`
	`776`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = '86e50149-6586-6131-2a9e-0b35558d84f6';`
`777`	`777`	`count`
`778`	`778`	`-------`
`779`	`779`	`13`
`@@ -784,38 +784,38 @@ SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = 'aab32389-22bc-c25a-6f60-6eb525`
`784`	`784`	`-- approach of adding rows into existing ranges`
`785`	`785`	`TRUNCATE brin_test_multi_2;`
`786`	`786`	`INSERT INTO brin_test_multi_2`
`787`		`-SELECT v::uuid FROM (SELECT row_number() OVER (ORDER BY v) c, v FROM (SELECTmd5((i/13)::text) AS v FROM generate_series(1,1000) s(i)) foo) bar ORDER BY c + 25 * random();`
`788`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a < '33e75ff0-9dd6-01bb-e69f-351039152189';`
	`787`	`+SELECT v::uuid FROM (SELECT row_number() OVER (ORDER BY v) c, v FROM (SELECTfipshash((i/13)::text) AS v FROM generate_series(1,1000) s(i)) foo) bar ORDER BY c + 25 * random();`
	`788`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a < '3d914f93-48c9-cc0f-f8a7-9716700b9fcd';`
`789`	`789`	`count`
`790`	`790`	`-------`
`791`	`791`	`195`
`792`	`792`	`(1 row)`
`793`	`793`
`794`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a > '33e75ff0-9dd6-01bb-e69f-351039152189';`
	`794`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a > '3d914f93-48c9-cc0f-f8a7-9716700b9fcd';`
`795`	`795`	`count`
`796`	`796`	`-------`
`797`	`797`	`792`
`798`	`798`	`(1 row)`
`799`	`799`
`800`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a <= 'f457c545-a9de-d88f-18ec-ee47145a72c0';`
	`800`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a <= 'f369cb89-fc62-7e66-8987-007d121ed1ea';`
`801`	`801`	`count`
`802`	`802`	`-------`
`803`	`803`	`961`
`804`	`804`	`(1 row)`
`805`	`805`
`806`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a >= 'c51ce410-c124-a10e-0db5-e4b97fc2af39';`
	`806`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a >= 'aea92132-c4cb-eb26-3e6a-c2bf6c183b5d';`
`807`	`807`	`count`
`808`	`808`	`-------`
`809`		`-272`
	`809`	`+273`
`810`	`810`	`(1 row)`
`811`	`811`
`812`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = 'cfcd2084-95d5-65ef-66e7-dff9f98764da';`
	`812`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = '5feceb66-ffc8-6f38-d952-786c6d696c79';`
`813`	`813`	`count`
`814`	`814`	`-------`
`815`	`815`	`12`
`816`	`816`	`(1 row)`
`817`	`817`
`818`		`-SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = 'aab32389-22bc-c25a-6f60-6eb525ffdc56';`
	`818`	`+SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = '86e50149-6586-6131-2a9e-0b35558d84f6';`
`819`	`819`	`count`
`820`	`820`	`-------`
`821`	`821`	`13`

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

Lines changed: 14 additions & 14 deletions

Original file line number	Diff line number	Diff line change
`@@ -545,23 +545,23 @@ RESET enable_seqscan;`
`545`	`545`	`-- do some inequality tests for varlena data types`
`546`	`546`	`CREATETABLEbrin_test_multi_2 (a UUID) WITH (fillfactor=10);`
`547`	`547`	`INSERT INTO brin_test_multi_2`
`548`		`-SELECT v::uuidFROM (SELECT row_number() OVER (ORDER BY v) c, vFROM (SELECTmd5((i/13)::text)AS vFROM generate_series(1,1000) s(i)) foo) barORDER BY c+25* random();`
	`548`	`+SELECT v::uuidFROM (SELECT row_number() OVER (ORDER BY v) c, vFROM (SELECTfipshash((i/13)::text)AS vFROM generate_series(1,1000) s(i)) foo) barORDER BY c+25* random();`
`549`	`549`
`550`	`550`	`CREATEINDEXbrin_test_multi_2_idxON brin_test_multi_2 USING brin (a uuid_minmax_multi_ops) WITH (pages_per_range=5);`
`551`	`551`
`552`	`552`	`SET enable_seqscan=off;`
`553`	`553`
`554`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a<'33e75ff0-9dd6-01bb-e69f-351039152189';`
	`554`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a<'3d914f93-48c9-cc0f-f8a7-9716700b9fcd';`
`555`	`555`
`556`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a>'33e75ff0-9dd6-01bb-e69f-351039152189';`
	`556`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a>'3d914f93-48c9-cc0f-f8a7-9716700b9fcd';`
`557`	`557`
`558`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a<='f457c545-a9de-d88f-18ec-ee47145a72c0';`
	`558`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a<='f369cb89-fc62-7e66-8987-007d121ed1ea';`
`559`	`559`
`560`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a>='c51ce410-c124-a10e-0db5-e4b97fc2af39';`
	`560`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a>='aea92132-c4cb-eb26-3e6a-c2bf6c183b5d';`
`561`	`561`
`562`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a='cfcd2084-95d5-65ef-66e7-dff9f98764da';`
	`562`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a='5feceb66-ffc8-6f38-d952-786c6d696c79';`
`563`	`563`
`564`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a='aab32389-22bc-c25a-6f60-6eb525ffdc56';`
	`564`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a='86e50149-6586-6131-2a9e-0b35558d84f6';`
`565`	`565`
`566`	`566`
`567`	`567`	`-- now do the same, but insert the rows with the indexes already created`
`@@ -570,19 +570,19 @@ SELECT COUNT(*) FROM brin_test_multi_2 WHERE a = 'aab32389-22bc-c25a-6f60-6eb525`
`570`	`570`
`571`	`571`	`TRUNCATE brin_test_multi_2;`
`572`	`572`	`INSERT INTO brin_test_multi_2`
`573`		`-SELECT v::uuidFROM (SELECT row_number() OVER (ORDER BY v) c, vFROM (SELECTmd5((i/13)::text)AS vFROM generate_series(1,1000) s(i)) foo) barORDER BY c+25* random();`
	`573`	`+SELECT v::uuidFROM (SELECT row_number() OVER (ORDER BY v) c, vFROM (SELECTfipshash((i/13)::text)AS vFROM generate_series(1,1000) s(i)) foo) barORDER BY c+25* random();`
`574`	`574`
`575`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a<'33e75ff0-9dd6-01bb-e69f-351039152189';`
	`575`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a<'3d914f93-48c9-cc0f-f8a7-9716700b9fcd';`
`576`	`576`
`577`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a>'33e75ff0-9dd6-01bb-e69f-351039152189';`
	`577`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a>'3d914f93-48c9-cc0f-f8a7-9716700b9fcd';`
`578`	`578`
`579`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a<='f457c545-a9de-d88f-18ec-ee47145a72c0';`
	`579`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a<='f369cb89-fc62-7e66-8987-007d121ed1ea';`
`580`	`580`
`581`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a>='c51ce410-c124-a10e-0db5-e4b97fc2af39';`
	`581`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a>='aea92132-c4cb-eb26-3e6a-c2bf6c183b5d';`
`582`	`582`
`583`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a='cfcd2084-95d5-65ef-66e7-dff9f98764da';`
	`583`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a='5feceb66-ffc8-6f38-d952-786c6d696c79';`
`584`	`584`
`585`		`-SELECTCOUNT(*)FROM brin_test_multi_2WHERE a='aab32389-22bc-c25a-6f60-6eb525ffdc56';`
	`585`	`+SELECTCOUNT(*)FROM brin_test_multi_2WHERE a='86e50149-6586-6131-2a9e-0b35558d84f6';`
`586`	`586`
`587`	`587`	`DROPTABLE brin_test_multi_2;`
`588`	`588`	`RESET enable_seqscan;`

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!

Commit86b64ba

File tree

2 files changed

2 files changed

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

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

0 commit comments