You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE OR REPLACE TEMPORARY TABLE TEST (COL VARCHAR);
INSERT INTO TEST (COL) VALUES ('VARCHAR1'), ('VARCHAR2');
CREATE OR REPLACE TEMPORARY TABLE JOINED (COL VARCHAR, ANOTHER VARCHAR);
INSERT INTO JOINED (COL, ANOTHER) VALUES ('CHAR1', 'JOIN');
SELECTT.COL
, SUBSTR(T.COL, 4) AS ALIAS
, J.ANOTHERFROM TEST AS T
LEFT JOIN JOINED AS J
ON ALIAS =J.COL;
Result:
COL
ALIAS
ANOTHER
VARCHAR1
CHAR1
JOIN
VARCHAR2
CHAR2
MCVE in fakesnow:
importfakesnowimportsnowflake.connectordefmain():
withfakesnow.patch():
conn=snowflake.connector.connect(database="X", schema="Y")
conn.execute_string("CREATE OR REPLACE TEMPORARY TABLE TEST (COL VARCHAR)")
conn.execute_string("INSERT INTO TEST (COL) VALUES ('VARCHAR1'), ('VARCHAR2')")
conn.execute_string("CREATE OR REPLACE TEMPORARY TABLE JOINED (COL VARCHAR, ANOTHER VARCHAR)")
conn.execute_string("INSERT INTO JOINED (COL, ANOTHER) VALUES ('CHAR1', 'JOIN')")
rows=conn.cursor().execute(""" SELECT T.COL , SUBSTR(T.COL, 4) AS ALIAS , J.ANOTHER FROM TEST AS T LEFT JOIN JOINED AS J ON ALIAS = J.COL; """).fetchall()
if__name__=="__main__":
main()
Error:
snowflake.connector.errors.ProgrammingError: 002043 (02000): Binder Error: Referenced column "ALIAS" not found in FROM clause!
Candidate bindings: "J.COL"
LINE 1: ...ROM TEST AS T LEFT JOIN JOINED AS J ON ALIAS = J.COL
CREATE OR REPLACE TEMPORARY TABLE TEST (COL TEXT);
INSERT INTO TEST (COL) VALUES ('VARCHAR1'), ('VARCHAR2');
CREATE OR REPLACE TEMPORARY TABLE JOINED (COL TEXT, ANOTHER TEXT);
INSERT INTO JOINED (COL, ANOTHER) VALUES ('CHAR1', 'JOIN');
SELECTT.COL, SUBSTR(T.COL, 4) AS ALIAS, J.ANOTHERFROM TEST AS T LEFT JOIN JOINED AS J ON ALIAS =J.COL;
The text was updated successfully, but these errors were encountered:
MCVE in Snowflake:
Result:
MCVE in fakesnow:
Error:
Version:
FAKESNOW_DEBUG=1:
The text was updated successfully, but these errors were encountered: