Re: confused...

[Hugh Sasse]

On Tue, 21 Feb 2006, Patrick Duda wrote:

 Why, when I create a table as follows:
 
 mysql create table requestid ( request_id int not null default 1,
 constraint requestid_innodb_pk_cons primary key(request_id) ) ENGINE=InnoDB;
 Query OK, 0 rows affected (0.02 sec)

Defines the properties of an empty table

The request id field for an inserted object will default to one if not
supplied.  But the object must be supplied.

Hugh

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

mysql driving make.

[Hugh Sasse]

I have a database backed-website in development.  (It's Rails based,
but for this question it probably doesn't matter.)  To make sure
things are clean during development I re-generate things from a
script.  Some things I generate depend on tables existing.  Other
things depend on tables being populated with data.   And my testing
depends on the web application having been created as well as the 
tables populated.

Clearly the above dependency graph is asking for a Makefile.  So how
do I check the table dependencies from make?   Searching for mysql
and make mostly turns up building instructions, of course, so it's
tricky to find the answer to this.

This is with Mysql 4.1.x, cygwin and Solaris.

Thank you
Hugh

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

Re: How to Square a number?

[Hugh Sasse]

On Sun, 18 Dec 2005, mos wrote:

 How do I square a number in MySQL 4.1? I thought it would be something simple
 like:
 
 select 3**2
 
 but that produces a syntax error. I can use Pow(3,2) but that produces a
 float. Is there a Square function? TIA

mysql select floor(pow(3,2));
+-+
| floor(pow(3,2)) |
+-+
|   9 |
+-+
1 row in set (0.00 sec)

You might also need round instead of floor depending on whether
the result of pow falls on the low side of the correct result.

 
 Mike

I'm disappointed by the responses that failed to recognise this as
the simplest specification for a more complicated case.

Hugh

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

Re: differenced backup from sql dumps

[Hugh Sasse]

On Mon, 14 Nov 2005, [EMAIL PROTECTED] wrote:

 We are making whole database sql dump every night.
 Now I have a bunch of sql dumps, that covers much space.
 Is there opensource tools with whom I  could make one 
 smaller differencial backup file with possibility to 
 get dump from every signle day?

SCCS, RCS, cvs, svn.  All of these use differential systems for
archiving versions of a file.  I've links to information at

http://www.eng.cse.dmu.ac.uk/~hgs/#RCS

if that's any help.
 
 Any ideas?:)
 
 Thankyou!
 Aktvists
 
Hugh

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

MySQL 4.1.13 lint?

[Hugh Sasse]

I'm fairly new to MySQL and am getting an error messages like:

ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for
the right syntax to use near 'id int(14) unsigned NOT NULL auto_increment,
forename varchar(40) NOT NU' at line 2
neelix hgs 18 % 

So it doesn't tell me exactly where, or what the nature of the
syntax error is (and it can't even tell me it is version 4.1.13
which I know already).  It has truncated the second line, so it's not
that the rest is missing.  My editor's syntax highlighter doesn't
show anything awful.  This is actually for lines 7 and 8 of the
input, the first 4 lines being comments, so the numbering in the
output is wrong.

Are there any tools (like lint for C) to be more verbose and helpful
about this?  

Thank you,
Hugh


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

Re: MySQL 4.1.13 lint?

[Hugh Sasse]

On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:

 Hugh Sasse [EMAIL PROTECTED] wrote on 13/10/2005 16:27:44:
 
  I'm fairly new to MySQL and am getting an error messages like:
  
  ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
  check the manual that corresponds to your MySQL server version for
  the right syntax to use near 'id int(14) unsigned NOT NULL 
 auto_increment,
  forename varchar(40) NOT NU' at line 2
  neelix hgs 18 % 
  
[...]
  
  Are there any tools (like lint for C) to be more verbose and helpful
  about this? 
 
 No, I don;'t think there are any such tools.
 
 When you get this sort of message, the error is nearly always *just 
 before* the quoted bit. Which means that you have to get hold of the full 

That's the first line of a  create Table:

