Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Filtering and special characters
Filtering and special characters [message #43256] Fri, 28 March 2008 08:40 Go to next message
Enrico Schenk is currently offline Enrico Schenk
Messages: 23
Registered: July 2009
Junior Member
Hello,

while experimenting with filters I found an unexpected behaviour of the
table filter. I created a table with the name $newtable within a Derby
profile (CREATE TABLE "$newtable" (col integer)). After applying a
"Starts with" filter with the expression "$", the table was not part of
the visible table list. Filtering tables with other names works perfect,
so I'm not sure if the seen behaviour is intended.

Thanks

Rico
Re: Filtering and special characters [message #43323 is a reply to message #43256] Fri, 28 March 2008 09:43 Go to previous messageGo to next message
Eclipse User
Originally posted by: brianf.sybase.com

Hey Rico...

I'd definitely add this as a bug. It may be that the filters are not aware
of special characters, so we could look at adding that.

--Fitz

"Enrico Schenk" <enrico.schenk@ingres.com> wrote in message
news:fsiovh$au5$1@build.eclipse.org...
> Hello,
>
> while experimenting with filters I found an unexpected behaviour of the
> table filter. I created a table with the name $newtable within a Derby
> profile (CREATE TABLE "$newtable" (col integer)). After applying a "Starts
> with" filter with the expression "$", the table was not part of the
> visible table list. Filtering tables with other names works perfect, so
> I'm not sure if the seen behaviour is intended.
>
> Thanks
>
> Rico
Re: Filtering and special characters [message #43357 is a reply to message #43323] Fri, 28 March 2008 09:51 Go to previous messageGo to next message
Enrico Schenk is currently offline Enrico Schenk
Messages: 23
Registered: July 2009
Junior Member
Hi Brian,

I have had a look into this. The ConnectionFilterImpl.NotLikeFilter does
not escape the search patterns, so the special characters are treated as
regex. Ok, I'm going to add this as a new bug.

Rico

Brian Fitzpatrick wrote:
> Hey Rico...
>
> I'd definitely add this as a bug. It may be that the filters are not aware
> of special characters, so we could look at adding that.
>
> --Fitz
>
> "Enrico Schenk" <enrico.schenk@ingres.com> wrote in message
> news:fsiovh$au5$1@build.eclipse.org...
>> Hello,
>>
>> while experimenting with filters I found an unexpected behaviour of the
>> table filter. I created a table with the name $newtable within a Derby
>> profile (CREATE TABLE "$newtable" (col integer)). After applying a "Starts
>> with" filter with the expression "$", the table was not part of the
>> visible table list. Filtering tables with other names works perfect, so
>> I'm not sure if the seen behaviour is intended.
>>
>> Thanks
>>
>> Rico
>
>
Re: Filtering and special characters [message #43383 is a reply to message #43357] Fri, 28 March 2008 10:12 Go to previous message
Eclipse User
Originally posted by: brianf.sybase.com

Thanks for the bug and the patch1 I'll get it delivered next week after we
get through the M6 milestone build.
--Fitz

"Enrico Schenk" <enrico.schenk@ingres.com> wrote in message
news:fsit57$7vp$1@build.eclipse.org...
> Hi Brian,
>
> I have had a look into this. The ConnectionFilterImpl.NotLikeFilter does
> not escape the search patterns, so the special characters are treated as
> regex. Ok, I'm going to add this as a new bug.
>
> Rico
>
> Brian Fitzpatrick wrote:
>> Hey Rico...
>>
>> I'd definitely add this as a bug. It may be that the filters are not
>> aware of special characters, so we could look at adding that.
>>
>> --Fitz
>>
>> "Enrico Schenk" <enrico.schenk@ingres.com> wrote in message
>> news:fsiovh$au5$1@build.eclipse.org...
>>> Hello,
>>>
>>> while experimenting with filters I found an unexpected behaviour of the
>>> table filter. I created a table with the name $newtable within a Derby
>>> profile (CREATE TABLE "$newtable" (col integer)). After applying a
>>> "Starts with" filter with the expression "$", the table was not part of
>>> the visible table list. Filtering tables with other names works perfect,
>>> so I'm not sure if the seen behaviour is intended.
>>>
>>> Thanks
>>>
>>> Rico
>>
Re: Filtering and special characters [message #590659 is a reply to message #43256] Fri, 28 March 2008 09:43 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Hey Rico...

I'd definitely add this as a bug. It may be that the filters are not aware
of special characters, so we could look at adding that.

--Fitz

"Enrico Schenk" <enrico.schenk@ingres.com> wrote in message
news:fsiovh$au5$1@build.eclipse.org...
> Hello,
>
> while experimenting with filters I found an unexpected behaviour of the
> table filter. I created a table with the name $newtable within a Derby
> profile (CREATE TABLE "$newtable" (col integer)). After applying a "Starts
> with" filter with the expression "$", the table was not part of the
> visible table list. Filtering tables with other names works perfect, so
> I'm not sure if the seen behaviour is intended.
>
> Thanks
>
> Rico
Re: Filtering and special characters [message #590665 is a reply to message #43323] Fri, 28 March 2008 09:51 Go to previous message
Enrico Schenk is currently offline Enrico Schenk
Messages: 23
Registered: July 2009
Junior Member
Hi Brian,

I have had a look into this. The ConnectionFilterImpl.NotLikeFilter does
not escape the search patterns, so the special characters are treated as
regex. Ok, I'm going to add this as a new bug.

Rico

Brian Fitzpatrick wrote:
> Hey Rico...
>
> I'd definitely add this as a bug. It may be that the filters are not aware
> of special characters, so we could look at adding that.
>
> --Fitz
>
> "Enrico Schenk" <enrico.schenk@ingres.com> wrote in message
> news:fsiovh$au5$1@build.eclipse.org...
>> Hello,
>>
>> while experimenting with filters I found an unexpected behaviour of the
>> table filter. I created a table with the name $newtable within a Derby
>> profile (CREATE TABLE "$newtable" (col integer)). After applying a "Starts
>> with" filter with the expression "$", the table was not part of the
>> visible table list. Filtering tables with other names works perfect, so
>> I'm not sure if the seen behaviour is intended.
>>
>> Thanks
>>
>> Rico
>
>
Re: Filtering and special characters [message #590679 is a reply to message #43357] Fri, 28 March 2008 10:12 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Thanks for the bug and the patch1 I'll get it delivered next week after we
get through the M6 milestone build.
--Fitz

"Enrico Schenk" <enrico.schenk@ingres.com> wrote in message
news:fsit57$7vp$1@build.eclipse.org...
> Hi Brian,
>
> I have had a look into this. The ConnectionFilterImpl.NotLikeFilter does
> not escape the search patterns, so the special characters are treated as
> regex. Ok, I'm going to add this as a new bug.
>
> Rico
>
> Brian Fitzpatrick wrote:
>> Hey Rico...
>>
>> I'd definitely add this as a bug. It may be that the filters are not
>> aware of special characters, so we could look at adding that.
>>
>> --Fitz
>>
>> "Enrico Schenk" <enrico.schenk@ingres.com> wrote in message
>> news:fsiovh$au5$1@build.eclipse.org...
>>> Hello,
>>>
>>> while experimenting with filters I found an unexpected behaviour of the
>>> table filter. I created a table with the name $newtable within a Derby
>>> profile (CREATE TABLE "$newtable" (col integer)). After applying a
>>> "Starts with" filter with the expression "$", the table was not part of
>>> the visible table list. Filtering tables with other names works perfect,
>>> so I'm not sure if the seen behaviour is intended.
>>>
>>> Thanks
>>>
>>> Rico
>>
Previous Topic:Type hierarchy of JDBCUniqueConstraint
Next Topic:Re: DTP: Why SQL statements die saying "no database selected"
Goto Forum:
  


Current Time: Fri Jul 25 13:38:05 EDT 2014

Powered by FUDForum. Page generated in 0.01796 seconds