Revision 2324 org.gvsig.cvsgis/trunk/org.gvsig.cvsgis/org.gvsig.cvsgis.lib/org.gvsig.cvsgis.lib.impl/src/main/java/org/gvsig/cvsgis/impl/localdb/tables/notas.txt

View differences:

notas.txt
40 40 
SELECT * FROM CVSGIS_DATA ORDER BY "data_identifier","data_operation";
41 41 

  		




  42
  42
  
    

  		




  
  43
  
    
-- CHECKOUT


  		




  43
  44
  
    
SELECT CVSGIS_DATA.* FROM 


  		




  44
  45
  
    
  ( SELECT "data_identifier", MAX("data_revnumber") AS "data_revnumber" FROM 


  		




  45
  46
  
    
      CVSGIS_DATA 


  		




  ......




  51
  52
  
    
  CVSGIS_DATA


  		




  52
  53
  
    
ON T1."data_identifier" = CVSGIS_DATA."data_identifier" AND 


  		




  53
  54
  
    
   T1."data_revnumber" = CVSGIS_DATA."data_revnumber"


  		




  
  55
  
    
;


  		




  54
  56
  
    

  		




  55
  57
  
    

  		




  
  58
  
    
-- INSERTEDS AND UPDATEDS


  		




  
  59
  
    
SELECT CVSGIS_DATA.* FROM 


  		




  
  60
  
    
  ( SELECT "data_identifier", MAX("data_revnumber") AS "max_revnumber" FROM 


  		




  
  61
  
    
      CVSGIS_DATA 


  		




  
  62
  
    
    WHERE "cod_branch" = 'master'AND "data_revnumber" >=1


  		




  
  63
  
    
    GROUP BY "data_identifier" 


  		




  
  64
  
    
    HAVING MIN("data_operation")<>0


  		




  
  65
  
    
  ) AS T1


  		




  
  66
  
    
LEFT JOIN 


  		




  
  67
  
    
  CVSGIS_DATA


  		




  
  68
  
    
ON T1."data_identifier" = CVSGIS_DATA."data_identifier" AND 


  		




  
  69
  
    
   T1."max_revnumber" = CVSGIS_DATA."data_revnumber"


  		




  
  70
  
    
;


  		




  56
  71
  
    

  		












Also available in:  Unified diff