TYPE=VIEW
query=select `co-operativebank-198`.`bal_lib_glope`.`shcode` AS `SHCODE`,sum(`co-operativebank-198`.`bal_lib_glope`.`bal`) AS `bal`,`co-operativebank-198`.`bal_lib_glope`.`hcode` AS `hcode` from `co-operativebank-198`.`bal_lib_glope` group by `co-operativebank-198`.`bal_lib_glope`.`shcode` union select \'171011\' AS `SHCODE`,0 AS `bal`,\'17100\' AS `hcode`
md5=0317d29fb3f893ccf1873eb352a42fac
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-06-18 07:33:34
create-version=1
source=SELECT `SHCODE`,sum(`BAL`) as bal,`hcode` FROM `bal_lib_glope` group by shcode union select \'171011\' as SHCODE,0 as bal, \'17100\' as hcode
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-198`.`bal_lib_glope`.`shcode` AS `SHCODE`,sum(`co-operativebank-198`.`bal_lib_glope`.`bal`) AS `bal`,`co-operativebank-198`.`bal_lib_glope`.`hcode` AS `hcode` from `co-operativebank-198`.`bal_lib_glope` group by `co-operativebank-198`.`bal_lib_glope`.`shcode` union select \'171011\' AS `SHCODE`,0 AS `bal`,\'17100\' AS `hcode`
