Revision 47579 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/resources/org/gvsig/sqlite/dal/fetchFeatureProviderByReference.sql
| fetchFeatureProviderByReference.sql | ||
|---|---|---|
| 1 | 1 |
|
| 2 | 2 |
-- Count SQL |
| 3 |
SELECT "PUBLIC"."test"."ID",
|
|
| 4 |
"PUBLIC"."test"."Byte",
|
|
| 5 |
"PUBLIC"."test"."Bool1",
|
|
| 6 |
"PUBLIC"."test"."Long",
|
|
| 7 |
"PUBLIC"."test"."Timestamp",
|
|
| 8 |
"PUBLIC"."test"."Date",
|
|
| 9 |
"PUBLIC"."test"."Time",
|
|
| 10 |
"PUBLIC"."test"."Bool2",
|
|
| 11 |
"PUBLIC"."test"."String",
|
|
| 12 |
"PUBLIC"."test"."Bool3",
|
|
| 13 |
"PUBLIC"."test"."Double",
|
|
| 14 |
"PUBLIC"."test"."Bool4",
|
|
| 15 |
"PUBLIC"."test"."Float",
|
|
| 16 |
"PUBLIC"."test"."Bool5",
|
|
| 17 |
"PUBLIC"."test"."Decimal",
|
|
| 18 |
NVL2("PUBLIC"."test"."Geometry",ST_AsBinary("PUBLIC"."test"."Geometry"),NULL)
|
|
| 19 |
FROM "PUBLIC"."test"
|
|
| 20 |
WHERE ( ("PUBLIC"."test"."ID") = (?) )
|
|
| 3 |
SELECT "test"."ID", |
|
| 4 |
"test"."Byte", |
|
| 5 |
"test"."Bool1", |
|
| 6 |
"test"."Long", |
|
| 7 |
"test"."Timestamp", |
|
| 8 |
"test"."Date", |
|
| 9 |
"test"."Time", |
|
| 10 |
"test"."Bool2", |
|
| 11 |
"test"."String", |
|
| 12 |
"test"."Bool3", |
|
| 13 |
"test"."Double", |
|
| 14 |
"test"."Bool4", |
|
| 15 |
"test"."Float", |
|
| 16 |
"test"."Bool5", |
|
| 17 |
"test"."Decimal", |
|
| 18 |
"test"."Geometry"
|
|
| 19 |
FROM "test" |
|
| 20 |
WHERE ( ("test"."ID") = (?) )
|
|
| 21 | 21 |
LIMIT 1; |
Also available in: Unified diff