Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql query

最新推荐文章于 2022-05-21 18:06:44 发布

原创最新推荐文章于 2022-05-21 18:06:44 发布 · 5.9k 阅读

1 ·

CC 4.0 BY-SA版权

本文探讨了在本地SQL自动发现过程中遇到的重复SQL别名错误。作者分享了一个实例，指出此错误通常由查询结果集中存在两个完全相同的字段引起。通过理解和避免这种错误，可以有效提升SQL查询效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

这句话的翻译是：在本地SQ自动发现期间遇到重复的SQL别名[ID]

之前看别人说是没有加别名，我看了自己的代码是加了的，后来看到翻译了一下发现是里面有两个一样的字段

所以报错了（所以这个报错就是不要在查询的结果集里面有两个一模一样的字段）

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

纯种的程序小白

关注关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

[Flink错误]SQL parse failed. Non-query expression encountered in illegal context

LangLang1111111的博客

11-22

1万+

错误源代码如下: tenv .sqlQuery("select" + "hop_start(et, interval '1' hour,interval '3' hour) stt, " + "hop_end(et, interval '1' hour,interval '3' hour) edt, " + "itemId, " +

java.sql.SQLException:Unexpected exception encountered during query

codebloom的博客

04-14

939

今天遇到了这个问题，快把我搞吐了，我的idea是2020最新版本的，在引入jar包时，我引入的是 mysql-connector-java-5.1.18-bin.jar 这个版本的，后来我换成了 mysql-connector-java-5.1.47.jar 但还是不行，我又去看是不是语法问题，也不是，然后几乎把所有的jar包都升级了，但还是不行，（心态炸裂）我又新建了一个项目，只把与数据库连接相关的jar包导入，然后把原项目中于此相关的类，servlet，。。都复制了过来，只让实现数据库这个功能，其

1 条评论您还未登录，请先登录后发表或查看评论

Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql query； nested exceptio

ヾ凉秋的博客

06-28

1327

报错信息： Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql query; nested exception is org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql q

Encountered a duplicated sql alias [id] during auto-discovery of a native-sql query异常

Mr.王同学

10-24

1307

通常是因为在关联查询时，用了select*，而*中几张表的id字段冲突，所以导致异常。

Encountered a duplicated sql alias [xxx] during auto-discovery of a native-sql query报错问题

weixin_44773906的博客

05-21

5719

一、问题描述 Encountered a duplicated sql alias [xxx] during auto-discovery of a native-sql query报错问题二、解决办法 1.检查重命名是否有重复 2.没有限定是哪个表，举例：（1）select * …改成 select 表别名.* （2）select id …改成 select 表别名.id ...

Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql query; nested exceptio

qq_31138647的博客

08-16

407

select ent.id,ent.enter_name,dis.unit_name,dis.advice,dis.advice_content,case when o.id is null then '未分送' when o.id is not null then '已分送' end statusName,o.id from " + " ( select * from lhcj_dis...

Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query； nested except

渡凡的博客

12-15

2827

报错：Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query; nested exception is org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [name] during auto-discovery of a native-sql.

sql2000报错Successfully re-opened the local eventlog解决方法

09-10

在使用Microsoft SQL Server 2000时，如果遇到“Successfully re-opened the local eventlog”报错，通常与事件日志的读取问题有关。这可能是因为系统日志文件在SQL Server读取过程中被修改，导致SQL Server无法正确...

X-Frame-Options相关文件

08-27

描述中提到的"X-Frame-Options头缺失 in a frame because it set 'X-Frame-Options' to 'deny'"，意味着在某个特定的场景下，一个网页没有设置X-Frame-Options头，或者设置了值为'deny'的X-Frame-Options头，这表明...

Graph Neural Networks_ A Review of Methods and Applications----清华大学周杰.pdf

09-03

Graph Neural Networks (GNNs) are a class of neural network models designed specifically for handling graph-structured data. Unlike traditional neural networks that operate on Euclidean data like ...

解决：Hibernate: Encountered a duplicated sql alias [] during auto-discovery of a native-sq

热门推荐

Liucheng417的博客

05-26

2万+

一、报错： Encountered a duplicated sql alias [created_by_login] during auto-discovery of a native-sql query 二、原因： Select后面没有别名！！！（注：存储过程不能select * ）三、解决：加别名之后，成功~

[异常] Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query；

Dj_nole的博客

12-28

1166

Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query； nested except

Encountered a duplicated sql alias [id] during auto-discovery of a native-sq

u014414110的博客

03-05

8653

因sql语句查询时候有多个id没使用别名导致

Encountered a duplicated sql alias [kind] during auto-discovery of a native-sql query

05-11

384

org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [kind] during auto-discovery of a native-sql query 这是因为没有添加别名，在原生的JPA中不能使用 " select * …… "

Encountered a duplicated sql alias [xxxx] during auto-discovery of a native-sql query

梁同学与Android

04-06

2666

Hibernate: SELECT avg(quality) as quality , max(server_time) as server_time , min(source_time) as source_time, count(tag) as tag , sum(value) as value, ...

Encountered a duplicated sql alias [NAME] during auto-discovery of a native-sql query

qq_31138647的博客

07-16

2358

1.控制台报错日志 org.springframework.orm.jpa.JpaSystemException: Encountered a duplicated sql alias [NAME] during auto-discovery of a native-sql query; nested exception is org.hibernate.loader.custom.NonUn...

Encountered a duplicated sql alias during auto-discovery of a native-sql query种种报错

nicknailo博客

08-07

4800

昨天开始出错， org.apache.jasper.JasperException: javax.el.PropertyNotFoundException: Property not readable on type Encountered a duplicated sql alias during auto-discovery 或者org.apache.catalina.core.

hibernate原生sql查询结果报Encountered a duplicated sql alias [job_id] during auto-discovery of a native-s

XingZhaoQiang的专栏

03-16

4112

20150316今天遇到这样一个错误，记到同日期的笔记上现在在博客上也记一次；做的sql语句查询 SELECT X.ID, X.NAME, x.PRICE,x.SALES_PRICE,...........,h.NAME as hotStreetName ,x.DISCOUNT,x.APPRAISE_SCORE from (PA_PACKAGE x, CO_HOT_STREET

org.junit.platform.launcher.core.DiscoveryIssueException: TestEngine with ID 'junit-jupiter' encountered a critical issue during test discovery: