Examples of SQLLiteral

org.datanucleus.store.rdbms.sql.expression.SQLLiteral
Representation of an SQL Literal in a query.

org.eigenbase.sql.SqlLiteral

A SqlLiteral is a constant. It is, appropriately, immutable.

How is the value stored? In that respect, the class is somewhat of a black box. There is a {@link #getValue} method which returns the value as anobject, but the type of that value is implementation detail, and it is best that your code does not depend upon that knowledge. It is better to use task-oriented methods such as {@link #toSqlString(SqlDialect)} and{@link #toValue}.

If you really need to access the value directly, you should switch on the value of the {@link #typeName} field, rather than making assumptions aboutthe runtime type of the {@link #value}.

The allowable types and combinations are:

Allowable types for SqlLiteral
TypeName	Meaing	Value type
{@link SqlTypeName#NULL}	The null value. It has its own special type.	null
{@link SqlTypeName#BOOLEAN}	Boolean, namely `TRUE`, `FALSE` or `UNKNOWN`.	{@link Boolean}, or null represents the UNKNOWN value
{@link SqlTypeName#DECIMAL}	Exact number, for example `0`, `-.5`, `12345`.	{@link BigDecimal}
{@link SqlTypeName#DOUBLE}	Approximate number, for example `6.023E-23`.	{@link BigDecimal}
{@link SqlTypeName#DATE}	Date, for example `DATE '1969-04'29'`	{@link Calendar}
{@link SqlTypeName#TIME}	Time, for example `TIME '18:37:42.567'`	{@link Calendar}
{@link SqlTypeName#TIMESTAMP}	Timestamp, for example `TIMESTAMP '1969-04-29 18:37:42.567'`	{@link Calendar}
{@link SqlTypeName#CHAR}	Character constant, for example `'Hello, world!'`, `''`, `_N'Bonjour'`, `_ISO-8859-1'It''s superman!' COLLATE SHIFT_JIS$ja_JP$2`. These are always CHAR, never VARCHAR.	{@link NlsString}
{@link SqlTypeName#BINARY}	Binary constant, for example `X'ABC'`, `X'7F'`. Note that strings with an odd number of hexits will later become values of the BIT datatype, because they have an incomplete number of bytes. But here, they are all binary constants, because that's how they were written. These constants are always BINARY, never VARBINARY.	{@link BitString}
{@link SqlTypeName#SYMBOL}	A symbol is a special type used to make parsing easier; it is not part of the SQL standard, and is not exposed to end-users. It is used to hold a symbol, such as the LEADING flag in a call to the function `TRIM([LEADING\|TRAILING\|BOTH] chars FROM string)`.	A class which implements the {@link SqlSymbol} interface
{@link SqlTypeName#INTERVAL_DAY_TIME}	Interval, for example `INTERVAL '1:34' HOUR`.	{@link SqlIntervalLiteral.IntervalValue}.

Examples of org.datanucleus.store.rdbms.sql.expression.SQLLiteral

                else
                {
                    // Create Literal for the parameter (since we need to perform operations on it)
                    processParameterExpression(paramExpr, true);
                    SQLExpression paramSqlExpr = stack.pop();
                    SQLLiteral lit = (SQLLiteral)paramSqlExpr;
                    Object paramValue = lit.getValue();


                    List<String> tuples = expr.getTuples();
                    Iterator<String> tuplesIter = tuples.iterator();
                    Object objValue = paramValue;
                    while (tuplesIter.hasNext())

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.expression.SQLLiteral

                // SQLExpression numExpr = (SQLExpression)args.get(1);
                // TODO Use numExpr in a SUBSTRING
                if (substrExpr.isParameter())
                {
                    // Any pattern expression cannot be a parameter here
                    SQLLiteral substrLit = (SQLLiteral)substrExpr;
                    stmt.getQueryGenerator().useParameterExpressionAsLiteral(substrLit);
                    if (substrLit.getValue() == null)
                    {
                        return new BooleanExpression(expr, Expression.OP_LIKE, 
                            ExpressionUtils.getEscapedPatternExpression(substrExpr));
                    }
                }
                SQLExpression likeSubstrExpr = new StringLiteral(stmt,
                    expr.getJavaTypeMapping(), '%', null);
                return new BooleanExpression(expr, Expression.OP_LIKE, 
                    likeSubstrExpr.add(ExpressionUtils.getEscapedPatternExpression(substrExpr)));
            }
            else
            {
                // Create a new StringExpression and manually update its SQL
                if (substrExpr.isParameter())
                {
                    // Any pattern expression cannot be a parameter here
                    SQLLiteral substrLit = (SQLLiteral)substrExpr;
                    stmt.getQueryGenerator().useParameterExpressionAsLiteral(substrLit);
                    if (substrLit.getValue() == null)
                    {
                        return new BooleanExpression(expr, Expression.OP_LIKE, 
                            ExpressionUtils.getEscapedPatternExpression(substrExpr));
                    }
                }

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.expression.SQLLiteral

//                SQLExpression numExpr = (SQLExpression)args.get(1);
                // TODO Use numExpr in a SUBSTRING
                if (substrExpr.isParameter())
                {
                    // Any pattern expression cannot be a parameter here
                    SQLLiteral substrLit = (SQLLiteral)substrExpr;
                    stmt.getQueryGenerator().useParameterExpressionAsLiteral(substrLit);
                    if (substrLit.getValue() == null)
                    {
                        return new BooleanExpression(expr, Expression.OP_LIKE, 
                            ExpressionUtils.getEscapedPatternExpression(substrExpr));
                    }
                }
                SQLExpression likeSubstrExpr = new StringLiteral(stmt,
                    expr.getJavaTypeMapping(), '%', null);
                return new BooleanExpression(expr, Expression.OP_LIKE, 
                    ExpressionUtils.getEscapedPatternExpression(substrExpr).add(likeSubstrExpr));
            }
            else
            {
                // Create a new StringExpression and manually update its SQL
                if (substrExpr.isParameter())
                {
                    // Any pattern expression cannot be a parameter here
                    SQLLiteral substrLit = (SQLLiteral)substrExpr;
                    stmt.getQueryGenerator().useParameterExpressionAsLiteral(substrLit);
                    if (substrLit.getValue() == null)
                    {
                        return new BooleanExpression(expr, Expression.OP_LIKE, 
                            ExpressionUtils.getEscapedPatternExpression(substrExpr));
                    }
                }

View Full Code Here

Examples of org.eigenbase.sql.SqlLiteral

  }


  @Override
  public SqlNode rewrite(SqlNode sqlNode) throws RelConversionException{
    SqlExplain node = unwrap(sqlNode, SqlExplain.class);
    SqlLiteral op = node.operand(2);
    SqlExplain.Depth depth = (SqlExplain.Depth) op.getValue();
    if(node.getDetailLevel() != null) level = node.getDetailLevel();
    switch(depth){
    case LOGICAL:
      mode = ResultMode.LOGICAL;
      break;

View Full Code Here

Examples of org.eigenbase.sql.SqlLiteral

    public boolean isArray(){
      return isArray;
    }


    public SqlNode getNode(SqlNode node){
      SqlLiteral literal;
      if(isArray){
        literal = SqlLiteral.createExactNumeric(value, parserPos);
      }else{
        literal = SqlLiteral.createCharString(value, parserPos);
      }

View Full Code Here

Examples of org.eigenbase.sql.SqlLiteral

  }


  @Override
  public SqlNode rewrite(SqlNode sqlNode) throws RelConversionException{
    SqlExplain node = unwrap(sqlNode, SqlExplain.class);
    SqlLiteral op = node.operand(2);
    SqlExplain.Depth depth = (SqlExplain.Depth) op.getValue();
    if (node.getDetailLevel() != null) {
      level = node.getDetailLevel();
    }
    switch (depth) {
    case LOGICAL:

View Full Code Here

Examples of org.eigenbase.sql.SqlLiteral

    public boolean isArray(){
      return isArray;
    }


    public SqlNode getNode(SqlNode node){
      SqlLiteral literal;
      if(isArray){
        literal = SqlLiteral.createExactNumeric(value, parserPos);
      }else{
        literal = SqlLiteral.createCharString(value, parserPos);
      }

View Full Code Here

Examples of org.eigenbase.sql.SqlLiteral

  }


  @Override
  public SqlNode rewrite(SqlNode sqlNode) throws RelConversionException{
    SqlExplain node = unwrap(sqlNode, SqlExplain.class);
    SqlLiteral op = node.operand(2);
    SqlExplain.Depth depth = (SqlExplain.Depth) op.getValue();
    if(node.getDetailLevel() != null) level = node.getDetailLevel();
    switch(depth){
    case LOGICAL:
      mode = ResultMode.LOGICAL;
      break;

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.