错误记录:环境 Windows7 Mybatis Oracle
问题:给字段名定义别名(别名带双引号),外层嵌套查询where子句使用别名(不带双引号)报标识符无效错误;
错误示例:
// 报错
select * from (
select age "ua",name "un" from t_user
)where un = 'Tom' ;
// 报错
select * from (
select age "ua",name "un" from t_user
)where UN = 'Tom' ;
解决:
外层where子句使用别名带双引号且区分大小写则不报错
// 正确
select * from (
select age "ua",name "un" from t_user
)where "un"= 'Tom'