On 6/28/2016 4:52 PM, Simon Slavin wrote:
On 28 Jun 2016, at 11:22pm, Joe Pasquariello <j...@fenway.com> wrote:
select rowid, device, hex(device), localtime, udatetime
from eventlog where device like '%M14' and udatetime=1415000934
rowid device hex(device) localtime udatetime
18031 M14 4D3134 2014-11-03 01:48:54 1415000934
18062 M14 4D3134 2014-11-03 01:48:54 1415000934
(2)
select rowid, device, hex(device), udatetime
from eventlog where device like '%M14' and udatetime=1415000934
rowid device hex(device) udatetime
18062 M14 4D3134 1415000934
SELECT udatetime,typeof(udatetime),udatetime-1415000934 FROM eventlog where
device like '%M14' and udatetime=1415000934
udatetime typeof(udatetime) udatetime-1415000934
1415000934 integer 0
PRAGMA integrity_check
integrity_check
row 18029 missing from index sqlite_autoindex_EventLog_1
row 18030 missing from index sqlite_autoindex_EventLog_1
row 18031 missing from index sqlite_autoindex_EventLog_1
row 18032 missing from index sqlite_autoindex_EventLog_1
row 18033 missing from index sqlite_autoindex_EventLog_1
row 18034 missing from index sqlite_autoindex_EventLog_1
row 18035 missing from index sqlite_autoindex_EventLog_1
wrong # of entries in index sqlite_autoindex_EventLog_1
These are the duplicate records. This index is associated with a UNIQUE
constraint on the original table. Is there a way to clean it up?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Joe Pasquariello
Fenway Systems, LLC
2980 College Ave, Suite 7
Berkeley, CA 94705
510-665-4355
j...@fenway.com
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
