Movatterモバイル変換

Skip to content

postgrespro/pgspherePublic

NotificationsYou must be signed in to change notification settings
Fork15
Star24

Commit0fe578d

df7cb

msdemlei

authored and

committed

Test smoc_round on level 0

1 parentf855597 commit0fe578dCopy full SHA for 0fe578d

File tree

2 files changed

+14

-0

lines changed

expected
- moc.out
sql
- moc.sql

2 files changed

+14

-0

lines changed

`‎expected/moc.out‎`

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -601,6 +601,18 @@ SELECT smoc_round(5, '7/1,3,5,9');`
`601`	`601`	`5/0`
`602`	`602`	`(1 row)`
`603`	`603`
	`604`	`+SELECT smoc_round(0, '1/0');`
	`605`	`+ smoc_round`
	`606`	`+------------`
	`607`	`+ 0/0`
	`608`	`+(1 row)`
	`609`	`+`
	`610`	`+SELECT smoc_round(0, '1/47');`
	`611`	`+ smoc_round`
	`612`	`+------------`
	`613`	`+ 0/11`
	`614`	`+(1 row)`
	`615`	`+`
`604`	`616`	`WITH mocs(x) AS (VALUES ('0/'::smoc), ('0/1'), ('0/2'), ('0/4'), ('0/1,3'), ('0/1-3'), ('0/2-4'))`
`605`	`617`	`SELECT a.x AS a, b.x AS b,`
`606`	`618`	`a.x = b.x AS "=", a.x <> b.x AS "<>",`

`‎sql/moc.sql‎`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -135,6 +135,8 @@ SELECT intersection(moc) FROM (VALUES ('0/1-4'::smoc), ('0/2-5'), (NULL)) sub(mo`
`135`	`135`
`136`	`136`	`SELECT smoc_round(6,'7/1,3,5,9');`
`137`	`137`	`SELECT smoc_round(5,'7/1,3,5,9');`
	`138`	`+SELECT smoc_round(0,'1/0');`
	`139`	`+SELECT smoc_round(0,'1/47');`
`138`	`140`
`139`	`141`	`WITH mocs(x)AS (VALUES ('0/'::smoc), ('0/1'), ('0/2'), ('0/4'), ('0/1,3'), ('0/1-3'), ('0/2-4'))`
`140`	`142`	`SELECTa.xAS a,b.xAS b,`

0 commit comments

Comments

(0)

[8]ページ先頭

©2009-2025 Movatter.jp