Below is the list of changes that have just been committed into a local
5.1 repository of mleich. When mleich does a push these changes
will be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
ChangeSet@stripped, 2008-03-07 20:18:14+01:00, mleich@stripped +100 -0
Post merge fixes after
ChangeSet@stripped, 2008-03-07 17:44:03+01:00, mleich@stripped +132 -0
Merge five.local.lan:/work/merge/mysql-5.0-funcs_1
into five.local.lan:/work/merge/mysql-5.1-funcs_1
MERGE: 1.1810.3473.24
ChangeSet@stripped, 2008-03-07
WL#4203 Reorganize and fix the data dictionary tests of
testsuite funcs_1
1. Adjustment of expected results to modified server properties
2. Add some tests of information_schema views
3. Minor corrections and improvements
BitKeeper/deleted/.del-ndb__datadict.result@stripped, 2008-03-07 18:28:35+01:00,
mleich@stripped +0 -0
Delete: mysql-test/suite/funcs_1/r/ndb__datadict.result
BitKeeper/deleted/.del-ndb__datadict.test@stripped, 2008-03-07 18:28:43+01:00,
mleich@stripped +0 -0
Delete: mysql-test/suite/funcs_1/t/ndb__datadict.test
BitKeeper/deleted/.del-ndb__load.result@stripped, 2008-03-07 19:31:11+01:00,
mleich@stripped +0 -0
Delete: mysql-test/suite/funcs_1/r/ndb__load.result
BitKeeper/deleted/.del-ndb__load.test@stripped, 2008-03-07 19:31:03+01:00,
mleich@stripped +0 -0
Delete: mysql-test/suite/funcs_1/t/ndb__load.test
mysql-test/suite/funcs_1/datadict/processlist_priv.inc@stripped, 2008-03-07 20:18:05+01:00,
mleich@stripped +28 -28
Make the results independend of amount of preceding tests.
mysql-test/suite/funcs_1/datadict/processlist_val.inc@stripped, 2008-03-07 20:18:05+01:00,
mleich@stripped +1 -0
Correct the cleanup
mysql-test/suite/funcs_1/r/charset_collation_1.result@stripped, 2008-03-07 20:18:05+01:00,
mleich@stripped +3 -0
Updated results
mysql-test/suite/funcs_1/r/charset_collation_2.result@stripped, 2008-03-07 20:18:05+01:00,
mleich@stripped +3 -0
Updated results
mysql-test/suite/funcs_1/r/innodb_func_view.result@stripped, 2008-03-07 20:18:05+01:00,
mleich@stripped +4778 -4790
Updated results
mysql-test/suite/funcs_1/r/innodb_storedproc.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +18135 -18142
Updated results
mysql-test/suite/funcs_1/r/innodb_storedproc_02.result@stripped, 2008-03-07 19:33:22+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/innodb_storedproc_03.result@stripped, 2008-03-07 19:33:22+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/innodb_storedproc_07.result@stripped, 2008-03-07 19:33:22+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/innodb_storedproc_08.result@stripped, 2008-03-07 19:33:22+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/innodb_storedproc_10.result@stripped, 2008-03-07 19:33:22+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/is_basics_mixed.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +1 -1
Updated results
mysql-test/suite/funcs_1/r/is_character_sets.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +4 -4
Updated results
mysql-test/suite/funcs_1/r/is_collation_character_set_applicability.result@stripped,
2008-03-07 20:18:07+01:00, mleich@stripped +2 -2
Updated results
mysql-test/suite/funcs_1/r/is_collations.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +6 -6
Updated results
mysql-test/suite/funcs_1/r/is_column_privileges.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +9 -7
Updated results
mysql-test/suite/funcs_1/r/is_columns.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +29 -29
Updated results
mysql-test/suite/funcs_1/r/is_columns_innodb.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +1 -1
Updated results
mysql-test/suite/funcs_1/r/is_columns_is.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +306 -30
Updated results
mysql-test/suite/funcs_1/r/is_columns_memory.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +1 -1
Updated results
mysql-test/suite/funcs_1/r/is_columns_myisam.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +1 -1
Updated results
mysql-test/suite/funcs_1/r/is_columns_mysql.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +156 -18
Updated results
mysql-test/suite/funcs_1/r/is_engines.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +84 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_archive.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_archive.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_blackhole.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_blackhole.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_csv.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_csv.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_federated.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_federated.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_innodb.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_innodb.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_memory.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_memory.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_merge.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_merge.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_myisam.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_myisam.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_engines_ndb.result@stripped, 2008-03-07 20:18:13+01:00,
mleich@stripped +8 -0
Expected results
mysql-test/suite/funcs_1/r/is_engines_ndb.result@stripped, 2008-03-07 20:18:13+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_events.result@stripped, 2008-03-07 20:18:13+01:00,
mleich@stripped +148 -0
Expected results
mysql-test/suite/funcs_1/r/is_events.result@stripped, 2008-03-07 20:18:13+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/r/is_key_column_usage.result@stripped, 2008-03-07 20:18:07+01:00,
mleich@stripped +12 -12
Updated results
mysql-test/suite/funcs_1/r/is_routines.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +57 -27
Updated results
mysql-test/suite/funcs_1/r/is_schema_privileges.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +5 -5
Updated results
mysql-test/suite/funcs_1/r/is_schema_privileges_is_mysql_test.result@stripped, 2008-03-07
20:18:08+01:00, mleich@stripped +2 -0
Updated results
mysql-test/suite/funcs_1/r/is_schemata.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +5 -5
Updated results
mysql-test/suite/funcs_1/r/is_statistics.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +15 -15
Updated results
mysql-test/suite/funcs_1/r/is_statistics_mysql.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +5 -0
Updated results
mysql-test/suite/funcs_1/r/is_table_constraints.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +6 -6
Updated results
mysql-test/suite/funcs_1/r/is_table_constraints_mysql.result@stripped, 2008-03-07
20:18:08+01:00, mleich@stripped +4 -0
Updated results
mysql-test/suite/funcs_1/r/is_table_privileges.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +10 -6
Updated results
mysql-test/suite/funcs_1/r/is_tables.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +39 -39
Updated results
mysql-test/suite/funcs_1/r/is_tables_is.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +538 -32
Updated results
mysql-test/suite/funcs_1/r/is_tables_mysql.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +138 -0
Updated results
mysql-test/suite/funcs_1/r/is_tables_ndb.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +0 -23
Updated results
mysql-test/suite/funcs_1/r/is_triggers.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +58 -42
Updated results
mysql-test/suite/funcs_1/r/is_user_privileges.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +48 -48
Updated results
mysql-test/suite/funcs_1/r/is_views.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +25 -21
Updated results
mysql-test/suite/funcs_1/r/memory_func_view.result@stripped, 2008-03-07 20:18:08+01:00,
mleich@stripped +4778 -4790
Updated results
mysql-test/suite/funcs_1/r/memory_storedproc.result@stripped, 2008-03-07 20:18:09+01:00,
mleich@stripped +18100 -18108
Updated results
mysql-test/suite/funcs_1/r/memory_storedproc_02.result@stripped, 2008-03-07 19:33:11+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/memory_storedproc_03.result@stripped, 2008-03-07 19:33:11+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/memory_storedproc_07.result@stripped, 2008-03-07 19:33:03+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/memory_storedproc_08.result@stripped, 2008-03-07 19:33:11+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/memory_storedproc_10.result@stripped, 2008-03-07 19:33:11+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/myisam_func_view.result@stripped, 2008-03-07 20:18:09+01:00,
mleich@stripped +4778 -4790
Updated results
mysql-test/suite/funcs_1/r/myisam_storedproc.result@stripped, 2008-03-07 20:18:10+01:00,
mleich@stripped +18135 -18142
Updated results
mysql-test/suite/funcs_1/r/myisam_storedproc_02.result@stripped, 2008-03-07 19:33:23+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/myisam_storedproc_03.result@stripped, 2008-03-07 19:33:23+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/myisam_storedproc_07.result@stripped, 2008-03-07 19:33:23+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/myisam_storedproc_08.result@stripped, 2008-03-07 19:33:23+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/myisam_storedproc_10.result@stripped, 2008-03-07 19:33:23+01:00,
mleich@stripped +0 -0
Change mode to -rw-rw-r--
mysql-test/suite/funcs_1/r/myisam_views.result@stripped, 2008-03-07 20:18:10+01:00,
mleich@stripped +11800 -11801
Updated results
mysql-test/suite/funcs_1/r/ndb_func_view.result@stripped, 2008-03-07 20:18:11+01:00,
mleich@stripped +4778 -4790
Updated results
mysql-test/suite/funcs_1/r/ndb_storedproc.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +18122 -18129
Updated results
mysql-test/suite/funcs_1/r/ndb_storedproc_02.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -2
Updated results
mysql-test/suite/funcs_1/r/ndb_storedproc_03.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -2
Updated results
mysql-test/suite/funcs_1/r/ndb_storedproc_07.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -2
Updated results
mysql-test/suite/funcs_1/r/ndb_storedproc_08.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -2
Updated results
mysql-test/suite/funcs_1/r/ndb_storedproc_10.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -2
Updated results
mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result@stripped, 2008-03-07
20:18:12+01:00, mleich@stripped +117 -117
Updated results
mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result@stripped, 2008-03-07
18:30:03+01:00, mleich@stripped +0 -0
Rename: mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result ->
mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result
mysql-test/suite/funcs_1/r/processlist_priv_ps.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +117 -117
Updated results
mysql-test/suite/funcs_1/r/processlist_priv_ps.result@stripped, 2008-03-07 18:31:48+01:00,
mleich@stripped +0 -0
Rename: mysql-test/suite/funcs_1/r/b_processlist_priv_ps.result ->
mysql-test/suite/funcs_1/r/processlist_priv_ps.result
mysql-test/suite/funcs_1/r/processlist_val_no_prot.result@stripped, 2008-03-07
20:18:12+01:00, mleich@stripped +1 -0
Updated results
mysql-test/suite/funcs_1/r/processlist_val_no_prot.result@stripped, 2008-03-07
18:32:32+01:00, mleich@stripped +0 -0
Rename: mysql-test/suite/funcs_1/r/a_processlist_val_no_prot.result ->
mysql-test/suite/funcs_1/r/processlist_val_no_prot.result
mysql-test/suite/funcs_1/r/processlist_val_ps.result@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +1 -0
Updated results
mysql-test/suite/funcs_1/r/processlist_val_ps.result@stripped, 2008-03-07 18:33:21+01:00,
mleich@stripped +0 -0
Rename: mysql-test/suite/funcs_1/r/b_processlist_val_ps.result ->
mysql-test/suite/funcs_1/r/processlist_val_ps.result
mysql-test/suite/funcs_1/storedproc/storedproc_master.inc@stripped, 2008-03-07
20:18:12+01:00, mleich@stripped +7 -7
Set subtest checking a no more reserved keyword
to comment.
mysql-test/suite/funcs_1/t/disabled.def@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -1
ndb__datadict is dropped. The checks are done in
other scripts.
mysql-test/suite/funcs_1/t/is_engines.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +126 -0
Test of information_schema.engines
mysql-test/suite/funcs_1/t/is_engines.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_archive.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +15 -0
Test of information_schema.engines
Variant for ARCHIVE
mysql-test/suite/funcs_1/t/is_engines_archive.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_blackhole.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +15 -0
Test of information_schema.engines
Variant for BLACKHOLE
mysql-test/suite/funcs_1/t/is_engines_blackhole.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_csv.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +15 -0
Test of information_schema.engines
Variant for CSV
mysql-test/suite/funcs_1/t/is_engines_csv.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_federated.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +15 -0
Test of information_schema.engines
Variant for FEDERATED
mysql-test/suite/funcs_1/t/is_engines_federated.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_innodb.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +15 -0
Test of information_schema.engines
Variant for InnoDB
mysql-test/suite/funcs_1/t/is_engines_innodb.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_memory.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +14 -0
Test of information_schema.engines
Variant for MEMORY
mysql-test/suite/funcs_1/t/is_engines_memory.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_merge.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +14 -0
Test of information_schema.engines
Variant for MERGGE
mysql-test/suite/funcs_1/t/is_engines_merge.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_myisam.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +14 -0
Test of information_schema.engines
Variant for MyISAM
mysql-test/suite/funcs_1/t/is_engines_myisam.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_engines_ndb.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +15 -0
Test of information_schema.engines
Variant for NDB
mysql-test/suite/funcs_1/t/is_engines_ndb.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_events.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +169 -0
Test for information_schema.events
mysql-test/suite/funcs_1/t/is_events.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +0 -0
mysql-test/suite/funcs_1/t/is_routines.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +4 -0
Correction of comment
mysql-test/suite/funcs_1/t/is_triggers.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +11 -7
Adjustment to changes in privilege system between
MySQL 5.0 and 5.1.
mysql-test/suite/funcs_1/t/is_views.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +3 -0
Correction of comment.
mysql-test/suite/funcs_1/t/processlist_priv_no_prot.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +1 -7
Correction of comment.
mysql-test/suite/funcs_1/t/processlist_priv_no_prot.test@stripped, 2008-03-07 18:34:18+01:00,
mleich@stripped +0 -0
Rename: mysql-test/suite/funcs_1/t/a_processlist_priv_no_prot.test ->
mysql-test/suite/funcs_1/t/processlist_priv_no_prot.test
mysql-test/suite/funcs_1/t/processlist_priv_ps.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +1 -7
Correction of comment.
mysql-test/suite/funcs_1/t/processlist_priv_ps.test@stripped, 2008-03-07 18:34:57+01:00,
mleich@stripped +0 -0
Rename: mysql-test/suite/funcs_1/t/b_processlist_priv_ps.test ->
mysql-test/suite/funcs_1/t/processlist_priv_ps.test
mysql-test/suite/funcs_1/t/processlist_val_no_prot.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +1 -7
Correction of comment.
mysql-test/suite/funcs_1/t/processlist_val_no_prot.test@stripped, 2008-03-07 19:37:57+01:00,
mleich@stripped +0 -0
Rename: mysql-test/suite/funcs_1/t/a_processlist_val_no_prot.test ->
mysql-test/suite/funcs_1/t/processlist_val_no_prot.test
mysql-test/suite/funcs_1/t/processlist_val_ps.test@stripped, 2008-03-07 20:18:12+01:00,
mleich@stripped +1 -7
Correction of comment.
mysql-test/suite/funcs_1/t/processlist_val_ps.test@stripped, 2008-03-07 19:38:50+01:00,
mleich@stripped +0 -0
Rename: mysql-test/suite/funcs_1/t/b_processlist_val_ps.test ->
mysql-test/suite/funcs_1/t/processlist_val_ps.test
diff -Nrup a/mysql-test/suite/funcs_1/datadict/processlist_priv.inc
b/mysql-test/suite/funcs_1/datadict/processlist_priv.inc
--- a/mysql-test/suite/funcs_1/datadict/processlist_priv.inc 2007-08-29 21:36:43 +02:00
+++ b/mysql-test/suite/funcs_1/datadict/processlist_priv.inc 2008-03-07 20:18:05 +01:00
@@ -112,11 +112,11 @@ connect (con100,localhost,ddicttestuser1
--echo
####################################################################################
connection default;
eval SHOW CREATE TABLE $table;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
eval SHOW $table;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
eval SELECT * FROM $table $select_where ORDER BY id;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
eval SELECT $columns FROM $table $select_where ORDER BY id;
--source suite/funcs_1/datadict/datadict_priv.inc
--real_sleep 0.3
@@ -128,11 +128,11 @@ connection con100;
--echo SHOW/SELECT shows only the processes (1) of the user.
--echo
####################################################################################
eval SHOW CREATE TABLE $table;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
eval SHOW $table;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
eval SELECT * FROM $table $select_where ORDER BY id;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
eval SELECT $columns FROM $table $select_where ORDER BY id;
--source suite/funcs_1/datadict/datadict_priv.inc
--real_sleep 0.3
@@ -154,9 +154,9 @@ GRANT PROCESS ON *.* TO ddicttestuser1@'
--echo
####################################################################################
connection con100;
SHOW GRANTS;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -166,9 +166,9 @@ SELECT * FROM information_schema.process
--echo
####################################################################################
connect (con101,localhost,ddicttestuser1,ddictpass,information_schema);
SHOW GRANTS;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -188,9 +188,9 @@ GRANT PROCESS ON *.* TO ''@'localhost';
--echo
####################################################################################
connect (anonymous1,localhost,'',,information_schema);
SHOW GRANTS;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -210,9 +210,9 @@ connect (con102,localhost,ddicttestuser1
--echo ddicttestuser1 are visible.
--echo
####################################################################################
SHOW GRANTS;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -235,10 +235,10 @@ SHOW GRANTS FOR ''@'localhost';
if ($fixed_bug_30395)
{
# Bug#30395 strange results after REVOKE PROCESS ON *.* FROM ...
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
}
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -257,9 +257,9 @@ connect (con103,localhost,ddicttestuser1
--echo Only the processes of ddicttestuser1 user are visible.
--echo
####################################################################################
SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -279,9 +279,9 @@ connect (con104,localhost,ddicttestuser1
--echo Only the processes of ddicttestuser1 are visible.
--echo
####################################################################################
SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -326,9 +326,9 @@ connect (con200,localhost,ddicttestuser2
--echo ddicttestuser2 has now the PROCESS privilege and sees all connections
--echo
####################################################################################
SHOW GRANTS FOR 'ddicttestuser2'@'localhost';
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -347,9 +347,9 @@ connect (con201,localhost,ddicttestuser2
--echo ddicttestuser2 has no more the PROCESS privilege and can only see own
connects
--echo
####################################################################################
SHOW GRANTS;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -370,9 +370,9 @@ connect (con107,localhost,ddicttestuser1
SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
--error ER_ACCESS_DENIED_ERROR
GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
@@ -394,9 +394,9 @@ connect (con108,localhost,ddicttestuser1
--echo Therefore the missing SELECT privilege does not affect SELECTs on
PROCESSLIST.
--echo
####################################################################################
SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SHOW processlist;
---replace_column 6 TIME
+--replace_column 1 ID 6 TIME
SELECT * FROM information_schema.processlist;
--real_sleep 0.3
diff -Nrup a/mysql-test/suite/funcs_1/datadict/processlist_val.inc
b/mysql-test/suite/funcs_1/datadict/processlist_val.inc
--- a/mysql-test/suite/funcs_1/datadict/processlist_val.inc 2008-02-06 11:02:43 +01:00
+++ b/mysql-test/suite/funcs_1/datadict/processlist_val.inc 2008-03-07 20:18:05 +01:00
@@ -306,3 +306,4 @@ connection default;
--echo ----- close connection ddicttestuser1 -----
disconnect ddicttestuser1;
DROP USER ddicttestuser1@'localhost';
+DROP TABLE test.t1;
diff -Nrup a/mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result
b/mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result
--- a/mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result 2008-01-31 16:12:48
+01:00
+++ /dev/null Wed Dec 31 16:00:00 196900
@@ -1,475 +0,0 @@
-USE information_schema;
-####################################################################################
-1 Prepare test.
-connection default (user=root)
-####################################################################################
-####################################################################################
-1.1 Create two user
-####################################################################################
-DROP USER ddicttestuser1@'localhost';
-ERROR HY000: Operation DROP USER failed for 'ddicttestuser1'@'localhost'
-DROP USER ddicttestuser2@'localhost';
-ERROR HY000: Operation DROP USER failed for 'ddicttestuser2'@'localhost'
-CREATE USER ddicttestuser1@'localhost';
-CREATE USER ddicttestuser2@'localhost';
-SET PASSWORD FOR ddicttestuser1@'localhost' = PASSWORD('ddictpass');
-SET PASSWORD FOR ddicttestuser2@'localhost' = PASSWORD('ddictpass');
-####################################################################################
-1.2 Establish connection con100 (user=ddicttestuser1 with no PROCESS privilege):
-####################################################################################
-####################################################################################
-2 connection default(user=root with default privileges):
-SHOW/SELECT shows all processes/threads.
-####################################################################################
-SHOW CREATE TABLE processlist;
-Table Create Table
-PROCESSLIST CREATE TEMPORARY TABLE `PROCESSLIST` (
- `ID` bigint(4) NOT NULL DEFAULT '0',
- `USER` varchar(16) NOT NULL DEFAULT '',
- `HOST` varchar(64) NOT NULL DEFAULT '',
- `DB` varchar(64) DEFAULT NULL,
- `COMMAND` varchar(16) NOT NULL DEFAULT '',
- `TIME` bigint(7) NOT NULL DEFAULT '0',
- `STATE` varchar(64) DEFAULT NULL,
- `INFO` longtext
-) ENGINE=MyISAM DEFAULT CHARSET=utf8
-SHOW processlist;
-Id User Host db Command Time State Info
-1 root localhost information_schema Query TIME NULL SHOW processlist
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-SELECT * FROM processlist ORDER BY id;
-ID USER HOST DB COMMAND TIME STATE INFO
-1 root localhost information_schema Query TIME executing SELECT * FROM processlist ORDER
BY id
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist ORDER BY id;
-ID USER HOST DB COMMAND TIME STATE INFO
-1 root localhost information_schema Query TIME executing SELECT ID, USER, HOST, DB,
COMMAND, TIME, STATE, INFO FROM processlist ORDER BY id
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-CREATE TEMPORARY TABLE test.t_processlist AS SELECT * FROM processlist;
-UPDATE test.t_processlist SET user='horst' WHERE id=1 ;
-INSERT INTO processlist SELECT * FROM test.t_processlist;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-DROP TABLE test.t_processlist;
-CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO) AS SELECT
* FROM processlist WITH CHECK OPTION;
-ERROR HY000: CHECK OPTION on non-updatable view 'test.v_processlist'
-CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO) AS SELECT
* FROM processlist;
-UPDATE test.v_processlist SET TIME=NOW() WHERE id = 1;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-DROP VIEW test.v_processlist;
-UPDATE processlist SET user='any_user' WHERE id=1 ;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-DELETE FROM processlist WHERE id=1 ;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-REVOKE ALL ON processlist FROM current_user;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-GRANT INSERT,UPDATE ON processlist TO current_user;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-SHOW GRANTS;
-Grants for root@localhost
-GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
-CREATE INDEX i_processlist ON processlist (user);
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-DROP TABLE processlist;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-ALTER TABLE processlist DROP COLUMN user;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-ALTER TABLE processlist ADD COLUMN (my_column INT);
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-RENAME TABLE processlist TO new_processlist;
-ERROR 42S02: Unknown table 'new_processlist' in information_schema
-RENAME TABLE processlist TO files;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-CREATE TABLE new_processlist AS SELECT * FROM processlist;
-ERROR 42S02: Unknown table 'new_processlist' in information_schema
-DROP DATABASE information_schema;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-RENAME DATABASE information_schema TO info_schema;
-ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'DATABASE information_schema
TO info_schema' at line 1
-ALTER DATABASE information_schema UPGRADE DATA DIRECTORY NAME;
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-####################################################################################
-3 Switch to connection con100 (user=ddicttestuser1 with no PROCESS privilege):
-SHOW/SELECT shows only the processes (1) of the user.
-####################################################################################
-SHOW CREATE TABLE processlist;
-Table Create Table
-PROCESSLIST CREATE TEMPORARY TABLE `PROCESSLIST` (
- `ID` bigint(4) NOT NULL DEFAULT '0',
- `USER` varchar(16) NOT NULL DEFAULT '',
- `HOST` varchar(64) NOT NULL DEFAULT '',
- `DB` varchar(64) DEFAULT NULL,
- `COMMAND` varchar(16) NOT NULL DEFAULT '',
- `TIME` bigint(7) NOT NULL DEFAULT '0',
- `STATE` varchar(64) DEFAULT NULL,
- `INFO` longtext
-) ENGINE=MyISAM DEFAULT CHARSET=utf8
-SHOW processlist;
-Id User Host db Command Time State Info
-2 ddicttestuser1 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM processlist ORDER BY id;
-ID USER HOST DB COMMAND TIME STATE INFO
-2 ddicttestuser1 localhost information_schema Query TIME executing SELECT * FROM
processlist ORDER BY id
-SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist ORDER BY id;
-ID USER HOST DB COMMAND TIME STATE INFO
-2 ddicttestuser1 localhost information_schema Query TIME executing SELECT ID, USER, HOST,
DB, COMMAND, TIME, STATE, INFO FROM processlist ORDER BY id
-CREATE TEMPORARY TABLE test.t_processlist AS SELECT * FROM processlist;
-UPDATE test.t_processlist SET user='horst' WHERE id=1 ;
-INSERT INTO processlist SELECT * FROM test.t_processlist;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-DROP TABLE test.t_processlist;
-CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO) AS SELECT
* FROM processlist WITH CHECK OPTION;
-ERROR HY000: CHECK OPTION on non-updatable view 'test.v_processlist'
-CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO) AS SELECT
* FROM processlist;
-UPDATE test.v_processlist SET TIME=NOW() WHERE id = 1;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-DROP VIEW test.v_processlist;
-UPDATE processlist SET user='any_user' WHERE id=1 ;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-DELETE FROM processlist WHERE id=1 ;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-REVOKE ALL ON processlist FROM current_user;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-GRANT INSERT,UPDATE ON processlist TO current_user;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-SHOW GRANTS;
-Grants for ddicttestuser1@localhost
-GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-CREATE INDEX i_processlist ON processlist (user);
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-DROP TABLE processlist;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-ALTER TABLE processlist DROP COLUMN user;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-ALTER TABLE processlist ADD COLUMN (my_column INT);
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-RENAME TABLE processlist TO new_processlist;
-ERROR 42S02: Unknown table 'new_processlist' in information_schema
-RENAME TABLE processlist TO files;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-CREATE TABLE new_processlist AS SELECT * FROM processlist;
-ERROR 42S02: Unknown table 'new_processlist' in information_schema
-DROP DATABASE information_schema;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-RENAME DATABASE information_schema TO info_schema;
-ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'DATABASE information_schema
TO info_schema' at line 1
-ALTER DATABASE information_schema UPGRADE DATA DIRECTORY NAME;
-ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database
'information_schema'
-####################################################################################
-4 Grant PROCESS privilege to ddicttestuser1
-connection default (user=root)
-####################################################################################
-GRANT PROCESS ON *.* TO ddicttestuser1@'localhost' IDENTIFIED BY 'ddictpass';
-####################################################################################
-4.1 Existing connection con100 (ddicttestuser1)
-The user ddicttestuser1 has the PROCESS privilege, but the connection was
-established before PROCESS was granted.
-SHOW/SELECT shows only the processes (1) of the user.
-####################################################################################
-SHOW GRANTS;
-Grants for ddicttestuser1@localhost
-GRANT PROCESS ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-SHOW processlist;
-Id User Host db Command Time State Info
-2 ddicttestuser1 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-2 ddicttestuser1 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-####################################################################################
-4.2 New connection con101 (ddicttestuser1 with PROCESS privilege)
-SHOW/SELECT shows all processes/threads.
-####################################################################################
-SHOW GRANTS;
-Grants for ddicttestuser1@localhost
-GRANT PROCESS ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-SHOW processlist;
-Id User Host db Command Time State Info
-1 root localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-3 ddicttestuser1 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-1 root localhost information_schema Sleep TIME NULL
-####################################################################################
-5 Grant PROCESS privilege to anonymous user.
-connection default (user=root)
-####################################################################################
-GRANT PROCESS ON *.* TO ''@'localhost';
-####################################################################################
-5.1 Establish connection (anonymous1,localhost,'',,information_schema)
-anonymous user with PROCESS privilege
-SHOW/SELECT shows all processes/threads.
-####################################################################################
-SHOW GRANTS;
-Grants for @localhost
-GRANT PROCESS ON *.* TO ''@'localhost'
-SHOW processlist;
-Id User Host db Command Time State Info
-1 root localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-4 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-4 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-1 root localhost information_schema Sleep TIME NULL
-####################################################################################
-6 Revoke PROCESS privilege from ddicttestuser1
-connection default (user=root)
-####################################################################################
-REVOKE PROCESS ON *.* FROM ddicttestuser1@'localhost' IDENTIFIED BY 'ddictpass';
-####################################################################################
-6.1 New connection con102 (ddicttestuser1 has no more PROCESS privilege)
-Again (compared to state before GRANT PROCESS) only the processes of
-ddicttestuser1 are visible.
-####################################################################################
-SHOW GRANTS;
-Grants for ddicttestuser1@localhost
-GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-SHOW processlist;
-Id User Host db Command Time State Info
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-5 ddicttestuser1 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-####################################################################################
-7 Revoke PROCESS privilege from anonymous user + disconnect ddicttestuser1
-connection default (user=root)
-####################################################################################
-REVOKE PROCESS ON *.* FROM ''@'localhost';
-####################################################################################
-7.1 New connection (anonymous2,localhost,'',,information_schema)
-The anonymous user has no more the PROCESS privilege
-Again only the processes of the anonymous user are visible.
-####################################################################################
-SHOW GRANTS FOR ''@'localhost';
-Grants for @localhost
-GRANT USAGE ON *.* TO ''@'localhost'
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-6 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-4 localhost information_schema Sleep TIME NULL
-####################################################################################
-8 Grant SUPER (does not imply PROCESS) privilege to ddicttestuser1
-connection default (user=root)
-####################################################################################
-GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost';
-####################################################################################
-8.1 New connection con103 (ddicttestuser1 with SUPER privilege)
-Only the processes of ddicttestuser1 user are visible.
-####################################################################################
-SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
-Grants for ddicttestuser1@localhost
-GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-SHOW processlist;
-Id User Host db Command Time State Info
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-7 ddicttestuser1 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-7 ddicttestuser1 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-####################################################################################
-9 Revoke SUPER privilege from user ddicttestuser1
-connection default (user=root)
-####################################################################################
-REVOKE SUPER ON *.* FROM 'ddicttestuser1'@'localhost';
-####################################################################################
-9.1 New connection con104 (ddicttestuser1 without SUPER privilege)
-ddicttestuser1 has no more the SUPER privilege.
-Only the processes of ddicttestuser1 are visible.
-####################################################################################
-SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
-Grants for ddicttestuser1@localhost
-GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-SHOW processlist;
-Id User Host db Command Time State Info
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-7 ddicttestuser1 localhost information_schema Sleep TIME NULL
-8 ddicttestuser1 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-8 ddicttestuser1 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-7 ddicttestuser1 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-####################################################################################
-10 Grant SUPER privilege with grant option to user ddicttestuser1.
-connection default (user=root)
-####################################################################################
-GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost' WITH GRANT OPTION;
-####################################################################################
-10.1 New connection con105 (ddicttestuser1 with SUPER privilege and GRANT OPTION)
-Try to grant PROCESS privilege to user ddicttestuser2 without having it.
-####################################################################################
-SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
-Grants for ddicttestuser1@localhost
-GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1' WITH GRANT OPTION
-GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
-ERROR 28000: Access denied for user 'ddicttestuser1'@'localhost' (using password: YES)
-####################################################################################
-10.2 Grant SUPER and PROCESS privilege with grant option to user ddicttestuser1
-connection default (user=root)
-####################################################################################
-GRANT SUPER,PROCESS ON *.* TO 'ddicttestuser1'@'localhost' WITH GRANT OPTION;
-####################################################################################
-10.3 New connection con106 (ddicttestuser1 with SUPER,PROCESS WITH GRANT OPTION)
-Grant PROCESS privilege to user ddicttestuser2
-####################################################################################
-SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
-Grants for ddicttestuser1@localhost
-GRANT PROCESS, SUPER ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1' WITH GRANT OPTION
-GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
-####################################################################################
-10.4 New connection con200 (ddicttestuser2 with PROCESS privilege)
-ddicttestuser2 has now the PROCESS privilege and sees all connections
-####################################################################################
-SHOW GRANTS FOR 'ddicttestuser2'@'localhost';
-Grants for ddicttestuser2@localhost
-GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-SHOW processlist;
-Id User Host db Command Time State Info
-1 root localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-4 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-6 localhost information_schema Sleep TIME NULL
-7 ddicttestuser1 localhost information_schema Sleep TIME NULL
-8 ddicttestuser1 localhost information_schema Sleep TIME NULL
-9 ddicttestuser1 localhost information_schema Sleep TIME NULL
-10 ddicttestuser1 localhost information_schema Sleep TIME NULL
-11 ddicttestuser2 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-11 ddicttestuser2 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-10 ddicttestuser1 localhost information_schema Sleep TIME NULL
-9 ddicttestuser1 localhost information_schema Sleep TIME NULL
-8 ddicttestuser1 localhost information_schema Sleep TIME NULL
-7 ddicttestuser1 localhost information_schema Sleep TIME NULL
-6 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-4 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-1 root localhost information_schema Sleep TIME NULL
-####################################################################################
-11 User ddicttestuser1 revokes PROCESS privilege from user ddicttestuser2
-connection ddicttestuser1;
-####################################################################################
-REVOKE PROCESS ON *.* FROM 'ddicttestuser2'@'localhost';
-####################################################################################
-11.1 New connection con201 (ddicttestuser2)
-ddicttestuser2 has no more the PROCESS privilege and can only see own connects
-####################################################################################
-SHOW GRANTS;
-Grants for ddicttestuser2@localhost
-GRANT USAGE ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-SHOW processlist;
-Id User Host db Command Time State Info
-11 ddicttestuser2 localhost information_schema Sleep TIME NULL
-12 ddicttestuser2 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-12 ddicttestuser2 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-11 ddicttestuser2 localhost information_schema Sleep TIME NULL
-####################################################################################
-11.2 Revoke SUPER,PROCESS,GRANT OPTION privilege from user ddicttestuser1
-connection default (user=root)
-####################################################################################
-REVOKE SUPER,PROCESS,GRANT OPTION ON *.* FROM 'ddicttestuser1'@'localhost';
-####################################################################################
-11.3 New connection con107 (ddicttestuser1)
-ddicttestuser1 has no more the PROCESS privilege and can only see own connects
-He is also unable to GRANT the PROCESS privilege to ddicttestuser2
-####################################################################################
-SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
-Grants for ddicttestuser1@localhost
-GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
-ERROR 28000: Access denied for user 'ddicttestuser1'@'localhost' (using password: YES)
-SHOW processlist;
-Id User Host db Command Time State Info
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-7 ddicttestuser1 localhost information_schema Sleep TIME NULL
-8 ddicttestuser1 localhost information_schema Sleep TIME NULL
-9 ddicttestuser1 localhost information_schema Sleep TIME NULL
-10 ddicttestuser1 localhost information_schema Sleep TIME NULL
-13 ddicttestuser1 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-13 ddicttestuser1 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-10 ddicttestuser1 localhost information_schema Sleep TIME NULL
-9 ddicttestuser1 localhost information_schema Sleep TIME NULL
-8 ddicttestuser1 localhost information_schema Sleep TIME NULL
-7 ddicttestuser1 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-####################################################################################
-12 Revoke the SELECT privilege from user ddicttestuser1
-connection default (user=root)
-####################################################################################
-REVOKE SELECT ON *.* FROM 'ddicttestuser1'@'localhost';
-####################################################################################
-12.1 New connection con108 (ddicttestuser1)
-ddicttestuser1 has neither PROCESS nor SELECT privilege
-Manual says: Each MySQL user has the right to access these tables, but can see
-only the rows ...
-Therefore the missing SELECT privilege does not affect SELECTs on PROCESSLIST.
-####################################################################################
-SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
-Grants for ddicttestuser1@localhost
-GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
'*22DA61451703738F203CDB9DB041ACBA1F4760B1'
-SHOW processlist;
-Id User Host db Command Time State Info
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-7 ddicttestuser1 localhost information_schema Sleep TIME NULL
-8 ddicttestuser1 localhost information_schema Sleep TIME NULL
-9 ddicttestuser1 localhost information_schema Sleep TIME NULL
-10 ddicttestuser1 localhost information_schema Sleep TIME NULL
-13 ddicttestuser1 localhost information_schema Sleep TIME NULL
-14 ddicttestuser1 localhost information_schema Query TIME NULL SHOW processlist
-SELECT * FROM information_schema.processlist;
-ID USER HOST DB COMMAND TIME STATE INFO
-14 ddicttestuser1 localhost information_schema Query TIME executing SELECT * FROM
information_schema.processlist
-13 ddicttestuser1 localhost information_schema Sleep TIME NULL
-10 ddicttestuser1 localhost information_schema Sleep TIME NULL
-9 ddicttestuser1 localhost information_schema Sleep TIME NULL
-8 ddicttestuser1 localhost information_schema Sleep TIME NULL
-7 ddicttestuser1 localhost information_schema Sleep TIME NULL
-5 ddicttestuser1 localhost information_schema Sleep TIME NULL
-3 ddicttestuser1 localhost information_schema Sleep TIME NULL
-2 ddicttestuser1 localhost information_schema Sleep TIME NULL
-####################################################################################
-12.2 Revoke only the SELECT privilege on the information_schema from ddicttestuser1.
-connection default (user=root)
-####################################################################################
-REVOKE SELECT ON information_schema.* FROM 'ddicttestuser3'@'localhost';
-ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
-####################################################################################
-connection default (user=root)
-Cleanup: close connections, DROP USER etc.
-####################################################################################
-DROP USER ddicttestuser1@'localhost';
-DROP USER ddicttestuser2@'localhost';
-REVOKE USAGE ON *.* FROM ''@'localhost';
-DROP USER ''@'localhost';
diff -Nrup a/mysql-test/suite/funcs_1/r/a_processlist_val_no_prot.result
b/mysql-test/suite/funcs_1/r/a_processlist_val_no_prot.result
--- a/mysql-test/suite/funcs_1/r/a_processlist_val_no_prot.result 2008-02-06 11:02:43
+01:00
+++ /dev/null Wed Dec 31 16:00:00 196900
@@ -1,154 +0,0 @@
-DROP USER ddicttestuser1@'localhost';
-ERROR HY000: Operation DROP USER failed for 'ddicttestuser1'@'localhost'
-CREATE USER ddicttestuser1@'localhost';
-GRANT ALL ON *.* TO ddicttestuser1@'localhost';
-REVOKE PROCESS ON *.* FROM ddicttestuser1@'localhost';
-SET PASSWORD FOR ddicttestuser1@'localhost' = PASSWORD('ddictpass');
-DROP TABLE IF EXISTS test.t1;
-CREATE TABLE test.t1 (f1 BIGINT);
-SHOW CREATE TABLE INFORMATION_SCHEMA.PROCESSLIST;
-Table Create Table
-PROCESSLIST CREATE TEMPORARY TABLE `PROCESSLIST` (
- `ID` bigint(4) NOT NULL DEFAULT '0',
- `USER` varchar(16) NOT NULL DEFAULT '',
- `HOST` varchar(64) NOT NULL DEFAULT '',
- `DB` varchar(64) DEFAULT NULL,
- `COMMAND` varchar(16) NOT NULL DEFAULT '',
- `TIME` bigint(7) NOT NULL DEFAULT '0',
- `STATE` varchar(64) DEFAULT NULL,
- `INFO` longtext
-) ENGINE=MyISAM DEFAULT CHARSET=utf8
-SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST;
-COUNT(*)
-1
-USE test;
-SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
-ID USER HOST DB COMMAND TIME STATE INFO
-<ID> root localhost test Query 0 executing SELECT * FROM
INFORMATION_SCHEMA.PROCESSLIST
-SHOW FULL PROCESSLIST;
-Id User Host db Command Time State Info
-<ID> root localhost test Query 0 NULL SHOW FULL PROCESSLIST
-USE information_schema;
-SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
-ID USER HOST DB COMMAND TIME STATE INFO
-<ID> root localhost information_schema Query <TIME> executing SELECT * FROM
INFORMATION_SCHEMA.PROCESSLIST
-SHOW FULL PROCESSLIST;
-Id User Host db Command Time State Info
-<ID> root localhost information_schema Query <TIME> NULL SHOW FULL
PROCESSLIST
-SELECT INFO FROM INFORMATION_SCHEMA.PROCESSLIST;
-INFO
-SELECT INFO FROM INFORMATION_SCHEMA.PROCESSLIST
-SELECT ID INTO @my_proclist_id FROM INFORMATION_SCHEMA.PROCESSLIST;
-
------ establish connection ddicttestuser1 (user = ddicttestuser1) -----
-
------ switch to connection default (user = root) -----
-SELECT @time > 0;
-@time > 0
-1
-# Sleep some time
-SELECT @time < @time2;
-@time < @time2
-1
-SELECT ID = @my_proclist_id + 1 FROM INFORMATION_SCHEMA.PROCESSLIST
-WHERE USER = 'ddicttestuser1';
-ID = @my_proclist_id + 1
-1
-
------ switch to connection ddicttestuser1 (user = ddicttestuser1) -----
-SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
-ID USER HOST DB COMMAND TIME STATE INFO
-<ID> ddicttestuser1 localhost information_schema Query <TIME> executing SELECT
* FROM INFORMATION_SCHEMA.PROCESSLIST
-SHOW FULL PROCESSLIST;
-Id User Host db Command Time State Info
-<ID> ddicttestuser1 localhost information_schema Query <TIME> NULL SHOW FULL
PROCESSLIST
-
------ establish connection con2 (user = ddicttestuser1) ------
-SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
-ID USER HOST DB COMMAND TIME STATE INFO
-<ID> ddicttestuser1 localhost information_schema Query <TIME> executing SELECT
* FROM INFORMATION_SCHEMA.PROCESSLIST
-<ID> ddicttestuser1 localhost information_schema Sleep <TIME> NULL
-SHOW FULL PROCESSLIST;
-Id User Host db Command Time State Info
-<ID> ddicttestuser1 localhost information_schema Sleep <TIME> NULL
-<ID> ddicttestuser1 localhost information_schema Query <TIME> NULL SHOW FULL
PROCESSLIST
-
------ switch to connection default (user = root) -----
------ close connection con2 -----
-
------ switch to connection ddicttestuser1 (user = ddicttestuser1) -----
-
-
-# Send a long enough running statement to the server, but do not
-# wait till the result comes back. We will pull this later.
-SELECT sleep(2.5),'Command time';
-
------ switch to connection default (user = root) -----
-# Sleep some time
-SELECT @time > 0;
-@time > 0
-1
-# Sleep some time
-SELECT @time < @time2;
-@time < @time2
-1
-
------ switch to connection ddicttestuser1 (user = ddicttestuser1) -----
-# Pull("reap") the result set from the statement executed with "send".
-sleep(2.5) Command time
-0 Command time
-
-
-# Send a long (21 KB code and runtime = 2 seconds) statement to the server,
-# but do not wait till the result comes back. We will pull this later.
-SELECT sleep(2),'BEGIN this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of
a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a
very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a
very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a v
ery long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a ve
ry long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a ver
y long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very
long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very
long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very l
ong statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very lo
ng statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very lon
g statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long s
tatement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long st
atement.this is the representative of a very long statement.this is the representative of
a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long sta
tement.this is the representative of a very long statement.this is the representative of
a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long stat
ement.this is the representative of a very long statement.this is the representative of a
very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long state
ment.this is the representative of a very long statement.this is the representative of a
very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statem
ent.this is the representative of a very long statement.this is the representative of a
very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long stateme
nt.this is the representative of a very long statement.this is the representative of a
very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statemen
t.this is the representative of a very long statement.this is the representative of a
very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement
.this is the representative of a very long statement.this is the representative of a very
long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.END' AS
"my_monster_statement";
-
------ switch to connection default (user = root) -----
-# Sleep some time
-SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
-ID USER HOST DB COMMAND TIME STATE INFO
-<ID> ddicttestuser1 localhost information_schema <COMMAND> <TIME> <STATE> SELECT
sleep(2),'BEGIN this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is
the representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is t
he representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is th
e representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the r
epresentative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the re
presentative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the rep
resentative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the repr
esentative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the repre
sentative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the repres
entative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the represe
ntative of a very long statement.this is the representative of a very long statement.this
is the representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the represen
tative of a very long statement.this is the representative of a very long statement.this
is the representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the represent
ative of a very long statement.this is the representative of a very long statement.this
is the representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representa
tive of a very long statement.this is the representative of a very long statement.this is
the representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representat
ive of a very long statement.this is the representative of a very long statement.this is
the representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representati
ve of a very long statement.this is the representative of a very long statement.this is
the representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representativ
e of a very long statement.this is the representative of a very long statement.this is
the representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is the representative of a very long statement.this is the representative
of a very long statement.this is the representative of a very long statement.this is the
representative of a very long statement.this is the representative of a very long
statement.this is th 