Skip to content

修复oracle数据库ping语句 #721

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
imzhi wants to merge 3 commits into
base: 2.1
Choose a base branch
from
Open

修复oracle数据库ping语句 #721

imzhi wants to merge 3 commits into from

Conversation

@imzhi
Copy link

@imzhi imzhi commented Jan 21, 2026

修复如下报错

[2026-01-21 12:00:31] imi.ERROR: syncKc2_error: SQLSTATE[HY000]: General error: 923 OCIStmtExecute: ORA-00923: FROM keyword not found where expected
 (/www/server/panel/install/pdo_oci/oci_statement.c:155)  
[2026-01-21 12:00:31] imi.ERROR: syncKc2_error 堆栈: #0 /xxx/vendor/imiphp/imi/src/Db/Drivers/TPdoDriver.php(85): PDO->query()
#1 /xxx/vendor/imiphp/imi/src/Db/Pool/DbResource.php(75): Imi\Db\Mysql\Drivers\PdoMysql\Driver->ping()
#2 /xxx/vendor/imiphp/imi/src/Pool/PoolManager.php(194): Imi\Db\Pool\DbResource->checkState()
#3 /xxx/vendor/imiphp/imi/src/Db/Db.php(70): Imi\Pool\PoolManager::getRequestContextResource()
#4 /xxx/Module/Test/Repository/Sales.php(353): Imi\Db\Db::getInstance()

Oracle 提供了一个名为 DUAL 的虚拟表（伪表），专门用于在不需要从实际数据表中取数时凑齐语法结构。DUAL 表是什么：DUAL 是系统自带的一个只有一个字段、一行记录的特殊表。当你执行 SELECT 1 FROM DUAL 时，它只会返回一行结果 1。

@Yurunsoft
Copy link
Member

Yurunsoft commented Feb 4, 2026

需要格式化代码

@imzhi
Copy link
Author

imzhi commented Feb 5, 2026

哪里格式不对?

@Yurunsoft
Copy link
Member

Yurunsoft commented Feb 7, 2026

参考 Coding Standards 的结果，要用php-cs-fixer格式化

@imzhi
Copy link
Author

imzhi commented Feb 11, 2026

大佬 再看看 @Yurunsoft

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

2 participants

@imzhi @Yurunsoft