Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.3.29
-
Debian 11.4 using Docker
Description
Hi,
I'm facing on issue with this request :
SELECT DISTINCT(e.id) as id, e.code_barre, e.flag_fusion, f.libelle as famille, sf.libelle as sousFamille, m.nom, pl.libelle as plateforme, et.libelle as etat, e.quantite_reserve, e.stock_magasin, e.stock_amazon, e.stock_cdiscount_fbc, m.prix_vente_ht,m.prix_vente_ttc, m.cree_automatiquement, emp.code as emplacement, m.id as materielId, m.prix_achat_moyen_ht as prixAchatMoyenHt, e.asin FROM materiel_code_barre AS e LEFT JOIN materiel as m ON e.materiel_id = m.id LEFT JOIN stock_emplacement as emp ON e.ean_emplacement = emp.id LEFT JOIN materiel_etat as et ON m.etat_id = et.id LEFT JOIN materiel_plateforme as pl ON m.plateforme_id = pl.id LEFT JOIN categorie as f ON m.famille_id = f.id LEFT JOIN categorie as sf ON m.sous_famille_id = f.id WHERE e.code_barre is not null AND e.code_barre <> ''AND ( e.id LIKE "%5056208812636%" OR f.libelle LIKE "%5056208812636%" OR sf.libelle LIKE "%5056208812636%" OR m.nom LIKE "%5056208812636%" OR pl.libelle LIKE "%5056208812636%" OR et.libelle LIKE "%5056208812636%" OR e.stock_magasin LIKE "%5056208812636%" OR e.code_barre LIKE "%5056208812636%" OR e.asin LIKE "%5056208812636%" OR ( SELECT COUNT(e.id) FROM materiel_code_barre e2 JOIN stock_emplacement as em2 on e2.ean_emplacement = em2.id WHERE em2.id = e.id AND em2.code LIKE "%5056208812636%") > 0) ORDER BY e.id desc LIMIT 0, 10;
|
Using version 10.3.25 and 10.1. 48 : 1 row in set (0.229 sec)
Using version more than 10.3.25 : 1 row in set (1.414 sec)
Attachments
Issue Links
- relates to
-
MDEV-29442 Optimizer bug
- Confirmed