Commit2d6b1f2

committed

Update incorrect expected file. Use 'timestamp without time zone'

datatype in test, to try to avoid any dependency on local time zone.

1 parent1226816 commit2d6b1f2Copy full SHA for 2d6b1f2

File tree

-8

lines changed

-8

lines changed

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,7 +5,7 @@`
`5`	`5`	`\set ECHO none`
`6`	`6`	`create table inttmp (b int4);`
`7`	`7`	`\copy inttmp from 'data/test_btree.data'`
`8`		`-create table tstmp ( tdatetime );`
	`8`	`+create table tstmp ( ttimestamp without time zone );`
`9`	`9`	`\copy tstmp from 'data/test_btree_ts.data'`
`10`	`10`	`-- without idx`
`11`	`11`	`select count(*) from inttmp where b <=10;`
`@@ -14,10 +14,10 @@ select count(*) from inttmp where b <=10;`
`14`	`14`	`11`
`15`	`15`	`(1 row)`
`16`	`16`
`17`		`-select count(*) from tstmp where t < '2001-05-29 08:33:09+04';`
	`17`	`+select count(*) from tstmp where t < '2001-05-29 08:33:09';`
`18`	`18`	`count`
`19`	`19`	`-------`
`20`		`- 7`
	`20`	`+66`
`21`	`21`	`(1 row)`
`22`	`22`
`23`	`23`	`-- create idx`
`@@ -31,9 +31,9 @@ select count(*) from inttmp where b <=10;`
`31`	`31`	`11`
`32`	`32`	`(1 row)`
`33`	`33`
`34`		`-select count(*) from tstmp where t < '2001-05-29 08:33:09+04';`
	`34`	`+select count(*) from tstmp where t < '2001-05-29 08:33:09';`
`35`	`35`	`count`
`36`	`36`	`-------`
`37`		`- 7`
	`37`	`+66`
`38`	`38`	`(1 row)`
`39`	`39`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,15 +10,15 @@ create table inttmp (b int4);`
`10`	`10`
`11`	`11`	`\copy inttmpfrom'data/test_btree.data'`
`12`	`12`
`13`		`-createtabletstmp ( tdatetime );`
	`13`	`+createtabletstmp ( ttimestamp without time zone );`
`14`	`14`
`15`	`15`	`\copy tstmpfrom'data/test_btree_ts.data'`
`16`	`16`
`17`	`17`	`-- without idx`
`18`	`18`
`19`	`19`	`selectcount(*)from inttmpwhere b<=10;`
`20`	`20`
`21`		`-selectcount(*)from tstmpwhere t<'2001-05-29 08:33:09+04';`
	`21`	`+selectcount(*)from tstmpwhere t<'2001-05-29 08:33:09';`
`22`	`22`
`23`	`23`	`-- create idx`
`24`	`24`
`@@ -32,5 +32,5 @@ set enable_seqscan=off;`
`32`	`32`
`33`	`33`	`selectcount(*)from inttmpwhere b<=10;`
`34`	`34`
`35`		`-selectcount(*)from tstmpwhere t<'2001-05-29 08:33:09+04';`
	`35`	`+selectcount(*)from tstmpwhere t<'2001-05-29 08:33:09';`
`36`	`36`

Comments

(0)