I have a SQL query that looks in part like this:
First_value(si.ip_addr)
within GROUP (ORDER BY si.source DESC) AS srcIp,
First_value(si.port)
within GROUP (ORDER BY si.source DESC) AS srcPort,
Last_value(si.ip_addr)
within GROUP (ORDER BY si.source DESC) AS destIp,
Last_value(si.port)
within GROUP (ORDER BY si.source DESC) AS destPort
Sometimes it returns the port values in the ip column and the ip values in the
port column. If I delete the group by and the first/last sections it seems to
work fine.
If I run the query with 2-7 cores it runs fine (1 and 8 fail).
The part about the number of cores effecting the bug makes me pretty sure it’s
a race condition (along with the fact that printing out values changes the bug
too). I’ve looked at the client code and haven’t seen anything obvious. And
it just occurred to me that I suppose it could be the server code too.
Has anyone else seen anything like this?
Version numbers:
sqlline version 1.1.8
4.7.0-clabs-phoenix1.3.0.14
—
Jon Strayer l Sr. Software Engineer
Proofpoint, Inc.
M: 317-440-7938
E: <mailto:[email protected]>
[email protected]<mailto:[email protected]>
[id:19D710FA-EA49-4073-88E9-CA6D6C2BD349]<http://www.proofpoint.com/>
threat protection l compliance l archiving & governance l secure communication
