ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 30760] - sql task handle pl/sql with ';' in pl/sql code. (patch)
Date Tue, 24 Aug 2004 11:40:15 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=30760>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=30760

sql task handle pl/sql with ';' in pl/sql code. (patch)





------- Additional Comments From j_a_fernandez@yahoo.com  2004-08-24 11:40 -------

OK, took a look at what actually your example here says and I am even more 
horrified than before 8-O

Aparently in POSTGRESSQL an stored procedure is of the form:
  "CREATE" ... "AS" <multi-line-string> ";"

This is extremely POSTGRESS specific, it seems like. Certaintly it does not 
match SQL99 spec which is the one standarizing PSMs (i.e., stored procedures).
The truth is that as with any other programming language, there is no unique 
separator in SQL99, you need to understand the grammar of the language to know 
when things end due to the presence of nested statements.

What the current <sql/> does is a complete hack. I may be willing to accept 
that <sql/> should be able ignore the ending char when inside a SQL string,
which is the fundamental of what you provide. But we need to think not only 
on '....' SQL strings, but maybe also on "....." SQL table names, for example.

Notice that this does not mean that this will solve any of the issues you were 
pretending to solve (i.e., a CREATE statement in SQL99 can have multiple ";"s 
outside strings). But it may just happen to be enough for POSGRESS.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org


Mime
View raw message