Is this a bug - CategoryIDPath

A repeater control with a filter the Category name property resolves to SQL That uses the field CMS_Category.CategoryIDPath. CategoryIDPath is derived from CategoryID which is an identity column. Identity columns do not sync with the same values but use the next available value in the pattern. That means that if categories are not identical across all synced environments then the IDs will not match across environments. I believe this is why Kentico uses GUIDs, to ensure consistency across environments.

Seems like the issue could be resolved by replacing the reference to CategoryIDPath with a reference to CategoryNamePath.

Here's the (simplified) SQL the Repeater generated with a specified Category. Note the usage of CategoryIDPath.

SELECT TOP 5 *, Date AS [CMS_O1], ROW_NUMBER() OVER (ORDER BY Date DESC) AS [CMS_SRN], 0 AS [CMS_SN], ''cms.document.cta.blogarticle'' AS [CMS_T]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN cta_BlogArticle AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogArticleID AND V.ClassName = N''cta.BlogArticle'' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] LIKE @NodeAliasPath AND (
DocumentID IN (
SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID IN(
SELECT **CategoryID** FROM CMS_Category 
WHERE CategoryIDPath LIKE ''/00000010%'' AND CategoryEnabled = 1 AND (NOT EXISTS(SELECT CategoryID FROM CMS_Category AS pc WHERE (pc.CategoryEnabled = 0) AND (CMS_Category.CategoryIDPath LIKE pc.CategoryIDPath+''/%'')))))) AND [DocumentCulture] = @DocumentCulture)
ORDER BY Date DESC