Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread shawn l.green
Hello, On 7/6/2014 7:42 PM, 娄帅 wrote: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any inp

Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread Reindl Harald
gt;> >> >> 2014-07-07 7:42 GMT+08:00 娄帅 : >> >>> Hi, all, >>> >>> I want to use MySQL 5.6.18 in production, so i want to get all known bugs >>> on this version. Now i check the "bugfix" section in MySQL 5.6.19 and >> abov

Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread wagnerbianchi.com
Why do not use GTID? Just curious...WB 2014-07-07 3:18 GMT-03:00 louis liu : > don't use GTID is my suggestion :) > > > > 2014-07-07 7:42 GMT+08:00 娄帅 : > > > Hi, all, > > > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs >

Re: How to get all known bugs on specified mysql version?

2014-07-06 Thread louis liu
don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 : > Hi, all, > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs > on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above > version. Am i doing the

How to get all known bugs on specified mysql version?

2014-07-06 Thread 娄帅
Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciated!

mysql5.4 bugs about mysqladmin??

2009-05-19 Thread 周彦伟
Hi,I'm using mysql5.4-beta now.when I use flow command ,it does not works,is mysql5.4 bug? The command mysqladmin -p -r --sleep=1 --count=100 extended-status It run only one time. Thanks! -邮件原件- 发件人: mos [mailto:mo...@fastmail.fm] 发送时间: 2009年5月18日 2:14 收件人: mysql@lists.mysql.com 主题

mysqldump --compatible=mysql40 Bugs?

2006-11-29 Thread Manfred Rebentisch
Hallo ich habe eine mysql 5 Datenbank so extrahiert (für den Import in eine mysql 4 Datenbank): mysqldump -h localhost -p -u mareb --compatible=mysql40 mydatabase >mydatabase.sql Im SQL-Script fehlt dann die Angabe "auto_increment" - mit fatalen Folgen. Wenn ich mysqldump -h localhost -p -

Re: check bugs.

2006-11-12 Thread Daniel Kasak
C K wrote: please check bugs and please give the answer Bug ID=24216 and 24216 They are both the same bug ID, so I will only bother answering once. You probably are using InnoDB tables to store your data, and this is expected behaviour for InnoDB - MySQL provides a rough guess as to how

check bugs.

2006-11-11 Thread C K
please check bugs and please give the answer Bug ID=24216 and 24216 CPK

Re: mysqlbug_ problem with 5016 startup - doesnt work (2 bugs found)

2005-12-07 Thread Gleb Paharenko
Hello. > seems to put the socket file in the wrong place- (should be in /tmp) Your running copy of mysqld has --socket==/var/lib/mysql/mysql.sock argument. Perhaps mysqld_safe puts it by default or reads from [mysqld_safe] or [mysqld] sections of configuration file. Specify the value of so

mysqlbug_ problem with 5016 startup - doesnt work (2 bugs found)

2005-12-07 Thread Dan Gahlinger
Description: mysql will not create /tmp/mysql.sock at first it would not create /var/run/mysql/mysqld.pid - I manually created the /var/run/mysql and set permissions, and it works. now i have problems with the socket file - it wont create it How-To-Repeat: bin/mysqld_safe --user=mysql & ./b

Re: 2 Bugs

2005-10-05 Thread Remo Tex
Philippe HAMEAU wrote: Hi, I noticed 1 bug with 5.0.13rc (win32 msi) : when installing mysql in a custom location (eg c:\program files\easyphp\mysql), 1) the service will not get installed properly 2) mysqld will complain about InnoDB engine not present. Hope this helps. Phil Have you read:

Re: 2 Bugs

2005-10-05 Thread Jigal van Hemert
Remo Tex wrote: 1) that's common problem when doing custom install on PATH containing spaces like "C:\Program Files". Solution - try custom location with short(er) path and without spaces like "C:\mysql5013\". Probably that will solve problem 2. if not then.. Remo Tex, That is not a good exc

Re: 2 Bugs

2005-10-05 Thread Remo Tex
...and 3. Are you running another instance of mysql? Then perhaps both compete for same resource(s) like: port 3306 ;-) Remo Tex wrote: 1) that's common problem when doing custom install on PATH containing spaces like "C:\Program Files". Solution - try custom location with short(er) path and w

