[TAJO-1620] random() in an SQL should generate RANDOM numbers

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.11.0
• Component/s: Function/UDF
• Assignee: Jongyoung Park
• Reporter: Youngkyong Ko
• Created: 22/May/15 09:46
• Updated: 25/May/15 14:23
• Resolved: 25/May/15 13:57

Description

random() function in projection list should generate different random numbers per each record. Currently it generates same numbers like below:

SELECT o_custkey, o_totalprice, random(10) as rand from orders limit 10;

o_custkey, o_totalprice, rand
-------------------------------
36901, 173665.47, 8
78002, 46929.18, 8
123314, 193846.25, 8
136777, 32151.78, 8
44485, 144659.2, 8
55624, 58749.59, 8
39136, 252004.18, 8
130057, 208660.75, 8
66958, 163243.98, 8
61001, 58949.67, 8
(10 rows, 1.195 sec, 178 B selected)