SQLite使用!=条件不生效问题

 异常sql

select * from
    (select * from column_info where BACKUP_ID=39) t1
        left join (select * from column_info where BACKUP_ID=41) t2 on t1.TABLE_NAME=t2.TABLE_NAME
        and t1.COLUMN_NAME=t2.COLUMN_NAME
        where t1.COLUMN_ID is not null
        and (t1.DATA_TYPE!=t2.DATA_TYPE
        or t1.DATA_LENGTH!=t2.DATA_LENGTH
        or t1.DATA_DEFAULT!=t2.DATA_DEFAULT
        or t1.DATA_PRECISION!=t2.DATA_PRECISION
        or t1.DATA_SCALE!=t2.DATA_SCALE);

修改后

select * from
    (select * from column_info where BACKUP_ID=39) t1
        left join (select * from column_info where BACKUP_ID=41) t2 on t1.TABLE_NAME=t2.TABLE_NAME
        and t1.COLUMN_NAME=t2.COLUMN_NAME
        where t1.COLUMN_ID is not null
        and (t1.DATA_TYPE is not t2.DATA_TYPE
        or t1.DATA_LENGTH is not t2.DATA_LENGTH
        or t1.DATA_DEFAULT is not t2.DATA_DEFAULT
        or t1.DATA_PRECISION is not t2.DATA_PRECISION
        or t1.DATA_SCALE is not t2.DATA_SCALE);

解决方法将!=替换成"is not"