db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject Re: How to execute optimizer overrides in a java app
Date Sun, 11 Mar 2007 03:11:44 GMT
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 <Bernt.Johnsen@sun.com> 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-----
>
>

Mime
View raw message