starred/teamide-team-ide

Fork 0

mirror of https://github.com/team-ide/teamide.git synced 2026-04-28 03:55:49 +03:00

[GH-ISSUE #157] 达梦数据库编辑表问题 #61

New issue

Open

opened 2026-02-28 00:38:33 +03:00 by kerem · 5 comments

kerem commented

2026-02-28 00:38:33 +03:00

Owner

Originally created by @zero-wsh on GitHub (Nov 20, 2023).
Original GitHub issue: https://github.com/team-ide/teamide/issues/157

1、编辑表响应慢
2、查询出来的数据每条都重复了

Originally created by @zero-wsh on GitHub (Nov 20, 2023). Original GitHub issue: https://github.com/team-ide/teamide/issues/157 1、编辑表响应慢 2、查询出来的数据每条都重复了 ![image](https://github.com/team-ide/teamide/assets/44697042/6ad2c909-0ceb-409d-81e0-093cfc0f45d8)

kerem commented

2026-02-28 00:38:33 +03:00

Author

Owner

@team-ide commented on GitHub (Nov 30, 2023):

编辑表的话会到数据库查询表信息，如果数据库查询表、字段、主键、索引性能较差的话程序上无法处理
字段多的情况可以试下这两个SQL吗查询表字段信息


SELECT 
	t.COLUMN_NAME columnName,
	t.DATA_DEFAULT columnDefault,
	t.CHARACTER_SET_NAME columnCharacterSetName,
	t.NULLABLE isNullable,
	t.DATA_TYPE columnDataType,
	t.DATA_LENGTH,
	t.DATA_PRECISION,
	t.DATA_SCALE,
	tc.COMMENTS columnComment,
	t.TABLE_NAME tableName,
	t.OWNER ownerName
FROM ALL_TAB_COLUMNS t
LEFT JOIN ALL_COL_COMMENTS tc ON(tc.OWNER=t.OWNER AND tc.TABLE_NAME=t.TABLE_NAME AND tc.COLUMN_NAME=t.COLUMN_NAME)
WHERE t.OWNER='TEST_DB'
    AND t.TABLE_NAME='TB_USER';


SELECT 
	t.COLUMN_NAME columnName,
	t.DATA_DEFAULT columnDefault,
	t.CHARACTER_SET_NAME columnCharacterSetName,
	t.NULLABLE isNullable,
	t.DATA_TYPE columnDataType,
	t.DATA_LENGTH,
	t.DATA_PRECISION,
	t.DATA_SCALE,
	t.TABLE_NAME tableName,
	t.OWNER ownerName
FROM ALL_TAB_COLUMNS t
WHERE t.OWNER='TEST_DB'
    AND t.TABLE_NAME='TB_USER';

@team-ide commented on GitHub (Nov 30, 2023): 编辑表的话会到数据库查询表信息，如果数据库查询表、字段、主键、索引性能较差的话程序上无法处理字段多的情况可以试下这两个SQL吗查询表字段信息 ```sql SELECT t.COLUMN_NAME columnName, t.DATA_DEFAULT columnDefault, t.CHARACTER_SET_NAME columnCharacterSetName, t.NULLABLE isNullable, t.DATA_TYPE columnDataType, t.DATA_LENGTH, t.DATA_PRECISION, t.DATA_SCALE, tc.COMMENTS columnComment, t.TABLE_NAME tableName, t.OWNER ownerName FROM ALL_TAB_COLUMNS t LEFT JOIN ALL_COL_COMMENTS tc ON(tc.OWNER=t.OWNER AND tc.TABLE_NAME=t.TABLE_NAME AND tc.COLUMN_NAME=t.COLUMN_NAME) WHERE t.OWNER='TEST_DB' AND t.TABLE_NAME='TB_USER'; SELECT t.COLUMN_NAME columnName, t.DATA_DEFAULT columnDefault, t.CHARACTER_SET_NAME columnCharacterSetName, t.NULLABLE isNullable, t.DATA_TYPE columnDataType, t.DATA_LENGTH, t.DATA_PRECISION, t.DATA_SCALE, t.TABLE_NAME tableName, t.OWNER ownerName FROM ALL_TAB_COLUMNS t WHERE t.OWNER='TEST_DB' AND t.TABLE_NAME='TB_USER'; ```

kerem commented

2026-02-28 00:38:33 +03:00

Author

Owner

@zero-wsh commented on GitHub (Dec 19, 2023):

请问查询出来的数据每条都重复了这个问题修复了吗？我看最新的还有这个问题

@zero-wsh commented on GitHub (Dec 19, 2023): 请问查询出来的数据每条都重复了这个问题修复了吗？我看最新的还有这个问题

kerem commented

2026-02-28 00:38:33 +03:00

Author

Owner

@team-ide commented on GitHub (Dec 19, 2023):

你试下上边的语句将查询结果截图发下

@team-ide commented on GitHub (Dec 19, 2023): 你试下上边的语句将查询结果截图发下

kerem commented

2026-02-28 00:38:33 +03:00

Author

Owner

@zero-wsh commented on GitHub (Dec 20, 2023):

@zero-wsh commented on GitHub (Dec 20, 2023): ![image](https://github.com/team-ide/teamide/assets/44697042/43bda284-eaff-40e9-8734-7165fd94bc7a) ![image](https://github.com/team-ide/teamide/assets/44697042/4af9c53d-7f2a-4150-9e0d-7559c08ac1c7)

kerem commented

2026-02-28 00:38:33 +03:00

Author

Owner

@team-ide commented on GitHub (Dec 21, 2023):

达梦的字段注释表查询有冗余的数据，我程序处理吧，下个版本会处理

@team-ide commented on GitHub (Dec 21, 2023): 达梦的字段注释表查询有冗余的数据，我程序处理吧，下个版本会处理

kerem referenced this issue

2026-02-28 00:39:00 +03:00

[PR #61] [MERGED] 静态资源打包使用ZIP压缩 #176

No labels

pull-request

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/teamide-team-ide#61

No description provided.

Rows
Columns