场景,张三有一堆权限,复制张三的权限给李四
INSERT INTO "dlpt_dm"."t20_measure_authorization_group" ( "measure_authorization_group_id", "measure_dim_combination_id", "group_id", "creation_time", "update_time", "creator_id", "modifier_id", "measure_type", "due_time" ) SELECT REPLACE
( CAST ( uuid_generate_v4 ( ) AS VARCHAR ), '-', '' ),
"measure_dim_combination_id",
'b162453532d54777bb654b3691ab04d5',
"creation_time",
"update_time",
"creator_id",
"modifier_id",
"measure_type",
"due_time"
FROM
dlpt_dm.t20_measure_authorization_group
WHERE
group_id = 'b42c03ad9ba0431c9747f74e65656272'