Problem with table name containing punctuation mark
neilxp opened this issue · 0 comments
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$ npm -v
v10.16.0
oqc@OmegaStation3:
6.9.0
oqc@OmegaStation3:$ mysql --version$ xmysql --version
mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper
oqc@OmegaStation3:
xmysql@0.5.0
Mark issue with suitable label if it is clear what this issue is.