title: Spring - unknown column in 'field list' ONLY when saving / POST (but read / GET works...)
body: <p>I have a problem with Spring I can't get over. I added many fields to classes and MySQL database, but this time I don't know what's happening.</p>
  
  <p>The problematic field is <code>score</code>. I can retrieve the resource by GET and the field is returned by API, but any modification like POST new one throws <code>MySQLSyntaxErrorException: Unknown column 'score' in 'field list'</code>.</p>
  
  <p>Here is my class:</p>
  
  <pre><code>@Entity
  @Table(name = "resources")
  @Audited
  @JsonPropertyOrder({"id"})
  public class Resource extends ResourceSupport implements Localizable {
      @Id
      @GeneratedValue(strategy = GenerationType.IDENTITY)
      private Long resourceId;
  
      // ... other fields ...
  
      private Double score; // &lt;== that's the one!
  
      public Double getScore() {
          return score;
      }
  
      public void setScore(Double score) {
          this.score = score;
      }
  
      // ... other getters and setters ...
  }
  </code></pre>
  
  <p>In my database I have a <code>score</code> field defined this way: </p>
  
  <pre><code>CREATE TABLE `resources`  ( (...) 'score' double NOT NULL (...) )
  </code></pre>
  
  <p>I really don't get how it is possible that the field name matches but I still get the exception. <strong>I went through all the similar threads on Stack</strong> (about 10), but none addresses this specific issue...</p>