Date: 2018-04-21 09:12:11 +0200
From: Guillaume de GENTILE <<gentile_g>>
To: SQL devs <>
Version: 11.29.7 (Mar2018-SP1)
CC: @PedroTadim

Last updated: 2019-04-30 12:36:01 +0200

Comment 26397

Date: 2018-04-21 09:12:11 +0200
From: Guillaume de GENTILE <<gentile_g>>

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36
Build Identifier:

Table aliasing are supported in SQL select queries:
select a.* from table123 a --> OK

but not in SQL update queries!
update table123 a set a.COL1=0 --> ERROR
update table123 set COL1=0 --> OK

Reproducible: Always

Steps to Reproduce:

1.create a dummy table table123
2.update table using a table alias in SQL query
3.update table123 a set a.COL1=0 --> ERROR

Actual Results:

update table123 not successful
An error occurred when executing the SQL command:
update table123 a set COL1=0

ParseException:SQLparser:!42000!syntax error, unexpected IDENT, expecting SET in: "update table123 a" [SQL State=M0M10]
1 statement failed.

Execution time: 0s

Expected Results:

We need to be able to define table aliasing in SQL update queries.
update table123 a set a.COL1=0

Comment 26705

Date: 2018-11-29 17:57:37 +0100
From: @PedroTadim

I implemented this feature in merge-statements branch of MonetDB and it should be available in a future release.