SPATIAL fields with no unique index/autoincrement error when clicking #14068
Milestone
Comments
Without any unique column, there can be no where clause for a particular tuple. Also, the Well known text format in the options gives a bunch of errors and the values are empty. |
mauriciofauth
added a commit
that referenced
this issue
May 12, 2018
* 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@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@gmail.com> * Fix for issues with spatial fields Fixes typo in previous commits. Signed-Off-By: Lakshay arora <arora.lakshya123@gmail.com>
mauriciofauth
added a commit
that referenced
this issue
May 12, 2018
* 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@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@gmail.com> * Fix for issues with spatial fields Fixes typo in previous commits. Signed-Off-By: Lakshay arora <arora.lakshya123@gmail.com> (cherry picked from commit 9231620) Signed-off-by: Maurício Meneghini Fauth <mauriciofauth@gmail.com>
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
I discovered this when looking at #14067; maybe it's related or a duplicate.
Steps to reproduce
Expected behaviour
I should either be offered to download the data or grid edit.
Actual behaviour
An error is shown without any of the phpMyAdmin menu bar, navigation pane, etc:
Server configuration
Operating system:
Debian
Web server:
Apache
Database:
MariaDB 10.1.26
PHP version:
7.0.27
phpMyAdmin version:
master
Client configuration
Browser:
Firefox
Operating system:
MacOS
The text was updated successfully, but these errors were encountered: