SQL Server 2019 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU13) (KB5005679) - 15.0.4178.1 (X64) 
	Sep 23 2021 16:47:49 
	Copyright (C) 2019 Microsoft Corporation
	Express Edition (64-bit) on Linux (CentOS Linux 8) <X64>


create function dbo.bTest ( @p_geom geometry )
Returns @geometries TABLE
(
  id integer,
  geom geometry
)
as
begin
  declare @g geometry;
  set @g = @p_geom.STBuffer(0.5);
  
  insert into @geometries values (1, @g);
return;
end;
DECLARE @wkt geometry = geometry::Point(0,0,0);
select * from dbo.bTest(@wkt);


id
geom


1
POLYGON ((0 -0.49999999999999506, 0.02453383716370891 -0.49939772810258132, 0.049008570164780108 -0.49759236333609363, 0.0733652372276806 -0.49458825498238579, 0.097545161008063763 -0.49039264020161066, 0.12149008995163151 -0.48501562659726749, 0.14514233862723067 -0.4784701678661, 0.16844492669610944 -0.47077203259150607, 0.19134171618254422 -0.46193976625563921, 0.21377754671514032 -0.45199464656171756, 0.23569836841299804 -0.44096063217417358, 0.25705137209661005 -0.42886430500013223, 0.2777851165098002 -0.4157348061512689, 0.29784965224621573 -0.40160376574031881, 0.31719664208182174 -0.38650522668136494, 0.33577947742350811 -0.37047556267747606, 0.35355339059327268 -0.3535533905932704, 0.37047556267747839 -0.33577947742350595, 0.38650522668136733 -0.31719664208181964, 0.40160376574032125 -0.29784965224621363, 0.4157348061512714 -0.27778511650979815, 0.42886430500013484 -0.257051372096608, 0.44096063217417625 -0.23569836841299605, 0.45199464656172034 -0.21377754671513835, 0.46193976625564204 -0.19134171618254231, 0.470772032591509 -0.16844492669610756, 0.478470167866103 -0.14514233862722881, 0.4850156265972706 -0.12149008995162967, 0.49039264020161383 -0.097545161008061959, 0.49458825498238912 -0.0733652372276788, 0.497592363336097 -0.049008570164778324, 0.49939772810258481 -0.02453383716370713, 0.49999999999999861 1.7763568394002505E-15, 0.49939772810258481 0.024533837163710683, 0.497592363336097 0.049008570164781877, 0.49458825498238912 0.073365237227682359, 0.49039264020161383 0.097545161008065512, 0.4850156265972706 0.12149008995163323, 0.478470167866103 0.14514233862723236, 0.470772032591509 0.16844492669611111, 0.46193976625564204 0.19134171618254586, 0.45199464656172034 0.2137775467151419, 0.44096063217417625 0.2356983684129996, 0.42886430500013484 0.25705137209661155, 0.4157348061512714 0.2777851165098017, 0.40160376574032125 0.29784965224621718, 0.38650522668136733 0.31719664208182319, 0.37047556267747839 0.3357794774235095, 0.35355339059327268 0.35355339059327395, 0.33577947742350811 0.37047556267747961, 0.31719664208182174 0.3865052266813685, 0.29784965224621573 0.40160376574032236, 0.2777851165098002 0.41573480615127245, 0.25705137209661005 0.42886430500013578, 0.23569836841299804 0.44096063217417714, 0.21377754671514032 0.45199464656172111, 0.19134171618254422 0.46193976625564276, 0.16844492669610944 0.47077203259150963, 0.14514233862723067 0.47847016786610358, 0.12149008995163151 0.48501562659727104, 0.097545161008063763 0.49039264020161422, 0.0733652372276806 0.49458825498238934, 0.049008570164780108 0.49759236333609719, 0.02453383716370891 0.49939772810258487, 0 0.49999999999999861, -0.024533837163708796 0.4993977281025847, -0.049008570164779872 0.49759236333609691, -0.073365237227680236 0.4945882549823889, -0.097545161008063264 0.49039264020161361, -0.12149008995163085 0.48501562659727038, -0.14514233862722986 0.4784701678661028, -0.16844492669610847 0.47077203259150868, -0.19134171618254311 0.4619397662556417, -0.21377754671513904 0.45199464656172, -0.2356983684129966 0.44096063217417591, -0.25705137209660844 0.4288643050001345, -0.27778511650979848 0.41573480615127112, -0.29784965224621385 0.40160376574032103, -0.31719664208181969 0.38650522668136711, -0.33577947742350595 0.37047556267747828, -0.35355339059327034 0.35355339059327268, -0.37047556267747594 0.33577947742350822, -0.38650522668136472 0.31719664208182191, -0.40160376574031853 0.29784965224621596, -0.41573480615126851 0.27778511650980053, -0.42886430500013184 0.2570513720966105, -0.44096063217417314 0.2356983684129986, -0.45199464656171712 0.21377754671514101, -0.46193976625563876 0.19134171618254503, -0.47077203259150568 0.16844492669611036, -0.47847016786609964 0.14514233862723172, -0.48501562659726716 0.12149008995163268, -0.49039264020161027 0.097545161008065068, -0.49458825498238551 0.073365237227682026, -0.49759236333609341 0.049008570164781655, -0.49939772810258115 0.024533837163710572, -0.499999999999995 1.7763568394002505E-15, -0.49939772810258115 -0.024533837163707019, -0.49759236333609341 -0.0490085701647781, -0.49458825498238551 -0.073365237227678473, -0.49039264020161027 -0.097545161008061515, -0.48501562659726716 -0.12149008995162913, -0.47847016786609964 -0.14514233862722817, -0.47077203259150568 -0.16844492669610681, -0.46193976625563876 -0.19134171618254148, -0.45199464656171712 -0.21377754671513746, -0.44096063217417314 -0.23569836841299505, -0.42886430500013184 -0.25705137209660694, -0.41573480615126851 -0.277785116509797, -0.40160376574031853 -0.2978496522462124, -0.38650522668136472 -0.31719664208181836, -0.37047556267747594 -0.33577947742350467, -0.35355339059327034 -0.35355339059326912, -0.33577947742350595 -0.37047556267747472, -0.31719664208181969 -0.38650522668136356, -0.29784965224621385 -0.40160376574031748, -0.27778511650979848 -0.41573480615126757, -0.25705137209660844 -0.42886430500013095, -0.2356983684129966 -0.44096063217417236, -0.21377754671513904 -0.45199464656171645, -0.19134171618254311 -0.46193976625563815, -0.16844492669610847 -0.47077203259150513, -0.14514233862722986 -0.47847016786609925, -0.12149008995163085 -0.48501562659726682, -0.097545161008063264 -0.49039264020161005, -0.073365237227680236 -0.49458825498238534, -0.049008570164779872 -0.49759236333609336, -0.024533837163708796 -0.49939772810258115, 0 -0.49999999999999506))


