Commitd77a506

Thomas G. Lockhart

committed

Use additional ORDER BY to cope with new sorting routines.

1 parent16d65f5 commitd77a506Copy full SHA for d77a506

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -179,14 +179,14 @@ thirty\|point1 \|point2`
`179`	`179`	`QUERY: SELECT '' AS fifteen, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance`
`180`	`180`	`FROM POINT_TBL p1, POINT_TBL p2`
`181`	`181`	`WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1`
`182`		`- ORDER BY distance;`
	`182`	`+ ORDER BY distance, point1 using <<, point2 using <<;`
`183`	`183`	`fifteen\|point1 \|point2 \| distance`
`184`	`184`	`-------+----------+----------+----------------`
`185`	`185`	`\|(-3,4) \|(0,0) \| 5`
`186`	`186`	`\|(-10,0) \|(-3,4) \|8.06225774829855`
`187`	`187`	`\|(-10,0) \|(0,0) \| 10`
`188`		`- \|(-5,-12) \|(0,0) \| 13`
`189`	`188`	`\|(-10,0) \|(-5,-12) \| 13`
	`189`	`+ \|(-5,-12) \|(0,0) \| 13`
`190`	`190`	`\|(0,0) \|(10,10) \| 14.142135623731`
`191`	`191`	`\|(-3,4) \|(10,10) \|14.3178210632764`
`192`	`192`	`\|(-5,-12) \|(-3,4) \|16.1245154965971`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -67,7 +67,7 @@ SELECT '' AS thirty, p1.f1 AS point1, p2.f1 AS point2`
`67`	`67`	`SELECT''AS fifteen,p1.f1AS point1,p2.f1AS point2, (p1.f1<->p2.f1)AS distance`
`68`	`68`	`FROM POINT_TBL p1, POINT_TBL p2`
`69`	`69`	`WHERE (p1.f1<->p2.f1)>3andp1.f1<<p2.f1`
`70`		`-ORDER BY distance;`
	`70`	`+ORDER BY distance, point1 using<<, point2 using<<;`
`71`	`71`
`72`	`72`	`-- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10`
`73`	`73`	`SELECT''AS three,p1.f1AS point1,p2.f1AS point2, (p1.f1<->p2.f1)AS distance`

Comments

(0)