Bug: dm查找小写表名出错

[MSK-USER]

Chat2DB Version

3.1.17

Describe the bug

打开dm数据库小写表名提示表不存在

tableName: ny_af_g_399940 ··· {"getApplicationMessage":{"env":"desktop","versions":"3.1.17","buildTime":1703689902917,"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) chat2db/3.1.1 Chrome/108.0.5359.215 Electron/22.3.27 Safari/537.36"},"requestUrl":"http://127.0.0.1:10824/api/rdb/dml/execute_table","requestParams":"{"sql":"select * from "ny_af_g_399940"","tableName":"ny_af_g_399940","pageNo":1,"pageSize":200,"total":0,"hasNextPage":true,"dataSourceId":3,"databaseType":"DM","schemaName":"B","type":"DM"}","errorCode":null,"errorMessage":"第1 行附近出现错误:\n无效的表或视图名[NY_AF_G_399940]","errorDetail":null,"solutionLink":null} ···

[tmlx1990]

Chat2DB Version

3.1.17

Describe the bug

打开dm数据库小写表名提示表不存在

tableName: ny_af_g_399940 ··· {"getApplicationMessage":{"env":"desktop","versions":"3.1.17","buildTime":1703689902917,"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) chat2db/3.1.1 Chrome/108.0.5359.215 Electron/22.3.27 Safari/537.36"},"requestUrl":"http://127.0.0.1:10824/api/rdb/dml/execute_table","requestParams":"{"sql":"select * from "ny_af_g_399940"","tableName":"ny_af_g_399940","pageNo":1,"pageSize":200,"total":0,"hasNextPage":true,"dataSourceId":3,"databaseType":"DM","schemaName":"B","type":"DM"}","errorCode":null,"errorMessage":"第1 行附近出现错误:\n无效的表或视图名[NY_AF_G_399940]","errorDetail":null,"solutionLink":null} ···

您好，我在本地没有复现到您这个问题。新建的表ny_af_g_399940。

[MSK-USER]

Chat2DB Version

3.1.17

Describe the bug

打开dm数据库小写表名提示表不存在 tableName: ny_af_g_399940 ··· {"getApplicationMessage":{"env":"desktop","versions":"3.1.17","buildTime":1703689902917,"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) chat2db/3.1.1 Chrome/108.0.5359.215 Electron/22.3.27 Safari/537.36"},"requestUrl":"http://127.0.0.1:10824/api/rdb/dml/execute_table","requestParams":"{"sql":"select * from "ny_af_g_399940"","tableName":"ny_af_g_399940","pageNo":1,"pageSize":200,"total":0,"hasNextPage":true,"dataSourceId":3,"databaseType":"DM","schemaName":"B","type":"DM"}","errorCode":null,"errorMessage":"第1 行附近出现错误:\n无效的表或视图名[NY_AF_G_399940]","errorDetail":null,"solutionLink":null} ···

您好，我在本地没有复现到您这个问题。新建的表ny_af_g_399940。

你好，w我和同事都有这个问题，使用dm的官方工具没这个问题

[MSK-USER]

Chat2DB Version

3.1.17

Describe the bug

打开dm数据库小写表名提示表不存在 tableName: ny_af_g_399940 ··· {"getApplicationMessage":{"env":"desktop","versions":"3.1.17","buildTime":1703689902917,"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) chat2db/3.1.1 Chrome/108.0.5359.215 Electron/22.3.27 Safari/537.36"},"requestUrl":"http://127.0.0.1:10824/api/rdb/dml/execute_table","requestParams":"{"sql":"select * from "ny_af_g_399940"","tableName":"ny_af_g_399940","pageNo":1,"pageSize":200,"total":0,"hasNextPage":true,"dataSourceId":3,"databaseType":"DM","schemaName":"B","type":"DM"}","errorCode":null,"errorMessage":"第1 行附近出现错误:\n无效的表或视图名[NY_AF_G_399940]","errorDetail":null,"solutionLink":null} ···

您好，我在本地没有复现到您这个问题。新建的表ny_af_g_399940。

你好，测试了下，dm所有的表都这样的，大写也是，dm连接是正常的

[MSK-USER]

Chat2DB Version

3.1.17

Describe the bug

打开dm数据库小写表名提示表不存在 tableName: ny_af_g_399940 ··· {"getApplicationMessage":{"env":"desktop","versions":"3.1.17","buildTime":1703689902917,"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) chat2db/3.1.1 Chrome/108.0.5359.215 Electron/22.3.27 Safari/537.36"},"requestUrl":"http://127.0.0.1:10824/api/rdb/dml/execute_table","requestParams":"{"sql":"select * from "ny_af_g_399940"","tableName":"ny_af_g_399940","pageNo":1,"pageSize":200,"total":0,"hasNextPage":true,"dataSourceId":3,"databaseType":"DM","schemaName":"B","type":"DM"}","errorCode":null,"errorMessage":"第1 行附近出现错误:\n无效的表或视图名[NY_AF_G_399940]","errorDetail":null,"solutionLink":null} ···

您好，我在本地没有复现到您这个问题。新建的表ny_af_g_399940。

你好，找到原因了，查询语句没有添加schema信息导致找不到表，因为这个表不在URL填写的默认schema里，算是一个bug吧。