10248362694
74%
BABEL_5_X_DEV: 77%

Ran 05 Aug 2024 12:47PM UTC

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 05 Aug 2024 12:00PM UTC coverage: 73.558% (+0.008%) from 73.55%

Build # 10248362694

Build Type

push

github

Committed by

web-flow

Commit Message

Supported STContains, STEquals, STArea PostGIS functions for Geospatial datatypes (#2831)

Implemented GeoSpatial sql functions STContains(), STEquals(), STArea() and STSrid().

DECLARE @point1 geography, @point2 geography;
SET @point1 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SET @point2 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SELECT @point1.STContains(@point2) AS isIN;
go

Output:
isIN
------
1

DECLARE @point1 geography, @point2 geography;
SET @point1 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SET @point2 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SELECT @point1.STEquals(@point2) AS Equals;
go

Output:
Equals
------
1

DECLARE @point1 geography;
SET @point1 = geography::STGeomFromText('POINT(-122.354657658684900 47.658678768678100)', 4326);
SELECT @point1.STArea() AS Area;
go

Output:
Area
------
0

Task: BABEL-5101

Signed-off-by: yashneet vinayak yashneet@amazon.com

Run Details

42488 of 57761 relevant lines covered (73.56%)

110775.25 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
1	70.48	-0.22%	contrib/babelfishpg_tds/src/backend/tds/tdsutils.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	10248362694.1	05 Aug 2024 12:47PM UTC	114	73.56	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 10248362694
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 10248362694

babelfish-for-postgresql / babelfish_extensions / 10248362694 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 10248362694

babelfish-for-postgresql / babelfish_extensions / 10248362694
74%
BABEL_5_X_DEV: 77%

README BADGES
x