[sqlalchemy] LIMIT function behavior

The limit() function behaves in a way that is possibly unexpected: If you ask sqlalchemy to query limit(3) where a join is involved, for example, and 2 of the top-3 are actually the same primary key, sqlalchemy gets the 3 results, throws out the duplicate and your query size ends up as 2. This

Re: [sqlalchemy] LIMIT function behavior

Kent wrote: The limit() function behaves in a way that is possibly unexpected: If you ask sqlalchemy to query limit(3) where a join is involved, for example, and 2 of the top-3 are actually the same primary key, sqlalchemy gets the 3 results, throws out the duplicate and your query size ends