TYPE=VIEW
query=select max(`SQ1_alias1`.`pk`) AS `SQ1_cfield1` from (`test`.`table0_myisam_int` `SQ1_alias1` left join (`test`.`table0_myisam_int` `SQ1_alias2` straight_join `test`.`table0_myisam_int` `SQ1_alias3` on(`SQ1_alias3`.`col_int` = `SQ1_alias2`.`pk`)) on(`SQ1_alias3`.`pk` = `SQ1_alias2`.`pk`))
md5=8c69860ef4c15107ea8b1d243bda2e65
updatable=0
algorithm=0
definer_user=rqg
definer_host=localhost
suid=2
with_check_option=0
timestamp=2020-07-07 16:18:56
create-version=2
source=SELECT MAX( SQ1_alias1.`pk` ) AS SQ1_cfield1 FROM ( `table0_myisam_int` AS SQ1_alias1 LEFT JOIN ( `table0_myisam_int` AS SQ1_alias2 STRAIGHT_JOIN `table0_myisam_int` AS SQ1_alias3 ON (SQ1_alias3.`col_int` = SQ1_alias2.`pk` ) ) ON (SQ1_alias3.`pk` = SQ1_alias2.`pk` ) )
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select max(`SQ1_alias1`.`pk`) AS `SQ1_cfield1` from (`test`.`table0_myisam_int` `SQ1_alias1` left join (`test`.`table0_myisam_int` `SQ1_alias2` straight_join `test`.`table0_myisam_int` `SQ1_alias3` on(`SQ1_alias3`.`col_int` = `SQ1_alias2`.`pk`)) on(`SQ1_alias3`.`pk` = `SQ1_alias2`.`pk`))
mariadb-version=100505
