Mapping1|SELECT|SELECT * FROM BQT1.SmallA
Mapping2|SELECT|SELECT BQT1.SmallA.* FROM BQT1.SmallA
Mapping3|SELECT|SELECT * FROM BQT1.SmallA AS X
Mapping4|SELECT|SELECT X.* FROM BQT1.SmallA AS X
Expr1|SELECT|SELECT BQT1.SmallA.StringNum, 'val' FROM BQT1.SmallA
Expr2|SELECT|SELECT BQT1.SmallA.StringNum, 'val' AS E FROM BQT1.SmallA
Expr3|SELECT|SELECT concat(BQT1.SmallA.StringNum, 'val') FROM BQT1.SmallA
Expr4|SELECT|SELECT concat(BQT1.SmallA.StringNum, 'val') AS E FROM BQT1.SmallA
Expr5|SELECT|SELECT concat(BQT1.SmallA.StringNum, BQT1.SmallA.StringKey) AS E FROM BQT1.SmallA
Expr6|SELECT|SELECT BQT1.SmallA.StringNum, null FROM BQT1.SmallA
Expr7|SELECT|SELECT BQT1.SmallA.StringNum, null AS E FROM BQT1.SmallA
Order1|SELECT|SELECT BQT1.SmallA.IntKey, BQT1.SmallA.StringKey, BQT1.SmallA.IntNum, BQT1.SmallA.StringNum, BQT1.SmallA.FloatNum, BQT1.SmallA.LongNum, BQT1.SmallA.DoubleNum, BQT1.SmallA.ByteNum, BQT1.SmallA.DateValue, BQT1.SmallA.TimeValue, BQT1.SmallA.TimestampValue, BQT1.SmallA.BooleanValue, BQT1.SmallA.CharValue, BQT1.SmallA.ShortValue, BQT1.SmallA.BigIntegerValue, BQT1.SmallA.BigDecimalValue, BQT1.SmallA.ObjectValue FROM BQT1.SmallA ORDER BY IntKey
Order2|SELECT|SELECT BQT1.SmallA.IntKey, BQT1.SmallA.StringKey, BQT1.SmallA.IntNum, BQT1.SmallA.StringNum, BQT1.SmallA.FloatNum, BQT1.SmallA.LongNum, BQT1.SmallA.DoubleNum, BQT1.SmallA.ByteNum, BQT1.SmallA.DateValue, BQT1.SmallA.TimeValue, BQT1.SmallA.TimestampValue, BQT1.SmallA.BooleanValue, BQT1.SmallA.CharValue, BQT1.SmallA.ShortValue, BQT1.SmallA.BigIntegerValue, BQT1.SmallA.BigDecimalValue, BQT1.SmallA.ObjectValue FROM BQT1.SmallA ORDER BY StringNum, IntKey DESC
Order3|SELECT|SELECT concat(BQT1.SmallA.StringNum, 'val') AS E FROM BQT1.SmallA ORDER BY E
Order4|SELECT|SELECT DISTINCT BQT1.SmallA.StringNum FROM BQT1.SmallA
Order5|SELECT|SELECT DISTINCT BQT1.SmallA.StringNum FROM BQT1.SmallA ORDER BY StringNum
Agg1|SELECT|SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA GROUP BY BQT1.SmallA.StringNum
Agg2|SELECT|SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA GROUP BY BQT1.SmallA.StringNum HAVING BQT1.SmallA.StringNum = '1'
Agg3|SELECT|SELECT COUNT(*) FROM BQT1.SmallA
Agg4|SELECT|SELECT MIN(BQT1.SmallA.StringNum), SUM(BQT1.SmallA.IntKey), AVG(BQT1.SmallA.IntKey) FROM BQT1.SmallA GROUP BY BQT1.SmallA.StringNum