[teiid-issues] [JBoss JIRA] (TEIID-2096) Colons need to be escaped
Simon Green created TEIID-2096:
----------------------------------
Summary: Colons need to be escaped
Key: TEIID-2096
URL: https://issues.jboss.org/browse/TEIID-2096
Project: Teiid
Issue Type: Bug
Environment: Fedora 17, bash, psql from Fedora repo
Reporter: Simon Green
Assignee: Steven Hawkins
$ 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:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira