[R] RMySQL's column limit

[Mark Van De Vyver]

Thanks for pointing that out.  I've run the "create table" uploaded
with that bug report and it fails for the same reason using MySQL
4.1.12 on linux and 5.0.18-nt
So this is not a limitation of RMySQL.
Regards
Mark

On 3/24/06, Jeffrey Horner <jeff.horner at vanderbilt.edu> wrote:
> Mark Van De Vyver wrote:
> > My apologies,
> >
> > I'm using R v2.2.1 via the JGR Editor GUI, RMySQL v0.5.7 under windows
> > XP with latest patches.
> >
> > MySQL is "server version: 4.1.12"
> > I'm pretty sure it's running on a linux box.
>
> It turns out that this may be a MySQL limit:
>
> http://bugs.mysql.com/bug.php?id=4117
>
> >
> > The dimension of template is >2000, I know the error kicks in at 3000,
> > but haven't iterated to find the exact point - if it would help I can
> > do this.
> >
> > Regards
> > Mark
> >
> > On 3/24/06, David James <dj at research.bell-labs.com> wrote:
> >> Hi,
> >>
> >> Mark Van De Vyver wrote:
> >>> Dear R-users,
> >>> First, thank you to the developers for the very useful R-library RMySQL.
> >>>
> >>> While using this library a recieved an error message:
> >>>
> >>> RS-DBI driver: (could not run statement: Too many columns)
> >>>
> >>> The statement that generated the error was:
> >>>
> >>> dbWriteTable(dbcon, "simdataseries", template, overwrite = TRUE,
> >>> row.names = FALSE )
> >>>
> >>> I am assuming this is a RMySQL rather than MySQL limit.
> >> We need more information, e.g., what's dim(template), what version
> >> of MySQL you're using, etc.
> >>
> >>> If that is the case I was wondering just what this limit is and if it
> >>> is possible to raise it?
> >>>
> >>> Thanks again for all the hard work.
> >>>
> >>> Sincerely
> >>> Mark
> >>>
> >>> --
> >>> Mark Van De Vyver, PhD
> >>> --------------------------------------------------
> >>> My research is available from my SSRN Author page:
> >>> http://ssrn.com/author=36577
> >>> --------------------------------------------------
> >>> Finance Discipline
> >>> School of Business
> >>> The University of Sydney
> >>> Sydney NSW 2006
> >>> Australia
> >>>
> >>> Telephone: +61 2 9351-6452
> >>> Fax: +61 2 9351-6461
> >>>
> >>>
> >>> --
> >>> Mark Van De Vyver, PhD
> >>> --------------------------------------------------
> >>> My research is available from my SSRN Author page:
> >>> http://ssrn.com/author=36577
> >>> --------------------------------------------------
> >>> Finance Discipline
> >>> School of Business
> >>> The University of Sydney
> >>> Sydney NSW 2006
> >>> Australia
> >>>
> >>> Telephone: +61 2 9351-6452
> >>> Fax: +61 2 9351-6461
> >>>
> >>> ______________________________________________
> >>> R-help at stat.math.ethz.ch mailing list
> >>> https://stat.ethz.ch/mailman/listinfo/r-help
> >>> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> >> --
> >> David
> >>
> >
> >
> > --
> > Mark Van De Vyver, PhD
> > --------------------------------------------------
> > My research is available from my SSRN Author page:
> > http://ssrn.com/author=36577
> > --------------------------------------------------
> > Finance Discipline
> > School of Business
> > The University of Sydney
> > Sydney NSW 2006
> > Australia
> >
> > Telephone: +61 2 9351-6452
> > Fax: +61 2 9351-6461
> >
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>
> --
> Jeffrey Horner       Computer Systems Analyst         School of Medicine
> 615-322-8606         Department of Biostatistics   Vanderbilt University
>


--
Mark Van De Vyver, PhD
--------------------------------------------------
My research is available from my SSRN Author page:
http://ssrn.com/author=36577
--------------------------------------------------
Finance Discipline
School of Business
The University of Sydney
Sydney NSW 2006
Australia

Telephone: +61 2 9351-6452
Fax: +61 2 9351-6461