NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commita2fd844

Thomas G. Lockhart

committed

Reorder tests and move aggregate table data to data/.

1 parent1594bf2 commita2fd844Copy full SHA for a2fd844

File tree

2 files changed

-101

lines changed

src/test/regress/sql
- aggregates.sql
- tests

2 files changed

-101

lines changed

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

Lines changed: 1 addition & 94 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,102 +1,9 @@`
`1`		`---`
`2`		`--- replace`
`3`		`---`
`4`		`---`
`5`		`--- BTREE`
`6`		`---`
`7`		`-UPDATE onek`
`8`		`-SET unique1=onek.unique1+1;`
`9`		`-`
`10`		`-UPDATE onek`
`11`		`-SET unique1=onek.unique1-1;`
`12`		`-`
`13`		`---`
`14`		`--- BTREE partial`
`15`		`---`
`16`		`--- UPDATE onek2`
`17`		`--- SET unique1 = onek2.unique1 + 1;`
`18`		`-`
`19`		`---UPDATE onek2`
`20`		`--- SET unique1 = onek2.unique1 - 1;`
`21`		`-`
`22`		`---`
`23`		`--- BTREE shutting out non-functional updates`
`24`		`---`
`25`		`--- the following two tests seem to take a long time on some`
`26`		`--- systems. This non-func update stuff needs to be examined`
`27`		`--- more closely. - jolly (2/22/96)`
`28`		`---`
`29`		`-UPDATE temp`
`30`		`-SET stringu1= reverse_c16(onek.stringu1)`
`31`		`-WHEREonek.stringu1='JBAAAA'and`
`32`		`-onek.stringu1=temp.stringu1;`
`33`		`-`
`34`		`-UPDATE temp`
`35`		`-SET stringu1= reverse_c16(onek2.stringu1)`
`36`		`-WHEREonek2.stringu1='JCAAAA'and`
`37`		`-onek2.stringu1=temp.stringu1;`
`38`		`-`
`39`		`-DROPTABLE temp;`
`40`		`-`
`41`		`---UPDATE person*`
`42`		`--- SET age = age + 1;`
`43`		`-`
`44`		`---UPDATE person*`
`45`		`--- SET age = age + 3`
`46`		`--- WHERE name = 'linda';`
`47`		`-`
`48`		`---`
`49`		`--- copy`
`50`		`---`
`51`		`-COPY onek TO'_OBJWD_/results/onek.data';`
`52`		`-`
`53`		`-DELETEFROM onek;`
`54`		`-`
`55`		`-COPY onekFROM'_OBJWD_/results/onek.data';`
`56`		`-`
`57`		`-SELECT unique1FROM onekWHERE unique1<2;`
`58`		`-`
`59`		`-DELETEFROM onek2;`
`60`		`-`
`61`		`-COPY onek2FROM'_OBJWD_/results/onek.data';`
`62`		`-`
`63`		`-SELECT unique1FROM onek2WHERE unique1<2;`
`64`		`-`
`65`		`-COPY BINARY stud_emp TO'_OBJWD_/results/stud_emp.data';`
`66`		`-`
`67`		`-DELETEFROM stud_emp;`
`68`		`-`
`69`		`-COPY BINARY stud_empFROM'_OBJWD_/results/stud_emp.data';`
`70`		`-`
`71`		`-SELECT*FROM stud_emp;`
`72`		`-`
`73`		`--- COPY aggtest FROM stdin;`
`74`		`--- 567.8`
`75`		`--- 10099.097`
`76`		`--- 00.09561`
`77`		`--- 42324.78`
`78`		`--- .`
`79`		`--- COPY aggtest TO stdout;`
`80`		`-`
`81`		`-`
`82`		`---`
`83`		`--- test the random function`
`84`		`---`
`85`		`--- count the number of tuples originally`
`86`		`-SELECTcount(*)FROM onek;`
`87`		`-`
`88`		`--- select roughly 1/10 of the tuples`
`89`		`-SELECTcount(*)FROM onekwhere oidrand(onek.oid,10);`
`90`		`-`
`91`		`--- select again, the count should be different`
`92`		`-SELECTcount(*)FROM onekwhere oidrand(onek.oid,10);`
`93`		`-`
`94`	`1`	`--`
`95`	`2`	`-- AGGREGATES`
`96`	`3`	`--`
`97`	`4`	`SELECTavg(four)AS avg_1FROM onek;`
`98`	`5`
`99`		`-SELECTavg(a)ASavg_49FROM aggtestWHERE a<100;`
	`6`	`+SELECTavg(a)ASavg_32FROM aggtestWHERE a<100;`
`100`	`7`
`101`	`8`	`SELECTavg(b)AS avg_107_943FROM aggtest;`
`102`	`9`

`‎src/test/regress/sql/tests`

Lines changed: 7 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,21 +1,21 @@`
`1`	`1`	`boolean`
`2`		`-box`
`3`	`2`	`char`
`4`	`3`	`char16`
`5`	`4`	`char2`
`6`	`5`	`char4`
`7`	`6`	`char8`
`8`		`-float4`
`9`		`-float8`
	`7`	`+text`
`10`	`8`	`int2`
`11`	`9`	`int4`
`12`	`10`	`oid`
`13`	`11`	`oidint2`
`14`	`12`	`oidint4`
`15`	`13`	`oidname`
	`14`	`+float4`
	`15`	`+float8`
`16`	`16`	`point`
	`17`	`+box`
`17`	`18`	`polygon`
`18`		`-text`
`19`	`19`	`timespan`
`20`	`20`	`datetime`
`21`	`21`	`reltime`
`@@ -32,19 +32,19 @@ create_operator`
`32`	`32`	`create_view`
`33`	`33`	`create_index`
`34`	`34`	`sanity_check`
	`35`	`+errors`
`35`	`36`	`select`
`36`	`37`	`select_into`
`37`	`38`	`select_distinct`
`38`	`39`	`select_distinct_on`
	`40`	`+aggregates`
`39`	`41`	`transactions`
	`42`	`+random`
`40`	`43`	`portals`
`41`		`-errors`
`42`	`44`	`misc`
`43`		`-random`
`44`	`45`	`arrays`
`45`	`46`	`btree_index`
`46`	`47`	`hash_index`
`47`		`-aggregates`
`48`	`48`	`select_views`
`49`	`49`	`alter_table`
`50`	`50`	`purge`

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!

Commita2fd844

File tree

2 files changed

2 files changed

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

`‎src/test/regress/sql/tests`

0 commit comments