Advertisement
zamotivator

Untitled

Aug 11th, 2012
35
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. oleg (0) /storage/work/scidb/tests/harness$ cat testcases/r/checkin/simple-repart.expected
  2. SCIDB QUERY : <create array a <value:int32> [x=0:5,3,0]>
  3. Query was executed successfully
  4.  
  5. SCIDB QUERY : <create array b <value:int32> [x=0:5,2,0]>
  6. Query was executed successfully
  7.  
  8. SCIDB QUERY : <store(build(a, x), a)>
  9. [(0),(1),(2),(3),(4),(5)]
  10.  
  11. SCIDB QUERY : <explain_physical('store(repart(a,b), b)', 'afl')>
  12. [("[pPlan]:
  13. >[pNode] physicalStore agg 0 ddl 0 tile 0 children 1
  14. schema b<value:int32> [x=0:5,2,0]
  15. props sgm 1 sgo 1
  16. distr roro
  17. bound start {0} end {5} density 1 cells 6 chunks 3 est_bytes 222
  18. >>[pNode] impl_sg agg 0 ddl 0 tile 0 children 1
  19. schema b<value:int32> [x=0:5,2,0]
  20. props sgm 0 sgo 0
  21. distr roro
  22. bound start {0} end {5} density 1 cells 6 chunks 3 est_bytes 222
  23. >>>[pNode] physicalRepart agg 0 ddl 0 tile 0 children 1
  24. schema b<value:int32> [x=0:5,2,0]
  25. props sgm 1 sgo 1
  26. distr roro
  27. bound start {0} end {5} density 1 cells 6 chunks 3 est_bytes 222
  28. >>>>[pNode] physicalScan agg 0 ddl 0 tile 1 children 0
  29. schema a@1<value:int32> [xa=0:5,3,0]
  30. props sgm 1 sgo 1
  31. distr roro
  32. bound start {0} end {5} density 1 cells 6 chunks 2 est_bytes 206
  33. ")]
  34.  
  35. SCIDB QUERY : <store(repart(a,b), b)>
  36. [(0),(1),(2),(3),(4),(5)]
  37.  
  38. SCIDB QUERY : <remove(a)>
  39. Query was executed successfully
  40.  
  41. SCIDB QUERY : <remove(b)>
  42. Query was executed successfully
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement