NotificationsYou must be signed in to change notification settings
Fork15
Star24

Commitd0afcdb

authored

Merge pull request#57 from vitcpp/fix-test-moc100-pg16

Fix diff in the test moc100 on PG16

2 parents8ce614b +2116310 commitd0afcdbCopy full SHA for d0afcdb

File tree

1 file changed

+17

-17

lines changed

expected
- moc100_4.out

1 file changed

+17

-17

lines changed

`‎expected/moc100_4.out‎`

Lines changed: 17 additions & 17 deletions

Original file line number	Diff line number	Diff line change
`@@ -72,10 +72,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`72`	`72`	`SELECT * FROM moc100 WHERE coverage && '4/0';`
`73`	`73`	`QUERY PLAN`
`74`	`74`	`--------------------------------------------------------------------------------`
`75`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=1 width=96) (actual rows=35 loops=1)`
	`75`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=1 width=96) (actual rows=35 loops=1)`
`76`	`76`	`Filter: (coverage && '4/0'::smoc)`
`77`	`77`	`Rows Removed by Filter: 66`
`78`		`- Buffers: shared hit=114`
	`78`	`+ Buffers: shared hit=115`
`79`	`79`	`Planning:`
`80`	`80`	`Buffers: shared hit=1`
`81`	`81`	`(6 rows)`
`@@ -84,10 +84,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`84`	`84`	`SELECT * FROM moc100 WHERE coverage = '0/0-11';`
`85`	`85`	`QUERY PLAN`
`86`	`86`	`--------------------------------------------------------------------------------`
`87`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=1 width=96) (actual rows=23 loops=1)`
	`87`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=1 width=96) (actual rows=23 loops=1)`
`88`	`88`	`Filter: (coverage = '0/0-11'::smoc)`
`89`	`89`	`Rows Removed by Filter: 78`
`90`		`- Buffers: shared hit=59`
	`90`	`+ Buffers: shared hit=60`
`91`	`91`	`Planning:`
`92`	`92`	`Buffers: shared hit=4`
`93`	`93`	`(6 rows)`
`@@ -96,10 +96,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`96`	`96`	`SELECT * FROM moc100 WHERE coverage = '6/43225,43227';`
`97`	`97`	`QUERY PLAN`
`98`	`98`	`-------------------------------------------------------------------------------`
`99`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=1 width=96) (actual rows=1 loops=1)`
	`99`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=1 width=96) (actual rows=1 loops=1)`
`100`	`100`	`Filter: (coverage = '6/43225 43227'::smoc)`
`101`	`101`	`Rows Removed by Filter: 100`
`102`		`- Buffers: shared hit=59`
	`102`	`+ Buffers: shared hit=60`
`103`	`103`	`Planning:`
`104`	`104`	`Buffers: shared hit=1`
`105`	`105`	`(6 rows)`
`@@ -108,10 +108,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`108`	`108`	`SELECT * FROM moc100 WHERE coverage = '0/';`
`109`	`109`	`QUERY PLAN`
`110`	`110`	`-------------------------------------------------------------------------------`
`111`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=1 width=96) (actual rows=1 loops=1)`
	`111`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=1 width=96) (actual rows=1 loops=1)`
`112`	`112`	`Filter: (coverage = '0/'::smoc)`
`113`	`113`	`Rows Removed by Filter: 100`
`114`		`- Buffers: shared hit=59`
	`114`	`+ Buffers: shared hit=60`
`115`	`115`	`Planning:`
`116`	`116`	`Buffers: shared hit=1`
`117`	`117`	`(6 rows)`
`@@ -120,10 +120,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`120`	`120`	`SELECT * FROM moc100 WHERE coverage <> '0/0-11';`
`121`	`121`	`QUERY PLAN`
`122`	`122`	`----------------------------------------------------------------------------------`
`123`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=100 width=96) (actual rows=78 loops=1)`
	`123`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=100 width=96) (actual rows=78 loops=1)`
`124`	`124`	`Filter: (coverage <> '0/0-11'::smoc)`
`125`	`125`	`Rows Removed by Filter: 23`
`126`		`- Buffers: shared hit=59`
	`126`	`+ Buffers: shared hit=60`
`127`	`127`	`Planning:`
`128`	`128`	`Buffers: shared hit=4`
`129`	`129`	`(6 rows)`
`@@ -132,10 +132,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`132`	`132`	`SELECT * FROM moc100 WHERE coverage <> '6/43225,43227';`
`133`	`133`	`QUERY PLAN`
`134`	`134`	`-----------------------------------------------------------------------------------`
`135`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=100 width=96) (actual rows=100 loops=1)`
	`135`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=100 width=96) (actual rows=100 loops=1)`
