Error running mysql_install_db on Solaris10 x86

2005-04-26 Thread Joshua Mendenhall
Description:
   Running mysql_install_db generates an error. As follows:
   bash-3.00# scripts/mysql_install_db --user=mysql
   Installing all prepared tables
   Illegal Instruction - core dumped
   Installation of system tables failed!
   Examine the logs in ./data for more information.
   You can also try to start the mysqld daemon with:
   ./bin/mysqld --skip-grant 
   You can use the command line tool
   ./bin/mysql to connect to the mysql
   database and look at the grant tables:
   shell ./bin/mysql -u root mysql
   mysql show tables
   Try 'mysqld --help' if you have problems with paths. Using --log
   gives you a log in ./data that may be helpful.
   The latest information about MySQL is available on the web at
   http://www.mysql.com
   Please consult the MySQL manual section: 'Problems running 
mysql_install_db',
   and the manual section that describes problems on your OS.
   Another information source is the MySQL email archive.
   Please check all of the above before mailing us!
   And if you do mail us, you MUST use the ./bin/mysqlbug script!
   bash-3.00#
How-To-Repeat:
   Install mysql-standard-5.0.4-beta or mysql-max-5.0.4-beta on Solaris 10
   x86 using the pkg.gz files and then run mysql_install_db.
Fix:

Submitter-Id:   
Originator:Super-User
Organization:

MySQL support: none
Synopsis:Error running mysql_install_db on Solaris10
Severity:critical
Priority:high
Category:mysql
Class:sw-bug
Release:mysql-5.0.4-beta-standard (MySQL Community Edition - 
Standard (GPL))

C compiler:
C++ compiler:
Environment:
  
System: SunOS Sol1 5.10 Generic i86pc i386 i86pc
Architecture: i86pc

Some paths:  /usr/bin/perl /usr/local/bin/make /opt/sfw/bin/gmake 
/opt/sfw/bin/gcc /usr/ucb/cc
GCC: Reading specs from /opt/sfw/lib/gcc/i386-pc-solaris2.10/3.4.2/specs
Configured with: ../gcc-3.4.2/configure --prefix=/opt/sfw 
--with-ld=/usr/ccs/bin/ld --with-gnu-as --with-as=/opt/sfw/bin/gas 
--enable-shared --disable-libgcj
Thread model: posix
gcc version 3.4.2
Compilation info: CC='cc'  CFLAGS='-xO3 -mt -fsimple=1 -ftrap=%none 
-nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native'  CXX='CC'  
CXXFLAGS='-xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all 
-xlibmil -xlibmopt -xtarget=native'  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx   1 root root   9 Feb 17 16:29 /lib/libc.so - 
libc.so.1
-rwxr-xr-x   1 root bin  1031152 Jan 23 02:18 /lib/libc.so.1
lrwxrwxrwx   1 root root  19 Feb 17 16:16 /usr/lib/libc.so 
- ../../lib/libc.so.1
lrwxrwxrwx   1 root root  19 Feb 17 16:16 /usr/lib/libc.so.1 
- ../../lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql' 
'--localstatedir=/usr/local/mysql/data' 
'--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community 
Edition - Standard (GPL)' '--with-extra-charsets=complex' 
'--with-server-suffix=-standard' '--enable-thread-safe-client' 
'--enable-local-infile' '--with-named-curses=-lcurses' 
'--disable-shared' '--with-big-tables' '--with-readline' 
'--with-embedded-server' '--with-archive-storage-engine' '--with-innodb' 
'CC=cc' 'CFLAGS=-xO3 -mt -fsimple=1 -ftrap=%none -nofstore 
-xbuiltin=%all -xlibmil -xlibmopt -xtarget=native' 'CXXFLAGS=-xO3 -mt 
-fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt 
-xtarget=native' 'CXX=CC'

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


LIMIT clause only works with hard-coded constants

2005-04-15 Thread Joshua Mendenhall
Is there any plans for this to be changed in a future release?
I would like to use a parameterized LIMIT clause in my
stored procedures, but this limitation of the LIMIT clause
makes that impossible.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]