Bug #16191 UUID() doesn't replicate properly

• Submitted: 4 Jan 2006 15:57
• Modified: 5 Jan 2006 20:26
• Reporter: Ian Gulliver
• Status: Closed
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 5.0.16
• OS: Linux (Debian Sarge)
• CPU Architecture: Any

[4 Jan 2006 15:57] Ian Gulliver

Description:
As documented at:

http://dev.mysql.com/doc/refman/5.1/en/miscellaneous-functions.html

the UUID() function fails to replicate properly.  As UUID() would be a very useful alternative to AUTO INCREMENT for ID columns in a replication environment, having this working would be helpful.

How to repeat:
# On master server:

CREATE TABLE test (uid CHAR(36));
INSERT INTO test SET uid=UUID();
SELECT * FROM test;

# Example output:
# +--------------------------------------+
# | uid                                  |
# +--------------------------------------+
# | fece8494-ce86-1028-a3a2-000cf1e2fcf8 |
# +--------------------------------------+
# 1 row in set (0.00 sec)

# On slave server:

SELECT * FROM test;

# Example output:
# +--------------------------------------+
# | uid                                  |
# +--------------------------------------+
# | 37d162f6-ce88-1028-8f12-001125ce9bea |
# +--------------------------------------+
# 1 row in set (0.00 sec)

Suggested fix:
Make UUID() replicate properly.

[5 Jan 2006 20:18] Sergei Golubchik

It is not possible to make it working without big and incompatible changes :(
So it won't be done in 5.0.

But in 5.1 UUID() should replicate correctly if you use row-based replication.

[5 Jan 2006 20:24] Ian Gulliver

I can't find any mention in the documentation of 5.1 supporting row-based replication yet.  Shouldn't the wishlist bug stay open until it does?

[5 Jan 2006 20:26] Ian Gulliver

Nevermind; not in the changelog yet, but in the 5.1 replication docs stating 5.1.5.