SimpleJdbcInsert doesn't support "keyword" column [SPR-17097]

[spring-projects-issues]

lmtoo opened SPR-17097 and commented

I have a table, defined as follows:

create table im.t_process_instance_attributescreate table im.t_process_instance_attributes( ownerId int default '0' not null, `key` varchar(50) default '' not null, value varchar(200) null, primary key (ownerId, `key`));

While SimpleJdbcInsert generated insert sql is:

INSERT INTO t_process_instance_attributes (ownerId, key, value) VALUES(?, ?, ?)

 
Key column doesn't have escape symbol, and BadSqlGrammarException is thrown.

---

No further details from SPR-17097

[leolee192]

Duplicate of #13874

[sbrannen]

@ledoyen, thanks for pointing that out.

Closing this issue as a duplicate of #13874.

[ledoyen]

@sbrannen

I think you wanted to mention @leolee192 😉

[sbrannen]

Indeed. Sorry about the noise. I'll just blame that on auto-correct.