Re: mysql 4.0.1-alpha

2003-08-05 Thread Victoria Reznichenko
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > 7.5.5.2 Foreign Key Constraints > > Hi programmers, > > I try to code this > > CREATE TABLE EMPLOYEE > ( > FNAME VARCHAR(15) NOT NULL, > MINIT CHAR, > LNAME VARCHAR(15) NOT NULL, > SSN

mysql 4.0.1-alpha

2003-08-05 Thread Morten Gulbrandsen
7.5.5.2 Foreign Key Constraints Hi programmers, I try to code this CREATE TABLE EMPLOYEE ( FNAME VARCHAR(15) NOT NULL, MINIT CHAR, LNAME VARCHAR(15) NOT NULL, SSN CHAR(9) NOT NULL, BDATE DATE, ADDRESS VARCHAR(30), SE

error make test - mysql 4.0.1 alpha

2002-06-25 Thread Richard Pijnenburg
Hello, I've tried to install mysql 4.0.1 Alpha. The configuration did not give me any error's The "make" also worked just fine. But when I run "make test" I get the following error: ERROR: /down/new/mysql-4.0.1-alpha/mysql-test/var/run/master.pid was not created

mysql-4.0.1-alpha (Official MySQL RPM) installtion problem

2002-06-05 Thread Yogesh Malik
From: ymalik To: [EMAIL PROTECTED] Subject: [Installation ] >Description: mysql-4.0.1-alpha (Official MySQL RPM) installtion problem >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email sup

LOAD DATA LOCAL INFILE problem with MySQL 4.0.1-alpha on RH7.3

2002-05-29 Thread Patrik Birgersson
Hi list! I have a problem when trying to read data into tables with LOAD DATA LOCAL INFILE. I get this error: ERROR 2013: Lost connection to MySQL server during query When looking at the MySQL site it says that I should increase the max_allowed_packet=# option (default 1M). However, my file is

Re: Possible Bug in UPdATE in MySQL 4.0.1 alpha

2002-05-21 Thread Michael B. Venezia
On Tue, 21 May 2002, Michael Widenius wrote: > > Hi! > > > "Michael" == Michael B Venezia <[EMAIL PROTECTED]> writes: > > >> Description: > Michael> Possible Bug in UPDATE in MySQL 4.0.1 > > > > Michael> Attempting backtrace. You can use the following information to find out > Michael

Possible Bug in UPdATE in MySQL 4.0.1 alpha

2002-05-21 Thread Michael Widenius
Hi! > "Michael" == Michael B Venezia <[EMAIL PROTECTED]> writes: >> Description: Michael>Possible Bug in UPDATE in MySQL 4.0.1 Michael> Attempting backtrace. You can use the following information to find out Michael> where mysqld died. If you see no messages after this, something

Re: Possible Bug in UPdATE in MySQL 4.0.1 alpha

2002-05-20 Thread Victoria Reznichenko
Michael, Sunday, May 19, 2002, 12:56:00 PM, you wrote: MBV> Description: MBV> Possible Bug in UPDATE in MySQL 4.0.1 MBV> The following is the message in the error log... MBV> Number of processes running now: 0 MBV> 020519 04:55:30 mysqld restarted MBV> 020519 4:55:30 InnoDB:

Possible Bug in UPdATE in MySQL 4.0.1 alpha

2002-05-19 Thread Michael B. Venezia
nd the query worked without issue. I even tried this by simply copying the data directory over (tar.gz-ed the data directory, untared it on the other machine, and restarted the server) >Submitter-Id: >Originator: >Organization: >MySQL support: none >Synopsis: Specific U

builidng mysql-4.0.1-alpha

2002-05-14 Thread Taylor Lewick
Hi all, I am attempting to build mysql-4.0.1-alpha on an HP-UX 11.00 box because the binary I installed worked, but I couldnet connect to the database by typing in a password at the prompt, I had to actually pass it on the command line. I figured there might be a few other odd behaviors that

Re: InnoDB Error 150, MySQL 4.0.1 alpha & 3.23.49

2002-04-21 Thread Heikki Tuuri
Richard, - Original Message - From: ""Richard Harms"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, April 22, 2002 2:32 AM Subject: InnoDB Error 150, MySQL 4.0.1 alpha & 3.23.49 > Hello, > > When attempting to create some

InnoDB Error 150, MySQL 4.0.1 alpha & 3.23.49

2002-04-21 Thread Richard Harms
Hello, When attempting to create some tables using the MySQL 4.0.1 alpha and 3.23.49, I'm getting a generic error message, "General error: Can't create table './industria/ORDEREDITEMS.frm' (errno: 150)." The other 6 tables, all using similar features, are created

Re: Mysql 4.0.1-Alpha: Union + Limit bug.

2002-03-22 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > > Take two tables (call them a and b), which have identical structures. Table a > has no rows, table b has some (say 10) rows. If you do this: > > select * from a union select * from b limit 0,5 > > It works as expected. Now do this: > > select *

Mysql 4.0.1-Alpha: Union + Limit bug.

2002-03-21 Thread eric
SQL support: none >Synopsis: Union + Limit issue in 4.0.1 Alpha >Severity: non-critical >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.0.1-alpha (Official MySQL binary) >Environment: System: Linux webserver1 2.4.17 #

mysql-4.0.1-alpha: native cc compiler build failure on IBM AIX 4.3 because of gcc'isms in source code

2002-03-12 Thread mthnhb
>Description: mysql-4.0.1-alpha fails to build on IBM AIX 4.3 because of gcc'isms in the source code. A fix for that problem is supplied below. However, configure says: checking for alloca.h... no checking for working

mysql-4.0.1-alpha: small build glitch on DEC Alpha OSF/1 4.0: snprintf use, and a patch to fix it

2002-03-12 Thread Nelson H. F. Beebe
>Description: A build of mysql-4.0.1-alpha on DEC Alpha OSF/1 4.0 failed like this: gcc -O3 -DDBUG_OFF -o ft_dump ft_dump.o libmyisam.a \ ../mysys/libmysys.a ../dbug/libdbug.a \ ../strings/libmystrings.a -lpthread -lmach -lexc -lz