# Something wrong when create TokuDB table and table name is upper case

**URL:** <https://forums.percona.com/t/something-wrong-when-create-tokudb-table-and-table-name-is-upper-case/8340>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [December 3, 2020, 7:04pm UTC](https://forums.percona.com/t/something-wrong-when-create-tokudb-table-and-table-name-is-upper-case/8340 "2020-12-03T19:04:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nickzren](https://avatars.discourse-cdn.com/v4/letter/n/f04885/32.png) [@nickzren](https://forums.percona.com/u/nickzren)\
**Post date:** [December 3, 2020, 7:04pm UTC](https://forums.percona.com/t/something-wrong-when-create-tokudb-table-and-table-name-is-upper-case/8340/1 "2020-12-03T19:04:34Z")

</div>

Here is an example:

mysql\> CREATE TABLE `TEST` (

→ `id` int

→ ) ENGINE=TokuDB;

Query OK, 0 rows affected (0.05 sec)

mysql\> show create table TEST;

ERROR 1017 (HY000): Can’t find file: ‘test’ (errno: 2 - No such file or directory)

And I cannot do any actions to this table.

It somehow is looking for lower case db file? I have tried to create table with lower case table name then it works.

InnoDB does not have the issue.

I’m working on a Mac OS, and test on a docker percona server 8.0.21 container.

Any suggestions to fix it? Thanks

---

<div class="post-metadata">

**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\
**Post date:** [December 4, 2020, 3:46am UTC](https://forums.percona.com/t/something-wrong-when-create-tokudb-table-and-table-name-is-upper-case/8340/2 "2020-12-04T03:46:48Z")

</div>

Hi @nickzrenI tried to reproduce your issue but without success.

```auto
mysql> CREATE TABLE TEST ( id int ) ENGINE=TokuDB;
Query OK, 0 rows affected (0.10 sec) 
 
mysql> 
mysql> show create table TEST; 
+-------+------------------------------------------------------------------------------------------------------------------+ 
| Table | Create Table | 
+-------+------------------------------------------------------------------------------------------------------------------+ 
| TEST | CREATE TABLE `TEST` ( 
 `id` int DEFAULT NULL 
) ENGINE=TokuDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | 
+-------+------------------------------------------------------------------------------------------------------------------+ 
1 row in set (0.01 sec) 
 
mysql> 
mysql> 
mysql> CREATE TABLE `TEST2` (                      
   -> `id` int 
   -> ) ENGINE=TokuDB; 
Query OK, 0 rows affected (0.10 sec) 
 
mysql> show create table TEST2;                        
+-------+-------------------------------------------------------------------------------------------------------------------+ 
| Table | Create Table | 
+-------+-------------------------------------------------------------------------------------------------------------------+ 
| TEST2 | CREATE TABLE `TEST2` ( 
 `id` int DEFAULT NULL 
) ENGINE=TokuDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | 
+-------+-------------------------------------------------------------------------------------------------------------------+ 
1 row in set (0.00 sec) 

```

---

<div class="post-metadata">

**Author:** ![nickzren](https://avatars.discourse-cdn.com/v4/letter/n/f04885/32.png) [@nickzren](https://forums.percona.com/u/nickzren)\
**Post date:** [December 4, 2020, 10:39am UTC](https://forums.percona.com/t/something-wrong-when-create-tokudb-table-and-table-name-is-upper-case/8340/3 "2020-12-04T10:39:14Z")

</div>

The problem only happened when explicitly create a separate volume for mysql data.

Below are exact steps to reproduce the issue:

```auto
mkdir ~/mysql_dir

docker run -d --name ps8 -v ~/mysql_dir:/var/lib/mysql:rw -p 3311:3306 -e MYSQL_ROOT_PASSWORD=root -e INIT_TOKUDB=1 percona/percona-server:8.0.21

mysql -h127.0.0.1 -uroot -proot -P3311 -e "create database testdb"

mysql -h127.0.0.1 -uroot -proot -P3311 -e "use testdb; CREATE TABLE TEST ( id int ) ENGINE=TokuDB;"

mysql -h127.0.0.1 -uroot -proot -P3311 -e "use testdb; show create table TEST"

ERROR 1017 (HY000) at line 1: Can't find file: 'test' (errno: 2 - No such file or directory)

```