[MDEV-13008] Documentation improvements for Sequence objects Created: 2017-06-06  Updated: 2017-06-30  Resolved: 2017-06-30

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Sequences
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Andrii Nikitin (Inactive) Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-10139 Support for SEQUENCE objects Closed
relates to MDEV-12930 Testing SEQUENCE object Closed

 Description   

Documentation tweaks needed for Sequence Objects

1. Users may experience confusion between SEQUENCE Storage Engine and SEQUENCE Object.
https://mariadb.com/kb/en/mariadb/create-sequence/
https://mariadb.com/kb/en/mariadb/sequence/

Both chapters should include small disclaimer which clarifies that these are unrelated syntax elements, despite having similar name.

2. Sequence objects act as regular tables in many contexts, including LOCK TABLES command.
This may complicate migration from other RDBMS which use both LOCK TABLES and Sequence objects, because e.g. in Oracle LOCK TABLES does allow to increment sequences. This difference should be documented.

 Comments   
Comment by Ian Gilfillan [ 2017-06-30 ]

Added to the docs:
https://mariadb.com/kb/en/mariadb/sequence-overview/#standards-compliance

Generated at Thu Feb 08 08:02:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.