[DRILL-1443] order by does not sort when select *

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.6.0
• Component/s: Functions - Drill
• Assignee: Chun Chang
• Reporter: Zhiyong Liu
• Created: 22/Sep/14 21:27
• Updated: 29/Apr/15 01:23
• Resolved: 01/Oct/14 23:32

Description

git.commit.id.abbrev=f8d38b6
git.commit.id=f8d38b64e6e19367da22f5e65fde01f050102296

0: jdbc:drill:schema=dfs.Tpch-Multi> select * from region;
---------------------------------

R_REGIONKEY

R_NAME

R_COMMENT

---------------------------------

2	[B@7c7d3eb3	[B@29f999f
3	[B@3c1e9711	[B@7c4ffbec
4	[B@4cfbc929	[B@2653ca3b
0	[B@530f5e8e	[B@1608e73c
1	[B@22851f71	[B@51d3456b

---------------------------------
5 rows selected (0.184 seconds)
0: jdbc:drill:schema=dfs.Tpch-Multi> select * from region order by R_REGIONKEY;
---------------------------------

R_REGIONKEY

R_NAME

R_COMMENT

---------------------------------

2	[B@1fb66e87	[B@2127155
3	[B@8ce8483	[B@2e5db8f9
4	[B@1862dd93	[B@2c0ea67
0	[B@475d119a	[B@2f2eba10
1	[B@10b9982b	[B@8b537a1

---------------------------------
5 rows selected (0.149 seconds)

Compare:

0: jdbc:drill:schema=dfs.Tpch-Multi> select R_REGIONKEY, R_NAME, R_COMMENT from region order by R_REGIONKEY;
---------------------------------

R_REGIONKEY

R_NAME

R_COMMENT

---------------------------------

0	[B@6dfbc89a	[B@2d2f2edf
1	[B@5e652b7b	[B@4409c8a7
2	[B@5e546ed6	[B@7938d3fb
3	[B@1e541ea	[B@724a6a9e
4	[B@352c11d	[B@2e04589f

---------------------------------
5 rows selected (0.167 seconds)