DECLARE @wkt geometry = geometry::Point(0,0,0);
select * from dbo.bTest(@wkt);


id
geom


1
POLYGON ((0 -0.49999999999999506, 0.02453383716370891 -0.49939772810258132, 0.049008570164780108 -0.49759236333609363, 0.0733652372276806 -0.49458825498238579, 0.097545161008063763 -0.49039264020161066, 0.12149008995163151 -0.48501562659726749, 0.14514233862723067 -0.4784701678661, 0.16844492669610944 -0.47077203259150607, 0.19134171618254422 -0.46193976625563921, 0.21377754671514032 -0.45199464656171756, 0.23569836841299804 -0.44096063217417358, 0.25705137209661005 -0.42886430500013223, 0.2777851165098002 -0.4157348061512689, 0.29784965224621573 -0.40160376574031881, 0.31719664208182174 -0.38650522668136494, 0.33577947742350811 -0.37047556267747606, 0.35355339059327268 -0.3535533905932704, 0.37047556267747839 -0.33577947742350595, 0.38650522668136733 -0.31719664208181964, 0.40160376574032125 -0.29784965224621363, 0.4157348061512714 -0.27778511650979815, 0.42886430500013484 -0.257051372096608, 0.44096063217417625 -0.23569836841299605, 0.45199464656172034 -0.21377754671513835, 0.46193976625564204 -0.19134171618254231, 0.470772032591509 -0.16844492669610756, 0.478470167866103 -0.14514233862722881, 0.4850156265972706 -0.12149008995162967, 0.49039264020161383 -0.097545161008061959, 0.49458825498238912 -0.0733652372276788, 0.497592363336097 -0.049008570164778324, 0.49939772810258481 -0.02453383716370713, 0.49999999999999861 1.7763568394002505E-15, 0.49939772810258481 0.024533837163710683, 0.497592363336097 0.049008570164781877, 0.49458825498238912 0.073365237227682359, 0.49039264020161383 0.097545161008065512, 0.4850156265972706 0.12149008995163323, 0.478470167866103 0.14514233862723236, 0.470772032591509 0.16844492669611111, 0.46193976625564204 0.19134171618254586, 0.45199464656172034 0.2137775467151419, 0.44096063217417625 0.2356983684129996, 0.42886430500013484 0.25705137209661155, 0.4157348061512714 0.2777851165098017, 0.40160376574032125 0.29784965224621718, 0.38650522668136733 0.31719664208182319, 0.37047556267747839 0.3357794774235095, 0.35355339059327268 0.35355339059327395, 0.33577947742350811 0.37047556267747961, 0.31719664208182174 0.3865052266813685, 0.29784965224621573 0.40160376574032236, 0.2777851165098002 0.41573480615127245, 0.25705137209661005 0.42886430500013578, 0.23569836841299804 0.44096063217417714, 0.21377754671514032 0.45199464656172111, 0.19134171618254422 0.46193976625564276, 0.16844492669610944 0.47077203259150963, 0.14514233862723067 0.47847016786610358, 0.12149008995163151 0.48501562659727104, 0.097545161008063763 0.49039264020161422, 0.0733652372276806 0.49458825498238934, 0.049008570164780108 0.49759236333609719, 0.02453383716370891 0.49939772810258487, 0 0.49999999999999861, -0.024533837163708796 0.4993977281025847, -0.049008570164779872 0.49759236333609691, -0.073365237227680236 0.4945882549823889, -0.097545161008063264 0.49039264020161361, -0.12149008995163085 0.48501562659727038, -0.14514233862722986 0.4784701678661028, -0.16844492669610847 0.47077203259150868, -0.19134171618254311 0.4619397662556417, -0.21377754671513904 0.45199464656172, -0.2356983684129966 0.44096063217417591, -0.25705137209660844 0.4288643050001345, -0.27778511650979848 0.41573480615127112, -0.29784965224621385 0.40160376574032103, -0.31719664208181969 0.38650522668136711, -0.33577947742350595 0.37047556267747828, -0.35355339059327034 0.35355339059327268, -0.37047556267747594 0.33577947742350822, -0.38650522668136472 0.31719664208182191, -0.40160376574031853 0.29784965224621596, -0.41573480615126851 0.27778511650980053, -0.42886430500013184 0.2570513720966105, -0.44096063217417314 0.2356983684129986, -0.45199464656171712 0.21377754671514101, -0.46193976625563876 0.19134171618254503, -0.47077203259150568 0.16844492669611036, -0.47847016786609964 0.14514233862723172, -0.48501562659726716 0.12149008995163268, -0.49039264020161027 0.097545161008065068, -0.49458825498238551 0.073365237227682026, -0.49759236333609341 0.049008570164781655, -0.49939772810258115 0.024533837163710572, -0.499999999999995 1.7763568394002505E-15, -0.49939772810258115 -0.024533837163707019, -0.49759236333609341 -0.0490085701647781, -0.49458825498238551 -0.073365237227678473, -0.49039264020161027 -0.097545161008061515, -0.48501562659726716 -0.12149008995162913, -0.47847016786609964 -0.14514233862722817, -0.47077203259150568 -0.16844492669610681, -0.46193976625563876 -0.19134171618254148, -0.45199464656171712 -0.21377754671513746, -0.44096063217417314 -0.23569836841299505, -0.42886430500013184 -0.25705137209660694, -0.41573480615126851 -0.277785116509797, -0.40160376574031853 -0.2978496522462124, -0.38650522668136472 -0.31719664208181836, -0.37047556267747594 -0.33577947742350467, -0.35355339059327034 -0.35355339059326912, -0.33577947742350595 -0.37047556267747472, -0.31719664208181969 -0.38650522668136356, -0.29784965224621385 -0.40160376574031748, -0.27778511650979848 -0.41573480615126757, -0.25705137209660844 -0.42886430500013095, -0.2356983684129966 -0.44096063217417236, -0.21377754671513904 -0.45199464656171645, -0.19134171618254311 -0.46193976625563815, -0.16844492669610847 -0.47077203259150513, -0.14514233862722986 -0.47847016786609925, -0.12149008995163085 -0.48501562659726682, -0.097545161008063264 -0.49039264020161005, -0.073365237227680236 -0.49458825498238534, -0.049008570164779872 -0.49759236333609336, -0.024533837163708796 -0.49939772810258115, 0 -0.49999999999999506))


