topic Truncate with a where clause should throw syntax error in SQL builder talend 6.5 in Talend Studio

Truncate with a where clause should throw syntax error in SQL builder talend 6.5

Anonymous — Sat, 16 Nov 2024 03:10:31 GMT

Hi,

In Talend 6.5 SQL builder (tredshiftrow component), I ran a query with Truncate and where clause which is ideally a syntax error but the SQL builder doesn't throw any error or exception.

How to identify this as an syntax error and capture it in Talend. Could you please suggest ?

We have alternatives to use delete with where clause however would like to know if we can capture such errors in Talend SQL builder.

Thanks,

Sankeerthana

Re: Truncate with a where clause should throw syntax error in SQL builder talend 6.5

Anonymous — Wed, 26 Feb 2020 09:53:52 GMT

It should pop-up a window and shows the syntax error if you click the Test button.
Can you show an example of query you are testing?

Re: Truncate with a where clause should throw syntax error in SQL builder talend 6.5

Anonymous — Wed, 26 Feb 2020 20:48:07 GMT

Thanks for the reply.

I am using the below query in sql builder of talend (for tredshiftrow component)

Truncate <table> where <column>=<value>.

and was expecting a syntax error.

Please find the screenshots for the one where it is working and not working.

Example 1 : Truncate <table> where <column>=<value> ( we don't have column b and also where cannot be used) - doesn't work and talend sql builder is not throwing any error or dialog box

Example 2: Truncate <table> - works

Could you please assist and confirm if its not working or any other process to validate this exception.

Thanks

syntax error throws in a dialog box.PNG
truncate with where doesnt throw error.PNG
working.PNG
working_row_Deleted.PNG