hide kojima
hide kojima
This is related to #510, I changed cell format to text but still get the same result. 3B should show 132834.3 instead of 132834.29999999999. https://www.dropbox.com/s/9jdmatvz797p889/testdata10880-text.xlsx?dl=0 ``` r tmp ID Value...
Apologies for the belated update. Here is my result for `lubridate:::.get_locale_regs("Japanese_Japan.932")` on Windows. ``` r lubridate:::.get_locale_regs("Japanese_Japan.932") #> $alpha_flex #> b #> "((?1|2|3|4|5|6|7|8|9|10|11|12)|(?1月|2月|3月|4月|5月|6月|7月|8月|9月|10月|11月|12月))(?![[:alpha:]])" #> B #> "(?1月|2月|3月|4月|5月|6月|7月|8月|9月|10月|11月|12月)(?![[:alpha:]])" #> a #> "((?木|月|火|日|金|水|土)|(?木曜日|月曜日|火曜日|日曜日|金曜日|水曜日|土曜日))(?![[:alpha:]])"...
Directly querying from `information_schema.tables` works like below. ``` r Sys.setlocale(category="LC_CTYPE", locale="English_United States.932"); #> [1] "English_United States.932" # stringi::stri_enc_set("windows-932") conn 1 dbo Datetime2_Test #> 2 dbo フライト #> 3 dbo sysdiagrams...
Thank you for the update. So it seems this error happens when I try the relatively long SQL query but works ok for a short SQL query. Do you have...
``` r sessionInfo() #> R version 4.1.0 (2021-05-18) #> Platform: x86_64-w64-mingw32/x64 (64-bit) #> Running under: Windows 10 x64 (build 22000) #> #> Matrix products: default #> #> locale: #> [1]...
Apologies for the belated update. I installed the GitHub version but it still gives me up to 1000. ```r if(!require("remotes")){ install.packages("remotes") } remotes::install_github("cloudyr/googleCloudStorageR") > df nrow(df) [1] 1000 ```
I was testing with 1003 buckets like the below screenshots.
For both cases, it fetches up to 1000. ```r > df nrow(df) [1] 1000 > df nrow(df) [1] 1000 ```
```r > df Token exists. ℹ 2022-10-27 09:40:32 > Request: https://storage.googleapis.com/storage/v1/b/?project=exploratory-io&prefix=&projection=noAcl ℹ 2022-10-27 09:40:33 > No paging required ``` ```r > sessionInfo() R version 4.2.1 (2022-06-23) Platform: x86_64-apple-darwin17.0 (64-bit) Running...
``` r sessionInfo() #> R version 4.4.0 (2024-04-24 ucrt) #> Platform: x86_64-w64-mingw32/x64 #> Running under: Windows 11 x64 (build 22631) #> #> Matrix products: default #> #> #> locale: #>...