Commit34f03b1

committed

Patch for current CVS. It add test of lca() to ltree test suite.

Teodor Sigaev

1 parent683b0d3 commit34f03b1Copy full SHA for 34f03b1

File tree

+72

-0

lines changed

+72

-0

lines changed

Lines changed: 60 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -107,6 +107,66 @@ select ''::ltree \|\| 'Top.Child1.Child2'::ltree;`
`107`	`107`	`Top.Child1.Child2`
`108`	`108`	`(1 row)`
`109`	`109`
	`110`	`+select lca('{la.2.3,1.2.3.4.5.6,}') is null;`
	`111`	`+ ?column?`
	`112`	`+----------`
	`113`	`+ t`
	`114`	`+(1 row)`
	`115`	`+`
	`116`	`+select lca('{la.2.3,1.2.3.4.5.6}') is null;`
	`117`	`+ ?column?`
	`118`	`+----------`
	`119`	`+ f`
	`120`	`+(1 row)`
	`121`	`+`
	`122`	`+select lca('{1.la.2.3,1.2.3.4.5.6}');`
	`123`	`+ lca`
	`124`	`+-----`
	`125`	`+ 1`
	`126`	`+(1 row)`
	`127`	`+`
	`128`	`+select lca('{1.2.3,1.2.3.4.5.6}');`
	`129`	`+ lca`
	`130`	`+-----`
	`131`	`+ 1.2`
	`132`	`+(1 row)`
	`133`	`+`
	`134`	`+select lca('1.la.2.3','1.2.3.4.5.6');`
	`135`	`+ lca`
	`136`	`+-----`
	`137`	`+ 1`
	`138`	`+(1 row)`
	`139`	`+`
	`140`	`+select lca('1.2.3','1.2.3.4.5.6');`
	`141`	`+ lca`
	`142`	`+-----`
	`143`	`+ 1.2`
	`144`	`+(1 row)`
	`145`	`+`
	`146`	`+select lca('1.2.2.3','1.2.3.4.5.6');`
	`147`	`+ lca`
	`148`	`+-----`
	`149`	`+ 1.2`
	`150`	`+(1 row)`
	`151`	`+`
	`152`	`+select lca('1.2.2.3','1.2.3.4.5.6','');`
	`153`	`+ lca`
	`154`	`+-----`
	`155`	`+`
	`156`	`+(1 row)`
	`157`	`+`
	`158`	`+select lca('1.2.2.3','1.2.3.4.5.6','2');`
	`159`	`+ lca`
	`160`	`+-----`
	`161`	`+`
	`162`	`+(1 row)`
	`163`	`+`
	`164`	`+select lca('1.2.2.3','1.2.3.4.5.6','1');`
	`165`	`+ lca`
	`166`	`+-----`
	`167`	`+`
	`168`	`+(1 row)`
	`169`	`+`
`110`	`170`	`select '1'::lquery;`
`111`	`171`	`lquery`
`112`	`172`	`--------`

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -23,6 +23,18 @@ select 'Top_0'::ltree \|\| 'Top.Child1.Child2'::ltree;`
`23`	`23`	`select'Top.Child1.Child2'::ltree\|\|''::ltree;`
`24`	`24`	`select''::ltree\|\|'Top.Child1.Child2'::ltree;`
`25`	`25`
	`26`	`+select lca('{la.2.3,1.2.3.4.5.6,}') isnull;`
	`27`	`+select lca('{la.2.3,1.2.3.4.5.6}') isnull;`
	`28`	`+select lca('{1.la.2.3,1.2.3.4.5.6}');`
	`29`	`+select lca('{1.2.3,1.2.3.4.5.6}');`
	`30`	`+select lca('1.la.2.3','1.2.3.4.5.6');`
	`31`	`+select lca('1.2.3','1.2.3.4.5.6');`
	`32`	`+select lca('1.2.2.3','1.2.3.4.5.6');`
	`33`	`+select lca('1.2.2.3','1.2.3.4.5.6','');`
	`34`	`+select lca('1.2.2.3','1.2.3.4.5.6','2');`
	`35`	`+select lca('1.2.2.3','1.2.3.4.5.6','1');`
	`36`	`+`
	`37`	`+`
`26`	`38`	`select'1'::lquery;`
`27`	`39`	`select'4\|3\|2'::lquery;`
`28`	`40`	`select'1.2'::lquery;`

Comments

(0)