解决下拉框替换输入框或调整位置导致数据重复提交的问题

shao 错误处理 370

输入框换成下拉框,或者调下位置点发布会报数据重复

回复

共1条回复 我来回复
  • shao的头像
    shao
    数式Oinone (oinone.top),专注解决复杂场景的开源低代码平台
    评论

    ### 界面设计器发布报错提示数据重复的修复sql

    ## 查出异常记录
    SELECT id,version from designer_ui_designer_view_layout AS a
    WHERE a.version!=(
    SELECT MAX(b.version)+1
    FROM designer_ui_designer_view_layout_history AS b
    WHERE b.layout_id = a.id
    );

    ## 修正异常记录
    UPDATE designer_ui_designer_view_layout AS a
    SET version = (
    SELECT MAX(b.version)+1
    FROM designer_ui_designer_view_layout_history AS b
    WHERE b.layout_id = a.id
    )
    WHERE a.version!=(
    SELECT MAX(b.version)+1
    FROM designer_ui_designer_view_layout_history AS b
    WHERE b.layout_id = a.id
    );

    8个月前 0条评论