[IGNITE-14958] update SQL error "column is not compatible with index definition" after upgrading to 2.10.0

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Not A Bug
• Affects Version/s: 2.10
• Fix Version/s: 2.10
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Isaac Zhu
• Created: 22/Jun/21 03:15
• Updated: 12/Jul/21 02:00
• Resolved: 12/Jul/21 02:00

Description

We have an table "issues" which has columns:

       ID int, ASSINED_DATE timestamp, CATEGORY varchar

This table is created and inserted with data on 2.7.6 

 

After upgrading to 2.10.0, when I ran updating SQL:

update issue set category = 'A' where CATEGORY = 'B';

It errors: 

Error: Type for a column 'ASSIGNED_DATE' is not compatible with index definition. Expected 'Timestamp', actual type 'Date' (state=50000,code=1)

 

I tried drop the index of ASSIGNED_DATE, the updating SQL then works well.

But, If I recreate the index of the ASSIGNED_DATE, the updating SQL not working again.