File: simple_select_user_mysql50.result.etalon

package info (click to toggle)
mysql-gui-tools 5.0r14%2BopenSUSE-2.1
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 116,956 kB
  • ctags: 48,715
  • sloc: sql: 341,918; pascal: 276,698; ansic: 91,020; cpp: 90,451; objc: 33,236; sh: 29,481; yacc: 10,756; xml: 10,589; java: 10,079; php: 2,806; python: 2,092; makefile: 1,783; perl: 4
file content (88 lines) | stat: -rw-r--r-- 3,780 bytes parent folder | download | duplicates (3)
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
79
80
81
82
83
84
85
86
87
88
query : ****************************
  sql : ----------------------------
select 1, User, Host
from mysql.user
where User='root'
group by Host
order by Host;
------------------------------------
!query_is_editable(query,1)
------------------------------------
  query_type : MYX_QT_SELECT
  options(0) : 
  tables(1) : 
    -------------------------------
    table "system"."mysql"."user" ()
     fullname= "mysql.user"
     charset= "latin1"
     columns(33) : 
       column "Host", cs(latin1_bin) is     pk
       column "User", cs(latin1_bin) is     pk
       column "Password", cs(latin1_bin) is not pk
       column "Select_priv", cs(latin1_swedish_ci) is not pk
       column "Insert_priv", cs(latin1_swedish_ci) is not pk
       column "Update_priv", cs(latin1_swedish_ci) is not pk
       column "Delete_priv", cs(latin1_swedish_ci) is not pk
       column "Create_priv", cs(latin1_swedish_ci) is not pk
       column "Drop_priv", cs(latin1_swedish_ci) is not pk
       column "Reload_priv", cs(latin1_swedish_ci) is not pk
       column "Shutdown_priv", cs(latin1_swedish_ci) is not pk
       column "Process_priv", cs(latin1_swedish_ci) is not pk
       column "File_priv", cs(latin1_swedish_ci) is not pk
       column "Grant_priv", cs(latin1_swedish_ci) is not pk
       column "References_priv", cs(latin1_swedish_ci) is not pk
       column "Index_priv", cs(latin1_swedish_ci) is not pk
       column "Alter_priv", cs(latin1_swedish_ci) is not pk
       column "Show_db_priv", cs(latin1_swedish_ci) is not pk
       column "Super_priv", cs(latin1_swedish_ci) is not pk
       column "Create_tmp_table_priv", cs(latin1_swedish_ci) is not pk
       column "Lock_tables_priv", cs(latin1_swedish_ci) is not pk
       column "Execute_priv", cs(latin1_swedish_ci) is not pk
       column "Repl_slave_priv", cs(latin1_swedish_ci) is not pk
       column "Repl_client_priv", cs(latin1_swedish_ci) is not pk
       column "Create_view_priv", cs(latin1_swedish_ci) is not pk
       column "Show_view_priv", cs(latin1_swedish_ci) is not pk
       column "ssl_type", cs(latin1_swedish_ci) is not pk
       column "ssl_cipher", cs((null)) is not pk
       column "x509_issuer", cs((null)) is not pk
       column "x509_subject", cs((null)) is not pk
       column "max_questions", cs((null)) is not pk
       column "max_updates", cs((null)) is not pk
       column "max_connections", cs((null)) is not pk
     pk_columns_num(0) : 
     relationship_type=MYX_QTRT_NONE
       null relation 
    -------------------------------
  pk_columns_added_num 0
  columns(3)
     column "<<nil>>"."<<nil>>"."<<nil>>" ."1" (alias: 1, is_pk: 0)
     column "<<nil>>"."<<nil>>"."<<nil>>" ."User" (alias: User, is_pk: 0)
     column "<<nil>>"."<<nil>>"."<<nil>>" ."Host" (alias: Host, is_pk: 0)
  clauses(5)
    clause (7,22) ends with linebreak
      clause_type MYX_QCT_SELECT_CLAUSE
      clause : -------------------------
1, User, Host
      ------------------------------------
    clause (27,39) ends with linebreak
      clause_type MYX_QCT_FROM_CLAUSE
      clause : -------------------------
mysql.user
      ------------------------------------
    clause (45,58) ends with linebreak
      clause_type MYX_QCT_WHERE_CLAUSE
      clause : -------------------------
User='root'
      ------------------------------------
    clause (67,73) ends with linebreak
      clause_type MYX_QCT_GROUP_CLAUSE
      clause : -------------------------
Host
      ------------------------------------
    clause (82,87) doesn't end with linebreak
      clause_type MYX_QCT_ORDER_CLAUSE
      clause : -------------------------
Host;
      ------------------------------------
  subqueries(0)
  params_num 0