单表增加了几个字段,后台抛出提示无效列名异常

基于系统现有的测试数据lowcode_zexample_single_table,增加了edit_user字段,提示无效列名

评论区

熊旭 2026-05-31 10:29

把控制台的语句,拷贝到到sql客户端执行,能正常执行


SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT id AS "id", name AS "name", age AS "age", birth_date AS "birth_date", interest AS "interest", editor AS "editor", editor_dept AS "editor_dept", edit_at AS "edit_at", tenant_id AS "tenant_id", create_user AS "create_user", create_time AS "create_time", create_dept AS "create_dept", update_user AS "update_user", update_time AS "update_time", is_deleted AS "is_deleted", editor_id AS "editor_id", edit_dept_id AS "edit_dept_id" FROM lowcode_zexample_single_table tbl WHERE (is_deleted = 0) AND tbl.tenant_id = 1 ORDER BY id DESC ) TMP WHERE ROWNUM <=10) WHERE ROW_ID > 0

回复

扫码关注

添加客服
图片未加载,请刷新后再试
联系我们