Hello,
I guess I found case when visual editor generates incorrect SQL.
Generates the following SQL statement:
SELECT
*
FROM
(
SELECT
"SOA"."REL_INC_PROBS_MV"."SOURCE" AS "SOURCE",
"SOA"."REL_INC_PROBS_MV"."DEPEND" AS "DEPEND",
"SOA"."REL_INC_PROBS_MV"."TYPE" AS "TYPE",
"Группа Обращений>Обращения - Код обращения"."ID" AS "identifier_nrzurztxqzz",
"Группа Обращений>Обращения - Код обращения"."INCIDENT_ID" AS "identifier_nsuvruttzz",
"Группа Обращений>Обращения - Код обращения"."ADDED_BY" AS "identifier_nrxyvyvwwzz",
"Группа Обращений>Обращения - Код обращения"."ADDED_TIME" AS "identifier_uuwzvtvvx",
"Группа Обращений>Обращения - Код обращения"."REASON" AS "identifier_nrqvzvtvvrw",
"Группы обращений - ID"."AFFECTED_ITEM" AS "identifier_rqsxrtrvsq",
"Группы обращений - ID"."ASSIGNEE" AS "identifier_nxxwuzxqrt",
"Группы обращений - ID"."ASSIGNMENT" AS "identifier_nrwwrzvwwxt",
"Группы обращений - ID"."CATEGORY" AS "identifier_nruyruqyvxu",
"Группы обращений - ID"."CLOSE_TIME" AS "identifier_rvxxsvvsqx",
"Группы обращений - ID"."DESCRIPTION" AS "identifier_rxqwxtxtxx",
"Группы обращений - ID"."DIRECTION" AS "identifier_nrquvrvvtvv",
"Группы обращений - ID"."FZ_NUMBER" AS "identifier_nwsvzqwusv",
"Группы обращений - ID"."GROUPSERVICE" AS "identifier_rsxqzstxyt",
"Группы обращений - ID"."ID" AS "Группы обращений - ID__ID",
"Группы обращений - ID"."INCIDENTS_COUNT" AS "identifier_nuuvqwyuss",
"Группы обращений - ID"."OPEN_TIME" AS "identifier_rsrzttwyxr",
"Группы обращений - ID"."SERVICE" AS "Группы обращений - ID__SERVICE",
"Группы обращений - ID"."SUBCATEGORY" AS "identifier_nvuqszzzvv",
"Группы обращений - ID"."SYSMODTIME" AS "identifier_nrttwztyzsv",
"Группы обращений - ID"."TITLE" AS "Группы обращений - ID__TITLE"
FROM
"SOA"."REL_INC_PROBS_MV"
LEFT JOIN "SOA"."INCIDENT_GROUP_MEMBERS" "identifier_ztwtrywzy" ON "SOA"."REL_INC_PROBS_MV"."SOURCE" = "Группа Обращений>Обращения - Код обращения"."INCIDENT_ID"
LEFT JOIN "SOA"."INCIDENT_GROUPS" "Группы обращений - ID" ON "Группа Обращений>Обращения - Код обращения"."ID" = "Группы обращений - ID"."ID"
)
WHERE
ROWNUM <= 1048575
Oracle response is:
ORA-00904: "Группа Обращений>Обращения - Код обращения"."INCIDENT_ID": invalid identifier
As far as I understand "Группа Обращений>Обращения - Код обращения"."INCIDENT_ID" was renamed to "identifier_nsuvruttzz", but in join expression its referenced by original name.
First time the error was met in v 0.38.2. After upgrade to v0.39.1 still unchanged. Source database Oracle 12.1.
Diagnostic info
{
"browser-info": {
"language": "en-gb",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Safari/605.1.15",
"vendor": "Apple Computer, Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_261-b12",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_261",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "25.261-b12",
"os.name": "Windows Server 2019",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Europe/Moscow"
},
"metabase-info": {
"databases": [
"oracle"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.4"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.39.0",
"date": "2021-05-04",
"branch": "master",
"hash": "e0c624b"
},
"settings": {
"report-timezone": "Europe/Moscow"
}
}
}
on the first post