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

ST_PointFromWKB ignores SRID parameter and returns 0

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.11.4, 10.4(EOL), 10.5(EOL), 10.6(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
    • 10.5.29, 10.6.22, 10.11.12, 11.4.6
    • 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:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 3h
                3h

                Git Integration

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