title: Room error: no viable alternative at input?
body: <p>I am trying to update the table using @Query annotation of room library, below is my code ( In Dao interface ) : </p>
  
  <pre><code>@Query("UPDATE table_name SET table_name.col1 = :val1 WHERE table_name.col2 = :val2")
  void updateValue(long val1, long val2);
  </code></pre>
  
  <p>Complete error string as below : </p>
  
  <pre><code>Error:(11, 10) error: no viable alternative at input 'UPDATE table_name SET table_name.'
  </code></pre>
  
  <p>Here is entity class : </p>
  
  <pre><code>@Entity(tableName = "table_name")
  public class SampleTable {
  
      @PrimaryKey
      @ColumnInfo(name = "_id")
      private Long Id;
  
      @ColumnInfo(name = "col1")
      private Long column1;
  
      @ColumnInfo(name = "col2")
      private Long column2;
  
      public Long getId() {
          return Id;
      }
  
      public void setId(Long id) {
          Id = id;
      }
  
      public Long getColumn1() {
          return column1;
      }
  
      public void setColumn1(Long column1) {
          this.column1 = column1;
      }
  
      public Long getColumn2() {
          return column2;
      }
  
      public void setColumn2(Long column2) {
          this.column2 = column2;
      }
  }
  </code></pre>
  
  <p>What's wrong with my code ?</p>