Very interesting. seems to me like the view might be a bit corrupt then...
not sure...
I think Markus would know more about that
On Sun, Sep 18, 2011 at 11:09 PM, Michal Hruby
wrote:
> And concluding:
>
> SELECT subj_id, max(timestamp) AS timestamp
> FROM event_view
>WHERE (((subj_uri = 'a
And concluding:
SELECT subj_id, max(timestamp) AS timestamp
FROM event_view
WHERE (((subj_uri = 'application://gedit.desktop')
OR (subj_uri = 'application://devhelp.desktop')
OR (subj_uri = 'application://google-chrome.desktop') OR ...
GROUP BY subj_id;
executes in
And more research:
i just tried two queries in `sqlite3`
SELECT subj_id FROM event_view WHERE subj_uri IN
('application://gedit.desktop', 'application://firefox.desktop',
'application://devhelp.desktop', 'application://google-chrome.desktop',
'application://dfeet.desktop', 'http://twitter.com
As a note the result is pretty much still the same after seif's fix to
get rid of the "AND subj_current_uri = ..." part.
--
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
https://bugs.launchpad.net/bugs/844877
revno: 270
committer: Seif Lotfy
branch nick: bluebird
timestamp: Sun 2011-09-18 16:13:07 +0200
message:
remove faulty fixme notice
modified:
src/engine.vala
--
lp:~zeitgeist/zeitgeist/bluebird
https://code.launchpad.net/~zeitgeist
revno: 269
committer: Siegfried-Angel Gevatter Pujals
branch nick: bluebird
timestamp: Sun 2011-09-18 16:03:46 +0200
message:
Handle SIGINT properly.
modified:
src/zeitgeist-daemon.vala
--
lp:~zeitgeist/zeitgeist/bluebird
https://c
revno: 268
committer: Seif Lotfy
branch nick: bluebird
timestamp: Sun 2011-09-18 15:29:05 +0200
message:
added new extensions_conf table for extensions to store their data into
modified:
src/sql-schema.vala
--
lp:~zeitgeist/zeitgei
revno: 267
committer: Siegfried-Angel Gevatter Pujals
branch nick: bluebird
timestamp: Sun 2011-09-18 15:21:31 +0200
message:
exit -> Posix.exit
modified:
src/zeitgeist-daemon.vala
--
lp:~zeitgeist/zeitgeist/bluebird
https://code.l
revno: 266
committer: Siegfried-Angel Gevatter Pujals
branch nick: bluebird
timestamp: Sun 2011-09-18 15:18:23 +0200
message:
Add FIXME about --replace
modified:
src/zeitgeist-daemon.vala
--
lp:~zeitgeist/zeitgeist/bluebird
https:/
revno: 265
committer: Siegfried-Angel Gevatter Pujals
branch nick: bluebird
timestamp: Sun 2011-09-18 14:54:07 +0200
message:
Add test cases for events with multiple subjects and FindEvents (re DISTINCT)
modified:
src/engine.vala
t
revno: 264
committer: Siegfried-Angel Gevatter Pujals
branch nick: bluebird
timestamp: Sun 2011-09-18 14:22:59 +0200
message:
engine.vala: add comment about subject templates being AND'ed
modified:
src/engine.vala
--
lp:~zeitgeist/
revno: 263
committer: Siegfried-Angel Gevatter Pujals
branch nick: bluebird
timestamp: Sun 2011-09-18 14:10:22 +0200
message:
testFindTwoOfThreeEvents: move event declarations to a new three_events.js
added:
test/data/three_events.js
revno: 262
committer: Seif Lotfy
branch nick: bluebird
timestamp: Sun 2011-09-18 14:07:35 +0200
message:
prohibit the datamodel from assiging the current_uri if not set
modified:
src/datamodel.vala
--
lp:~zeitgeist/zeitgeist/bluebi
Ok, I've got another VERY bad one... See attachement
** Attachment added: "query.log"
https://bugs.launchpad.net/zeitgeist/+bug/844877/+attachment/2421293/+files/query.log
--
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitg
14 matches
Mail list logo