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:
Category:MySQL Server Severity:S2 (Serious)
Version:MySQL 4.0.25-standard OS:Any (?? Linux version ??)
Assigned to: CPU Architecture:Any

[11 Jul 2006 2:37] Joey Garcia
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 ;
[11 Jul 2006 2:39] Joey Garcia
This bug prevents our customers to from submiting there orders on an eCommerce site.  Please give it some attention.

[11 Jul 2006 6:26] Tonci Grgin
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
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)