<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Aptos Display";
panose-1:2 11 0 4 2 2 2 2 2 4;}
@font-face
{font-family:Aptos;
panose-1:2 11 0 4 2 2 2 2 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span.Stylwiadomocie-mail17
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1555433089;
mso-list-type:hybrid;
mso-list-template-ids:1410208276 68485137 68485145 68485147 68485135 68485145 68485147 68485135 68485145 68485147;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style>
</head>
<body lang="PL" link="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Aptos Display",sans-serif">Hi all<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos Display",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">I have run a couple of tests on Postgresql 17 with Postgis 3.5.0<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">Have you ever met such a situation that:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">Case 1: On PG 15.3 with Postgis 3.3.7<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">POSTGIS="3.3.1 3786b21" [EXTENSION] PGSQL="150" GEOS="3.11.0-CAPI-1.17.0" PROJ="7.2.1" LIBXML="2.9.1" LIBJSON="0.11"<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif"><o:p> </o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">QUERY:
<b>SELECT st_intersects(ST_GeomFromText('LINESTRING(20.4181889 52.2294573, 20.4181297 52.2293530)',4326), ST_GeomFromText('POLYGON((20.4184446 52.2300275, 20.4184364 52.2299621, 20.4183278 52.2297000, 20.4182316 52.2294864, 20.4181977 52.2294529, 20.4181239
52.2294898, 20.4181889 52.2294573, 20.4182713 52.2295927, 20.4183541 52.2297635, 20.4184219 52.2299443, 20.4184446 52.2300275))',4326));</b><o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">Produces:<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="font-size:14.0pt;font-family:"Aptos Display",sans-serif">ERROR: GEOSIntersects: TopologyException: side location conflict at 20.418188900000001 52.2294573. This can occur if the input geometry is invalid.<o:p></o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif"><o:p> </o:p></span></p>
<p class="MsoListParagraph"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">Case 2: On PG17.0 with Postgis 3.5.0<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.25pt"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">POSTGIS="3.5.0 d2c3ca4" [EXTENSION] PGSQL="170" GEOS="3.13.0-CAPI-1.19.0" PROJ="9.5.0 (compiled against PROJ 9.13.0) LIBXML="2.9.13" LIBJSON="0.14"
LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.25pt"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:35.25pt"><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">Same QUERY:</span><b><span lang="EN-US" style="font-size:12.0pt;font-family:"Aptos Display",sans-serif;color:maroon;mso-ligatures:none;mso-fareast-language:PL">
</span></b><b><span lang="EN-US" style="font-family:"Aptos Display",sans-serif">SELECT st_intersects(ST_GeomFromText('LINESTRING(20.4181889 52.2294573, 20.4181297 52.2293530)',4326),<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:35.25pt"><b><span style="font-family:"Aptos Display",sans-serif">ST_GeomFromText('POLYGON((20.4184446 52.2300275, 20.4184364 52.2299621, 20.4183278 52.2297000, 20.4182316 52.2294864, 20.4181977 52.2294529, 20.4181239
52.2294898, 20.4181889 52.2294573, 20.4182713 52.2295927, 20.4183541 52.2297635, 20.4184219 52.2299443, 20.4184446 52.2300275))',4326));<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:35.25pt"><b><span style="font-family:"Aptos Display",sans-serif"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="margin-left:35.25pt"><span lang="EN-US" style="font-size:14.0pt;font-family:"Aptos Display",sans-serif">Produces: True<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.25pt"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Is it some kind of regression?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thank for any information<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif;color:black;mso-ligatures:none">Best regards<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:18.0pt;text-indent:-18.0pt"><span style="font-family:"Calibri",sans-serif;color:black;mso-ligatures:none">Łukasz Szałek<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>