Re: 2 Bugs

2005-10-05 Thread Remo Tex
1) that's common problem when doing custom install on PATH containing spaces like "C:\Program Files". Solution - try custom location with short(er) path and without spaces like "C:\mysql5013\". Probably that will solve problem 2. if not then.. 2. Edit my.ini looking for skip-innodb or related o

2 Bugs

2005-10-04 Thread Philippe HAMEAU
Hi, I noticed 1 bug with 5.0.13rc (win32 msi) : when installing mysql in a custom location (eg c:\program files\easyphp\mysql), 1) the service will not get installed properly 2) mysqld will complain about InnoDB engine not present. Hope this helps. Phil -- MySQL General Mailing List For list a

Re: MySQL Bugs: #7714: if disk full, sometimes MyISAM doesn't wait for free space, corrupts table

2005-09-21 Thread Guilhem Bichot
Hi, On Wed, Sep 21, 2005 at 02:40:26PM +0530, Jaspreet Singh wrote: > Hi, > > I was trying to impose hard disk-quotas over MySQL database when i > stumbled upon this bug. (Bug #7714) > > The Bug report says that, it has been comited in 4.0 branch. But release > notes show me that it was been fix

Re: timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

2004-11-29 Thread Peter Valdemar Mørch
Thank you Michael for your very thoughtful reply. I know that it takes time and effort to answer at the level you did. Michael Stassen Michael.Stassen-at-verizon.net |Lists| wrote: > You seem to have a fundamental misunderstanding of the TIMESTAMP type. > No timezone or DST information is stored

Re: timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

2004-11-28 Thread Michael Stassen
holiday rather than reading e-mail, I might add). I agree that it does not do what you expect, but the question of "fundamentally broken" is not so simple. I'll go ahead and file several bugs, and start changing our code to avoid the timestamp type altogther. I'm quite sur

Re: timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

2004-11-27 Thread Peter Valdemar Mørch
From the lack of responses I take it that nobody disagrees that the handling of the timestamp type is fundamentally broken in every version of MySQL. I'll go ahead and file several bugs, and start changing our code to avoid the timestamp type altogther. I'm quite surprised! P

timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

2004-11-25 Thread Peter Valdemar Mørch
---+ | TIMEDIFF(FROM_UNIXTIME(1099185600), FROM_UNIXTIME(1099181400)) | ++ | 00:10:00 | +----+ But 4200 secs is 01:10:00, not 00:10:00!!!

ALTER table performance and bugs...

2004-10-16 Thread Kevin A. Burton
I just posted two detailed issues WRT the perfomance of ALTER table and what I think are pretty significant issues. For the last few days I've been using MySQLs ALTER and REPAIR table functionality and its caused tons of countless problems and a great deal of lost sleep. The first problem I no

Re: 4.1.3-5. Bugs alive!

2004-09-24 Thread Egor Egorov
Juri Shimon <[EMAIL PROTECTED]> wrote: > Using 'int not null' make next enum (using cp1251) corrupted in > mysqldump output on W2000. > Is this a known issue? Spasibo, the bug is posted as http://bugs.mysql.com/bug.php?id=5728 I'm not sure if this is a known issue, but I let the developers inve

4.1.3-5. Bugs alive!

2004-09-23 Thread Juri Shimon
Hello mysql, Using 'int not null' make next enum (using cp1251) corrupted in mysqldump output on W2000. Is this a known issue? How-to-repeat: --- drop table if exists t1; drop table if exists t2; create table t1 (a int, b enum('А','Б')) DEFAULT CHARACTER SET cp1251; creat

Re: Status of bugs

2003-12-15 Thread miguel solorzano
At 11:34 15/12/2003 -0800, Jim Gallagher wrote: Hi, Hello, Last month I posted here a question (with no responses) about a problem I am having with myisamchk ("myisamchk Error 22 WinServer 2003 Large table"). My problem seems to be identical to that described here: http://bugs.mysql.com/bug.ph

Status of bugs

2003-12-15 Thread Jim Gallagher
Hello, Last month I posted here a question (with no responses) about a problem I am having with myisamchk ("myisamchk Error 22 WinServer 2003 Large table"). My problem seems to be identical to that described here: http://bugs.mysql.com/bug.php?id=779 However, that bug was for the 3.x version

