Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: The index table is missing the table_kind identifier #19740

Open
1 task done
qingxinhome opened this issue Nov 1, 2024 · 1 comment
Open
1 task done

[Bug]: The index table is missing the table_kind identifier #19740

qingxinhome opened this issue Nov 1, 2024 · 1 comment
Assignees
Labels
area/performance kind/bug Something isn't working phase/testing severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Milestone

Comments

@qingxinhome
Copy link
Contributor

Is there an existing issue for the same bug?

  • I have checked the existing issues.

Branch Name

main

Commit ID

The index table is missing the table_kind identifier

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

image

Expected Behavior

No response

Steps to Reproduce

DROP TABLE IF EXISTS `real_time_position`;
CREATE TABLE `real_time_position` (
`location_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '位置id',
`vehicle_id` VARCHAR(255) DEFAULT null COMMENT '车辆id',
`longitude` VARCHAR(64) DEFAULT null COMMENT '经度',
`latitude` VARCHAR(64) DEFAULT null COMMENT '纬度',
`time_stamp` BIGINT DEFAULT null COMMENT '记录位置信息的时间戳',
`distance` DOUBLE DEFAULT null COMMENT '距离',
`area` VARCHAR(64) DEFAULT null COMMENT '省份',
UNIQUE KEY `location_id` (`location_id`),
KEY `time_stamp_index` (`time_stamp`) COMMENT '时间戳索引',
KEY `vehicle_id_index` (`vehicle_id`) COMMENT '车辆ID索引'
) COMMENT='车辆实时位置表';


select * from mo_catalog.mo_indexes where table_id = (select rel_id from mo_catalog.mo_tables where relname = 'real_time_position');

select rel_id,relname,reldatabase,relkind from mo_catalog.mo_tables where relname = '__mo_index_unique_0192e666-2da3-74b3-9f75-d6f65a680e1d';

Additional information

No response

@qingxinhome qingxinhome added kind/bug Something isn't working needs-triage labels Nov 1, 2024
@qingxinhome qingxinhome added this to the 2.0.1 milestone Nov 1, 2024
@qingxinhome qingxinhome added the severity/s0 Extreme impact: Cause the application to break down and seriously affect the use label Nov 2, 2024
@qingxinhome qingxinhome assigned aressu1985 and unassigned qingxinhome Nov 6, 2024
@qingxinhome
Copy link
Contributor Author

The issue has been resolved. Please verify and test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/performance kind/bug Something isn't working phase/testing severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Projects
None yet
Development

No branches or pull requests

3 participants