[Bug 690131] Re: mysqlimport fails on table names which are keywords if unescaped

[Clint Byrum]

cputoaster, I was unable to confirm this on maverick or natty:

(natty-amd64)root at clint-MacBookPro:~# mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.1.49-1ubuntu8.1 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> create database test;
Query OK, 1 row affected (0.00 sec)

mysql> use test;
Database changed
mysql> CREATE TABLE `load` (   `Timestamp` datetime NOT NULL,   `Value` double unsigned NOT NULL,   `QUALIF` varchar(45) NOT NULL,   `DS` varchar(45) NOT NULL,   `Platform` varchar(45) NOT NULL,   `Object` varchar(45) NOT NULL,   `Computer` varchar(45) NOT NULL,   PRIMARY KEY  (`Timestamp`,`QUALIF`,`DS`,`Object`,`Computer`) );
Query OK, 0 rows affected (0.08 sec)

mysql> Bye
(natty-amd64)root at clint-MacBookPro:~# mysqlimport --ignore --fields-terminated-by=\; test /tmp/load.txt
test.load: Records: 0  Deleted: 0  Skipped: 0  Warnings: 0

Can you explain further why you believe this bug to still be a problem?

** Changed in: mysql-5.1 (Ubuntu)
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in ubuntu.
https://bugs.launchpad.net/bugs/690131

Title:
  mysqlimport fails on table names which are keywords if unescaped