[ 
https://issues.apache.org/jira/browse/DERBY-2785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12880642#action_12880642
 ] 

Bryan Pendleton commented on DERBY-2785:
----------------------------------------

Hi Eranda,

I see you are right, there is no exception in the derby.log.

To see the stack trace, I had to add

  e.printStackTrace() ;

to the 2 catch() blocks near line 375 of 
java/tools/org/apache/derby/impl/tools/ij/utilMain.java

When I did that, I see:


ij> describe 'CamelCaseTable';
java.lang.NullPointerException
        at org.apache.derby.impl.tools.ij.ij.caIdentifier(ij.java:2635)
        at org.apache.derby.impl.tools.ij.ij.DescTableStatement(ij.java:1445)
        at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:1110)
        at 
org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:341)
        at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:261)
        at org.apache.derby.impl.tools.ij.Main.go(Main.java:229)
        at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:184)
        at org.apache.derby.impl.tools.ij.Main.main(Main.java:75)
        at org.apache.derby.tools.ij.main(ij.java:59)
JAVA ERROR: java.lang.NullPointerException

In my tree, line 2635 of ij.java is the line:


        haveConnection();
        DatabaseMetaData dbmd = theConnection.getMetaData();
        String identifier = i;

        if(t!=null)
            identifier = t.image;
        if (dbmd.storesLowerCaseIdentifiers())
            identifier = identifier.toLowerCase(Locale.ENGLISH);
        else if (dbmd.storesUpperCaseIdentifiers())
            identifier = identifier.toUpperCase(Locale.ENGLISH);       <====== 
THIS IS LINE 2635

        {if (true) return identifier;}
    throw new Error("Missing return statement in function");
  }

So 'identifier' must be NULL at this point.

Maybe you can investigate and determine why this is?

thanks,

bryan


> ij "describe" built in command cannot describe a table named "run"
> ------------------------------------------------------------------
>
>                 Key: DERBY-2785
>                 URL: https://issues.apache.org/jira/browse/DERBY-2785
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 10.2.2.0
>         Environment: OS-X, Java 1.5
>            Reporter: Tim Halloran
>            Assignee: Eranda Sooriyabandara
>            Priority: Minor
>         Attachments: caidentifier.diff, derby-2785.diff, derby-2785.diff, 
> derby-2785.diff, derbyall_report.txt, derbyall_report.txt, 
> describeKeywords.diff, junitAll.out, step logs.txt
>
>
> steps to duplicate:
> (attach ij to any database)
> ij> create table run (i int);
> 0 rows inserted/updated/deleted
> ij> desc run;
> ERROR 42X01: Syntax error: Encountered "desc" at line 1, column 1.
> ij> 
> I think this is a parser problem within ij where the "run" is taken as a 
> token and that token is not included in the definition of a tablename 
> expression in the grammer (should be an easy fix).

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to