S, Igor Tandetnik piše:
> Radovan Antloga<radovan.antl...@siol.net>  wrote:
>> create table test (a integer not null, b float not null);
>>
>> update test
>> set b = 0.0 / 0;
>>
>> you will get error: test.b may not be null
> Appears to be working as intended. Division by zero produces null, which 
> cannot be stored in test.b . What exactly seems to be the problem?

Oh I see sqlite allows division by zero but result
is null. Sorry I didn't expect it. Some other DB
gives division by zero error in this case.

But actually I like sqlite way more. I will fix some
of my sql-s to use this sqlite feature :-).
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to