[ARROW-14722] [R] dplyr::arrange converts number values to negative

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 6.0.0
• Fix Version/s: 7.0.0
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/30260
• Assignee: Will Jones
• Reporter: Will Jones
• Created: 16/Nov/21 14:11
• Updated: 11/Jan/23 08:41
• Resolved: 30/Nov/21 00:09

Description

```

# Load libraries
library(arrow)
library(dplyr)

# Store table
file_path <- tempfile()
write_parquet(dplyr::tibble(a = 1:10, b = "A"), file_path)

# Read table 
my_table <- read_parquet(file_path)

# Table looks normal
my_table
# A tibble: 10 x 2
#       a b    
#   <int> <chr>
# 1     1 A    
# 2     2 A    
# 3     3 A    
# 4     4 A    
# 5     5 A    
# 6     6 A    
# 7     7 A    
# 8     8 A    
# 9     9 A    
# 10    10 A  

# First arrange changes number values to negative
my_table %>% arrange(dplyr::desc(a)) 
# A tibble: 10 x 2
#       a b    
#   <int> <chr>
# 1   -10 A    
# 2    -9 A    
# 3    -8 A    
# 4    -7 A    
# 5    -6 A    
# 6    -5 A    
# 7    -4 A    
# 8    -3 A    
# 9    -2 A    
# 10   -1 A   

# Even underlying data is changed!!!
my_table
# A tibble: 10 x 2
#       a b    
#   <int> <chr>
# 1   -10 A    
# 2    -9 A    
# 3    -8 A    
# 4    -7 A    
# 5    -6 A    
# 6    -5 A    
# 7    -4 A    
# 8    -3 A    
# 9    -2 A    
# 10   -1 A   

# Second arrange changes it back
my_table %>% arrange(dplyr::desc(a)) 
my_table
# A tibble: 10 x 2
#       a b    
#   <int> <chr>
# 1     1 A    
# 2     2 A    
# 3     3 A    
# 4     4 A    
# 5     5 A    
# 6     6 A    
# 7     7 A    
# 8     8 A    
# 9     9 A    
# 10    10 A  

```

Issue Links

• links to: GitHub Pull Request #11727