← Back to branch summary

~percona-toolkit-dev/percona-toolkit/mysql-5.6-test-fixes

« back to all changes in this revision

Viewing changes to t/lib/samples/pg/pg-log-002.txt

  • Committer: Daniel Nichter
  • Date: 2011-06-24 17:22:06 UTC
  • Revision ID: daniel@percona.com-20110624172206-c7q4s4ad6r260zz6
Add lib/, t/lib/, and sandbox/.  All modules are updated and passing on MySQL 5.1.

Show diffs side-by-side

added added

removed removed

Lines of Context:
t/lib/samples/pg/pg-log-002.txt
 
1
                SELECT sum(commits) AS commits,sum(adds) AS adds
 
2
                FROM stats_cvs_group
 
3
                WHERE group_id='98'
 
4
        
 
5
2004-05-07 11:58:22 LOG:  duration: 0.084312 sec
 
6
2004-05-07 11:58:22 LOG:  query: SELECT groups.group_name,groups.unix_group_name,
 
7
                groups.type_id,users.user_name,users.realname,
 
8
                news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details 
 
9
                FROM users,news_bytes,groups 
 
10
                WHERE news_bytes.group_id='98' AND news_bytes.is_approved <> '4' 
 
11
                AND users.user_id=news_bytes.submitted_by 
 
12
                AND news_bytes.group_id=groups.group_id 
 
13
                ORDER BY post_date DESC LIMIT 10 OFFSET 0
 
14
2004-05-07 11:58:22 LOG:  duration: 0.002680 sec
 
15
2004-05-07 11:58:36 LOG:  query: begin; select getdatabaseencoding(); commit