Bug in parser - Mailing list pgsql-bugs

From Andriy I Pilipenko
Subject Bug in parser
Date
Msg-id Pine.BSF.4.05.9901111139260.538-100000@pai.marka.net.ua
Whole thread Raw
List pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        :    Andriy I Pilipenko
Your email address    :    bamby@marka.net.ua


System Configuration
---------------------
  Architecture (example: Intel Pentium)      :    i486 and higher

  Operating System (example: Linux 2.0.26 ELF)     :    FreeBSD 2.2.6
                            FreeBSD 2.2.7
                            Linux 2.0.34 ELF

  PostgreSQL version (example: PostgreSQL-6.4.2)  :       PostgreSQL-6.4
                            PostgreSQL-6.4.2

  Compiler used (example:  gcc 2.8.0)        :    gcc 2.7.2.1


Please enter a FULL description of your problem:
------------------------------------------------

Backend reports syntax error near unary '-' in queries like:

    SELECT * FROM some_table WHERE some_column IN ( <negative number> )
                           ^^^^^^^^^^^^^^^^^^^^^^^^
This bug not existed in 6.3.2. It first appeared in 6.4 and remains in
6.4.2.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

Bug is very easy to reproduce. See query above.



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------






pgsql-bugs by date:

Previous
From: Unprivileged user
Date:
Subject: General Bug Report: pg_attribute a.attlen does not return correct values
Next
From: Unprivileged user
Date:
Subject: General Bug Report: PG/PLSQL makes errors in compiling sql-requests (aggregates)