Is it Bug in Mysql?

db and can't create database but when i tried creating db?dbname the database was created though it didn't allow the user to create any other database. I created this database using phpmyadmin. Is it a bug in mysql? In case i am not using special character '_' (underscore), I am no

bug in mysql with COUNT() in subqueries

guys, strange things happen when using COUNT() in subqueries. even the use of HAVING in a SELECT statement turns up a weired result, as it should work on the result set and should be filtered while rows are returned to the client. (you can find the selects and stuff in a more readable way on http

Re: bug in MySQL 5?

Octavian Rasnita wrote: From: "Gleb Paharenko" <[EMAIL PROTECTED]> Hello. In my opinion, it is not a bug. REPLACE has returned the sum of affected rows - one was deleted, and one was inserted. See: http://dev.mysql.com/doc/refman/5.1/en/replace.html Thank you. I have seen that's the true. I

Re: bug in MySQL 5?

From: "Gleb Paharenko" <[EMAIL PROTECTED]> > Hello. > > In my opinion, it is not a bug. REPLACE has returned the sum > of affected rows - one was deleted, and one was inserted. See: > http://dev.mysql.com/doc/refman/5.1/en/replace.html > > Thank you. I have seen that's the true. Is there any

Re: bug in MySQL 5?

Hello. In my opinion, it is not a bug. REPLACE has returned the sum of affected rows - one was deleted, and one was inserted. See: http://dev.mysql.com/doc/refman/5.1/en/replace.html Octavian Rasnita wrote: > Hi, > > I have tried: > > mysql> create table z(id int unsigned not n

bug in MySQL 5?

Hi, I have tried: mysql> create table z(id int unsigned not null primary key, first_name varchar(20), last_name varchar(20)); Query OK, 0 rows affected (0.06 sec) mysql> insert into z values(1, 'John', 'Smith'), (2, 'George', 'Washington'); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplica

Re: possible bug in mysql 5.0.13

Peter Brawley <[EMAIL PROTECTED]> wrote on 10/12/2005 04:27:18 PM: > James, > > Both ... > > SELECT ... > FROM a, b LEFT JOIN c ON a.x=c.y > > and > > SELECT ... > FROM a > LEFT JOIN B USING (x ) > LEFT JOIN c ON a.x=c.y > > work up to and including version 5.0.10, not in 5.

Re: possible bug in mysql 5.0.13

James, Both ...   SELECT ...   FROM a, b LEFT JOIN c ON a.x=c.y and   SELECT ...   FROM a     LEFT JOIN B USING (x )     LEFT JOIN c ON a.x=c.y work up to and including version 5.0.10, not in 5.0.11, 12 or 13. http://bugs.mysql.com/bug.php?id=13832 reports... "The two statements below

Re: possible bug in mysql 5.0.13

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > SELECT... > FROM items i > INNER JOIN nams.netids n > INNER JOIN ... > ... > Does the problem remain? If it goes away, this would be useful information > to include in your bug report. Thank you for the suggestion, but

Re: possible bug in mysql 5.0.13

James Black <[EMAIL PROTECTED]> wrote on 10/12/2005 02:06:26 PM: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Peter Brawley wrote: > > James, > > > > You can reproduce that error by writing ... > > > > SELECT ... > > FROM a, b INNER JOIN c ON a.x=c.y > > > > The error goes away if

Re: possible bug in mysql 5.0.13

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter Brawley wrote: > James, > > You can reproduce that error by writing ... > > SELECT ... > FROM a, b INNER JOIN c ON a.x=c.y > > The error goes away if you instead write ... > > SELECT ... > FROM b, a INNER JOIN c ON A.x=c.y > > so you

Re: possible bug in mysql 5.0.13

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter Brawley wrote: > James, > > You can reproduce that error by writing ... > > SELECT ... > FROM a, b INNER JOIN c ON a.x=c.y > > The error goes away if you instead write ... > > SELECT ... > FROM b, a INNER JOIN c ON A.x=c.y I will t

Re: possible bug in mysql 5.0.13

James, You can reproduce that error by writing ...   SELECT ...   FROM a, b INNER JOIN c ON a.x=c.y The error goes away if you instead write ...   SELECT ...   FROM b, a INNER JOIN c ON A.x=c.y so you might try swapping FROM items i , nams.netids n PB - [EMAIL PROTECTED] wrote:

re: possible bug in mysql 5.0.13

James Black <[EMAIL PROTECTED]> wrote on 10/12/2005 09:57:51 AM: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Due to the complexity of my query I don't know how to get this down to a > simple test case to demonstrate the error. > > This works under mysql 4.1.8 btw, so it is failing due

re: possible bug in mysql 5.0.13

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Due to the complexity of my query I don't know how to get this down to a simple test case to demonstrate the error. This works under mysql 4.1.8 btw, so it is failing due to a change introduced recently. It also worked under mysql 5.0.9, but I haven'

InnoDB tablespace fragmentation bug in MySQL 4.0.20

Hi, ( hopefully a MySQL developer sees this at some point! ) I am giving InnoDB a good workout before rolling it out onto production systems, and found a bug in the way the tablespace gets fragmented when doing basic add/drop of indexes. Below my sig is a series of SQL commands I used to replicate

Potential crashing bug in MySQL 4.0.19

, a potential crashing bug in MySQL 4.1 was found and confirmed to affect the 4.0.19 release as well. This happened just shortly before the release was publicly announced and published on the 4.0 download pages at http://dev.mysql.com/. See Bug #3596 for details (it was initially reported against

bug in Mysql 4.1

We have found a bug in MySQL 4.1 (tested on Win2k machine): create database testdate; use testdate; create table a (id int not null auto_increment, dt date, primary key(id)); insert into a (dt) values (''); insert into a (dt) values ('2004-05-06'); select * from a where dt

Re: Bug in MySQL with Correlated Subqueries?

Are you saying this is a bug which has already been fixed for the next release? In any case, it may be worth noting that the manual says correlated subqueries "are inefficient and likely to be slow. Rewriting the query as a join might improve performance."

Re: Bug in MySQL with Correlated Subqueries?

At 13:59 27/3/2004, Ed Smith wrote: Hi, Below the results from a server built with BK 4.1 tree 3 days ago: C:\mysql\bin>mysqld --standalone --console --ansi --default-table-type=innodb 040328 0:36:59 InnoDB: Started; log sequence number 0 43634 mysqld: ready for connections. Version: '4.1.2-alpha

Bug in MySQL with Correlated Subqueries?

MySQL 4.1.1-alpha incorrectly computes select-list correlated subqueries. See the explanation of the problem below. Is this a known problem? Thanks! Consider the following schema and data: CREATE TABLE person (pid INTEGER, name CHAR(5)); CREATE TABLE phone (pid INTEGER, num CHAR(10)); INSERT

Weird bug in MySQL and Mac OS X 10.3

I've had some very weird issues that I've posted about here in the past, but no one was able to help. I posted a bug report on mysql.com and have received some advice on how to suppress the problems I was having. The problem seems to be exploited when running a slave server on OSX 10.3.x; alt

Re: BUG IN MYSQL

At 17:16 3/1/2004 -0700, Richard S. Huntrods wrote: Hi, I also checked this problem with my main database on a Solaris box (4.0.5a), and the problem did not occur. In this case the bug is a Windows MySQL server specific issue. I will upgrade to 4.0.17. Please do, it is the only solution for. --

Re: BUG IN MYSQL

ete/insert" to "BUG IN MYSQL". Cheers... I've distilled the problem I'm having with DELETE/INSERT to an even simpler test case. Here's the SQL - it can be used with any database, not just the special "expdb" I created. I run

Re: BUG IN MYSQL

De : Richard S. Huntrods [mailto:[EMAIL PROTECTED] Envoyé : Saturday, January 03, 2004 6:05 PM À : [EMAIL PROTECTED] Objet : BUG IN MYSQL I've submitted this problem three times now, and been ignored all three times. http://bugs.mysql.com/ I guess bugs are simply not popular. Since th

Re: BUG IN MYSQL

is 100% repeatable, I will now escallate it from "problem with delete/insert" to "BUG IN MYSQL". I tested with the latest release package 4.0.17 and verify that your reported behavior is already fixed. I guess that this case is the same as reported in the below bug report: htt

Re: BUG IN MYSQL

I also ran the test, using MySQL 4.0.16, for apple-darwin6.6 (powerpc) on a Mac iBook G4 w/Panther and got no errors from mysqlcheck. You might try using mysqlbug to compose the bug report: http://www.mysql.com/doc/en/Bug_reports.html Hassan Schroeder wrote: Richard S. Huntrods wrote: I've

Re: BUG IN MYSQL

llate it from "problem with delete/insert" to "BUG IN MYSQL". I tested with the latest release package 4.0.17 and verify that your reported behavior is already fixed. I guess that this case is the same as reported in the below bug report: http://bugs.mysql.com/bug.php?id=1397

Re: BUG IN MYSQL

Richard S. Huntrods wrote: I've submitted this problem three times now, and been ignored all three times. I guess bugs are simply not popular. Since the problem described below is 100% repeatable, Uh, well, maybe not quite :-) I've distilled the problem I'm having with DELETE/INSERT to an even

RE: BUG IN MYSQL

> -Message d'origine- > De : Richard S. Huntrods [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 6:05 PM > À : [EMAIL PROTECTED] > Objet : BUG IN MYSQL > > > I've submitted this problem three times now, and been ignored > all th

BUG IN MYSQL

I've submitted this problem three times now, and been ignored all three times. I guess bugs are simply not popular. Since the problem described below is 100% repeatable, I will now escallate it from "problem with delete/insert" to "BUG IN MYSQL". Cheers... I

Re: Weird bug in MySQL?

Michael Bacarella <[EMAIL PROTECTED]> wrote: > We're running MySQL 3.23.56 w/ InnoDB on Red Hat Linux 8.0, > compiled natively with bundled gcc: > > # gcc -v > Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs > Configured with: ../configure --prefix=/usr --mandir=/usr/share/man > -

Weird bug in MySQL?

We're running MySQL 3.23.56 w/ InnoDB on Red Hat Linux 8.0, compiled natively with bundled gcc: # gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=p

Re: Bug in MYSQL replication

On 31 Mar 2003 at 16:39, Dyego Souza do Carmo wrote: > this is a bug... because i modify the database escribaupdate from > database mysql and this is not logged... Yes, it is a bug, but you can work around it by using replicate-wild- do-table. See the documentation for the replicate-do-db option

Re: Bug in MYSQL replication

You may consider it a bug, but it is the documented behavior. Dyego Souza do Carmo wrote: I'm using MySQL/InnoDB 4.0.12 I set replication to replicate only database escribaupdate... The bug is: I connect in database escribaupdate and run: delete from escriba_autorizacao; go to shell and execut

Bug in MYSQL replication

I'm using MySQL/InnoDB 4.0.12 I set replication to replicate only database escribaupdate... The bug is: I connect in database escribaupdate and run: delete from escriba_autorizacao; go to shell and execute: scribthree:/database/log-bin# /usr/local/mysql4/bin/mysqlbinlog logbin.001 # at 4 #03

Possible bug in mysql 4.0.12 Install for Win32

To replicate: 1. Start with a machine running Pentium 4, Windows XP Pro. 2. Map a "New Network Place" to: \\somecomputer\C$ Where \\somecomputer contains an install, in the root directory, (i.e. C:\mysql,) of mysql already. The remote install in this case was version 3.23.56. 3.

bug?? in MySQL Control Center 0.8.10-beta

Hello, MySQL database connecting to: 3.22.32 when I select * from a table (with no primary key), the results are displayed. I attempt to use the GRID to update a field of a record. When I try to change it, I get the following error: ERROR 1064: You have an error in your SQL syntax near 'LIMIT 1

May be bug in MySQL Table!!!

Dear Sir/Madam, Here I've attached one Table of MySQL, named as "M_Filed". When I am trying to select all tables from VB, it gives me following error Run-time error '-2147467259 (80004005)': [TCX][MyODBC]Got error 127 from table handler Waiting for your reply. Regards, Shripal.

Re: gethostbyname_r() (un)bug in MySQL source build

TWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Michael Bacarella" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 4:23 PM Subject: gethost

gethostbyname_r() (un)bug in MySQL source build

Hope everyone's having fun at LinuxWorld. I couldn't find any discussion of a solution for this (according to Google, mysql.com search), other than at least a dozen reports from people having trouble with it. The bug is that the proper error is not reported and at least I was sent on a wild goos

Bug in MySQL Control Center 0.8.8 Beta Windows

I have come across the following bug in MySQL Control Center 0.8.8 Beta for Windows: When you have two databases that are identicle (ie, a master and a slave) and you connect to both databases (one on a server and one on the local machine) when you open a table listing for one database and open a

Re: May be bug in MySQL 4

t: Tuesday, January 14, 2003 9:37 PM Subject: May be bug in MySQL 4 > Hi, > There might be a bug in mysql 4 (tested on 4.0.8-gamma and 4.0.9-gamma) when > combining simple arithmetic operations and date conversion > > I have a table with the following structure > date_col date

May be bug in MySQL 4 (addition)

;Dobromir Velev" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 21:37 Subject: May be bug in MySQL 4 > Hi, > There might be a bug in mysql 4 (tested on 4.0.8-gamma and 4.0.9-gamma) when > combining simple arithmetic operations and date convers

May be bug in MySQL 4

Hi, There might be a bug in mysql 4 (tested on 4.0.8-gamma and 4.0.9-gamma) when combining simple arithmetic operations and date conversion I have a table with the following structure date_col date -00-00 int_col tinyint(3) unsigned This is what happens when I try to run a query like the one

Bug in MySql 3.23.53 ?

Hi, Seems that mySql sometime write Querys to Log but does not execute them. I found folling in the MySql Log-File. Comments made by me are signed with "->". Maybe some one has a solution for that ? # at 5636748 #021216 15:27:38 server id 1 Intvar SET INSERT_ID = 189612; # at 5636770 #02121

Fw: I've found a bug in MySQL.

Dear Sir, I've found a bug in the function "mysql_real_escape_string". For example, i use this function like below: mysql_real_escape_string(auth_sql_server, escapeUser, user, strlen(user)); now user = "cHm%Ilu!", but escapeUser equals to "Chm134739000!"(random), instead of "cHm

Comment-parsing bug in MySQL

>Description: Single quotes (') in comments may cause syntax errors. >How-To-Repeat: Run this MySQL code from a file, including the comment (running from the MySQL shell will also expose the bug, but you will not be able to complete the command without

Re: Bug in MySQL privilege system?

Harald Fuchs writes: > [This is for MySQL 4.0.1 alpha on Linux 2.2.18-SMP, if it should matter] > > Either I misunderstand the manual, or I found a small bug. Consider > the following command sequence: > > mysql -e 'CREATE DATABASE t1' > mysql t1 -e 'CREATE TABLE t1 (id INT)' > mysql -e 'G

Re: AW: Bug in MySQL API ?!?

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >> mysql_fix_pointers(mysql, &tmp_mysql); /* adjust connection pointers */ >> ... >> this method contains (unlike version known to me) function call >mysql_fix_pointers(), which probably handles pointers of MYSQL struct.

Re: AW: Bug in MySQL API ?!?

Skriniar Gregor writes: > Hello, > > first of all thanks for your comment. > > I am sorry that I discussed this problem with Sinisa in private (not via >[EMAIL PROTECTED]). So, once more I would like to summarize it: > My opinion is that there is/(at least) was a bug in your API because: >

AW: Bug in MySQL API ?!?

t; Von: Michael Widenius [SMTP:[EMAIL PROTECTED]] > Gesendet am: Sonntag, 10. Februar 2002 19:19 > An: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Betreff: Re: Bug in MySQL API ?!? >=20 >=20 > Hi! >=20 > I have a couple of small comm

Re: Bug in MySQL API ?!?

Hi! I have a couple of small comments to Sinisa answer. > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Skriniar Gregor writes: >> Dear all, >> >> I experienced some problems with using MySQL API: >> My problem is that if I don't use database a long time it is disconn

Re: Bug in MySQL API ?!?

Hi! I have a couple of small comments to Sinisa answer. > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Skriniar Gregor writes: >> Dear all, >> >> I experienced some problems with using MySQL API: >> My problem is that if I don't use database a long time it is disconn

Re: Bug in MySQL API ?!?

At 15:45 +0100 2/4/02, Skriniar Gregor wrote: >Dear all, > >I experienced some problems with using MySQL API: >My problem is that if I don't use database a long time it is disconnected and That's how it's supposed to behave. What's the bug? If your application really needs to hold the connectio

Re: Bug in MySQL API ?!?

Skriniar Gregor writes: > Dear all, > > I experienced some problems with using MySQL API: > My problem is that if I don't use database a long time it is disconnected and when I >try to connect again at first I use method mysql_ping(), which reopens connection and >that's the point. Please see n

Bug in MySQL API ?!?

Dear all, I experienced some problems with using MySQL API: My problem is that if I don't use database a long time it is disconnected and when I try to connect again at first I use method mysql_ping(), which reopens connection and that's the point. Please see next code of MySQL API: static my_

Re: SupportWizard: bug in mysql: "ALTER TABLE CHANGE COLUMN A" can damage autoincrement column B!

Max writes: > >Description: > I am using russian values(cp1251 charset) for ENUM items. > Here is an example how to damage ID field by query to change > F_Category Enum. > >How-To-Repeat: > # Create tableA with ID field. > CREATE TABLE tableA ( > ID int(11) NOT NULL auto

SupportWizard: bug in mysql: "ALTER TABLE CHANGE COLUMN A" can damage autoincrement column B!

>Description: I am using russian values(cp1251 charset) for ENUM items. Here is an example how to damage ID field by query to change F_Category Enum. >How-To-Repeat: # Create tableA with ID field. CREATE TABLE tableA ( ID int(11) NOT NULL auto_increment, F_ReportID b

bug in mysql-test-run script (solaris)

>Description: mysql-test-run script uses the test [ -e "$BASEDIR/client/.libs/mysqltest" ] (line 276 ) since the script uses /bin/sh, and this test [ -e ] is not implemented in /bin/sh on solaris, the mysql-test-run script fails & exits >How-To-Repeat: run mysql-test-

Re: Bug in MySQL-4.0

Fournier Jocelyn [Presence-PC] writes: > Hi, > > I caught a bug in MySQL-4.0, but I don't know how to reproduce it ;) > > Here is the description : > > mysqld got signal 11; > This could be because you hit a bug. It is also possible that this binary > or on

Re: Re[4]: Bug in Mysql access rights ?

BAUMEISTER Alexandre writes: > Sinisa, > > >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD >'' | > >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' > | > >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO

Re: Re[6]: Bug in Mysql access rights ?

BAUMEISTER Alexandre writes: > Sinisa, > > >> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD >'' | > >> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' > | > >> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON cont

Re[6]: Bug in Mysql access rights ?

Sinisa, >> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD >'' | >> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' >| >> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%' >

Re[4]: Bug in Mysql access rights ?

Sinisa, >> mysql> show grants for news@'192.168.1.%'; >> >++ >> | Grants for [EMAIL PROTECTED]% > | >> >+---

Re: Re[2]: Bug in Mysql access rights ?

BAUMEISTER Alexandre writes: > Sinisa, > > mysql> show grants for news@'192.168.1.%'; > >++ > | Grants for [EMAIL PROTECTED]% >| > >+

Re[2]: Bug in Mysql access rights ?

Sinisa, >> What's happening ? SM> Your story is quite strange. SM> Can you run SHOW GRANTS on both user@localhost and user@remoteIP and SM> see what they are showing ?? I had to make my applications work, so I removed the lines in 'user' and 'db' tables for the remote IP. This solved

Re: Bug in Mysql access rights ?

BAUMEISTER Alexandre writes: > Bonjour, > > What's happening ? > > Regards, > Alex. Your story is quite strange. Can you run SHOW GRANTS on both user@localhost and user@remoteIP and see what they are showing ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr

Bug in Mysql access rights ?

Bonjour, I have a problem with Mysql-3.23.39 and users access rights. It's the second time I notice this problem since I installed .39 on two of my servers. But yesterday, the bug was even more flagrant. I had a user which had all rights on a database when connecting from localhos

RE: Possible Bug in mysql 3.23.38

I would like to note that bug reports should only be sent out if you are using the latest version, which now is 3.23.39. --On Friday, June 15, 2001 17:37 -0600 Chris Bolt <[EMAIL PROTECTED]> wrote: >> After creating a new database, I ran: >> >> update user set password = 'SomeJunk' where user

Re: Possible Bug in mysql 3.23.38

Hello Simon. On Fri, Jun 15, 2001 at 05:08:18PM -0400, [EMAIL PROTECTED] wrote: > Could not find a bug report form. So I am telling y'll... > > Platform: FreeBSD 4.3 (I do not think it matters) > > After creating a new database, I ran: > > update user set password = 'SomeJunk' where user = '

RE: Possible Bug in mysql 3.23.38

> After creating a new database, I ran: > > update user set password = 'SomeJunk' where user = 'root'; > > This inserts the string 'SomeJunk' literally into the database, > unencrypted. This is SQL expected but the result is a database > lockout (not to mention the security breach of having the c

Re: Possible Bug in mysql 3.23.38

PLEASE read the manual. you need to set password = password('SomeJunk') And the bug report form can be obtained by running mysqlbug, the instructions for which are also found in the manual. Thank you. j- k- On Friday 15 June 2001 13:08, Simon Shapiro wrote: > Could not find a bug r

Possible Bug in mysql 3.23.38

Could not find a bug report form. So I am telling y'll... Platform: FreeBSD 4.3 (I do not think it matters) After creating a new database, I ran: update user set password = 'SomeJunk' where user = 'root'; This inserts the string 'SomeJunk' literally into the database, unencrypted. This is S

Re: Bug in Mysql C API?

Rafael Martinez writes: > Hei > > If I send a SELECT sql-request to my DB and this request returns an > "Empty set" ... > > mysql_num_rows(MYSQL_RES *result) returns 0 - This is OK > but mysql_num_fields(MYSQL_RES *result) returns 1 - This is not OK ;-) > > Why? Am I missing anyth

Bug in Mysql C API?

Hei If I send a SELECT sql-request to my DB and this request returns an "Empty set" ... mysql_num_rows(MYSQL_RES *result) returns 0 - This is OK but mysql_num_fields(MYSQL_RES *result) returns 1 - This is not OK ;-) Why? Am I missing anything? Sincerely Rafael Martinez

Re: query max(length(column)) HANGS or there is a BUG in Mysql 3.23.33

More interesting rezults, after runnig some check/repair/analyze commands in sequence on the same table: mysql> repair table http_refer extended; +-++--+--+ | Table | Op | Msg_type | Msg_text | +-++--+--

query max(length(column)) HANGS or there is a BUG in Mysql 3.23.33

Hi, I'm a bit desperate and have some questions to ask. I'm working with my own compiled server 3.23.33 on SuSe 7.0 I have table: mysql> desc test.http_refer; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra

Re: Bug in MySQL 3.22 ?

gro if you use underscore instead. O | O \/ - Original Message - From: "Johnny Withers" <[EMAIL PROTECTED]> To: "Mysql-List" <[EMAIL PROTECTED]> Sent: Monday, March 05, 2001 23:35 Subject: Bug in MySQL 3.22 ? > the following is quite odd, maybe i&#x

Bug in MySQL 3.22 ?

the following is quite odd, maybe i'm doing something wrong.. mysql> drop database planhouse-broke; ERROR 1064: You have an error in your SQL syntax near '-broke' at line 1 mysql> show databases; +-+ | Database| +-+ | jeffdavis | | kermit | |

CREATE/DROP DATABASE bug in mysql client

>Description: The manual says that starting from MySQL 3.23.6, any combination of characters is allowed for a database name (excluding '/', ASCII(0) and ASCII(255)). I created database that name consist only of numbers using mysqladmin tool, but I was unable to drop it using mysql command

Re: binary bug in mysql 3.23.30-gamma

'varchar(16) binary' works in 3.22 and tinyblob works in 3.23. by work I mean I can insert hexidecimal numbers into the field. I am basically treating it as an integer field. I can store 16 byte numbers in the field and in the case of varchar(16) binary on mysql 3.22 I could store a 32 character

Re: binary bug in mysql 3.23.30-gamma

question is if they are suppose to be the same thing why don't they work the same... Also both work in 3.22 so I guess I am trying to figure out is this a bug in mysql and how do I get it listed as a bug in mysql if there is not now a solution. "Carsten H. Pedersen" wrote: >

Re: binary bug in mysql 3.23.30-gamma

inserting 0x1 into a CHAR field? - Original Message - From: "Tommie Jones" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, February 07, 2001 22:18 Subject: Re: binary bug in mysql 3.23.30-gamma > Bina

RE: binary bug in mysql 3.23.30-gamma

s instead, if > > there is an error, which in your case, would be NULL. What you > want instead > > is an integer column. > > > > - Original Message ----- > > From: "Tommie Jones" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > &g

Re: binary bug in mysql 3.23.30-gamma

- > From: "Tommie Jones" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, February 07, 2001 3:30 > Subject: binary bug in mysql 3.23.30-gamma > > > In the process of converting over to 3.23.30-gamma from 3.22 > > > > wheneve

Re: binary bug in mysql 3.23.30-gamma

L PROTECTED]> Sent: Wednesday, February 07, 2001 3:30 Subject: binary bug in mysql 3.23.30-gamma > In the process of converting over to 3.23.30-gamma from 3.22 > > whenever I set the field to a binary field to a value it stores it in > the database as zero. > > Does anyone ha

binary bug in mysql 3.23.30-gamma

In the process of converting over to 3.23.30-gamma from 3.22 whenever I set the field to a binary field to a value it stores it in the database as zero. Does anyone have any suggestions. I am having a problem with the binary data type... Here is the log to demonstrate. ---

binary bug in mysql 3.23.30-gamma

In the process of converting over to 3.23.30-gamma from 3.22 It appears that a table with field 'key varchar(16) binary' as a primary key. Whenever I write a record to this table and then do a select the value of the field seems to be zero. I do a 'select * from table where key=0x0' I get all t

Re: Bug in MySQL TRIM() Function! ?

Hi! > "Matt" == Matt Wagner <[EMAIL PROTECTED]> writes: Matt> Paul Wisén writes: >> This works: >> mysql> select trim('foo' FROM 'foobaar'); >> ++ >> | trim('foo' FROM 'foobaar') | >> ++ >> | baar | >> +-

Re: Bug in MySQL TRIM() Function! ?

I think it would have to be considered a simple bug. If you're not convinced by the 'both' example he gave, here's one that's even more obviously a bug: mysql> select trim(leading 'foo' from 'foo'); ++ | trim(leading 'foo' from 'foo') |

Re: Bug in MySQL TRIM() Function! ? / Set element solution

I guess I can replace it with a null string.. select REPLACE('foo', 'foo', ''); Works just fine! Thanx! Well, then my SET problems is fixed. I wanted a way to add, replace or remove elements in a set without doing it with any extra code. fyi then, this could come handy. To: Add an element

Re: Bug in MySQL TRIM() Function! ?

Hi, >> This works: >> >> mysql> select trim('foo' FROM 'foobaar'); >> ++ >> | trim('foo' FROM 'foobaar') | >> ++ >> | baar | >> ++ >> 1 row in set (0.00 sec) >> >> This does not work: ! >>

Re: Bug in MySQL TRIM() Function! ?

Paul Wisén writes: > This works: > > mysql> select trim('foo' FROM 'foobaar'); > ++ > | trim('foo' FROM 'foobaar') | > ++ > | baar | > ++ > 1 row in

Bug in MySQL TRIM() Function! ?

This works: mysql> select trim('foo' FROM 'foobaar'); ++ | trim('foo' FROM 'foobaar') | ++ | baar | ++ 1 row in set (0.00 sec) This do