Skip to content

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

Closed
@cjhewett

Description

@cjhewett

Steps to reproduce

CREATE TABLE `t` (
 `point` POINT DEFAULT NULL
) ENGINE=InnoDB;

INSERT INTO `t` (`point`) VALUES (NULL), (PointFromText('POINT(1 1)'));
  1. Go to Search tab on phpmyadmin
  2. Change point operator to "IS NULL" (or "IS NOT NULL")
  3. Click Go

Expected behaviour

Results should show 1 entry for the NULL point

Actual behaviour

No WHERE clause is added to SQL so whole table is returned

Server configuration

Operating system:
CentOS
Web server:
Apache/2.4.6
Database:
10.2.12-MariaDB
PHP version:
5.6.33
phpMyAdmin version:
4.7.7

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions