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
You have an error in your SQL syntax: MERGE INTO agents a USING (SELECT * FROM agents WHERE commission > 0.15) cd ON (a.agent_code = cd.agent_code) WHEN MATCHED THEN UPDATE SET agent_code = cd.agent_code WHEN NOT MATCHED THEN INSERT (agent_code) VALUES (cd.agent_code) no viable alternative at input 'MERGE' at line 1 position 1 near @01:5='MERGE'<340>1:1
The text was updated successfully, but these errors were encountered:
class org.apache.shardingsphere.sql.parser.sql.common.segment.generic.AliasSegment cannot be cast to class org.apache.shardingsphere.sql.parser.sql.common.segment.generic.table.TableSegment (org.apache.shardingsphere.sql.parser.sql.common.segment.generic.AliasSegment and org.apache.shardingsphere.sql.parser.sql.common.segment.generic.table.TableSegment are in unnamed module of loader 'app')
You have an error in your SQL syntax: MERGE INTO agents a USING (SELECT * FROM agents WHERE commission > 0.15) cd ON (a.agent_code = cd.agent_code) WHEN MATCHED THEN UPDATE SET agent_code = cd.agent_code WHEN NOT MATCHED THEN INSERT (agent_code) VALUES (cd.agent_code) no viable alternative at input 'MERGE' at line 1 position 1 near @01:5='MERGE'<340>1:1
The text was updated successfully, but these errors were encountered: