Re: FW: mySQL Question

Hi!

On Oct 22, J. Phul wrote:
> Hello Sergei,
> As per your request I'm posting to the bugs and CCd you for this e-mail
> only.
>
> Okay, when I look at my installer files, it is clearly labeled as
> 3.23.52. If I use mySQL-Front from my PC, it says the same thing. When I
> use the command line on the UNIX box, it says:
> mysql Ver 11.16 Distrib 3.23.49, for redhat-linux-gnu (i386)
>
> I'm a little confused why the versions are different. My assumption is
> the server is one version while the client is another?

yes, it's possible and quite normal.
to check server's version use

SELECT VERSION();

> Unfortunately I am experiencing this problem and am not sure what other
> info I can offer.

Complete set or commands to show the bug.
You've sent CREATE TABLE and INSERTs already, saying that UPDATE should
fail - it doesn't for me. I can assume, your UPDATE was different.
What UPDATE command did you use that failed ?

> What distribution did you run the test on?

mysql-3.23.52-pc-linux-gnu-i686.tar.gz

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12820@lists.mysql.com
To unsubscribe, e-mail

RE: FW: mySQL Question

Hi... and thanks for all the prompt responses! :)
Answers to your questions first:
Yes, I'm using 'mysql-3.23.52-pc-linux-gnu-i686.tar.gz' and had
downloaded it from the mySQL site.

I also did SELECT VERSION() and got: 3.23.52-log

As for the update, I've listed it below along with the script for
creating the test table and values.


How-To-Repeat:
########## SQL START
#
# Table structure for table 'myTest'
#

CREATE TABLE `myTest` (
`id` tinyint(3) unsigned NOT NULL auto_increment,
`name` varchar(60) default NULL,
`description` text,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `id_2` (`id`),
FULLTEXT KEY `ft_name` (`name`,`description`)
) TYPE=MyISAM;



#
# Dumping data for table 'myTest'
#
INSERT INTO `myTest` VALUES("1","name 1","This is record 1.");
INSERT INTO `myTest` VALUES("2","name 2","This should be the second
record.\r\n");


#Then I use the following command to update a record:
UPDATE myTest SET name='name1 Changed' WHERE name='name 1';

########## SQL END

As soon as the UPDATE runs, I get the error.
Sergei, are you testing on the same distribution as well? If not, what
version are you running?
~jerry


-----Original Message-----
From: Sergei Golubchik [mailto:serg@mysql.com]
Sent: Tuesday, October 22, 2002 3:12 PM
To: J. Phul
Cc: bugs@lists.mysql.com
Subject: Re: FW: mySQL Question

Hi!

On Oct 22, J. Phul wrote:
> Hello Sergei,
> As per your request I'm posting to the bugs and CCd you for this
e-mail
> only.
>
> Okay, when I look at my installer files, it is clearly labeled as
> 3.23.52. If I use mySQL-Front from my PC, it says the same thing. When
I
> use the command line on the UNIX box, it says:
> mysql Ver 11.16 Distrib 3.23.49, for redhat-linux-gnu (i386)
>
> I'm a little confused why the versions are different. My assumption is
> the server is one version while the client is another?

yes, it's possible and quite normal.
to check server's version use

SELECT VERSION();

> Unfortunately I am experiencing this problem and am not sure what
other
> info I can offer.

Complete set or commands to show the bug.
You've sent CREATE TABLE and INSERTs already, saying that UPDATE should
fail - it doesn't for me. I can assume, your UPDATE was different.
What UPDATE command did you use that failed ?

> What distribution did you run the test on?

mysql-3.23.52-pc-linux-gnu-i686.tar.gz

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12856@lists.mysql.com
To unsubscribe, e-mail

Re: FW: mySQL Question

Hi!

On Oct 24, J. Phul wrote:
> Hi... and thanks for all the prompt responses! :)
> Answers to your questions first:
> Yes, I'm using 'mysql-3.23.52-pc-linux-gnu-i686.tar.gz' and had
> downloaded it from the mySQL site.
>
> I also did SELECT VERSION() and got: 3.23.52-log
>
> As for the update, I've listed it below along with the script for
> creating the test table and values.

Still no luck :(

============================================================ ==

% mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.52

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 3.23.52 |
+-----------+
1 row in set (0.01 sec)

mysql> CREATE TABLE `myTest` (
-> `id` tinyint(3) unsigned NOT NULL auto_increment,
-> `name` varchar(60) default NULL,
-> `description` text,
-> PRIMARY KEY (`id`),
-> UNIQUE KEY `id` (`id`),
-> KEY `id_2` (`id`),
-> FULLTEXT KEY `ft_name` (`name`,`description`)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO `myTest` VALUES("1","name 1","This is record 1.");
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `myTest` VALUES("2","name 2","This should be the second record.\r\n");
Query OK, 1 row affected (0.00 sec)

mysql> UPDATE myTest SET name='name1 Changed' WHERE name='name 1';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM myTest;
+----+---------------+-------------------------------------+
| id | name | description |
+----+---------------+-------------------------------------+
| 1 | name1 Changed | This is record 1. |
| 2 | name 2 | This should be the second record.
|
+----+---------------+-------------------------------------+
2 rows in set (0.01 sec)

mysql> Bye
============================================================ ==

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12857@lists.mysql.com
To unsubscribe, e-mail