Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32619

ST_PointFromWKB ignores SRID parameter and returns 0

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.11.4, 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
    • 10.5, 10.6, 10.11
    • Data types, GIS
    • Debian 12

    Description

      The ST_PointFromWKB() function ignores the SRID parameter and returns 0 regardless of specified SRID parameter.

      To reproduce this behavior:

      SELECT ST_SRID(ST_PointFromWKB(POINT(1,2), 4326));

      Should return 4326, but returns 0.

      If creating the point from Well Known Text instead, the SRID is preserved (expected behavior)

      SELECT ST_SRID(ST_PointFromText('POINT(1 2)', 4326))

      Returns 4326 as expected.

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            ryangriggs Ryan Griggs
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.