Fix Sample Data Tests

[naydav]

We have problem during installation of Module 'Magento_InventoryCatalog'

[Magento\Framework\DB\Adapter\DuplicateException]
11-Dec-2017 07:28:53 | [exec]   SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-24-MB01' for key 'INVENTORY_SOURCE_ITEM_SOURCE_ID_SKU', query was: INSERT INTO `inventory_source_item` (`source_id`, `quantity`, `status`, `sku`) SELECT 1 AS `source_id`, `cataloginventory_stock_item`.`qty`, `cataloginventory_stock_item`.`is_in_stock`, `catalog_product_entity`.`sku` FROM `cataloginventory_stock_item`
11-Dec-2017 07:28:53 | [exec]    INNER JOIN `catalog_product_entity` ON entity_id = product_id AND (catalog_product_entity.created_in <= 1 AND catalog_product_entity.updated_in > 1) WHERE (website_id = 0)
11-Dec-2017 07:28:53 | [exec]
11-Dec-2017 07:28:53 | [exec]
11-Dec-2017 07:28:53 | [exec] Exception trace:
11-Dec-2017 07:28:53 | [exec]  () at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php:555
11-Dec-2017 07:28:53 | [exec]  Magento\Framework\DB\Adapter\Pdo\Mysql->_query() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php:580
11-Dec-2017 07:28:53 | [exec]  Magento\Framework\DB\Adapter\Pdo\Mysql->query() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/app/code/Magento/InventoryCatalog/Setup/Operation/UpdateInventorySourceItem.php:80
11-Dec-2017 07:28:53 | [exec]  Magento\InventoryCatalog\Setup\Operation\UpdateInventorySourceItem->execute() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/app/code/Magento/InventoryCatalog/Setup/InstallData.php:79
11-Dec-2017 07:28:53 | [exec]  Magento\InventoryCatalog\Setup\InstallData->install() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/setup/src/Magento/Setup/Model/Installer.php:867
11-Dec-2017 07:28:53 | [exec]  Magento\Setup\Model\Installer->handleDBSchemaData() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/setup/src/Magento/Setup/Model/Installer.php:791
11-Dec-2017 07:28:53 | [exec]  Magento\Setup\Model\Installer->installDataFixtures() at n/a:n/a
11-Dec-2017 07:28:53 | [exec]  call_user_func_array() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/setup/src/Magento/Setup/Model/Installer.php:342
11-Dec-2017 07:28:53 | [exec]  Magento\Setup\Model\Installer->install() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/setup/src/Magento/Setup/Console/Command/InstallCommand.php:127
11-Dec-2017 07:28:53 | [exec]  Magento\Setup\Console\Command\InstallCommand->execute() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/vendor/symfony/console/Command/Command.php:242
11-Dec-2017 07:28:53 | [exec]  Symfony\Component\Console\Command\Command->run() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/vendor/symfony/console/Application.php:842
11-Dec-2017 07:28:53 | [exec]  Symfony\Component\Console\Application->doRunCommand() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/vendor/symfony/console/Application.php:193
11-Dec-2017 07:28:53 | [exec]  Symfony\Component\Console\Application->doRun() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/lib/internal/Magento/Framework/Console/Cli.php:104
11-Dec-2017 07:28:53 | [exec]  Magento\Framework\Console\Cli->doRun() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/vendor/symfony/console/Application.php:117
11-Dec-2017 07:28:53 | [exec]  Symfony\Component\Console\Application->run() at /opt/bamboo/builds/M2-SDT1933-CEE/instance-0/bin/magento:23

Possible solution is replace select from select on

INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE

in \Magento\InventoryCatalog\Setup\Operation\UpdateInventorySourceItem::execute

[naydav]

Merged
#310