Re: [sqlite3-ruby] Magic Users in Select Queries Bug?

[Luis Lavena]

Hello,

Please show us code that recreates the issue.

Your analysis of what is going on and what is wrong doesn't help us to
determine a possible bug in sqlite3-ruby, only points a possible bug
in your code.

On Thu, Mar 7, 2013 at 2:12 PM, Nick Prokesch <npro...@gmail.com> wrote:
> Hello,
>
> I've been having a strange bug in my ruby app. My app basically tracks how
> many times a user has been visited.
> I use a select statement to query my sqlite database for users that have a
> visit count of 0. For some reason, the query always returns a certain
> selection of users who have counts of over 0, sometimes as high as 40. It's
> always the same users, aka the same db fields. When I delete them from the
> db, close the db & close the app, and re-open it, the rows are recreated on
> their own (I think with different rowid) and crash the party in my select
> queries.
>
> I am stumped. Is this an easy fix, a dumb mistake on my end, or a legitimate
> bug? None of my ruby savvy friends have heard of such a thing happening.
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlite3-ruby" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlite3-ruby...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>



--
Luis Lavena
AREA 17
-
Perfection in design is achieved not when there is nothing more to add,
but rather when there is nothing more to take away.
Antoine de Saint-Exupéry

[Nick Prokesch]

Well, it looks like my problem was that I wasn't completing transactions properly, and not closing the db at all. 

Sorry for pointing fingers. Thanks for the prompt response.

[Nick Prokesch]

Update: this wasn't even database related. Sorry again. 

Thank you so much for making my Ruby database experience so much better. The work you do is much appreciated and makes a big difference in my life.