FWIW, PostgreSQL 9.2.4 shows two rows, like sqlite 3.8.0.
On Wed, Aug 28, 2013 at 7:57 AM, Max Vlasov <max.vla...@gmail.com> wrote: > Hi, > > the following query (notice the space at the end of the 3rd string) > > Create table [TestTable] ([Title] TEXT); > INsert into TestTable (Title) VALUES ('simple text'); > INsert into TestTable (Title) VALUES ('simple text'); > INsert into TestTable (Title) VALUES ('simple text '); > select Trim(Title) as Title, Count(*) as Cnt FROM TestTable Group By Title; > > produces two results > > "simple text" "2" > "simple text" "1" > > while all previous versions I tried a single one > > "simple text" "3" > > Speaking about the correct way, seems like 3.8 is right (technically > the strings are different), but I just wonder why all this time this > seems like existed and never noticed. On the other side, mysql of a > some old version also showed a single result > > Max > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- As of next week, passwords will be entered in Morse code. Maranatha! <>< John McKown _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users