Re: [sqlite] Type affinity changed by HAVING clause

I'd say this is definitely a bug. Especially keeping in mind that it's not affinity that changed it's actual datatype of returning value. It's interesting though that affinity for the value remains TEXT and comparison is performed as for text: sqlite> create table t1(a text, b int); sqlite>

[sqlite] Type affinity changed by HAVING clause

Hi, I think I may have found a bug where affinities change through the HAVING expression. For example, under v3.6.22, if I do... create table t1(a text, b int); insert into t1 values(123, 456); select typeof(a), a from t1 group by a having a