0

I'm trying to connect to trino and querying to delete rows and inserting rows for my Alteryx workflow. getting error after adding semicolon at the end of query which is a blocking currently the workflow. The same query works after removing semicolon. After adding semicolon getting error Removing semicolon works fine

I tried connecting to trino datasource using trino driver. example query DELETE FROM test_semicolon_pg without semicolon at end which works fine. but i expect the query should work fine even after adding adding semicolon at end of the query.

pooja
  • 1
  • 1
    This is NOT MySQL problem and not MySQL error message (in MySQL the error code 1060 matches SQL state *42S21* with error message *Duplicate column name '%s'*). So this is a problem detected by your software pre-parser. Maybe you use query execution method which does not support batches/multiqueries, and it assumes the semicolon presence like a delimiter between the statements in a batch? – Akina Aug 16 '23 at 08:23
  • Please provide enough code so others can better understand or reproduce the problem. – Nico Haase Aug 16 '23 at 17:46

0 Answers0