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/testJsonValue.sql

View differences:

testJsonValue.sql
2 2 
-- test Json Value Function SQL
3 3 

  		




  4
  4
  
    
-- JsonValueWhere 


  		




  5
  
  
    
SELECT "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", NVL2("Geometry",ST_AsBinary("Geometry"),NULL), JSON_VALUE("String", '$.acc_cit') AS "JsonValue1" FROM "PUBLIC"."test" WHERE (JSON_VALUE("String", '$.acc_cit') = 1) ORDER BY "ID" ASC;


  		




  
  5
  
    
SELECT "PUBLIC"."test"."ID", "PUBLIC"."test"."Byte", "PUBLIC"."test"."Bool1", "PUBLIC"."test"."Long", "PUBLIC"."test"."Timestamp", "PUBLIC"."test"."Date", "PUBLIC"."test"."Time", "PUBLIC"."test"."Bool2", "PUBLIC"."test"."String", "PUBLIC"."test"."Bool3", "PUBLIC"."test"."Double", "PUBLIC"."test"."Bool4", "PUBLIC"."test"."Float", "PUBLIC"."test"."Bool5", "PUBLIC"."test"."Decimal", NVL2("PUBLIC"."test"."Geometry",ST_AsBinary("PUBLIC"."test"."Geometry"),NULL), JSON_VALUE("PUBLIC"."test"."String", '$.acc_cit') AS "JsonValue1" FROM "PUBLIC"."test" WHERE (JSON_VALUE("PUBLIC"."test"."String", '$.acc_cit') = 1) ORDER BY "PUBLIC"."test"."ID" ASC;


  		




  6
  6
  
    

  		




  7
  7
  
    
-- Count


  		




  8
  8
  
    

  		












Also available in:  Unified diff