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 @ 47606
History | View | Annotate | Download (479 Bytes)
| 1 |
|
|---|---|
| 2 |
-- test Json Value Function SQL
|
| 3 |
|
| 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", "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 |
|
| 7 |
-- Count
|
| 8 |
|