Skip to content

fix column names with spaces for relationship columns #25018

fix column names with spaces for relationship columns

fix column names with spaces for relationship columns #25018

Triggered via pull request January 16, 2025 15:07
Status Failure
Total duration 3m 51s
Artifacts

budibase_ci.yml

on: pull_request
Matrix: test-server
Fit to window
Zoom out
Zoom in

Annotations

22 errors and 1 warning
lint: packages/server/src/api/routes/tests/row.spec.ts#L3656
'mainRow' is assigned a value but never used. Allowed unused vars must match /^_/u
lint
Process completed with exit code 1.
/rows (mariadb) › Fields with spaces › Successfully returns rows that have spaces in their field names: packages/server/src/tests/utilities/api/base.ts#L205
Expected status 200 but got 500 Body: ⏐ { ⏐ "message": "Unknown column 'a.nameWithSpace ' in 'field list'", ⏐ "status": 500, ⏐ "error": { ⏐ "code": "ER_BAD_FIELD_ERROR" ⏐ } ⏐ } Stack from request handler: ⏐ Error: Unknown column 'a.nameWithSpace ' in 'field list' ⏐ at PromiseConnection.query (/home/runner/work/budibase/budibase/node_modules/mysql2/promise.js:94:22) ⏐ at MySQLIntegration.query [as internalQuery] (/home/runner/work/budibase/budibase/packages/server/src/integrations/mysql.ts:275:43) ⏐ at internalQuery (/home/runner/work/budibase/budibase/packages/server/src/integrations/mysql.ts:395:14) ⏐ at MySQLIntegration.queryFn [as queryWithReturning] (/home/runner/work/budibase/budibase/packages/backend-core/src/sql/sql.ts:1820:28) ⏐ at MySQLIntegration.queryWithReturning [as query] (/home/runner/work/budibase/budibase/packages/server/src/integrations/mysql.ts:406:25) ⏐ at processTicksAndRejections (node:internal/process/task_queues:95:5) ⏐ at AliasTables.queryWithAliasing (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/sqlAlias.ts:241:20) ⏐ at ExternalRequest.run (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/ExternalRequest.ts:756:11) ⏐ at getRow (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/external.ts:35:20) ⏐ at Object.save (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/external.ts:78:17) ⏐ at save (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/index.ts:108:7) ⏐ at middleware (/home/runner/work/budibase/budibase/packages/server/src/middleware/cleanup.ts:7:16) ⏐ at /home/runner/work/budibase/budibase/node_modules/koa-compress/lib/index.js:38:5 ⏐ at errorHandling (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/errorHandling.ts:8:5) ⏐ at userAgent (/home/runner/work/budibase/budibase/node_modules/koa-useragent/dist/index.js:12:5) ⏐ at contentSecurityPolicy (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/contentSecurityPolicy.ts:105:5) ⏐ at _default (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/ip.ts:6:12) at RowAPI._checkResponse (src/tests/utilities/api/base.ts:205:15) at RowAPI._checkResponse [as _request] (src/tests/utilities/api/base.ts:233:17) at RowAPI._post (src/tests/utilities/api/base.ts:60:12) at RowAPI.save (src/tests/utilities/api/row.ts:44:12) at Object.<anonymous> (src/api/routes/tests/row.spec.ts:3681:21)
test-server (mariadb)
Process completed with exit code 1.
test-server (mongodb)
The job was canceled because "mariadb" failed.
test-server (mongodb)
The operation was canceled.
test-server (postgres_legacy)
The job was canceled because "mariadb" failed.
/rows (postgres_legacy) › Fields with spaces › Successfully returns rows that have spaces in their field names: packages/server/src/tests/utilities/api/base.ts#L205
Expected status 200 but got 500 Body: ⏐ { ⏐ "message": "Undefined column.", ⏐ "status": 500 ⏐ } Stack from request handler: ⏐ Error: Undefined column. ⏐ at PostgresIntegration.internalQuery (/home/runner/work/budibase/budibase/packages/server/src/integrations/postgres.ts:288:15) ⏐ at processTicksAndRejections (node:internal/process/task_queues:95:5) ⏐ at PostgresIntegration.query (/home/runner/work/budibase/budibase/packages/server/src/integrations/postgres.ts:438:24) ⏐ at AliasTables.queryWithAliasing (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/sqlAlias.ts:241:20) ⏐ at ExternalRequest.run (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/ExternalRequest.ts:756:11) ⏐ at getRow (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/external.ts:35:20) ⏐ at Object.save (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/external.ts:78:17) ⏐ at save (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/index.ts:108:7) ⏐ at middleware (/home/runner/work/budibase/budibase/packages/server/src/middleware/cleanup.ts:7:16) ⏐ at /home/runner/work/budibase/budibase/node_modules/koa-compress/lib/index.js:38:5 ⏐ at errorHandling (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/errorHandling.ts:8:5) ⏐ at userAgent (/home/runner/work/budibase/budibase/node_modules/koa-useragent/dist/index.js:12:5) ⏐ at contentSecurityPolicy (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/contentSecurityPolicy.ts:105:5) ⏐ at _default (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/ip.ts:6:12) at RowAPI._checkResponse (src/tests/utilities/api/base.ts:205:15) at RowAPI._checkResponse [as _request] (src/tests/utilities/api/base.ts:233:17) at RowAPI._post (src/tests/utilities/api/base.ts:60:12) at RowAPI.save (src/tests/utilities/api/row.ts:44:12) at Object.<anonymous> (src/api/routes/tests/row.spec.ts:3681:21)
test-server (postgres_legacy)
The operation was canceled.
test-server (postgres)
The job was canceled because "mariadb" failed.
test-server (postgres)
The operation was canceled.
test-server (mysql)
The job was canceled because "mariadb" failed.
/rows (mysql) › Fields with spaces › Successfully returns rows that have spaces in their field names: packages/server/src/tests/utilities/api/base.ts#L205
Expected status 200 but got 500 Body: ⏐ { ⏐ "message": "Unknown column 'a.nameWithSpace ' in 'field list'", ⏐ "status": 500, ⏐ "error": { ⏐ "code": "ER_BAD_FIELD_ERROR" ⏐ } ⏐ } Stack from request handler: ⏐ Error: Unknown column 'a.nameWithSpace ' in 'field list' ⏐ at PromiseConnection.query (/home/runner/work/budibase/budibase/node_modules/mysql2/promise.js:94:22) ⏐ at MySQLIntegration.query [as internalQuery] (/home/runner/work/budibase/budibase/packages/server/src/integrations/mysql.ts:275:43) ⏐ at internalQuery (/home/runner/work/budibase/budibase/packages/server/src/integrations/mysql.ts:395:14) ⏐ at MySQLIntegration.queryFn [as queryWithReturning] (/home/runner/work/budibase/budibase/packages/backend-core/src/sql/sql.ts:1820:28) ⏐ at MySQLIntegration.queryWithReturning [as query] (/home/runner/work/budibase/budibase/packages/server/src/integrations/mysql.ts:406:25) ⏐ at processTicksAndRejections (node:internal/process/task_queues:95:5) ⏐ at AliasTables.queryWithAliasing (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/sqlAlias.ts:241:20) ⏐ at ExternalRequest.run (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/ExternalRequest.ts:756:11) ⏐ at getRow (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/external.ts:35:20) ⏐ at Object.save (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/external.ts:78:17) ⏐ at save (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/index.ts:108:7) ⏐ at middleware (/home/runner/work/budibase/budibase/packages/server/src/middleware/cleanup.ts:7:16) ⏐ at /home/runner/work/budibase/budibase/node_modules/koa-compress/lib/index.js:38:5 ⏐ at errorHandling (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/errorHandling.ts:8:5) ⏐ at userAgent (/home/runner/work/budibase/budibase/node_modules/koa-useragent/dist/index.js:12:5) ⏐ at contentSecurityPolicy (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/contentSecurityPolicy.ts:105:5) ⏐ at _default (/home/runner/work/budibase/budibase/packages/backend-core/src/middleware/ip.ts:6:12) at RowAPI._checkResponse (src/tests/utilities/api/base.ts:205:15) at RowAPI._checkResponse [as _request] (src/tests/utilities/api/base.ts:233:17) at RowAPI._post (src/tests/utilities/api/base.ts:60:12) at RowAPI.save (src/tests/utilities/api/row.ts:44:12) at Object.<anonymous> (src/api/routes/tests/row.spec.ts:3681:21)
test-server (mysql)
The operation was canceled.
test-server (oracle)
The job was canceled because "mariadb" failed.
test-server (oracle)
The operation was canceled.
test-server (none)
The job was canceled because "mariadb" failed.
test-server (none)
The operation was canceled.
test-server (mssql)
The job was canceled because "mariadb" failed.
test-server (mssql)
The operation was canceled.
test-server (sqs)
The job was canceled because "mariadb" failed.
test-server (sqs)
The operation was canceled.
helm-lint
Error while fetching latest Helm release: Error: [@octokit/auth-action] `GITHUB_TOKEN` variable is not set. It must be set on either `env:` or `with:`. See https://github.com/octokit/auth-action.js#createactionauth. Using default version v3.9.0