Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.21
-
None
-
Windows
Description
I just realized about a bug, I do not know if it is because of the CONNECT ODBC Engine or MariaDB Server itself:
When I do a query such as:
SELECT
|
*
|
FROM
|
t_name_Local_Server AS A
|
LEFT JOIN t_Name_Remote_Server AS B
|
ON A.Join_Column_Name = B.Join_Column_Name
|
MariaDB returns a Result Set which performs an INNER JOIN, not a LEFT JOIN. That is, it returns a result set which contains only those rows which are not null in Table aliased as B (t_Name_Remote_Server).