EOM Generating SQL for MySQL 5

From: Klaus Berkling (kberklin..yned.com)
Date: Fri Jun 13 2008 - 16:46:51 EDT

  • Next message: Mike Schrag: "Re: EOM Generating SQL for MySQL 5"

    Anyone seen this? Can't just be me.

    The SQL generated by Entity Modeler puts quotes around the column
    names and MySQL does not seem to like it.

    Works:
            CREATE TABLE Country (_id INT NOT NULL);

    Does not:
            CREATE TABLE Country ("_id" INT NOT NULL);

            ERROR 1064 (42000) at line <n>

    MySQL:
    mysql Ver 14.12 Distrib 5.0.51a, for apple-darwin8.5.1 (i686) using
    readline 5.0

    Eclipse:
    Version: 3.3.2
    Build id: M20080221-1800

    WOLips:
    First seen in 5047 and reproduces in 5233

    Thanks

    kib

    "Success is not final, failure is not fatal: it is the courage to
    continue that counts.”
    - Winston Churchill

    Klaus Berkling
    Systems Administrator
    DynEd International, Inc.
    www.dyned.com | www.eskimo.com/~kiberkli


    This archive was generated by hypermail 2.0.0 : Fri Jun 13 2008 - 16:48:08 EDT