[teiid-issues] [JBoss JIRA] (TEIID-2096) Colons need to be escaped

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12788572#comment-12788572 ] 

RH Bugzilla Integration commented on TEIID-2096:
------------------------------------------------

jolee at redhat.com changed the Status of [bug 880811|https://bugzilla.redhat.com/show_bug.cgi?id=880811] from VERIFIED to CLOSED
                
> Colons need to be escaped
> -------------------------
>
>                 Key: TEIID-2096
>                 URL: https://issues.jboss.org/browse/TEIID-2096
>             Project: Teiid
>          Issue Type: Bug
>          Components: ODBC
>    Affects Versions: 7.1, 7.7.2
>         Environment: Fedora 17, bash, psql from Fedora repo
>            Reporter: Simon Green
>            Assignee: Steven Hawkins
>             Fix For: 8.1, 7.7.2
>
>
> $ psql -h vdb.engineering.redhat.com -p 35432 -U sgreen -d EngVDBR
> Password for user sgreen: 
> psql (9.1.4, server 8.1.4)
> WARNING: psql version 9.1, server version 8.1.
>          Some psql features might not work.
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
> Type "help" for help.
> EngVDBR=> SELECT class, COUNT(*) FROM Bugzilla.audit_log GROUP BY class;
>                        class                       | count 
> ---------------------------------------------------+-------
>  Bugzilla::Component                               |  3686
>  Bugzilla::Extension::ExternalBugs::Bug            |  3110
>  Bugzilla::Extension::ExternalBugs::Type           |     4
>  Bugzilla::Extension::ExternalBugs::Type::Bugzilla |     1
>  Bugzilla::Extension::Releases::Release            |     5
>  Bugzilla::Field                                   |    27
>  Bugzilla::Field::Choice::cf_extra_component       |   421
>  Bugzilla::Field::Choice::cf_extra_version         |    20
>  Bugzilla::Field::Choice::cf_verified              |     1
>  Bugzilla::FlagType                                |    89
>  Bugzilla::Group                                   |    34
>  Bugzilla::Milestone                               |    81
>  Bugzilla::Product                                 |    30
>  Bugzilla::Release                                 |    66
>  Bugzilla::User                                    |  3316
>  Bugzilla::Version                                 |    79
> (16 rows)
> EngVDBR=> SELECT * FROM Bugzilla.audit_log WHERE class = 'Bugzilla::Component' LIMIT 1;
>  user_id | class | object_id | field | removed | added | at_time 
> ---------+-------+-----------+-------+---------+-------+---------
> (0 rows)
> EngVDBR=> SELECT * FROM Bugzilla.audit_log WHERE class = 'Bugzilla\:\:Component' LIMIT 1;
>  user_id |        class        | object_id |    field     | removed | added  |  
>       at_time        
> ---------+---------------------+-----------+--------------+---------+--------+--
> ---------------------
>   271726 | Bugzilla::Component |     91289 | initialowner | 173606  | 295575 | 2
> 012-05-19 19:33:15.0
> (1 row)
> Question is. Why do the colons need to be backspaced to get a result?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira