Warning message when calling get_ids

[jasonO6359]

library(tidyverse)
library(taxadb)

lmb_itis <- get_ids("Micropterus salmoides",
                    provider = "itis", 
                    check_from = FALSE)
#> It looks like you tried to incorrectly use a table in a schema as source.
#> ℹ If you want to specify a schema use `in_schema()` or `in_catalog()`.
#> ℹ If your table actually contains "." in the name use `check_from = FALSE` to
#>   silence this message.
#> Joining with `by = join_by(scientificName)`

^{Created on 2024-02-29 with reprex v2.1.0}

Session info

sessionInfo()
#> R version 4.3.0 (2023-04-21 ucrt)
#> Platform: x86_64-w64-mingw32/x64 (64-bit)
#> Running under: Windows 10 x64 (build 19045)
#> 
#> Matrix products: default
#> 
#> 
#> locale:
#> [1] LC_COLLATE=English_United States.utf8 
#> [2] LC_CTYPE=English_United States.utf8   
#> [3] LC_MONETARY=English_United States.utf8
#> [4] LC_NUMERIC=C                          
#> [5] LC_TIME=English_United States.utf8    
#> 
#> time zone: America/New_York
#> tzcode source: internal
#> 
#> attached base packages:
#> [1] stats     graphics  grDevices utils     datasets  methods   base     
#> 
#> other attached packages:
#>  [1] taxadb_0.2.1    lubridate_1.9.3 forcats_1.0.0   stringr_1.5.1  
#>  [5] dplyr_1.1.4     purrr_1.0.2     readr_2.1.5     tidyr_1.3.1    
#>  [9] tibble_3.2.1    ggplot2_3.5.0   tidyverse_2.0.0
#> 
#> loaded via a namespace (and not attached):
#>  [1] styler_1.10.2     utf8_1.2.4        generics_0.1.3    stringi_1.8.3    
#>  [5] hms_1.1.3         digest_0.6.34     magrittr_2.0.3    evaluate_0.23    
#>  [9] grid_4.3.0        timechange_0.3.0  blob_1.2.4        contentid_0.0.18 
#> [13] fastmap_1.1.1     jsonlite_1.8.8    R.oo_1.26.0       R.cache_0.16.0   
#> [17] R.utils_2.12.3    DBI_1.2.2         httr_1.4.7        fansi_1.0.6      
#> [21] scales_1.3.0      duckdb_0.9.2-1    cli_3.6.2         rlang_1.1.3      
#> [25] dbplyr_2.4.0      R.methodsS3_1.8.2 munsell_0.5.0     reprex_2.1.0     
#> [29] cachem_1.0.8      withr_3.0.0       yaml_2.3.8        tools_4.3.0      
#> [33] tzdb_0.4.0        memoise_2.0.1     colorspace_2.1-0  curl_5.2.0       
#> [37] vctrs_0.6.5       R6_2.5.1          lifecycle_1.0.4   fs_1.6.3         
#> [41] pkgconfig_2.0.3   pillar_1.9.0      gtable_0.3.4      glue_1.7.0       
#> [45] xfun_0.42         tidyselect_1.2.0  rstudioapi_0.15.0 knitr_1.45       
#> [49] htmltools_0.5.7   rmarkdown_2.25    compiler_4.3.0    askpass_1.2.0    
#> [53] openssl_2.1.1

[jasonO6359]

Issue appears to be caused by call to dplyr::tbl(db, tbl_name) within the call to taxa_tbl(). Warning message is the result of tbl_name having a "." which is due to the database version number "22.12". Can be resolved by modifying to dplyr::tbl(db, tbl_name, check_from = FALSE)