Details
-
Sub-Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.4.3
-
None
-
2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7
Description
CS previously returned an error for some queries that failed previously:
SELECT DISTINCT t2.gid AS lgid,
|
(SELECT t1.name FROM t1, t2
|
WHERE t1.lid = t2.lid AND t2.gid = lgid
|
ORDER BY t2.dt DESC LIMIT 1
|
) as clid
|
FROM t2;
|
|
|
CREATE VIEW v1 AS
|
SELECT DISTINCT t2.gid AS lgid,
|
(SELECT t1.name FROM t1, t2
|
WHERE t1.lid = t2.lid AND t2.gid = lgid
|
ORDER BY t2.dt DESC LIMIT 1
|
) as clid
|
FROM t2;
|
SELECT * FROM v1;
|
|
|
-ERROR 1815 (HY000) at line 96: Internal error: IDB-3019: Limit within a correlated subquery is currently not supported.
|
-ERROR 1815 (HY000) at line 110: Internal error: IDB-3019: Limit within a correlated subquery is currently not supported.
|
Now these queries work. We need to investigate the scope of this unexpected free feature.