Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
5.5.47-galera
Description
A simple SQL query which works fine for MySQL (5.0.95) hangs the system for MariaDB. No error message appear and Maria server does not appear to be using CPU cycles.
Here is an example of a problem SQL which uses a single table:
USE cworks_classicplus1; |
SELECT DISTINCT author_tab1.author , author_tab2.author , |
author_tab1.num , author_tab2.num
|
FROM author AS author_tab1 , author AS author_tab2 |
WHERE author_tab1.author ='SMITH' AND author_tab2.author ='JONES' |
AND author_tab1.recnum = author_tab2.recnum ; |
The table was originally created using:
CREATE TABLE author ( |
num INTEGER(8) PRIMARY KEY, |
recnum INTEGER(8) NOT NULL, |
author VARCHAR(50) NOT NULL, |
finitial CHAR(1), |
rest VARCHAR(70) |
);
|
The sort of output expected (as from MySQL) is:
.
|
.
|
Smith Jones 7836054 7836053
|
Smith Jones 7843689 7843688
|
Smith Jones 8028018 8028016
|
Smith Jones 8028023 8028021
|