Re: [Maria-discuss] InnoDB selected projects

2014-04-11 Thread Pantelis Theodosiou
Adam, you are right, bulk load project is 5835: (2) InnoDB fast bulk load Description: External tool to load CVS file directly to InnoDB file space (innodb_file_per_table = 1). https://mariadb.atlassian.net/browse/MDEV-5835 On Fri, Apr 11, 2014 at 5:28 PM, Adam Scott adam.c.sc...@gmail.com

Re: [Maria-discuss] query result inconsistency between MariaDB 10.0.x and Oracle MySQL 5.1.x

2014-05-23 Thread Pantelis Theodosiou
Roberto, Federico, While I agree with your comments regarding use of ONLY_FULL_GROUP_BY, the specific case has primary keys defined on (id), on both tables. So, the GROUP BY t1.id has (or should have) no effect as every group will have exactly one row and the results should be the deterministic.

Re: [Maria-discuss] Group Concat and Sub Query

2015-10-04 Thread Pantelis Theodosiou
Did you mean to write ORDER BY value ASC and ORDER BY value DESC in the subqueries? The "ORDER BY date" doesn't make sense in the subqueries as all the rows will have the same date, due to the "WHERE date=a.date" correlation. Pantelis On Sat, Oct 3, 2015 at 2:12 AM, Roberto Spadim

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 >

Re: [Maria-discuss] MariaDB Knowledge base - 500 error

2016-10-21 Thread Pantelis Theodosiou
B 10.1 <https://mariadb.com/kb/en/what-is-mariadb-101/>. - The previous stable release is MariaDB 5.5 <https://mariadb.com/kb/en/what-is-mariadb-55/>. Pantelis Theodosiou ___ Mailing list: https://launchpad.net/~maria-discuss

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

2016-10-16 Thread Pantelis Theodosiou
aur...@webyog.com> wrote: > 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 <yperc...@gmail.com> > wrote: > >> Would this be good to be added

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] Query ambiguity

2018-05-17 Thread Pantelis Theodosiou
readable and easy to edit: https://mariadb.com/kb/en/library/with/ Best regards Pantelis Theodosiou On Thu, May 17, 2018 at 11:23 AM, <rhys.campb...@swisscom.com> wrote: > You're not making a lot of sense here. Please explain the "ambiguity". > That's a fairly complex query