select * from dbo.bTest(geometry::Point(0,0,0));


id
geom


1
POLYGON ((0 -0.49999999999999506, 0.02453383716370891 -0.49939772810258132, 0.049008570164780108 -0.49759236333609363, 0.0733652372276806 -0.49458825498238579, 0.097545161008063763 -0.49039264020161066, 0.12149008995163151 -0.48501562659726749, 0.14514233862723067 -0.4784701678661, 0.16844492669610944 -0.47077203259150607, 0.19134171618254422 -0.46193976625563921, 0.21377754671514032 -0.45199464656171756, 0.23569836841299804 -0.44096063217417358, 0.25705137209661005 -0.42886430500013223, 0.2777851165098002 -0.4157348061512689, 0.29784965224621573 -0.40160376574031881, 0.31719664208182174 -0.38650522668136494, 0.33577947742350811 -0.37047556267747606, 0.35355339059327268 -0.3535533905932704, 0.37047556267747839 -0.33577947742350595, 0.38650522668136733 -0.31719664208181964, 0.40160376574032125 -0.29784965224621363, 0.4157348061512714 -0.27778511650979815, 0.42886430500013484 -0.257051372096608, 0.44096063217417625 -0.23569836841299605, 0.45199464656172034 -0.21377754671513835, 0.46193976625564204 -0.19134171618254231, 0.470772032591509 -0.16844492669610756, 0.478470167866103 -0.14514233862722881, 0.4850156265972706 -0.12149008995162967, 0.49039264020161383 -0.097545161008061959, 0.49458825498238912 -0.0733652372276788, 0.497592363336097 -0.049008570164778324, 0.49939772810258481 -0.02453383716370713, 0.49999999999999861 1.7763568394002505E-15, 0.49939772810258481 0.024533837163710683, 0.497592363336097 0.049008570164781877, 0.49458825498238912 0.073365237227682359, 0.49039264020161383 0.097545161008065512, 0.4850156265972706 0.12149008995163323, 0.478470167866103 0.14514233862723236, 0.470772032591509 0.16844492669611111, 0.46193976625564204 0.19134171618254586, 0.45199464656172034 0.2137775467151419, 0.44096063217417625 0.2356983684129996, 0.42886430500013484 0.25705137209661155, 0.4157348061512714 0.2777851165098017, 0.40160376574032125 0.29784965224621718, 0.38650522668136733 0.31719664208182319, 0.37047556267747839 0.3357794774235095, 0.35355339059327268 0.35355339059327395, 0.33577947742350811 0.37047556267747961, 0.31719664208182174 0.3865052266813685, 0.29784965224621573 0.40160376574032236, 0.2777851165098002 0.41573480615127245, 0.25705137209661005 0.42886430500013578, 0.23569836841299804 0.44096063217417714, 0.21377754671514032 0.45199464656172111, 0.19134171618254422 0.46193976625564276, 0.16844492669610944 0.47077203259150963, 0.14514233862723067 0.47847016786610358, 0.12149008995163151 0.48501562659727104, 0.097545161008063763 0.49039264020161422, 0.0733652372276806 0.49458825498238934, 0.049008570164780108 0.49759236333609719, 0.02453383716370891 0.49939772810258487, 0 0.49999999999999861, -0.024533837163708796 0.4993977281025847, -0.049008570164779872 0.49759236333609691, -0.073365237227680236 0.4945882549823889, -0.097545161008063264 0.49039264020161361, -0.12149008995163085 0.48501562659727038, -0.14514233862722986 0.4784701678661028, -0.16844492669610847 0.47077203259150868, -0.19134171618254311 0.4619397662556417, -0.21377754671513904 0.45199464656172, -0.2356983684129966 0.44096063217417591, -0.25705137209660844 0.4288643050001345, -0.27778511650979848 0.41573480615127112, -0.29784965224621385 0.40160376574032103, -0.31719664208181969 0.38650522668136711, -0.33577947742350595 0.37047556267747828, -0.35355339059327034 0.35355339059327268, -0.37047556267747594 0.33577947742350822, -0.38650522668136472 0.31719664208182191, -0.40160376574031853 0.29784965224621596, -0.41573480615126851 0.27778511650980053, -0.42886430500013184 0.2570513720966105, -0.44096063217417314 0.2356983684129986, -0.45199464656171712 0.21377754671514101, -0.46193976625563876 0.19134171618254503, -0.47077203259150568 0.16844492669611036, -0.47847016786609964 0.14514233862723172, -0.48501562659726716 0.12149008995163268, -0.49039264020161027 0.097545161008065068, -0.49458825498238551 0.073365237227682026, -0.49759236333609341 0.049008570164781655, -0.49939772810258115 0.024533837163710572, -0.499999999999995 1.7763568394002505E-15, -0.49939772810258115 -0.024533837163707019, -0.49759236333609341 -0.0490085701647781, -0.49458825498238551 -0.073365237227678473, -0.49039264020161027 -0.097545161008061515, -0.48501562659726716 -0.12149008995162913, -0.47847016786609964 -0.14514233862722817, -0.47077203259150568 -0.16844492669610681, -0.46193976625563876 -0.19134171618254148, -0.45199464656171712 -0.21377754671513746, -0.44096063217417314 -0.23569836841299505, -0.42886430500013184 -0.25705137209660694, -0.41573480615126851 -0.277785116509797, -0.40160376574031853 -0.2978496522462124, -0.38650522668136472 -0.31719664208181836, -0.37047556267747594 -0.33577947742350467, -0.35355339059327034 -0.35355339059326912, -0.33577947742350595 -0.37047556267747472, -0.31719664208181969 -0.38650522668136356, -0.29784965224621385 -0.40160376574031748, -0.27778511650979848 -0.41573480615126757, -0.25705137209660844 -0.42886430500013095, -0.2356983684129966 -0.44096063217417236, -0.21377754671513904 -0.45199464656171645, -0.19134171618254311 -0.46193976625563815, -0.16844492669610847 -0.47077203259150513, -0.14514233862722986 -0.47847016786609925, -0.12149008995163085 -0.48501562659726682, -0.097545161008063264 -0.49039264020161005, -0.073365237227680236 -0.49458825498238534, -0.049008570164779872 -0.49759236333609336, -0.024533837163708796 -0.49939772810258115, 0 -0.49999999999999506))


select * from dbo.bTest(geometry::Point(0,0,0));
Msg 596 Level 21 State 1 Line 0
Cannot continue the execution because the session is in the kill state.
Msg 0 Level 20 State 0 Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.