The Ultimate Guide to High Availability with MariaDB

Issue with view definition in MariaDB 10.1.18

I encountered a rewriting problem of view definition in MariaDB 10.1.18.

set names utf8;
create table test(bins varbinary(10));
create view test_view as select hex(coalesce(bins, '')) as bins from test;
show create view test_view;
VIEW `test_view` AS select hex(coalesce(convert(`test`.`bins` using utf8),'')) AS `bins` from `test`

MariaDB will rewrite the view definition by adding convert in the function of coalesce. However, we should not convert the varbinary field to utf8. Can you help investigate the problem? Thanks.

Answer Answered by Ian Gilfillan in this comment.

This should rather be reported in the issue tracker.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.