Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
2.2.12
Description
Following query parsed as QUERY_OP_SELECT
UPDATE test1 AS log_funnel
|
INNER JOIN (SELECT inner_funnel.idvisit, min(step_position) as minstep, max(step_position) as maxstep
|
FROM test1 inner_funnel
|
LEFT JOIN pwk_log_visit log_visit on inner_funnel.idvisit = log_visit.idvisit
|
WHERE inner_funnel.idfunnel = '10' |
AND log_visit.idsite = '8' |
AND log_visit.visit_last_action_time >= '2018-12-02 16:00:00' |
AND log_visit.visit_last_action_time <= '2018-12-03 15:59:59' |
GROUP BY inner_funnel.idvisit) lf
|
SET log_funnel.min_step = lf.minstep, log_funnel.max_step = lf.maxstep
|
WHERE log_funnel.idvisit = lf.idvisit
|
AND log_funnel.idfunnel = '10' |
AND log_funnel.min_step != lf.minstep
|
AND log_funnel.max_step != lf.maxstep
|