BUG #15606: Postgres incorrectly returns syntax error when using WITH clacuse

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: newsx(at)outlook(dot)com
Subject: BUG #15606: Postgres incorrectly returns syntax error when using WITH clacuse
Date: 2019-01-23 13:18:36
Message-ID: 15606-57631ea2557ebb93@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15606
Logged by: Rikke Hammer
Email address: newsx(at)outlook(dot)com
PostgreSQL version: 11.1
Operating system: Windows 10 Home version1803 x64
Description:

I get a syntax error when I try to use a WITH clause in a query. Below is a
simple test query. It (as as well as any other WITH clause query I do,
creates the following error:

SQL Error [42601]: ERROR: syntax error at end of input
Position: 53
ERROR: syntax error at end of input
Position: 53
ERROR: syntax error at end of input
Position: 53

CREATE TABLE employees (
employee_id serial PRIMARY KEY,
full_name VARCHAR NOT NULL,
manager_id INT
);

INSERT INTO employees (
employee_id,
full_name,
manager_id
)
VALUES
(1, 'Michael North', NULL),
(2, 'Megan Berry', 1),
(3, 'Sarah Berry', 1),
(4, 'Zoe Black', 1),
(5, 'Tim James', 1),
(6, 'Bella Tucker', 2),
(7, 'Ryan Metcalfe', 2);

WITH emp AS (
select * from rikke_hammer.employees)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2019-01-23 14:45:21 Re: BUG #15606: Postgres incorrectly returns syntax error when using WITH clacuse
Previous Message PG Bug reporting form 2019-01-23 08:57:43 BUG #15605: Unstable regression test "tablespace"