Hi Hemanth,
First of all: This is the forum for the Falcon storage engine. For general testing-related questions, the QA forum would be a better choice:
http://forums.mysql.com/list.php?132
Back to your question:
The "Test requires: 'true'" messages usually stems from tests requiring a certain feature which is not available in the build you are testing. Usually this is done by sourcing an include file in the test case itself.
For example, in the sample.test file you may have a line like this:
--source include/have_innodb.inc
And the file mysql-test/include/have_innodb.inc contains:
disable_query_log;
--require r/true.require
select (support = 'YES' or support = 'DEFAULT' or support = 'ENABLED') as `TRUE` from information_schema.engines where engine = 'innodb';
enable_query_log;
So, if (in this example) the query does not return 'YES', 'DEFAULT' or 'ENABLED', the "requires: 'true'" skip message may appear when you run the test.
The skip message is not very informative, though, so this could have been done in a better way, e.g. like this (from mysql-test/include/have_falcon.inc):
let $have_falcon = `SELECT (support = 'YES' OR support = 'DEFAULT' OR support = 'ENABLED') AS 'HAVE_FALCON' FROM INFORMATION_SCHEMA.ENGINES
WHERE ENGINE = 'Falcon'`;
if (!$have_falcon)
{
skip Test needs the Falcon storage engine;
}
For more information about include files in mysql-test, see
http://dev.mysql.com/doc/mysqltest/en/writing-tests-include-files.html
--
John