table names in getCrossReference() are case sensitive

[GoogleCodeExporter]

Before submitting a bug, please check the FAQ:
http://www.h2database.com/html/faq.html

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. Create two tables 'a' and 'b', with 'b' having a foreign key reference to 
'a'.
2. With the JDBC driver: connection.getMetadata().getCrossReference(null, null, 
'a', null, null, 'b') returns an empty set.

What is the expected output? What do you see instead?

* the call above should return a result set with the appropriate row from  
INFORMATION_SCHEMA.CROSS_REFERENCES

Version: 1.3.170

Do you know a workaround?

specify the table names in upper case

Feel free to contact me if it is not clear or additional information is needed. 

Original issue reported on code.google.com by lopez.ju...@gmail.com on 11 Feb 2013 at 11:53

[GoogleCodeExporter]

As far as I know, it's not a bug but the way it's supposed to work (same as 
other metadata methods).

Original comment by thomas.t...@gmail.com on 12 Feb 2013 at 5:48

• Changed state: Invalid

[GoogleCodeExporter]

Thanks for the prompt reply.

It is confusing because the table identifier is specified in lower case at 
creation time, and as far as I could tell, the JDBC documentation does not 
specify case sensitivity for the getCrossReference(), getImportedKeys(), 
getExportedKeys(), etc.  Could you elaborate on what the expected behavior is?

Thanks in advance.

Original comment by lopez.ju...@gmail.com on 12 Feb 2013 at 6:31

[GoogleCodeExporter]

For questions, please use StackOverflow.

Original comment by thomas.t...@gmail.com on 12 Feb 2013 at 7:09