TYPE=VIEW
query=select sql_small_result min(`SQ5_alias1`.`col_int`) AS `SQ5_ifield1` from (`test`.`table0_myisam_int` `SQ5_alias1` join `test`.`table0_myisam_int` `SQ5_alias2` on(`SQ5_alias2`.`col_int` = `SQ5_alias1`.`pk`)) where `SQ5_alias2`.`pk` in (select `C_SQ1_alias1`.`pk` AS `C_SQ1_cfield1` from `test`.`table0_myisam_int` `C_SQ1_alias1` having `C_SQ1_cfield1` <> \'n\') and `SQ5_alias2`.`pk` > `SQ5_alias2`.`pk`
md5=b65c58a870e2b5981228efe9cae92fbf
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 SQL_SMALL_RESULT MIN( SQ5_alias1.`col_int` ) AS SQ5_ifield1 FROM ( `table0_myisam_int` AS SQ5_alias1 INNER JOIN `table0_myisam_int` AS SQ5_alias2 ON (SQ5_alias2.`col_int` = SQ5_alias1.`pk` ) ) WHERE ( SQ5_alias2.`pk` IN ( SELECT C_SQ1_alias1.`pk` AS C_SQ1_cfield1 FROM `table0_myisam_int` AS C_SQ1_alias1 HAVING C_SQ1_cfield1 <> \'n\') AND SQ5_alias2.`pk` > SQ5_alias2.`pk` )
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select sql_small_result min(`SQ5_alias1`.`col_int`) AS `SQ5_ifield1` from (`test`.`table0_myisam_int` `SQ5_alias1` join `test`.`table0_myisam_int` `SQ5_alias2` on(`SQ5_alias2`.`col_int` = `SQ5_alias1`.`pk`)) where `SQ5_alias2`.`pk` in (select `C_SQ1_alias1`.`pk` AS `C_SQ1_cfield1` from `test`.`table0_myisam_int` `C_SQ1_alias1` having `C_SQ1_cfield1` <> \'n\') and `SQ5_alias2`.`pk` > `SQ5_alias2`.`pk`
mariadb-version=100505
