This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

View | Details | Raw Unified | Return to bug 200368
Collapse All | Expand All

(-)db.sql.editor/src/org/netbeans/modules/db/sql/editor/completion/SQLCompletionQuery.java (-1 / +1 lines)
Lines 441-447 Link Here
441 
    private void completeTuple(Identifier ident) {
 441 
    private void completeTuple(Identifier ident) {
442 
        if (ident.fullyTypedIdent.isEmpty()) {
 442 
        if (ident.fullyTypedIdent.isEmpty()) {
443 
            completeTupleSimpleIdent(ident.lastPrefix, ident.quoted);
 443 
            completeTupleSimpleIdent(ident.lastPrefix, ident.quoted);
444 
        } else if (ident.fullyTypedIdent.isSimple()) {
 444 
        } else {
445 
            completeTupleQualIdent(ident.fullyTypedIdent, ident.lastPrefix, ident.quoted);
 445 
            completeTupleQualIdent(ident.fullyTypedIdent, ident.lastPrefix, ident.quoted);
446 
        }
 446 
        }
447 
    }
 447 
    }
(-)db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/SelectCompletionQueryTest.java (+4 lines)
Lines 137-142 Link Here
137 
        suite.addTest(new SelectCompletionQueryTest("selectAfterDeclare"));
 137 
        suite.addTest(new SelectCompletionQueryTest("selectAfterDeclare"));
138 
        suite.addTest(new SelectCompletionQueryTest("selectAfterSet"));
 138 
        suite.addTest(new SelectCompletionQueryTest("selectAfterSet"));
139 

          139
          

        

            

              
              
              140
              
        // #200368: CC does not work with fully qualified names (catalog, schema) 

            

            

              141
              
        //          table names are not completed

            

            

              142
              
        suite.addTest(new SelectCompletionQueryTest("selectQualifiedIdentifierFrom"));

            

            

              143
              
        

            

        

          140
          
        return suite;

          144
          
        return suite;

        

        

          141
          
    }

          145
          
    }

        

        

          142
          

          146
          

        



(-)db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.pass
      (-2 / +2 lines)




  

    
      
            Lines 1-2
          
      
      
        Link Here
      
    
  

          
            

              1
              
Column invoice_id in table acatalog.accounting.invoice


              1
              
Table customer

            

            

              2
              
Column customer_id in table acatalog.accounting.invoice


              2
              
Table invoice

            



(-)db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.test
      (-1 / +1 lines)




  

    
      
            Lines 1-4
          
      
      
        Link Here
      
    
  

          
            

              1
              
select acatalog.accounting.invoice.|


              1
              
select * from acatalog.accounting.|

            

        

          2
          

          2
          

        

        

          3
          
--

          3
          
--

        

        

          4
          
<unknown>

          4
          
<unknown>

        






  

  Return to bug 200368