Revision 47606 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/resources/org/gvsig/sqlite/dal/testJsonValue.sql

View differences:

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

  		




  4
  4
  
    
-- JsonValueWhere 


  		




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


  		




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


  		




  6
  6
  
    

  		




  7
  7
  
    
-- Count


  		




  8
  8
  
    

  		












Also available in:  Unified diff