BUGS: MySQL 4.1.1 Internationalization (ENUM)

2003-12-10 Thread Juri Shimon
Hi! create table t(a enum ('','ÃÃÃ','ÃÃÃ')); show create table t; CREATE TABLE `t` ( `a` enum('','???','???') default NULL ) TYPE=MyISAM DEFAULT CHARSET=cp1251 and this is a bug! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

Re: bugs

2003-11-14 Thread Victoria Reznichenko
Margrit Lottmann <[EMAIL PROTECTED]> wrote: > Why do you refuse to accept my messages. > I urgently need to send our bug report. Post bug reports to the bug databse: http://bugs.mysql.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsor

bugs

2003-11-14 Thread Margrit Lottmann
Why do you refuse to accept my messages. I urgently need to send our bug report. -- Mit freundlichen Gruessen M.Lottmann Otto - von - Guericke Universitaet __ __ _ _ __ Magdeburg / / / / / __ \__ // | / / ---

Re: [OT] libmysqld (was Re: [Submitting BUGS] Paying for Support)

2003-09-28 Thread Jakob Dölling
Director General: NEFACOMP wrote: > Will you please explain? Yes. You wrote: I am developping a software [...] Also I will try to negociate with them for a customized version of the MySQL database (with some amount of $$$ of course) so that the server can be reached by and only by MY APPLICATIO

Re: MySql bugs?

2003-09-17 Thread Andrea
The original problem is because MySql dosen't support "deferrable constraint". I "solve" this problem with this workaround: UPDATE Prova SET Prog=Prog*-1 WHERE Gruppo=16 AND Prog>=1; UPDATE Prova SET Prog=ABS(Prog)+1 WHERE Gruppo=16 AND ABS(Prog)>=1; > Use ORDER BY clause in UPDATE statement: > h

Re: MySql bugs?

2003-09-17 Thread Egor Egorov
"Andrea" <[EMAIL PROTECTED]> wrote: > > In MySql I create this table: > > CREATE TABLE `prova` ( > `Gruppo` int(11) NOT NULL default '0', > `Prog` int(11) NOT NULL default '0', > `Descrizione` varchar(100) default '', > PRIMARY KEY (`Gruppo`, `Prog`) > ) TYPE=MyISAM; > > Running this: > UPD

MySql bugs?

2003-09-17 Thread Andrea
Hi. In MySql I create this table: CREATE TABLE `prova` ( `Gruppo` int(11) NOT NULL default '0', `Prog` int(11) NOT NULL default '0', `Descrizione` varchar(100) default '', PRIMARY KEY (`Gruppo`, `Prog`) ) TYPE=MyISAM; Running this: UPDATE Prog SET Prog=Prog+1 WHERE Gruppo=16 AND Prog>=1

Re: BUGs on MyODBC when trying MS DTS MSSQL 2000 to MYSQL 3.23.55

2003-03-07 Thread Karam Chand
I have never tried MS DTS, but SQLyog works great for me in transferring MS SQL Server data to MySQL. --- phil <[EMAIL PROTECTED]> wrote: > How-To-Repeat: > > > I am tried to use MS DTS to transfer a table from > MSSQL 2000 to MYSQL > 3.23.55, > however there has an error during the transformat

BUGs on MyODBC when trying MS DTS MSSQL 2000 to MYSQL 3.23.55

2003-03-07 Thread phil
How-To-Repeat: I am tried to use MS DTS to transfer a table from MSSQL 2000 to MYSQL 3.23.55, however there has an error during the transformation on one data type. The error happens when I have a "text" datatype on MSSQL 2000 table, and "text/blob" on MySQL table. The error is "fail to insert

Re: Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Victoria, > Thank you for bug reports, both bugs are fixed. That's fast :-)) What about the LOCAL bug (or feature)? I.e. you can start mysqld --local-infile=1, or you can start MySQL Monitor like mysql --local-infile=1, or even both, and it won't help. You cannot use lo

re: Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system

2003-01-13 Thread Victoria Reznichenko
+--- > > > | GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD > > '4655c05b05f1 > > | GRANT ON `footable`.* TO 'foo'@'foohost' WITH GRANT OPTION > > +---

Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system

