From ea18b11235448a6416de5ce78792e24861a7a73e Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Fri, 28 Apr 2017 16:27:55 +0400 Subject: MDEV-12619 UNION creates excessive integer column types for integer literals --- mysql-test/suite/innodb_gis/r/create_spatial_index.result | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/suite/innodb_gis/r') diff --git a/mysql-test/suite/innodb_gis/r/create_spatial_index.result b/mysql-test/suite/innodb_gis/r/create_spatial_index.result index 572e3ac0d14..9629fa03fef 100644 --- a/mysql-test/suite/innodb_gis/r/create_spatial_index.result +++ b/mysql-test/suite/innodb_gis/r/create_spatial_index.result @@ -1238,7 +1238,7 @@ Table Op Msg_type Msg_text test.tab check status OK DROP TABLE tab; CREATE TABLE tab(c1 POINT NOT NULL,CONSTRAINT tab_const check(c1 > 0) ) ENGINE=InnoDB; -ERROR HY000: Illegal parameter data types geometry and bigint for operation '>' +ERROR HY000: Illegal parameter data types geometry and int for operation '>' CREATE TABLE tab(c1 POINT NOT NULL,CONSTRAINT tab_const check(CAST(c1 AS BINARY) > 0) ) ENGINE=InnoDB; CREATE SPATIAL INDEX idx1 ON tab(c1) ; SHOW CREATE TABLE tab; -- cgit v1.2.1