-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathfilter_plugin.result
More file actions
78 lines (78 loc) · 5.73 KB
/
filter_plugin.result
File metadata and controls
78 lines (78 loc) · 5.73 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
install plugin filter_plugin soname 'filter_plugin.so';
create table user (host char(60) COLLATE utf8_bin NOT NULL DEFAULT '', user char(32) COLLATE utf8_bin NOT NULL DEFAULT '') DEFAULT CHARSET=utf8 COLLATE=utf8_bin ;
insert into user (user, host) values('root', '127.0.0.1'), ('root', '::1'), ('mysql.sys', 'localhost'), ('root', 'localhost'), ('root', 'thinkie');
SELECT 1;
1
1
SELECT COUNT(user) FROM user;
COUNT(user)
5
SELECT COUNT(user) FILTER(WHERE host='127.0.0.1') FROM user;
COUNT(CASE WHEN host='127.0.0.1' THEN user ELSE NULL END)
1
Warnings:
Note 1105 Query 'SELECT COUNT(user) FILTER(WHERE host='127.0.0.1') FROM user' rewritten to 'SELECT COUNT(CASE WHEN host='127.0.0.1' THEN user ELSE NULL END) FROM user' by a query rewrite plugin
Warning 1292 Truncated incorrect INTEGER value: 'root '
SELECT COUNT(*) FILTER(WHERE host='127.0.0.1') FROM user;
COUNT(CASE WHEN host='127.0.0.1' THEN 1 ELSE NULL END)
1
Warnings:
Note 1105 Query 'SELECT COUNT(*) FILTER(WHERE host='127.0.0.1') FROM user' rewritten to 'SELECT COUNT(CASE WHEN host='127.0.0.1' THEN 1 ELSE NULL END) FROM user' by a query rewrite plugin
SELECT COUNT(user) FILTER(WHERE host='127.0.0.1'), COUNT(*) FILTER(WHERE host like '%host') FROM user;
COUNT(CASE WHEN host='127.0.0.1' THEN user ELSE NULL END) COUNT(CASE WHEN host like '%host' THEN 1 ELSE NULL END)
1 2
Warnings:
Note 1105 Query 'SELECT COUNT(user) FILTER(WHERE host='127.0.0.1'), COUNT(*) FILTER(WHERE host like '%host') FROM user' rewritten to 'SELECT COUNT(CASE WHEN host='127.0.0.1' THEN user ELSE NULL END), COUNT(CASE WHEN host like '%host' THEN 1 ELSE NULL END) FROM user' by a query rewrite plugin
Warning 1292 Truncated incorrect INTEGER value: 'root '
SELECT COUNT(DISTINCT user) FILTER(WHERE host not like '%host') FROM user;
COUNT(DISTINCT CASE WHEN host not like '%host' THEN user ELSE NULL END)
1
Warnings:
Note 1105 Query 'SELECT COUNT(DISTINCT user) FILTER(WHERE host not like '%host') FROM user' rewritten to 'SELECT COUNT(DISTINCT CASE WHEN host not like '%host' THEN user ELSE NULL END) FROM user' by a query rewrite plugin
SELECT COUNT(ALL user) FILTER(WHERE host not like '%host') FROM user;
COUNT(ALL CASE WHEN host not like '%host' THEN user ELSE NULL END)
3
Warnings:
Note 1105 Query 'SELECT COUNT(ALL user) FILTER(WHERE host not like '%host') FROM user' rewritten to 'SELECT COUNT(ALL CASE WHEN host not like '%host' THEN user ELSE NULL END) FROM user' by a query rewrite plugin
Warning 1292 Truncated incorrect INTEGER value: 'root '
Warning 1292 Truncated incorrect INTEGER value: 'root '
Warning 1292 Truncated incorrect INTEGER value: 'root '
select 1;
1
1
select count(user) from user;
count(user)
5
select count(user) filter(where host='127.0.0.1') from user;
count(CASE WHEN host='127.0.0.1' THEN user ELSE NULL END)
1
Warnings:
Note 1105 Query 'select count(user) filter(where host='127.0.0.1') from user' rewritten to 'select count(CASE WHEN host='127.0.0.1' THEN user ELSE NULL END) from user' by a query rewrite plugin
Warning 1292 Truncated incorrect INTEGER value: 'root '
select count(*) filter(where host='127.0.0.1') from user;
count(CASE WHEN host='127.0.0.1' THEN 1 ELSE NULL END)
1
Warnings:
Note 1105 Query 'select count(*) filter(where host='127.0.0.1') from user' rewritten to 'select count(CASE WHEN host='127.0.0.1' THEN 1 ELSE NULL END) from user' by a query rewrite plugin
select count(user) filter(where host='127.0.0.1'), count(*) filter(where host like '%host') from user;
count(CASE WHEN host='127.0.0.1' THEN user ELSE NULL END) count(CASE WHEN host like '%host' THEN 1 ELSE NULL END)
1 2
Warnings:
Note 1105 Query 'select count(user) filter(where host='127.0.0.1'), count(*) filter(where host like '%host') from user' rewritten to 'select count(CASE WHEN host='127.0.0.1' THEN user ELSE NULL END), count(CASE WHEN host like '%host' THEN 1 ELSE NULL END) from user' by a query rewrite plugin
Warning 1292 Truncated incorrect INTEGER value: 'root '
select count(distinct user) filter(where host not like '%host') from user;
count(DISTINCT CASE WHEN host not like '%host' THEN user ELSE NULL END)
1
Warnings:
Note 1105 Query 'select count(distinct user) filter(where host not like '%host') from user' rewritten to 'select count(DISTINCT CASE WHEN host not like '%host' THEN user ELSE NULL END) from user' by a query rewrite plugin
select count(all user) filter(where host not like '%host') from user;
count(ALL CASE WHEN host not like '%host' THEN user ELSE NULL END)
3
Warnings:
Note 1105 Query 'select count(all user) filter(where host not like '%host') from user' rewritten to 'select count(ALL CASE WHEN host not like '%host' THEN user ELSE NULL END) from user' by a query rewrite plugin
Warning 1292 Truncated incorrect INTEGER value: 'root '
Warning 1292 Truncated incorrect INTEGER value: 'root '
Warning 1292 Truncated incorrect INTEGER value: 'root '
uninstall plugin filter_plugin;
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown