Oleksandr Byelkin added a comment - 2022-11-29 13:44 It is not a problem of view print: show create view v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sformat('Num [{:20}]',42) AS `sformat('Num [{:20}]', 42)`latin1 latin1_swedish_ci

Weijun Huang added a comment - 2023-02-26 12:22 create view v1 as select sformat( 'Num [{:6}]' , 42 ); select * from v1; sformat( 'Num [{:6}]' , 42 ) Num [ 42 ] drop view v1; create view v1 as select sformat( 'Num [{:7}]' , 42 ); select * from v1; sformat( 'Num [{:7}]' , 42 ) Num [ 42 drop view v1; create view v1 as select sformat( 'Num [{:8}]' , 42 ); select * from v1; sformat( 'Num [{:8}]' , 42 ) Num [ 4 drop view v1; create view v1 as select sformat( 'Num [{:9}]' , 42 ); select * from v1; sformat( 'Num [{:9}]' , 42 ) Num [ drop view v1; main.view_test [ pass ] 12

Weijun Huang added a comment - 2023-02-26 17:01 I have discovered a bug in `mariadbd` at `Field_varstring::store(this=0x00000001050eb6a0, from="Num [ 42]", length=15, cs=0x0000000101a23f88)` in the `field.cc` file at line 7872, column 3. The issue is that the `Field_varstring.field_length` value, 12, is smaller than the length of the string, which is causing the error. I have attempted to modify the `field_length` parameter to resolve the issue, but I have been unsuccessful so far.

Sergei Golubchik added a comment - 2023-03-26 19:37 Item_func_sformat determines the max length of the result as a sum of max length of its arguments: bool Item_func_sformat::fix_length_and_dec(THD *thd) { ... for (uint i=0 ; i < arg_count ; i++) { char_length+= args[i]->max_char_length(); this, of course, makes little sense, because the length of the result can be anything, depending on the format string.

Daniel Black added a comment - 2023-05-04 04:40 Thanks Weijun Huang . Note Fix Versions may be incorrect. Merged to 10.8 however bb-10.8-release is created and no alternate version exist in JIRA yet.