Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.1.2
-
None
-
Win64
Description
Script, created by mariadb-dump, got execution errors due to improper view creation sequence. The reason is initial view creation by such type commands:
CREATE VIEW `...` AS SELECT
|
1 AS `...`, |
1 AS `...`, |
After that view columns defined as numeric despite original column types.
Then comes second view creation that uses function on underlying view columns and it hits an error of wrong type argument. This could be fixed if initial view would use corresponding type constant (for example, now() for datetime columns, '' for char columns), not only 1 for columns of all types.