我正在从mysql数据库中提取数据。mysql中的数据是float结构，但我在将它们加载到Dataframe时收到以下错误：“nas通过强制引入到integer range”
下面是mysql函数：

## 

## MySQL function

## 

library(RMySQL)
rozDB <- function(q,type) {
  mysql_conn <- dbConnect(
    MySQL(), 
    user="", 
    password="", 
    dbname="", 
    host="")

  if(type == "select") {
    query <- dbSendQuery(mysql_conn, q)
    result <- fetch(query, n = Inf)
    check <- dbHasCompleted(query)
  }

  if(type == "insert") {
    query <- dbSendQuery(mysql_conn, q)
    result <- "Complete"
  }

  dbClearResult(query)
  dbDisconnect(mysql_conn)

  return(result)
}

数据调用：

### 

### Build condition map and number of sessions

### 

conditions <- c()
query1 <- paste0("SELECT notebook_condition conditions, COUNT(notebook_condition) count FROM key_map GROUP BY notebook_condition;")
conditions <- rozDB(query1, "select")

### 

### Get 1 day of 1 condition

### 

selectedCondition <- conditions[3,]

for(i in 1:selectedCondition[1,2]){
  query3 <- paste0("SELECT kx,ky,kz FROM dataread3 WHERE `datetime` BETWEEN (SELECT `start_time` FROM key_map WHERE `cond` = '",selectedCondition[1,1],"' LIMIT ",i,",1) AND (SELECT `end_time` FROM key_map WHERE `cond` = '",selectedCondition[1,1],"' LIMIT ",i,",1);")
  print(query3)
  data <- rozDB(query3,"select")
}