PostgreSQL Table Name이 double-quotes로 되어 있을 경우 Load 오류 발생 #832
Description
"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