Uploaded image for project: 'VPMS Web Application'
  1. OVPMS-2065

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

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0.2
    • Component/s: Release
    • Labels:
      None
    • Sprint:

      Description

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

      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:

      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:

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

        Attachments

          Activity

            People

            • Assignee:
              tanderson Tim Anderson
              Reporter:
              tanderson Tim Anderson
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 0.5h
                0.5h

                  Who's Looking?