Yes, this has been reported on this list a couple times already.
Really baffling how this one made it out of QA.
Josh
On Thu, 23 Dec 2004 21:43:27 +0200 (EET)
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
SQL
Hello, All!
IMHO this the bug in 4.1.8 to create library shared libraries
Hi!
http://bugs.mysql.com/bug.php?id=7496
A critical bug found: if one uses the 4.1 my.cnf option
innodb_file_per_table
to create tables, and some of the secondary index records are inserted to
the InnoDB 'insert buffer', then after a normal mysqld shutdown InnoDB loses
all those secondary index
Eric Bergen wrote:
Jay,
Are you using the replicate-do-db option on the slave? This option
relies on 'use' being set correctly when the query is issued. A quote
from the manual explains it better than I can:
Tells the slave to restrict replication to statements where the
default database (that
but i stripped down to the point of failing. The
failing factor is when i use content_review_site as
a,site_rating_factors as b (not a cross database but a cross table
query).
I wonder if you're running into this bug
http://bugs.mysql.com/bug.php?id=7011
We saw it on 4.0.22 and Mac OS X. MySQL
I have a problem with an update query not replicating through to the slave.
The query is update content_review_site as a,site_rating_factors as b set
a.overall_rating = 77 where a.content_id=243
Version : 4.0.22
OS : Linux X86
How to replicate the error.
CREATE TABLE content_review_site (
Jay,
Are you using the replicate-do-db option on the slave? This option
relies on 'use' being set correctly when the query is issued. A quote
from the manual explains it better than I can:
Tells the slave to restrict replication to statements where the
default database (that is, the one
Dec 2004 22:01:37 +0200, Heikki Tuuri [EMAIL PROTECTED] wrote:
Alejandro,
- Original Message -
From: Alejandro D. Burne [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 03, 2004 7:20 PM
Subject: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode
tables
http://www.innodb.com/order.php
- Original Message -
From: Alejandro D. Burne [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 2:40 PM
Subject: Re: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode:
13)
Heikki I do it, in my.cnf
Hello.
The value of wait_timeout is initialized from wait_timeout variable or
from the global interactive_timeout variable, depending on the type of client.
Put interactive_timeout=10 in your config file. See:
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
Andrew
After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't start with error:
Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)
I think it's a problem with innodb, if I add skip-innodb on my.cnf
mysqld starts up:
041203 14:04:01 mysqld started
041203 14:04:01 [Warning] Asked for 196608
Alejandro,
- Original Message -
From: Alejandro D. Burne [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 03, 2004 7:20 PM
Subject: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)
After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't
the same, no different settings, only the MySQL AB
client dll was exchanged.
We would appreciate any feedback as to if this is in fact a bug, or some MySQL
setting causing this behavior or if this is something specific to our MySQL
4.1.7 installation (i.e. if no one else experience these symptoms
Hi, All
It's happen after upgrade from 3.23.46.
Just look at this set of queries
mysql select 1 or null;
+---+
| 1 or null |
+---+
| 1 | - Ok
+---+
1 row in set (0.00 sec)
mysql create table a ( a int not null );
Query OK, 0 rows affected (0.00 sec)
mysql select
Hello Vlad,
The reason is: If one or both arguments are NULL, the result of the
comparison is NULL, except for the NULL-safe = equality comparison
operator.
Thereore, or NULL in your select statement will always returned NULL.
You can find all the rules for comparaison at URL:
Bernard Clement wrote:
Hello Vlad,
The reason is: If one or both arguments are NULL, the result of the
comparison is NULL, except for the NULL-safe = equality comparison
operator.
Thereore, or NULL in your select statement will always returned NULL.
You can find all the rules for comparaison
Vlad Shalnev wrote:
[...]
OR
||
Logical OR. Evaluates to 1 if any operand is non-zero, to NULL if any
operand is NULL, otherwise 0 is returned.
This definition (from the manual) is self-contradicting: 1 OR NULL
should evaluate to 1 because any operand is non-zero, but it should
also evaluate to
Hi
This definition (from the manual) is self-contradicting: 1 OR NULL
should evaluate to 1 because any operand is non-zero, but it should
also evaluate to NULL because any operand is NULL.
Why self-contradicting ? If you apply this rule as described ( from left to
right ) you will get correct
Hi!
On Dec 02, Vlad Shalnev wrote:
Looks like a bug.
Could you submit a bugreport at http://bugs.mysql.com ?
It happens after upgrade from 3.23.46.
mysql create table a ( a int not null );
Query OK, 0 rows affected (0.00 sec)
mysql select min( a ) is null or null from
Vlad Shalnev wrote:
* from the manual:
Logical OR. Evaluates to 1 if any operand is non-zero, to NULL if any
operand is NULL, otherwise 0 is returned.
* Roger Baklund:
This definition (from the manual) is self-contradicting: 1 OR NULL
should evaluate to 1 because any operand is non-zero, but it
.
Therefore, Vlad has found a bug:
mysql CREATE TABLE nullbug (a INT NOT NULL);
Query OK, 0 rows affected (0.01 sec)
mysql SELECT MIN(a), MIN(a) IS NULL, MIN(a) IS NULL OR NULL FROM nullbug;
++++
| MIN(a) | MIN(a) IS NULL | MIN(a) IS NULL OR NULL
OR should behave based on the the manual's poor choice of wording.
I agree.
Therefore, Vlad has found a bug:
I agree again. :)
This is (as I see it) a documentation issue, I was not trying to say
that Vlad was wrong.
While we're at it: the term non-zero... what does it mean? As we all
know
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
This definition (from the manual) is self-contradicting: 1 OR NULL
should evaluate to 1 because any operand is non-zero, but it should
also evaluate to NULL because any operand is NULL.
URL:
Roger Baklund wrote:
snip
This is (as I see it) a documentation issue, I was not trying to say
that Vlad was wrong.
Right, that's why I'm copying the docs list.
While we're at it: the term non-zero... what does it mean? As we
all know, NULL != 0, and 0 == zero, consequently NULL must be
I upgraded from 5.01 to 5.02 and now I am getting the error localhost is not
allowed to connect to this MySQL server. What should I do, root cannot
connect a well. I'm currently using win32 and have old-passwords in my.cnf
Thanks
--
MySQL General Mailing List
For list archives:
At 11:42 -0500 12/2/04, Michael Stassen wrote:
Roger Baklund wrote:
snip
This is (as I see it) a documentation issue, I was not trying to
say that Vlad was wrong.
Right, that's why I'm copying the docs list.
I updated the description to account for the cases when there are 1 or 2
NULL operands.
Hi all,
In version 4.0.18 when setting the wait_timeout variable to 10 in
my.cnf, it seems to work when looking at 'mysqladmin variables' as it is
indeed showing up as 10.
However, when in the mysql client and I do a 'show variables' it is
showing up with the default value of 28800.
I'm certain
Sergei Golubchik wrote:
Hi!
On Dec 02, Vlad Shalnev wrote:
Looks like a bug.
Could you submit a bugreport at http://bugs.mysql.com ?
I've submitted a bugreport.
Downgrade to 3.23 and wait for this problem solving.
Thanks for all
It happens after upgrade from 3.23.46.
mysql create table
Hi Vlad !
Why not using
select (select min( a ) is null from a) or null;
as a workaround ?
Regards,
Jocelyn
- Original Message -
From: Vlad Shalnev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 03, 2004 7:01 AM
Subject: Re: Comparing bug in 4.1.7
Sergei
This is MySQL 4.1.5-gamma-max on Darwin Kernel Version 7.6.0 (OS X
v10.3.6), installed via the Mac OS X installer.
mysql select gid, fbin from fdata where gid = 3557 order by fbin;
+--+--+
| gid | fbin |
+--+--+
| 3557 | 1000.007086 |
| 3557 |
row in set (0.00 sec)
==CUT
DROP DATABASE IF EXISTS bug;
create database bug;
use bug;
CREATE TABLE AULE (
AUL_ID int(11) NOT NULL auto_increment,
PRIMARY KEY (AUL_ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE OCCUPAZIONI (
OCC_ID int(11) NOT NULL
SELECT TYTUL FROM tKsidata
WHERE MATCH (TYTUL) AGAINST (space)
ORDER BY TYTUL
TYTUL
Shaping Space 2ed
National Air Space Museum
Light Space
Free Space Architecture
Does Economics Space Matter ?
Economies of Signs Space
Industry Space Competition Contribution of Economists of P
Przemyslaw Popielarski [EMAIL PROTECTED] wrote:
SELECT TYTUL FROM tKsidata
WHERE MATCH (TYTUL) AGAINST (space)
ORDER BY TYTUL
TYTUL
Shaping Space 2ed
National Air Space Museum
Light Space
Free Space Architecture
Does Economics Space Matter ?
[...]
...and compiling own binary from
SELECT TYTUL FROM tKsidata
WHERE MATCH (TYTUL) AGAINST (space)
ORDER BY TYTUL
TYTUL
Shaping Space 2ed
National Air Space Museum
Light Space
Free Space Architecture
Does Economics Space Matter ?
Economies of Signs Space
Industry Space Competition Contribution of Economists of P
Money Space
Fortunately there is function COALESCE() that will return the first
argument
that is not NULL. In case of NULL values you can use a default value for
an
expression: COALESCE( `col`*2, 14) will produce 14 if `col` is NULL.
FWIW, IFNULL() does the same thing, with a clearer (to me) name,
On Thu, Oct 28, 2004 at 11:50:12AM +0200, Jigal van Hemert wrote:
...
Fortunately there is function COALESCE() that will return the first argument
that is not NULL. In case of NULL values you can use a default value for an
expression: COALESCE( `col`*2, 14) will produce 14 if `col` is NULL.
In article [EMAIL PROTECTED],
matt_lists [EMAIL PROTECTED] writes:
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
If those other databases return also NULL values
From: Harald Fuchs [EMAIL PROTECTED]
Yes, of course. NULL 'blah' returns NULL, and that's perfectly
standards-conformant.
Furthermore, it's quite logical.
NULL is meant to indicate that the value is unknown. If a value is unknown
it can be anything.
So, in the example `col` 'blah', col can
In article [EMAIL PROTECTED],
Jigal van Hemert [EMAIL PROTECTED] writes:
NULL is meant to indicate that the value is unknown. If a value is unknown
it can be anything.
So, in the example `col` 'blah', col can be anything, including 'blah'.
If you take that into consideration the only outcome
From: Harald Fuchs [EMAIL PROTECTED]
In article [EMAIL PROTECTED],
Jigal van Hemert [EMAIL PROTECTED] writes:
Fortunately there is function COALESCE() that will return the first
argument
that is not NULL. In case of NULL values you can use a default value for
an
expression: COALESCE(
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
but in mysql, it wont work if there's null records in the table
I have to do this, select from table where ( col 'blah
[snip]
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
but in mysql, it wont work if there's null records in the table
I have to do this, select from table where ( col
matt_lists wrote:
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
In SQL (not just MySQL), any comparisons involving NULL return NULL,
so if that was working in some
At 14:51 -0400 10/25/04, matt_lists wrote:
I cant tell if this is a bug or a feature.
Select from table where col 'blah'
I use this all the time with other databases, works great, gives me
everything that's not blah
but in mysql, it wont work if there's null records in the table
http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Keith Ivey [EMAIL PROTECTED] wrote on 10/25/2004 03:11:53 PM:
matt_lists wrote:
I cant tell if this is a bug or a feature.
Select from table where col 'blah
: Weirdness (or bug) with DROP TABLE
This is the only article in this thread
View: Original Format
Newsgroups: mailing.database.myodbc
Date: 2004-10-06 13:03:59 PST
I am using Mandrake 10, MySQL 4.1.5 from RPM downloaded from
dev.mysql.com.
Look at this session:
$ mysql -u root -p permarn
Enter
I am using Mandrake 10, MySQL 4.1.5 from RPM downloaded from
dev.mysql.com.
Look at this session:
$ mysql -u root -p permarn
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.1.5-gamma-standard
Type 'help;' or '\h'
I'd like to suggest the attached patch fixing a manpage formatting bug.
regards
Peter Breitenlohner [EMAIL PROTECTED]diff -ur mysql-4.0.21.orig/man/mysqlaccess.1.in mysql-4.0.21/man/mysqlaccess.1.in
--- mysql-4.0.21.orig/man/mysqlaccess.1.in 2004-09-07 00:29:40.0 +0200
+++ mysql
Josh Trutwin [EMAIL PROTECTED] wrote on 09/20/2004 10:41:46 PM:
On Mon, 20 Sep 2004 10:25:16 -0400
[EMAIL PROTECTED] wrote:
I think you missed my point. I think the 5.0.1 behavior was correct
and the others are wrong. There is a known bug (or two) about mixing
outer joins and inner
the outer row
for class id = 2 to show.
This was so much easier with the bug! :)
Thanks for your help,
Josh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
with the bug! :)
Thanks for your help,
Josh
Hmmm. you want to see a student, all of the classes they are enrolled in
and how many times they attended? I understand the relationships between
the student, class, and class_attended tables (that's all related to
attendance and class scheduling
On Tue, 21 Sep 2004 10:49:31 -0400
[EMAIL PROTECTED] wrote:
Hmmm. you want to see a student, all of the classes they are
enrolled in and how many times they attended? I understand the
relationships between the student, class, and class_attended tables
(that's all related to attendance and
Thanks! Between the ERD and your descriptions I think I've got it. Most of
the others on this list who have designed a system like yours (gradebooks
or attendance taking) designed it so that it supported multiple
instructors for multiple courses each of which have their own class
schedules (at
:
Is there a known bug with outer joins in MySQL 5.0.1?
I tried the following query on 5.0.1:
SELECT s.tech_id, s.full_name, sa.points_awarded, sa.date_submitted
FROM student s
INNER JOIN enrollment e ON e.tech_id = s.tech_id
INNER JOIN submitted_assignment sa ON sa.tech_id = s.tech_id
RIGHT
On Mon, 20 Sep 2004 09:33:56 -0400
[EMAIL PROTECTED] wrote:
Sounds like your 4.0.20 may be the buggy installation... let me see
if I can explain.
Except this is a 5.0.1 installation. The query worked as is in 4.0.20
(and it also worked in 5.0.0), only after playing with 5.0.1 did the
results
I think you missed my point. I think the 5.0.1 behavior was correct and
the others are wrong. There is a known bug (or two) about mixing outer
joins and inner joins and it looks like it may be fixed. IF you want to
see all of the students THAT TABLE (students) needs to be on the LEFT side
On Mon, 20 Sep 2004 10:25:16 -0400
[EMAIL PROTECTED] wrote:
I think you missed my point. I think the 5.0.1 behavior was correct
and the others are wrong. There is a known bug (or two) about mixing
outer joins and inner joins and it looks like it may be fixed. IF
you want to see all
Is there a known bug with outer joins in MySQL 5.0.1?
I tried the following query on 5.0.1:
SELECT s.tech_id, s.full_name, sa.points_awarded, sa.date_submitted
FROM student s
INNER JOIN enrollment e ON e.tech_id = s.tech_id
INNER JOIN submitted_assignment sa ON sa.tech_id = s.tech_id
RIGHT JOIN
C api mysql 4.1.4 ,select many select error!
free_root fail.
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
We are trying to put a monitoring solution in place at a client and have
come up against something during testing. If the replication user
disappears off the master and the slave cannot log in, the
Slave_IO_Thread still shows running and
Yes, I confirm, it's a bug.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED
Hi Folks,
We are trying to put a monitoring solution in place at a client and have
come up against something during testing. If the replication user
disappears off the master and the slave cannot log in, the
Slave_IO_Thread still shows running and no error in the last error
number field. Does
David,
I haven't ever attempted to delete the slave user on the master, and since I
only run replication on 4.1 boxes and not 4.0 boxes, I won't be able to help
much. But I would probably submit it to http://bugs.mysql.com and they can
verify that it is a bug. But they will probably
in the log.
Notice: same server, exactly same configuration runs as master on a different machine,
and didn't cause such problems. I had some trouble (sometimes it stucks when i try to
connect from console with mysql).
i'd like someone who handles bug to take a look on this error log:
MySQL: ready
Hi guys,
We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a
very high volume site. We are evaluating the performance on our new server
AMD64 and it seems it's slow compared to Dual Xeon/MySQL 4.0.15/RedHat8 and
Dual Xeon/MySQL 4.0.18/Mandrake 10.
And it seems there are
support | extended email support ]
Synopsis: more than one writeprocess impossible
Severity: [ critical ]
Priority: [ low | medium | high ] (one line)
Category: mysql
Class: [ sw-bug | doc-bug | change-request | support ] (one line)
Release: mysql-4.0.20-standard
Hi!
On Aug 21, Robert Nagy wrote:
Hi. Can u point me to the fixed file(s) please?
Or can u send me the diff if you have it?
http://bugs.mysql.com/bug.php?id=3933
Roger, it is explained my reply to the bugreport, and in my reply to
you.
The bug is fixed in 4.0.21.
According to the manual
Stardate [040822 00:26]. Sergei Golubchik of Borg wrote:
Roger, it is explained my reply to the bugreport, and in my reply to
you.
Thanks I can read. But the question was not that.
http://www.mysql.com/doc/en/Installing_source_tree.html
I'd like to see the diff between the two revisions.
Hi!
On Aug 22, Robert Nagy wrote:
Stardate [040822 00:26]. Sergei Golubchik of Borg wrote:
Roger, it is explained my reply to the bugreport, and in my reply to
you.
Thanks I can read. But the question was not that.
http://www.mysql.com/doc/en/Installing_source_tree.html
I'd like to
Stardate [040822 01:45]. Sergei Golubchik of Borg wrote:
Ah, ok.
Here it is:
http://mysql.bkbits.net:8080/mysql-4.0/[EMAIL PROTECTED]
Regards,
Sergei
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi. Can u point me to the fixed file(s) please?
Or can u send me the diff if you have it?
http://bugs.mysql.com/bug.php?id=3933
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have downloaded and installed MYSQL Client/Server 4.0.
1. when I get a query on SHOW DATABASES, it only shows test and not
mysql which has the users info
2. It doesn't give me access to create a new DATABASE and gives me an
access denied error.
Please advise. Thanks.
p.s. I have worked
Who did you log in as?
-Original Message-
From: Farnaz Akhavi
To: [EMAIL PROTECTED]
Sent: 8/10/04 9:57 AM
Subject: bug
I have downloaded and installed MYSQL Client/Server 4.0.
1. when I get a query on SHOW DATABASES, it only shows test and not
mysql which has the users info
2
that I did setObject correctly, there are 7 columns and
I have 7 value supplied. But JDBC complains that first column is null.
Is it a bug or someone can tell me what is going on?
Thanks
Haitao
What version of Connector/J are you using? This looks like a bug that was
fixed in 3.1.3
)
at com.mysql.jdbc.PreparedStatement.executeUpdate
(PreparedStatement.java:1658)
It is obvious that I did setObject correctly, there are 7 columns and
I have 7 value supplied. But JDBC complains that first column is null.
Is it a bug or someone can tell me what is going on?
Thanks
Haitao
--
MySQL General Mailing List
For list archives: http
Hi!
On Aug 01, Helge Jung wrote:
Description:
When I start up my fresh compiled mysqld it crashes immediately, the
error log file says:
It was reported just a few hours ago at bugs.mysql.com
(which is the recommended way to report bugs, by the way :)
you may follow the progress using
;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
[EMAIL PROTECTED]
To: Leonardo Javier Belén [EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 9:34 AM
Subject: SV: A possible bug
Hi Leonardo
i had a similar problem, it was with InnoDB tables, so i changed these
values:
# Set buffer pool size to 50-80% of your computer's memory
set-variable
Hi all,
I am using MySQL ver. 4.1.3-beta on Windows 2000 pro and I found that,
whenever i try to export data using the into outfile clause of the select
command the server hangs and i need to restart the service. Has anyone faced
the same problem, and if it is, how have you resolve it?
I
2004 22:56:12 -0700
Subject: Last insert id problem/bug
From: Scott Haneda [EMAIL PROTECTED]
I am not sure this is just how it is, my issue, or a bug, I searched the
bugs database, but don't really know what to call this in order to properly
look up the info:
MySQL 4.0.18-standard
CREATE TABLE
I'd like to ask some questions regarding a work-around
for
bug #861, a configure problem preventing installation
on mac os x.
Status on bug is currently Need Feedback. Any
suggestions on
how to route questions to bug author and/or the
developer?
Thanks.
Ron
You could select the Add Comment tab on the bug report to add feedback, if
you wish, but that bug report is a year old, and it's for version 4.0.13. I
cannot be 100% certain, but I'd bet that it was the same bug I reported on
this list for 4.0.15, which was fixed in 4.0.16. You can read
on 7/22/04 10:56 PM, Scott Haneda at [EMAIL PROTECTED] wrote:
I am not sure this is just how it is, my issue, or a bug, I searched the
bugs database, but don't really know what to call this in order to properly
look up the info:
MySQL 4.0.18-standard
Also note, I just tested this on 4.0.20
In article [EMAIL PROTECTED],
Scott Haneda [EMAIL PROTECTED] writes:
I am not sure this is just how it is, my issue, or a bug, I searched the
bugs database, but don't really know what to call this in order to properly
look up the info:
MySQL 4.0.18-standard
CREATE TABLE `addresses
on 7/23/04 5:30 AM, Harald Fuchs at [EMAIL PROTECTED] wrote:
The behavior is indeed strange, but it's not a bug, since it's documented:
If you use `INSERT IGNORE' and the record is ignored, the
`AUTO_INCREMENT' counter still is incremented and
`LAST_INSERT_ID()' returns
I am not sure this is just how it is, my issue, or a bug, I searched the
bugs database, but don't really know what to call this in order to properly
look up the info:
MySQL 4.0.18-standard
CREATE TABLE `addresses` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0
hi
i'm trying to compile my C app using mysql embedded stuff, but i get the following
linking error. is this a mysql 4.0.20 bug? should i replace -lmysqld with
-lmysqlclient when compiling for embeeded mysql? (does solve the problem.)
gcc -L/usr/lib/mysql -ofdlog fdlog.o util.o fdipc.o
)
OR
delete test_base, test_lead from test_base join test_lead on
(test_base.id = test_lead.lead_id);
Query OK, 0 rows affected (0.00 sec)
Submitter-Id: Asim Thakker
Originator:Asim Thakker
Organization:
Data Management
MySQL support: none licence
Synopsis: BUG
(0.00 sec)
Submitter-Id: Asim Thakker
Originator:Asim Thakker
Organization:
Data Management
MySQL support: none licence
Synopsis: BUG in Multi-Delete when table aliases included in query
Severity: serious
Priority: medium
Category: mysql
LIMIT 20
Können Sie mir bitte Nachricht geben, ob es ein Bug ist ? Da ich ansonsten
nicht weiterkomme.
Danke
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi again.
PROCESS LIST is:
Creating tmp file
Repair by sorting
The problem occurs while repair by sorting.
myisam parameters have been increased accordingly:
myisam max extra sort file size = 15000M
myisam max sort file size = 15000M
There must be a bug somewhere? What do you suggest?
Vincent
Hi
Terry,
thank you for reporting this. Since the cardinality reported by SHOW TABLE
STATUS is just an estimate, this is not strictly a bug, but it is best to
correct this anyway.
I modified the cardinality estimation algorithm to 4.0 in March 2004, but
forgot the case where the index B-tree just
TABLE
STATUS is just an estimate, this is not strictly a bug, but it is best
to
correct this anyway.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have been trying out 4.1.3 beta on XP, and note that in SQLyog, Maestro,
and even MYSQL Administrator, the number of records shown is always one
more than actual - in InnoDB tables only. Even an empty table still shows
as 1. This is different than the count shown in these GUIs with 4.1.1
Hi!
On Jul 06, Vincent Bouret wrote:
Hi,
I got the following values:
key_buffer_size = 256M
myisam max extra sort file size = 8000M
myisam max sort file size = 8000M
myisam sort buffer size = 128M
But that big table (MYD = 2397 MB), rows = 5 355 866 still won't index
in full text.
Hello,
I would like to mention a potential bug with using the silent install
feature of mySQL with the mysql-4.0.20d-win.zip for windows. I have
WindowsXP Professional for an OS. I was setting up mySQL to generate a
setup.iss file. I found that the setup.iss file that was generated did
I've got two Linux x86 servers: master and slave, both with MySQL 4.0.20
from the same package. On the master I do:
SET CHARACTER SET cp1250_latin2;
UPDATE `my_tab` SET `my_field`='my_cp1250_string';
and got this in both master's and slave's log.
On master the data is properly translated into
time). It looks like at 4am, our optimize
database script fires off on the SLAVE, and it looks like the slave
thread dies a little while after. I have turned off nightly
optimization, and for the past 5 days, we have not seen the slave stop.
So I would believe that we are running into bug:
http
smaller
tables.
When you create indexes on the existing data and when you add data to
the index MySQL uses different algoritms to create/modify indexes.
Thus is the first one - in ALTER TABLE - has a bug, you won't trigger it
with regular updates.
Regards,
Sergei
it unchanged because I don't list
it in the -c clause.
So, is that a bug or mysqlimport is only useful for
populating empty tables and for that reason emptyes
the values of the columns not listed?
If so, I'll must to discard that sooo elegant solution
and use a .php script to make a HUGE .sql
At 12:03 -0300 7/5/04, j llarens wrote:
Hi people
I'm facing a (not huge) problem with mysqlimport.
The mysql version I'm using is MySQL
4.0.11a-gamma'-Max'
For updating a #29000 records table from fixed-lenght
ASCII file, I'm using a php script that gets a record
and executes and UPDATE for each
401 - 500 of 2315 matches
Mail list logo