Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.21
-
None
-
Linux
Description
DELIMITER $$
|
|
ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `aigk_appl` AS ( |
SELECT
|
`a_cl`.`id_profile` AS `id_profile` |
,`a_cl`.`id_profile_parent` AS `id_profile_parent` |
,`a_cl`.`id_document` AS `id_document` |
,`pr_gr_cl`.`id_profile_group` AS `id_profile_group` |
,`pr_gr_cl`.`description` AS `группа` |
,`a_cl`.`FNAME` AS `фио` |
,`apt`.`id_profile_type` AS `id_profile_type` |
,`apt`.`description` AS `профайл_тип` |
,column_get(`a_cl`.`dynamic_cols`,'INN' AS CHAR CHARSET utf8) AS `ИНН` |
,`doc_type_21`.`description` AS `название_паспорта` |
,`doc_21`.`series` AS `паспорт_серия` |
,`doc_21`.`number` AS `паспорт_номер` |
,`doc_21`.`date_of_issue` AS `паспорт_дата` |
,`doc_21`.`authority` AS `паспорт_кем` |
,`doc_21`.subdivision_code AS код_подразделения |
,`doc_84`.`number` AS `СНИЛС_номер` |
,`doc_84`.`date_of_issue` AS `СНИЛС_дата` |
,column_get(`a_cl`.`dynamic_cols`,'secondname' AS CHAR CHARSET utf8) AS `фамилия` |
,column_get(`a_cl`.`dynamic_cols`,'firstname' AS CHAR CHARSET utf8) AS `имя` |
,column_get(`a_cl`.`dynamic_cols`,'middlename' AS CHAR CHARSET utf8) AS `отчетсво` |
,column_get(`a_cl`.`dynamic_cols`,'old_middlename' AS CHAR CHARSET utf8) AS `old_фамилия` |
,column_get(`a_cl`.`dynamic_cols`,'old_firstname' AS CHAR CHARSET utf8) AS `old_имя` |
,column_get(`a_cl`.`dynamic_cols`,'old_secondname' AS CHAR CHARSET utf8) AS `old_отчество` |
,column_get(`a_cl`.`dynamic_cols`,'gender' AS CHAR CHARSET utf8) AS `пол` |
,column_get(`a_cl`.`dynamic_cols`,'birthdate' AS DATE) AS `дата_рождения` |
,column_get(`a_cl`.`dynamic_cols`,'birthplace' AS CHAR CHARSET utf8) AS `место_рождения` |
,`fam`.`description` AS `семейное_положение` |
,column_get(`a_cl`.`dynamic_cols`,'marriage_contract' AS SIGNED) AS `брачный_договор` |
,`crm_e`.`description` AS `образование` |
,`army`.`description` AS `армия` |
,addr.fullname AS адрес |
FROM
|
`appl_profiles` `a_cl` JOIN `appl_profiles_groups` `pr_gr` ON(`a_cl`.`id_profile` = `pr_gr`.`id_profile`) |
JOIN `appl_profile_groups` `pr_gr_cl` ON(`pr_gr`.`id_profile_group` = `pr_gr_cl`.`id_profile_group`) |
LEFT JOIN `appl_profile_doc` `doc_21` ON((`a_cl`.`id_profile` = `doc_21`.`id_profile`) AND (`doc_21`.`id_doc_type` = 1)) |
LEFT JOIN `crm_doc_type` `doc_type_21` ON(`doc_21`.`id_doc_type` = `doc_type_21`.`id_doc_type`) |
LEFT JOIN `appl_profile_doc` `doc_84` ON((`a_cl`.`id_profile` = `doc_84`.`id_profile`) AND (`doc_84`.`id_doc_type` = 84)) |
LEFT JOIN `crm_family_type` `fam` ON(column_get(`a_cl`.`dynamic_cols`,'id_family_type' AS SIGNED) = `fam`.`id_family_type`) |
LEFT JOIN `crm_education` `crm_e` ON((column_get(`a_cl`.`dynamic_cols`,'id_education' AS SIGNED) = `crm_e`.`id_education`)) |
LEFT JOIN `appl_profile_types` `apt` ON(`a_cl`.`id_profile_type` = `apt`.`id_profile_type`) |
JOIN `appl_profile_addr` addr ON (a_cl.id_profile = addr.id_profile AND addr.addr_type = 'reg') |
|
LEFT JOIN `crm_army_status` `army` ON((column_get(`a_cl`.`dynamic_cols`,'id_army_status' AS SIGNED) = `army`.`id_army_status`)))$$ |
|
DELIMITER ;
|
# mysql
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 1098
|
Server version: 10.0.21-MariaDB MariaDB Server
|
|
|
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
|
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
|
MariaDB [(none)]> show processlist;
|
+------+--------+-----------------+--------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+------+--------+-----------------+--------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 1047 | dev | localhost | dev | Sleep | 2437 | | NULL | 0.000 |
|
| 1048 | dev | localhost | dev | Sleep | 4351 | | NULL | 0.000 |
|
| 1049 | dev | localhost | dev | Sleep | 2696 | | NULL | 0.000 |
|
| 1050 | dev | localhost | dev | Sleep | 2683 | | NULL | 0.000 |
|
| 1051 | dev | localhost | dev | Sleep | 2585 | | NULL | 0.000 |
|
| 1052 | dev | localhost | dev | Sleep | 5057 | | NULL | 0.000 |
|
| 1053 | dev | localhost | dev | Sleep | 2443 | | NULL | 0.000 |
|
| 1054 | dev | localhost | dev | Sleep | 2439 | | NULL | 0.000 |
|
| 1057 | root | localhost:50646 | NULL | Sleep | 13497 | | NULL | 0.000 |
|
| 1058 | itpark | localhost | itpark | Sleep | 11578 | | NULL | 0.000 |
|
| 1059 | itpark | localhost | itpark | Sleep | 11571 | | NULL | 0.000 |
|
| 1060 | itpark | localhost | itpark | Sleep | 11551 | | NULL | 0.000 |
|
| 1061 | itpark | localhost | itpark | Sleep | 11540 | | NULL | 0.000 |
|
| 1062 | itpark | localhost | itpark | Sleep | 11606 | | NULL | 0.000 |
|
| 1063 | itpark | localhost | itpark | Sleep | 11594 | | NULL | 0.000 |
|
| 1064 | itpark | localhost | itpark | Sleep | 11590 | | NULL | 0.000 |
|
| 1065 | itpark | localhost | itpark | Sleep | 11584 | | NULL | 0.000 |
|
| 1096 | root | localhost:50686 | dev | Query | 374 | Waiting for table metadata lock | ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `aigk_appl` AS (
|
SELE | 0.000 |
|
| 1097 | root | localhost:50688 | dev | Sleep | 287 | | NULL | 0.000 |
|
| 1098 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
|
+------+--------+-----------------+--------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
20 rows in set (0.00 sec)
|
|
|