drop table if exists test_table;
drop procedure if exists test;

CREATE TABLE `test_table` (
    `id` int(11) NOT NULL auto_increment,
    `acct_session_id` varchar(253) NOT NULL,
    PRIMARY KEY  (`id`),
    UNIQUE KEY `index_test_table_on_acct_session_id` (`acct_session_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--disable_warnings
--disable_query_log
let i=255;
while ($i)
{
--eval insert into test_table(acct_session_id) values('293128542661$i')
--dec $i
}
--enable_query_log
--enable_warnings

delimiter |;

CREATE PROCEDURE `test`(IN
p_acct_session_id    varchar(256))
BEGIN
EXPLAIN SELECT id
	FROM test_table
	WHERE acct_session_id LIKE p_acct_session_id LIMIT 1;

END
|

delimiter ;|
#flush status;
#show status like 'handler%';
SELECT id FROM test_table WHERE acct_session_id LIKE '293128542661120' LIMIT 1;
explain SELECT id FROM test_table WHERE acct_session_id LIKE '293128542661120' LIMIT 1;
#show status like 'handler%';
#flush status;
#show status like 'handler%';
explain SELECT id FROM test_table WHERE acct_session_id LIKE 293128542661120 LIMIT 1;
#show status like 'handler%';
#flush status;
#show status like 'handler%';
call test('293128542661120');
#show status like 'handler%';