[TORQUE-104] Sybase DBMS DDL errors

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Won't Fix
• Affects Version/s: 3.3-RC2
• Component/s: Generator
• Environment: machine on Windows XP - used Sybase 15.0.2 Developer Edition, Maven 2.07 and plugin 3.3-RC2
• Assignee: Unassigned
• Reporter: Sylvain Benoist
• Created: 10/Oct/07 13:23
• Updated: 27/Sep/12 19:38
• Resolved: 03/Jul/11 18:52

Description

used goals torque:sql ; torque:sqlExec

When the *-schema.xml file contains descriptions on tables and/or columns, the torque:sql goal generates a DDL that contains instructions like
'COMMENT ON TABLE blahblahblah IS 'some description' or 'COMMENT ON COLUMN blahblah IS...
Sybase does not support these, so they should be suppressed from the output when Sybase is the target database.

Another issue - Sybase does not like ';' in the DDL – all it wants to see is LF/CR, and 'go' statements