Title: [Bug] join 关键字 在 count 分页的时候,会报关联的子表的字段找不到 · Issue #824 · APIJSON/APIJSON · GitHub
Open Graph Title: [Bug] join 关键字 在 count 分页的时候,会报关联的子表的字段找不到 · Issue #824 · APIJSON/APIJSON
X Title: [Bug] join 关键字 在 count 分页的时候,会报关联的子表的字段找不到 · Issue #824 · APIJSON/APIJSON
Description: APIJSON Version/APIJSON 版本号 7.5.5 Database Type & Version/数据库类型及版本号 PostgreSQL 17.3 Environment/环境信息 - JDK/基础库: 17 - OS/系统: window11 APIAuto Screenshots/APIAuto 请求与结果完整截屏 1 Current Behavior/问题描述 { "@schema": "warehose", "[]": { "Inventor...
Open Graph Description: APIJSON Version/APIJSON 版本号 7.5.5 Database Type & Version/数据库类型及版本号 PostgreSQL 17.3 Environment/环境信息 - JDK/基础库: 17 - OS/系统: window11 APIAuto Screenshots/APIAuto 请求与结果完整截屏 1 Current Behavior/问题描述 { ...
X Description: APIJSON Version/APIJSON 版本号 7.5.5 Database Type & Version/数据库类型及版本号 PostgreSQL 17.3 Environment/环境信息 - JDK/基础库: 17 - OS/系统: window11 APIAuto Screenshots/APIAuto 请求与结果完整截屏 1 Current Behavior/问题描...
Opengraph URL: https://github.com/APIJSON/APIJSON/issues/824
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Bug] join 关键字 在 count 分页的时候,会报关联的子表的字段找不到","articleBody":"### APIJSON Version/APIJSON 版本号\n\n7.5.5\n\n### Database Type & Version/数据库类型及版本号\n\nPostgreSQL 17.3\n\n### Environment/环境信息\n\n```markdown\n- JDK/基础库: 17\n- OS/系统: window11\n```\n\n### APIAuto Screenshots/APIAuto 请求与结果完整截屏\n\n1\n\n### Current Behavior/问题描述\n\n```markdown\n{\n \"@schema\": \"warehose\",\n \"[]\": {\n \"Inventory\": {},\n \"query\": 2,\n \"count\": 10,\n \"page\": 0,\n \"join\": \"\u003c/Location_info/code@,\u003c/Warehose_info/id@\",\n \"Location_info\": {\n \"code@\": \"/Inventory/location_code\"\n },\n \"Warehose_info\": {\n \"id@\": \"/Location_info/warehouse_id\"\n }\n },\n \"@explain\": true\n}\n\n如果\"query\": 0 ,查询没问题,\n\n分页count 生成的,\n已生成 1 条 SQL\nexecute startTime = 1750920200358\ndatabase = ; schema = warehose; sql = \nSELECT count(*) AS \"count\" FROM \"warehose\".\"inventory\" AS \"Inventory\" \n LEFT JOIN ( SELECT \"code\" FROM \"warehose\".\"location_info\" ) AS \"Location_info\" ON \"Location_info\".\"code\" = \"Inventory\".\"location_code\" \n LEFT JOIN ( SELECT \"id\" FROM \"warehose\".\"warehose_info\" ) AS \"Warehose_info\" ON \"Warehose_info\".\"id\" = \"Location_info\".\"warehouse_id\" \n\n这里限制只能是 SELECT \"code\" FROM \"warehose\".\"location_info\" code了,这个count sql会运行不通过。\n```\n\n### Expected Behavior/期望结果\n\n```markdown\n有没有另外一种访问可以通过count\n```\n\n### Any additional comments?/其它补充说明?\n\n```markdown\n\n```","author":{"url":"https://github.com/wz11wz","@type":"Person","name":"wz11wz"},"datePublished":"2025-06-26T06:46:04Z","url":"https://github.com/APIJSON/APIJSON/issues/824"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:7710dc5e-6fa8-2a7f-2046-048bc7a575b5 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | CC5E:117ED:3E54EE:560B94:6AFCB199 |
| html-safe-nonce | e871ae4e5b3c64b76ec1bfffd9b462b5ca3cff3e6db7bd6461ccc9c25abcd331 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDQzVFOjExN0VEOjNFNTRFRTo1NjBCOTQ6NkFGQ0IxOTkiLCJ2aXNpdG9yX2lkIjoiODQwODU5NTI2Nzc2MjA0MTI0MSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | be89f6dcb08e44707ba73966c73769a093422536eac4eaf01a6214a584a08d19 |
| hovercard-subject-tag | issue:3177987780 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/APIJSON/APIJSON/824/issue_layout |
| twitter:image | https://opengraph.githubassets.com/96503b87c876ea1315f28c1f745cf5f2617bc14b764da6415f1b417e6fbe523f/APIJSON/APIJSON/issues/824 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/96503b87c876ea1315f28c1f745cf5f2617bc14b764da6415f1b417e6fbe523f/APIJSON/APIJSON/issues/824 |
| og:image:alt | APIJSON Version/APIJSON 版本号 7.5.5 Database Type & Version/数据库类型及版本号 PostgreSQL 17.3 Environment/环境信息 - JDK/基础库: 17 - OS/系统: window11 APIAuto Screenshots/APIAuto 请求与结果完整截屏 1 Current Behavior/问题描述 { ... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | wz11wz |
| hostname | github.com |
| expected-hostname | github.com |
| None | e3084aead77cbcb4f4904fba53851fa1a0546b0dec3619bd250815e72588dc6d |
| turbo-cache-control | no-preview |
| go-import | github.com/APIJSON/APIJSON git https://github.com/APIJSON/APIJSON.git |
| octolytics-dimension-user_id | 41146037 |
| octolytics-dimension-user_login | APIJSON |
| octolytics-dimension-repository_id | 74359442 |
| octolytics-dimension-repository_nwo | APIJSON/APIJSON |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 74359442 |
| octolytics-dimension-repository_network_root_nwo | APIJSON/APIJSON |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5410e4bebd3e45b138c853ecef3992279d86d5af |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width