>> I've run into a phenomenon I don't understand where view nesting affects >> types. >> Seen in sqlite 3.7.6.3 > sqlite-3.6.23 does NOT show this behavior.
After further reflection, I am going to go out on a limb and suggest that the behavior described in the OP is a regression. The behavior started somewhere between versions 3.6.23 and 3.7.6.3. It can have serious consequences in the form of calculation errors. regards, Mark _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users