Revision 914

View differences:

org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/main/java/org/gvsig/oracle/dal/expressionbuilderformatter/OracleConstant.java
38 38
    @Override
39 39
    public String format(ExpressionBuilder.Value function) {
40 40
        Object value = ((Constant) function).value();
41
        if (value instanceof Geometry) {
41
        if( value instanceof Boolean ) {
42
            if( (Boolean)value ) {
43
                return "(1=1)";
44
            }
45
            return "(1<>1)";
46
        } else if (value instanceof Geometry) {
42 47
            Geometry geom = (Geometry) value; //function;
43 48
            try {
44 49
                switch (this.builder.geometry_support_type()) {
org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/test/java/org/gvsig/oracle/dal/OracleSQLBuilderTest.java
651 651
        );
652 652
    }
653 653

  
654
    
654
    public void testWhereTRUE() throws Exception {
655
        SQLBuilder sqlbuilder = createSQLBuilder();
656
        GeometryExpressionBuilder expbuilder = sqlbuilder.expression();
657

  
658
        sqlbuilder.update().table().database("master").schema("dbo").name("test1");
659
        sqlbuilder.update().where().set(expbuilder.constant(true));
660
        sqlbuilder.update().column().name("name").with_value(expbuilder.parameter("name"));
661

  
662
        System.out.println("# Test:: testTRUE");
663
        System.out.println("# SQL:: " + sqlbuilder.toString());
664
        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));
665
        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));
666
        assertEquals(
667
                "UPDATE \"dbo\".\"test1\" SET \"name\" = ? WHERE (1=1)",
668
                sqlbuilder.toString()
669
        );
670
        assertEquals(
671
                "[name]",
672
                ArrayUtils.toString(sqlbuilder.variables_names())
673
        );
674
        assertEquals(
675
                "[\"name\"]",
676
                ArrayUtils.toString(sqlbuilder.parameters_names())
677
        );
678
    }
655 679
}

Also available in: Unified diff