2003-01-08 Thread Stefan Hinz, iConnect \(Berlin\)
7;@'foohost'; +--- | Grants for foo@foohost +--- | GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD '4655c05b05f1 | GRANT ON `footable`.* TO 'foo'@'foohost'

RE: MySQL 4.0.7-gamma: Bugs affecting the privilege system

2003-01-08 Thread Alexander M. Turek
lege_tables is nowhere to find, but a list > member who had pulled the 4.1 source found it in there and > sent it to me. I extracted the SQL statements, ran the > script, and now my 4.0.7 has all the new privileges. You'll > find it at the bottom of this mail. > > Maybe this c

Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system

2003-01-05 Thread Stefan Hinz, iConnect \(Berlin\)
now my 4.0.7 has all the new privileges. You'll find it at the bottom of this mail. Maybe this can fix the other bugs you reported, too. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germ

MySQL 4.0.7-gamma: Bugs affecting the privilege system

2003-01-05 Thread Alexander M. Turek
Hi MySQL team, I'm not sure, if this is the right place for bug reports, so, if it isn't, please forward this to those who are resposible. Running MySQL 4.0.7 on a Windows NT 5.2 RC2 machine and on a Windows NT 5.1 one as well, I encoutered some bugs: - After having set up bot

Re: bugs with Widows Me

