Case Sensitivity

2010-03-24 Thread Pavel Bortnovskiy
Hello, all: when executing a statement, such as: select Id as id, Code as code, TypeStr as typeStr from MyTable against a Derby in-memory table, the ResultSetMetaData present column names all i

Re: Case Sensitivity

2010-03-24 Thread Peter Ondruška
select Id as "id", Code as "code", TypeStr as "typeStr" from MyTable On Wed, Mar 24, 2010 at 10:30 PM, Pavel Bortnovskiy wrote: > > Hello, all: > > when executing a statement, such as: > >                         select

Re: Case Sensitivity

2010-03-24 Thread Pavel Bortnovskiy
Thank you, Peter, for your prompt response. Is enclosing them in quotes the only way to do so? Is there any setting which can be applied to Derby (or a -Define), so that the quotes could be omitted? Peter Ondru?ka 03/24/2010 05:33 PM Please respond to "Derby Discussion" To Derby Discus

Re: Case Sensitivity

2010-03-24 Thread Peter Ondruška
Not that I know, this is by SQL standard. On Wed, Mar 24, 2010 at 10:43 PM, Pavel Bortnovskiy < pbortnovs...@jefferies.com> wrote: > > Thank you, Peter, for your prompt response. Is enclosing them in quotes the > only way to do so? Is there any setting which can be applied to Derby (or a > -Defin

Re: Query execution never ends

2010-03-24 Thread Witold Szczerba
2010/3/22 Bryan Pendleton : > I think it would be great if you can file an issue in the Derby tracking > system, and include these discussions, and the query plan information > that you have collected. Perhaps the topic of the issue could be > something like "inferior query plan chosen for outer jo

Re: Case Sensitivity

2010-03-24 Thread Mark Thornton
Peter Ondruška wrote: Not that I know, this is by SQL standard. On Wed, Mar 24, 2010 at 10:43 PM, Pavel Bortnovskiy mailto:pbortnovs...@jefferies.com>> wrote: Thank you, Peter, for your prompt response. Is enclosing them in quotes the only way to do so? Is there any setting which can

Re: Case Sensitivity

2010-03-24 Thread Pavel Bortnovskiy
Thank you, Mark and Peter, for your immediate help and explanation. Mark Thornton 03/24/2010 06:02 PM Please respond to "Derby Discussion" To Derby Discussion cc Subject Re: Case Sensitivity Peter Ondru?ka wrote: > Not that I know, this is by SQL standard. > > On Wed, Mar 24, 201