CREATE TABLE `a` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `a` int(11) NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `a` (`id`, `a`) VALUES
(1,	1);

CREATE TABLE `b` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notIndexed` int(11) NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `b` (`id`, `notIndexed`) VALUES
(1,	1);


CREATE ALGORITHM=UNDEFINED VIEW `noCondition` AS select `a`.`id` AS `id` from (`b` join `a` on(`b`.`notIndexed` = `a`.`id`)) where `a`.`id` = 1;

CREATE ALGORITHM=UNDEFINED VIEW `forceConditionU` AS select straight_join `a`.`id` AS `id` from (`b` join `a` on(`b`.`notIndexed` = `a`.`id`)) where `a`.`id` = 1;

CREATE ALGORITHM=MERGE VIEW `forceConditionM` AS select straight_join `a`.`id` AS `id` from (`b` join `a` on(`b`.`notIndexed` = `a`.`id`)) where `a`.`id` = 1;
