BI-12 query variant fails.

[glennga]

The following variant of BI-12 raises a runtime error (most likely due to the LEFT MATCH):

LET                                                                                    
    personMessages = (                                                                 
        FROM                                                                           
            GRAPH SNB.Native.SNBGraph                                                  
                (person:Person)                                                        
            LEFT MATCH                                                                 
                (person)<-[:HAS_CREATOR]-(message:Message)-[:REPLY_OF*]->(post:Message)
        WHERE                                                                          
            message.content IS NOT NULL AND                                            
            message.length < 60 AND                                                    
            message.creationDate > DATETIME("2012-07-09T00:00:00") AND                 
            post.language IN ["zh","ru","fr"] AND                                      
            post.isPost                                                                
        GROUP BY                                                                       
            person.id AS personId                                                      
        SELECT                                                                         
            personId          AS personId,                                             
            COUNT(message.id) AS messageCount                                          
    )                                                                                  
FROM                                                                                   
    personMessages pm                                                                  
GROUP BY                                                                               
    pm.messageCount                                                                    
SELECT                                                                                 
    pm.messageCount    AS messageCount,                                                
    COUNT(pm.personId) AS personCount                                                  
ORDER BY                                                                               
    personCount DESC,                                                                  
    messageCount DESC;                                                                 

The runtime error is given below. I suspect there might be some runtime misalignment issues, as sometimes we get an out-of-bounds error instead.

org.apache.hyracks.api.exceptions.HyracksDataException: ASX0002: Type mismatch: function boolean-inspector expects its 0 input parameter to be of type boolean, but the actual input type is tinyint
        at org.apache.hyracks.api.exceptions.HyracksDataException.create(HyracksDataException.java:70) ~[hyracks-api-0.3.9-SNAPSHOT.jar:0.3.9-SNAPSHOT]
        at org.apache.hyracks.api.util.ExceptionUtils.setNodeIds(ExceptionUtils.java:70) ~[hyracks-api-0.3.9-SNAPSHOT.jar:0.3.9-SNAPSHOT]
        at org.apache.hyracks.control.nc.Task.run(Task.java:398) ~[hyracks-control-nc-0.3.9-SNAPSHOT.jar:0.3.9-SNAPSHOT]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
        at java.lang.Thread.run(Thread.java:829) ~[?:?]

[glennga]

Running into this issue again with the following rewrite:

LET                                                                               
    personMessages = (                                                            
        FROM                                                                      
            SNB.Native.Persons p                                                  
            LEFT JOIN                                                             
                (                                                                 
                    FROM                                                          
                        GRAPH SNB.Native.SNBGraph                                 
                            (message:Message)-[:REPLY_OF*]->(post:Message)        
                    WHERE                                                         
                        message.content IS NOT NULL AND                           
                        message.length < 115 AND                                  
                        message.creationDate > DATETIME("2012-06-06T00:00:00") AND
                        post.language IN ["es","ta","pt"] AND                     
                        post.isPost                                               
                    SELECT                                                        
                        message.id,                                               
                        message.creatorId                                         
                ) postMessages ON postMessages.creatorId = p.id                   
        GROUP BY                                                                  
            p.id AS personId                                                      
        SELECT                                                                    
            personId               AS personId,                                   
            COUNT(postMessages.id) AS messageCount                                
    )                                                                             
FROM                                                                              
    personMessages pm                                                             
GROUP BY                                                                          
    pm.messageCount                                                               
SELECT                                                                            
    pm.messageCount    AS messageCount,                                           
    COUNT(pm.personId) AS personCount                                             
ORDER BY                                                                          
    personCount DESC,                                                             
    messageCount DESC;                                                            

I've narrowed down the cause to some race condition bug with PBJ.