GaussDB 505
100.0 / 10016/16 个固定 explain case 被受理
迁衡月度证据报告 · 2026-07
国产数据库 Oracle 同题探针受理率
四个目标使用同一组 8 个特征、16 个 canonical SQL case，并要求相同的 explain 深度。
口径边界：受理率只回答语法/计划入口是否接受这些固定样本， 不等于语义兼容、性能等价或完整 Oracle 兼容度。
OceanBase 4.2.5 Oracle
100.0 / 10016/16 个固定 explain case 被受理
PanWeiDB 3.0
100.0 / 10016/16 个固定 explain case 被受理
openGauss 6.0 A
87.5 / 10014/16 个固定 explain case 被受理
可复算方法
16 个固定 case 等权；pass 记 1，reject 记 0。 任一目标缺少工件、身份不符、深度不同或样本不同，整期报告拒绝生成。
基准：oracle-common-v1。数据文件：evidence.json。
逐格证据
GaussDB 505 · SYS_CONTEXT · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| sys-context-app-tenant | pass | explain | c6f4481e444eafbd47bf7308ad8b5b1c3d24adf2cbf0650ec8b68e8db053bece |
| sys-context-session-user | pass | explain | 3cedbee7c7b6d056f58a156cababfc24e68570af28ccd1ca0439d30380ebd443 |
OceanBase 4.2.5 Oracle · SYS_CONTEXT · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| sys-context-app-tenant | pass | explain | c6f4481e444eafbd47bf7308ad8b5b1c3d24adf2cbf0650ec8b68e8db053bece |
| sys-context-session-user | pass | explain | 3cedbee7c7b6d056f58a156cababfc24e68570af28ccd1ca0439d30380ebd443 |
openGauss 6.0 A · SYS_CONTEXT · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| sys-context-app-tenant | reject | explain | c6f4481e444eafbd47bf7308ad8b5b1c3d24adf2cbf0650ec8b68e8db053bece |
| sys-context-session-user | reject | explain | 3cedbee7c7b6d056f58a156cababfc24e68570af28ccd1ca0439d30380ebd443 |
PanWeiDB 3.0 · SYS_CONTEXT · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| sys-context-app-tenant | pass | explain | c6f4481e444eafbd47bf7308ad8b5b1c3d24adf2cbf0650ec8b68e8db053bece |
| sys-context-session-user | pass | explain | 3cedbee7c7b6d056f58a156cababfc24e68570af28ccd1ca0439d30380ebd443 |
GaussDB 505 · 字节串函数 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| lengthb-column | pass | explain | 87eb71fb5a046ced7d2c53696c3d2519e0d1df9ddd8dc50ca5201ac564a4eb6a |
| substrb-column | pass | explain | 9ffbca16f162a56e65adaed2d5585cc83eeec832336c88ced743948a00c2039b |
OceanBase 4.2.5 Oracle · 字节串函数 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| lengthb-column | pass | explain | 87eb71fb5a046ced7d2c53696c3d2519e0d1df9ddd8dc50ca5201ac564a4eb6a |
| substrb-column | pass | explain | 9ffbca16f162a56e65adaed2d5585cc83eeec832336c88ced743948a00c2039b |
openGauss 6.0 A · 字节串函数 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| lengthb-column | pass | explain | 87eb71fb5a046ced7d2c53696c3d2519e0d1df9ddd8dc50ca5201ac564a4eb6a |
| substrb-column | pass | explain | 9ffbca16f162a56e65adaed2d5585cc83eeec832336c88ced743948a00c2039b |
PanWeiDB 3.0 · 字节串函数 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| lengthb-column | pass | explain | 87eb71fb5a046ced7d2c53696c3d2519e0d1df9ddd8dc50ca5201ac564a4eb6a |
| substrb-column | pass | explain | 9ffbca16f162a56e65adaed2d5585cc83eeec832336c88ced743948a00c2039b |
GaussDB 505 · GREATEST / LEAST NULL 语义 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| greatest-columns | pass | explain | 6e0d8607983fdcf65e190479effabdd888588b7e7022bc77324934c82f398d29 |
| least-columns | pass | explain | e9075cb40497f3d0ae4656eae4db41284b7843391724f0daed0837cd3ede66fe |
OceanBase 4.2.5 Oracle · GREATEST / LEAST NULL 语义 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| greatest-columns | pass | explain | 6e0d8607983fdcf65e190479effabdd888588b7e7022bc77324934c82f398d29 |
| least-columns | pass | explain | e9075cb40497f3d0ae4656eae4db41284b7843391724f0daed0837cd3ede66fe |
openGauss 6.0 A · GREATEST / LEAST NULL 语义 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| greatest-columns | pass | explain | 6e0d8607983fdcf65e190479effabdd888588b7e7022bc77324934c82f398d29 |
| least-columns | pass | explain | e9075cb40497f3d0ae4656eae4db41284b7843391724f0daed0837cd3ede66fe |
PanWeiDB 3.0 · GREATEST / LEAST NULL 语义 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| greatest-columns | pass | explain | 6e0d8607983fdcf65e190479effabdd888588b7e7022bc77324934c82f398d29 |
| least-columns | pass | explain | e9075cb40497f3d0ae4656eae4db41284b7843391724f0daed0837cd3ede66fe |
GaussDB 505 · LPAD / RPAD · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| lpad-column | pass | explain | 2805b043b3163cd67a5f7aa4a24aff96d7159ad0ab033e83d37a74846ad16970 |
| rpad-column | pass | explain | 2a148b3c5d5ee268f816ee4809c52c62b13e96f735a5c24c19aa57a4c54add65 |
OceanBase 4.2.5 Oracle · LPAD / RPAD · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| lpad-column | pass | explain | 2805b043b3163cd67a5f7aa4a24aff96d7159ad0ab033e83d37a74846ad16970 |
| rpad-column | pass | explain | 2a148b3c5d5ee268f816ee4809c52c62b13e96f735a5c24c19aa57a4c54add65 |
openGauss 6.0 A · LPAD / RPAD · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| lpad-column | pass | explain | 2805b043b3163cd67a5f7aa4a24aff96d7159ad0ab033e83d37a74846ad16970 |
| rpad-column | pass | explain | 2a148b3c5d5ee268f816ee4809c52c62b13e96f735a5c24c19aa57a4c54add65 |
PanWeiDB 3.0 · LPAD / RPAD · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| lpad-column | pass | explain | 2805b043b3163cd67a5f7aa4a24aff96d7159ad0ab033e83d37a74846ad16970 |
| rpad-column | pass | explain | 2a148b3c5d5ee268f816ee4809c52c62b13e96f735a5c24c19aa57a4c54add65 |
GaussDB 505 · NEXT_DAY · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| next-day-sysdate | pass | explain | 4ee385586077731aa12f9434bbfd6166028e616b750d634f5af092c069c365c8 |
| next-day-column | pass | explain | 17cc14df6064829f462694fc45b452a48df376fe943120c8435a999be82d78dc |
OceanBase 4.2.5 Oracle · NEXT_DAY · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| next-day-sysdate | pass | explain | 4ee385586077731aa12f9434bbfd6166028e616b750d634f5af092c069c365c8 |
| next-day-column | pass | explain | 17cc14df6064829f462694fc45b452a48df376fe943120c8435a999be82d78dc |
openGauss 6.0 A · NEXT_DAY · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| next-day-sysdate | pass | explain | 4ee385586077731aa12f9434bbfd6166028e616b750d634f5af092c069c365c8 |
| next-day-column | pass | explain | 17cc14df6064829f462694fc45b452a48df376fe943120c8435a999be82d78dc |
PanWeiDB 3.0 · NEXT_DAY · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| next-day-sysdate | pass | explain | 4ee385586077731aa12f9434bbfd6166028e616b750d634f5af092c069c365c8 |
| next-day-column | pass | explain | 17cc14df6064829f462694fc45b452a48df376fe943120c8435a999be82d78dc |
GaussDB 505 · TO_CHAR 格式模型 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| to-char-datetime | pass | explain | 1dbc8211805432db45618b9ea6e31c8a48483bcdb0b5e3a860812e897eaeba60 |
| to-char-number | pass | explain | 48cbdbd68509fe347ff813e3466baee3dbc0b19302c196884cd2e900eabea117 |
OceanBase 4.2.5 Oracle · TO_CHAR 格式模型 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| to-char-datetime | pass | explain | 1dbc8211805432db45618b9ea6e31c8a48483bcdb0b5e3a860812e897eaeba60 |
| to-char-number | pass | explain | 48cbdbd68509fe347ff813e3466baee3dbc0b19302c196884cd2e900eabea117 |
openGauss 6.0 A · TO_CHAR 格式模型 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| to-char-datetime | pass | explain | 1dbc8211805432db45618b9ea6e31c8a48483bcdb0b5e3a860812e897eaeba60 |
| to-char-number | pass | explain | 48cbdbd68509fe347ff813e3466baee3dbc0b19302c196884cd2e900eabea117 |
PanWeiDB 3.0 · TO_CHAR 格式模型 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| to-char-datetime | pass | explain | 1dbc8211805432db45618b9ea6e31c8a48483bcdb0b5e3a860812e897eaeba60 |
| to-char-number | pass | explain | 48cbdbd68509fe347ff813e3466baee3dbc0b19302c196884cd2e900eabea117 |
GaussDB 505 · TO_NUMBER 格式模型 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| to-number-formatted | pass | explain | cc271c9826aca705810f2556680dc0ef817d450d58ed21edfd1ef23181b9ede3 |
| to-number-column | pass | explain | e0b7212f1ddd1c063860a7a42731149428d698cc40225ce81948560414345ada |
OceanBase 4.2.5 Oracle · TO_NUMBER 格式模型 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| to-number-formatted | pass | explain | cc271c9826aca705810f2556680dc0ef817d450d58ed21edfd1ef23181b9ede3 |
| to-number-column | pass | explain | e0b7212f1ddd1c063860a7a42731149428d698cc40225ce81948560414345ada |
openGauss 6.0 A · TO_NUMBER 格式模型 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| to-number-formatted | pass | explain | cc271c9826aca705810f2556680dc0ef817d450d58ed21edfd1ef23181b9ede3 |
| to-number-column | pass | explain | e0b7212f1ddd1c063860a7a42731149428d698cc40225ce81948560414345ada |
PanWeiDB 3.0 · TO_NUMBER 格式模型 · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| to-number-formatted | pass | explain | cc271c9826aca705810f2556680dc0ef817d450d58ed21edfd1ef23181b9ede3 |
| to-number-column | pass | explain | e0b7212f1ddd1c063860a7a42731149428d698cc40225ce81948560414345ada |
GaussDB 505 · TRUNC · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| trunc-sysdate | pass | explain | a0b351742baf750f6c2f7f7bd1e41f041ba990d2ecc3bd74a5fb2f0f803b235a |
| trunc-month-column | pass | explain | 91b4ec9f2aa5cd675ef7ecf83b98235ca695bdbd1f581ad809d883cdd0bbdd6b |
OceanBase 4.2.5 Oracle · TRUNC · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| trunc-sysdate | pass | explain | a0b351742baf750f6c2f7f7bd1e41f041ba990d2ecc3bd74a5fb2f0f803b235a |
| trunc-month-column | pass | explain | 91b4ec9f2aa5cd675ef7ecf83b98235ca695bdbd1f581ad809d883cdd0bbdd6b |
openGauss 6.0 A · TRUNC · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| trunc-sysdate | pass | explain | a0b351742baf750f6c2f7f7bd1e41f041ba990d2ecc3bd74a5fb2f0f803b235a |
| trunc-month-column | pass | explain | 91b4ec9f2aa5cd675ef7ecf83b98235ca695bdbd1f581ad809d883cdd0bbdd6b |
PanWeiDB 3.0 · TRUNC · support=partial
| case | 结果 | 深度 | SQL digest |
|---|---|---|---|
| trunc-sysdate | pass | explain | a0b351742baf750f6c2f7f7bd1e41f041ba990d2ecc3bd74a5fb2f0f803b235a |
| trunc-month-column | pass | explain | 91b4ec9f2aa5cd675ef7ecf83b98235ca695bdbd1f581ad809d883cdd0bbdd6b |