Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-10-16 Thread Pantelis Theodosiou
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 :) > >

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-10-16 Thread Federico Razzoli
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

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-10-16 Thread Peter Laursen
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 > >

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-10-16 Thread Sergei Golubchik
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

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-10-16 Thread Pantelis Theodosiou
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

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-10-16 Thread 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,

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-04-06 Thread Pantelis Theodosiou
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 >

[Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-04-04 Thread Peter Laursen
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