Pomelo.EntityFrameworkCore.MySql icon indicating copy to clipboard operation
Pomelo.EntityFrameworkCore.MySql copied to clipboard

Support `SEQUENCE` for MariaDB

Open lauxjpn opened this issue 5 years ago • 2 comments

In contrast to MySQL, MariaDB introduced SEQUENCE in 10.3. See the Knowledge Base for further details.

This would fix #768 and address #509 and #477 for MariaDB. I think we should consider implementing this for 3.1.0.

lauxjpn avatar Nov 01 '19 20:11 lauxjpn

My Pull request #1195 solves 2 Issues: 1)Syntax Mismatch: "NOCYCLE" instead of "NO CYCLE" 2)Values Mismatch: Using "Starts with 0" is incompatible with NO MINVALUE (Minvalue has to be set when starting with 0 or less)

pgiacomo69 avatar Oct 13 '20 19:10 pgiacomo69

Thanks to @pgiacomo69 for the sequence support in regards to migrations!

lauxjpn avatar Nov 25 '20 20:11 lauxjpn