<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/manticore-search-28-6-6-uuid-document-ids-ordered-group-xpfg7udv7" -->

---
title: Manticore Search 28.6.6: UUID document IDs, ordered GROUP
description: Manticore Search 28.6.6 introduces two headline features: UUID document IDs for real-time tables (eliminating the need for separate numeric ID mappings) and...
canonical: https://daily.dev/posts/manticore-search-28-6-6-uuid-document-ids-ordered-group-xpfg7udv7
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: Manticore Search 28.6.6: UUID document IDs, ordered GROUP | daily.dev
og:description: Manticore Search 28.6.6 introduces two headline features: UUID document IDs for real-time tables (eliminating the need for separate numeric ID mappings) and...
og:url: https://daily.dev/posts/manticore-search-28-6-6-uuid-document-ids-ordered-group-xpfg7udv7
og:image: https://api.daily.dev/og/posts/xPfg7udV7.png
og:image:alt: Manticore Search 28.6.6: UUID document IDs, ordered GROUP
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Manticore Search 28.6.6: UUID document IDs, ordered GROUP

**[Manticore](https://daily.dev/sources/manticoresearch)** · 4 min read · 3 upvotes · 0 comments

## Summary

Manticore Search 28.6.6 introduces two headline features: UUID document IDs for real-time tables (eliminating the need for separate numeric ID mappings) and ordered, limited GROUP_CONCAT() with ORDER BY, SEPARATOR, and LIMIT options in GROUP BY queries. The release also ships 16 fixes covering backup table-freeze bugs, authenticated replication with populated RT tables, query stack corruption on long phrase queries, StreamVByte decoder crashes in secondary-index queries, SphinxQL SSL race conditions, and MySQL client compatibility for USER() and SHOW INDEX STATUS.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://manticoresearch.com/blog/manticore-search-28-6-6>

## Questions this post answers

### How do I create a real-time table with UUID document IDs in Manticore Search?

Define the id column as uuid when creating the table, for example CREATE TABLE products_uuid(id uuid, title text, price int). Manticore accepts an explicit UUID string or generates one automatically when id is omitted from an insert or replace. UUID equality and IN filters work in queries, and UUID IDs support REPLACE, UPDATE, and DELETE, but ALTER TABLE cannot convert an existing numeric-ID table to UUID.

_Track new capabilities like this by following Manticore Search release coverage on daily.dev._

### How do I get the top N grouped values sorted in a specific order using GROUP_CONCAT in SQL?

In Manticore Search 28.6.6, GROUP_CONCAT() supports ORDER BY, SEPARATOR, and LIMIT clauses in explicit SQL GROUP BY queries, for example GROUP_CONCAT(title ORDER BY price DESC SEPARATOR ', ' LIMIT 3). This returns the top values in the requested order directly from the query instead of concatenating an arbitrary set and re-sorting it in application code.

_Developers refining grouped queries can follow database feature updates like this on daily.dev._

### Does upgrading to Manticore Search 28.6.6 require a data migration?

No mandatory data migrations are required for this release. UUID document IDs are opt-in through table definition, so existing numeric-ID tables keep working unchanged; only newly created real-time tables can use id uuid. The release also fixes a backup issue that could leave real-time tables frozen and blocked for writes after a successful backup completed.

_Teams planning a database upgrade can track release notes like these on daily.dev before rolling out._

## Similar posts on daily.dev

- [UUID in Manticore: A Practical Guide](https://daily.dev/posts/uuid-in-manticore-a-practical-guide-b55hxwzme) · Manticore · 1 upvotes · 0 comments
- [UUID in Manticore: a single ID for the primary database and Manticore](https://daily.dev/posts/uuid-in-manticore-a-single-id-for-the-primary-database-and-manticore-ms4mwqupn) · Manticore · 7 upvotes · 0 comments
- [Manticore Search 27.1.5: Authentication, sharded tables, conversational search and faster vector search](https://daily.dev/posts/manticore-search-27-1-5-authentication-sharded-tables-conversational-search-and-faster-vector-sea-vaeuj65j7) · Manticore · 2 upvotes · 0 comments
- [PostgreSQL 18's UUIDv7: Faster and Secure Time-Ordered IDs](https://daily.dev/posts/postgresql-18-s-uuidv7-faster-and-secure-time-ordered-ids-smvesvjbw) · Hashrocket · 42 upvotes · 0 comments

---

Tags: [#backend](https://daily.dev/tags/backend), [#full-text-search](https://daily.dev/tags/full-text-search), [#manticore-search](https://daily.dev/tags/manticore-search)

[View this post on daily.dev](https://daily.dev/posts/manticore-search-28-6-6-uuid-document-ids-ordered-group-xpfg7udv7)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"Manticore Search 28.6.6: UUID document IDs, ordered GROUP","url":"https://daily.dev/posts/manticore-search-28-6-6-uuid-document-ids-ordered-group-xpfg7udv7","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/manticore-search-28-6-6-uuid-document-ids-ordered-group-xpfg7udv7"},"datePublished":"2026-07-31T08:42:25.896Z","dateModified":"2026-09-14T08:18:43.102Z","description":"Manticore Search 28.6.6 introduces two headline features: UUID document IDs for real-time tables (eliminating the need for separate numeric ID mappings) and...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/54a94e2ec42591ed5417dfd6f8a9f3e5?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/54a94e2ec42591ed5417dfd6f8a9f3e5?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Manticore","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Manticore","logo":"https://media.daily.dev/image/upload/s--FP5Ea08h--/f_auto/v1754225081/logos/manticoresearch","url":"https://daily.dev/sources/manticoresearch"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/manticore-search-28-6-6-uuid-document-ids-ordered-group-xpfg7udv7","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":3},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"backend,full-text-search,manticore-search","timeRequired":"PT4M"}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Manticore","item":"https://daily.dev/sources/manticoresearch"},{"@type":"ListItem","position":3,"name":"Manticore Search 28.6.6: UUID document IDs, ordered GROUP"}]}
{"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/manticore-search-28-6-6-uuid-document-ids-ordered-group-xpfg7udv7#faq","mainEntity":[{"@type":"Question","name":"How do I create a real-time table with UUID document IDs in Manticore Search?","acceptedAnswer":{"@type":"Answer","text":"Define the id column as uuid when creating the table, for example CREATE TABLE products_uuid(id uuid, title text, price int). Manticore accepts an explicit UUID string or generates one automatically when id is omitted from an insert or replace. UUID equality and IN filters work in queries, and UUID IDs support REPLACE, UPDATE, and DELETE, but ALTER TABLE cannot convert an existing numeric-ID table to UUID. Track new capabilities like this by following Manticore Search release coverage on daily.dev."}},{"@type":"Question","name":"How do I get the top N grouped values sorted in a specific order using GROUP_CONCAT in SQL?","acceptedAnswer":{"@type":"Answer","text":"In Manticore Search 28.6.6, GROUP_CONCAT() supports ORDER BY, SEPARATOR, and LIMIT clauses in explicit SQL GROUP BY queries, for example GROUP_CONCAT(title ORDER BY price DESC SEPARATOR ', ' LIMIT 3). This returns the top values in the requested order directly from the query instead of concatenating an arbitrary set and re-sorting it in application code. Developers refining grouped queries can follow database feature updates like this on daily.dev."}},{"@type":"Question","name":"Does upgrading to Manticore Search 28.6.6 require a data migration?","acceptedAnswer":{"@type":"Answer","text":"No mandatory data migrations are required for this release. UUID document IDs are opt-in through table definition, so existing numeric-ID tables keep working unchanged; only newly created real-time tables can use id uuid. The release also fixes a backup issue that could leave real-time tables frozen and blocked for writes after a successful backup completed. Teams planning a database upgrade can track release notes like these on daily.dev before rolling out."}}]}
```