Skip site navigation (1) Skip section navigation (2)

Bug in parser

From: Andriy I Pilipenko <bamby(at)marka(dot)net(dot)ua>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug in parser
Date: 1999-01-11 09:51:34
Message-ID: Pine.BSF.4.05.9901111139260.538-100000@pai.marka.net.ua (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	Andriy I Pilipenko
Your email address	:	bamby(at)marka(dot)net(dot)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

Next:From: Unprivileged userDate: 1999-01-11 10:19:16
Subject: General Bug Report: PG/PLSQL makes errors in compiling sql-requests (aggregates)
Previous:From: Unprivileged userDate: 1999-01-11 04:49:22
Subject: General Bug Report: pg_attribute a.attlen does not return correct values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group