TYPE=VIEW
query=select sql_small_result `SQ3_alias1`.`col_int` AS `SQ3_cfield1` from `test`.`table0_myisam_int` `SQ3_alias1` where `SQ3_alias1`.`pk` <= (select count(`C_SQ1_alias1`.`col_int`) AS `C_SQ1_cfield1` from (`test`.`table0_myisam_int` `C_SQ1_alias1` join `test`.`table0_myisam_int` `C_SQ1_alias2` on(`C_SQ1_alias2`.`col_int` = `C_SQ1_alias1`.`col_int`)) where `C_SQ1_alias1`.`col_int` = 9)
md5=bc4fa4597afd30f8575f1d6eafa4ff08
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 SQL_SMALL_RESULT SQ3_alias1.`col_int` AS SQ3_cfield1 FROM `table0_myisam_int` AS SQ3_alias1 WHERE SQ3_alias1.`pk` <= ( SELECT COUNT( C_SQ1_alias1.`col_int` ) AS C_SQ1_cfield1 FROM ( `table0_myisam_int` AS C_SQ1_alias1 INNER JOIN `table0_myisam_int` AS C_SQ1_alias2 ON (C_SQ1_alias2.`col_int` = C_SQ1_alias1.`col_int` ) ) WHERE C_SQ1_alias1.`col_int` = 9 )
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select sql_small_result `SQ3_alias1`.`col_int` AS `SQ3_cfield1` from `test`.`table0_myisam_int` `SQ3_alias1` where `SQ3_alias1`.`pk` <= (select count(`C_SQ1_alias1`.`col_int`) AS `C_SQ1_cfield1` from (`test`.`table0_myisam_int` `C_SQ1_alias1` join `test`.`table0_myisam_int` `C_SQ1_alias2` on(`C_SQ1_alias2`.`col_int` = `C_SQ1_alias1`.`col_int`)) where `C_SQ1_alias1`.`col_int` = 9)
mariadb-version=100505
