- 
                Notifications
    You must be signed in to change notification settings 
- Fork 1k
Closed
Description
e.g. ad hoc joins
require(data.table)
X = data.table(a=1:3,b=4:6,c=c("foo","bar","baz"))
X[.(5), on="b"]
# Error in bmerge(i, x, leftcols, rightcols, io, xo, roll, rollends, nomatch,  : 
#   Internal error. icols[0] is NAdesired output
X[.(b=5), on="b"]
#    a b   c
#1: 2 5 barand where one join column has the same name but not the other :
X = data.table(A=1:3,b=4:6,c=c("foo","bar","baz"))
Y = data.table(A=2:4, B=5:7)
X[Y, on=c("A",b="B")]
# Error in forderv(x, by = rightcols) : 
#   'by' value -2147483648 out of range [1,3]
X[Y, on=c(A="A",b="B")]
#    A b   c
#1: 2 5 bar
#2: 3 6 baz
#3: 4 7  NA