On Wed, Nov 18, 2009 at 8:39 AM, Vasu Nori wrote:
>
>
> On Wed, Nov 18, 2009 at 4:06 AM, D. Richard Hipp wrote:
>
>>
>> On Nov 17, 2009, at 9:49 PM, D. Richard Hipp wrote:
>>
>> >
>> > On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote:
>> >>
>> >> sqlite> SELECT _id, typeof(_id) FROM feeds;
>> >> 1|i
On Wed, Nov 18, 2009 at 4:06 AM, D. Richard Hipp wrote:
>
> On Nov 17, 2009, at 9:49 PM, D. Richard Hipp wrote:
>
> >
> > On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote:
> >>
> >> sqlite> SELECT _id, typeof(_id) FROM feeds;
> >> 1|integer
> >> 2|integer
> >> 3|integer
> >> 4|integer
> >> 5|integer
On Nov 17, 2009, at 9:49 PM, D. Richard Hipp wrote:
>
> On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote:
>>
>> sqlite> SELECT _id, typeof(_id) FROM feeds;
>> 1|integer
>> 2|integer
>> 3|integer
>> 4|integer
>> 5|integer
>> 6|integer
>> 7|integer
>> 8|integer
>> 9|integer
>> 10|integer
>> 11|integer
attached.
thanks for your time.
On Tue, Nov 17, 2009 at 6:49 PM, D. Richard Hipp wrote:
>
> On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote:
> >
> > sqlite> SELECT _id, typeof(_id) FROM feeds;
> > 1|integer
> > 2|integer
> > 3|integer
> > 4|integer
> > 5|integer
> > 6|integer
> > 7|integer
> > 8|i
On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote:
>
> sqlite> SELECT _id, typeof(_id) FROM feeds;
> 1|integer
> 2|integer
> 3|integer
> 4|integer
> 5|integer
> 6|integer
> 7|integer
> 8|integer
> 9|integer
> 10|integer
> 11|integer
> 0|integer
> 13|integer
> 14|integer
Please email your database dir
> in one case you do:
> select count(*) from feeds where _id = '0';
> in the other you do:
> select count(*) from feeds where _id = 0; <--- note the missing quotes
> this shouldn't make a difference (since SQLite is typeless), but I wonder if
> it is in this case.
> what is the type of _id?
in one case you do:
select count(*) from feeds where _id = '0';
in the other you do:
select count(*) from feeds where _id = 0; <--- note the missing quotes
this shouldn't make a difference (since SQLite is typeless), but I wonder if
it is in this case.
what is the type of _id?
can you run t
if I vacuum it, database file sems to have correct data.
sqlite> vacuum
...> ;
sqlite> select count(*) from feeds where _id = '0';
count(*)
--
1
I can't tell if this is a bug in sqlite3 or if the database file is corrupt
but sqlite3 can't recognize it when I do "pragma integrity_check
On Nov 17, 2009, at 8:09 PM, Vasu Nori wrote:
>
> but can't select the row _id = 0
What does the following query show:
SELECT _id, typeof(_id) FROM feeds;
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
hi all
attached is a database file with a strange behavior.
it has a table "feeds". has the following data (just selected 2 columns for
discussion purpose)
sqlite> select _id, feed from feeds;
_id feed
--
-
10 matches
Mail list logo