|
1273.13.45
by Brian Aker
Update for test split. |
1 |
use data_dictionary; |
2 |
show create table PROCESSLIST ; |
|
3 |
Table Create Table |
|
|
1638.10.91
by Stewart Smith
test result fixes for the dictionary suites: table names should be upper case as well as having explicit COLLATE in SHOW CREATE TABLE |
4 |
PROCESSLIST CREATE TABLE `PROCESSLIST` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
5 |
`ID` BIGINT NOT NULL, |
6 |
`USER` VARCHAR(16) NOT NULL, |
|
7 |
`HOST` VARCHAR(1025) NOT NULL, |
|
|
1993.3.2
by Andrew Hutchings
More test case fixes |
8 |
`DB` VARCHAR(256) DEFAULT NULL, |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
9 |
`COMMAND` VARCHAR(16) NOT NULL, |
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
10 |
`TIME` BIGINT UNSIGNED NOT NULL, |
|
1726.3.7
by Andrew Hutchings
Merge trunk into branch |
11 |
`STATE` VARCHAR(256) DEFAULT NULL, |
|
1948.2.7
by Brian Aker
Adding "HAS_GLOBAL_LOCK" to processlist. |
12 |
`INFO` VARCHAR(100) DEFAULT NULL, |
|
2023.2.3
by Brian Aker
Merge in fixes for DD to make use of BOOLEAN as a type. |
13 |
`HAS_GLOBAL_LOCK` BOOLEAN NOT NULL |
|
1638.10.91
by Stewart Smith
test result fixes for the dictionary suites: table names should be upper case as well as having explicit COLLATE in SHOW CREATE TABLE |
14 |
) ENGINE=FunctionEngine COLLATE = utf8_general_ci |
|
1273.13.45
by Brian Aker
Update for test split. |
15 |
SELECT ID FROM processlist; |
16 |
ID
|
|
17 |
#
|
|
18 |
SELECT ID FROM processlist ORDER BY ID; |
|
19 |
ID
|
|
20 |
#
|
|
21 |
SELECT a.ID FROM processlist as a, processlist as b ORDER BY ID; |
|
22 |
ID
|
|
23 |
#
|
|
24 |
SELECT a.ID FROM processlist as a, data_dictionary.processlist as b; |
|
25 |
ID
|
|
26 |
#
|