Revision 47119
trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.file/org.gvsig.fmap.dal.file.csv/src/test/java/org/gvsig/fmap/dal/store/csv/TestFilter1.java | ||
---|---|---|
58 | 58 |
filter.append(" WHERE "); |
59 | 59 |
filter.append(" continents.NAME = countries.CONTINENT AND "); |
60 | 60 |
filter.append(" countries.SOV_A3 = 'GB1' "); //FR1=4, GB1=6 |
61 |
filter.append(" LIMIT 1; ");
|
|
61 |
filter.append(" LIMIT 1 "); |
|
62 | 62 |
filter.append(")"); |
63 | 63 |
|
64 | 64 |
FeatureStore continents = TestUtils.openSourceContinents(); |
... | ... | |
77 | 77 |
filter.append(" WHERE "); |
78 | 78 |
filter.append(" continents.NAME = countries.CONTINENT AND "); |
79 | 79 |
filter.append(" countries.SOV_A3 = 'FR1' "); //FR1=4, GB1=6 |
80 |
filter.append(" LIMIT 1; ");
|
|
80 |
filter.append(" LIMIT 1 "); |
|
81 | 81 |
filter.append(")"); |
82 | 82 |
|
83 | 83 |
FeatureStore continents = TestUtils.openSourceContinents(); |
trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/test/java/org/gvsig/fmap/dal/store/h2/operations/sql/TestResultSetForSetProvider.java | ||
---|---|---|
563 | 563 |
filter.append(" WHERE "); |
564 | 564 |
filter.append(" test.STRING = countries.CONTINENT AND "); |
565 | 565 |
filter.append(" countries.LASTCENSUS < 0 "); |
566 |
filter.append(" LIMIT 1;, ");
|
|
566 |
filter.append(" LIMIT 1, "); |
|
567 | 567 |
filter.append(" 'EXISTS62a964cd7bc24f409b97c03b9170408d' "); |
568 | 568 |
filter.append(")"); |
569 | 569 |
FeatureType featureType = sourceStore.getDefaultFeatureType(); |
... | ... | |
613 | 613 |
filter.append(" WHERE "); |
614 | 614 |
filter.append(" test.STRING = countries.CONTINENT AND "); |
615 | 615 |
filter.append(" countries.LASTCENSUS < 0 "); |
616 |
filter.append(" LIMIT 1;, ");
|
|
616 |
filter.append(" LIMIT 1, "); |
|
617 | 617 |
filter.append(" 'EXISTS62a964cd7bc24f409b97c03b9170408d' "); |
618 | 618 |
filter.append(")"); |
619 | 619 |
FeatureType featureType = sourceStore.getDefaultFeatureType(); |
... | ... | |
661 | 661 |
filter.append(" WHERE "); |
662 | 662 |
filter.append(" test.STRING = countries.CONTINENT AND "); |
663 | 663 |
filter.append(" countries.LASTCENSUS < 0 "); |
664 |
filter.append(" LIMIT 1;, ");
|
|
664 |
filter.append(" LIMIT 1, "); |
|
665 | 665 |
filter.append(" 'EXISTS62a964cd7bc24f409b97c03b9170408d' "); |
666 | 666 |
filter.append(")"); |
667 | 667 |
FeatureType featureType = sourceStore.getDefaultFeatureType(); |
Also available in: Unified diff