Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.68, 10.7.1
-
None
Description
From https://dba.stackexchange.com/questions/306183/why-is-my-database-name-truncated
$ db=$(printf 'a%.0s' {1..40})
|
$ echo $db
|
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
|
$ podman run -d --rm -e MYSQL_ALLOW_EMPTY_PASSWORD=1 -e MYSQL_DATABASE=$db -e MYSQL_USER=u -e MYSQL_PASSWORD=p --name m55 mariadb:5.5
|
1b2c0740bf664b8a3da8071bb96234a86fe8dd5f3eb6348598f5d0c2b59ede56
|
|
$ podman exec -ti m55 mysql -u u -pp --column-type-info -e 'select database() as "database" union all select database()' $db
|
Field 1: `database`
|
Catalog: `def`
|
Database: ``
|
Table: ``
|
Org_table: ``
|
Type: VAR_STRING
|
Collation: latin1_swedish_ci (8)
|
Length: 34
|
Max_length: 34
|
Decimals: 0
|
Flags:
|
|
|
+------------------------------------+
|
| database |
|
+------------------------------------+
|
| aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
|
| aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
|
+------------------------------------+
|
|
$ podman exec -ti m55 mysql -u u -pp --column-type-info -e 'select database()' $db
|
Field 1: `database()`
|
Catalog: `def`
|
Database: ``
|
Table: ``
|
Org_table: ``
|
Type: VAR_STRING
|
Collation: latin1_swedish_ci (8)
|
Length: 34
|
Max_length: 40
|
Decimals: 31
|
Flags:
|
|
|
+------------------------------------------+
|
| database() |
|
+------------------------------------------+
|
| aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
|
+------------------------------------------+
|
Above with 5.5 however have verified it on 10.2.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Fix Version/s | 10.2.42 [ 26803 ] | |
Fix Version/s | 10.3.33 [ 26805 ] | |
Fix Version/s | 10.4.23 [ 26807 ] | |
Fix Version/s | 10.5.14 [ 26809 ] | |
Fix Version/s | 10.6.6 [ 26811 ] | |
Fix Version/s | 10.7.2 [ 26813 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Assignee | Alexander Barkov [ bar ] | Daniel Black [ danblack ] |
Resolution | Fixed [ 1 ] | |
Status | Confirmed [ 10101 ] | Closed [ 6 ] |