Commitb9c8fae

Thomas G. Lockhart

committed

Allow more timezone-like interpretation of INTERVALs.

Fix up labeling of some new test cases.

1 parentd74c52c commitb9c8faeCopy full SHA for b9c8fae

File tree

-7

lines changed

-7

lines changed

Lines changed: 7 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,13 +5,13 @@`
`5`	`5`	`SET DATESTYLE= DEFAULT;`
`6`	`6`
`7`	`7`	`-- check acceptance of "time zone style"`
`8`		`-SELECT INTERVAL'01:00';`
`9`		`-SELECT INTERVAL'+02:00';`
`10`		`-SELECT INTERVAL'-08:00';`
`11`		`-SELECT INTERVAL'-05';`
`12`		`-SELECT INTERVAL'-1 +02:03';`
`13`		`-SELECT INTERVAL'-1 days +02:03';`
`14`		`-SELECT INTERVAL'10 years -11 month -12 days +13:14';`
	`8`	`+SELECT INTERVAL'01:00'AS"One hour";`
	`9`	`+SELECT INTERVAL'+02:00'AS"Two hours";`
	`10`	`+SELECT INTERVAL'-08:00'AS"Eight hours";`
	`11`	`+SELECT INTERVAL'-05'AS"Five hours";`
	`12`	`+SELECT INTERVAL'-1 +02:03'AS"22 hours ago...";`
	`13`	`+SELECT INTERVAL'-1 days +02:03'AS"22 hours ago...";`
	`14`	`+SELECT INTERVAL'10 years -11 month -12 days +13:14'AS"9 years...";`
`15`	`15`
`16`	`16`	`CREATETABLEINTERVAL_TBL (f1 interval);`
`17`	`17`

Comments

(0)