[Rd] sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7703)

From: <david.whiting_at_ncl.ac.uk>
Date: Fri 25 Feb 2005 - 04:37:53 EST

Full_Name: David Whiting
Version: 2.1.0 Under development (unstable) OS: linux
Submission from: (NULL) (

I have just upgraded from a previous version (2.0.0?) and found some of my code that used okay to run now gives an error. The function being called is sqlSave(). I am pretty sure (but not 100% certain) that the data frame I am trying to save has not changed. I am 100% sure that the ODBC connection information for MySQL has not changed and I have not updated MySQL.

> sqlSave(lh, data, "survey")

Error in gsub(pattern, replacement, x, ignore.case, extended, fixed) :

        invalid regular expression '[^[:alnum]_]+'
> traceback()

4: gsub("[^[:alnum]_]+", "", colnames)
3: mangleColNames(names(colspecs))
2: sqltablecreate(tablename, colspecs = colspecs, keys = keys)
1: sqlSave(lh, data, "survey")

> str(data)
`data.frame': 192 obs. of 171 variables:
(I can send the whole structure if that will help)

> version

platform i686-pc-linux-gnu           
arch     i686                        
os       linux-gnu                   
system   i686, linux-gnu             
status   Under development (unstable)
major    2                           
minor    1.0                         
year     2005                        
month    02                          
day      24                          
language R                           


R-devel@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel Received on Fri Feb 25 03:47:33 2005

This archive was generated by hypermail 2.1.8 : Fri 18 Mar 2005 - 09:02:58 EST