Comments (3)
@k1LoW
Thank you for your response.
I noticed that it was a bug of MySQL and it has been fixed at 8.0.14.
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-14.html
Names of referenced columns of foreign keys were always shown in lowercase in SHOW CREATE TABLE output and the INFORMATION_SCHEMA.KEY_COLUMN_USAGE table. (Bug #27353767, Bug #88718)
Upgrading my local MySQL resolved this issue.
Sorry for bothering you. Thank you for your support!
from tbls.
Hi, @myzkyy Thank you for your report!!
I'll fix it as soon as possible.
from tbls.
I tried to check and could not reproduce it.
Is there something in the tbls.yml?
mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 8.0.19 |
+-----------+
1 row in set (0.00 sec)
mysql> CREATE DATABASE `issue-255` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected, 1 warning (0.01 sec)
mysql> USE `issue-255`;
Database changed
mysql> CREATE TABLE table1 (productCode INT PRIMARY KEY);
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE TABLE table2 (productCode INT, FOREIGN KEY(`productCode`) REFERENCES table1(`productcode`));
Query OK, 0 rows affected (0.03 sec)
mysql> SHOW CREATE TABLE table1;
+--------+--------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+--------------------------------------------------------------------------------------------------------------------------+
| table1 | CREATE TABLE `table1` (
`productCode` int NOT NULL,
PRIMARY KEY (`productCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+--------+--------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SHOW CREATE TABLE table2;
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| table2 | CREATE TABLE `table2` (
`productCode` int DEFAULT NULL,
KEY `productCode` (`productCode`),
CONSTRAINT `table2_ibfk_1` FOREIGN KEY (`productCode`) REFERENCES `table1` (`productCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
$ tbls version
1.43.1
$ tbls doc my://root:mypass@localhost:33308/issue-255 -f issue/255 # no tbls.yml
issue/255/schema.svg
issue/255/table1.svg
issue/255/table2.svg
issue/255/README.md
issue/255/table1.md
issue/255/table2.md
from tbls.
Related Issues (20)
- Listing functions doesn't respect include filter HOT 1
- Support of old MSSQL versions HOT 1
- go install show warning error HOT 2
- Parse error when generating Mermaid ER diagram due to double quotes in entity attribute comments HOT 2
- Add Hyperlinks to "Tables of" Sheet for Sheets in Excel Output HOT 1
- Documentation for Viewpoints HOT 1
- Lint rule "requireViewpoints" HOT 1
- Add the installation guide with aqua to the document
- Add "Arguments" to the field to sort in function category. HOT 2
- Refer viewpoints from tables HOT 1
- C warning in graphviz dependency HOT 2
- One-to-one relations are incorrectly exported as one-to-many in mermaid diagram HOT 4
- Viewpoints from tables not refered just in `diff` HOT 1
- D2 diagram support
- download v1.72.0 getting error HOT 3
- Distinguish Views from Tables in README.md HOT 5
- Configuration File Customization - Support for custom file names HOT 4
- An error about:invalid database scheme HOT 8
- Split configuration file for one schema HOT 2
- Github action could not find a writable bin path: /usr/local/bin:/usr/bin:/bin:/snap/bin HOT 7
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tbls.