Skip to content

Instantly share code, notes, and snippets.

@sevenmaxis

sevenmaxis/syntax_error.sql

Created February 26, 2021 14:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sevenmaxis/16cdee2ce9b12e34edbfe134aa9c1948 to your computer and use it in GitHub Desktop.
Save sevenmaxis/16cdee2ce9b12e34edbfe134aa9c1948 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
syntax_error.sql
2021-02-26T14:54:13.000000+00:00 app[heroku-postgres]: source=HEROKU_POSTGRESQL_JADE addon=postgresql-encircled-23248 sample#current_transaction=7651 sample#db_size=4459725679bytes sample#tables=67 samp│
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-1] sql_error_code = 42601 ERROR: syntax error at or near ";" at character 361 │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-2] sql_error_code = 42601 STATEMENT: SELECT │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-3] o.name AS "Office name", │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-4] e.email AS "Email", │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-5] e.* │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-6] FROM │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-7] public.employees e │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-8] INNER JOIN offices o ON e.office_id = o.id │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-9] WHERE │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-10] e.customer_id = 673 │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-11] AND e.id NOT IN( │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-12] SELECT │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-13] employee_id FROM public.rewards │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-14] WHERE │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-15] campaign_id = 1111 -- AND created_at BETWEEN '2020-01-22 00:00:00' AND '2020-01-22 23:59:59') │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-16] ORDER BY │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-17] o.name, e.id DESC │
│2021-02-26T14:54:37.000000+00:00 app[postgres.29600]: [JADE] [10-18] LIMIT 1000; │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-1] sql_error_code = 42601 ERROR: syntax error at or near ";" at character 361 │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-2] sql_error_code = 42601 STATEMENT: SELECT │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-3] o.name AS "Office name", │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-4] e.email AS "Email", │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-5] e.* │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-6] FROM │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-7] public.employees e │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-8] INNER JOIN offices o ON e.office_id = o.id │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-9] WHERE │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-10] e.customer_id = 673 │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-11] AND e.id NOT IN( │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-12] SELECT │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-13] employee_id FROM public.rewards │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-14] WHERE │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-15] campaign_id = 1111 -- AND created_at BETWEEN '2020-01-22 00:00:00' AND '2020-01-22 23:59:59') │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-16] ORDER BY │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-17] o.name, e.id DESC │
│2021-02-26T14:55:01.000000+00:00 app[postgres.29600]: [JADE] [11-18] LIMIT 1000; │
│2021-02-26T14:53:37.000000+00:00 app[heroku-postgres]: source=HEROKU_POSTGRESQL_IVORY addon=postgresql-animated-71352 sample#current_transaction=7651 sample#db_size=4459774831bytes sample#tables=67 samp│
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-1] sql_error_code = 42601 ERROR: syntax error at or near ";" at character 367 │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-2] sql_error_code = 42601 STATEMENT: SELECT │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-3] o.name AS "Office name", │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-4] e.email AS "Email", │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-5] e.* │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-6] FROM │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-7] public.employees e │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-8] INNER JOIN offices o ON e.office_id = o.id │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-9] WHERE │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-10] e.customer_id = 673 │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-11] AND e.id NOT IN( │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-12] SELECT │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-13] employee_id FROM public.rewards │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-14] WHERE │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-15] campaign_id = 1111 -- AND created_at BETWEEN '2020-01-22 00:00:00' AND '2020-01-22 23:59:59')
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-16] ORDER BY │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-17] o.name, e.id DESC │
│2021-02-26T14:55:28.000000+00:00 app[postgres.29600]: [JADE] [12-18] LIMIT 1000;
|2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-1] sql_error_code = 42601 ERROR: syntax error at or near ";" at character 361 │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-2] sql_error_code = 42601 STATEMENT: SELECT │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-3] o.name AS "Office name", │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-4] e.email AS "Email", │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-5] e.* │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-6] FROM │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-7] public.employees e │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-8] INNER JOIN offices o ON e.office_id = o.id │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-9] WHERE │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-10] e.customer_id = 674 │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-11] AND e.id NOT IN( │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-12] SELECT │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-13] employee_id FROM public.rewards │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-14] WHERE │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-15] campaign_id = 1112 -- AND created_at BETWEEN '2020-01-22 00:00:00' AND '2020-01-22 23:59:59') │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-16] ORDER BY │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-17] o.name, e.id DESC │
│2021-02-26T14:57:28.000000+00:00 app[postgres.29600]: [JADE] [13-18] LIMIT 1000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment