Hi,
On 28-8-2011 4:08, shawn wilson wrote:
On Sat, Aug 27, 2011 at 17:33, Arthur Fullerfuller.art...@gmail.com wrote:
I agree 110%. It is completely pointless to index a column with that amount
of NULLs. In practical fact I would go further: what is the point of a
NULLable column?
A NULL
Hi,
On 27-8-2011 1:28, Dave Dyer wrote:
Can you post the EXPLAIN EXTENDED output for your before and after queries?
also, have you recently run an ANALYZE TABLE on the tables?
What was the result of ANALYZE TABLE?
What is the engine of the tables involved?
// before
Used keys:
p2.NULL,
The innocuous change was to add an index for is_robot which is true
for 6 out of 20,000 records and null for the rest.
My complaint/question/observation is not how to optimize the query
that went awry, but to be alarmed that a venerable and perfectly
serviceable query, written years ago and
Hi,
On 27-8-2011 22:52, Dave Dyer wrote:
The innocuous change was to add an index for is_robot which is true
for 6 out of 20,000 records and null for the rest.
Not useful to add an index for that. I also wonder why the value is null
(meaning: unknown, not certain) for almost all records.
I agree 110%. It is completely pointless to index a column with that amount
of NULLs. In practical fact I would go further: what is the point of a
NULLable column? I try to design my tables such that every column is NOT
NULL. In practice this is not realistic, but I try to adhere to this
principle
It is a general rule that indexes for columns with low cardinality are not
worth it, often making queries more expensive than they would be without
said index. binary columns all suffer from this.
- michael dykman
On Sat, Aug 27, 2011 at 4:52 PM, Dave Dyer ddyer-my...@real-me.net wrote:
On Sat, Aug 27, 2011 at 17:33, Arthur Fuller fuller.art...@gmail.com wrote:
I agree 110%. It is completely pointless to index a column with that amount
of NULLs. In practical fact I would go further: what is the point of a
NULLable column? I try to design my tables such that every column is NOT
This is a cautionary tale - adding indexes is not always helpful or harmless.
I recently added an index to the players table to optimize a common query,
and as a consequence this other query flipped from innocuous to something that
takes infinite time.
select
In the last episode (Aug 26), Dave Dyer said:
This is a cautionary tale - adding indexes is not always helpful or
harmless. I recently added an index to the players table to optimize a
common query, and as a consequence this other query flipped from innocuous
to something that takes infinite
Can you post the EXPLAIN EXTENDED output for your before and after queries?
also, have you recently run an ANALYZE TABLE on the tables?
// before
mysql explain extended select
p1.player_name,g.score1,g.time1,g.color1,p2.player_name,g.score2,g.time2,g.color2,g.gamename,gmtdate
- from
BTW, the query on the database with the added index doesn't take
forever, it takes a mere 51 minutes (vs. instantaneous).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
BTW, the query on the database with the added index doesn't take
forever, it takes a mere 51 minutes (vs. instantaneous).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
a bug by visiting
http://bugs.mysql.com/, you can use the mysqlbug script to generate a
bug report (or a report about any problem).
which is, of course, pretty useless if you have no Web access. Worse,
I had to find it by googling with site:mysql.com.
I had a look at the mysqlbug script
: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
mysqld got signal 11;
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
.
InnoDB: Send a detailed bug report to mysql@lists.mysql.com
mysqld got signal 11;
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
After installing mySQL along with a program called articlebot, I tried to
run the application and I keep getting this message:
An unhandled exception has occurred in a component in your application.
Click continue and application will ignore this error and attempt to
continue.
ERROR
Hello.
I don't know the relationships between program articlebot and MySQL.
But error message tells me to ask you to check if you have MyODBC
properly configured and whether your MySQL server is running. See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
There is
It would appear that LOAD DATA FROM MASTER processes databases and
tables alphabetically. When a merge table is being copied, and it's name
is alphabetically before some/any/all of it's components, the process
fails with a 1017 couldn't find file error.
Has this been fixed? If so, as of which
server not starting beginnig two-three days ago. All went well until then, when i had
some large queries on server, and i think that was the moment when it crashed. I tried
increasing the amount of innodb_buffer_pool_size from 8 to 16M , it started now, but
the same list of errors appears in
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
Description:
When I start up my fresh compiled mysqld it crashes immediately, the error log file
says:
040801 00:07:28 mysqld restarted
040801 0:07:29 Warning: Can't open time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without them
mysqld got signal 11;
Dear Sir/Madame,
Sehr geehrte Damen und Herren,
I got the following message using the mysql-Database with phpMyAdmin:
Ich habe folgende Meldung beim benutzen der mysql-Datenbank mit phpmyadmin
erhalten:
Möglicherweise haben Sie einen Bug im SQL-Parser entgeckt. Bitte überprüfen
Sie Ihre
a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
mysqld got signal 11;
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
/
- Original Message -
From: Eric Aubourg [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, September 09, 2003 2:37 AM
Subject: bug report
030905 10:39:38 mysqld started
030905 10:39:40 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files
hi
There is a Bug in the InstallWizard Engine. If I install mysql on my winxp
professional system WITHOUT sp1, install shield say goodbye when the setup is almost
ready. i've tried custom and completly installation. maybe its a failied download. the
mysql version is: mysql-4.0.14b-win.zip
cya
Nils Wisiol wrote:
hi
There is a Bug in the InstallWizard Engine. If I install mysql on my winxp
professional system WITHOUT sp1, install shield say goodbye when the setup is almost
ready. i've tried custom and completly installation. maybe its a failied download.
the mysql version is:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: LIMIT of 1000 rows returned on SELECT (2nd try)
Description:
When doing a query on a table with more than 1000 rows,
the SELECT * query returns only the first 1000 rows.
How-To-Repeat:
I tried to attach data for
Johnson, David C [EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: LIMIT of 1000 rows returned on SELECT (2nd try)
Description:
When doing a query on a table with more than 1000 rows,
the SELECT * query returns only the first 1000 rows.
Do
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi Mysql,
This is a bug report.
There are two cases, because the bug is quite old, I
detected it the first time
a year ago on a 3.23.44 with MyISAM, but I thought it
would be fixed soon,
sorry.
This bug happens in 4.0.8 too with MyISAM tables.
Test Case 1
---
Operating System: Linux
On 26 Mar 2003 at 9:23, Alejandro Paz wrote:
As you can see the colum `b' is updated, too.
Note, you have to insert a delay of almost 1 second
between the first select
and the update, because the column `b' takes the
current time!.
Only happens with timestamp columns not with datetime
Bug report -- MySQL Embedded Server v4.0.10, binary distribution for
Windows
in thread 4225946759 in file
M:\mysql-3.23\innobase
os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL PROTECTED]
030302 18:45:05 D:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting!
030302 18:45:05 Aborting
InnoDB: Warning: shutting down
-
From: Keith Engelhardt [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, March 03, 2003 1:52 AM
Subject: Bug Report: mysql-3.23.38-win
I am attempting to get mysql-3.23.38-win on a Windows 98 SE box. The
mysql-3.23.38-win.zip install wizard allowed me to install to D:\MYSQL
Description:
Please IGNORE my previous bug report. I had another script which was
deleting the data. Stupid user error.
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Mudit Wahal
Organization:
MySQL support: [none | licence | email support
Hi all,
I recently had to restore from a backup and discovered that mysql didn't
want to re-create a table which had the minus symbol (-) in it, eg
DROP TABLE IF EXISTS Postcodes;
CREATE TABLE Postcodes (
DanPK mediumint(8) unsigned NOT NULL auto_increment,
MyStamp timestamp(14) NOT NULL,
On Wed, Jan 15, 2003 at 11:44:24AM +1100, Daniel Kasak wrote:
Hi all,
I recently had to restore from a backup and discovered that mysql didn't
want to re-create a table which had the minus symbol (-) in it, eg
Yeah, you need to quote such names now.
Upgrade your version of mysqldump and
MySQLCC probably uses the backtick (`) to escape stuff so it issued
UNIQUE KEY `IDX_Postcode-Location` (Postcode,Location)
and not
UNIQUE KEY IDX_Postcode-Location (Postcode,Location)
It has been mentioned on the list a few times in the last couple months that
if you escape strings containing
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
Description:
Description:
I keep recieving signal 11 and stack dumps. There are no
connections going into mysql and no databases besides
mysql and test. Only user in there is root and the other
defualt ' ' user.
How-To-Repeat:
Simply started up the server and let it
to
change it to:
set-variable=innodb_log_files_in_group=2 to get it to restart (a suggestion by Heikki
Tuuri)
030107 4:05:57 InnoDB: Assertion failure in thread 11497484 in file btr0sea.c line
456
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL
Subject: bug report
From: Adam Gillespie
Date: Tue, 7 Jan 2003 09:29:59 -0800
Our db server crashed and this was in the log. One strange thing was that
when I
went to restart, the error log gave me this line:
/usr
information.
Regards,
Heikki
- Original Message -
From: Matt Solnit [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Henry Bequet [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 2:44 AM
Subject: Bug report: UNIQUE KEY and DESCRIBE TABLE
===
Bug report -- MySQL v4.06, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
512 MB RAM
Windows XP Professional SP1
Problem description
At 16:44 -0800 12/27/02, Matt Solnit wrote:
===
Bug report -- MySQL v4.06, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
512 MB RAM
Windows XP Professional SP1
Hello.
I'd like to report a bug I've found with MySQL. MySQL, as shipped with Mandrake
9, gets hanged when starting it with safe_mysqld or service mysql start
or /etc/rc.d/init.d/mysql ALWAYS WHEN NSS_LDAP IS ENABLED! I'd like to report
this so that you can try if it's a bug from mysql or
.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
InnoDB: Thread 10251 stopped in file row0mysql.c line 92
mysqld got signal 11;
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
Christopher,
- Original Message -
From: Christopher Stephan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, December 21, 2002 6:00 PM
Subject: Bug Report
Hello,
following problem occurs using MySql.
Can you help me with that Error?
this is memory corruption
On Wednesday 11 December 2002 01:46, Christopher M. Keslin wrote:
The following sql query works very well in version 4.0.1-alpha-nt. However
it returns a null set with the data provided in aBetterLimo.sql in all
later versions (the last one tried was 4.0.5-beta. I hope that this is
enough
: Henry Bequet
Subject: Re: Bug report: Embedded MySQL version 4.05a
At 15:39 -0800 12/10/02, Matt Solnit wrote:
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
Windows XP Professional SP1
.NET Framework SP2
Problem
Hello,
The following sql query works very well in version 4.0.1-alpha-nt. However
it returns a null set with the data provided in aBetterLimo.sql in all later
versions (the last one tried was 4.0.5-beta. I hope that this is enough
information. If you would like anymore please feel free to
At 15:39 -0800 12/10/02, Matt Solnit wrote:
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
Windows XP Professional SP1
.NET
On Thu, 5 Dec 2002, Heikki Tuuri wrote:
the table definition below does not match the index records below. In the
index records one of the datetime columns seems to appear twice.
Heikki, you are right. The old definition of that MySQl table had two
columns twice. When I REgenerated the table,
http://www.mysql.com
sql query
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 12:24 AM
Subject: Re: Bug Report: Replication in 4.0.5beta
Michael,
I have been running tests on 4.0.6 with big insert
On Wed, 4 Dec 2002, Heikki Tuuri wrote:
what MySQL version you are running? On what OS?
Version 3.23.53-max-nt-log on Windows Professional 2000
What does SHOW CREATE TABLE tabdocumentoconsultado; print?
I created again all the tables of the database called bdatena.
Now that the table is no
updating
UPDATE tabdocumentoconsultado SET EmPausa='N' WHERE
IdAprendiz='landrade' AND Tipo='Top' AND codcurso='11' AND
IdP='20'
InnoDB: Make a detailed bug report and send it
InnoDB: to [EMAIL PROTECTED]
InnoDB: error in sec index entry update in
InnoDB: index umDoc table bdatena
: InnoDB: a detailed bug report
From: Willie D. Leiva [EMAIL PROTECTED]
Date: 2002-12-04 9:36:24
MySQL generated the following error messages about a corrupted table:
/
021127 15:48:01 InnoDB: Started
InnoDB: error in sec index entry update in
InnoDB: index umDoc table bdatena
Subject: Re: Bug Report: Replication in 4.0.5beta
Michael,
- Original Message -
From: Michael Ryan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 28, 2002 12:34 PM
Subject: Bug Report: Replication in 4.0.5beta
The environment info was copied from
The environment info was copied from the mysqlbug command by our external
hosting company who truncated the lines therefore the last couple of
characters from each line is not there however it was a Solaris 2.8 binary
download of 4.0.5beta so you would have all of the info anyway.
Description:
Michael,
- Original Message -
From: Michael Ryan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 28, 2002 12:34 PM
Subject: Bug Report: Replication in 4.0.5beta
The environment info was copied from the mysqlbug command by our
external
hosting company who
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same machine
Matt,
thank you for the bug report.
I do not have C# in my computer. Did I understand correctly the bug does not
appear if you use the Embedded Server Library inside C++?
My first note is that you should define USE_TLS in all MySQL modules, like
Monty instructed a week ago. But I guess
PROTECTED]
Cc: Henry Bequet
Subject: Re: Bug report: Embedded MySQL v4.04b
Matt,
thank you for the bug report.
I do not have C# in my computer. Did I understand correctly the bug does
not
appear if you use the Embedded Server Library inside C++?
My first note is that you should define USE_TLS in all
I have a problem with key creation :
Server version: 4.0.4-beta-max-nt Binary version
PC : DELL OPTIPLEX GX100
OS : Windows 2000 Professional
RAM: 256 Mb
C:\mysql\binmysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version:
Angeloluca,
Tuesday, November 19, 2002, 12:21:58 PM, you wrote:
AdBamdc I have a problem with key creation :
AdBamdc Server version: 4.0.4-beta-max-nt Binary version
AdBamdc PC : DELL OPTIPLEX GX100
AdBamdc OS : Windows 2000 Professional
AdBamdc RAM: 256 Mb
[skip]
AdBamdc 236 Is the maximum
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same machine
Innobase Oy
sql query
...
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same
: Egor Egorov [EMAIL PROTECTED]
D To: [EMAIL PROTECTED]
D Sent: Saturday, October 19, 2002 6:35 AM
D Subject: re: Bug report
Douglas,
Saturday, October 19, 2002, 1:08:14 AM, you wrote:
D INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different
D size
D INNODB: than specified
Douglas,
Saturday, October 19, 2002, 1:08:14 AM, you wrote:
D INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different size
D INNODB: than specified in the my.cnf file!
D INNODB:Assertion failure in thread 138207232 in file os0file.c
D send bug report to [EMAIL PROTECTED]
D mysqld
021018 17:50:30 mysqld started
INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different size
INNODB: than specified in the my.cnf file!
INNODB:Assertion failure in thread 138207232 in file os0file.c
send bug report to [EMAIL PROTECTED]
mysqld got signal 11
key_buffer_size
INNODB: than specified in the my.cnf file!
INNODB:Assertion failure in thread 138207232 in file os0file.c
send bug report to [EMAIL PROTECTED]
mysqld got signal 11
key_buffer_size = 16773120
read_buffer_size = 131072
sort_buffer_size = 0
max_used_connections = 0
threads_connected = 0
:30 mysqld started
INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different size
INNODB: than specified in the my.cnf file!
INNODB:Assertion failure in thread 138207232 in file os0file.c
send bug report to [EMAIL PROTECTED]
mysqld got signal 11
key_buffer_size = 16773120
This occured while using phpmyadmin 2.3.0-rc4:
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05
IEV4
cCAkPGJyIC8+CldoeSBkaWQgd2UgZ2V0IGhlcmU
Quasimodo wrote:
This occured while using phpmyadmin 2.3.0-rc4:
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05
[snip]
This is reporting a bug
This is documented behavior.
Indexes are not used with DESC.
Ver 4.X does, however support DESC with an index.
Grigoriy Vinogradov wrote:
Bug Report:
Version: 3.23.51-max
OS: Windows ME
Problem:
Synopsis: Does not use index when ordering records on datetime field in
the descending order, even
Bug Report:
Version: 3.23.51-max
OS: Windows ME
Problem:
Synopsis: Does not use index when ordering records on datetime field in
the descending order, even though though this field is NOT NULL.
I created the following table:
CREATE TABLE Threads (threadID int NOT NULL PRIMARY KEY
John,
Wednesday, August 14, 2002, 12:26:29 PM, you wrote:
JMH data chunk below.
Description:
JMH Bug in SQL parser.
JMH --BEGIN CUT--
JMH
eNotjs0KgkAYRfc9xV20itBxzMqhHyImCoxIA9eJX41hOY1m9YI+Vz+4u+dwFre7SQXKe66PpiRj
JMH
data chunk below.
Description:
Bug in SQL parser.
--BEGIN CUT--
eNotjs0KgkAYRfc9xV20itBxzMqhHyImCoxIA9eJX41hOY1m9YI+Vz+4u+dwFre7SQXKe66PpiRj
5VliaaX7NRzL8cAZ4zYb2XwIZyxcJjwfOV19yJdGd5IY2LNOrN5IsxRPwpkqKDI0B4cLd9AWAZ2q
!
Thank you for your bug report.
Thanks to it, the above bug was fixed and fix will come up in 4.0.3.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
Description:
Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege
not working
ERROR 1142
How-To-Repeat:
1) (under root)
mysql GRANT CREATE TEMPORARY TABLES ON *.* TO
test_user@localhost IDENTIFIED BY 'test_pass';
Query OK, 0 rows affected
sergei,
no i meant loading it up from raw data again. in the sense, i empty the
database, then i have a script which takes a directory full of files and reads
them into the database. each time i do that the database ends up corrupted.
is there any way to figure out where the corruption is? is
:
The same results with oficial mysql-4.0.2 and latest bk snapshot,
mysql was compiled with both gcc-3.1 and gcc-295.3
Unfortunately we can't test this bug report as we do not have tables to run
this query with.
Please check tables you have at first to eliminate corrupted table
On Wednesday 24 July 2002 17:23, Sinisa Milivojevic wrote:
Sergey S. Kostyliov writes:
At first I want to thank you for a fast answer,
On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR
Description:
ERROR 2013: Lost connection to MySQL server during query.
How-To-Repeat:
select distinct s.supplier_id, s.who_pay, r.name as rname, s.name,
s.nick, s.address, s.contact_person, s.email, s.fax,
s.comment
from
-295.3
Unfortunately we can't test this bug report as we do not have tables to run
this query with.
Please check tables you have at first to eliminate corrupted table is the
source of the problem and if problem persist upload them into secret
directory at ftp://support.mysql.com
If you
mysql-4.0.2 and latest bk snapshot,
mysql was compiled with both gcc-3.1 and gcc-295.3
Unfortunately we can't test this bug report as we do not have tables to run
this query with.
Please check tables you have at first to eliminate corrupted table is the
source of the problem and if problem
On Tue, 2 Jul 2002, Erlend Hopsø Strømsvik wrote:
Download the 4.0.2 source and compile it.
Things seem to work a lot better with the 4.0.2. And it won't crash with
special combinations of words :)
Hi,
Some things with BOOLEAN MODE seem still broken. Especially the '*'
jokers. I have
Hi!
On Jul 02, Thomas Spahni wrote:
On Tue, 2 Jul 2002, Erlend Hops? Str?msvik wrote:
Download the 4.0.2 source and compile it.
Things seem to work a lot better with the 4.0.2. And it won't crash with
special combinations of words :)
Hi,
Some things with BOOLEAN MODE seem still
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-gnu
on i686
Hi!
- Original Message -
From: Wan YU [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, June 27, 2002 8:25 PM
Subject: BUG REPORT FOR MYSQL
Hi,
I'm doing research on DBMS recently and have found
some bugs in mysql's source codes.I think
hugh,
Friday, May 17, 2002, 5:06:46 AM, you wrote:
h Description: /usr/libexec/mysqld: error while loading shared libraries: cannot open
shared object file: cannot open shared object file: No such file or directory.
h How-To-Repeat:
h /usr/libexec/mysqld -u root
h
Original Message
Subject: Bug Report
Date: Thu, 16 May 2002 21:28:21 -0400
From: hugh [EMAIL PROTECTED]
Organization: The Dualies
To: [EMAIL PROTECTED]
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments
Hallo,
i tried to use MySQL together with MySQL-ODBC 3.51.02 für an MS-Project
Database. While storing the following error comes up.
...
When the error occures the programm has written 19 tables with entrys.
Is it realy a bug or is do you now a solution to work with MS-Project
Hello All
Many Thanks specialy goto Egor Egorov.
We changed the RAM in the Server .. MySQL has now been Running
(without Crash) for over 48 h .. Problem solved !
Thanks again for your Support !
Cheers
Gavin Woodhatch
NetZone Ltd.
Description:
MySQL Crashes often.
How-To-Repeat:
Don't know
Fix:
Don't know
Submitter-Id: Gavin Woodhatch
Originator:
Organization: NetZone Ltd.
MySQL support: [none]
Synopsis: Random MySQL crashes (1-2 every 24h)
Severity: [ serious ]
Priority: [ medium
Gavin,
Monday, April 22, 2002, 6:29:08 PM, you wrote:
GW Description:
GW MySQL Crashes often.
GW How-To-Repeat:
GW Don't know
GW Fix:
GW Don't know
GWSubmitter-Id: Gavin Woodhatch
GWOriginator:
GWOrganization: NetZone Ltd.
GWMySQL support: [none]
GWSynopsis:
Patrice,
Thursday, April 04, 2002, 4:41:24 AM, you wrote:
P MySQL Version: 3.23.49
P OS: Win 98
P Query 1: select length ('abc') returns
P You have an error in your SQL syntax near '('abc')' at
P line 1
P Query2: select length('abc') returns 3: OK
P Note the space between the 'h' and '(' in
MySQL Version: 3.23.49
OS: Win 98
Query 1: select length ('abc') returns
You have an error in your SQL syntax near '('abc')' at
line 1
Query2: select length('abc') returns 3: OK
Note the space between the 'h' and '(' in Query 1. The
parser does not like this space...
The same problem occurs
Hi!
Ken == Ken Menzel [EMAIL PROTECTED] writes:
Ken Hi Monty and Sasha,
Ken Just a quick not to say that's such a great idea that Monty even
Ken thought of it before! Monty and I discussed this last September, I
Ken hope we could get something like this in 4.1
Ken Just a vote!
I have
1 - 100 of 182 matches
Mail list logo
