0 Replies Latest reply on Oct 25, 2002 3:15 PM by José Luis

    is this a bug?

    José Luis Newbie

      I am using jboss-3.0.3_tomcat-4.1.12 , mysql and CMP 2.0 .
      I get this wrong sql sentence:

      ALTER TABLE events ADD INDEX ind_nplan, anio (nplan, anio), ADD CONSTRAINT fk_events_party FOREIGN KEY (nplan, anio) REFERENCES parties (anio, nplan)

      due to my standardjbosscmp-jdbc.xml:
      <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>

      Is this a bug?