[Maria-developers] Check constraints
Hi, Where can I find meta information for check constraints on tables? 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.
Hi, Martijn! 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. Individual constraint definitions are currently only visible in SHOW CREATE TABLE. They'll be in INFORMATION_SCHEMA.CHECK_CONSTRAINTS when https://jira.mariadb.org/browse/MDEV-14474 will be implemented. Regards, Sergei Chief Architect MariaDB and security@mariadb.org
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.
Hi Martijn, I agree that metadata is important, but I respectfully disagree that it should have blocked the release of 10.2. My company is using check constraints in production and (after 6 years of using MySQL) we are glad to finally have check constraints available to us. In fact, check constraints are the main reason we switched from MySQL to maria. I'm not a MariaDB developer, just a user, so it's just my opinion. -Jared On Wed, Jan 10, 2018 at 3:28 AM, Martijn Tonies (Upscene Productions) <m.tonies@upscene.com> wrote:
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.
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Jared Beck • (607) 216-5373 • jared@jaredbeck.com
Hi, Martijn! On Jan 10, Martijn Tonies (Upscene Productions) wrote:
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.
Yes :( That's why MDEV-14474 was created.
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.
It was, unfortunately, overlooked, because neither the server itself nor any tools that we ship needed that table. And no tool developer mentioned this issue before 10.2 became GA. We still can add this table even to 10.2 (I've just changed the target version for MDEV-14474 from 10.3 to 10.2).
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
It's https://jira.mariadb.org/browse/MDEV-13805 and we plan to fix it rather soon (much sooner than in the next 12 years :). But note that SHOW CREATE VIEW cannot simply show the original view definition instead of the generated one. There must be some new way to show the original view definition. If you have any thoughts about how this new way should look like, feel free to add them to MDEV-13805.
Meta data information is very important.
I know. It's just not always easy to think like a tool developer, so the feedback is very important too. Thanks! Regards, Sergei Chief Architect MariaDB and security@mariadb.org
participants (3)
-
Jared Beck -
Martijn Tonies (Upscene Productions) -
Sergei Golubchik