svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.sqlite / org.gvsig.sqlite.provider / src / test / resources / org / gvsig / sqlite / dal / testJsonValue.sql @ 47539
History | View | Annotate | Download (710 Bytes)
| 1 |
|
|---|---|
| 2 |
-- test Json Value Function SQL
|
| 3 |
|
| 4 |
-- JsonValueWhere
|
| 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 |
|
| 7 |
-- Count
|
| 8 |
|