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

Can't create SPATIAL index on top of persistent virtual column

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.5, 10.1, 10.2, 10.0
    • Fix Version/s: 10.2
    • Component/s: GIS, Virtual Columns
    • Labels:
      None

      Description

      I don't have the details of error reported , but i remember server complaining about unique index

      The workaround was to materialized the GEOM column not using virtual column :

      alter table zip_all add column coord point not null
      update zip_all set coord = POINT(lat,lon);
      alter table zip_all_bis ADD SPATIAL INDEX(coord)

      Thanks

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              stephane@skysql.com VAROQUI Stephane
              Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: