We're updating the issue view to help you get more done. 

migrate-1.3-to-1.4.sql contains SQL rejected by MySQL 5.5

Description

The migrate-1.3-to-1.4.sql script contains the following statement, which fails in MySQL 5.5:

1 2 3 delete entity_classifications c from lookups l, entity_classifications c where c.lookup_id = l.Lookup_id and arch_short_name = "lookup.paymentType";

The error is:

1 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c from lookups l, entity_classifications c where c.lookup_id = l.Lookup_id and a' at line 1

For MySQL 5.5, it should be:

1 2 3 delete c from lookups l, entity_classifications c where c.lookup_id = l.Lookup_id and arch_short_name = "lookup.paymentType";

Environment

Status

Assignee

Tim Anderson

Reporter

Tim Anderson

Components

Fix versions

Affects versions

2.0

Priority

Minor