maria-developers team mailing list archive

["Martijn Tonies \(Upscene Productions\)" <m.tonies@xxxxxxxxxxx>]

Hello Sergei,

> On Jan 09, Martijn Tonies (Upscene Productions) wrote:
> > Hi,
> >
> > Where can I find meta information for check constraints on tables?
>
> You can see the list of check constraints in
> INFORMATION_SCHEMA.TABLE_CONSTRAINTS table.

I noticed they are listed, yes, but not with a definition.

> Individual constraint definitions are currently only visible in SHOW
> CREATE TABLE. 

Well, that is... not quite ideal.

> They'll be in INFORMATION_SCHEMA.CHECK_CONSTRAINTS when
> https://jira.mariadb.org/browse/MDEV-14474 will be implemented.

But version 10.2 is the release version, right? I'm surprised that this
has been released without such functionality. As a tool developer and
as a database developer, I'd say this MDEV-14474 would be a 
requirement before a stable release is ready.

I've checked with both MySQL and MariaDB 10.2, this 12 year old issue 
hasn't changed either:
https://lists.mysql.com/internals/25437

Meta data information is very important.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.