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

Data too long when setting @@tidb_cloud_storage_uri #48029

Closed
tangenta opened this issue Oct 27, 2023 · 0 comments · Fixed by #48030
Closed

Data too long when setting @@tidb_cloud_storage_uri #48029

tangenta opened this issue Oct 27, 2023 · 0 comments · Fixed by #48030
Labels
affects-7.5 component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development severity/major type/bug The issue is confirmed as a bug.

Comments

@tangenta
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Previously, global variable value cannot have more than 1024 characters:

mysql> desc mysql.global_variables;
+----------------+---------------+------+------+---------+-------+
| Field          | Type          | Null | Key  | Default | Extra |
+----------------+---------------+------+------+---------+-------+
| VARIABLE_NAME  | varchar(64)   | NO   | PRI  | NULL    |       |
| VARIABLE_VALUE | varchar(1024) | YES  |      | NULL    |       |
+----------------+---------------+------+------+---------+-------+
2 rows in set (0.00 sec)

However, S3 URI is easy to exceed 1024 if it consists of multiple query parameters.

2. What did you expect to see? (Required)

No error.

3. What did you see instead (Required)

ERROR 1406 (22001): Data too long for column 'VARIABLE_VALUE' at row 1; 

4. What is your TiDB version? (Required)

9224f62

@tangenta tangenta added type/bug The issue is confirmed as a bug. severity/major labels Oct 27, 2023
@ti-chi-bot ti-chi-bot bot added may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 may-affects-7.5 labels Oct 27, 2023
@tangenta tangenta added feature/developing the related feature is in development affects-7.5 and removed may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 may-affects-7.5 labels Oct 27, 2023
@jebter jebter added the component/ddl This issue is related to DDL of TiDB. label Oct 30, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.5 component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants