Суть проблемы
пользуюсь navicat premium(новая версия не помогла)
обновил я Openserver у себя на компе и вот бядаааа....
теперь когда я нажимаю сохранить View в запрос добавляется гора скобок и экранизаций символов, да и таблицы теряют регистр
например было
SELECT
MPC.m_bname AS cat_bname,
PC.cat_name,
PC.bname AS pc_bname,
PC.sort AS pod_cat_sort,
P.`name`,
P.id AS p_id,
P.bname AS P_bname,
P.unit_name,
P.dsp_type,
P.recommended,
PV.pv_id,
PV.price,
PV.old_price,
PV.weight,
PV.energy,
PV.description,
PV.tovar_v,
CONCAT(PVI.pub_dir, PVI.img_name) AS img_name,
PP.props,
L.lapsha,
P.sort
FROM
M_parts AS P
LEFT JOIN v_part_variant_concat AS PV ON PV.part_id = P.id
LEFT JOIN M_parts_variant_img AS PVI ON PVI.var_parts_id = PV.pv_id
LEFT JOIN M_parts_category AS PC ON PC.`code` = P.cat_id
LEFT JOIN v_part_prop AS PP ON PP.part_id = P.id
LEFT JOIN A_main_cat_parts AS AMPC ON AMPC.cat_code = PC.`code`
LEFT JOIN M_main_cat_parts AS MPC ON MPC.id = AMPC.main_cat_id
LEFT JOIN M_lapsha AS L ON L.part_id = P.id
WHERE
P.`status` = 1
GROUP BY
PV.part_id
ORDER BY
PC.sort ASC,
P.sort DESC
а стало
select `mpc`.`m_bname` AS `cat_bname`,`pc`.`cat_name` AS `cat_name`,`pc`.`bname` AS `pc_bname`,`pc`.`sort` AS `pod_cat_sort`,`p`.`name` AS `name`,`p`.`id` AS `p_id`,`p`.`bname` AS `P_bname`,`p`.`unit_name` AS `unit_name`,`p`.`dsp_type` AS `dsp_type`,`p`.`recommended` AS `recommended`,`pv`.`pv_id` AS `pv_id`,`pv`.`price` AS `price`,`pv`.`old_price` AS `old_price`,`pv`.`weight` AS `weight`,`pv`.`energy` AS `energy`,`pv`.`description` AS `description`,`pv`.`tovar_v` AS `tovar_v`,concat(`pvi`.`pub_dir`,`pvi`.`img_name`) AS `img_name`,`pp`.`props` AS `props`,`l`.`lapsha` AS `lapsha`,`p`.`sort` AS `sort` from (((((((`M_parts` `p` left join `v_part_variant_concat` `pv` on((`pv`.`part_id` = `p`.`id`))) left join `M_parts_variant_img` `pvi` on((`pvi`.`var_parts_id` = `pv`.`pv_id`))) left join `M_parts_category` `pc` on((`pc`.`code` = `p`.`cat_id`))) left join `v_part_prop` `pp` on((`pp`.`part_id` = `p`.`id`))) left join `A_main_cat_parts` `ampc` on((`ampc`.`cat_code` = `pc`.`code`))) left join `M_main_cat_parts` `mpc` on((`mpc`.`id` = `ampc`.`main_cat_id`))) left join `M_lapsha` `l` on((`l`.`part_id` = `p`.`id`))) where (`p`.`status` = 1) group by `pv`.`part_id` order by `pc`.`sort`,`p`.`sort` desc
я все конфиги перелазил
ставил регистрозависимость
0 но новая версия MySql с таким параметром на винде вообще перестала, я так понял - нововедение
проверяю все на mysql 5.5