NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit6be40de

committed

Minor tweak to make rowtypes regression test run faster. We don't

currently have any better strategy for this query than re-running thesub-select over and over; it seems unlikely that doing so 10000 timesis a more useful test than doing it a few dozen times.

1 parent6e1664b commit6be40deCopy full SHA for 6be40de

File tree

2 files changed

-2

lines changed

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

2 files changed

-2

lines changed

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

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -206,7 +206,8 @@ LINE 1: select ROW('ABC','DEF') ~~ ROW('DEF','ABC') as fail;`
`206`	`206`	`HINT: Row comparison operators must be associated with btree operator families.`
`207`	`207`	`-- Check row comparison with a subselect`
`208`	`208`	`select unique1, unique2 from tenk1`
`209`		`-where (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3);`
	`209`	`+where (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3)`
	`210`	`+ and unique1 <= 20;`
`210`	`211`	`unique1 \| unique2`
`211`	`212`	`---------+---------`
`212`	`213`	`1 \| 2838`

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

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -100,7 +100,8 @@ select ROW('ABC','DEF') ~~ ROW('DEF','ABC') as fail;`
`100`	`100`
`101`	`101`	`-- Check row comparison with a subselect`
`102`	`102`	`select unique1, unique2from tenk1`
`103`		`-where (unique1, unique2)< any (select ten, tenfrom tenk1where hundred<3);`
	`103`	`+where (unique1, unique2)< any (select ten, tenfrom tenk1where hundred<3)`
	`104`	`+and unique1<=20;`
`104`	`105`
`105`	`106`	`-- Also check row comparison with an indexable condition`
`106`	`107`	`select thousand, tenthousfrom tenk1`

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!

Commit6be40de

File tree

2 files changed

2 files changed

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

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

0 commit comments