Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
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.
Attachments
Issue Links
- is caused by
-
MDEV-11692 Comparison data type aggregation for pluggable data types
-
- Closed
-