Code generation problem: using reserved word as column name

[alexanderfefelov]

DDL of my table is

CREATE TABLE `address_config` (
  `table_id` varchar(50) NOT NULL,
  `record_id` int(11) NOT NULL,
  `key` varchar(50) NOT NULL,
  `value` mediumtext NOT NULL,
  PRIMARY KEY (`table_id`,`record_id`,`key`)
)

Reversed code contains this fragment

object AddressConfig extends SQLSyntaxSupport[AddressConfig] {
  override val tableName = "address_config"
  override val columns = Seq("table_id", "record_id", "key", "value")

Generated SQL query

insert into address_config ( table_id, record_id, key, value ) values (...)

throws error You have an error in your SQL syntax.

Valid query may looks like

insert into address_config ( table_id, record_id, `key`, value ) values (...)

or

insert into address_config ( table_id, record_id, address_config.key, value ) values (...)

Environment:

• MySQL Server 5.7.25
• MySQL Connector/J 5.1.47
• scalikejdbc-mapper-generator 3.3.5

[seratch]

You can configure the code generator by changing this: https://github.com/scalikejdbc/scalikejdbc/blob/3.3.5/scalikejdbc-mapper-generator-core/src/main/scala/scalikejdbc/mapper/GeneratorConfig.scala#L18

[alexanderfefelov]

The problem is the key banned by SQL, not Scala.

columnNameToFieldName affects Scala code, not SQL.

[seratch]

Ah, you’re right