2026-04-17 17:45
修改的原因 : 你原先的sql 想把一个字符串类型的字段作为pid(integer类型), mysql 在帮你转化的时候,可能会丢失数据,导致查询有问题
2026-04-17 15:05
将 view_rbuf 的 数据 form 配置 
改为
(
SELECT r1.* from (select `r`.`id` AS `id`,0 AS `pid`,`r`.`name` AS `name` from `sq_region` `r` ) as r1
union all
select b1.* from (select `b`.`id` AS `id`,CAST( `b`.region_id AS UNSIGNED) AS `pid`, `b`.`name` AS `name` from `sq_build` `b`) as b1
union all
select u1.* from (select `u`.`id` AS `id`,CAST(SUBSTRING_INDEX(`u`.`build_id`, ',', - 1) AS UNSIGNED) AS `pid`, `u`.`name` AS `name` from `sq_unit` `u` ) as u1
union all
select f1.* from (select `f`.`id` AS `id`,CAST(SUBSTRING_INDEX(`f`.`unit_id`, ',', - 1) AS UNSIGNED) AS `pid` , `f`.`name` AS `name` from `sq_floor` `f`) as f1
) as rbuf
