No receipt for ‘com.apple.pkg.CLTools_Executables‘ found at ‘/‘.错误

最新推荐文章于 2023-02-09 12:12:21 发布
原创 最新推荐文章于 2023-02-09 12:12:21 发布 · 1.6k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#vue #npm #gyp #node.js

在更新npm版本后，尝试安装deasync模块时遇到了错误。首先提示需要Python3.6及以上版本，安装Python后，npm安装过程中报错，错误代码为1。错误信息显示缺少必要的开发者工具，如Xcode的命令行工具。解决方法可能包括安装Xcode的命令行工具或者更换npm的源到官方源。
部署运行你感兴趣的模型镜像

具体错误信息

这个是更新npm版本后出现的，先提示安装python3.6及以上版本，安装后报下面这个错误

npm ERR! code 1
npm ERR! path /Users/kid/Desktop/Done/fe-slb-console-cecloud-com/node_modules/deasync
npm ERR! command failed
npm ERR! command sh -c node-gyp rebuild
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.0.0
npm ERR! gyp info using node@14.17.3 | darwin | x64
npm ERR! gyp info find Python using Python version 3.10.4 found at "/usr/local/bin/python3"
npm ERR! gyp info spawn /usr/local/bin/python3
npm ERR! gyp info spawn args [
npm ERR! gyp info spawn args   '/usr/local/lib/node_modules/npm/node_modules/node-gyp/gyp/gyp_main.py',
npm ERR! gyp info spawn args   'binding.gyp',
npm ERR! gyp info spawn args   '-f',
npm ERR! gyp info spawn args   'make',
npm ERR! gyp info spawn args   '-I',
npm ERR! gyp info spawn args   '/Users/kid/Desktop/Done/fe-slb-console-cecloud-com/node_modules/deasync/build/config.gypi',
npm ERR! gyp info spawn args   '-I',
npm ERR! gyp info spawn args   '/usr/local/lib/node_modules/npm/node_modules/node-gyp/addon.gypi',
npm ERR! gyp info spawn args   '-I',
npm ERR! gyp info spawn args   '/Users/kid/Library/Caches/node-gyp/14.17.3/include/node/common.gypi',
npm ERR! gyp info spawn args   '-Dlibrary=shared_library',
npm ERR! gyp info spawn args   '-Dvisibility=default',
npm ERR! gyp info spawn args   '-Dnode_root_dir=/Users/kid/Library/Caches/node-gyp/14.17.3',
npm ERR! gyp info spawn args   '-Dnode_gyp_dir=/usr/local/lib/node_modules/npm/node_modules/node-gyp',
npm ERR! gyp info spawn args   '-Dnode_lib_file=/Users/kid/Library/Caches/node-gyp/14.17.3/<(target_arch)/node.lib',
npm ERR! gyp info spawn args   '-Dmodule_root_dir=/Users/kid/Desktop/Done/fe-slb-console-cecloud-com/node_modules/deasync',
npm ERR! gyp info spawn args   '-Dnode_engine=v8',
npm ERR! gyp info spawn args   '--depth=.',
npm ERR! gyp info spawn args   '--no-parallel',
npm ERR! gyp info spawn args   '--generator-output',
npm ERR! gyp info spawn args   'build',
npm ERR! gyp info spawn args   '-Goutput_dir=.'
npm ERR! gyp info spawn args ]
npm ERR! No receipt for 'com.apple.pkg.CLTools_Executables' found at '/'.
npm ERR! 
npm ERR! No receipt for 'com.apple.pkg.DeveloperToolsCLILeo' found at '/'.
npm ERR! 
npm ERR! No receipt for 'com.apple.pkg.DeveloperToolsCLI' found at '/'.
npm ERR! 
npm ERR! gyp info spawn make
npm ERR! gyp info spawn args [ 'BUILDTYPE=Release', '-C', 'build' ]
npm ERR! xcode-select: note: no developer tools were found at '/Applications/Xcode.app', requesting install. Choose an option in the dialog to download the command line developer tools.
npm ERR! gyp ERR! build error 
npm ERR! gyp ERR! stack Error: `make` failed with exit code: 1
npm ERR! gyp ERR! stack     at ChildProcess.onExit (/usr/local/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:194:23)
npm ERR! gyp ERR! stack     at ChildProcess.emit (events.js:375:28)
npm ERR! gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:277:12)
npm ERR! gyp ERR! System Darwin 21.1.0
npm ERR! gyp ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild"
npm ERR! gyp ERR! cwd /Users/kid/Desktop/Done/fe-slb-console-cecloud-com/node_modules/deasync
npm ERR! gyp ERR! node -v v14.17.3
npm ERR! gyp ERR! node-gyp -v v9.0.0
npm ERR! gyp ERR! not ok

