Issue 81 in sarasvati: Error in creating Foreign Key

[sara...@googlecode.com]

Status: New
Owner: ----

New issue 81 by veny...@yahoo.com: Error in creating Foreign Key
http://code.google.com/p/sarasvati/issues/detail?id=81

What steps will reproduce the problem?
1. Execute ALTER TABLE wf_process
ADD CONSTRAINT FK_process_parent
FOREIGN KEY (parent_token_id)
REFERENCES wf_node_token;
2. All other database scripts executed successfully except for the above.
Also there is no parent_token_id reference in wf_node_token table.
3. Please help with correct statement.

What is the expected output? What do you see instead?
ERROR 1005 (HY000): Can't create table 'workflow.#sql-1518_75' (errno: 150)


Please use labels and text to provide additional information.
Using MySQL 5.5 on Windows XP Pro.

[sara...@googlecode.com]

Comment #1 on issue 81 by veny...@yahoo.com: Error in creating Foreign Key
http://code.google.com/p/sarasvati/issues/detail?id=81

alter table wf_process
add constraint FK_process_parent
foreign key (parent_token_id) references wf_node_token(id);

The reference is (id) which was missing in Saravathi 1.4. The above
statement is from 2.0.1.

This issue can be closed. Thanks.

[sara...@googlecode.com]

Updates:
Status: Invalid

Comment #2 on issue 81 by plor...@gmail.com: Error in creating Foreign Key
http://code.google.com/p/sarasvati/issues/detail?id=81

Just got a chance to look at this today. Thank you for the clarification.
Closing as requested.