|
Some time in 10.3, probably around MDEV-11692, comparison rules were strictened so much that it became impossible to see a definition of a view which invokes such a comparison.
create or replace table t (a int);
|
create or replace view v as select * from t where a < 1000;
|
create or replace table t (a point);
|
show create view v;
|
|
# Cleanup
|
drop view v;
|
drop table t;
|
|
10.3 3a62ff7e
|
mysqltest: At line 4: query 'show create view v' failed: 4078: Illegal parameter data types geometry and int for operation '<'
|
Obviously it's quite inconvenient, one needs to see the definition of a broken view in order to fix it.
|