Issue 58 #68

Closed

makssent wants to merge 2 commits into red-soft-ru:master from makssent:issue-58

Collaborator

makssent commented Jul 4, 2024

Fixes #58

Changes proposed in this pull request:

Fix error message: "You have an error in your SQL syntax: SELECT C.CUST_NAME C.CUST_CITY FROM CUSTOMER c WHERE c.agent_code IN (WITH T121 AS (SELECT AGENT_CODE FROM AGENTS) SELECT C.CUST_NAME FROM CUSTOMER c LEFT JOIN T121 T ON T.AGENT_CODE = C.AGENT_CODE) no viable alternative at input 'IN' at line 1 position 68 near @1568:69='IN'<106>1:68"
New error message: "Table or view T121 does not exist."

makssent added 2 commits

July 3, 2024 14:06


          fix "no viable alternative at input 'WITH'"

1f5248c


          fix "no viable alternative at input 'IN'" test: T122

95ebe4f

TedCraft closed this

Collaborator

TedCraft commented Jul 4, 2024

Закрыл т.к. нет смысле делать два пул реквеста с одинаковыми коммитами. Можно просто в одном указать два issue

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

None yet