joshuaulrich / joshuaulrich/quantmod
[R-Forge #111] db.fields bug in getSymbols.MySQL
Open
bug
- Dominant language
- R
- Stars
- 906
- Forks
- 233
- PR merge metrics
- No merged PRs in 30d
Description
Submitted by: Denis Kolodin
Assigned to: Nobody
[R-Forge link](http://r-forge.r-project.org/tracker/index.php?func=detail&aid=111&group_id=125&atid=544)
When I call getSymbols('MSFT',src='MySQL', db.fields = c('timestamp', 'open', 'high', 'low', 'close', 'volume', 'adjust')) it make query:
SELECT timestamp, open, high, low, close, volume, adjust FROM my_table ORDER BY (!)date(!);
I change code that generates query to:
query <- paste('SELECT ', paste(db.fields, collapse = ','),
' FROM ', Symbols[[i]], ' ORDER BY ', db.fields[1])
Maybe fix it in library?!
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.