TiDB, I_S: TABLE_ID size is 21 or 64

translator_bot · June 21, 2024, 3:35pm

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb, I_S: TABLE_ID size is 21 or 64

| username: ShawnYan

Bug Report
Clearly and accurately describe the issue you found. Providing any steps to reproduce the problem can help the development team address the issue promptly.
[TiDB Version] tidb-server, master
[Impact of the Bug]

[Possible Steps to Reproduce]

[Observed Unexpected Behavior]

github.com

pingcap/tidb/blob/master/pkg/infoschema/tables.go#L1379


      
          	{name: stmtsummary.PreparedStr, tp: mysql.TypeTiny, size: 1, flag: mysql.NotNullFlag, comment: "Whether prepared"},
          	{name: stmtsummary.AvgAffectedRowsStr, tp: mysql.TypeDouble, size: 22, flag: mysql.NotNullFlag | mysql.UnsignedFlag, comment: "Average number of rows affected"},
          	{name: stmtsummary.FirstSeenStr, tp: mysql.TypeTimestamp, size: 26, flag: mysql.NotNullFlag, comment: "The time these statements are seen for the first time"},
          	{name: stmtsummary.LastSeenStr, tp: mysql.TypeTimestamp, size: 26, flag: mysql.NotNullFlag, comment: "The time these statements are seen for the last time"},
          	{name: stmtsummary.PlanInCacheStr, tp: mysql.TypeTiny, size: 1, flag: mysql.NotNullFlag, comment: "Whether the last statement hit plan cache"},
          	{name: stmtsummary.PlanCacheHitsStr, tp: mysql.TypeLonglong, size: 20, flag: mysql.NotNullFlag, comment: "The number of times these statements hit plan cache"},
          	{name: stmtsummary.PlanInBindingStr, tp: mysql.TypeTiny, size: 1, flag: mysql.NotNullFlag, comment: "Whether the last statement is matched with the hints in the binding"},
          	{name: stmtsummary.QuerySampleTextStr, tp: mysql.TypeBlob, size: types.UnspecifiedLength, comment: "Sampled original statement"},
          	{name: stmtsummary.PrevSampleTextStr, tp: mysql.TypeBlob, size: types.UnspecifiedLength, comment: "The previous statement before commit"},
          	{name: stmtsummary.PlanDigestStr, tp: mysql.TypeVarchar, size: 64, comment: "Digest of its execution plan"},
          	{name: stmtsummary.PlanStr, tp: mysql.TypeBlob, size: types.UnspecifiedLength, comment: "Sampled execution plan"},
          	{name: stmtsummary.BinaryPlan, tp: mysql.TypeBlob, size: types.UnspecifiedLength, comment: "Sampled binary plan"},
          	{name: stmtsummary.Charset, tp: mysql.TypeVarchar, size: 64, comment: "Sampled charset"},
          	{name: stmtsummary.Collation, tp: mysql.TypeVarchar, size: 64, comment: "Sampled collation"},
          	{name: stmtsummary.PlanHint, tp: mysql.TypeVarchar, size: 64, comment: "Sampled plan hint"},
          	{name: stmtsummary.MaxRequestUnitReadStr, tp: mysql.TypeDouble, flag: mysql.NotNullFlag | mysql.UnsignedFlag, size: 22, comment: "Max read request-unit cost of these statements"},
          	{name: stmtsummary.AvgRequestUnitReadStr, tp: mysql.TypeDouble, flag: mysql.NotNullFlag | mysql.UnsignedFlag, size: 22, comment: "Average read request-unit cost of these statements"},
          	{name: stmtsummary.MaxRequestUnitWriteStr, tp: mysql.TypeDouble, flag: mysql.NotNullFlag | mysql.UnsignedFlag, size: 22, comment: "Max write request-unit cost of these statements"},
          	{name: stmtsummary.AvgRequestUnitWriteStr, tp: mysql.TypeDouble, flag: mysql.NotNullFlag | mysql.UnsignedFlag, size: 22, comment: "Average write request-unit cost of these statements"},
          	{name: stmtsummary.MaxQueuedRcTimeStr, tp: mysql.TypeLonglong, size: 22, flag: mysql.NotNullFlag | mysql.UnsignedFlag, comment: "Max time of waiting for available request-units"},
          	{name: stmtsummary.AvgQueuedRcTimeStr, tp: mysql.TypeLonglong, size: 22, flag: mysql.NotNullFlag | mysql.UnsignedFlag, comment: "Max time of waiting for available request-units"},

