Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.10
-
None
-
*nix
Description
A SELECT query that uses a FULL JOIN fails with a syntax error if you use table aliases in the query.
Code to reproduce:
create table a(aa int);
create table b(bb int);
insert into a values (12);
insert into b values (12);
/* Returns one row. */
select * from a full join b on aa = bb;
/* Fails with "check the manual that corresponds to your MariaDB server version for the right syntax to use near 'full join b b_alias on aa = bb' at line 1" */
select * from a a_alias full join b b_alias on aa = bb;