Revision 74
| trunk/org.gvsig.mssqlserver/org.gvsig.mssqlserver.provider/src/test/java/org/gvsig/fmap/dal/store/jdbc2/SQLBuilderTest.java | ||
|---|---|---|
| 155 | 155 |
45, |
| 156 | 156 |
0, |
| 157 | 157 |
false, |
| 158 |
false, |
|
| 158 | 159 |
true, |
| 159 | 160 |
false, |
| 160 | 161 |
null |
| ... | ... | |
| 166 | 167 |
0, |
| 167 | 168 |
true, |
| 168 | 169 |
false, |
| 170 |
false, |
|
| 169 | 171 |
true, |
| 170 | 172 |
0 |
| 171 | 173 |
); |
| ... | ... | |
| 175 | 177 |
0, |
| 176 | 178 |
0, |
| 177 | 179 |
false, |
| 180 |
false, |
|
| 178 | 181 |
true, |
| 179 | 182 |
false, |
| 180 | 183 |
null |
| trunk/org.gvsig.mssqlserver/org.gvsig.mssqlserver.provider/src/test/java/org/gvsig/mssqlserver/dal/MSSQLServerSQLBuilderTest.java | ||
|---|---|---|
| 211 | 211 |
45, |
| 212 | 212 |
0, |
| 213 | 213 |
false, |
| 214 |
false, |
|
| 214 | 215 |
true, |
| 215 | 216 |
false, |
| 216 | 217 |
null |
| ... | ... | |
| 222 | 223 |
0, |
| 223 | 224 |
true, |
| 224 | 225 |
false, |
| 226 |
false, |
|
| 225 | 227 |
true, |
| 226 | 228 |
0 |
| 227 | 229 |
); |
| ... | ... | |
| 231 | 233 |
0, |
| 232 | 234 |
0, |
| 233 | 235 |
false, |
| 236 |
false, |
|
| 234 | 237 |
true, |
| 235 | 238 |
false, |
| 236 | 239 |
null |
| trunk/org.gvsig.mssqlserver/org.gvsig.mssqlserver.provider/src/main/java/org/gvsig/mssqlserver/dal/MSSQLServerSQLBuilder.java | ||
|---|---|---|
| 56 | 56 |
config.set(SQLConfig.ST_GeomFromText, "geometry::STGeomFromText({0}, {1})");
|
| 57 | 57 |
config.set(SQLConfig.ST_GeomFromWKB, "geometry::STGeomFromWKB({0}, {1})");
|
| 58 | 58 |
config.set(SQLConfig.ST_GeomFromEWKB, "geometry::STGeomFromWKB({0}, {1})");
|
| 59 |
config.set(SQLConfig.ST_Simplify, "({0}).Reduce({1})");
|
|
| 59 | 60 |
config.set(SQLConfig.lcase, "LOWER({0})");
|
| 60 | 61 |
config.set(SQLConfig.ucase, "UPPER({0})");
|
| 61 | 62 |
config.set(SQLConfig.operator_ILIKE, "LOWER({0}) LIKE LOWER({1})");
|
Also available in: Unified diff