Simplified test query:
PREPARE st1 FROM " SELECT BB.col_varchar_key FROM BB STRAIGHT_JOIN B ON ('d') IN (SELECT `col_varchar_nokey` SUBQUERY2_field1 FROM view_B ) ";
Simplified test query:
PREPARE st1 FROM "
SELECT BB.col_varchar_key
FROM BB STRAIGHT_JOIN B
ON ('d') IN (SELECT `col_varchar_nokey` SUBQUERY2_field1 FROM view_B )
";