# Database Writer Node Bug report

**URL:** <https://forum.knime.com/t/database-writer-node-bug-report/5779>\
**Category:** KNIME Analytics Platform\
**Created:** [February 22, 2017, 3:18pm UTC](https://forum.knime.com/t/database-writer-node-bug-report/5779 "2017-02-22T15:18:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![punctis](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/a3d4f5/32.png) [@punctis](https://forum.knime.com/u/punctis)\
**Post date:** [February 22, 2017, 3:18pm UTC](https://forum.knime.com/t/database-writer-node-bug-report/5779/1 "2017-02-22T15:18:44Z")

</div>

Hello Knime developers,

just wanted to report that the "Database Writer" node on knime fails to correctly write the SQL query when one of the columns is named "group". I already resolved by giving the column another name, but I think this is an internal bug of the node: it writes the query this way: INSERT INTO ('group) VALUES ('value'). The column name closing quote is missing, resulting in a SQL syntax error!

Best!

Andrea

---

<div class="post-metadata">

**Author:** ![tobias.koetter](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tobias.koetter/32/56844_2.png) [@tobias.koetter](https://forum.knime.com/u/tobias.koetter)\
**Post date:** [February 27, 2017, 10:38am UTC](https://forum.knime.com/t/database-writer-node-bug-report/5779/2 "2017-02-27T10:38:34Z")

</div>

Hello Andrea,

thanks for reporting this issue. The problem is that the current db implementation does not automatically quote db keywords such as group or table etc. Right now it only quotes column names with spaces e.g. "column 1". I have opened a ticket for this in order to have it fixed with one of the next releases.

Thanks

Tobias

---

<div class="post-metadata">

**Author:** ![lareooreal](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/53a042/32.png) [@lareooreal](https://forum.knime.com/u/lareooreal)\
**Post date:** [July 2, 2018, 12:35pm UTC](https://forum.knime.com/t/database-writer-node-bug-report/5779/3 "2018-07-02T12:35:52Z")

</div>

As of today the bug still persists. Any fix anytime soon ?

---

<div class="post-metadata">

**Author:** ![tobias.koetter](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tobias.koetter/32/56844_2.png) [@tobias.koetter](https://forum.knime.com/u/tobias.koetter)\
**Post date:** [July 2, 2018, 12:51pm UTC](https://forum.knime.com/t/database-writer-node-bug-report/5779/4 "2018-07-02T12:51:16Z")

</div>

Hi,  
with the next release we will provide a preview of the new DB framework which will fix this issue.  
Bye  
Tobias

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:22pm UTC](https://forum.knime.com/t/database-writer-node-bug-report/5779/5 "2023-06-23T20:22:22Z")

</div>


