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

🐛 Bug: 当表的名称中有特殊字符时会出错! #8313

Open
1 task done
wanghonghe opened this issue Apr 22, 2024 · 1 comment
Open
1 task done

🐛 Bug: 当表的名称中有特殊字符时会出错! #8313

wanghonghe opened this issue Apr 22, 2024 · 1 comment

Comments

@wanghonghe
Copy link

Please confirm if bug report does NOT exist already ?

  • I confirm there is no existing issue for this

Steps to reproduce ?

当一个表的名字中存在特殊字符,比如”.“,即小数点时,查询这个表就会出错,因为查询将这个表名字拆分成了多段。
如下图:
image

image
而这个表名在navicat等软件中没有问题。

Desired Behavior

请修复一下这个问题。感谢

Project Details

使用sqlite数据库的docker安装的最新版本nocodb,链接的数据库版本为mysql8

Attachments

No response

@dstala
Copy link
Member

dstala commented May 15, 2024

When there are special characters in the name of a table, such as ".", which is a decimal point, an error will occur when querying the table because the query will split the table name into multiple segments.
As shown below:

There is no problem with this table name in software such as Navicat.

Use the latest version of nocodb installed by docker of sqlite database, and the linked database version is mysql8

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: 🏌️ Open
Development

No branches or pull requests

2 participants