Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.compat.cdc / org.gvsig.fmap.dal / org.gvsig.fmap.dal.db / org.gvsig.fmap.dal.db.h2 / src / test / resources / org / gvsig / fmap / dal / store / h2 / fetchFeatureProviderByReference.sql @ 44678

History | View | Annotate | Download (271 Bytes)

1 

    		
  

  

    
      2
    
    
      
-- Count SQL


    		
  

  

    
      3
    
    
      
SELECT 


    		
  

  

    
      4
    
    
      
  "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", 


    		
  

  

    
      5
    
    
      
  "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 


    		
  

  

    
      6
    
    
      
  NVL2("Geometry",ST_AsBinary("Geometry"),NULL) 


    		
  

  

    
      7
    
    
      
  FROM "PUBLIC"."test" 


    		
  

  

    
      8
    
    
      
  WHERE ( ("ID") = (?) ) LIMIT 1;