[sqlite] Problem with cast(xx as YY)

[zhangzhenggui]

Dear Friend,

    My sqlite version is 3.6.21. I find that, the behavior of cast(XX as YY) 
is not the same as other DBMS, such as SQL Server, MYSQL.
    
    This is my test:
     create table t(f1);
     insert into t values('1');
     
     select * from t where cast(f1 as int) = 1 and f1 = '1';     
     select * from t where f1 = '1' and cast(f1 as int) = 1;
     
     The results of ths two 'select' are different. The first 'select' gets 
nothing and the second 'select' gets one record. 
     The value of f1 is changed to int type after call cast(f1 as int). 
     The behavior of cast(XX as YY) is not the same as the old version, such 
as 3.3.4, and also different to SQL Server or  MYSQL.
     
     Is this a bug? or a characteristic of sqlite?
     
     I hope for your response, thanks.
     Thanks a again.
     
     
Thanks
zhangzhenggui


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users