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 / fetchFeatureProviderByReference.sql @ 47539
History | View | Annotate | Download (666 Bytes)
1 |
|
---|---|
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") = (?) ) |
21 |
LIMIT 1;
|