I agree with Bernt that the optimizer override syntax will be more intuitive with /*..*/ form of comments. With the current -- syntax, you can be taken by surprise if one forgets that everything after -- is considered comment and hence the actual sql should not be included there.
Mamta On 3/10/07, Bernt M. Johnsen <[EMAIL PROTECTED]> wrote:
I think this discussion is another arument for https://issues.apache.org/jira/browse/DERBY-1749 Then an example could be ResultSet rs = s.executeQuery( "SELECT num, addr FROM derbyDB /*derby-properties index=IDX1*/ order by num"); while "SELECT num, addr FROM derbyDB /*derby-properties index=IDX1 order by num"); should give a syntax error. -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) iD8DBQFF8vJ1lFBD9TXBAPARAlV+AJ0U+WtRGZQiwLuCI49my6289Hr5WgCeLpWK zRhhMPknYIVO2wrEE+HK8Dk= =umCn -----END PGP SIGNATURE-----
