This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- there's 5 events in the range 2010-10-15 to 2010-10-21 | |
-- event1,event2,event3 and event4 have start_at in 2010-10-20 | |
-- and event5 is on 2010-10-21 | |
-- thats their tags: event1{tag1,tag2,tag3,tag4}, event2{tag1,tag2,tag3}, event3{tag1,tag2}, event4{tag1} | |
-- and event5 has only 'tag4'... so.. | |
-- the tag count in the range 2010-10-15 to 2010-10-21 should display count = 2 for tag4...but its ignoring | |
-- the 2010-10-21 day, what is wrong with this select? | |
-- event with id = 13 is the one with tag4 with the start_at thats being ignored(2010-10-21) | |
sqlite> select events.* from events where events.id = 13; |
NewerOlder