/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.apache.shardingsphere.core.rewrite.token.pojo;

import lombok.Getter;

/**
 * Insert cipher item token.
 *
 * @author panjuan
 */
@Getter
public final class SelectCipherItemToken extends SQLToken implements Substitutable {
    
    private final int stopIndex;
    
    private final String selectItemName;
    
    public SelectCipherItemToken(final int startIndex, final int stopIndex, final String selectItemName) {
        super(startIndex);
        this.stopIndex = stopIndex;
        this.selectItemName = selectItemName;
    }
    
    @Override
    public String toString() {
        return selectItemName;
    }
}

@@ -856,16 +856,55 @@
 .pojo;%0A%0A
+import com.google.common.base.Strings;%0A
 import l
@@ -917,16 +917,16 @@
 Getter;%0A
-
 %0A/**%0A * 
@@ -1155,24 +1155,61 @@
 mName;%0A    %0A
+    private final String alias;%0A    %0A
     public S
@@ -1299,16 +1299,36 @@
 ItemName
+, final String alias
 ) %7B%0A    
@@ -1428,24 +1428,52 @@
 ctItemName;%0A
+        this.alias = alias;%0A
     %7D%0A    %0A 
@@ -1531,30 +1531,112 @@
  return 
-selectItemName
+Strings.isNullOrEmpty(alias) ? selectItemName : String.format(%22%25s AS %25s%22, selectItemName, alias)
 ;%0A    %7D%0A

add alias