TYPE=VIEW
query=select `SQ2_alias1`.`col_int` AS `SQ2_ifield1`,`SQ2_alias1`.`pk` AS `SQ2_ifield2` from (`test`.`table0_myisam_int` `SQ2_alias1` join `test`.`table0_myisam_int` `SQ2_alias2` on(`SQ2_alias2`.`col_int` = `SQ2_alias1`.`col_int`)) where `SQ2_alias1`.`col_int` > `SQ2_alias2`.`pk` group by `SQ2_alias1`.`col_int`,`SQ2_alias1`.`pk`
md5=bca4986c3a4e7dfd70d3221d42b403a8
updatable=0
algorithm=0
definer_user=rqg
definer_host=localhost
suid=2
with_check_option=0
timestamp=2020-07-07 15:36:13
create-version=2
source=SELECT SQ2_alias1.`col_int` AS SQ2_ifield1, SQ2_alias1.`pk` AS SQ2_ifield2 FROM ( `table0_myisam_int` AS SQ2_alias1 INNER JOIN `table0_myisam_int` AS SQ2_alias2 ON (SQ2_alias2.`col_int` = SQ2_alias1.`col_int` ) ) WHERE SQ2_alias1.`col_int` > SQ2_alias2.`pk` GROUP BY SQ2_ifield1, SQ2_ifield2
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select `SQ2_alias1`.`col_int` AS `SQ2_ifield1`,`SQ2_alias1`.`pk` AS `SQ2_ifield2` from (`test`.`table0_myisam_int` `SQ2_alias1` join `test`.`table0_myisam_int` `SQ2_alias2` on(`SQ2_alias2`.`col_int` = `SQ2_alias1`.`col_int`)) where `SQ2_alias1`.`col_int` > `SQ2_alias2`.`pk` group by `SQ2_alias1`.`col_int`,`SQ2_alias1`.`pk`
mariadb-version=100505
