Xerial SQLite JDBC is limited to upper-case table names

[GoogleCodeExporter]

Thank you for creating Xerial SQLite JDBC as Open Source software.

This issue has been discussed in the SchemaCrawler support form thread
https://sourceforge.net/projects/schemacrawler/forums/forum/495991/topic/3471755

What steps will reproduce the problem?
1. create an SQLite database with at least one table whose name is
lower-case or mixed-case.
2. try to access the database with Xerial SQLite JDBC (I use SchemaCrawler.)

What is the expected output? What do you see instead?
1. Xerial SQLite JDBC finds ALL tables.
2. Xerial SQLite JDBC finds ALL columns in each table.
3. Xerial SQLite JDBC succeeds when accessing any table whose name contains
no lower-case letters.
4. Xerial SQLite JDBC *FAILS* when accessing any table whose name contains
any lower-case letter.  

I suspect this may be because when Xerial SQLite JDBC reads the table
schema, it uses "SELECT ... upper(name) as TABLE_NAME ..." in GetTables. 
I'm not a Java programmer, so I would be wrong.

I am using the version of Xerial SQLite JDBC bundled with SchemaCrawler 7.5
and version 3.6.16 of SQLite.

All testing was performed on Ubuntu Karmic Koala with IcedTea 1.6.1

Thank you for your time and expertise.

Kyle

Original issue reported on code.google.com by kfer...@gmail.com on 27 Nov 2009 at 9:26

[GoogleCodeExporter]

The milestone should be reset to Xerial SQLite JDBC and the Opsys should be 
reset to
Linux.  Sorry--I don't see a way to change those now that I've created the 
issue.

Original comment by kfer...@gmail.com on 27 Nov 2009 at 9:33

[GoogleCodeExporter]

Original comment by taroleo on 5 Dec 2009 at 4:06

• Added labels: Milestone-sqlite-jdbc-3.6.20
• Removed labels: Milestone-xerial-core-1.1

[GoogleCodeExporter]

Fixed at http://code.google.com/p/xerial/source/diff?
spec=svn.sqlite.b089584d68ad1adae65ae314d207c40e7f35fb62&repo=sqlite&r=b089584d6
8ad1ada
e65ae314d207c40e7f35fb62&format=side&path=/src/main/java/org/sqlite/MetaData.jav
a

Original comment by taroleo on 8 Dec 2009 at 6:28

• Changed state: Fixed