-
Bug
-
-
Critical
-
Resolution:
Fixed
-
N/A
-
-
-
|
10.1 tree
|
MariaDB [test]> SELECT ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))')));
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))'))) |
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| NULL |
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
PostGIS
|
pgis=# SELECT ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))')));
|
st_astext
|
-----------------------------------
|
POINT(-70.9510231824279 42.09385)
|
(1 row)
|
The shape is rather simple (see the picture).
{"report":{"fcp":1005.7000000011176,"ttfb":328.7000000011176,"pageVisibility":"visible","entityId":49743,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"12973417-6781-4942-96e2-3793e5ff5e31","navigationType":0,"readyForUser":1184.0999999996275,"redirectCount":0,"resourceLoadedEnd":836.2000000011176,"resourceLoadedStart":334.30000000074506,"resourceTiming":[{"duration":104.29999999888241,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":334.30000000074506,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":334.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":438.59999999962747,"responseStart":0,"secureConnectionStart":0},{"duration":104.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":334.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":334.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":439,"responseStart":0,"secureConnectionStart":0},{"duration":150,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":334.7000000011176,"connectEnd":334.7000000011176,"connectStart":334.7000000011176,"domainLookupEnd":334.7000000011176,"domainLookupStart":334.7000000011176,"fetchStart":334.7000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":334.7000000011176,"responseEnd":484.7000000011176,"responseStart":484.7000000011176,"secureConnectionStart":334.7000000011176},{"duration":268.59999999962747,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":334.90000000037253,"connectEnd":334.90000000037253,"connectStart":334.90000000037253,"domainLookupEnd":334.90000000037253,"domainLookupStart":334.90000000037253,"fetchStart":334.90000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":334.90000000037253,"responseEnd":603.5,"responseStart":603.5,"secureConnectionStart":334.90000000037253},{"duration":272.1000000014901,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":335.09999999962747,"connectEnd":335.09999999962747,"connectStart":335.09999999962747,"domainLookupEnd":335.09999999962747,"domainLookupStart":335.09999999962747,"fetchStart":335.09999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":335.09999999962747,"responseEnd":607.2000000011176,"responseStart":607.2000000011176,"secureConnectionStart":335.09999999962747},{"duration":272.19999999925494,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":335.40000000037253,"connectEnd":335.40000000037253,"connectStart":335.40000000037253,"domainLookupEnd":335.40000000037253,"domainLookupStart":335.40000000037253,"fetchStart":335.40000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":335.40000000037253,"responseEnd":607.5999999996275,"responseStart":607.5999999996275,"secureConnectionStart":335.40000000037253},{"duration":272.59999999962747,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":335.40000000037253,"connectEnd":335.40000000037253,"connectStart":335.40000000037253,"domainLookupEnd":335.40000000037253,"domainLookupStart":335.40000000037253,"fetchStart":335.40000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":335.40000000037253,"responseEnd":608,"responseStart":608,"secureConnectionStart":335.40000000037253},{"duration":299.7000000011176,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":335.59999999962747,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":335.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":635.3000000007451,"responseStart":0,"secureConnectionStart":0},{"duration":272.69999999925494,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":335.80000000074506,"connectEnd":335.80000000074506,"connectStart":335.80000000074506,"domainLookupEnd":335.80000000074506,"domainLookupStart":335.80000000074506,"fetchStart":335.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":335.80000000074506,"responseEnd":608.5,"responseStart":608.5,"secureConnectionStart":335.80000000074506},{"duration":299.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":336,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":336,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":635.5,"responseStart":0,"secureConnectionStart":0},{"duration":273,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":336.09999999962747,"connectEnd":336.09999999962747,"connectStart":336.09999999962747,"domainLookupEnd":336.09999999962747,"domainLookupStart":336.09999999962747,"fetchStart":336.09999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":336.09999999962747,"responseEnd":609.0999999996275,"responseStart":609.0999999996275,"secureConnectionStart":336.09999999962747},{"duration":493.80000000074506,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":341.59999999962747,"connectEnd":341.59999999962747,"connectStart":341.59999999962747,"domainLookupEnd":341.59999999962747,"domainLookupStart":341.59999999962747,"fetchStart":341.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":341.59999999962747,"responseEnd":835.4000000003725,"responseStart":835.4000000003725,"secureConnectionStart":341.59999999962747},{"duration":494.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":341.7000000011176,"connectEnd":341.7000000011176,"connectStart":341.7000000011176,"domainLookupEnd":341.7000000011176,"domainLookupStart":341.7000000011176,"fetchStart":341.7000000011176,"redirectEnd":0,"redirectStart":0,"requestStart":341.7000000011176,"responseEnd":836.2000000011176,"responseStart":836.2000000011176,"secureConnectionStart":341.7000000011176},{"duration":148.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":687.3000000007451,"connectEnd":687.3000000007451,"connectStart":687.3000000007451,"domainLookupEnd":687.3000000007451,"domainLookupStart":687.3000000007451,"fetchStart":687.3000000007451,"redirectEnd":0,"redirectStart":0,"requestStart":687.3000000007451,"responseEnd":835.8000000007451,"responseStart":835.8000000007451,"secureConnectionStart":687.3000000007451}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":97,"responseStart":329,"responseEnd":335,"domLoading":332,"domInteractive":1245,"domContentLoadedEventStart":1245,"domContentLoadedEventEnd":1290,"domComplete":2695,"loadEventStart":2695,"loadEventEnd":2697,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1224.4000000003725},{"name":"bigPipe.sidebar-id.end","time":1225.4000000003725},{"name":"bigPipe.activity-panel-pipe-id.start","time":1225.5999999996275},{"name":"bigPipe.activity-panel-pipe-id.end","time":1228.4000000003725},{"name":"activityTabFullyLoaded","time":1300}],"measures":[],"correlationId":"c7f43eefb76b6b","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":173,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
MDEV-7509 Testing for GIS extensions
