On Sun, Oct 16, 2016 at 5:15 PM, Sergei Golubchik wrote:
> Hi, Peter!
>
> On Oct 16, Peter Laursen wrote:
> > Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
> > from there into MariaDB I think. -- Peter
>
> I'm afraid you've got it backwards :)
>
>
are not slow. Just SIGNAL an error is the value of
i_must_be_between_7_and_12 is not valid.
Federico
Dom 16/10/16, Pantelis Theodosiou <yperc...@gmail.com> ha scritto:
Oggetto: Re: [Maria-discuss] Virtual CHECK constraint using Virtual c
ok .. I should have checked properly! :-(
On Sun, Oct 16, 2016 at 6:15 PM, Sergei Golubchik wrote:
> Hi, Peter!
>
> On Oct 16, Peter Laursen wrote:
> > Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
> > from there into MariaDB I think. -- Peter
>
>
Hi, Peter!
On Oct 16, Peter Laursen wrote:
> Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
> from there into MariaDB I think. -- Peter
I'm afraid you've got it backwards :)
MySQL 8.0 has no CHECK constraint (at least it's not mentioned in
My suggestion is for documenting existing functionality and a use case for
VIRTUAL columns.
When CHECK constraints are actually added, it will be obsolete of course
but still useful for those that use older versions (5, 10).
On Sun, Oct 16, 2016 at 3:51 PM, Peter Laursen
Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
from there into MariaDB I think. -- Peter
On Sun, Oct 16, 2016 at 4:45 PM, Pantelis Theodosiou
wrote:
> Would this be good to be added in the documentation of VIRTUAL columns?
>
> Or as a separate page,
On Mon, Apr 4, 2016 at 2:10 PM, Peter Laursen
wrote:
> As described in this Blog
> http://mablomy.blogspot.dk/2016/04/check-constraint-for-mysql-not-null-on.html.
> A very nice hack/trick IMO.
>
> However it is not working with MariaDB as VC's cannot be declared NOT
>
As described in this Blog
http://mablomy.blogspot.dk/2016/04/check-constraint-for-mysql-not-null-on.html.
A very nice hack/trick IMO.
However it is not working with MariaDB as VC's cannot be declared NOT
NULL. What prevents that?
-- Peter
-- Webyog
8 matches
Mail list logo