babelfish-for-postgresql / babelfish_extensions / 7652855123
75%
BABEL_5_X_DEV: 75%

LAST BUILD BRANCH: jira-babel-5648
DEFAULT BRANCH: BABEL_5_X_DEV
Ran
Jobs 1
Files 113
Run time 10s
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: 71.936% (+0.09%) from 71.843%
7652855123

push

github

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

* 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 fun... (continued)

40053 of 55679 relevant lines covered (71.94%)

58619.13 hits per line

Jobs
ID Job ID Ran Files Coverage
1 7652855123.1 113
71.94
 GitHub Action Run
Source Files on build 7652855123