Bug in LIKE operator processing

From: Żak, Sławomir <SZak(at)era(dot)pl>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Bug in LIKE operator processing
Date: 2003-01-27 15:58:46
Message-ID: 2560F40A346E1C42A18A2C49A058F206101040@AMON.corponet.era.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I've found that statement:

SELECT * FROM os WHERE 'FreeBSD 4.7-RC'
LIKE string_id; (one of string_id's is 'FreeBSD 4.7%')

doesn't work. No error is reported. It does work in Oracle,
so I think it's a standard SQL query.

Table is defined as:

host=> \d os
Table "os"
Column | Type | Modifiers
-----------+-----------------------+-----------------------------------------------
id | integer | not null default nextval('"os_id_seq"'::text)
name | character varying(32) |
major | integer |
minor | integer |
subrev | character(16) |
string_id | character(32) |
Unique keys: os_id_key

PostgreSQL version is 7.3.1

Is it non-implemented by design, or maybe I've overlooked something?

Thanks, /S

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jean-Luc Lachance 2003-01-27 19:42:36 No error reported when field in subselect is not part of the table but exists in the main table.
Previous Message Fredy K. GMX 2003-01-27 14:54:55 ECPG does not recognise typedefs