Bug #45362 Support for ROWID
Submitted: 8 Jun 2009 2:56
Reporter: Mikiya Okuno Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:any OS:Any
Assigned to: CPU Architecture:Any

[8 Jun 2009 2:56] Mikiya Okuno
Description:
Currently, MySQL Server doesn't support ROWIDs, as the storage engine interface doesn't have a way to work with ROWIDs. In some cases, especially working with row-based replication, backup and restore etc, ROWIDs are useful. However, in other cases, ROWIDs are unnecessary and they could be just an overhead.

The best usage is that users can choose whether they use ROWID or not when creating a table like below:

mysql> CREATE TABLE tbl (...) ENGINE=MYISAM ROWID=BIGINT;

Without specifying ROWID option, ROWIDs should not be created.

ROWIDs should be accessed as `ROWID` or ROWID() in SQL statements. How they are stored should depend on a storage engine implementation.

How to repeat:
n/a

Suggested fix:
n/a
[13 Jan 2016 7:58] Daniƫl van Eeden
Related to or duplicate of:
Bug #1214 	Unique row identifier data type for MySQL (like MSSQL uniqueidentifier)