Tag: clause

PaginationInterceptor pagination exception: Mybatis-plus paging function reports an error: Unless TOP, OFFSET or FOR XML is also specified, the ORDER BY clause in the view

I remember that the paging function of Mybatis Plus PaginationInterceptor was abnormal during the development process. I found a lot of blogs, but I didn’t analyze why the exception was caused. Most of them are custom count queries, so I need to write a lot of code. This article analyzes the source code of the […]

[Solved] ‘You can’t specify target table for update in FROM clause error in mysql update statement

Questions While using mysql update statement, I get the following error: You can’t specify target table for update in FROM clause The sql statement is as follows: update resmgr_cluster set env = ‘1’ where cluster_id in ( select cluster_id from resmgr_cluster where env = ‘2’ ) Error reason: Directly treat the query data of same […]

[Solved] java.sql.SQLException: You can’t specify target table ‘XXX’ for update in FROM clauseSolution

Let’s look at the error log: ### Error updating database. Cause: java.sql.SQLException: You can’t specify target table ‘file’ for update in FROM clause ### SQL: DELETE FROM file WHERE (url = ? AND Id NOT IN(SELECT MAX(Id) FROM file)) ### Cause: java.sql.SQLException: You can’t specify target table ‘file’ for update in FROM clause] with root […]

[Solved] MySQL error 1055 solution: [Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains

[mysql error 1055 error solution][Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Time: Monday, December 20, 2021 14:44:04 The winter vacation is approaching, and the examinations of […]

[Solved] Python catches exception pycharm reports “Too broad exception clause” warning

Directory 1. Problems 2. Reason 3. Solutions 1. Since the problem is “the terms are too broad”, write specific terms. 2. Choose to ignore such errors in pycharm. 3. Comment # noinspection PyBroadException before code Fourth, attached: python standard exception 1. Questions When writing code, sometimes I just want the code to skip certain errors […]

[Solved] mysql group by error Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated c

When the group by statement is used, the following error will be reported when the column following the select does not exist after the group by: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘XXX’ which is not functionally dependent on columns in GROUP BY clause; this is […]

[Solved] Error [Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause…

Problem description: Environment: mysql8 deployed by local docker, system Ubuntu 9.4.0-1ubuntu1~20.04.1 execute sql error [Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Solution: Check the mysql [Err] […]

[Solved] Postgre paging query error: ERROR: LIMIT #,# syntax is not supported Suggestion: Use separate LIMIT and OFFSET clauses

Questions Error when using postgre query: ERROR: LIMIT #,# syntax is not supported Suggestion: Use separate LIMIT and OFFSET clauses Analysis PSQLException when looking at the error type, indicating that it is an error identified by the postgresql database It can be seen that the “LIMIT #,#” in the sql statement cannot be recognized! This […]

[Solved] ES execution error: too_many_clause

org.springframework.data.elasticsearch.ElasticsearchException: Cannot execute jest action , response code : 500 , error : {<!– –> “root_cause”: [ {<!– –> “type”: “too_many_clauses”, “reason”: “too_many_clauses: maxClauseCount is set to 1024” } ], “type”: “search_phase_execution_exception”, “reason”: “all shards failed”, “phase”: “dfs”, “grouped”: true, “failed_shards”: [ {<!– –> “shard”: 0, “index”: “test”, “node”: “mX6IENzdRwCEhOwAsvJlmQ”, “reason”: {<!– –> “type”: “too_many_clauses”, […]