[sqlite] Group by in sqlite 3.8 works a little differently depending on the spaces at the end

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) a

Re: [sqlite] Group by in sqlite 3.8 works a little differently depending on the spaces at the end

FWIW, PostgreSQL 9.2.4 shows two rows, like sqlite 3.8.0. On Wed, Aug 28, 2013 at 7:57 AM, Max Vlasov 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'); > INse

Re: [sqlite] Group by in sqlite 3.8 works a little differently depending on the spaces at the end

On 8/28/2013 8:57 AM, Max Vlasov wrote: 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 (

Re: [sqlite] Group by in sqlite 3.8 works a little differently depending on the spaces at the end

On Wed, Aug 28, 2013 at 5:11 PM, Igor Tandetnik wrote: > On 8/28/2013 8:57 AM, Max Vlasov wrote: > See the recent discussion at > > http://comments.gmane.org/gmane.comp.db.sqlite.general/83005 > > It's not about trailing spaces, but about whether Title in GROUP BY resolves > to mean the table colu