~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

INSERT INTO t1 VALUES (3359356,405,3359356,'Mustermann Musterfrau',52500,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprft','','privat',1485525,2122316,'+','','N',1909160,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',3,24,'MobilCom Shop Koeln',52500,NULL,'auto','2001-02-02 10:59:16','Mobilfunk','PP','','','');

INSERT INTO t1 VALUES (3359357,468,3359357,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprft','','privat',1503580,2139699,'+','','P',1909171,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

INSERT INTO t1 VALUES (3359358,407,3359358,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprft','','privat',1501358,2137473,'N','','N',1909159,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

INSERT INTO t1 VALUES (3359359,468,3359359,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprft','','privat',1507831,2143894,'+','','P',1909162,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

INSERT INTO t1 VALUES (3359360,0,0,'Mustermann Musterfrau',29674907,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprft','','privat',1900169997,2414578,'+',NULL,'N',1909148,'',NULL,NULL,'RV99066_2',20,NULL,'POS',29674907,NULL,NULL,20010202105916,'Mobilfunk','','','97317481','007');

INSERT INTO t1 VALUES (3359361,406,3359361,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag storniert','','(7001-84):Storno, Kd. mchte nicht mehr','privat',NULL,0,'+','','P',1909150,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

INSERT INTO t1 VALUES (3359362,406,3359362,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprft','','privat',1509984,2145874,'+','','P',1909154,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie;

Kundentyp kategorie

Privat (Private Nutzung) Mobilfunk

Warnings:

Warning 1052 Column 'kundentyp' in group statement is ambiguous

drop table t1;

CREATE TABLE t1 (

aufnr varchar(12) NOT NULL default '',

plnfl varchar(6) NOT NULL default '',

vornr varchar(4) NOT NULL default '',

xstatus_vor int NOT NULL default '0'

);

INSERT INTO t1 VALUES ('40004712','000001','0010',9);

INSERT INTO t1 VALUES ('40004712','000001','0020',0);

UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr =

"40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr

ASC LIMIT 1;

drop table t1;

drop table if exists t1,t2,t3;

create table t1 (a int, b int, c int);

create table t2 (d int);

create table t3 (a1 int, b1 int, c1 int);

insert into t1 values(1,2,3);

insert into t1 values(11,22,33);

insert into t2 values(99);

select t1.* as 'with_alias' from t1;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t1' at line 1

select t2.* as 'with_alias' from t2;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t2' at line 1

select t1.*, t1.* as 'with_alias' from t1;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t1' at line 1

select t1.* as 'with_alias', t1.* from t1;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', t1.* from t1' at line 1

select t1.* as 'with_alias', t1.* as 'alias2' from t1;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', t1.* as 'alias2' from t1' at line 1

select t1.* as 'with_alias', a, t1.* as 'alias2' from t1;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', a, t1.* as 'alias2' from t1' at line 1

select a, t1.* as 'with_alias' from t1;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t1' at line 1

select t1.* as 'with_alias', a from t1;

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', a from t1' at line 1

select a, t1.* as 'with_alias', b from t1;

100

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', b from t1' at line 1

101

select (select d from t2 where d > a), t1.* as 'with_alias' from t1;

102

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t1' at line 1

103

select t1.* as 'with_alias', (select a from t2 where d > a) from t1;

104

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', (select a from t2 where d > a) from t1' at line 1

105

select a as 'x', t1.* as 'with_alias' from t1;

106

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t1' at line 1

107

select t1.* as 'with_alias', a as 'x' from t1;

108

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', a as 'x' from t1' at line 1

109

select a as 'x', t1.* as 'with_alias', b as 'x' from t1;

110

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', b as 'x' from t1' at line 1

111

select (select d from t2 where d > a) as 'x', t1.* as 'with_alias' from t1;

112

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t1' at line 1

113

select t1.* as 'with_alias', (select a from t2 where d > a) as 'x' from t1;

114

115

select (select t2.* as 'x' from t2) from t1;

116

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'x' from t2) from t1' at line 1

117

select a, (select t2.* as 'x' from t2) from t1;

118

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'x' from t2) from t1' at line 1

119

select t1.*, (select t2.* as 'x' from t2) from t1;

120

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'x' from t2) from t1' at line 1

121

insert into t3 select t1.* as 'with_alias' from t1;

122

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t1' at line 1

123

insert into t3 select t2.* as 'with_alias', 1, 2 from t2;

124

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', 1, 2 from t2' at line 1

125

insert into t3 select t2.* as 'with_alias', d as 'x', d as 'z' from t2;

126

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', d as 'x', d as 'z' from t2' at line 1

127

insert into t3 select t2.*, t2.* as 'with_alias', 3 from t2;

128

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', 3 from t2' at line 1

129

create table t3 select t1.* as 'with_alias' from t1;

130

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias' from t1' at line 1

131

create table t3 select t2.* as 'with_alias', 1, 2 from t2;

132

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', 1, 2 from t2' at line 1

133

create table t3 select t2.* as 'with_alias', d as 'x', d as 'z' from t2;

134

135

create table t3 select t2.*, t2.* as 'with_alias', 3 from t2;

136

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'as 'with_alias', 3 from t2' at line 1

137

select t1.* from t1;

138

a b c

139

1 2 3

140

11 22 33

141

select t2.* from t2;

142

143

144

select t1.*, t1.* from t1;

145

a b c a b c

146

1 2 3 1 2 3

147

11 22 33 11 22 33

148

select t1.*, a, t1.* from t1;

149

a b c a a b c

150

1 2 3 1 1 2 3

151

11 22 33 11 11 22 33

152

select a, t1.* from t1;

153

a a b c

154

1 1 2 3

155

11 11 22 33

156

select t1.*, a from t1;

157

a b c a

158

1 2 3 1

159

11 22 33 11

160

select a, t1.*, b from t1;

161

a a b c b

162

1 1 2 3 2

163

11 11 22 33 22

164

select (select d from t2 where d > a), t1.* from t1;

165

(select d from t2 where d > a) a b c

166

99 1 2 3

167

99 11 22 33

168

select t1.*, (select a from t2 where d > a) from t1;

169

a b c (select a from t2 where d > a)

170

1 2 3 1

171

11 22 33 11

172

select a as 'x', t1.* from t1;

173

x a b c

174

1 1 2 3

175

11 11 22 33

176

select t1.*, a as 'x' from t1;

177

a b c x

178

1 2 3 1

179

11 22 33 11

180

select a as 'x', t1.*, b as 'x' from t1;

181

x a b c x

182

1 1 2 3 2

183

11 11 22 33 22

184

select (select d from t2 where d > a) as 'x', t1.* from t1;

185

x a b c

186

99 1 2 3

187

99 11 22 33

188

select t1.*, (select a from t2 where d > a) as 'x' from t1;

189

a b c x

190

1 2 3 1

191

11 22 33 11

192

select (select t2.* from t2) from t1;

193

(select t2.* from t2)

194

195

196

select a, (select t2.* from t2) from t1;

197

a (select t2.* from t2)

198

1 99

199

11 99

200

select t1.*, (select t2.* from t2) from t1;

201

a b c (select t2.* from t2)

202

1 2 3 99

203

11 22 33 99

204

insert into t3 select t1.* from t1;

205

insert into t3 select t2.*, 1, 2 from t2;

206

insert into t3 select t2.*, d as 'x', d as 'z' from t2;

207

insert into t3 select t2.*, t2.*, 3 from t2;

208

create table t4 select t1.* from t1;

209

drop table t4;

210

create table t4 select t2.*, 1, 2 from t2;

211

drop table t4;

212

create table t4 select t2.*, d as 'x', d as 'z' from t2;

213

drop table t4;

214

drop table t1,t2,t3;

Older »