Bugs item #648807, was opened at 2002-12-04 20:44
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=648807&group_id=22866

Category: JBossTest
Group: v4.0
Status: Closed
Resolution: Fixed
Priority: 5
Submitted By: David Jencks (d_jencks)
Assigned to: Peter Fagerlund (peter_f)
Summary: databaseMetaData.getTables has changed

Initial Comment:
Apparently there is a problem of some sort with hslqdb 1.7.1 and 
databaseMetaData.getTables not reporting that a table already 
exists.

This can be seen by running 
org.jboss.test.bmp.test.BMPUnitTestCase twice after a clean 
build on jboss 4 (head).  The first run succeeds, but the second 
fails due to an attempt to create an existing table.

----------------------------------------------------------------------

Comment By: Jeremy Boynes (jboynes)
Date: 2002-12-04 23:37

Message:
Logged In: YES 
user_id=378919

I also meant to add, I believe (but can't verify) the
standard says the unquoted name should match to a quoted
name containing only uppercase letters i.e simpleBean is the
same as "SIMPLEBEAN" which is why the search must use all
uppercase characters

----------------------------------------------------------------------

Comment By: Jeremy Boynes (jboynes)
Date: 2002-12-04 23:30

Message:
Logged In: YES 
user_id=378919

The SQL standard says unquoted identifiers are
case-insensitive but quoted ones are case-sensitive. So a
database supporting quoted identifers may have two
_different_ tables called, for example, "simpleBean" and
"SIMPLEBEAN". hsqldb 1.6 did not support quoted identifiers
so probably allowed case-insensitve metadata searches to
match identifier lookup. When support for quoted identifiers
was added in 1.7 they would have had to change the search
behaviour to case-sensitive to distinguish the two tables
above. This is consistent with other platforms e.g. Oracle.

----------------------------------------------------------------------

Comment By: David Jencks (d_jencks)
Date: 2002-12-04 23:10

Message:
Logged In: YES 
user_id=60525

Following a comment in a patch for 3.2, I changed all the sql identifiers 
to uppercase which fixes the immediate problem with the test case.  I'm 
still curious why a lowercase string won't retrieve the table name: this 
seems to me to be a bug in hsqldb.  Comments, peter?
thanks
david jencks

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=648807&group_id=22866


-------------------------------------------------------
This SF.net email is sponsored by: Microsoft Visual Studio.NET 
comprehensive development tool, built to increase your 
productivity. Try a free online hosted session at:
http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to