MySQL Bugs: #20955: Pattern causes http error 406

Bug #20955	Pattern causes http error 406
Submitted:	11 Jul 2006 2:37	Modified:	11 Jul 2006 6:26
Reporter:	Joey Garcia	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	MySQL 4.0.25-standard	OS:	Any (?? Linux version ??)
Assigned to:		CPU Architecture:	Any

Description:
We get a HTTP error 406 when I run this SQL statement.
UPDATE `sizes` SET `sizes_name` = 'BCC - OS' WHERE `sizes_id` = '44444' LIMIT 1 ;

As it turns out, MySQL doesn't like the "CC -" part.

It still throws this error when the query is changed to:
UPDATE `sizes` SET `sizes_name` = 'CC -' WHERE `sizes_id` = '44444' LIMIT 1 ;

We need a workaround for this because the first query above is a value that we use daily.  

How to repeat:
Run this query

UPDATE `sizes` SET `sizes_name` = 'CC -' WHERE `sizes_id` = '44444' LIMIT 1 ;

This bug prevents our customers to from submiting there orders on an eCommerce site.  Please give it some attention.

Thanks

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

More info:
Resolving 406 errors - general
    This error occurs very infrequently in Web browsers, because most browsers will accept any data returned from your Web server.
    If the client is not a Web browser, then anyone can only investigate the problem by looking at the Accept headers generated by the client system and the data stream returned by the Web server. 

MySQL 4.0.28 BK on Suse 10:
C:\mysql\bin>mysql -uroot -hmunja --port=3307
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.28-log

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

mysql> use test;
Database changed
mysql> create table test20955 (
    ->   ID int unsigned not null AUTO_INCREMENT primary key,
    ->   Name VARCHAR(10) NOT NULL
    ->   );
Query OK, 0 rows affected (0.01 sec)

mysql> insert into test20955 values(1,"test 1"),(2,"test 2"),(44444,"test 3");
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> UPDATE `test20955` SET test20955.Name = 'CC -' WHERE test20955.ID = 44444
 LIMIT 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from test20955\G
*************************** 1. row ***************************
  ID: 1
Name: test 1
*************************** 2. row ***************************
  ID: 2
Name: test 2
*************************** 3. row ***************************
  ID: 44444
Name: CC -
3 rows in set (0.03 sec)

mysql>