[phpMyAdmin Git] [phpmyadmin/phpmyadmin] 923162: Fix for issues with spatial fields (#14125)

[Lakshay arora]

  Branch: refs/heads/master
  Home:   https://github.com/phpmyadmin/phpmyadmin
  Commit: 9231620c2de872bbdf5a21b63f084ad601d400d3
      https://github.com/phpmyadmin/phpmyadmin/commit/9231620c2de872bbdf5a21b63f084ad601d400d3
  Author: Lakshay arora <carefreelakshay97 at gmail.com>
  Date:   2018-05-12 (Sat, 12 May 2018)

  Changed paths:
    M libraries/classes/Controllers/Table/TableSearchController.php
    M libraries/classes/Display/Results.php
    M libraries/classes/Sql.php
    M libraries/classes/Util.php
    M templates/display/results/options_block.twig
    M test/classes/Controllers/Table/TableSearchControllerTest.php

  Log Message:
  -----------
  Fix for issues with spatial fields (#14125)

*  Fix for issues with spatial fields

Fixes the following issues:

1.    #14068 SPATIAL fields with no unique index/autoincrement error when clicking
      This error occurs when there is no unique column to uniquely identify a tuple. I've disabled the geomtery view and made view as wkt the default view in such cases.

2.    #14121 View spatial fields as WKT doesn't work

1.    #14067 IS NULL search operator produces no WHERE SQL with spatial fields

Signed-Off-By: Lakshay arora <arora.lakshya123 at gmail.com>

* Fix for issues with spatial fields
This commit fixes view as BINARY not working in the previous commit.
Signed-Off-By: Lakshay arora <arora.lakshya123 at gmail.com>

* Fix for issues with spatial fields

Fixes typo in previous commits.

Signed-Off-By: Lakshay arora <arora.lakshya123 at gmail.com>



      **NOTE:** This service been marked for deprecation: https://developer.github.com/changes/2018-04-25-github-services-deprecation/

      Functionality will be removed from GitHub.com on January 31st, 2019.