[teiid-issues] [JBoss JIRA] (TEIID-2096) Colons need to be escaped
Johnathon Lee (JIRA)
jira-events at lists.jboss.org
Mon Sep 10 09:42:32 EDT 2012
[ https://issues.jboss.org/browse/TEIID-2096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Johnathon Lee updated TEIID-2096:
---------------------------------
Affects Version/s: 7.7.2
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=855868 (was: https://bugzilla.redhat.com/show_bug.cgi?id=855868)
> 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
>
>
> $ 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
More information about the teiid-issues
mailing list