2002-11-19 Thread Nicholas Elliott
]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 10:06 AM Subject: bugs with Widows Me > /* >$var="some long text" >or >$var='some long text' > */ > > if (!mysql_query("INSERT INTO table(field) VALUES($var)")) die(

Re: bugs with Widows Me

2002-11-19 Thread Roger Baklund
* Erumba Gotha Henri > /* >$var="some long text" >or >$var='some long text' > */ The kind of quoting used within PHP does not matter to mysql. > if (!mysql_query("INSERT INTO table(field) VALUES($var)")) die("Always > die"); > > /* >1. MySQL doesn't insert the content of the varia

bugs with Widows Me

2002-11-19 Thread Erumba Gotha Henri
/* $var="some long text" or $var='some long text' */ if (!mysql_query("INSERT INTO table(field) VALUES($var)")) die("Always die"); /* 1. MySQL doesn't insert the content of the variable $var into the field table wich is a VARCHAR type or TEXT type 2. table contains other fields - t

About recent "bugs" in MySQL/Glibc

2002-10-19 Thread Egor Egorov
Hello. A note due to lots of reports. Those of you who has problems running latest binary MySQL with the latest glibc from RedHat (MySQL crashes when client tries to connect from remote host) - you can either: * Downgrade glibc * Run nscd That will help. -- For technical support contrac

bugs report

2002-09-06 Thread Ole Andersen
I got this and I think You must have it. You seem to have found a bug in the SQL parser. Please submit a bug report with the data chunk below: --BEGIN CUT-- JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05IEV4 cCAkPGJyIC8+CldoeSBkaWQgd2UgZ2V0IGhlcmU/IDQ2OSA0NzAgODE3PGJy

2 bugs in mysqlaccess

2002-08-26 Thread Christian Hammers
Hello First bug: The contact address is no longer existing: "BUGs can be reported by email to [EMAIL PROTECTED]" Second bug: perl does not substitute the '~' char to the home directory: > --- /tmp/mysqlaccess.orig 2002-08-27 08:25:23.0 +0200 >

Re: 4.0.2 Bugs

2002-07-13 Thread Richard Clarke
Jeremy Zawodny wrote: >On Sat, Jul 13, 2002 at 09:25:32AM +0100, Richard Clarke wrote: > >>Heikki & Others, >> >> I read through the 4.0.2 Changelog but I couldn't find indication of >>the following bug fixes. >> >>1. Was the bug with drop/create tables causing assertaion errors fixed. >>I th

Re: 4.0.2 Bugs

2002-07-13 Thread Jeremy Zawodny
On Sat, Jul 13, 2002 at 09:25:32AM +0100, Richard Clarke wrote: > Heikki & Others, > >I read through the 4.0.2 Changelog but I couldn't find indication of > the following bug fixes. > > 1. Was the bug with drop/create tables causing assertaion errors fixed. > I think that the latest 3.x re

4.0.2 Bugs

2002-07-13 Thread Richard Clarke
Heikki & Others, I read through the 4.0.2 Changelog but I couldn't find indication of the following bug fixes. 1. Was the bug with drop/create tables causing assertaion errors fixed. I think that the latest 3.x release has this bug fixed but I know 4.0.1 certainly doesn't. 2. Do Unions

BUGS REPORT FOR MYSQL

2002-06-28 Thread Wan YU
(1)Maybe it should be modified this way, err = WaitForSingleObject(event, time); (2)Comment this statement Submitter-Id: [EMAIL PROTECTED] Originator: ybetter Organization: UESTC MySQL support: none Synopsis: source code bugs Severity: seriou

BUGS REPORT FOR MYSQL

2002-06-27 Thread Wan YU
Hi, I'm doing research on DBMS recently and have found some bugs in mysql's source codes.I think it will be more convenient to point out them directly than using mysqlbug.The following are my finds. mysqladmin -version output: mysqladmin Ver 8.22 Distrib 3.23.44, for pc-linux-g

Re: 4.0.1 Bugs

2002-05-23 Thread Richard Clarke
ROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 5:15 AM Subject: Re: 4.0.1 Bugs > > I had problems with unions that result in large queries too. > I found that MySQL 4 was using Heap tables for Unions. > One can Increase the Heap Table size to help, but >

Re: 4.0.1 Bugs

2002-05-22 Thread Michael Grover
p://www.innodb.com for the online manual and latest news on InnoDB > > > > - Original Message - > > From: "Richard Clarke" <[EMAIL PROTECTED]> > > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > > Sent: Sunday, May 19, 2002 12:02 PM &

Re: 4.0.1 Bugs

2002-05-22 Thread Heikki Tuuri
EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > Sent: Sunday, May 19, 2002 12:02 PM > Subject: Re: 4.0.1 Bugs > > > > Heikki, > > As for my crashes. This one is a little hard, see, we have two > machines > > that do this. Both however

Re: 4.0.1 Bugs

2002-05-19 Thread Heikki Tuuri
manual and latest news on InnoDB - Original Message - From: "Richard Clarke" <[EMAIL PROTECTED]> To: "MYSQL" <[EMAIL PROTECTED]>; "Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Sunday, May 19, 2002 3:25 PM Subject: Re: 4.0.1 Bugs > Heikki,

Re: 4.0.1 Bugs

2002-05-19 Thread Richard Clarke
after show create/drop/create ... worked fine. Even though these show creates happen 4/5 hours could they be the cause of it somehow only crashing every 4/5 days? Or is it more likely that the crashes I experience are a set of bugs. Maybe one day the assertion failure crashes it, then a few days aft

Re: 4.0.1 Bugs

2002-05-19 Thread Heikki Tuuri
ri" <[EMAIL PROTECTED]> Sent: Sunday, May 19, 2002 12:02 PM Subject: Re: 4.0.1 Bugs > Heikki, > As for my crashes. This one is a little hard, see, we have two machines > that do this. Both however, display little to no information in the log. One > server just says mys

Re: 4.0.1 Bugs

2002-05-19 Thread Heikki Tuuri
ri" <[EMAIL PROTECTED]> Sent: Sunday, May 19, 2002 12:02 PM Subject: Re: 4.0.1 Bugs > Heikki, > As for my crashes. This one is a little hard, see, we have two machines > that do this. Both however, display little to no information in the log. One > server just says mys

Re: 4.0.1 Bugs

2002-05-18 Thread Heikki Tuuri
already a rather old release and several bugs have been fixed since then. Unfortunately, 3.23 does not support unions. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news

Re: 4.0.1 Bugs

2002-05-18 Thread Richard Clarke
ginal Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: "Richard Clarke" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTECTED]> Sent: Saturday, May 18, 2002 9:48 PM Subject: SV: 4.0.1 Bugs > > Fra: Richard Clarke [mailto:[EMAIL PROTECTED]]

SV: 4.0.1 Bugs

2002-05-18 Thread Carsten Gehling
> Fra: Richard Clarke [mailto:[EMAIL PROTECTED]] > Sendt: 18. maj 2002 22:29 > Emne: 4.0.1 Bugs > > > List, > I wondered if any movement has been made to determine the cause of the > following "bugs" that I have come across using Mysql 4.0.1. > > 1)

4.0.1 Bugs

2002-05-18 Thread Richard Clarke
List, I wondered if any movement has been made to determine the cause of the following "bugs" that I have come across using Mysql 4.0.1. 1) selectunion causes a temporary table full type error when the datasets aren't even that large and when there is bags of disk s

Re: FULLTEXT search bugs in 4.0.1 alpha?...

2002-05-06 Thread Sergei Golubchik
Hi! On May 06, Gurhan Ozen wrote: >Is there anyway to see what bugs have been reported for fulltext search > in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs > were found in fulltext search in 4.0.1 , but didn't tell what they were. > I have instal

FULLTEXT search bugs in 4.0.1 alpha?...

2002-05-06 Thread Gurhan Ozen
Is there anyway to see what bugs have been reported for fulltext search in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs were found in fulltext search in 4.0.1 , but didn't tell what they were. I have installed 4.0.1 and ran it as second mysqld in my web s

SQL Bugs/Missing INFO

2002-04-26 Thread Michael Widenius
en for syntax errors and ind I am not aware of any bugs that would cause this error. Are you 100 % sure that you don't have an syntax error or are using some feature that MySQL doesn't support in your SQL command ? Regards, Monty -- For technical

SQL Bugs/Missing INFO

2002-04-25 Thread Trent Creekmore
In the MySQL manual, the error codes are not available. This is a serious problem. I have an error that keeps coming up and no way to solve it. The error code is 1064. I believe for the syntax, but a THOROUGH check indicated there is NO error in syntax, so it must be a bug in the MySQL server.

BUGs in mysqldumpslow + fixes

2002-03-09 Thread Steven Roussey
(BTW, mysqldumpslow does not seem to be in the RPMs for v4.) mysqldumpslow (perl itself, I guess) dumps core and acts incorrectly when dealing with simplifying strings. Fix: Change: s/'([^\\\']|\\.|\'\')+'/'S'/g; s/"([^\\\"]|\\.|\"\")+"/"S"/g; To: s/''/'S'/g; s/""

RE: Bugs and more Bugs.

2002-02-22 Thread Eric Mayers
st. =) Eric Mayers Software Engineer I Captus Networks > -Original Message- > From: Joedilson B. Azevedo [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 3:08 PM > To: [EMAIL PROTECTED] > Subject: Bugs and more Bugs. > > > Hi, I installed the BD mysql

RE: Bugs and more Bugs.

2002-02-22 Thread Gregory Junker
vedo; [EMAIL PROTECTED] > Subject: RE: Bugs and more Bugs. > > > did you follow the instructions in the link below? > > http://www.mysql.com/documentation/mysql/bychapter/manual_Inst > alling.htm > l#Post-installation > > > > -Original Message- > &g

RE: Bugs and more Bugs.

2002-02-22 Thread Gregory Junker
IL PROTECTED] > Subject: Bugs and more Bugs. > > > Hi, I installed the BD mysql and I am some problems. > > # /usr/local/mysql/bin/safe_mysqld & > It's ok. > > Here: > # mysqladmin password my_password > > /usr/local/mysql/bin/mysqladmin: connect t

Bugs and more Bugs.

2002-02-22 Thread Joedilson B. Azevedo
Hi, I installed the BD mysql and I am some problems. # /usr/local/mysql/bin/safe_mysqld & It's ok. Here: # mysqladmin password my_password /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' And when I

question on regexp/rlike -- bugs?

2001-12-01 Thread Cindy
For reference, the version I'm using is: mysql Ver 10.11 Distrib 3.23.23-beta, for pc-linux-gnu (i686) (which I am not in a position to upgrade ,tho I could always ask) I'm having some difficulties getting the REGEXP/RLIKE to work. I'm trying to match on what is basically "$name[0-9]*" (the na

4.0.0 on Linux: errmsg.sys not found; some docu bugs.

2001-11-22 Thread Axel Boldt
Hi, using the binary distribution mysql-4.0.0-alpha-pc-linux-gnu-i686, installed in the standard location /usr/local, running on Debian GNU Linux, I noticed the following buglets: INSTALL-BINARY and manual.txt both refer to bin/safe_mysqld which doesn't exist; they mean bin/mysqld_safe. --

Fwd: [PHP] might be bugs on PHP 4.06 or mySQL 4.0

2001-11-11 Thread Yamin Prabudy
-- Forwarded Message -- Subject: [PHP] might be bugs on PHP 4.06 or mySQL 4.0 Date: Fri, 9 Nov 2001 13:37:32 -0500 From: Yamin Prabudy <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>, PHP <[EMAIL PROTECTED]> Hi there, I just try

bugs / inconsistencies with date functions

2001-10-31 Thread Michael Widenius
Hi! >>>>> "oliver" == oliver <[EMAIL PROTECTED]> writes: >> Description: oliver> I have found some inconsistencies (one may call them bugs ;-) in the oliver> current MySQL 3.23 version. I tested this on Linux and Solaris 2.8 oli

bugs / inconsistencies with date functions

2001-10-30 Thread oliver
>Description: I have found some inconsistencies (one may call them bugs ;-) in the current MySQL 3.23 version. I tested this on Linux and Solaris 2.8 so this should not be platform specific... The result differs, if one uses the constant value "-0

Re: bugs for mysql 4.0

2001-10-24 Thread Michael Widenius
Hi! >>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Jeremy Zawodny writes: >> On Wed, Oct 17, 2001 at 12:18:28AM +0100, Mark Maunder wrote: >> > Where does one post (possible) bugs for mysql 4? >> > >> &g

Re: Two bugs with complex aggregate functions.

2001-10-19 Thread Sinisa Milivojevic
Philip Lijnzaad writes: > > > Upload your file to this directory : > > >ftp://support.mysql.com:/pub/mysql/secret > > Done. > > -- > The mail transport agent is not liable for any coffee stains in this message >

Re: Two bugs with complex aggregate functions.

2001-10-19 Thread Philip Lijnzaad
> Philip Lijnzaad writes: >> >> > Upload your file to this directory : >> >> >ftp://support.mysql.com:/pub/mysql/secret >> >> Done. > Sorry, it is 0 bytes long !! No it is not. Guest login ok, access restrictions apply. Logged in to support.mysql.com.

Re: Two bugs with complex aggregate functions.

2001-10-19 Thread Sinisa Milivojevic
OK, I have got a first one. I will try it out as soon as I find some time ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca,

Re: Two bugs with complex aggregate functions.

2001-10-19 Thread Philip Lijnzaad
> Upload your file to this directory : >ftp://support.mysql.com:/pub/mysql/secret Done. -- The mail transport agent is not liable for any coffee stains in this message - Philip Lijnzaad, [EMAIL PROTECTED] Europea

Re: Two bugs with complex aggregate functions.

2001-10-19 Thread Sinisa Milivojevic
Sorry for a typo. Upload your file to this directory : ftp://support.mysql.com:/pub/mysql/secret -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___

Re: Two bugs with complex aggregate functions.

2001-10-19 Thread Sinisa Milivojevic
Philip Lijnzaad writes: > > Yes, it also occurs for mysqld Ver 3.23.43 for pc-linux-gnu on i686. > > Please try and reproduce it using > http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz. > > > Philip > -- > The mail

Re: Two bugs with complex aggregate functions.

2001-10-19 Thread Philip Lijnzaad
> Philip Lijnzaad writes: >> >> Yes, it also occurs for mysqld Ver 3.23.43 for pc-linux-gnu on i686. >> >> Please try and reproduce it using >> http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz. > Please upload your file to: > ftp://support.mysql.com:/pub/mysql/secreat ncftp /pub/my

any bugs with 3.23.36 regarding COUNT(DISTINCT ?

2001-10-18 Thread Kevin Fries
Hi, we're trying to recommend that clients upgrade to version 3.23.36, and wanted to ensure that it's stable. Particularly, have there been any bugs regarding any bugs regarding the use of COUNT(DISTINCT since then? In other words, if our software performs a COUNT(DISTINCT co

Re: Two bugs with complex aggregate functions.

2001-10-18 Thread Philip Lijnzaad
> Please try our latest 3.23 version and see if problems still persists. Yes, it also occurs for mysqld Ver 3.23.43 for pc-linux-gnu on i686. Please try and reproduce it using http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz.

Re: Two bugs with complex aggregate functions.

2001-10-18 Thread Sinisa Milivojevic
HI! Please try our latest 3.23 version and see if problems still persists. There have been a few bug fixes since 3.23.32 regarding IF(). -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, F

Two bugs with complex aggregate functions.

2001-10-18 Thread Philip Lijnzaad
>Description: parsing/executing aggregates involving IF() statements. Everything needed to reproduce the bug available from http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz It's tested and reproduced on MySQL, version 3.23.32 on TrueUnix (two bugs) or version 3.

Bugs? Re: HAVING [cond...] problem

2001-06-14 Thread Cliff Daniel
Still doesn't work, I've even tried: HAVING ( Avg_Xmit = 12345 ) AND ( Samples >= 25 ) 19000 rows returned, none equalling 12345, but all have Samples >= 25. It's almost as if this became an OR. Cliff Gerald Clark <[EMAIL PROTECTED]> writes: > Have you tried: > HAVING > ( Avg_Xmit

Re: BDB tables bugs

2001-05-31 Thread Peter Zaitsev
Hello Michael, Thursday, May 31, 2001, 11:19:03 PM, you wrote: MW> Hi! >>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter>> Hello bugs, Peter>> mysql 3.23.38 Peter>> Linux diamond 2.4.4.SuSE-12-4GB-SMP #8 SMP Sat May 19

Re: winmysqladmin bugs

2001-04-17 Thread Miguel Angel Solórzano
At 17:38 17/04/2001 -0400, Gengxin Chen wrote: At this end of this week will release a new binary with some bugs fixed. >Description: > 1. doesn't save "my.ini" anywhere I didn't able to repeat this issue, on my machine doesn't have problem.

winmysqladmin bugs

2001-04-17 Thread Gengxin Chen
Description: 1. doesn't save "my.ini" anywhere 2. paths in "my.ini Setup" are all in Unix style (using "/") 3. "Table Columns" display in "Databases" are mis-aligned How-To-Repeat: just run it Fix: create c:\my.cnf mannually Synopsis: Submitter-I

Re: Bugs in 3.23.35

2001-03-22 Thread denis
Thanks Sinisa Milivojevic wrote: > denis writes: > > Any ETA on corrected RPM's? > > > > > > Should be out this weekend or in the beginning of next week. > > Regards, > > Sinisa > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Miliv

Re: Bugs in 3.23.35

2001-03-22 Thread Sinisa Milivojevic
denis writes: > Any ETA on corrected RPM's? > > Should be out this weekend or in the beginning of next week. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mail

Bugs in 3.23.35

2001-03-21 Thread denis
Any ETA on corrected RPM's? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubsc

Patches for two bugs in 3.23.35

2001-03-21 Thread Sinisa Milivojevic
Hi! There were two bugs reported in 3.23.35. First one deals with info not being displayed after table has been changed with UPDATE, LOAD DATA or similar. Here is patch for that bug: = sql_parse.cc 1.118 vs edited = *** /tmp/sql_parse.cc-1.118-23407 Wed Mar 21 00:58:38 2001

Bugs

2001-02-13 Thread Jonathan Berall
Hi, Attached is a bug and a question. Regards, Jonathan user id: jberall4691 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ SELECT t.trans_id, t.trans_no, DATE_FORMAT(t.tra

Re: bugs

2001-01-17 Thread Tibor Simko
Hello > INSERT INTO new_table (campo1,campo2) SELECT (campo1,campo2) FROM old_table ^ ^ The 2nd set of parentheses should not be there. > Mysql dont suport sub-querys yet, we will be waiting It is not a subquery issue, see the section 7

RE: bugs

2001-01-17 Thread Gabriel Carbone
Mysql no soporta sub-querys todavia, seguiremos esperando Mysql dont suport sub-querys yet, we will be waiting -Mensaje original- De: Erick Tomás Izquierdo Cerra [mailto:[EMAIL PROTECTED]] Enviado el: Wednesday, January 17, 2001 6:17 AM Para: [EMAIL PROTECTED] Asunto: bugs no puedo

  1   2   >