CREATE TABLE IF NOT EXISTS students(

id int(14) unsigned NOT NULL auto_increment,
forename varchar(40) NOT NULL default '',
surname varchar(40) NOT NULL default '',
[...]


 command line that you sent and find out what immediately preceded the 
 characters it has given as an error. 

It would be helpful if it could spit out expected %s, which would
give some more clues  I know that parsers are difficult to get
right, however
 
 Alec
 

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

Re: MySQL 4.1.13 lint?

[Hugh Sasse]

On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:

 
 MySQL does not normally use  (double quotes) as name identifiers, it 
 uses ` `(backticks). Change all of your  to ` to make your syntax 
 correct. That would mean that part of your original statement will look 
 like

Thank you.
 
 In this case line 2 did not refer to the position in the script but to 

but line 5 was at least line 7 in the script, and at most line 4 in
the statement.
 the line within the statement. Your line 1 was something like
 
 CREATE TABLE sometablename (
 
 which made your first column definition (the id column) appear on line 2. 
 Make better sense?

Yes. Thank you.
 
 For more details on ` vs.   please read 
 http://dev.mysql.com/doc/refman/4.1/en/legal-names.html
 
Thank you, I'm off there now.
Hugh

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

Re: MySQL 4.1.13 lint?

[Hugh Sasse]

On Thu, 13 Oct 2005, Peter Brawley wrote:

 Hugh,
 
 Agreed that the MySQL error reporter is primitive, and that 'lint for MySQL'

If I were familiar with the code base I'd happy send patches, but I
was hoping improve diagnostics  might get nudged up somebody's
list by raising it.

 would be a smash hit, but if you look up error 1064 you'll find it is a naming

The first several results returned by google are no help.

 error, two of which are visible in your error report--column names enclosed in
 double quotes.

I'll probably need to talk to the maintainers of the vim syntax file
then, as well, because though that's a MySQL 3 syntax file I expect
it was still wrong.  Imho it should show white on red as a result,
not red on black (string).
 
 PB
 http://www.artfulsoftware.com

Thank you,
Hugh

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

Re: Failure to install on Solaris.

[Hugh Sasse]

On Tue, 20 Sep 2005, Dan Nelson wrote:


In the last episode (Sep 20), Hugh Sasse said:

So I started again and built using this script:
#!/bin/bash
CFLAGS=-O3 -L$LD_LIBRARY_PATH CXX=gcc MAKE=gmake \
 CXXFLAGS=-O3 -L$LD_LIBRARY_PATH -felide-constructors -fno-exceptions
 -fno-rtti ./configure \
 --prefix=/usr/local/mysql --enable-assembler \
 --enable-thread-safe-client \
 --with-mysqld-ldflags=-all-static --with-tcp-port=3308 \
 --with-unix-socket-path=/tmp/mysql4.sock \
 --with-pthread --with-gnu-ld  \
 gmake  \
 cd mysql-test  ./mysql-test-run --force
 exit


Get rid of the --with-mysqld-ldflags=-all-static flag; Solaris 9
doesn't provide a static pthread, and in Solaris 10, you can't build
static binaries at all:

http://partneradvantage.sun.com/protected/solaris10/adoptionkit/tech/proc.html
http://blogs.sun.com/roller/page/rie/?anchor=static_linking_where_did_it


Thank you. This worked.  I'd like to propose the following patch
against 4.1.13:


neelix hgs 96 % gdiff -u INSTALL-SOURCE INSTALL-SOURCE.new
--- INSTALL-SOURCE  2005-07-15 11:42:14.0 +0100
+++ INSTALL-SOURCE.new  2005-09-21 10:40:23.848026000 +0100
@@ -60,12 +60,16 @@
 `-fno-rtti' along with`-fno-exceptions'. When in doubt, do the
 following:

- CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors \
--fno-exceptions -fno-rtti ./configure \
+ CFLAGS=-O3
+ CXX=gcc
+ CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti
+ export CFLAGS CXX CXXFLAGS
+ ./configure \
 --prefix=/usr/local/mysql --enable-assembler \
 --with-mysqld-ldflags=-all-static

-On most systems, this gives you a fast and stable binary.
+On most systems, this gives you a fast and stable binary, but avoid
+--with-mysqld-ldflags=-all-static  on Solaris 2.9 and above.

 If you run into problems, _please always use`mysqlbug'_ when
 posting questions to aMySQL mailing list. Even if the problem isn't
neelix hgs 97 %

This is mainly because the variables need to be exported for
recursive make to work correctly, from what I saw.


--
Dan Nelson
[EMAIL PROTECTED]


Thank you,
Hugh


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

Failure to install on Solaris.

[Hugh Sasse]

On solaris 9 Sparc I built originally by modifying
mysql-4.1.14/BUILD/compile-solaris-sparc thusly

neelix hgs 81 % display_diffs.rb .
--- ./compile-solaris-sparc.orig2005-08-17 18:06:41.0 +0100
+++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100
@@ -11,6 +11,6 @@
 (cd gemini  aclocal  autoheader  aclocal  automake  autoconf)
  fi

-CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts 
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused  -O3 -fno-omit-frame-pointer 
-mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch 
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor 
-felide-constructors -fno-exceptions -fno-rtti  -O3 -fno-omit-frame-pointer -mcpu=v8 
-Wa,-xarch=v8plusa -g ./configure --prefix=/usr/local/mysql --enable-assembler 
--with-extra-charsets=complex --enable-thread-safe-client
+CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts 
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused  -O3 -fno-omit-frame-pointer 
-mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch 
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor 
-felide-constructors -fno-exceptions -fno-rtti  -O3 -fno-omit-frame-pointer -mcpu=v8 
-Wa,-xarch=v8plusa -g ./configure --prefix=/usr/local/mysql --enable-assembler 
--with-extra-charsets=complex --enable-thread-safe-client --with-tcp-port=3308 
--with-unix-socket-path=/tmp/mysql4.sock --prefix=/usr/local/mysql-4.1.14

  gmake -j 4
neelix hgs 82 %
and I invoked the script directly, and also tried with bash.
I have:

GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.9

gcc (GCC) 3.4.3


This got as far as the test phase, and tested successfully.  I did
it this way because of the solaris settings being collected
together.  However, when I installed, parts of the installation
overwrote /usr/local/mysql despite my --prefix.  I already have a
mysql setup there that I didn't want disturbed.

So I started again and built using this script:
#!/bin/bash
CFLAGS=-O3 -L$LD_LIBRARY_PATH CXX=gcc MAKE=gmake \
 CXXFLAGS=-O3 -L$LD_LIBRARY_PATH -felide-constructors -fno-exceptions 
-fno-rtti ./configure \
 --prefix=/usr/local/mysql --enable-assembler \
 --enable-thread-safe-client \
 --with-mysqld-ldflags=-all-static --with-tcp-port=3308 \
 --with-unix-socket-path=/tmp/mysql4.sock \
 --with-pthread --with-gnu-ld  \
 gmake  \
 cd mysql-test  ./mysql-test-run --force
 exit

My LD_LIBRARY_PATH is

/progs/SUNWspro/lib:/usr/local/lib:/usr/local/lib/sparcv9:/usr/lib:/usr/share/lib:/usr/dt/lib:/usr/openwin/lib:/opt/panorama/lib:/opt/sfw/lib

This blows up with:

gmake[4]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql/share'
gmake[4]: Entering directory `/scratch/hgs/mysql-4.1.13/sql'
/bin/bash ../libtool --preserve-dup-deps --mode=link gcc  -O3 -DDBUG_OFF -O3 
-L/progs/SUNWspro/lib:/usr/local/lib:/usr/local/lib/sparcv9:/usr/lib:/usr/share/lib:/usr/dt/lib:/usr/openwin/lib:/opt/panorama/lib:/opt/sfw/lib
 -felide-constructors -fno-exceptions -fno-rtti   -fno-implicit-templates 
-fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DDEFINE_CXA_PURE_VIRTUAL 
-D_FILE_OFFSET_BITS=64 -DHAVE_RWLOCK_T   -o mysql_tzinfo_to_sql  
mysql_tzinfo_to_sql.o -all-static ../myisam/libmyisam.a 
../myisammrg/libmyisammrg.a ../heap/libheap.a ../vio/libvio.a 
../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a 
../strings/libmystrings.a -lz   -lpthread -lposix4 -lcrypt -lgen -lsocket -lnsl 
-lm  -lpthread
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti 
-fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW 
-DDEFINE_CXA_PURE_VIRTUAL -D_FILE_OFFSET_BITS=64 -DHAVE_RWLOCK_T -o 
mysql_tzinfo_to_sql mysql_tzinfo_to_sql.o -static  
-L/progs/SUNWspro/lib:/usr/local/lib:/usr/local/lib/sparcv9:/usr/lib:/usr/share/lib:/usr/dt/lib:/usr/openwin/lib:/opt/panorama/lib:/opt/sfw/lib
 ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a 
../vio/libvio.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a 
../strings/libmystrings.a -lz -lpthread -lposix4 -lcrypt -lgen -lsocket -lnsl 
-lm -lpthread
/usr/local/bin/ld: cannot find -lpthread
collect2: ld returned 1 exit status
gmake[4]: *** [mysql_tzinfo_to_sql] Error 1
gmake[4]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql'
gmake[3]: *** [all-recursive] Error 1
gmake[3]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/scratch/hgs/mysql-4.1.13'
gmake: *** [all] Error 2
neelix hgs 57 % ls /usr/lib/*pthread*

Re: Failure to install on Solaris.

[Hugh Sasse]

On Tue, 20 Sep 2005, David Logan wrote:


Hugh Sasse wrote:



On solaris 9 Sparc I built originally by modifying
mysql-4.1.14/BUILD/compile-solaris-sparc thusly
[...] 

gmake -j 4
neelix hgs 82 %
and I invoked the script directly, and also tried with bash.
I have:

GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.9

gcc (GCC) 3.4.3


[...]

So I started again and built using this script:
#!/bin/bash
CFLAGS=-O3 -L$LD_LIBRARY_PATH CXX=gcc MAKE=gmake \
CXXFLAGS=-O3 -L$LD_LIBRARY_PATH -felide-constructors -fno-exceptions 
--with-pthread --with-gnu-ld  \

[...]


My LD_LIBRARY_PATH is

/progs/SUNWspro/lib:/usr/local/lib:/usr/local/lib/sparcv9:/usr/lib:/usr/share/lib:/usr/dt/lib:/usr/openwin/lib:/opt/panorama/lib:/opt/sfw/lib

 


This blows up with:


[...]
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti 
-fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW 
-DDEFINE_CXA_PURE_VIRTUAL -D_FILE_OFFSET_BITS=64 -DHAVE_RWLOCK_T -o 
mysql_tzinfo_to_sql mysql_tzinfo_to_sql.o -static 
-L/progs/SUNWspro/lib:/usr/local/lib:/usr/local/lib/sparcv9:/usr/lib:/usr/share/lib:/usr/dt/lib:/usr/openwin/lib:/opt/panorama/lib:/opt/sfw/lib 
../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a 
../vio/libvio.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a 
../strings/libmystrings.a -lz -lpthread -lposix4 -lcrypt -lgen -lsocket 
-lnsl -lm -lpthread

/usr/local/bin/ld: cannot find -lpthread
collect2: ld returned 1 exit status
gmake[4]: *** [mysql_tzinfo_to_sql] Error 1
gmake[4]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql'
gmake[3]: *** [all-recursive] Error 1
gmake[3]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/scratch/hgs/mysql-4.1.13'
gmake: *** [all] Error 2




neelix hgs 57 % ls /usr/lib/*pthread*
/usr/lib/libpthread.so /usr/lib/llib-lpthread
/usr/lib/libpthread.so.1 /usr/lib/llib-lpthread.ln
neelix hgs 58 %


Any suggestions as to how I get around this and get the whole thing
installed in /usr/local/mysql-4.1.13 ?

Thank you,
Hugh


Hi Hugh,

Do you have the pthread library path in the -L path somewhere? It doesn't


Yes, it is in $LD_LIBARY_PATH above.


seem to be able to find it.


Well, it does for some of the work, but not at the stage it fails.

You might like to use crle to put the paths in in 
a more permanent fashion


Possibly, but that only works for sun's ld, and GNU ld is being
found by configure.  AFAICS GNU ld doesn't make use of
$LD_LIBARY_PATH, hence the -L.


Regards
David


Thank you,
Hugh

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

Re: Failure to install on Solaris.

[Hugh Sasse]

On Tue, 20 Sep 2005, Pooly wrote:


Hi,



gmake: *** [all] Error 2
neelix hgs 57 % ls /usr/lib/*pthread*
/usr/lib/libpthread.so /usr/lib/llib-lpthread
/usr/lib/libpthread.so.1   /usr/lib/llib-lpthread.ln
neelix hgs 58 %


Any suggestions as to how I get around this and get the whole thing
installed in /usr/local/mysql-4.1.13 ?


Have you installed the development package for the pthread library ?


Not explicitly.  I have not explicitly installed pthread either.
These in /usr/lib must be supplied by Sun, I think.

Where do I get it (What's the package called, do I need a certain
version to go with 4.1.13, etc)?


I guess you're missing libpthread.a which is needed even for a dynamic


I don't know enough about pthread to know why I should need a .a
when I have a .so : they are both libraries

Why did it build the first time around, then?


linking, the linker can't do it's job here.

--
Pooly


Thank you,
Hugh

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

Re: Failure to install on Solaris.

[Hugh Sasse]

On Tue, 20 Sep 2005, Hugh Sasse wrote:


On Tue, 20 Sep 2005, Pooly wrote:


Hi,



gmake: *** [all] Error 2
neelix hgs 57 % ls /usr/lib/*pthread*
/usr/lib/libpthread.so /usr/lib/llib-lpthread
/usr/lib/libpthread.so.1   /usr/lib/llib-lpthread.ln
neelix hgs 58 %


[...]

I guess you're missing libpthread.a which is needed even for a dynamic


I don't know enough about pthread to know why I should need a .a
when I have a .so : they are both libraries

Why did it build the first time around, then?


And I get, adding -t to LDFLAGS,

configure:25912: checking named thread libs:
configure:25919: result: -lpthread
configure:26155: checking for strtok_r in -lpthread
configure:26185: gcc -o conftest -O3 
-L/progs/SUNWspro/lib:/usr/local/lib:/usr/local/lib/sparcv9:/usr/lib:/usr/share/lib:/usr/dt/lib:/usr/openwin/lib:/opt/panorama/lib:/opt/sfw/lib
 -t   -D_FILE_OFFSET_BITS=64 -DHAVE_RWLOCK_T  
-L/progs/SUNWspro/lib:/usr/local/lib:/usr/local/lib/sparcv9:/usr/lib:/usr/share/lib:/usr/dt/lib:/usr/openwin/lib:/opt/panorama/lib:/opt/sfw/lib
  conftest.c -lpthread  -lpthread -lposix4 -lcrypt -lgen -lsocket -lnsl -lm  -lpthread 
5
/usr/local/bin/ld: mode elf32_sparc
/usr/local/lib/gcc/sparc-sun-solaris2.9/3.4.3/crt1.o
/usr/local/lib/gcc/sparc-sun-solaris2.9/3.4.3/crti.o
/usr/ccs/lib/values-Xa.o
/usr/local/lib/gcc/sparc-sun-solaris2.9/3.4.3/crtbegin.o
/var/tmp//ccGJWR1E.o
-lpthread (/usr/lib/libpthread.so)
-lpthread (/usr/lib/libpthread.so)
-lposix4 (/usr/lib/libposix4.so)
-lcrypt (/usr/lib/libcrypt.so)
-lgen (/usr/ccs/lib/libgen.so)
-lsocket (/usr/lib/libsocket.so)
-lnsl (/usr/lib/libnsl.so)
-lm (/usr/lib/libm.so)
-lpthread (/usr/lib/libpthread.so)
-lc (/usr/lib/libc.so)
-lc (/usr/lib/libc.so)
/usr/local/lib/gcc/sparc-sun-solaris2.9/3.4.3/crtend.o
/usr/local/lib/gcc/sparc-sun-solaris2.9/3.4.3/crtn.o
configure:26191: $? = 0
configure:26195: test -z
 || test ! -s conftest.err
configure:26198: $? = 0
configure:26201: test -s conftest
configure:26204: $? = 0
configure:26217: result: yes

in configure.log.



linking, the linker can't do it's job here.

--
Pooly


Hugh





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

Re: `gmake test` probs Solaris9 for M. 4.1.4.

[Hugh Sasse]

On Fri, 9 Sep 2005, Michael Stassen wrote:


With mysql 4.1.12, `make -n test` reveals

 cd mysql-test; ./mysql-test-run  ./mysql-test-run --ps-protocol


For the record, here's what I got on Solaris 9 for 4.1.13

neelix hgs 18 % cd mysql-test  ./mysql-test-run --force
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables 
--basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster 
--skip-bdb --language=../sql/share/english/ 
--character-sets-dir=../sql/share/charsets/
Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables 
--basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster 
--skip-bdb --language=../sql/share/english/ 
--character-sets-dir=../sql/share/charsets/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TESTRESULT
---
alias  [ pass ]
alter_table[ pass ]
analyse[ pass ]
analyze[ pass ]
ansi   [ pass ]
archive[ skipped ]
auto_increment [ pass ]
backup [ pass ]
bdb-alter-table-1  [ skipped ]
bdb-alter-table-2  [ skipped ]
bdb-crash  [ skipped ]
bdb-deadlock   [ skipped ]
bdb[ skipped ]
bdb_cache  [ skipped ]
bench_count_distinct   [ pass ]
bigint [ pass ]
binary [ pass ]
blackhole  [ skipped ]
bool   [ pass ]
bulk_replace   [ pass ]
case   [ pass ]
cast   [ pass ]
check  [ pass ]
comments   [ pass ]
compare[ pass ]
connect[ pass ]
consistent_snapshot[ pass ]
constraints[ pass ]
count_distinct [ pass ]
count_distinct2[ pass ]
count_distinct3[ pass ]
create [ pass ]
create_select_tmp  [ pass ]
csv[ skipped ]
ctype_big5 [ skipped ]
ctype_collate  [ pass ]
ctype_cp1250_ch[ skipped ]
ctype_cp1251   [ pass ]
ctype_cp932[ skipped ]
ctype_create   [ pass ]
ctype_latin1   [ pass ]
ctype_latin1_de[ pass ]
ctype_latin2   [ pass ]
ctype_many [ skipped ]
ctype_mb   [ pass ]
ctype_recoding [ pass ]
ctype_sjis [ skipped ]
ctype_tis620   [ skipped ]
ctype_uca  [ skipped ]
ctype_ucs  [ skipped ]
ctype_ucs_binlog   [ skipped ]
ctype_ujis [ skipped ]
ctype_utf8 [ pass ]
date_formats   [ pass ]
delayed[ pass ]
delete [ pass ]
derived[ pass ]
dirty_close[ pass ]
distinct   [ pass ]
drop   [ pass ]
drop_temp_table[ pass ]
empty_table[ pass ]
endspace   [ pass ]
errors [ pass ]
exampledb  [ skipped ]
explain[ pass ]
flush  [ pass ]
flush_block_commit [ pass ]
flush_table[ pass ]
foreign_key[ pass ]
fulltext   [ pass ]
fulltext2  [ pass ]
fulltext_cache [ pass ]
fulltext_distinct  [ pass ]
fulltext_left_join [ pass ]
fulltext_multi [ pass ]
fulltext_order_by  [ pass ]
fulltext_update[ pass ]
fulltext_var   [ pass ]
func_compress  [ pass ]
func_concat[ pass ]
func_crypt [ pass ]
func_date_add  [ pass ]
func_default   [ pass ]
func_des_encrypt   [ skipped ]
func_encrypt   [ skipped ]
func_encrypt_nossl [ pass ]
func_equal [ pass ]
func_gconcat   [ pass ]
func_group [ pass ]
func_if[ pass ]
func_in[ pass ]
func_isnull[ pass ]
func_like  [ pass ]
func_math  [ pass ]
func_misc  [ pass ]
func_op[ pass ]
func_regexp 

Re: `gmake test` probs Solaris9 for M. 4.1.4.

[Hugh Sasse]

I've see no reply to this and I checked the archives, so please
excuse my resubmitting it.  Maybe I shouldn't be using 4.1.14 but
4.0.x?
Thank you,
Hugh
On Wed, 7 Sep 2005, Hugh Sasse wrote:


Attempts to do make test prior to installation, to check that I'm
installing something workable, give:

quote
neelix hgs 63 % gmake test
cd mysql-test; perl mysql-test-run.pl  perl mysql-test-run.pl --ps-protocol
No ndbcluster support
Killing Possible Leftover Processes
Removing Stale Files
Installing Master Databases
Installing Master Databases
Installing Slave Databases
Installing Slave Databases
Installing Slave Databases
===
Finding  Tests in the 'main' suite
Starting Tests in the 'main' suite

TESTRESULT
---

alias   [ pass ]
alter_table [ pass ]
analyse [ pass ]
analyze [ pass ]
ansi[ pass ]
archive [ fail ]
Errors are (from /scratch/hgs/mysql-4.1.14/mysql-test/var/log/mysqltest-time) 
:

This test is not supported by this installation
mysqltest returned unexpected code 15872, it has probably crashed
(the last lines may be the most important ones)

Aborting: archive failed. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon

Master(s) shutdown finished
Slave(s) shutdown finished
gmake: *** [test] Error 1
neelix hgs 64 %
/quote

So, firstly, invoke what with '--force'?  You don't get anything
useful if you pass that to make

Also, how can I tell if InnoDB built OK?  I'm doing this for use
with Ruby on Rails, and I need it to be in a separate directory from
the version we already have (3.x) used by others.  I modified
mysql-4.1.14/BUILD/compile-solaris-sparc thusly

neelix hgs 81 % display_diffs.rb .
--- ./compile-solaris-sparc.orig2005-08-17 18:06:41.0 +0100
+++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100
@@ -11,6 +11,6 @@
   (cd gemini  aclocal  autoheader  aclocal  automake  autoconf)
fi

-CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W 
-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Wunused  -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc 
CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W 
-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy 
-Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti  -O3 
-fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa -g ./configure 
--prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex 
--enable-thread-safe-client
+CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W 
-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Wunused  -O3 -fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc 
CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W 
-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy 
-Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti  -O3 
-fno-omit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa -g ./configure 
--prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex 
--enable-thread-safe-client --with-tcp-port=3308 
--with-unix-socket-path=/tmp/mysql4.sock --prefix=/usr/local/mysql-4.1.14


gmake -j 4
neelix hgs 82 %
and I invoked the script directly, and also tried with bash.

Not sure what else to pass on.

GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.9

gcc (GCC) 3.4.3

   Thank you
   Hugh

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





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

Re: `gmake test` probs Solaris9 for M. 4.1.4.

[Hugh Sasse]

On Fri, 9 Sep 2005, Michael Stassen wrote:


Hugh,

I get the same thing on Mac OS X 10.3.9.  My thinking was that rather than 
replying with an unhelpful Me too,  I would do some digging and then reply 
with what I found.  I realize now that left you hanging (sorry), so I'll 
report what I've found so far.


Ok, thanks for this report, which is in plenty of detail, even if it
is so far :-)


The test suite is broken.


Who guards the guards? :-)


The archive test is meant to test the archive table engine, but the archive 
engine is not built into mysql by default.  You have to add the 
--with-archive-storage-engine if you want it.  You didn't do that, so the


I'm not sure what it is, so I probably don't need it.


archive test should have been skipped.

With mysql 4.1.12, `make -n test` reveals

 cd mysql-test; ./mysql-test-run  ./mysql-test-run --ps-protocol

With 4.1.14, that has changed to

 cd mysql-test; perl mysql-test-run.pl  perl mysql-test-run.pl
 --ps-protocol

Apparently, the test program shell script, mysql-test-run, has been rewritten 
as a perl script, though there is no mention of this in the change log 
http://dev.mysql.com/doc/mysql/en/news-4-1-x.html.  A quick glance at the


  I was rather surpised about the dependency on Perl.

source shows that the perl script is not finished -- it has quite a few 
commented-out, fix me sections.


I'll have a look.


You still have a couple of options to test your build.  You can run the new 
test suite with the --force option.  Do what make would do, `cd mysql-test`, 
then `perl mysql-test-run.pl --force`.  You will see that every test that 
should have been skipped will instead be run and fail (archive, the bdb 
tests, blackhole, csv, example, func_des_encrypt, isam, the ndb tests,


I'm fairly fluent in perl, though mine's a bit Chaucerian, since I
learned Perl4 :-), and am not *so* familiar with the 5 constructs, but
I could try to send patches (to whom?).

openssl_1, raid, and so on).  If every test passes except for tests of things 
you don't have, you should be OK.  In particular, there are a set of innodb 
tests which should answer your question about whether or not innodb is 
working in your build.


Thanks.


There's a second way, which I think is better.  It turns out that the old 
shell-script test suite is still built.  Hence, you can still test the old 
way.


Yes, and It may be worth trying both.


 cd mysql-test  ./mysql-test-run --force

This will properly skip tests of features not compiled in.  Note that I added


I can probably steal how to skip them and stick that in the Perl.

--force because, at least in my case, the new embedded test, 
not_embedded_server, is run and fails.  I'm not yet sure if that should have 
been skipped.


The errors explicitly told me I needed --force, so that's OK.


As the old test script is still built and the new test script is unfinished, 
undocumented, and broken, I am suspicious that the real problem is that make 
was prematurely (accidentally?) changed to use the new one before it was 
ready.  I've copied the bugs list in hopes of an answer.


Definitely some weirdness about the release process there :-)  I'm
sure I've done worse in the past, though.

I'm not subscribed to the bugs list, so this might bounce back off
there.

The third way, I suppose, is to ask whether I'm actually using the
correct version -- should I be on 4.1,x, or 4.0.x, or what?  I'm under
the impression that for work with Ruby on Rails I need the latest
4.x but I could have misunderstood something.  What I really mean
is: which versions are considered stable?  [Ruby has a custom that
minor release numbers are odd for developement, even for stable, but
minorminor ones increment successively after that: 1.8.2, and 1.8.3
(due soon) are stable, 1.9.x is development (at present). I'm not
sure how things work in the MySQL world.] 


Michael

P.S.  Out of curiosity, why did you find it necessary to edit 
BUILD/compile-solaris-sparc?  Couldn't you make the changes you wanted with 
options to configure?


I was passing options to configure, and the was a bit of setup in
compile-solaris-sparc that was probably there for a reason.  So I
changed it there.  I changed it to give me the alternative port and
directory so I don't munge things for people using V3.x, used for
teaching.  [Besides, I'd have to mess with autoconf to fix configure
properly, as it is setup by that, and I'm not so fluent in autoconf
as I'd wish, plus it seems silly to mod the autoconf stuff for
something so parochial as port + directory.] Maybe there's a better
place altogether to define this stuff?

Thank you,
Hugh

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

Re: `gmake test` probs Solaris9 for M. 4.1.4.

[Hugh Sasse]

On Fri, 9 Sep 2005, Joerg Bruehe wrote:


Michael,


you beat me in replying, and saved me from typing the analysis - thanks!


Michael Stassen wrote:

[[...]]

The test suite is broken.


Well, I would not put it that way - a diplomatic wording is:
The tool to run the test suite does not run as it should.
I understand that the effect for Hugh and you is the same ;-)


Nobody was claiming *deliberate* breakage! :-)
[...]

quite a few commented-out, fix me sections.


Correct. A Perl script for the test suite is being worked on. Reasons:
1) A shell script will never work for native Windoes users who do not 
install Cygwwin, MinGW, MKS or similar suites.
2) The shell script lacks some functionality which is needed, and it is 
already too convoluted.


Good reasons. 



[...]

  cd mysql-test  ./mysql-test-run --force


Right, this is what I recommend.

To be a bit picky: There is one standard test suite only (which is included 
in the source tar-ball), but there are currently two different scripts to run 
it, the (old) shell and the (new) Perl script.


The specific error causing your and Hugh's problem, the incorrect skipping of 
tests which are not applicable to the server to be tested,
has been fixed, but maybe this version has not yet been pushed to the 4.1 
tree.


Can we grab the new version off the web (CVSweb or similar?)
somewhere?  If it is feasible for me I'd like to translate it to
Ruby to give you that much wider coverage.  Depends if my Perl
fluency is sufficient, etc.  Whether {you, the committee, ???} accept
the contribution is another matter entirely, of course.



Regards, J?rg


Thank you,
Hugh





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

`gmake test` probs Solaris9 for M. 4.1.4.

[Hugh Sasse]

Attempts to do make test prior to installation, to check that I'm
installing something workable, give:

quote
neelix hgs 63 % gmake test
cd mysql-test; perl mysql-test-run.pl  perl mysql-test-run.pl --ps-protocol
No ndbcluster support
Killing Possible Leftover Processes
Removing Stale Files
Installing Master Databases
Installing Master Databases
Installing Slave Databases
Installing Slave Databases
Installing Slave Databases
===
Finding  Tests in the 'main' suite
Starting Tests in the 'main' suite

TESTRESULT
---

alias   [ pass ]
alter_table [ pass ]
analyse [ pass ]
analyze [ pass ]
ansi[ pass ]
archive [ fail ]
Errors are (from /scratch/hgs/mysql-4.1.14/mysql-test/var/log/mysqltest-time) :
This test is not supported by this installation
mysqltest returned unexpected code 15872, it has probably crashed
(the last lines may be the most important ones)

Aborting: archive failed. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon

Master(s) shutdown finished
Slave(s) shutdown finished
gmake: *** [test] Error 1
neelix hgs 64 %
/quote

So, firstly, invoke what with '--force'?  You don't get anything
useful if you pass that to make

Also, how can I tell if InnoDB built OK?  I'm doing this for use
with Ruby on Rails, and I need it to be in a separate directory from
the version we already have (3.x) used by others.  I modified
mysql-4.1.14/BUILD/compile-solaris-sparc thusly

neelix hgs 81 % display_diffs.rb .
--- ./compile-solaris-sparc.orig2005-08-17 18:06:41.0 +0100
+++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100
@@ -11,6 +11,6 @@
(cd gemini  aclocal  autoheader  aclocal  automake  autoconf)
 fi

-CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts 
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused  -O3 -fno-omit-frame-pointer 
-mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch 
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor 
-felide-constructors -fno-exceptions -fno-rtti  -O3 -fno-omit-frame-pointer -mcpu=v8 
-Wa,-xarch=v8plusa -g ./configure --prefix=/usr/local/mysql --enable-assembler 
--with-extra-charsets=complex --enable-thread-safe-client
+CFLAGS=-g -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts 
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused  -O3 -fno-omit-frame-pointer 
-mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch 
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings 
-Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor 
-felide-constructors -fno-exceptions -fno-rtti  -O3 -fno-omit-frame-pointer -mcpu=v8 
-Wa,-xarch=v8plusa -g ./configure --prefix=/usr/local/mysql --enable-assembler 
--with-extra-charsets=complex --enable-thread-safe-client --with-tcp-port=3308 
--with-unix-socket-path=/tmp/mysql4.sock --prefix=/usr/local/mysql-4.1.14

 gmake -j 4
neelix hgs 82 %
and I invoked the script directly, and also tried with bash.

Not sure what else to pass on.

GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.9

gcc (GCC) 3.4.3

Thank you
Hugh

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