Hi,
On 28-8-2011 4:08, shawn wilson wrote:
On Sat, Aug 27, 2011 at 17:33, Arthur Fuller 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 'value' is special in most
On Sat, Aug 27, 2011 at 17:33, Arthur Fuller 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
> NULL. In practice
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 wrote:
>
> The "innocuous change" w
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
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.
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 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,
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
>
>
>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
-> f
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 infi
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
p1.player_name,g.score1,g.tim
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 in
n thread 137490432 in file
>../../innobase/include/buf0buf.ic line 261
>InnoDB: 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 on
.
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
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
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 [HY000
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 the
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
htt
>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 Abfra
rt from https://order.mysql.com/
- 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
ntionally 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. This error c
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
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
"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 ro
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 the
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 dateti
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
__
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 PRO
Bug report -- MySQL Embedded Server v4.0.10, binary distribution for
Windows
-
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
failure 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: shuttin
>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:
>Originator:Mudit Wahal
>Organization:
>MySQL support: [none | licence | ema
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 hyph
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
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,
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
f 3 threads.
"
Regards,
Heikki
Innobase Oy
sql query
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
wh
ad 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 [
. DESCRIBE TABLE does not contain all information.
Regards,
Heikki
- Original Message -
From: "Matt Solnit" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "Henry Bequet" <[EMAIL PROTECTED]>
Sent: Saturda
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
===
Bug report -- MySQL v4.06, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
512 MB RAM
Windows XP Professional SP1
Problem description
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 mandr
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
.
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,
or
: 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
>===
>
>--
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
> enoug
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
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 conta
===
Bug report -- MySQL v4.05a, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
Windows XP Professional SP1
.NET Framework SP2
Problem
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,
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
he
can fix these to 4.0.6.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
- Original Message -
From: "Heikki Tuuri" <[EMAI
Thursday, November 28, 2002 1:27 PM
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
> Subj
ubject: 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
Inn
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
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" comm
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:
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
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 that
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same machine
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 maxi
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\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.4-beta-
Innobase Oy
sql query
...
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same machine
...
looks like the hash table of log records had a wrong count of page numbers
which caused the assertion.
recv_sys->n_addrs means for how many database pages we have log records.
I have not seen this bug report before. If you can send me ibbackup_logfile
from your backup directory, I can pars
p.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
Segmentation fault
--
Kevin Carrigan <[EMAIL PROTECTED]>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
sage -
D> From: "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: Err
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
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
erent 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
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
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 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
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 fie
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>
5VliaaX7NRzL8cAZ4zYb2XwIZyxc
data chunk below.
>Description:
Bug in SQL parser.
--BEGIN CUT--
eNotjs0KgkAYRfc9xV20itBxzMqhHyImCoxIA9eJX41hOY1m9YI+Vz+4u+dwFre7SQXKe66PpiRj
5VliaaX7NRzL8cAZ4zYb2XwIZyxcJjwfOV19yJdGd5IY2LNOrN5IsxRPwpkqKDI0B4cLd9AWAZ2q
oiYj0LRmIX5FC9E+EIhkI5cH9LAKd
ARY TABLE tmp_table(i INT);
> ERROR 1142: create command denied to user: 'test_user@localhost' for table
>
> 'tmp_table'
>
Hi!
Thank you for your bug report.
Thanks to it, the above bug was fixed and fix will come up in 4.0.3.
--
Regards,
__ __
>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 it
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:
> > > >
> >
Lost connection to MySQL server during query.
>
> > > Note:
> > > 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
> > 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 fir
h 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 is the
>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 su
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 s
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 4.
> 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 resear
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
Copyr
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> /usr/bin/s
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-P
> 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
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.
---
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
GW>Submitter-Id: Gavin Woodhatch
GW>Originator:
GW>Organization: NetZone Ltd.
GW>MySQL support: [none]
GW>Synopsis:
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: [ m
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 '(
1 - 100 of 194 matches
Mail list logo