npm ERR! A complete log of this run can be found in:
npm ERR!     /Users/kid/.npm/_logs/2022-03-31T11_18_32_222Z-debug-0.log

解决方式

换成npm的源
新的淘宝源没有尝试会不会有这个问题

npm config set registry https://registry.npmjs.org/

您可能感兴趣的与本文相关的镜像

Python3.11

Python3.11

Conda
Python

Python 是一种高级、解释型、通用的编程语言，以其简洁易读的语法而闻名，适用于广泛的应用，包括Web开发、数据分析、人工智能和自动化脚本

安装依赖报-gyp: No Xcode or CLT version detected!
JackieDYH的博客
05-27 484
成功安装后，现在可以下载新的 npm 包，而不会出现任何 （gyp） 错误消息。要修复此错误，您需要重新安装 Xcode 命令行。下载和安装 Xcode 命令行工具需要一些时间。此命令会弹出一个提示，单击按钮并继续安装。上面的命令要求输入系统密码。
gitbook 安装报错 /usr/local/lib/node_modules/gitbook-cli/node_modules/npm/node_modules/graceful-fs/polyf
阿哥的专栏
02-17 1755
macbook上使用npm 安装gitbook $ npm install gitbook-cli -g 后，运行gitbook init 报错如下： % gitbook init Installing GitBook 3.2.3 (node:53712) [DEP0150] DeprecationWarning: Setting process.config is deprecated. In the future the property will be read-..
npm ERR， gyp ERR报错
热门推荐
qq_1805110951的博客
11-22 2万+
npm ERR! code 1 npm ERR! path E:\uino\citybuilder\node_modules\canvas npm ERR! command failed npm ERR! command C:\Windows\system32\cmd.exe /d /s /c node-gyp rebuild npm ERR! gyp info it worked if it ends with ok npm ERR! gyp info using node-gyp@7.1.2 npm E
gyp: No Xcode or CLT version detected!
qq_36977499的博客
12-25 1381
我的macOS版本是`macOS Catalina 10.15.2` >在执行npm install下载项目的依赖包的时候出现的gyp报错，报错内容如下： ``` No receipt for 'com.apple.pkg.CLTools_Executables' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLIL...
在Mac上使用vue-cli4创建项目时报错，提示：gyp: No Xcode or CLT version detected!
qq_40922656的博客
12-11 423
错误信息如下： No receipt for 'com.apple.pkg.CLTools_Executables' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLILeo' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLI' found at '/'. gyp: No Xcode or CLT version detected! gyp ERR!
bug Error: Cannot find module ‘vue-loader-v16/package.json‘的解决办法
weixin_40945354的博客
03-03 2442
更新，命令如下，在 https://stackoverflow.com/questions/63504594/error-cannot-find-module-vue-loader-v16-package-json 查到 cnpm i --save-dev vue-loader-v16 ivyone@ivyonedeMacBook-Pro daily-cost % cnpm install ⠦ [12/17] Installing source-map@^0.6.1[vue-loader-v16@npm
精选资源
NPM Error：gyp: No Xcode or CLT version detected!
01-07
No receipt for 'com.apple.pkg.CLTools_Executables' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLILeo' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLI' found at '/'. gyp: ...
vue-element-admin框架install失败问题
qq_36690992的博客
04-29 1745
vue-element-admin框架install失败问题最终解决方案问题环境错误描述/日志填坑之路1、node-gyp2、python版本3、canvas最终解决方案 最终解决方案 已提交至项目issuse，点击查看 问题环境 coandeMacBook-Pro:vue-admin-template mac$ node -v v15.11.0 coandeMacBook-Pro:vue-admin-template mac$ npm -v 7.6.0 coandeMacBook-Pro:vue-admi
VS CODE下 无法执行 node-gyp 命令
GUMU12345的专栏
03-31 2675
错误信息 node-gyp : 无法加载文件 C:\Users\ThinkPad\AppData\Roaming\npm\node-gyp.ps1，因为在此系统上禁止运行脚本。有关详细信息， 请参阅 https:/go.microsoft.com/fwlink/?LinkID=135170 中的 about_Execution_Policies。 所在位置 行:1 字符: 1 + node-gyp rebuild + ~~~~~~~~ + CategoryInfo : Secu
解决使用webstorm新建vue项目时‘gyp: No Xcode or CLT version detected!’报错
MIKE2333的博客
01-14 453
在使用webstorm新建vue项目时，遇到了下面的错误 No receipt for 'com.apple.pkg.CLTools_Executables' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLILeo' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLI' found at '/'. gyp: No Xcode or CLT version d
Mac 解决 gyp: No Xcode or CLT version detected! 报错
inorilin的博客
04-12 4311
在执行npm install下载项目的依赖包的时候出现的gyp报错，报错内容如下： No receipt for 'com.apple.pkg.CLTools_Executables' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLILeo' found at '/'. No receipt for 'com.apple...
npm报错 gyp: No Xcode or CLT version detected!
在这个数字革命的时代，我们将引领您穿越去中心化、智能合约、加密货币以及分布式应用程序的世界。无论您是初学者还是经验丰富的区块链开发者，我们都致力于为您提供有价值的信息和见解。
03-04 4242
报错： No receipt for 'com.apple.pkg.CLTools_Executables' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLILeo' found at '/'. No receipt for 'com.apple.pkg.DeveloperToolsCLI' found at '/'. ...
npm错误 gyp错误 vs版本不对 msvs_version不兼容
m0_67391683的博客
03-08 5278
npm错误 gyp错误 vs版本不对msvs_version 不兼容 windows SDK 报错 执行更新GYP 语句 第一种方案 第二种方案 执行更新GYP 语句 npm install -g node-gyp 最新的GYP 好像已经不支持Python 2.7 版本，npm 会提示你 更新都3.*.*版本 安装 Node.js 的时候一定要勾选 以下这个 ， 会自动检测安装缺少的环境 第一种方案 管理员运行 CMD （Power Shell 也行） 执行更新工具集 npm install -
【环境篇 npm 报错】npm ERR gyp ERR stack import sys； print “%s.%s.%s“ % sys.version_info[:3]；
世幻水的博客
12-25 1万+
问题描述 npm ERR! code 1 npm ERR! path D:\user\Desktop\NiSown\node_modules\node-sass npm ERR! command failed npm ERR! command C:\Windows\system32\cmd.exe /d /s /c node scripts/build.js npm ERR! Building: D:\env\nodejs\node.exe D:\user\Desktop\NiSown\node_modul
node-gyp环境配置报错处理，nodejs 调用 c++接口
weixin_45253306的博客
06-07 3626
1，node-gyp：9.0.0 2，node：14.0.0 3，python：3.10.5 4，vs_buildToolsnode-gyp@9.0.0需要python版本在3.7.x以上，否则会提示你需要更新到最新版本的python。node版本选择14.0.0是因为，我开始使用的是10.10.0版本，但是会爆出一个错误，。选择14.0.0之后解决了这个问题。vs build tools的安装，有两种方式。1，运行命令：，但是我当时会卡主不动，并且安装的python是2.7.x的版本不符和要求（如果你提前
解决gyp err 错误
qq_45031196的博客
08-29 2837
gyp err 提示python环境不正确
mac: npm install 报错
bao
06-21 1505
报错信息 部分 npm ERR! code 1 npm ERR! path /xxx/node_modules/fibers npm ERR! command failed npm ERR! command sh -c node-gyp rebuild npm ERR! gyp info it worked if it ends with ok npm ERR! gyp info using node-gyp@3.8.0 npm ERR! gyp info using node@12.18.0 | darw
npm ERR! gyp verb等一系列错
weixin_45973213的博客
07-31 9484
npm ERR!gyp verb一系列报错
解决 npm ERR! node-sass 和 gyp ERR! node-gyp 报错问题
我的米饭
02-09 1万+
node-sass报错解决方法
select * from (SELECT a.* FROM (SELECT a.ID, a.PROJECT_ID,b.PROJ_ID project_code,b.PROJ_NAME project_name, a.ORG_NO,c.NAME org_name, a.MILESTONE_NO, a.MILESTONE_DESCRIPTION, a.MILESTONE_TYPE, a.BASELINE_DATE, a.ACTUAL_DATE, a.REMARK, a.REMARK_EN, a.MILESTONE_DESCRIPTION_EN, a.MILESTONE_TYPE_EN, a.IS_OUT, a.FORECAST_DATE, case WHEN a.ACTUAL_DATE IS NULL AND TRUNC(sysdate)>trunc(a.PLAN_END_DATE) THEN '3' ELSE a.STATE END state , a.CREATE_USER_ID, a.CREATE_DATE, a.UPDATE_USER_ID, a.UPDATE_DATE,a.milestone_edition,a.PLAN_END_DATE,a.is_check, a.examine_state,a.FORECAST_DATE_EN,a.milestone_state, a.IS_RECEIPT FROM (SELECT * FROM PLANNING_MILESTONES WHERE PROJECT_ID IN (select T.proj_no as id from rel_account_project R inner join proj T on R.project_id = T.proj_no and R.account_id = #{model.userId})) a LEFT JOIN proj b ON a.PROJECT_ID = b.PROJ_NO LEFT JOIN PROJECT_BUILDBASE c ON a.ORG_NO = c.ORG_NO JOIN (SELECT project_id,'R'||max(TO_NUMBER(REPLACE(milestone_edition,'R'))) milestone_edition_num FROM (SELECT * FROM PLANNING_MILESTONES WHERE PROJECT_ID IN (select T.proj_no as id from rel_account_project R inner join proj T on R.project_id = T.proj_no and R.account_id = #{model.userId})) a GROUP BY project_id) d ON a.project_id = d.project_id AND a.milestone_edition = d.milestone_edition_num Left Join PROJECT_WBS_CONFIG pwc on a.PROJECT_ID = pwc.PROJECT_ID) a where a.state = '3' union all SELECT b.* FROM ( SELECT a.ID, a.PROJECT_ID,b.PROJ_ID project_code,b.PROJ_NAME project_name, a.ORG_NO,c.NAME org_name, a.MILESTONE_NO, a.MILESTONE_DESCRIPTION, a.MILESTONE_TYPE, a.BASELINE_DATE, a.ACTUAL_DATE, a.REMARK, a.REMARK_EN, a.MILESTONE_DESCRIPTION_EN, a.MILESTONE_TYPE_EN, a.IS_OUT, a.FORECAST_DATE, case WHEN a.ACTUAL_DATE IS NULL AND TRUNC(sysdate)>trunc(a.PLAN_END_DATE) THEN '3' ELSE a.STATE END state , a.CREATE_USER_ID, a.CREATE_DATE, a.UPDATE_USER_ID, a.UPDATE_DATE,a.milestone_edition,a.PLAN_END_DATE,a.is_check, a.examine_state,a.FORECAST_DATE_EN,a.milestone_state FROM (SELECT * FROM PLANNING_MILESTONES WHERE PROJECT_ID IN (select T.proj_no as id from rel_account_project R inner join proj T on R.project_id = T.proj_no and R.account_id = #{model.userId})) a LEFT JOIN proj b ON a.PROJECT_ID = b.PROJ_NO LEFT JOIN PROJECT_BUILDBASE c ON a.ORG_NO = c.ORG_NO JOIN (SELECT project_id,'R'||max(TO_NUMBER(REPLACE(milestone_edition,'R'))) milestone_edition_num FROM (SELECT * FROM PLANNING_MILESTONES WHERE PROJECT_ID IN (select T.proj_no as id from rel_account_project R inner join proj T on R.project_id = T.proj_no and R.account_id = #{model.userId})) a GROUP BY project_id) d ON a.project_id = d.project_id AND a.milestone_edition = d.milestone_edition_num ORDER BY b.PROJ_ID,a.milestone_edition,TO_NUMBER(REGEXP_SUBSTR(MILESTONE_NO,'[^-]+',1,(length(MILESTONE_NO)-length(REPLACE(MILESTONE_NO,'-'))+1))) ) b where b.state != '3' )
最新发布
10-10
你提供的 SQL 报错： > **ORA-01789: query block has incorrect number of result columns** 原因正是：在 `UNION ALL` 的两个查询中，**返回的列数量不一致**。 --- ## ✅ 问题定位 我们来逐行分析你的 SQL： ```sql SELECT * FROM ( -- 查询 A（第一个 SELECT） SELECT a.* FROM ( SELECT a.ID, ..., a.IS_RECEIPT -- 注意：这里包含了 IS_RECEIPT 字段 ... ) a WHERE a.state = '3' UNION ALL -- 查询 B（第二个 SELECT） SELECT b.* FROM ( SELECT a.ID, ..., a.milestone_state -- ❌ 缺少 IS_RECEIPT 字段！ ... ) b WHERE b.state != '3' ) ``` ### 🔍 关键差异点： - 第一个子查询（A）有字段：`a.IS_RECEIPT` - 第二个子查询（B）**没有 `IS_RECEIPT` 字段** 所以： - 查询 A 返回：**比如 25 列** - 查询 B 返回：**24 列（少一列）** 👉 因此 Oracle 抛出错误：`ORA-01789: query block has incorrect number of result columns` --- ## ✅ 解决方案 要修复这个问题，必须让两个 `SELECT` 查询返回 **相同数量和兼容类型的列**。 ### ✅ 修复方法：在第二个查询中补上缺失的 `IS_RECEIPT` 字段 修改第二部分的 `SELECT`，显式添加 `NULL AS IS_RECEIPT`（或其他默认值）： ```sql SELECT * FROM ( -- 查询 A（保留原样） SELECT a.* FROM ( SELECT a.ID, a.PROJECT_ID, b.PROJ_ID AS project_code, b.PROJ_NAME AS project_name, a.ORG_NO, c.NAME AS org_name, a.MILESTONE_NO, a.MILESTONE_DESCRIPTION, a.MILESTONE_TYPE, a.BASELINE_DATE, a.ACTUAL_DATE, a.REMARK, a.REMARK_EN, a.MILESTONE_DESCRIPTION_EN, a.MILESTONE_TYPE_EN, a.IS_OUT, a.FORECAST_DATE, CASE WHEN a.ACTUAL_DATE IS NULL AND TRUNC(SYSDATE) > TRUNC(a.PLAN_END_DATE) THEN '3' ELSE a.STATE END AS state, a.CREATE_USER_ID, a.CREATE_DATE, a.UPDATE_USER_ID, a.UPDATE_DATE, a.milestone_edition, a.PLAN_END_DATE, a.is_check, a.examine_state, a.FORECAST_DATE_EN, a.milestone_state, a.IS_RECEIPT -- ✅ 包含了 IS_RECEIPT FROM PLANNING_MILESTONES a LEFT JOIN proj b ON a.PROJECT_ID = b.PROJ_NO LEFT JOIN PROJECT_BUILDBASE c ON a.ORG_NO = c.ORG_NO JOIN ( SELECT project_id, 'R'||MAX(TO_NUMBER(REPLACE(milestone_edition,'R'))) AS milestone_edition_num FROM PLANNING_MILESTONES WHERE PROJECT_ID IN ( SELECT T.proj_no FROM rel_account_project R INNER JOIN proj T ON R.project_id = T.proj_no WHERE R.account_id = #{model.userId} ) GROUP BY project_id ) d ON a.project_id = d.project_id AND a.milestone_edition = d.milestone_edition_num LEFT JOIN PROJECT_WBS_CONFIG pwc ON a.PROJECT_ID = pwc.PROJECT_ID WHERE a.PROJECT_ID IN ( SELECT T.proj_no FROM rel_account_project R INNER JOIN proj T ON R.project_id = T.proj_no WHERE R.account_id = #{model.userId} ) ) a WHERE a.state = '3' UNION ALL -- 查询 B（修复：补上 IS_RECEIPT） SELECT b.* FROM ( SELECT a.ID, a.PROJECT_ID, b.PROJ_ID AS project_code, b.PROJ_NAME AS project_name, a.ORG_NO, c.NAME AS org_name, a.MILESTONE_NO, a.MILESTONE_DESCRIPTION, a.MILESTONE_TYPE, a.BASELINE_DATE, a.ACTUAL_DATE, a.REMARK, a.REMARK_EN, a.MILESTONE_DESCRIPTION_EN, a.MILESTONE_TYPE_EN, a.IS_OUT, a.FORECAST_DATE, CASE WHEN a.ACTUAL_DATE IS NULL AND TRUNC(SYSDATE) > TRUNC(a.PLAN_END_DATE) THEN '3' ELSE a.STATE END AS state, a.CREATE_USER_ID, a.CREATE_DATE, a.UPDATE_USER_ID, a.UPDATE_DATE, a.milestone_edition, a.PLAN_END_DATE, a.is_check, a.examine_state, a.FORECAST_DATE_EN, a.milestone_state, NULL AS IS_RECEIPT -- ✅ 补上这一列，保持列数一致 FROM PLANNING_MILESTONES a LEFT JOIN proj b ON a.PROJECT_ID = b.PROJ_NO LEFT JOIN PROJECT_BUILDBASE c ON a.ORG_NO = c.ORG_NO JOIN ( SELECT project_id, 'R'||MAX(TO_NUMBER(REPLACE(milestone_edition,'R'))) AS milestone_edition_num FROM PLANNING_MILESTONES WHERE PROJECT_ID IN ( SELECT T.proj_no FROM rel_account_project R INNER JOIN proj T ON R.project_id = T.proj_no WHERE R.account_id = #{model.userId} ) GROUP BY project_id ) d ON a.project_id = d.project_id AND a.milestone_edition = d.milestone_edition_num WHERE a.PROJECT_ID IN ( SELECT T.proj_no FROM rel_account_project R INNER JOIN proj T ON R.project_id = T.proj_no WHERE R.account_id = #{model.userId} ) ) b WHERE b.state != '3' ) ``` --- ## ✅ 为什么会出现这个错误？ | 原因 | 说明 | |------|------| | ❌ 列数不匹配 | `UNION [ALL]` 要求左右两边 `SELECT` 的列数完全相同 | | ❌ 字段遗漏 | 第二个查询忘了加 `IS_RECEIPT` | | 🧠 开发习惯问题 | 使用 `SELECT *` 或嵌套太多层时容易忽略字段对齐 | --- ## ✅ 最佳实践建议 ### ✅ 1. 避免使用多层嵌套 + `SELECT *` 尽量避免写成： ```sql SELECT * FROM (SELECT * FROM (...)) ``` 这种结构难以调试且容易出错。 ✅ 建议改为扁平化结构，并明确列出所有字段。 --- ### ✅ 2. 统一字段列表模板 可以先定义好“标准输出字段”，然后两个分支都按这个结构输出： ```sql -- 标准字段清单： ID, PROJECT_ID, project_code, project_name, ORG_NO, org_name, MILESTONE_NO, MILESTONE_DESCRIPTION, MILESTONE_TYPE, BASELINE_DATE, ACTUAL_DATE, REMARK, REMARK_EN, MILESTONE_DESCRIPTION_EN, MILESTONE_TYPE_EN, IS_OUT, FORECAST_DATE, state, CREATE_USER_ID, CREATE_DATE, UPDATE_USER_ID, UPDATE_DATE, milestone_edition, PLAN_END_DATE, is_check, examine_state, FORECAST_DATE_EN, milestone_state, IS_RECEIPT ``` 每个分支都要包含这些字段，缺失的用 `NULL` 补齐。 --- ### ✅ 3. 使用 CTE 提高可读性（Oracle 11g 及以上） ```sql WITH base_data AS ( SELECT a.*, b.PROJ_ID AS project_code, b.PROJ_NAME AS project_name, c.NAME AS org_name, CASE WHEN a.ACTUAL_DATE IS NULL AND TRUNC(SYSDATE) > TRUNC(a.PLAN_END_DATE) THEN '3' ELSE a.STATE END AS computed_state, ROW_NUMBER() OVER (PARTITION BY a.PROJECT_ID ORDER BY TO_NUMBER(REPLACE(a.milestone_edition,'R')) DESC) AS rn FROM PLANNING_MILESTONES a JOIN proj b ON a.PROJECT_ID = b.PROJ_NO LEFT JOIN PROJECT_BUILDBASE c ON a.ORG_NO = c.ORG_NO WHERE a.PROJECT_ID IN ( SELECT T.proj_no FROM rel_account_project R INNER JOIN proj T ON R.project_id = T.proj_no WHERE R.account_id = #{model.userId} ) ), latest_edition AS ( SELECT * FROM base_data WHERE rn = 1 ) SELECT ID, PROJECT_ID, project_code, project_name, ORG_NO, org_name, MILESTONE_NO, MILESTONE_DESCRIPTION, MILESTONE_TYPE, BASELINE_DATE, ACTUAL_DATE, REMARK, REMARK_EN, MILESTONE_DESCRIPTION_EN, MILESTONE_TYPE_EN, IS_OUT, FORECAST_DATE, computed_state AS state, CREATE_USER_ID, CREATE_DATE, UPDATE_USER_ID, UPDATE_DATE, milestone_edition, PLAN_END_DATE, is_check, examine_state, FORECAST_DATE_EN, milestone_state, IS_RECEIPT FROM latest_edition ORDER BY project_code, milestone_edition, ...; ``` 这样逻辑更清晰，也避免了 `UNION` 的麻烦。 --- ## ✅ 总结 | 问题 | 解决方案 | |------|----------| | `ORA-01789` 错误 | 两个 `SELECT` 列数不一致 | | 缺失字段 | 第二个查询缺少 `IS_RECEIPT` | | 修复方式 | 在第二个查询中添加 `NULL AS IS_RECEIPT` | | 预防措施 | 显式列出所有字段，避免嵌套 `SELECT *` | ---
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

空门.

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值