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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
query : ****************************
sql : ----------------------------
select /* test comment */ *
from /* xx */t1/* yy */, /* cc */t2/* dd */ -- test comment returns
where a=10 # test comment forever
------------------------------------
!query_is_editable(query,1)
------------------------------------
query_type : MYX_QT_SELECT
options(0) :
tables(2) :
-------------------------------
table "def"."test"."t1" ()
fullname= "t1"
charset= "latin1"
columns(1) :
column "t1_id", cs((null)) is pk
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
-------------------------------
table "def"."test"."t2" ()
fullname= "t2"
charset= "latin1"
columns(2) :
column "t2_id", cs((null)) is pk
column "t1_id", cs((null)) is not pk
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(3)
column "def"."test"."t1" ."t1_id" (alias: t1_id, is_pk: 1)
column "def"."test"."t2" ."t2_id" (alias: t2_id, is_pk: 1)
column "def"."test"."t2" ."t1_id" (alias: t1_id, is_pk: 0)
clauses(3)
clause (7,30) ends with linebreak
clause_type MYX_QCT_SELECT_CLAUSE
clause : -------------------------
*
------------------------------------
clause (35,99) ends with linebreak
clause_type MYX_QCT_FROM_CLAUSE
clause : -------------------------
t1 , t2
------------------------------------
clause (105,133) doesn't end with linebreak
clause_type MYX_QCT_WHERE_CLAUSE
clause : -------------------------
a=10
------------------------------------
subqueries(0)
params_num 0
query : ****************************
sql : ----------------------------
select /* test comment */ *
from t1 -- test comment returns
where a=10 # test comment forever
------------------------------------
query_is_editable(query,1)
------------------------------------
query_type : MYX_QT_SELECT
options(0) :
tables(1) :
-------------------------------
table "def"."test"."t1" ()
fullname= "t1"
charset= "latin1"
columns(1) :
column "t1_id", cs((null)) is pk
pk_columns_num(1) :
|t1_id|
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(1)
column "def"."test"."t1" ."t1_id" (alias: t1_id, is_pk: 1)
clauses(3)
clause (7,30) ends with linebreak
clause_type MYX_QCT_SELECT_CLAUSE
clause : -------------------------
*
------------------------------------
clause (35,63) ends with linebreak
clause_type MYX_QCT_FROM_CLAUSE
clause : -------------------------
t1
------------------------------------
clause (69,97) doesn't end with linebreak
clause_type MYX_QCT_WHERE_CLAUSE
clause : -------------------------
a=10
------------------------------------
subqueries(0)
params_num 0
query : ****************************
sql : ----------------------------
# Connection: dba on faster
# Host: faster
# Saved: 2004-09-16 22:02:16
#
select 1
------------------------------------
!query_is_editable(query,1)
------------------------------------
query_type : MYX_QT_SELECT
options(0) :
tables(0) :
pk_columns_added_num 0
columns(1)
column "<<nil>>"."<<nil>>"."<<nil>>" ."" (alias: , is_pk: 0)
clauses(1)
clause (85,86) doesn't end with linebreak
clause_type MYX_QCT_SELECT_CLAUSE
clause : -------------------------
1
------------------------------------
subqueries(0)
params_num 0
|
