Querying ymail.messages don't work - no success at all with WHERE statements


I'm getting desperate. It seems that even the simplest WHERE statements fail for me. For example : select * from ymail.messages where mid='DUMMY_ID' returns all the messages. Come on, there is surely no message with mid : DUMMY_ID select * from ymail.messages where mid='2_0_0_1_3176_AK/tHkgAAVBPUYKC9AQw/S/dUSc' returns all messages (that id does exist).

In the end I'd like to query what messages has attachments, so I'm doing it like : select * from ymail.messages where messageInfo.flags.hasAttachment='1'

all messages returned, even those who has hasAttachment : 0

Please help, I've been trying since hours but can't get around this, this is so simple, so I might screw up some obvious thing, or there are veeery serious bugs in YQL.

0 Replies

Recent Posts

in YQL