-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Hello,
I am seeing a change in the results returned for a query in SQLIte 3.8.2
version. The query used to return expected results with 3.7.7 and when I
updated to 3.8.2, it changed the results.
Here is a test case:
CREATE TABLE test(name text, value text);
insert into test values ('first', 't');
insert into test values ('second', 'T');
Now execute the following query in 3.7.7 version:
select lower(value) as value from test group by value;
This returns:
t
Now execute the same query in 3.8.2 which returns
t
t
I can fix it by changing the query like to one the following:
select lower(value) as value1 from test group by value1;
select lower(value) as value from test group by lower(value);
But I am not sure if this is expected. Is this a bug or should I change
the query like the above?
- --
Cheers,
Navaneeth
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: GPGTools - https://gpgtools.org
iQEcBAEBCgAGBQJSzkR/AAoJEHFACYSL7h6kuXkIANSVtCIo01XqDZxN6hCrPEtB
rTUQ7/ah0Z2MexQnkrv7ejREIP7gkmHgmJuyFM1p4HkSNeuEUbOZR6yGuwU4Jbg7
pRKxKNMJieMl44nQRp9i+Spw7f2UkpVGMveJxFu0HgXWnwc0RyFiRshV1kjiV3DX
9YvJscjPfdUKx4lraVbKMwBKQI1iGrwb9dAvCbOntfWx2xYgfpuQbhmCLa5Qej3+
NuSkSvAW/Jm/UjVOE/vog6a42v3rvxlVERSST8fxtgcNEojCV9dzs71R+cfweEOp
6/OEjXbMfobCmvDwv5nOLtQ1Y7th3to/1o/Za48ZXIHjghwVVaqYF1GLwILy90c=
=UD2n
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
