Revision 47606 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/java/org/gvsig/sqlite/dal/operations/usecases/arena2/TestArena2OrderByExtraValue.java

View differences:

TestArena2OrderByExtraValue.java
61 61 

  		




  62
  62
  
    
            List<String> expectedSQLs = utils().getExpectedSQLs("usecases/arena2/testOrderByExtraValue.sql");


  		




  63
  63
  
    

  		




  64
  
  
    
            DatabaseWorkspaceManager ws = TestArena2Utils.initDatabase(utils(), "testGroupByForeignValue");


  		




  
  64
  
    
            DatabaseWorkspaceManager ws = TestArena2Utils.initDatabase(utils(), "testOrderByExtraValue");


  		




  65
  65
  
    
            SQLBuilder sqlbuilder = TestArena2Utils.createSQLBuilder(ws);


  		




  66
  66
  
    

  		




  67
  67
  
    

  		




  ......




  107
  107
  
    
            System.out.println("###### SQL:" + sqlcount + ";");


  		




  108
  108
  
    
            System.out.println("###### EXP:" + expectedSQLs.get(1) + ";");


  		




  109
  109
  
    
            assertEquals("Count SQL", expectedSQLs.get(1), sqlcount);


  		




  110
  
  
    
            TestArena2Utils.runSQLToCheckSyntax(utils(), "testOrderByExtraValue", sqlcount);


  		




  111
  110
  
    

  		




  112
  111
  
    
            ResultSetForSetProviderOperation resultSetForSetProvider = operations.createResultSetForSetProvider(


  		




  113
  112
  
    
                    table,


  		




  ......




  126
  125
  
    
            System.out.println("###### EXP:" + expectedSQLs.get(0) + ";");


  		




  127
  126
  
    

  		




  128
  127
  
    
            assertEquals("Select SQL", expectedSQLs.get(0), sql);


  		




  
  128
  
    

  		




  129
  129
  
    
            TestArena2Utils.runSQLToCheckSyntax(utils(), "testOrderByExtraValue", sqlcount);


  		




  
  130
  
    
            TestArena2Utils.runSQLToCheckSyntax(utils(), "testOrderByExtraValue", sql);


  		




  130
  131
  
    
            


  		




  131
  132
  
    
            


  		




  132
  133
  
    
        } catch (Throwable th) {


  		












Also available in:  Unified diff