File: quote_no_mysql41_ansi.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 (97 lines) | stat: -rw-r--r-- 3,644 bytes parent folder | download | duplicates (6)
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
89
90
91
92
93
94
95
96
97
query : ****************************
  sql : ----------------------------
UPDATE mysql.db SET db.name='new'
------------------------------------
  query_type : MYX_QT_UPDATE
  options(0) : 
  tables(1) : 
    -------------------------------
    table "system"."mysql"."db" ()
     fullname= "mysql.db"
     charset= "utf8"
     columns(15) : 
       column "Host", cs(utf8_bin) is     pk
       column "Db", cs(utf8_bin) is     pk
       column "User", cs(utf8_bin) is     pk
       column "Select_priv", cs(utf8_bin) is not pk
       column "Insert_priv", cs(utf8_bin) is not pk
       column "Update_priv", cs(utf8_bin) is not pk
       column "Delete_priv", cs(utf8_bin) is not pk
       column "Create_priv", cs(utf8_bin) is not pk
       column "Drop_priv", cs(utf8_bin) is not pk
       column "Grant_priv", cs(utf8_bin) is not pk
       column "References_priv", cs(utf8_bin) is not pk
       column "Index_priv", cs(utf8_bin) is not pk
       column "Alter_priv", cs(utf8_bin) is not pk
       column "Create_tmp_table_priv", cs(utf8_bin) is not pk
       column "Lock_tables_priv", cs(utf8_bin) is not pk
     pk_columns_num(0) : 
     relationship_type=MYX_QTRT_NONE
       null relation 
    -------------------------------
  pk_columns_added_num 0
  columns(0)
  clauses(2)
    clause (7,16) doesn't end with linebreak
      clause_type MYX_QCT_UPDATE_CLAUSE
      clause : -------------------------
mysql.db
      ------------------------------------
    clause (20,33) doesn't end with linebreak
      clause_type MYX_QCT_SET_CLAUSE
      clause : -------------------------
db.name='new'
      ------------------------------------
  subqueries(0)
  params_num 0
query : ****************************
  sql : ----------------------------
UPDATE mysql.db SET db.name='a' WHERE db.host='b'
------------------------------------
  query_type : MYX_QT_UPDATE
  options(0) : 
  tables(1) : 
    -------------------------------
    table "system"."mysql"."db" ()
     fullname= "mysql.db"
     charset= "utf8"
     columns(15) : 
       column "Host", cs(utf8_bin) is     pk
       column "Db", cs(utf8_bin) is     pk
       column "User", cs(utf8_bin) is     pk
       column "Select_priv", cs(utf8_bin) is not pk
       column "Insert_priv", cs(utf8_bin) is not pk
       column "Update_priv", cs(utf8_bin) is not pk
       column "Delete_priv", cs(utf8_bin) is not pk
       column "Create_priv", cs(utf8_bin) is not pk
       column "Drop_priv", cs(utf8_bin) is not pk
       column "Grant_priv", cs(utf8_bin) is not pk
       column "References_priv", cs(utf8_bin) is not pk
       column "Index_priv", cs(utf8_bin) is not pk
       column "Alter_priv", cs(utf8_bin) is not pk
       column "Create_tmp_table_priv", cs(utf8_bin) is not pk
       column "Lock_tables_priv", cs(utf8_bin) is not pk
     pk_columns_num(0) : 
     relationship_type=MYX_QTRT_NONE
       null relation 
    -------------------------------
  pk_columns_added_num 0
  columns(0)
  clauses(3)
    clause (7,16) doesn't end with linebreak
      clause_type MYX_QCT_UPDATE_CLAUSE
      clause : -------------------------
mysql.db
      ------------------------------------
    clause (20,32) doesn't end with linebreak
      clause_type MYX_QCT_SET_CLAUSE
      clause : -------------------------
db.name='a'
      ------------------------------------
    clause (38,49) doesn't end with linebreak
      clause_type MYX_QCT_WHERE_CLAUSE
      clause : -------------------------
db.host='b'
      ------------------------------------
  subqueries(0)
  params_num 0