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

LAST BUILD BRANCH: datetime2fromparts_bugfix
DEFAULT BRANCH: BABEL_5_X_DEV
Ran
Jobs 1
Files 113
Run time 9s
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 72.536% (+0.09%) from 72.446%
7650196611

push

github

web-flow 
Support TSQL syntax for Geospatial functions (#2271)

This commit contains Support for TSQL syntax for geospatial functions. Added Handling for STX, STY, LAT, LONG, STDistance, STAsText, and STAsBinary functions. Modified Test Cases to check TSQL syntax for geospatial functions  

Supported Syntax -

Use in a full column name with function name at the last (i.e. full_column_name DOT column_Geospatial_function)
select <TableName>.<Column_name>.STX
select <TableName>.<Column_name>.Lat
go

Use in a function_call statement with function name at the last (i.e. full_column_name DOT function_Geospatial_function)
select <TableName>.<Column_name>.STAsText()
select <TableName>.<Column_name>.STDistance(point_instance)
go

Use in a declared variable statement with function name at the last (i.e. local_id DOT Geospatial_function)
DECLARE @point geometry;
SET @point = geometry::STGeomFromText('POINT(-122.34900 47.65100)', 4326);
select @point.STX
select @point.STY
select @point.STAsText()
select @point.STDistance(@point)
go

Use in a complex function_call statement with function name at the last (i.e. function_call DOT Geospatial_function)
select geometry::STGeomFromText('POINT(-122.34900 47.65100)', 4326).STX
select geometry::STGeomFromText('POINT(-122.34900 47.65100)', 4326).STY
select geometry::STGeomFromText('POINT(-122.34900 47.65100)', 4326).STAsText()
select geometry::STGeomFromText('POINT(-122.34900 47.65100)', 4326).STDistance(point_instance)
go

Use in a complex subquery statement with function name at the last (i.e. subquery DOT Geospatial_function)
select ( select <geometryCol> From <geometryTable> ).STX 
select ( select <geometryCol> From <geometryTable> ).STY
select ( select <geometryCol> From <geometryTable> ).STAsText()
select ( select <geometryCol> From <geometryTable> ).STDistance(point_instance)
go

Use in a complex expression statement with function name at the last (i.e. ( expression ) DOT Geospatial_functio... (continued)

40372 of 55658 relevant lines covered (72.54%)

57220.11 hits per line

Jobs
ID Job ID Ran Files Coverage
1 7650196611.1 113
72.54
 GitHub Action Run
Source Files on build 7650196611