GreptimeTeam/greptimedb
View on GitHubUnable to list tables in GreptimeDB using the database client in VSCode
Open
#6,546 opened on Jul 17, 2025
C-enhancementgood first issue
Repository metrics
- Stars
- (6,332 stars)
- PR merge metrics
- (PR metrics pending)
Description
What type of enhancement is this?
API improvement
What does the enhancement do?
Unable to list tables in GreptimeDB using the database client in VSCode:
Execute fail : SELECT TABLE_COMMENT "comment",TABLE_NAME "name",TABLE_ROWS "table_rows",`AUTO_INCREMENT` "auto_increment",
row_format "row_format",DATA_LENGTH "data_length",INDEX_LENGTH "index_length",TABLE_COLLATION "collation",
TABLE_TYPE "view_group",`ENGINE` engine
FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'public' and TABLE_TYPE<>'VIEW' ORDER BY TABLE_NAME;
2025-07-17 18:19:58 [ERROR] (PlanQuery): Failed to plan SQL: No field named "AUTO_INCREMENT". Valid fields are information_schema.tables.table_catalog, information_schema.tables.table_schema, information_schema.tables.table_name, information_schema.tables.table_type, information_schema.tables.table_id, information_schema.tables.data_length, information_schema.tables.max_data_length, information_schema.tables.index_length, information_schema.tables.max_index_length, information_schema.tables.avg_row_length, information_schema.tables.engine, information_schema.tables.version, information_schema.tables.row_format, information_schema.tables.table_rows, information_schema.tables.data_free, information_schema.tables.auto_increment, information_schema.tables.create_time, information_schema.tables.update_time, information_schema.tables.check_time, information_schema.tables.table_collation, information_schema.tables.checksum, information_schema.tables.create_options, information_schema.tables.table_comment, information_schema.tables.temporary.
2025-07-17 18:19:58 [ERROR] Error: (PlanQuery): Failed to plan SQL: No field named "AUTO_INCREMENT". Valid fields are information_schema.tables.table_catalog, information_schema.tables.table_schema, information_schema.tables.table_name, information_schema.tables.table_type, information_schema.tables.table_id, information_schema.tables.data_length, information_schema.tables.max_data_length, information_schema.tables.index_length, information_schema.tables.max_index_length, information_schema.tables.avg_row_length, information_schema.tables.engine, information_schema.tables.version, information_schema.tables.row_format, information_schema.tables.table_rows, information_schema.tables.data_free, information_schema.tables.auto_increment, information_schema.tables.create_time, information_schema.tables.update_time, information_schema.tables.check_time, information_schema.tables.table_collation, information_schema.tables.checksum, information_schema.tables.create_options, information_schema.tables.table_comment, information_schema.tables.temporary.
Looks like missing AUTO_INCREMENT column in information_schema.tables.
Implementation challenges
No response