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

Problem with table name containing punctuation mark #25

Open
neilxp opened this issue Nov 19, 2019 · 0 comments
Open

Problem with table name containing punctuation mark #25

neilxp opened this issue Nov 19, 2019 · 0 comments

Comments

@neilxp
Copy link

neilxp commented Nov 19, 2019

I have many tables with punctuation marks in their name, which is legal in MySQL. Including ()_~*
But xmysql doesn't work with these tables.

oqc@OmegaStation3:~$ curl 'http://127.0.0.1:3000/api/DK_(IC1909*2~IF1909*3)~(sh000905*2~sh000300*3)/describe'

<title>Error</title>
Cannot GET /api/DK_(IC1909*2~IF1909*3)~(sh000905*2~sh000300*3)/describe

Other tables without these punctuations in names are OK.

oqc@OmegaStation3:~$ curl 'http://127.0.0.1:3000/api/DK_sh000300/describe'
[{"Field":"id","Type":"bigint(20)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"instrumentId","Type":"varchar(30)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"day","Type":"date","Null":"YES","Key":"UNI","Default":null,"Extra":""},{"Field":"open","Type":"double","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"close","Type":"double","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"high","Type":"double","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"low","Type":"double","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"preClose","Type":"double","Null":"YES","Key":"","Default":null,"Extra":""}]

Please provide dev environment versions of your system

oqc@OmegaStation3:$ node -v
v10.16.0
oqc@OmegaStation3:
$ npm -v
6.9.0
oqc@OmegaStation3:$ mysql --version
mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper
oqc@OmegaStation3:
$ xmysql --version
[email protected]

Mark issue with suitable label if it is clear what this issue is.

@o1lab o1lab transferred this issue from nocodb/nocodb May 27, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant