Revision 46505 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/test/resources/org/gvsig/fmap/dal/store/h2/usecases/arena2/testMultipleExpansionOfCalculatedField.sql

View differences:

testMultipleExpansionOfCalculatedField.sql
34 34 
"PUBLIC"."ARENA2_CONDUCTORES"."OTRA_INFRAC_COND", "PUBLIC"."ARENA2_CONDUCTORES"."EXTRA",
35 35 
"PUBLIC"."ARENA2_ACCIDENTES"."KM" AS "AccKm0",
36 36 
("PUBLIC"."ARENA2_ACCIDENTES"."KM" * 100) AS "AccKm1",
37 
("PUBLIC"."ARENA2_ACCIDENTES"."KM" * 222) AS "AccKm2",
38 
"PUBLIC"."ARENA2_ACCIDENTES"."KM"
37 
("PUBLIC"."ARENA2_ACCIDENTES"."KM" * 222) AS "AccKm2"
39 38 
FROM "PUBLIC"."ARENA2_CONDUCTORES"
40 39 
LEFT JOIN "PUBLIC"."ARENA2_ACCIDENTES" ON ( ("PUBLIC"."ARENA2_CONDUCTORES"."ID_ACCIDENTE") = ("PUBLIC"."ARENA2_ACCIDENTES"."ID_ACCIDENTE") )
41 
ORDER BY "LID_CONDUCTOR" ASC LIMIT 15;
40 
ORDER BY "PUBLIC"."ARENA2_CONDUCTORES"."LID_CONDUCTOR" ASC LIMIT 15;
42 41 

  		




  43
  42
  
    
-- Count


  		




  44
  43
  
    
SELECT COUNT(*) FROM "PUBLIC"."ARENA2_CONDUCTORES";


  		












Also available in:  Unified diff