var tableTableTiFlashTablesCols = []columnInfo{
{name: "TABLE_ID", tp: mysql.TypeLonglong, size: 64},

github.com

pingcap/tidb/blob/master/pkg/infoschema/tables.go#L1436


      
          	{name: "DELTA_COUNT", tp: mysql.TypeLonglong, size: 64},
          	{name: "TOTAL_DELTA_ROWS", tp: mysql.TypeLonglong, size: 64},
          	{name: "TOTAL_DELTA_SIZE", tp: mysql.TypeLonglong, size: 64},
          	{name: "AVG_DELTA_ROWS", tp: mysql.TypeDouble, size: 64},
          	{name: "AVG_DELTA_SIZE", tp: mysql.TypeDouble, size: 64},
          	{name: "AVG_DELTA_DELETE_RANGES", tp: mysql.TypeDouble, size: 64},
          	{name: "STABLE_COUNT", tp: mysql.TypeLonglong, size: 64},
          	{name: "TOTAL_STABLE_ROWS", tp: mysql.TypeLonglong, size: 64},
          	{name: "TOTAL_STABLE_SIZE", tp: mysql.TypeLonglong, size: 64},
          	{name: "TOTAL_STABLE_SIZE_ON_DISK", tp: mysql.TypeLonglong, size: 64},
          	{name: "AVG_STABLE_ROWS", tp: mysql.TypeDouble, size: 64},
          	{name: "AVG_STABLE_SIZE", tp: mysql.TypeDouble, size: 64},
          	{name: "TOTAL_PACK_COUNT_IN_DELTA", tp: mysql.TypeLonglong, size: 64},
          	{name: "MAX_PACK_COUNT_IN_DELTA", tp: mysql.TypeLonglong, size: 64},
          	{name: "AVG_PACK_COUNT_IN_DELTA", tp: mysql.TypeDouble, size: 64},
          	{name: "AVG_PACK_ROWS_IN_DELTA", tp: mysql.TypeDouble, size: 64},
          	{name: "AVG_PACK_SIZE_IN_DELTA", tp: mysql.TypeDouble, size: 64},
          	{name: "TOTAL_PACK_COUNT_IN_STABLE", tp: mysql.TypeLonglong, size: 64},
          	{name: "AVG_PACK_COUNT_IN_STABLE", tp: mysql.TypeDouble, size: 64},
          	{name: "AVG_PACK_ROWS_IN_STABLE", tp: mysql.TypeDouble, size: 64},
          	{name: "AVG_PACK_SIZE_IN_STABLE", tp: mysql.TypeDouble, size: 64},

var tableTableTiFlashSegmentsCols = []columnInfo{
{name: "TABLE_ID", tp: mysql.TypeLonglong, size: 64},

[Expected Behavior]
The size should be 21?

{name: "TABLE_ID", tp: mysql.TypeLonglong, size: 21},

[Related Components and Specific Versions]

[Other Background Information or Screenshots]
Such as cluster topology, system and kernel versions, application app information, etc.; if the issue is related to SQL, please provide the SQL statements and related table schema information; if there are critical errors in the node logs, please provide the relevant node log content or files; if some business-sensitive information is inconvenient to provide, please leave contact information for private communication.

translator_bot · June 21, 2024, 3:35pm

| username: ShawnYan | Original post link

Raise issue:

github.com/pingcap/tidb

tidb, I_S: TABLE_ID size is 21 or 64

opened 08:25AM - 06 Nov 23 UTC

shawn0915

type/bug sig/execution severity/moderate component/tiflash affects-8.1 found/community

## Bug Report Please answer these questions before submitting your issue. Tha…nks! ### 1. Minimal reproduce step (Required) https://github.com/pingcap/tidb/blob/master/pkg/infoschema/tables.go#L1379 ``` var tableTableTiFlashTablesCols = []columnInfo{ {name: "TABLE_ID", tp: mysql.TypeLonglong, size: 64}, ``` https://github.com/pingcap/tidb/blob/master/pkg/infoschema/tables.go#L1436 ``` var tableTableTiFlashSegmentsCols = []columnInfo{ {name: "TABLE_ID", tp: mysql.TypeLonglong, size: 64}, ``` ref asktug topic: https://asktug.com/t/topic/1015931 ### 2. What did you expect to see? (Required) size is 21? plz confirm. ### 3. What did you see instead (Required) ### 4. What is your TiDB version? (Required) master

translator_bot · June 21, 2024, 3:35pm

| username: ShawnYan | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.