Issue 81927

Summary:	[cws dba24a] mysql odbc releations design: error when delete a relation
Product:	Base	Reporter:	marc.neumann
Component:	code	Assignee:	ocke.janssen
Status:	CLOSED DUPLICATE	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	recent-trunk
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description marc.neumann 2007-09-25 10:00:38 UTC

I use
- Linux
- mysql 5.0.18
- mysql-connector-odbc-3.51.20-0
- the tables are create with this SQL command:
drop TABLE if EXISTS rel1 ;
CREATE TABLE `rel1` (
  `id` int(11) NOT NULL,
  `text_1` varchar(20) default NULL,
  `text_2` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

drop TABLE if EXISTS rel2;
CREATE TABLE `rel2` (
  `id` int(11) NOT NULL,
  `text_1` varchar(20) default NULL,
  `text_2` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

1. open a database with type mysql and ODBC to connect to the mysql server 
2. open TOOLS / RELATIONS
3. add table rel1 and rel2
4. d&d id field from rel1 to rel2
5. right click the relation
6. choose delete
==>> error messages: You have an error in your SQL syntax: 'CONSTRAINT 'NULL''

Comment 1 ocke.janssen 2007-09-25 12:43:12 UTC

.

*** This issue has been marked as a duplicate of 81921 ***

Comment 2 ocke.janssen 2007-09-25 12:43:29 UTC

Closing