PostgreSQL Table Name이 double-quotes로 되어 있을 경우 Load 오류 발생

[SeongyoonKim]

"Read from DB" 통해서 데이터를 가져오려고 하는데, "Query Statement"에서 "SELECT * FROM example."testCase"와 같이 테이블 명이 double-quotes 처리되어 있을 경우 하기와 같은 오류가 발생합니다.

• double-quotes된 테이블명은 PostgreSQL에서 허용을 하고 있는데 해당 부분 처리 확인이 필요할 것 같습니다. (https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS)

---

JOB ID: c_flC87osBG7D7D68U_202201102318395520 java.lang.Exception: SyntaxError: EOL while scanning string literal

at com.samsung.sds.brightics.agent.context.python.PythonProcessManager.run(PythonProcessManager.java:283)
at com.samsung.sds.brightics.agent.context.python.PythonProcessManager.run(PythonProcessManager.java:240)
at com.samsung.sds.brightics.agent.context.python.PythonContext.runFunction(PythonContext.java:72)
at com.samsung.sds.brightics.agent.service.TaskService.executeFunction(TaskService.java:203)
at com.samsung.sds.brightics.agent.service.TaskService.executeTaskToContext(TaskService.java:165)
at com.samsung.sds.brightics.agent.service.TaskService.getTaskResult(TaskService.java:115)
at com.samsung.sds.brightics.agent.service.TaskService$1.run(TaskService.java:83)

Caused by: java.lang.Throwable: Traceback (most recent call last): File "C:\Users___\Downloads\brightics-studio\brightics-server\functions\python\brightics\brightics_python_runner.py", line 113, in _executer code_tree = ast.parse(code) File "ast.py", line 35, in parse File "", line 2 params = {r"""datasource""": {r"""password""": r"""postgres""", r"""port""": r"""5432""", r"""ip""": r"""192.168.0.100""", r"""dbName""": r"""test""", r"""dbType""": r"""postgre""", r"""username""": r"""postgres"""}, r"""sql""": r"""SELECT * FROM example."testCase""""} ^ SyntaxError: EOL while scanning string literal ... 7 more

[github-actions[bot]]

Awesome! Thanks for taking the time to open an issue. We will have a look and answer as soon as we can.' first issue