Re: [sqlite] unexpected effect of view nesting on type conversion

> 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. I don't know though when the change happened. Mark ___ sqlite-users mailing list

Re: [sqlite] unexpected effect of view nesting on type conversion

>I've run into a phenomenon I don't understand where view nesting affects >types. Give me a try: Form what I understand, views don't have their own types, so default affinity applies. 12.0 gets converted to 12 as an integer in v2 when the value gets picked from v1. Please someone correct me

[sqlite] unexpected effect of view nesting on type conversion

Hi, I've run into a phenomenon I don't understand where view nesting affects types. Seen in sqlite 3.7.6.3. The following is my attempt at a minimal case that produces this behavior. Here a real is unexpectedly converted to int. CREATE TABLE customer ( id INT, PRIMARY KEY (id) );