expected 200 "OK", got 409 "Conflict" at GroupsAPI.expect [as saveGroup] (src/tests/api/groups.ts:14:8) at Object.saveGroup (src/api/routes/global/tests/groups.spec.ts:308:42) ---- at Test._assertStatus (../../node_modules/supertest/lib/test.js:252:14) at ../../node_modules/supertest/lib/test.js:308:13 at Test._assertFunction (../../node_modules/supertest/lib/test.js:285:13) at Test.assert (../../node_modules/supertest/lib/test.js:164:23) at localAssert (../../node_modules/supertest/lib/test.js:120:14) at ../../node_modules/supertest/lib/test.js:125:7 at Test.fn [as callback] (../../node_modules/supertest/node_modules/superagent/src/node/index.js:925:3) at callback (../../node_modules/supertest/node_modules/superagent/src/node/index.js:1166:18) at IncomingMessage.fn (../../node_modules/supertest/node_modules/superagent/src/node/parsers/json.js:19:7)

/api/global/groups › with global builder role › update should return forbidden: packages/worker/src/tests/api/groups.ts#L14

test-worker

Process completed with exit code 1.

/v2/views (mariadb) › row operations › search › sorting › allow sorting ({ field: 'name': packages/server/src/tests/utilities/api/base.ts#L205

Expected status 200 but got 500 Body: ⏐ { ⏐ "message": "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls first, `a`.`id` asc limit 5000' at line 1", ⏐ "status": 500, ⏐ "error": { ⏐ "code": "ER_PARSE_ERROR" ⏐ } ⏐ } Stack from request handler: ⏐ Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls first, `a`.`id` asc limit 5000' at line 1 ⏐ 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 async Promise.all (index 0) ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search/external.ts:108:52) ⏐ at /home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:138:16 ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:42:10) ⏐ at searchView (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/views.ts:48:18) ⏐ 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 ViewV2API._checkResponse (src/tests/utilities/api/base.ts:205:15) at ViewV2API._checkResponse [as _request] (src/tests/utilities/api/base.ts:233:17) at ViewV2API._post (src/tests/utilities/api/base.ts:60:12) at ViewV2API.search (src/tests/utilities/api/viewV2.ts:67:12) at src/api/routes/tests/viewV2.spec.ts:3277:34

/v2/views (mariadb) › row operations › search › sorting › allow sorting ({ field: 'name' }): packages/server/src/tests/utilities/api/base.ts#L205

/v2/views (mariadb) › row operations › search › sorting › allow sorting ({ field: 'name': packages/server/src/tests/utilities/api/base.ts#L205

Expected status 200 but got 500 Body: ⏐ { ⏐ "message": "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls last, `a`.`id` asc limit 5000' at line 1", ⏐ "status": 500, ⏐ "error": { ⏐ "code": "ER_PARSE_ERROR" ⏐ } ⏐ } Stack from request handler: ⏐ Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls last, `a`.`id` asc limit 5000' at line 1 ⏐ 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 async Promise.all (index 0) ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search/external.ts:108:52) ⏐ at /home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:138:16 ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:42:10) ⏐ at searchView (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/views.ts:48:18) ⏐ 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 ViewV2API._checkResponse (src/tests/utilities/api/base.ts:205:15) at ViewV2API._checkResponse [as _request] (src/tests/utilities/api/base.ts:233:17) at ViewV2API._post (src/tests/utilities/api/base.ts:60:12) at ViewV2API.search (src/tests/utilities/api/viewV2.ts:67:12) at src/api/routes/tests/viewV2.spec.ts:3277:34

/v2/views (mariadb) › row operations › search › sorting › allow sorting ({ field: 'name': packages/server/src/tests/utilities/api/base.ts#L205

Expected status 200 but got 500 Body: ⏐ { ⏐ "message": "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls last, `a`.`id` asc limit 5000' at line 1", ⏐ "status": 500, ⏐ "error": { ⏐ "code": "ER_PARSE_ERROR" ⏐ } ⏐ } Stack from request handler: ⏐ Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls last, `a`.`id` asc limit 5000' at line 1 ⏐ 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 async Promise.all (index 0) ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search/external.ts:108:52) ⏐ at /home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:138:16 ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:42:10) ⏐ at searchView (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/views.ts:48:18) ⏐ 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 ViewV2API._checkResponse (src/tests/utilities/api/base.ts:205:15) at ViewV2API._checkResponse [as _request] (src/tests/utilities/api/base.ts:233:17) at ViewV2API._post (src/tests/utilities/api/base.ts:60:12) at ViewV2API.search (src/tests/utilities/api/viewV2.ts:67:12) at src/api/routes/tests/viewV2.spec.ts:3277:34

/v2/views (mariadb) › row operations › search › sorting › allow sorting ({ field: 'age': packages/server/src/tests/utilities/api/base.ts#L205

Expected status 200 but got 500 Body: ⏐ { ⏐ "message": "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls last, `a`.`id` asc limit 5000' at line 1", ⏐ "status": 500, ⏐ "error": { ⏐ "code": "ER_PARSE_ERROR" ⏐ } ⏐ } Stack from request handler: ⏐ Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls last, `a`.`id` asc limit 5000' at line 1 ⏐ 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 async Promise.all (index 0) ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search/external.ts:108:52) ⏐ at /home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:138:16 ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:42:10) ⏐ at searchView (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/views.ts:48:18) ⏐ 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 ViewV2API._checkResponse (src/tests/utilities/api/base.ts:205:15) at ViewV2API._checkResponse [as _request] (src/tests/utilities/api/base.ts:233:17) at ViewV2API._post (src/tests/utilities/api/base.ts:60:12) at ViewV2API.search (src/tests/utilities/api/viewV2.ts:67:12) at src/api/routes/tests/viewV2.spec.ts:3277:34

/v2/views (mariadb) › row operations › search › sorting › allow sorting ({ field: 'age': packages/server/src/tests/utilities/api/base.ts#L205

Expected status 200 but got 500 Body: ⏐ { ⏐ "message": "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls last, `a`.`id` asc limit 5000' at line 1", ⏐ "status": 500, ⏐ "error": { ⏐ "code": "ER_PARSE_ERROR" ⏐ } ⏐ } Stack from request handler: ⏐ Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nulls last, `a`.`id` asc limit 5000' at line 1 ⏐ 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 async Promise.all (index 0) ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search/external.ts:108:52) ⏐ at /home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:138:16 ⏐ at Object.search (/home/runner/work/budibase/budibase/packages/server/src/sdk/app/rows/search.ts:42:10) ⏐ at searchView (/home/runner/work/budibase/budibase/packages/server/src/api/controllers/row/views.ts:48:18) ⏐ 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 ViewV2API._checkResponse (src/tests/utilities/api/base.ts:205:15) at ViewV2API._checkResponse [as _request] (src/tests/utilities/api/base.ts:233:17) at ViewV2API._post (src/tests/utilities/api/base.ts:60:12) at ViewV2API.search (src/tests/utilities/api/viewV2.ts:67:12) at src/api/routes/tests/viewV2.spec.ts:3277:34

/v2/views (mariadb) › row operations › search › sorting › allow override the default view sorting ({ field: 'name': packages/server/src/tests/utilities/api/base.ts#L205

/v2/views (mariadb) › row operations › search › sorting › allow override the default view sorting ({ field: 'name' }): packages/server/src/tests/utilities/api/base.ts#L205

test-server (postgres)