Comments (5)
Hi @jimmyg3g, thanks for reporting this!
This error was happening because of a problem in the queryparser package, which tidyquery depends on, and which I also maintain.
I believe I have now resolved this in the development version of queryparser on GitHub.
I have also made a change to queryparser that silences the numerous truncating string with embedded nuls
warnings.
Please reinstall the development version of queryparser from GitHub and let me know if it works for you:
remotes::install_github("ianmcook/queryparser")
from tidyquery.
Yes, it works for me, thanks!
from tidyquery.
The third example on this reprex is throwing an error:
library(tidyverse)
library(tidyquery)
mtcars_tibble <- mtcars %>% rownames_to_column(var = 'brand and model') %>%
as_tibble()
query('SELECT mt.`brand and model` FROM mtcars_tibble as mt LIMIT 1')
#> # A tibble: 1 x 1
#> `brand and model`
#> <chr>
#> 1 Mazda RX4
query("SELECT SUBSTRING_INDEX(`brand and model`, ' ', 1) as brand from mtcars_tibble LIMIT 1")
#> # A tibble: 1 x 1
#> brand
#> <chr>
#> 1 Mazda
query("SELECT SUBSTRING_INDEX(mt.`brand and model`, ' ', 1) as brand from mtcars_tibble as mt LIMIT 1")
#> Error in str2lang(expr_out): <text>:1:20: unexpected symbol
#> 1: SUBSTRING_INDEX(mt.`brand and model`
#> ^
Created on 2020-08-18 by the reprex package (v0.3.0.9001)
from tidyquery.
Oops, didn't catch that case. I just fixed it. The version of queryparser on GitHub should solve this for you.
from tidyquery.
That did the trick, thanks!
from tidyquery.
Related Issues (20)
- Support disk.frame objects HOT 9
- Support data.table objects through dtplyr HOT 2
- Support SQL-92-style join queries
- Add function show_dplyr() HOT 4
- Simplify dplyr code where possible HOT 1
- Improve support for outer join queries HOT 1
- Add support for cross joins HOT 4
- query() fails when FROM clause refers to object in non-global calling environment
- Add substring_index() function HOT 2
- Support for Subqueries and OVER clauses HOT 1
- Support Arrow Table, RecordBatch, and Dataset objects HOT 1
- Failing test with next version of dtplyr HOT 9
- Do not truncate function arguments in output of `show_dplyr()` HOT 3
- Allow `namespace::object` in `FROM` clause
- Export version number for queryparser HOT 1
- dplyr 1.0.8, rlang 1.0.0 HOT 2
- Cross join not working . HOT 1
- Migrate CI to GitHub Actions HOT 1
- Use new dplyr `join_by()` syntax to represent join conditions HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tidyquery.