db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Susan Cline <home4...@pacbell.net>
Subject dblook and lower-case table names created with double-quotes, doc bug or "bug" bug?
Date Wed, 06 Sep 2006 19:28:41 GMT
In reviewing the dblook examples in the Tools and Utilities Guide:
 
http://db.apache.org/derby/docs/dev/tools/rtoolsdblookexamples.html
 
I noticed the output from using the -t flag with  dblook to specify a particular table created
using
lower case names and double-quotes is inconsistent when creating tablenames in upper case
and double-quoting the name.
 
Testing these combinations, case 3 and 5 do not work as expected.
 
Create tables in lower and upper case, some with one word, and quoted, some with multiple
words:
 
1) create table lower_case_one_word(id integer); 
 
2) create table UPPER_CASE_ONE_WORD(id integer);

3) create table "lower_case_quoted_word"(id integer); 
 
4) create table "UPPER_CASE_QUOTED_WORD"(id integer);

5)  create table "lower_case quoted three_words"(id integer); 
 
6) create table "UPPER_CASE QUOTED THREE_WORDS"(id integer);
 
I tested using dblook directly, org.apache.derby.tools.dblook and derbyrun.jar, with the same
results.
Use the -t argument for dblook:
 
3)     create  table "lower_case_quoted_word"(id integer); 
This does not work if it is passed if lower case, upper case or double quotes or not are used:
 
java -jar C:\derby_src\db-derby-10.2.1.2-bin\lib\derbyrun.jar dblook -d jdbc:derby://localhost:1527/C:\derby_s
rc\db-derby-10.2.1.2-bin\demo\databases\toursDB -z APP -t lower_case_quoted_word
-- Timestamp: 2006-09-06 11:01:30.9
-- Source database is: C:\derby_src\db-derby-10.2.1.2-bin\demo\databases\toursDB
-- Connection URL is: jdbc:derby://localhost:1527/C:\derby_src\db-derby-10.2.1.2
-bin\demo\databases\toursDB
-- The dblook utility will consider only specified tables.
-- Specified schema is: APP
-- appendLogs: false

 
java -jar C:\derby_src\db-derb-10.2.1.2-bin\lib\derbyrun.jar dblook -d jdbc:derby://localhost:1527/C:\derby_s
rc\db-derby-10.2.1.2-bin\demo\databases\toursDB -z APP -t "lower_case_quoted_word"
-- Timestamp: 2006-09-06 11:03:32.585
-- Source database is: C:\derby_src\db-derby-10.2.1.2-bin\demo\databases\toursDB
-- Connection URL is: jdbc:derby://localhost:1527/C:\derby_src\db-derby-10.2.1.2
-bin\demo\databases\toursDB
-- The dblook utility will consider only specified tables.
-- Specified schema is: APP
-- appendLogs: false
 
java -jar C:\derby_src\db-derby-10.2.1.2-bin\lib\derbyrun.jar dblook -d jdbc:derby://localhost:1527/C:\derby_s
rc\db-derby-10.2.1.2-bin\demo\databases\toursDB -z APP -t "LOWER_CASE_QUOTED_WORD"
-- Timestamp: 2006-09-06 12:17:43.425
-- Source database is: C:\derby_src\db-derby-10.2.1.2-bin\demo\databases\toursDB
-- Connection URL is: jdbc:derby://localhost:1527/C:\derby_src\db-derby-10.2.1.2
-bin\demo\databases\toursDB
-- The dblook utility will consider only specified tables.
-- Specified schema is: APP
-- appendLogs: false

java -jar C:\derby_src\db-derby-10.2.1.2-bin\lib\derbyrun.jar dblook -d jdbc:derby://localhost:1527/C:\derby_s
rc\db-derby-10.2.1.2-bin\demo\databases\toursDB -z APP -t LOWER_CASE_QUOTED_WORD
-- Timestamp: 2006-09-06 12:18:00.49
-- Source database is: C:\derby_src\db-derby-10.2.1.2-bin\demo\databases\toursDB
-- Connection URL is: jdbc:derby://localhost:1527/C:\derby_src\db-derby-10.2.1.2
-bin\demo\databases\toursDB
-- The dblook utility will consider only specified tables.
-- Specified schema is: APP
-- appendLogs: false
 
 
5)     create  table "lower_case quoted three_words"(id integer); 
This does not work whether the argument is in lower case or upper case and double quoted:
 
java -jar C:\derby_src\db-derby-10.2.1.2-bin\lib\derbyrun.jar dblook -d jdbc:derby://localhost:1527/C:\derby_s
rc\db-derby-10.2.1.2-bin\demo\databases\toursDB -z APP -t "lower_case quoted three_words"
-- Timestamp: 2006-09-06 11:09:11.352
-- Source database is: C:\derby_src\db-derby-10.2.1.2-bin\demo\databases\toursDB
-- Connection URL is: jdbc:derby://localhost:1527/C:\derby_src\db-derby-10.2.1.2
-bin\demo\databases\toursDB
-- The dblook utility will consider only specified tables.
-- Specified schema is: APP
-- appendLogs: false

java -jar C:\derby_src\db-derby-10.2.1.2-bin\lib\derbyrun.jar dblook -d jdbc:derby://localhost:1527/C:\derby_s
rc\db-derby-10.2.1.2-bin\demo\databases\toursDB -z APP -t "LOWER_CASE QUOTED THREE_WORDS"
-- Timestamp: 2006-09-06 12:20:42.553
-- Source database is: C:\derby_src\db-derby-10.2.1.2-bin\demo\databases\toursDB
-- Connection URL is: jdbc:derby://localhost:1527/C:\derby_src\db-derby-10.2.1.2
-bin\demo\databases\toursDB
-- The dblook utility will consider only specified tables.
-- Specified schema is: APP
-- appendLogs: false
 
Is this a doc bug or a bug in the code?
 
Thanks,
 
Susan

Mime
View raw message