Before posting this as a bug report, I seek help on the list, also in
order to produce a more complete test case in the event this is
effectively a bug.
My configuration:
- a master server running in NO_BACKSLASH_ESCAPES sql mode
- a slave server also running in NO_BACKSLASH_ESCAPES sql mode
R
2007/2/15, Manuel Vacelet <[EMAIL PROTECTED]>:
Hi all,
I'm facing a strange behaviour with an UPDATE statement.
I have a table like:
+-+--+
| item_id | rank |
+-+--+
|2812 |2 |
| 13050 |4 |
| 13051 |3 |
| 13052 |1 |
+-+---
Hi all,
I'm facing a strange behaviour with an UPDATE statement.
I have a table like:
+-+--+
| item_id | rank |
+-+--+
|2812 |2 |
| 13050 |4 |
| 13051 |3 |
| 13052 |1 |
+-+--+
And I want to switch items 2812 and 13052 rank
In "current_date - 7" the date is converted to a string and than to an Integer.
Use adddate function:
adddate(CURRENT_DATE(),interval -1 day)
Santino
At 11:37 +0100 7-12-2005, christophe nauwelaers wrote:
Hi,
For any reason, current_date doens't look to behave normally since a few
days.
I run r
Hi,
For any reason, current_date doens't look to behave normally since a few
days.
I run reports in a MySQL DB through sql queries and I use a statement like "
... invd between current_date - 7 and current_date - 1 ..." It always
worked.
I just noticed that this week's report was wrong. Indeed : c
Hi,
I was assuming USE INDEX was only telling MySQL which INDEX it needed to
use, but it seems to be not always the case.
With MySQL 4.1.10, USE INDEX(topic) for the following query seems to change
the way the index is used.
mysql> EXPLAIN SELECT numreponse FROM searchjoinhardwarefr13 WHERE
id='
[EMAIL PROTECTED] wrote:
>
> I've been running MySQL 4.0.x on a RH9 machine for some months and everything
> was fine. I could create tables of type InnoDB and define FOREIGN KEY's all
> was well.
>
> A few days ago it does not let me create tables with foreign keys anymore it
> says some
Hello,
I've been running MySQL 4.0.x on a RH9 machine for some months and everything
was fine. I could create tables of type InnoDB and define FOREIGN KEY's all
was well.
A few days ago it does not let me create tables with foreign keys anymore it
says something like "unable to create /da
At 23:13 +0200 5/2/04, Alessandro Sappia wrote:
When I create a table with InnoDB there is a strange behaviour in it:
mysql> CREATE TABLE prometeo_indirizzi_cliente (
-> indirizzi_cliente_id int(10) unsigned NOT NULL auto_increment,
-> denominazione_indirizzo_id int(10)
When I create a table with InnoDB there is a strange behaviour in it:
mysql> CREATE TABLE prometeo_indirizzi_cliente (
-> indirizzi_cliente_id int(10) unsigned NOT NULL auto_increment,
-> denominazione_indirizzo_id int(10) unsigned default NULL,
-> cliente_id int(
I have a 3.x database that I backed up and restored to a 4.0 server. All
worked fine, except for one issue:
One table holds addresses, and when restoring it, would fail with an
"unmatched quotes" message.
On further examination, I found that it would occur on entries where the
text was like "123
> I won't say you need to go back to high school, but maybe you need to
> review how SQL works. You have no criterion for joining your two
At least my knowledge of SQL needs an update.
Although there are criteria for joining the two
tables I realize that the way I specified them is
wrong.
> t
On 14 Jan 2003, at 15:28, Peter van der Kamp wrote:
> What should be the result when I issue the following
> query:
> select naam_bron from bron, topic where
> (bron.media="Book")
> or (topic.naam_bron = bron.naam_bron and
> topic.topic_code = "5.1");
>
> Before posting my results I'll wait for
Hello,
I'm working with mySQL 3.23.32 under Solaris. I have
a database with two tables 'bron' and 'topic'. Those
tables are related via 'naam_bron'. Lets say that
table 'bron' contains 100 records where column
'media' = 'Book' and table 'topic' contains 30
records where column 'topic_code' = '
ller and FBSD5 seeing the drives.
Best of luck,
Ken
- Original Message -
From: "Odhiambo Washington" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 2:10 AM
Subject: strange behaviour
>
> I run mysql on FreeBSD and it's been givin
I run mysql on FreeBSD and it's been giving me a lot of problems. Sometimes
the load shoots up and some applications cannot access mysql server anymore.
During such instances, when I run top, I get something like this:
last pid: 57669; load averages: 1.40, 1.52, 1.52
I have a database structure as follows (simplyfied) :
CREATE TABLE masterTABLE (
pid int(11) unsigned NOT NULL default '0',
c1id int(11) unsigned default NULL,
c2id int(11) unsigned default NULL,
value int(11) unsigned NOT NULL default '0',
UNIQUE KEY pid2 (pid,c1id,c2id),
UNIQUE KEY
Ys (pid and pid2) from Table masterTABLE.
This behaviour ist tested on MySQL 3.23.51 and now even
on MySQL 3.23.53.
TIA
>How-To-Repeat:
Code Sample above
>Fix:
??
>Submitter-Id:
>Originator: Stephan Skusa
>Organization: Lippe-Net Online-Service
>MySQL suppo
Cams Ismael writes:
> Description:
> A time ago I reported next bug:
>
> "The ALTER TABLE command behaves very strange when stopping and
> restarting the MySQL server afterwards. I noticed this after having
> rebooted my PC (which means that the MySql server is st
mysql > quit;
> C:\>net stop mysql
> C:\>net start mysql
>
> mysql > select * from metaoid;
> +---+---+-+
> | objid | tablename | oid |
> +---+---+-+
> | 5 | test| 1 |
>
MySQL v3.23.49 linux
Hi,
We came across something strange here.
select count(*), user from mysql.user;
is illegal (ERROR 1140: Mixing of GROUP columns ... if there is no GROUP BY clause).
But,
select if( count(*) and user, 1, 0 ) from mysql.user;
actually works.
Is this a bug or
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 09, 2002 3:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes:
> Hello Sinisa,
>
> have you already found the origin of the problem ? How
Cams Ismael writes:
> Hello Sinisa,
>
> have you already found the origin of the problem ? How does the bugs get
> fixed -> are they solved in patch releases or are they solved in a next
> release of the MySQL server ?
>
> Kind regards,
> Ismaël
>
Sorry to have lost your e-mail.
If that is a
ent: Tuesday, July 02, 2002 1:43 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes:
> Hello Sinisa,
>
> this has nothing to do with services. I have also tried this without
> cre
Cams Ismael writes:
> Hello Sinisa,
>
> this has nothing to do with services. I have also tried this without
> creating a service and the result is the same.
> Normally the services are also stopped automatically when logging of, so I
> don't understand why I should stop it manually. Also I have
after dropping/adding a column messes up your database ! Can you
please check this ?
Kind regards,
Ismaël
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 4:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: St
Cams Ismael writes:
> * I have indeed installed MySQL as a service. That's why I use 'net stop
> mysql' and 'net start mysql' to start and stop the MySQL server.
>
> * I have done nothing special before rebooting my PC. The problem doesn't
> seem to lay in rebooting the PC, but in stopping and
Two questions :
* have you installed MySQL as a service ??
* have you stopeed a service prior to rebooting ??
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\
gt; | 5 | test | 1 |
> +---+---+-+
>
> mysql > quit;
> C:\>net stop mysql
> C:\>net start mysql
>
> mysql > select * from metaoid;
> +---+---+-+
> | objid | tablename
I see no column named Site.nome showing that it is wrong.
ds wrote:
>Hi,
>
>I'm having a strange problem using SQL vars (@variable) and an order by
>expression.
>
>I have a query that returns a record for each day.
>Each record has a date (data), a column with the daily total value
>(uv_views)
Hi,
I'm having a strange problem using SQL vars (@variable) and an order by
expression.
I have a query that returns a record for each day.
Each record has a date (data), a column with the daily total value
(uv_views) and other with the accumulated value until the current day
(acc_views). The ot
Hi!
On Nov 19, Ian Collins wrote:
> If you open a table using HANDLER,
>
> e.g, HANDLER MYTABLE OPEN;
>
> then during the course of your application truncate that table,
>
> e.g, TRUNCATE TABLE MYTABLE;
>
> then you get some really wierd behaviour (my wierd behaviour was the
> applicatio
On Monday 19 November 2001 09:51, you wrote:
> Hello,
> started a new compiled MysqlDataBase on my local Machine
> everything okay sofar.
> added a ./bin/mysqladmin -u root password '' (password omitted)
> no problem
> I tried it several times to log in to create a database but only gettin
Ian Collins writes:
> If you open a table using HANDLER,
>
> e.g, HANDLER MYTABLE OPEN;
>
> then during the course of your application truncate that table,
>
> e.g, TRUNCATE TABLE MYTABLE;
>
> then you get some really wierd behaviour (my wierd behaviour was the
> application rolling on a
Hello,
started a new compiled MysqlDataBase on my local Machine
everything okay sofar.
added a ./bin/mysqladmin -u root password '' (password omitted)
no problem
I tried it several times to log in to create a database but only getting
this:
>behrens@ws8:/home/behrens/behrens_local/mysql-3
If you open a table using HANDLER,
e.g, HANDLER MYTABLE OPEN;
then during the course of your application truncate that table,
e.g, TRUNCATE TABLE MYTABLE;
then you get some really wierd behaviour (my wierd behaviour was the
application rolling on a free in a completely different part of t
Hi,
I just experienced a strange bug in MySQL 3.23.39 I couldn't explain (and couldn't
reproduce, it's why I post it on this list ;))
I misconfigured my my.cnf, so MySQL didn't found the host.frm.
The strange behaviour is just after the normal shutdown of mysql :
010
Andre,
the strange behavior may have been due to the same bug Alex
Baumeister reported, and for which I posted a fix on the mailing
list a few minutes ago.
After you had reloaded the table, did you insert, update, or delete
any rows in the table? Or did you just do selects? Did you have any
othe
Heikki, here are more details ...
I' am running mysql-3.23.37 on a hp-ux11 box (with actual patches)
I used the following configure options to compile MySQL:
CXX=gcc
CFLAGS="-fomit-frame-pointer -O6 -fpic"
CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O6"
./configure --with-low-m
Andre,
it might be a bug in the multiversioning code in InnoDB.
Can you describe in detail the situation:
- What is the CREATE TABLE statement?
- How many rows there are in the table?
- How did you import the table?
- Are you able to repeat the bug if you delete and drop the table,
and create
Hi,
I accidently delete all my records from a table, but I always make backups!!!
Okay, I deleted the (empty) table with drop table.
Than I recreate the table and all the data mith a mysql batch job (from
mysqldump) .
No problem. Than I started the mysql UI and make some test queries.
select *
41 matches
Mail list logo
