eclipse-ee4j / eclipse-ee4j/eclipselink

MySQLPlatform lacks support of mariadb sequences

Open
#883 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
246
Forks
202
Avg merge
1d 22h
Merged PRs (30d)
14

Description

MySQLPlatform lacks support of mariadb sequences introduced in https://mariadb.com/kb/en/sequences/

Duplicating Bug 545248 - Support for mariadb 10.3 sequences https://bugs.eclipse.org/bugs/show_bug.cgi?id=545248

CREATE SEQUENCE was introduced in MariaDB 10.3.

https://mariadb.com/kb/en/sequences/

A sequence is an object that generates a sequence of numeric values, as specified by the CREATE SEQUENCE statement. Sequences are an alternative to AUTO_INCREMENT when you want more control over how sequence numbers are generated.

Sequences can be used as alternative to table storage, but without locks when multiple threads are accessing id generation.

Contributor guide

Open the contributing guide

Research direction

Start by locating the MySQLPlatform implementation and its existing sequence-related handling. Read the MariaDB 10.3 sequence documentation linked in the issue, then trace how database-platform capabilities are tested. Done means MariaDB sequences are supported without breaking existing MySQL behavior, with coverage for the new platform behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mariadb
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.