check-constraints

MySql constraints don't work on mysql Ubuntu

I\'ve installed mysql in my ubuntuusing the classic command: apt-get install mysql-server And to my surprise it is a mysql which doesnt respect any constraint i write with \"check\".[详细]

2023-04-13 05:39 分类：问答

Oracle 11g - Check constraint with RegEx

I\'m using Oracle 11g, and trying to 开发者_JAVA技巧create a table define constraints on the creation.[详细]

2023-04-09 15:33 分类：问答

Simple CHECK Constraint not so simple

2nd Edit: The source code for the involved function is as follows: ALTER FUNCTION [Fileserver].[fn_CheckSingleFileSource] ( @fileId INT )[详细]

2023-03-30 21:52 分类：问答

A nicer way to write a CHECK CONSTRAINT that checks that exactly one value is not null

Imagine that I have a table with integer columns Col1, Col2, Col3, Col4.Each column is nullable and a valid row must contain a value in exactly 1 columns (i.e. all nulls is invalid and more than 1 col[详细]

2023-03-30 02:52 分类：问答

Can an SQL constraint be used to prevent a particular value being changed when a condition holds?

I know that SQL constraints can force data to meet validity criteria. However, what about criteria such as \"Student\'s grade can only be updated when the \'finalised\' flag is false\"? Do such update[详细]

2023-03-18 22:19 分类：问答

Why aren'y my CHECK CONSTRAINTS on child tables being utilized by the planner to reduce the size of the plan?

I have a table that is partitioned by month and is used for holding apache log information.When I run EXPLAIN for a simple query which has a WHERE clause on the same field as the partition CHECKs, I g[详细]

2023-03-16 07:12 分类：问答

Tests with constraint checking errors not caught when using AbstractTransactionalSpringContextTests (rollback)

The majority of开发者_如何学C my integration tests use spring\'s AbstractTransactionalSpringContextTests to do a rollback instead of commiting to the database.This works well normally but because fore[详细]

2023-03-12 13:33 分类：问答

What SQL databases support subqueries in CHECK constraints?

What SQL databases, if any, support subqueries in CHECK constraints? At present and as far as I know, Oracle, MySQL, and PostgreSQL do not.[详细]

2023-03-10 01:48 分类：问答

Is it possible to define an XOR constraint using JPA?

I need to define an XOR constraint on an entity using JPA i.e. a constraint that specifies that you can have a value in either column A or column B but not both (but at least one of them). It seems to[详细]

2023-03-08 02:40 分类：问答