fix column names with spaces for relationship columns #25020
Annotations
10 errors
|
Test server:
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
|
|
Test server:
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
|
|
Test server:
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
|
|
Test server:
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
|
|
Test server:
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
|
|
Test server:
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
|
|
Test server:
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
|
|
Test server:
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
|
|
Test server:
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:3300:34
|
|
Test server:
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:3300:34
|
Loading