-- source include/have_ndb.inc
-- source include/not_embedded.inc

CREATE TABLE `pub_articles` (
  `article_id` int(10) unsigned NOT NULL auto_increment,
  `category_id` int(10) unsigned NOT NULL default '0',
  `category2_id` int(10) unsigned NOT NULL default '0',
  `requested_end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `first_publish_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `latest_publish_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `expiration_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `headline` varchar(150) NOT NULL default '',
  `brief_headline` varchar(50) NOT NULL default '',
  `hot_level` char(1) NOT NULL default '',
  `used` char(1) NOT NULL default 'N',
  `image_id` int(11) NOT NULL default '0',
  `image_price` varchar(50) NOT NULL default '',
  `image_avux_id` int(10) unsigned NOT NULL,
  `large_image_url` varchar(255) NOT NULL default '',
  `large_image_width` smallint(6) NOT NULL default '0',
  `large_image_height` smallint(6) NOT NULL default '0',
  `medium_image_url` varchar(255) NOT NULL default '',
  `medium_image_width` smallint(6) NOT NULL default '0',
  `medium_image_height` smallint(6) NOT NULL default '0',
  `small_image_url` varchar(255) NOT NULL default '',
  `small_image_width` smallint(6) NOT NULL default '0',
  `small_image_height` smallint(6) NOT NULL default '0',
  `price` double(8,2) default NULL,
  `category_name` varchar(100) NOT NULL default '',
  `category_url` varchar(100) NOT NULL default '',
  `category_path` varchar(255) NOT NULL default '',
  `publication_id` int(11) NOT NULL default '0',
  `section_id` int(11) NOT NULL default '0',
  `hotness` decimal(8,4) NOT NULL default '0.0000',
  `rank` tinyint(3) unsigned NOT NULL default '0',
  `billable` tinyint(4) NOT NULL default '0',
  `normal_body` mediumtext NOT NULL,
  `teaser_body` mediumtext NOT NULL,
  `exclusive_body` mediumtext NOT NULL,
  `vendors` mediumtext NOT NULL,
  `urls` mediumtext NOT NULL,
  PRIMARY KEY  (`article_id`,`publication_id`),
  KEY `publication_id` (`publication_id`,`first_publish_time`),
  KEY `publication_id_2` (`publication_id`,`requested_end_time`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

CREATE TABLE `article_edition_lookup` (
  `publication_id` int(11) NOT NULL default '0',
  `article_id` int(10) unsigned NOT NULL,
  `publication_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`publication_id`,`publication_date`,`article_id`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

--disable_query_log
source $HOME/bug29011.sql;
--enable_query_log

update article_edition_lookup set article_id=2;

explain select pub_articles.article_id from pub_articles inner join article_edition_lookup on pub_articles.article_id=article_edition_lookup.article_id and pub_articles.publication_id=article_edition_lookup.publication_id and publication_date='9297-07-25' where pub_articles.publication_id=0;

explain select article_id from article_edition_lookup inner join pub_articles using (article_id, publication_id) where publication_id=0 and publication_date='9297-07-25';

alter table article_edition_lookup engine=myisam;
alter table pub_articles engine=myisam;

explain select pub_articles.article_id from pub_articles inner join article_edition_lookup on pub_articles.article_id=article_edition_lookup.article_id and pub_articles.publication_id=article_edition_lookup.publication_id and publication_date='9297-07-25' where pub_articles.publication_id=0;

explain select article_id from article_edition_lookup inner join pub_articles using (article_id, publication_id) where publication_id=0 and publication_date='9297-07-25';