`136`	`136`	`Filter: (coverage <> '6/43225 43227'::smoc)`
`137`	`137`	`Rows Removed by Filter: 1`
`138`		`- Buffers: shared hit=59`
	`138`	`+ Buffers: shared hit=60`
`139`	`139`	`Planning:`
`140`	`140`	`Buffers: shared hit=1`
`141`	`141`	`(6 rows)`
`@@ -144,10 +144,10 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`144`	`144`	`SELECT * FROM moc100 WHERE coverage <> '0/';`
`145`	`145`	`QUERY PLAN`
`146`	`146`	`-----------------------------------------------------------------------------------`
`147`		`- Seq Scan on moc100 (cost=0.00..6.26 rows=100 width=96) (actual rows=100 loops=1)`
	`147`	`+ Seq Scan on moc100 (cost=0.00..7.26 rows=100 width=96) (actual rows=100 loops=1)`
`148`	`148`	`Filter: (coverage <> '0/'::smoc)`
`149`	`149`	`Rows Removed by Filter: 1`
`150`		`- Buffers: shared hit=59`
	`150`	`+ Buffers: shared hit=60`
`151`	`151`	`Planning:`
`152`	`152`	`Buffers: shared hit=1`
`153`	`153`	`(6 rows)`
`@@ -254,7 +254,7 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`254`	`254`	`SELECT * FROM moc100 WHERE coverage <> '0/0-11';`
`255`	`255`	`QUERY PLAN`
`256`	`256`	`-------------------------------------------------------------------------------------------------------------------`
`257`		`- Bitmap Heap Scan on moc100 (cost=106888.23..106894.48 rows=100 width=96) (actual rows=78 loops=1)`
	`257`	`+ Bitmap Heap Scan on moc100 (cost=106888.23..106895.48 rows=100 width=96) (actual rows=78 loops=1)`
`258`	`258`	`Recheck Cond: (coverage <> '0/0-11'::smoc)`
`259`	`259`	`Rows Removed by Index Recheck: 23`
`260`	`260`	`Heap Blocks: exact=5`
`@@ -273,7 +273,7 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`273`	`273`	`SELECT * FROM moc100 WHERE coverage <> '6/43225,43227';`
`274`	`274`	`QUERY PLAN`
`275`	`275`	`-------------------------------------------------------------------------------------------------------------------`
`276`		`- Bitmap Heap Scan on moc100 (cost=106888.23..106894.48 rows=100 width=96) (actual rows=100 loops=1)`
	`276`	`+ Bitmap Heap Scan on moc100 (cost=106888.23..106895.48 rows=100 width=96) (actual rows=100 loops=1)`
`277`	`277`	`Recheck Cond: (coverage <> '6/43225 43227'::smoc)`
`278`	`278`	`Rows Removed by Index Recheck: 1`
`279`	`279`	`Heap Blocks: exact=5`
`@@ -292,7 +292,7 @@ EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`292`	`292`	`SELECT * FROM moc100 WHERE coverage <> '0/';`
`293`	`293`	`QUERY PLAN`
`294`	`294`	`-------------------------------------------------------------------------------------------------------------------`
`295`		`- Bitmap Heap Scan on moc100 (cost=106888.23..106894.48 rows=100 width=96) (actual rows=100 loops=1)`
	`295`	`+ Bitmap Heap Scan on moc100 (cost=106888.23..106895.48 rows=100 width=96) (actual rows=100 loops=1)`
`296`	`296`	`Recheck Cond: (coverage <> '0/'::smoc)`
`297`	`297`	`Rows Removed by Index Recheck: 1`
`298`	`298`	`Heap Blocks: exact=5`

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!

Commitd0afcdb

File tree

1 file changed

1 file changed

`‎expected/moc100_4.out‎`

0 commit comments