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
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.
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
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
>
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
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
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 :)
>
>
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
8 matches
Mail list logo