Steps to reproduce the issue

Open Joomla_3.4.0-Stable-Full_Package.zip\installation\sql\mysql\sample_learn.sql
In the "#__assets" you have:

(172, 96, 178, 179, 7, 'com_content.article.70', 'Smart Search', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),

Whereas in the "#__content" Table you have:
(70, 170, 'Smart Search', 'smart-search', '

This module provides search using the Smart Search component. You should only use it if you have indexed your content and either have enabled the Smart Search content plugin or are keeping the index of your site updated manually. Help.

Expected result

Matching item ID's

Actual result

Mismatched ID's with match 172 and 170

So there is a conflict with "#__assets"

(170, 50, 217, 218, 6, 'com_content.article.68', 'Captcha', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),

System information (as much as possible)

Fresh download and install of Joomla_3.4.0-Stable-Full_Package.zip
Local MAMP for WINDOWS - PHP 5.6.3 - Joomla 3.4