~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

insert into t2 values ("0.0","0.0","0.0",7),("-0.0","-0.0","-0.0",8),("+0.0","+0.0","+0.0",9),("01.0","01.0","01.0",10),("+01.0","+01.0","+01.0",11),("-01.0","-01.0","-01.0",12);

Warnings:

Warning 1264 Out of range value for column 'c2' at row 2

Warning 1264 Out of range value for column 'c2' at row 6

insert into t2 values ("-.1","-.1","-.1",13),("+.1","+.1","+.1",14),(".1",".1",".1",15);

Warnings:

Note 1265 Data truncated for column 'c1' at row 1

Warning 1264 Out of range value for column 'c2' at row 1

Note 1265 Data truncated for column 'c3' at row 1

Note 1265 Data truncated for column 'c1' at row 2

Note 1265 Data truncated for column 'c2' at row 2

Note 1265 Data truncated for column 'c3' at row 2

Note 1265 Data truncated for column 'c1' at row 3

Note 1265 Data truncated for column 'c2' at row 3

Note 1265 Data truncated for column 'c3' at row 3

insert into t2 values ("00000000000001","00000000000001","00000000000001",16),("+0000000000001","+0000000000001","+0000000000001",17),("-0000000000001","-0000000000001","-0000000000001",18);

Warnings:

Warning 1264 Out of range value for column 'c2' at row 3

insert into t2 values ("+111111111.11","+111111111.11","+111111111.11",19),("111111111.11","111111111.11","111111111.11",20),("-11111111.11","-11111111.11","-11111111.11",21);

Warnings:

Note 1265 Data truncated for column 'c1' at row 1

Note 1265 Data truncated for column 'c2' at row 1

Note 1265 Data truncated for column 'c3' at row 1

Note 1265 Data truncated for column 'c1' at row 2

Note 1265 Data truncated for column 'c2' at row 2

Note 1265 Data truncated for column 'c3' at row 2

Note 1265 Data truncated for column 'c1' at row 3

Warning 1264 Out of range value for column 'c2' at row 3

Note 1265 Data truncated for column 'c3' at row 3

insert into t2 values ("-111111111.11","-111111111.11","-111111111.11",22),("+1111111111.11","+1111111111.11","+1111111111.11",23),("1111111111.11","1111111111.11","1111111111.11",24);

Warnings:

Note 1265 Data truncated for column 'c1' at row 1

Warning 1264 Out of range value for column 'c2' at row 1

Note 1265 Data truncated for column 'c3' at row 1

Note 1265 Data truncated for column 'c1' at row 2

Note 1265 Data truncated for column 'c2' at row 2

Note 1265 Data truncated for column 'c3' at row 2

Note 1265 Data truncated for column 'c1' at row 3

Note 1265 Data truncated for column 'c2' at row 3

Note 1265 Data truncated for column 'c3' at row 3

insert into t2 values ("1e+1000","1e+1000","1e+1000",25),("1e-1000","1e-1000","1e-1000",26),("-1e+1000","-1e+1000","-1e+1000",27);

Warnings:

Warning 1264 Out of range value for column 'c1' at row 1

Warning 1264 Out of range value for column 'c2' at row 1

Warning 1264 Out of range value for column 'c3' at row 1

Note 1265 Data truncated for column 'c1' at row 2

Note 1265 Data truncated for column 'c2' at row 2

Note 1265 Data truncated for column 'c3' at row 2

Warning 1264 Out of range value for column 'c1' at row 3

Warning 1264 Out of range value for column 'c2' at row 3

Warning 1264 Out of range value for column 'c3' at row 3

100

insert into t2 values ("1e+4294967296","1e+4294967296","1e+4294967296",28),("1e-4294967296","1e-4294967296","1e-4294967296",29);

101

Warnings:

102

Warning 1264 Out of range value for column 'c1' at row 1

103

Warning 1264 Out of range value for column 'c2' at row 1

104

Warning 1264 Out of range value for column 'c3' at row 1

105

Note 1265 Data truncated for column 'c1' at row 2

106

Note 1265 Data truncated for column 'c2' at row 2

107

Note 1265 Data truncated for column 'c3' at row 2

108

insert into t2 values ("1e+18446744073709551615","1e+18446744073709551615","1e+18446744073709551615",30),("1e+18446744073709551616","1e+18446744073709551616","1e+18446744073709551616",31),("1e-9223372036854775807","1e-9223372036854775807","1e-9223372036854775807",32),("1e-9223372036854775809","1e-9223372036854775809","1e-9223372036854775809",33);

109

Warnings:

110

Warning 1264 Out of range value for column 'c1' at row 1

111

Warning 1264 Out of range value for column 'c2' at row 1

112

Warning 1264 Out of range value for column 'c3' at row 1

113

Warning 1366 Incorrect decimal value: '1e+18446744073709551616' for column 'c1' at row 2

114

Warning 1366 Incorrect decimal value: '1e+18446744073709551616' for column 'c2' at row 2

115

Warning 1366 Incorrect decimal value: '1e+18446744073709551616' for column 'c3' at row 2

116

Note 1265 Data truncated for column 'c1' at row 3

117

Note 1265 Data truncated for column 'c2' at row 3

118

Note 1265 Data truncated for column 'c3' at row 3

119

Warning 1366 Incorrect decimal value: '1e-9223372036854775809' for column 'c1' at row 4

120

Warning 1366 Incorrect decimal value: '1e-9223372036854775809' for column 'c2' at row 4

121

Warning 1366 Incorrect decimal value: '1e-9223372036854775809' for column 'c3' at row 4

122

SELECT * FROM t1;

123

c1 c2 c3 c4

124

0.00000 -0.10000 0 13

125

0.00000 0.00000 0 7

126

1.00000 1.00000 1 10

127

100.05000 -100.05000 100 1

128

12345.00001 NULL NULL NULL

129

99999.99999 -99999.99999 100000 5

130

99999.99999 99999.99999 111111111 19

131

SELECT * FROM t2;

132

c1 c2 c3 c4

133

-1 0 -1 12

134

-1 0 -1 18

135

-1000000000 1000000000 1000000000 2

136

-11111111 0 -11111111 21

137

-111111111 0 -111111111 22

138

-9999999999 0 -9999999999 27

139

-9999999999 0 9999999999 4

140

0 0 0 13

141

0 0 0 14

142

0 0 0 15

143

0 0 0 26

144

0 0 0 29

145

0 0 0 31

146

0 0 0 32

147

0 0 0 33

148

0 0 0 7

149

0 0 0 8

150

0 0 0 9

151

1 1 1 10

152

1 1 1 11

153

1 1 1 16

154

1 1 1 17

155

111111111 111111111 111111111 19

156

111111111 111111111 111111111 20

157

1111111111 1111111111 1111111111 23

158

1111111111 1111111111 1111111111 24

159

9999999999 0 9999999999 6

160

9999999999 9999999999 9999999999 25

161

9999999999 9999999999 9999999999 28

162

9999999999 9999999999 9999999999 30

163

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t1;

164

total_rows min_value max_value sum avg

165

7 0.00000 99999.99999 212446.04999 30349.435712857

166

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t1;

167

total_rows min_value max_value sum avg

168

7 -99999.99999 99999.99999 -99.15000 -16.525000000

169

SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t1;

170

total_rows min_value max_value sum avg

171

7 0 111111111 111211212 18535202.0000

172

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t2;

173

total_rows min_value max_value sum avg

174

30 -9999999999 9999999999 21322222222 710740740.7333

175

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t2;

176

total_rows min_value max_value sum avg

177

30 0 9999999999 33444444445 1114814814.8333

178

SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t2;

179

total_rows min_value max_value sum avg

180

30 -9999999999 9999999999 43322222220 1444074074.0000

181

SELECT * FROM t1;

182

c1 c2 c3 c4

183

0.00000 -0.10000 0 13

184

0.00000 0.00000 0 7

185

1.00000 1.00000 1 10

186

100.05000 -100.05000 100 1

187

12345.00001 NULL NULL NULL

188

99999.99999 -99999.99999 100000 5

189

99999.99999 99999.99999 111111111 19

190

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;

191

total_rows min_value max(c1)

192

7 0.00000 99999.99999

193

SELECT * FROM t1 WHERE c3 = '0.0';

194

c1 c2 c3 c4

195

0.00000 -0.10000 0 13

196

0.00000 0.00000 0 7

197

SELECT c1,c2 FROM t1;

198

c1 c2

199

0.00000 -0.10000

200

0.00000 0.00000

201

1.00000 1.00000

202

100.05000 -100.05000

203

12345.00001 NULL

204

99999.99999 -99999.99999

205

99999.99999 99999.99999

206

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

207

c1 c2

208

0.00000 0.00000

209

0.00000 -0.10000

210

1.00000 1.00000

211

100.05000 -100.05000

212

12345.00001 NULL

213

99999.99999 99999.99999

214

99999.99999 -99999.99999

215

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

216

c1 c2 c3 c4

217

0.00000 -0.10000 0 13

218

0.00000 0.00000 0 7

219

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

220

c1 c2 c3 c4

221

0.00000 0.00000 0 7

222

0.00000 -0.10000 0 13

223

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2;

224

c1 c2 c3 c4

225

0.00000 -0.10000 0 13

226

0.00000 0.00000 0 7

227

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 LIMIT 2;

228

c1 c2 c3 c4

229

0.00000 -0.10000 0 13

230

0.00000 0.00000 0 7

231

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC;

232

c1 c2 c3 c4

233

0.00000 0.00000 0 7

234

0.00000 -0.10000 0 13

235

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC LIMIT 2;

236

c1 c2 c3 c4

237

0.00000 0.00000 0 7

238

0.00000 -0.10000 0 13

239

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2;

240

c1 c2 c3 c4

241

1.00000 1.00000 1 10

242

100.05000 -100.05000 100 1

243

12345.00001 NULL NULL NULL

244

99999.99999 -99999.99999 100000 5

245

99999.99999 99999.99999 111111111 19

246

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 LIMIT 2;

247

c1 c2 c3 c4

248

1.00000 1.00000 1 10

249

100.05000 -100.05000 100 1

250

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2;

251

c1 c2 c3 c4

252

1.00000 1.00000 1 10

253

100.05000 -100.05000 100 1

254

12345.00001 NULL NULL NULL

255

99999.99999 -99999.99999 100000 5

256

99999.99999 99999.99999 111111111 19

257

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 LIMIT 2;

258

c1 c2 c3 c4

259

1.00000 1.00000 1 10

260

100.05000 -100.05000 100 1

261

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2;

262

c1 c2 c3 c4

263

0.00000 -0.10000 0 13

264

0.00000 0.00000 0 7

265

1.00000 1.00000 1 10

266

100.05000 -100.05000 100 1

267

12345.00001 NULL NULL NULL

268

99999.99999 -99999.99999 100000 5

269

99999.99999 99999.99999 111111111 19

270

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 LIMIT 2;

271

c1 c2 c3 c4

272

0.00000 -0.10000 0 13

273

0.00000 0.00000 0 7

274

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2;

275

c1 c2 c3 c4

276

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 LIMIT 2;

277

c1 c2 c3 c4

278

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2;

279

c1 c2 c3 c4

280

0.00000 -0.10000 0 13

281

0.00000 0.00000 0 7

282

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 LIMIT 2;

283

c1 c2 c3 c4

284

0.00000 -0.10000 0 13

285

0.00000 0.00000 0 7

286

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2;

287

c1 c2 c3 c4

288

0.00000 -0.10000 0 13

289

0.00000 0.00000 0 7

290

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 LIMIT 2;

291

c1 c2 c3 c4

292

0.00000 -0.10000 0 13

293

0.00000 0.00000 0 7

294

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2;

295

c1 c2 c3 c4

296

0.00000 -0.10000 0 13

297

0.00000 0.00000 0 7

298

1.00000 1.00000 1 10

299

100.05000 -100.05000 100 1

300

12345.00001 NULL NULL NULL

301

99999.99999 -99999.99999 100000 5

302

99999.99999 99999.99999 111111111 19

303

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;

304

c1 c2 c3 c4

305

0.00000 -0.10000 0 13

306

0.00000 0.00000 0 7

307

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2;

308

c1 c2 c3 c4

309

0.00000 -0.10000 0 13

310

0.00000 0.00000 0 7

311

99999.99999 -99999.99999 100000 5

312

99999.99999 99999.99999 111111111 19

313

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 LIMIT 2;

314

c1 c2 c3 c4

315

0.00000 -0.10000 0 13

316

0.00000 0.00000 0 7

317

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2;

318

c1 c2 c3 c4

319

1.00000 1.00000 1 10

320

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 LIMIT 2;

321

c1 c2 c3 c4

322

1.00000 1.00000 1 10

323

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;

324

c1 c2 c3 c4

325

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;

326

c1 c2 c3 c4

327

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;

328

c1 c2 c3 c4

329

0.00000 -0.10000 0 13

330

0.00000 0.00000 0 7

331

1.00000 1.00000 1 10

332

100.05000 -100.05000 100 1

333

12345.00001 NULL NULL NULL

334

99999.99999 -99999.99999 100000 5

335

99999.99999 99999.99999 111111111 19

336

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

337

c1 c2 c3 c4

338

0.00000 -0.10000 0 13

339

0.00000 0.00000 0 7

340

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC;

341

c1 c2 c3 c4

342

1.00000 1.00000 1 10

343

100.05000 -100.05000 100 1

344

12345.00001 NULL NULL NULL

345

99999.99999 99999.99999 111111111 19

346

99999.99999 -99999.99999 100000 5

347

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC LIMIT 2;

348

c1 c2 c3 c4

349

1.00000 1.00000 1 10

350

100.05000 -100.05000 100 1

351

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC;

352

c1 c2 c3 c4

353

1.00000 1.00000 1 10

354

100.05000 -100.05000 100 1

355

12345.00001 NULL NULL NULL

356

99999.99999 99999.99999 111111111 19

357

99999.99999 -99999.99999 100000 5

358

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC LIMIT 2;

359

c1 c2 c3 c4

360

1.00000 1.00000 1 10

361

100.05000 -100.05000 100 1

362

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC;

363

c1 c2 c3 c4

364

0.00000 0.00000 0 7

365

0.00000 -0.10000 0 13

366

1.00000 1.00000 1 10

367

100.05000 -100.05000 100 1

368

12345.00001 NULL NULL NULL

369

99999.99999 99999.99999 111111111 19

370

99999.99999 -99999.99999 100000 5

371

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC LIMIT 2;

372

c1 c2 c3 c4

373

0.00000 0.00000 0 7

374

0.00000 -0.10000 0 13

375

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC;

376

c1 c2 c3 c4

377

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC LIMIT 2;

378

c1 c2 c3 c4

379

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC;

380

c1 c2 c3 c4

381

0.00000 0.00000 0 7

382

0.00000 -0.10000 0 13

383

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC LIMIT 2;

384

c1 c2 c3 c4

385

0.00000 0.00000 0 7

386

0.00000 -0.10000 0 13

387

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC;

388

c1 c2 c3 c4

389

0.00000 0.00000 0 7

390

0.00000 -0.10000 0 13

391

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC LIMIT 2;

392

c1 c2 c3 c4

393

0.00000 0.00000 0 7

394

0.00000 -0.10000 0 13

395

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC;

396

c1 c2 c3 c4

397

0.00000 0.00000 0 7

398

0.00000 -0.10000 0 13

399

1.00000 1.00000 1 10

400

100.05000 -100.05000 100 1

401

12345.00001 NULL NULL NULL

402

99999.99999 99999.99999 111111111 19

403

99999.99999 -99999.99999 100000 5

404

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

405

c1 c2 c3 c4

406

0.00000 0.00000 0 7

407

0.00000 -0.10000 0 13

408

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC;

409

c1 c2 c3 c4

410

0.00000 0.00000 0 7

411

0.00000 -0.10000 0 13

412

99999.99999 99999.99999 111111111 19

413

99999.99999 -99999.99999 100000 5

414

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;

415

c1 c2 c3 c4

416

0.00000 0.00000 0 7

417

0.00000 -0.10000 0 13

418

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC;

419

c1 c2 c3 c4

420

1.00000 1.00000 1 10

421

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC LIMIT 2;

422

c1 c2 c3 c4

423

1.00000 1.00000 1 10

424

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;

425

c1 c2 c3 c4

426

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

427

c1 c2 c3 c4

428

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;

429

c1 c2 c3 c4

430

0.00000 0.00000 0 7

431

0.00000 -0.10000 0 13

432

1.00000 1.00000 1 10

433

100.05000 -100.05000 100 1

434

12345.00001 NULL NULL NULL

435

99999.99999 99999.99999 111111111 19

436

99999.99999 -99999.99999 100000 5

437

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

438

c1 c2 c3 c4

439

0.00000 0.00000 0 7

440

0.00000 -0.10000 0 13

441

SELECT * FROM t1;

442

c1 c2 c3 c4

443

0.00000 -0.10000 0 13

444

0.00000 0.00000 0 7

445

1.00000 1.00000 1 10

446

100.05000 -100.05000 100 1

447

12345.00001 NULL NULL NULL

448

99999.99999 -99999.99999 100000 5

449

99999.99999 99999.99999 111111111 19

450

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;

451

total_rows min_value max(c1)

452

7 0.00000 99999.99999

453

SELECT * FROM t1 WHERE c3 = '-0.0';

454

c1 c2 c3 c4

455

0.00000 -0.10000 0 13

456

0.00000 0.00000 0 7

457

SELECT c1,c2 FROM t1;

458

c1 c2

459

0.00000 -0.10000

460

0.00000 0.00000

461

1.00000 1.00000

462

100.05000 -100.05000

463

12345.00001 NULL

464

99999.99999 -99999.99999

465

99999.99999 99999.99999

466

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

467

c1 c2

468

0.00000 0.00000

469

0.00000 -0.10000

470

1.00000 1.00000

471

100.05000 -100.05000

472

12345.00001 NULL

473

99999.99999 99999.99999

474

99999.99999 -99999.99999

475

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

476

c1 c2 c3 c4

477

0.00000 -0.10000 0 13

478

0.00000 0.00000 0 7

479

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

480

c1 c2 c3 c4

481

0.00000 0.00000 0 7

482

0.00000 -0.10000 0 13

483

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2;

484

c1 c2 c3 c4

485

99999.99999 -99999.99999 100000 5

486

99999.99999 99999.99999 111111111 19

487

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

488

c1 c2 c3 c4

489

99999.99999 -99999.99999 100000 5

490

99999.99999 99999.99999 111111111 19

491

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC;

492

c1 c2 c3 c4

493

99999.99999 99999.99999 111111111 19

494

99999.99999 -99999.99999 100000 5

495

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

496

c1 c2 c3 c4

497

99999.99999 99999.99999 111111111 19

498

99999.99999 -99999.99999 100000 5

499

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2;

500

c1 c2 c3 c4

501

0.00000 -0.10000 0 13

502

0.00000 0.00000 0 7

503

1.00000 1.00000 1 10

504

100.05000 -100.05000 100 1

505

12345.00001 NULL NULL NULL

506

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 LIMIT 2;

507

c1 c2 c3 c4

508

0.00000 -0.10000 0 13

509

0.00000 0.00000 0 7

510

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2;

511

c1 c2 c3 c4

512

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 LIMIT 2;

513

c1 c2 c3 c4

514

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2;

515

c1 c2 c3 c4

516

99999.99999 -99999.99999 100000 5

517

99999.99999 99999.99999 111111111 19

518

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 LIMIT 2;

519

c1 c2 c3 c4

520

99999.99999 -99999.99999 100000 5

521

99999.99999 99999.99999 111111111 19

522

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2;

523

c1 c2 c3 c4

524

0.00000 -0.10000 0 13

525

0.00000 0.00000 0 7

526

1.00000 1.00000 1 10

527

100.05000 -100.05000 100 1

528

12345.00001 NULL NULL NULL

529

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 LIMIT 2;

530

c1 c2 c3 c4

531

0.00000 -0.10000 0 13

532

0.00000 0.00000 0 7

533

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2;

534

c1 c2 c3 c4

535

0.00000 -0.10000 0 13

536

0.00000 0.00000 0 7

537

1.00000 1.00000 1 10

538

100.05000 -100.05000 100 1

539

12345.00001 NULL NULL NULL

540

99999.99999 -99999.99999 100000 5

541

99999.99999 99999.99999 111111111 19

542

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 LIMIT 2;

543

c1 c2 c3 c4

544

0.00000 -0.10000 0 13

545

0.00000 0.00000 0 7

546

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2;

547

c1 c2 c3 c4

548

99999.99999 -99999.99999 100000 5

549

99999.99999 99999.99999 111111111 19

550

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 LIMIT 2;

551

c1 c2 c3 c4

552

99999.99999 -99999.99999 100000 5

553

99999.99999 99999.99999 111111111 19

554

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2;

555

c1 c2 c3 c4

556

100.05000 -100.05000 100 1

557

12345.00001 NULL NULL NULL

558

99999.99999 -99999.99999 100000 5

559

99999.99999 99999.99999 111111111 19

560

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;

561

c1 c2 c3 c4

562

100.05000 -100.05000 100 1

563

12345.00001 NULL NULL NULL

564

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2;

565

c1 c2 c3 c4

566

100.05000 -100.05000 100 1

567

99999.99999 -99999.99999 100000 5

568

99999.99999 99999.99999 111111111 19

569

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 LIMIT 2;

570

c1 c2 c3 c4

571

100.05000 -100.05000 100 1

572

99999.99999 -99999.99999 100000 5

573

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2;

574

c1 c2 c3 c4

575

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

576

c1 c2 c3 c4

577

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;

578

c1 c2 c3 c4

579

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;

580

c1 c2 c3 c4

581

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;

582

c1 c2 c3 c4

583

0.00000 -0.10000 0 13

584

0.00000 0.00000 0 7

585

1.00000 1.00000 1 10

586

100.05000 -100.05000 100 1

587

12345.00001 NULL NULL NULL

588

99999.99999 -99999.99999 100000 5

589

99999.99999 99999.99999 111111111 19

590

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

591

c1 c2 c3 c4

592

0.00000 -0.10000 0 13

593

0.00000 0.00000 0 7

594

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC;

595

c1 c2 c3 c4

596

0.00000 0.00000 0 7

597

0.00000 -0.10000 0 13

598

1.00000 1.00000 1 10

599

100.05000 -100.05000 100 1

600

12345.00001 NULL NULL NULL

601

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

602

c1 c2 c3 c4

603

0.00000 0.00000 0 7

604

0.00000 -0.10000 0 13

605

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC;

606

c1 c2 c3 c4

607

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

608

c1 c2 c3 c4

609

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC;

610

c1 c2 c3 c4

611

99999.99999 99999.99999 111111111 19

612

99999.99999 -99999.99999 100000 5

613

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

614

c1 c2 c3 c4

615

99999.99999 99999.99999 111111111 19

616

99999.99999 -99999.99999 100000 5

617

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC;

618

c1 c2 c3 c4

619

0.00000 0.00000 0 7

620

0.00000 -0.10000 0 13

621

1.00000 1.00000 1 10

622

100.05000 -100.05000 100 1

623

12345.00001 NULL NULL NULL

624

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

625

c1 c2 c3 c4

626

0.00000 0.00000 0 7

627

0.00000 -0.10000 0 13

628

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC;

629

c1 c2 c3 c4

630

0.00000 0.00000 0 7

631

0.00000 -0.10000 0 13

632

1.00000 1.00000 1 10

633

100.05000 -100.05000 100 1

634

12345.00001 NULL NULL NULL

635

99999.99999 99999.99999 111111111 19

636

99999.99999 -99999.99999 100000 5

637

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

638

c1 c2 c3 c4

639

0.00000 0.00000 0 7

640

0.00000 -0.10000 0 13

641

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC;

642

c1 c2 c3 c4

643

99999.99999 99999.99999 111111111 19

644

99999.99999 -99999.99999 100000 5

645

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

646

c1 c2 c3 c4

647

99999.99999 99999.99999 111111111 19

648

99999.99999 -99999.99999 100000 5

649

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC;

650

c1 c2 c3 c4

651

100.05000 -100.05000 100 1

652

12345.00001 NULL NULL NULL

653

99999.99999 99999.99999 111111111 19

654

99999.99999 -99999.99999 100000 5

655

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

656

c1 c2 c3 c4

657

100.05000 -100.05000 100 1

658

12345.00001 NULL NULL NULL

659

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC;

660

c1 c2 c3 c4

661

100.05000 -100.05000 100 1

662

99999.99999 99999.99999 111111111 19

663

99999.99999 -99999.99999 100000 5

664

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;

665

c1 c2 c3 c4

666

100.05000 -100.05000 100 1

667

99999.99999 99999.99999 111111111 19

668

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC;

669

c1 c2 c3 c4

670

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

671

c1 c2 c3 c4

672

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;

673

c1 c2 c3 c4

674

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

675

c1 c2 c3 c4

676

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;

677

c1 c2 c3 c4

678

0.00000 0.00000 0 7

679

0.00000 -0.10000 0 13

680

1.00000 1.00000 1 10

681

100.05000 -100.05000 100 1

682

12345.00001 NULL NULL NULL

683

99999.99999 99999.99999 111111111 19

684

99999.99999 -99999.99999 100000 5

685

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

686

c1 c2 c3 c4

687

0.00000 0.00000 0 7

688

0.00000 -0.10000 0 13

689

SELECT * FROM t1;

690

c1 c2 c3 c4

691

0.00000 -0.10000 0 13

692

0.00000 0.00000 0 7

693

1.00000 1.00000 1 10

694

100.05000 -100.05000 100 1

695

12345.00001 NULL NULL NULL

696

99999.99999 -99999.99999 100000 5

697

99999.99999 99999.99999 111111111 19

698

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t1;

699

total_rows min_value max(c2)

700

7 -99999.99999 99999.99999

701

SELECT * FROM t1 WHERE c3 = '-0.0';

702

c1 c2 c3 c4

703

0.00000 -0.10000 0 13

704

0.00000 0.00000 0 7

705

SELECT c1,c2 FROM t1;

706

c1 c2

707

0.00000 -0.10000

708

0.00000 0.00000

709

1.00000 1.00000

710

100.05000 -100.05000

711

12345.00001 NULL

712

99999.99999 -99999.99999

713

99999.99999 99999.99999

714

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

715

c1 c2

716

0.00000 0.00000

717

0.00000 -0.10000

718

1.00000 1.00000

719

100.05000 -100.05000

720

12345.00001 NULL

721

99999.99999 99999.99999

722

99999.99999 -99999.99999

723

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

724

c1 c2 c3 c4

725

0.00000 -0.10000 0 13

726

0.00000 0.00000 0 7

727

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

728

c1 c2 c3 c4

729

0.00000 0.00000 0 7

730

0.00000 -0.10000 0 13

731

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2;

732

c1 c2 c3 c4

733

99999.99999 -99999.99999 100000 5

734

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 LIMIT 2;

735

c1 c2 c3 c4

736

99999.99999 -99999.99999 100000 5

737

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC;

738

c1 c2 c3 c4

739

99999.99999 -99999.99999 100000 5

740

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

741

c1 c2 c3 c4

742

99999.99999 -99999.99999 100000 5

743

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2;

744

c1 c2 c3 c4

745

0.00000 -0.10000 0 13

746

0.00000 0.00000 0 7

747

1.00000 1.00000 1 10

748

100.05000 -100.05000 100 1

749

99999.99999 99999.99999 111111111 19

750

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 LIMIT 2;

751

c1 c2 c3 c4

752

0.00000 -0.10000 0 13

753

0.00000 0.00000 0 7

754

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2;

755

c1 c2 c3 c4

756

0.00000 -0.10000 0 13

757

0.00000 0.00000 0 7

758

1.00000 1.00000 1 10

759

100.05000 -100.05000 100 1

760

99999.99999 99999.99999 111111111 19

761

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 LIMIT 2;

762

c1 c2 c3 c4

763

0.00000 -0.10000 0 13

764

0.00000 0.00000 0 7

765

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2;

766

c1 c2 c3 c4

767

0.00000 -0.10000 0 13

768

0.00000 0.00000 0 7

769

1.00000 1.00000 1 10

770

100.05000 -100.05000 100 1

771

99999.99999 -99999.99999 100000 5

772

99999.99999 99999.99999 111111111 19

773

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 LIMIT 2;

774

c1 c2 c3 c4

775

0.00000 -0.10000 0 13

776

0.00000 0.00000 0 7

777

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2;

778

c1 c2 c3 c4

779

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 LIMIT 2;

780

c1 c2 c3 c4

781

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2;

782

c1 c2 c3 c4

783

99999.99999 -99999.99999 100000 5

784

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 LIMIT 2;

785

c1 c2 c3 c4

786

99999.99999 -99999.99999 100000 5

787

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2;

788

c1 c2 c3 c4

789

99999.99999 -99999.99999 100000 5

790

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 LIMIT 2;

791

c1 c2 c3 c4

792

99999.99999 -99999.99999 100000 5

793

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2;

794

c1 c2 c3 c4

795

0.00000 -0.10000 0 13

796

0.00000 0.00000 0 7

797

100.05000 -100.05000 100 1

798

99999.99999 -99999.99999 100000 5

799

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 LIMIT 2;

800

c1 c2 c3 c4

801

0.00000 -0.10000 0 13

802

0.00000 0.00000 0 7

803

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2;

804

c1 c2 c3 c4

805

0.00000 0.00000 0 7

806

99999.99999 -99999.99999 100000 5

807

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 LIMIT 2;

808

c1 c2 c3 c4

809

0.00000 0.00000 0 7

810

99999.99999 -99999.99999 100000 5

811

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2;

812

c1 c2 c3 c4

813

99999.99999 -99999.99999 100000 5

814

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

815

c1 c2 c3 c4

816

99999.99999 -99999.99999 100000 5

817

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2;

818

c1 c2 c3 c4

819

12345.00001 NULL NULL NULL

820

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 LIMIT 2;

821

c1 c2 c3 c4

822

12345.00001 NULL NULL NULL

823

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2;

824

c1 c2 c3 c4

825

0.00000 -0.10000 0 13

826

0.00000 0.00000 0 7

827

1.00000 1.00000 1 10

828

100.05000 -100.05000 100 1

829

99999.99999 -99999.99999 100000 5

830

99999.99999 99999.99999 111111111 19

831

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

832

c1 c2 c3 c4

833

0.00000 -0.10000 0 13

834

0.00000 0.00000 0 7

835

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC;

836

c1 c2 c3 c4

837

0.00000 0.00000 0 7

838

0.00000 -0.10000 0 13

839

1.00000 1.00000 1 10

840

100.05000 -100.05000 100 1

841

99999.99999 99999.99999 111111111 19

842

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

843

c1 c2 c3 c4

844

0.00000 0.00000 0 7

845

0.00000 -0.10000 0 13

846

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC;

847

c1 c2 c3 c4

848

0.00000 0.00000 0 7

849

0.00000 -0.10000 0 13

850

1.00000 1.00000 1 10

851

100.05000 -100.05000 100 1

852

99999.99999 99999.99999 111111111 19

853

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

854

c1 c2 c3 c4

855

0.00000 0.00000 0 7

856

0.00000 -0.10000 0 13

857

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC;

858

c1 c2 c3 c4

859

0.00000 0.00000 0 7

860

0.00000 -0.10000 0 13

861

1.00000 1.00000 1 10

862

100.05000 -100.05000 100 1

863

99999.99999 99999.99999 111111111 19

864

99999.99999 -99999.99999 100000 5

865

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

866

c1 c2 c3 c4

867

0.00000 0.00000 0 7

868

0.00000 -0.10000 0 13

869

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC;

870

c1 c2 c3 c4

871

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

872

c1 c2 c3 c4

873

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC;

874

c1 c2 c3 c4

875

99999.99999 -99999.99999 100000 5

876

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

877

c1 c2 c3 c4

878

99999.99999 -99999.99999 100000 5

879

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC;

880

c1 c2 c3 c4

881

99999.99999 -99999.99999 100000 5

882

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

883

c1 c2 c3 c4

884

99999.99999 -99999.99999 100000 5

885

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC;

886

c1 c2 c3 c4

887

0.00000 0.00000 0 7

888

0.00000 -0.10000 0 13

889

100.05000 -100.05000 100 1

890

99999.99999 -99999.99999 100000 5

891

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC LIMIT 2;

892

c1 c2 c3 c4

893

0.00000 0.00000 0 7

894

0.00000 -0.10000 0 13

895

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC;

896

c1 c2 c3 c4

897

0.00000 0.00000 0 7

898

99999.99999 -99999.99999 100000 5

899

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC LIMIT 2;

900

c1 c2 c3 c4

901

0.00000 0.00000 0 7

902

99999.99999 -99999.99999 100000 5

903

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC;

904

c1 c2 c3 c4

905

99999.99999 -99999.99999 100000 5

906

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

907

c1 c2 c3 c4

908

99999.99999 -99999.99999 100000 5

909

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC;

910

c1 c2 c3 c4

911

12345.00001 NULL NULL NULL

912

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

913

c1 c2 c3 c4

914

12345.00001 NULL NULL NULL

915

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC;

916

c1 c2 c3 c4

917

0.00000 0.00000 0 7

918

0.00000 -0.10000 0 13

919

1.00000 1.00000 1 10

920

100.05000 -100.05000 100 1

921

99999.99999 99999.99999 111111111 19

922

99999.99999 -99999.99999 100000 5

923

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

924

c1 c2 c3 c4

925

0.00000 0.00000 0 7

926

0.00000 -0.10000 0 13

927

SELECT c1 FROM t1 GROUP BY c1;

928

929

0.00000

930

1.00000

931

100.05000

932

12345.00001

933

99999.99999

934

SELECT DISTINCT c1 FROM t1;

935

936

0.00000

937

1.00000

938

100.05000

939

12345.00001

940

99999.99999

941

SELECT c1,MIN(c2) FROM t1 GROUP BY c1;

942

c1 MIN(c2)

943

0.00000 -0.10000

944

1.00000 1.00000

945

100.05000 -100.05000

946

12345.00001 NULL

947

99999.99999 -99999.99999

948

CREATE TABLE t5(c1 DECIMAL(65,0) UNSIGNED NOT NULL, c2 DECIMAL(65,0) SIGNED NULL, c3 DECIMAL, c4 INT, INDEX idx(c1,c2));

949

INSERT INTO t5 VALUES('1e+64','-1e+64','1e+64',1),('1e-64','-1e-64','1e-64',2);

950

Warnings:

951

Warning 1264 Out of range value for column 'c3' at row 1

952

Note 1265 Data truncated for column 'c1' at row 2

953

Note 1265 Data truncated for column 'c2' at row 2

954

Note 1265 Data truncated for column 'c3' at row 2

955

INSERT INTO t5 VALUES('1.2e+65','-1.2e+65','1.2e+65',3),('1.2e-65','-1.2e-65','1.2e-65',4);

956

Warnings:

957

Warning 1264 Out of range value for column 'c1' at row 1

958

Warning 1264 Out of range value for column 'c2' at row 1

959

Warning 1264 Out of range value for column 'c3' at row 1

960

Note 1265 Data truncated for column 'c1' at row 2

961

Note 1265 Data truncated for column 'c2' at row 2

962

Note 1265 Data truncated for column 'c3' at row 2

963

SELECT * FROM t5;

964

c1 c2 c3 c4

965

0 0 0 2

966

0 0 0 4

967

10000000000000000000000000000000000000000000000000000000000000000 -10000000000000000000000000000000000000000000000000000000000000000 9999999999 1

968

99999999999999999999999999999999999999999999999999999999999999999 -99999999999999999999999999999999999999999999999999999999999999999 9999999999 3

969

DROP TABLE t5;

970

CREATE TABLE t5(c1 DECIMAL(18,9) UNSIGNED, c2 DECIMAL(18,9) SIGNED) /* requires 8 bytes */;

971

INSERT INTO t5 VALUES(123456789.123456789,-123456789.123456789);

972

SELECT c1,c2 FROM t5;

973

c1 c2

974

123456789.123456789 -123456789.123456789

975

ALTER TABLE t5 CHANGE c1 c1 DECIMAL(19,9) UNSIGNED, CHANGE c2 c2 DECIMAL(19,9) SIGNED /* requires 9 bytes */;

976

INSERT INTO t5 VALUES(1234567891.123456789,-1234567891.123456789);

977

SELECT c1,c2 FROM t5;

978

c1 c2

979

123456789.123456789 -123456789.123456789

980

1234567891.123456789 -1234567891.123456789

981

ALTER TABLE t5 CHANGE c1 c1 DECIMAL(21,10) UNSIGNED, CHANGE c2 c2 DECIMAL(21,10) SIGNED /* requires 10 bytes */;

982

INSERT INTO t5 VALUES(12345678912.1234567891,-12345678912.1234567891);

983

SELECT c1,c2 FROM t5;

984

c1 c2

985

123456789.1234567890 -123456789.1234567890

986

1234567891.1234567890 -1234567891.1234567890

987

12345678912.1234567891 -12345678912.1234567891

988

ALTER TABLE t5 CHANGE c1 c1 DECIMAL(23,11) UNSIGNED, CHANGE c2 c2 DECIMAL(23,11) SIGNED /* requires 11 bytes */;

989

INSERT INTO t5 VALUES(123456789123.12345678912,-123456789123.12345678912);

990

SELECT c1,c2 FROM t5;

991

c1 c2

992

123456789.12345678900 -123456789.12345678900

993

1234567891.12345678900 -1234567891.12345678900

994

12345678912.12345678910 -12345678912.12345678910

995

123456789123.12345678912 -123456789123.12345678912

996

ALTER TABLE t5 CHANGE c1 c1 DECIMAL(25,12) UNSIGNED, CHANGE c2 c2 DECIMAL(25,12) SIGNED /* requires 12 bytes */;

997

INSERT INTO t5 VALUES(1234567891234.123456789123,-1234567891234.123456789123);

998

SELECT c1,c2 FROM t5;

999

c1 c2

1000

123456789.123456789000 -123456789.123456789000

1001

1234567891.123456789000 -1234567891.123456789000

1002

12345678912.123456789100 -12345678912.123456789100

1003

123456789123.123456789120 -123456789123.123456789120

1004

1234567891234.123456789123 -1234567891234.123456789123

1005

SELECT SUM(c1),SUM(c2) FROM t5;

1006

SUM(c1) SUM(c2)

1007

1371728383949.617283945343 -1371728383949.617283945343

1008

DROP TABLE t5;

1009

CREATE TABLE t5(c1 DECIMAL(16,6), c2 tinyint);

1010

INSERT INTO t5 VALUES(1.1325,3);

1011

SELECT ROUND(c1,c2),TRUNCATE(c1,c2) FROM t5;

1012

ROUND(c1,c2) TRUNCATE(c1,c2)

1013

1.133000 1.132000

1014

DROP TABLE t5;

1015

CREATE TABLE t7(c1 DECIMAL(66,0));

1016

ERROR 42000: Too big precision 66 specified for column 'c1'. Maximum is 65.

1017

CREATE TABLE t7(c1 DECIMAL(5,10));

1018

ERROR 42000: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'c1').

1019

DROP TABLE t1,t2;

1020

CREATE TABLE t1(c1 FLOAT(10,5) UNSIGNED NOT NULL, c2 FLOAT(10,5) SIGNED NULL, c3 FLOAT, c4 INT, UNIQUE INDEX idx(c1,c2));

1021

CREATE TABLE t2(c1 FLOAT(10,0) SIGNED NOT NULL, c2 FLOAT(10,0) UNSIGNED NULL, c3 FLOAT, c4 INT);

1022

INSERT INTO t1 VALUES('00100.05000','-00100.05000','00100.05000',1);

1023

INSERT INTO t2 VALUES('-1000000000','1000000000','1000000000',2);

1024

INSERT INTO t1(c1) VALUES('12345.000009');

1025

INSERT INTO t1 VALUES('99999.99999','-99999.99999','99999.99999',3);

1026

INSERT INTO t2 VALUES('-9999999999','-9999999999','9999999999',4);

1027

Warnings:

1028

Warning 1264 Out of range value for column 'c2' at row 1

1029

SELECT * FROM t1;

1030

c1 c2 c3 c4

1031

100.05000 -100.05000 100.05 1

1032

12345.00000 NULL NULL NULL

1033

100000.00000 -100000.00000 100000 3

1034

INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);

1035

ERROR 23000: Duplicate entry '100000.00000--100000.00000' for key 'idx'

1036

DELETE FROM t1 WHERE c1='100000.00000' AND c2='-100000.00000';

1037

INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);

1038

Warnings:

1039

Warning 1264 Out of range value for column 'c1' at row 1

1040

Warning 1264 Out of range value for column 'c2' at row 1

1041

INSERT INTO t2 VALUES('10000000000','-10000000000','10000000000',6);

1042

Warnings:

1043

Warning 1264 Out of range value for column 'c1' at row 1

1044

Warning 1264 Out of range value for column 'c2' at row 1

1045

insert into t1 values ("0.0","0.0","0.0",7),("01.0","01.0","01.0",10);

1046

insert into t1 values ("-.1","-.1","-.1",13);

1047

Warnings:

1048

Warning 1264 Out of range value for column 'c1' at row 1

1049

insert into t1 values ("+111111111.11","+111111111.11","+111111111.11",19);

1050

Warnings:

1051

Warning 1264 Out of range value for column 'c1' at row 1

1052

Warning 1264 Out of range value for column 'c2' at row 1

1053

insert into t2 values ("0.0","0.0","0.0",7),("-0.0","-0.0","-0.0",8),("+0.0","+0.0","+0.0",9),("01.0","01.0","01.0",10),("+01.0","+01.0","+01.0",11),("-01.0","-01.0","-01.0",12);

1054

Warnings:

1055

Warning 1264 Out of range value for column 'c2' at row 6

1056

insert into t2 values ("-.1","-.1","-.1",13),("+.1","+.1","+.1",14),(".1",".1",".1",15);

1057

Warnings:

1058

Warning 1264 Out of range value for column 'c2' at row 1

1059

insert into t2 values ("00000000000001","00000000000001","00000000000001",16),("+0000000000001","+0000000000001","+0000000000001",17),("-0000000000001","-0000000000001","-0000000000001",18);

1060

Warnings:

1061

Warning 1264 Out of range value for column 'c2' at row 3

1062

insert into t2 values ("+111111111.11","+111111111.11","+111111111.11",19),("111111111.11","111111111.11","111111111.11",20),("-11111111.11","-11111111.11","-11111111.11",21);

1063

Warnings:

1064

Warning 1264 Out of range value for column 'c2' at row 3

1065

insert into t2 values ("-111111111.11","-111111111.11","-111111111.11",22),("+1111111111.11","+1111111111.11","+1111111111.11",23),("1111111111.11","1111111111.11","1111111111.11",24);

1066

Warnings:

1067

Warning 1264 Out of range value for column 'c2' at row 1

1068

insert into t2 values ("1e+1000","1e+1000","1e+1000",25),("1e-1000","1e-1000","1e-1000",26),("-1e+1000","-1e+1000","-1e+1000",27);

1069

Warnings:

1070

Warning 1264 Out of range value for column 'c1' at row 1

1071

Warning 1264 Out of range value for column 'c1' at row 1

1072

Warning 1264 Out of range value for column 'c2' at row 1

1073

Warning 1264 Out of range value for column 'c2' at row 1

1074

Warning 1264 Out of range value for column 'c3' at row 1

1075

Warning 1264 Out of range value for column 'c3' at row 1

1076

Warning 1264 Out of range value for column 'c1' at row 3

1077

Warning 1264 Out of range value for column 'c1' at row 3

1078

Warning 1264 Out of range value for column 'c2' at row 3

1079

Warning 1264 Out of range value for column 'c2' at row 3

1080

Warning 1264 Out of range value for column 'c3' at row 3

1081

Warning 1264 Out of range value for column 'c3' at row 3

1082

insert into t2 values ("1e+4294967296","1e+4294967296","1e+4294967296",28),("1e-4294967296","1e-4294967296","1e-4294967296",29);

1083

Warnings:

1084

Warning 1264 Out of range value for column 'c1' at row 1

1085

Warning 1264 Out of range value for column 'c1' at row 1

1086

Warning 1264 Out of range value for column 'c2' at row 1

1087

Warning 1264 Out of range value for column 'c2' at row 1

1088

Warning 1264 Out of range value for column 'c3' at row 1

1089

Warning 1264 Out of range value for column 'c3' at row 1

1090

1091

Warnings:

1092

Warning 1264 Out of range value for column 'c1' at row 1

1093

Warning 1264 Out of range value for column 'c1' at row 1

1094

Warning 1264 Out of range value for column 'c2' at row 1

1095

Warning 1264 Out of range value for column 'c2' at row 1

1096

Warning 1264 Out of range value for column 'c3' at row 1

1097

Warning 1264 Out of range value for column 'c3' at row 1

1098

Warning 1264 Out of range value for column 'c1' at row 2

1099

Warning 1264 Out of range value for column 'c1' at row 2

1100

Warning 1264 Out of range value for column 'c2' at row 2

1101

Warning 1264 Out of range value for column 'c2' at row 2

1102

Warning 1264 Out of range value for column 'c3' at row 2

1103

Warning 1264 Out of range value for column 'c3' at row 2

1104

SELECT * FROM t1;

1105

c1 c2 c3 c4

1106

0.00000 -0.10000 -0.1 13

1107

0.00000 0.00000 0 7

1108

1.00000 1.00000 1 10

1109

100.05000 -100.05000 100.05 1

1110

100000.00000 -100000.00000 100000 5

1111

100000.00000 100000.00000 1.11111e+08 19

1112

12345.00000 NULL NULL NULL

1113

SELECT * FROM t2;

1114

c1 c2 c3 c4

1115

-1 0 -1 12

1116

-1 0 -1 18

1117

-1000000000 1000000000 1e+09 2

1118

-10000000000 0 -3.40282e+38 27

1119

-10000000000 0 1e+10 4

1120

-11111111 0 -1.11111e+07 21

1121

-111111112 0 -1.11111e+08 22

1122

0 0 -0 8

1123

0 0 -0.1 13

1124

0 0 0 26

1125

0 0 0 29

1126

0 0 0 32

1127

0 0 0 33

1128

0 0 0 7

1129

0 0 0 9

1130

0 0 0.1 14

1131

0 0 0.1 15

1132

1 1 1 10

1133

1 1 1 11

1134

1 1 1 16

1135

1 1 1 17

1136

10000000000 0 1e+10 6

1137

10000000000 10000000000 3.40282e+38 25

1138

10000000000 10000000000 3.40282e+38 28

1139

10000000000 10000000000 3.40282e+38 30

1140

10000000000 10000000000 3.40282e+38 31

1141

111111112 111111112 1.11111e+08 19

1142

111111112 111111112 1.11111e+08 20

1143

1111111168 1111111168 1.11111e+09 23

1144

1111111168 1111111168 1.11111e+09 24

1145

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t1;

1146

total_rows min_value max_value sum avg

1147

7 0.00000 100000.00000 212446.05000 30349.435714722

1148

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t1;

1149

total_rows min_value max_value sum avg

1150

7 -100000.00000 100000.00000 -99.15000 -16.525000509

1151

SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t1;

1152

total_rows min_value max_value sum avg

1153

7 -0.100000001490116 111111112 111211212.950003 18535202.1583338

1154

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t2;

1155

total_rows min_value max_value sum avg

1156

30 -10000000000 10000000000 31322222339 1044074077.9667

1157

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t2;

1158

total_rows min_value max_value sum avg

1159

30 0 10000000000 43444444564 1448148152.1333

1160

SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t2;

1161

total_rows min_value max_value sum avg

1162

30 -3.40282346638529e+38 3.40282346638529e+38 1.02084703991559e+39 3.40282346638529e+37

1163

SELECT * FROM t1;

1164

c1 c2 c3 c4

1165

0.00000 -0.10000 -0.1 13

1166

0.00000 0.00000 0 7

1167

1.00000 1.00000 1 10

1168

100.05000 -100.05000 100.05 1

1169

100000.00000 -100000.00000 100000 5

1170

100000.00000 100000.00000 1.11111e+08 19

1171

12345.00000 NULL NULL NULL

1172

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;

1173

total_rows min_value max(c1)

1174

7 0.00000 100000.00000

1175

SELECT * FROM t1 WHERE c3 = '0.0';

1176

c1 c2 c3 c4

1177

0.00000 0.00000 0 7

1178

SELECT c1,c2 FROM t1;

1179

c1 c2

1180

0.00000 -0.10000

1181

0.00000 0.00000

1182

1.00000 1.00000

1183

100.05000 -100.05000

1184

100000.00000 -100000.00000

1185

100000.00000 100000.00000

1186

12345.00000 NULL

1187

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

1188

c1 c2

1189

0.00000 0.00000

1190

0.00000 -0.10000

1191

1.00000 1.00000

1192

100.05000 -100.05000

1193

12345.00000 NULL

1194

100000.00000 100000.00000

1195

100000.00000 -100000.00000

1196

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

1197

c1 c2 c3 c4

1198

0.00000 -0.10000 -0.1 13

1199

0.00000 0.00000 0 7

1200

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

1201

c1 c2 c3 c4

1202

0.00000 0.00000 0 7

1203

0.00000 -0.10000 -0.1 13

1204

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2;

1205

c1 c2 c3 c4

1206

0.00000 -0.10000 -0.1 13

1207

0.00000 0.00000 0 7

1208

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 LIMIT 2;

1209

c1 c2 c3 c4

1210

0.00000 -0.10000 -0.1 13

1211

0.00000 0.00000 0 7

1212

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC;

1213

c1 c2 c3 c4

1214

0.00000 0.00000 0 7

1215

0.00000 -0.10000 -0.1 13

1216

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC LIMIT 2;

1217

c1 c2 c3 c4

1218

0.00000 0.00000 0 7

1219

0.00000 -0.10000 -0.1 13

1220

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2;

1221

c1 c2 c3 c4

1222

1.00000 1.00000 1 10

1223

100.05000 -100.05000 100.05 1

1224

12345.00000 NULL NULL NULL

1225

100000.00000 -100000.00000 100000 5

1226

100000.00000 100000.00000 1.11111e+08 19

1227

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 LIMIT 2;

1228

c1 c2 c3 c4

1229

1.00000 1.00000 1 10

1230

100.05000 -100.05000 100.05 1

1231

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2;

1232

c1 c2 c3 c4

1233

1.00000 1.00000 1 10

1234

100.05000 -100.05000 100.05 1

1235

12345.00000 NULL NULL NULL

1236

100000.00000 -100000.00000 100000 5

1237

100000.00000 100000.00000 1.11111e+08 19

1238

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 LIMIT 2;

1239

c1 c2 c3 c4

1240

1.00000 1.00000 1 10

1241

100.05000 -100.05000 100.05 1

1242

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2;

1243

c1 c2 c3 c4

1244

0.00000 -0.10000 -0.1 13

1245

0.00000 0.00000 0 7

1246

1.00000 1.00000 1 10

1247

100.05000 -100.05000 100.05 1

1248

12345.00000 NULL NULL NULL

1249

100000.00000 -100000.00000 100000 5

1250

100000.00000 100000.00000 1.11111e+08 19

1251

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 LIMIT 2;

1252

c1 c2 c3 c4

1253

0.00000 -0.10000 -0.1 13

1254

0.00000 0.00000 0 7

1255

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2;

1256

c1 c2 c3 c4

1257

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 LIMIT 2;

1258

c1 c2 c3 c4

1259

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2;

1260

c1 c2 c3 c4

1261

0.00000 -0.10000 -0.1 13

1262

0.00000 0.00000 0 7

1263

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 LIMIT 2;

1264

c1 c2 c3 c4

1265

0.00000 -0.10000 -0.1 13

1266

0.00000 0.00000 0 7

1267

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2;

1268

c1 c2 c3 c4

1269

0.00000 -0.10000 -0.1 13

1270

0.00000 0.00000 0 7

1271

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 LIMIT 2;

1272

c1 c2 c3 c4

1273

0.00000 -0.10000 -0.1 13

1274

0.00000 0.00000 0 7

1275

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2;

1276

c1 c2 c3 c4

1277

0.00000 -0.10000 -0.1 13

1278

0.00000 0.00000 0 7

1279

1.00000 1.00000 1 10

1280

100.05000 -100.05000 100.05 1

1281

12345.00000 NULL NULL NULL

1282

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;

1283

c1 c2 c3 c4

1284

0.00000 -0.10000 -0.1 13

1285

0.00000 0.00000 0 7

1286

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2;

1287

c1 c2 c3 c4

1288

0.00000 -0.10000 -0.1 13

1289

0.00000 0.00000 0 7

1290

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 LIMIT 2;

1291

c1 c2 c3 c4

1292

0.00000 -0.10000 -0.1 13

1293

0.00000 0.00000 0 7

1294

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2;

1295

c1 c2 c3 c4

1296

1.00000 1.00000 1 10

1297

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 LIMIT 2;

1298

c1 c2 c3 c4

1299

1.00000 1.00000 1 10

1300

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;

1301

c1 c2 c3 c4

1302

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;

1303

c1 c2 c3 c4

1304

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;

1305

c1 c2 c3 c4

1306

0.00000 -0.10000 -0.1 13

1307

0.00000 0.00000 0 7

1308

1.00000 1.00000 1 10

1309

100.05000 -100.05000 100.05 1

1310

12345.00000 NULL NULL NULL

1311

100000.00000 -100000.00000 100000 5

1312

100000.00000 100000.00000 1.11111e+08 19

1313

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

1314

c1 c2 c3 c4

1315

0.00000 -0.10000 -0.1 13

1316

0.00000 0.00000 0 7

1317

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC;

1318

c1 c2 c3 c4

1319

1.00000 1.00000 1 10

1320

100.05000 -100.05000 100.05 1

1321

12345.00000 NULL NULL NULL

1322

100000.00000 100000.00000 1.11111e+08 19

1323

100000.00000 -100000.00000 100000 5

1324

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC LIMIT 2;

1325

c1 c2 c3 c4

1326

1.00000 1.00000 1 10

1327

100.05000 -100.05000 100.05 1

1328

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC;

1329

c1 c2 c3 c4

1330

1.00000 1.00000 1 10

1331

100.05000 -100.05000 100.05 1

1332

12345.00000 NULL NULL NULL

1333

100000.00000 100000.00000 1.11111e+08 19

1334

100000.00000 -100000.00000 100000 5

1335

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC LIMIT 2;

1336

c1 c2 c3 c4

1337

1.00000 1.00000 1 10

1338

100.05000 -100.05000 100.05 1

1339

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC;

1340

c1 c2 c3 c4

1341

0.00000 0.00000 0 7

1342

0.00000 -0.10000 -0.1 13

1343

1.00000 1.00000 1 10

1344

100.05000 -100.05000 100.05 1

1345

12345.00000 NULL NULL NULL

1346

100000.00000 100000.00000 1.11111e+08 19

1347

100000.00000 -100000.00000 100000 5

1348

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC LIMIT 2;

1349

c1 c2 c3 c4

1350

0.00000 0.00000 0 7

1351

0.00000 -0.10000 -0.1 13

1352

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC;

1353

c1 c2 c3 c4

1354

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC LIMIT 2;

1355

c1 c2 c3 c4

1356

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC;

1357

c1 c2 c3 c4

1358

0.00000 0.00000 0 7

1359

0.00000 -0.10000 -0.1 13

1360

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC LIMIT 2;

1361

c1 c2 c3 c4

1362

0.00000 0.00000 0 7

1363

0.00000 -0.10000 -0.1 13

1364

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC;

1365

c1 c2 c3 c4

1366

0.00000 0.00000 0 7

1367

0.00000 -0.10000 -0.1 13

1368

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC LIMIT 2;

1369

c1 c2 c3 c4

1370

0.00000 0.00000 0 7

1371

0.00000 -0.10000 -0.1 13

1372

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC;

1373

c1 c2 c3 c4

1374

0.00000 0.00000 0 7

1375

0.00000 -0.10000 -0.1 13

1376

1.00000 1.00000 1 10

1377

100.05000 -100.05000 100.05 1

1378

12345.00000 NULL NULL NULL

1379

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1380

c1 c2 c3 c4

1381

0.00000 0.00000 0 7

1382

0.00000 -0.10000 -0.1 13

1383

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC;

1384

c1 c2 c3 c4

1385

0.00000 0.00000 0 7

1386

0.00000 -0.10000 -0.1 13

1387

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;

1388

c1 c2 c3 c4

1389

0.00000 0.00000 0 7

1390

0.00000 -0.10000 -0.1 13

1391

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC;

1392

c1 c2 c3 c4

1393

1.00000 1.00000 1 10

1394

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC LIMIT 2;

1395

c1 c2 c3 c4

1396

1.00000 1.00000 1 10

1397

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;

1398

c1 c2 c3 c4

1399

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

1400

c1 c2 c3 c4

1401

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;

1402

c1 c2 c3 c4

1403

0.00000 0.00000 0 7

1404

0.00000 -0.10000 -0.1 13

1405

1.00000 1.00000 1 10

1406

100.05000 -100.05000 100.05 1

1407

12345.00000 NULL NULL NULL

1408

100000.00000 100000.00000 1.11111e+08 19

1409

100000.00000 -100000.00000 100000 5

1410

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

1411

c1 c2 c3 c4

1412

0.00000 0.00000 0 7

1413

0.00000 -0.10000 -0.1 13

1414

SELECT * FROM t1;

1415

c1 c2 c3 c4

1416

0.00000 -0.10000 -0.1 13

1417

0.00000 0.00000 0 7

1418

1.00000 1.00000 1 10

1419

100.05000 -100.05000 100.05 1

1420

100000.00000 -100000.00000 100000 5

1421

100000.00000 100000.00000 1.11111e+08 19

1422

12345.00000 NULL NULL NULL

1423

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;

1424

total_rows min_value max(c1)

1425

7 0.00000 100000.00000

1426

SELECT * FROM t1 WHERE c3 = '-0.0';

1427

c1 c2 c3 c4

1428

0.00000 0.00000 0 7

1429

SELECT c1,c2 FROM t1;

1430

c1 c2

1431

0.00000 -0.10000

1432

0.00000 0.00000

1433

1.00000 1.00000

1434

100.05000 -100.05000

1435

100000.00000 -100000.00000

1436

100000.00000 100000.00000

1437

12345.00000 NULL

1438

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

1439

c1 c2

1440

0.00000 0.00000

1441

0.00000 -0.10000

1442

1.00000 1.00000

1443

100.05000 -100.05000

1444

12345.00000 NULL

1445

100000.00000 100000.00000

1446

100000.00000 -100000.00000

1447

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

1448

c1 c2 c3 c4

1449

0.00000 -0.10000 -0.1 13

1450

0.00000 0.00000 0 7

1451

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

1452

c1 c2 c3 c4

1453

0.00000 0.00000 0 7

1454

0.00000 -0.10000 -0.1 13

1455

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2;

1456

c1 c2 c3 c4

1457

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

1458

c1 c2 c3 c4

1459

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC;

1460

c1 c2 c3 c4

1461

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1462

c1 c2 c3 c4

1463

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2;

1464

c1 c2 c3 c4

1465

0.00000 -0.10000 -0.1 13

1466

0.00000 0.00000 0 7

1467

1.00000 1.00000 1 10

1468

100.05000 -100.05000 100.05 1

1469

12345.00000 NULL NULL NULL

1470

100000.00000 -100000.00000 100000 5

1471

100000.00000 100000.00000 1.11111e+08 19

1472

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 LIMIT 2;

1473

c1 c2 c3 c4

1474

0.00000 -0.10000 -0.1 13

1475

0.00000 0.00000 0 7

1476

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2;

1477

c1 c2 c3 c4

1478

100000.00000 -100000.00000 100000 5

1479

100000.00000 100000.00000 1.11111e+08 19

1480

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 LIMIT 2;

1481

c1 c2 c3 c4

1482

100000.00000 -100000.00000 100000 5

1483

100000.00000 100000.00000 1.11111e+08 19

1484

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2;

1485

c1 c2 c3 c4

1486

100000.00000 -100000.00000 100000 5

1487

100000.00000 100000.00000 1.11111e+08 19

1488

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 LIMIT 2;

1489

c1 c2 c3 c4

1490

100000.00000 -100000.00000 100000 5

1491

100000.00000 100000.00000 1.11111e+08 19

1492

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2;

1493

c1 c2 c3 c4

1494

0.00000 -0.10000 -0.1 13

1495

0.00000 0.00000 0 7

1496

1.00000 1.00000 1 10

1497

100.05000 -100.05000 100.05 1

1498

12345.00000 NULL NULL NULL

1499

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 LIMIT 2;

1500

c1 c2 c3 c4

1501

0.00000 -0.10000 -0.1 13

1502

0.00000 0.00000 0 7

1503

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2;

1504

c1 c2 c3 c4

1505

0.00000 -0.10000 -0.1 13

1506

0.00000 0.00000 0 7

1507

1.00000 1.00000 1 10

1508

100.05000 -100.05000 100.05 1

1509

12345.00000 NULL NULL NULL

1510

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 LIMIT 2;

1511

c1 c2 c3 c4

1512

0.00000 -0.10000 -0.1 13

1513

0.00000 0.00000 0 7

1514

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2;

1515

c1 c2 c3 c4

1516

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 LIMIT 2;

1517

c1 c2 c3 c4

1518

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2;

1519

c1 c2 c3 c4

1520

100.05000 -100.05000 100.05 1

1521

12345.00000 NULL NULL NULL

1522

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;

1523

c1 c2 c3 c4

1524

100.05000 -100.05000 100.05 1

1525

12345.00000 NULL NULL NULL

1526

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2;

1527

c1 c2 c3 c4

1528

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 LIMIT 2;

1529

c1 c2 c3 c4

1530

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2;

1531

c1 c2 c3 c4

1532

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

1533

c1 c2 c3 c4

1534

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;

1535

c1 c2 c3 c4

1536

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;

1537

c1 c2 c3 c4

1538

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;

1539

c1 c2 c3 c4

1540

0.00000 -0.10000 -0.1 13

1541

0.00000 0.00000 0 7

1542

1.00000 1.00000 1 10

1543

100.05000 -100.05000 100.05 1

1544

12345.00000 NULL NULL NULL

1545

100000.00000 -100000.00000 100000 5

1546

100000.00000 100000.00000 1.11111e+08 19

1547

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

1548

c1 c2 c3 c4

1549

0.00000 -0.10000 -0.1 13

1550

0.00000 0.00000 0 7

1551

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC;

1552

c1 c2 c3 c4

1553

0.00000 0.00000 0 7

1554

0.00000 -0.10000 -0.1 13

1555

1.00000 1.00000 1 10

1556

100.05000 -100.05000 100.05 1

1557

12345.00000 NULL NULL NULL

1558

100000.00000 100000.00000 1.11111e+08 19

1559

100000.00000 -100000.00000 100000 5

1560

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1561

c1 c2 c3 c4

1562

0.00000 0.00000 0 7

1563

0.00000 -0.10000 -0.1 13

1564

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC;

1565

c1 c2 c3 c4

1566

100000.00000 100000.00000 1.11111e+08 19

1567

100000.00000 -100000.00000 100000 5

1568

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1569

c1 c2 c3 c4

1570

100000.00000 100000.00000 1.11111e+08 19

1571

100000.00000 -100000.00000 100000 5

1572

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC;

1573

c1 c2 c3 c4

1574

100000.00000 100000.00000 1.11111e+08 19

1575

100000.00000 -100000.00000 100000 5

1576

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1577

c1 c2 c3 c4

1578

100000.00000 100000.00000 1.11111e+08 19

1579

100000.00000 -100000.00000 100000 5

1580

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC;

1581

c1 c2 c3 c4

1582

0.00000 0.00000 0 7

1583

0.00000 -0.10000 -0.1 13

1584

1.00000 1.00000 1 10

1585

100.05000 -100.05000 100.05 1

1586

12345.00000 NULL NULL NULL

1587

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1588

c1 c2 c3 c4

1589

0.00000 0.00000 0 7

1590

0.00000 -0.10000 -0.1 13

1591

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC;

1592

c1 c2 c3 c4

1593

0.00000 0.00000 0 7

1594

0.00000 -0.10000 -0.1 13

1595

1.00000 1.00000 1 10

1596

100.05000 -100.05000 100.05 1

1597

12345.00000 NULL NULL NULL

1598

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1599

c1 c2 c3 c4

1600

0.00000 0.00000 0 7

1601

0.00000 -0.10000 -0.1 13

1602

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC;

1603

c1 c2 c3 c4

1604

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1605

c1 c2 c3 c4

1606

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC;

1607

c1 c2 c3 c4

1608

100.05000 -100.05000 100.05 1

1609

12345.00000 NULL NULL NULL

1610

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1611

c1 c2 c3 c4

1612

100.05000 -100.05000 100.05 1

1613

12345.00000 NULL NULL NULL

1614

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC;

1615

c1 c2 c3 c4

1616

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;

1617

c1 c2 c3 c4

1618

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC;

1619

c1 c2 c3 c4

1620

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1621

c1 c2 c3 c4

1622

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;

1623

c1 c2 c3 c4

1624

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

1625

c1 c2 c3 c4

1626

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;

1627

c1 c2 c3 c4

1628

0.00000 0.00000 0 7

1629

0.00000 -0.10000 -0.1 13

1630

1.00000 1.00000 1 10

1631

100.05000 -100.05000 100.05 1

1632

12345.00000 NULL NULL NULL

1633

100000.00000 100000.00000 1.11111e+08 19

1634

100000.00000 -100000.00000 100000 5

1635

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

1636

c1 c2 c3 c4

1637

0.00000 0.00000 0 7

1638

0.00000 -0.10000 -0.1 13

1639

SELECT * FROM t1;

1640

c1 c2 c3 c4

1641

0.00000 -0.10000 -0.1 13

1642

0.00000 0.00000 0 7

1643

1.00000 1.00000 1 10

1644

100.05000 -100.05000 100.05 1

1645

100000.00000 -100000.00000 100000 5

1646

100000.00000 100000.00000 1.11111e+08 19

1647

12345.00000 NULL NULL NULL

1648

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t1;

1649

total_rows min_value max(c2)

1650

7 -100000.00000 100000.00000

1651

SELECT * FROM t1 WHERE c3 = '-0.0';

1652

c1 c2 c3 c4

1653

0.00000 0.00000 0 7

1654

SELECT c1,c2 FROM t1;

1655

c1 c2

1656

0.00000 -0.10000

1657

0.00000 0.00000

1658

1.00000 1.00000

1659

100.05000 -100.05000

1660

100000.00000 -100000.00000

1661

100000.00000 100000.00000

1662

12345.00000 NULL

1663

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

1664

c1 c2

1665

0.00000 0.00000

1666

0.00000 -0.10000

1667

1.00000 1.00000

1668

100.05000 -100.05000

1669

12345.00000 NULL

1670

100000.00000 100000.00000

1671

100000.00000 -100000.00000

1672

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

1673

c1 c2 c3 c4

1674

0.00000 -0.10000 -0.1 13

1675

0.00000 0.00000 0 7

1676

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

1677

c1 c2 c3 c4

1678

0.00000 0.00000 0 7

1679

0.00000 -0.10000 -0.1 13

1680

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2;

1681

c1 c2 c3 c4

1682

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 LIMIT 2;

1683

c1 c2 c3 c4

1684

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC;

1685

c1 c2 c3 c4

1686

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1687

c1 c2 c3 c4

1688

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2;

1689

c1 c2 c3 c4

1690

0.00000 -0.10000 -0.1 13

1691

0.00000 0.00000 0 7

1692

1.00000 1.00000 1 10

1693

100.05000 -100.05000 100.05 1

1694

100000.00000 -100000.00000 100000 5

1695

100000.00000 100000.00000 1.11111e+08 19

1696

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 LIMIT 2;

1697

c1 c2 c3 c4

1698

0.00000 -0.10000 -0.1 13

1699

0.00000 0.00000 0 7

1700

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2;

1701

c1 c2 c3 c4

1702

0.00000 -0.10000 -0.1 13

1703

0.00000 0.00000 0 7

1704

1.00000 1.00000 1 10

1705

100.05000 -100.05000 100.05 1

1706

100000.00000 100000.00000 1.11111e+08 19

1707

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 LIMIT 2;

1708

c1 c2 c3 c4

1709

0.00000 -0.10000 -0.1 13

1710

0.00000 0.00000 0 7

1711

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2;

1712

c1 c2 c3 c4

1713

0.00000 -0.10000 -0.1 13

1714

0.00000 0.00000 0 7

1715

1.00000 1.00000 1 10

1716

100.05000 -100.05000 100.05 1

1717

100000.00000 100000.00000 1.11111e+08 19

1718

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 LIMIT 2;

1719

c1 c2 c3 c4

1720

0.00000 -0.10000 -0.1 13

1721

0.00000 0.00000 0 7

1722

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2;

1723

c1 c2 c3 c4

1724

100000.00000 -100000.00000 100000 5

1725

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 LIMIT 2;

1726

c1 c2 c3 c4

1727

100000.00000 -100000.00000 100000 5

1728

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2;

1729

c1 c2 c3 c4

1730

100000.00000 -100000.00000 100000 5

1731

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 LIMIT 2;

1732

c1 c2 c3 c4

1733

100000.00000 -100000.00000 100000 5

1734

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2;

1735

c1 c2 c3 c4

1736

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 LIMIT 2;

1737

c1 c2 c3 c4

1738

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2;

1739

c1 c2 c3 c4

1740

0.00000 -0.10000 -0.1 13

1741

0.00000 0.00000 0 7

1742

100.05000 -100.05000 100.05 1

1743

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 LIMIT 2;

1744

c1 c2 c3 c4

1745

0.00000 -0.10000 -0.1 13

1746

0.00000 0.00000 0 7

1747

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2;

1748

c1 c2 c3 c4

1749

0.00000 0.00000 0 7

1750

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 LIMIT 2;

1751

c1 c2 c3 c4

1752

0.00000 0.00000 0 7

1753

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2;

1754

c1 c2 c3 c4

1755

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

1756

c1 c2 c3 c4

1757

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2;

1758

c1 c2 c3 c4

1759

12345.00000 NULL NULL NULL

1760

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 LIMIT 2;

1761

c1 c2 c3 c4

1762

12345.00000 NULL NULL NULL

1763

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2;

1764

c1 c2 c3 c4

1765

0.00000 -0.10000 -0.1 13

1766

0.00000 0.00000 0 7

1767

1.00000 1.00000 1 10

1768

100.05000 -100.05000 100.05 1

1769

100000.00000 -100000.00000 100000 5

1770

100000.00000 100000.00000 1.11111e+08 19

1771

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

1772

c1 c2 c3 c4

1773

0.00000 -0.10000 -0.1 13

1774

0.00000 0.00000 0 7

1775

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC;

1776

c1 c2 c3 c4

1777

0.00000 0.00000 0 7

1778

0.00000 -0.10000 -0.1 13

1779

1.00000 1.00000 1 10

1780

100.05000 -100.05000 100.05 1

1781

100000.00000 100000.00000 1.11111e+08 19

1782

100000.00000 -100000.00000 100000 5

1783

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1784

c1 c2 c3 c4

1785

0.00000 0.00000 0 7

1786

0.00000 -0.10000 -0.1 13

1787

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC;

1788

c1 c2 c3 c4

1789

0.00000 0.00000 0 7

1790

0.00000 -0.10000 -0.1 13

1791

1.00000 1.00000 1 10

1792

100.05000 -100.05000 100.05 1

1793

100000.00000 100000.00000 1.11111e+08 19

1794

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1795

c1 c2 c3 c4

1796

0.00000 0.00000 0 7

1797

0.00000 -0.10000 -0.1 13

1798

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC;

1799

c1 c2 c3 c4

1800

0.00000 0.00000 0 7

1801

0.00000 -0.10000 -0.1 13

1802

1.00000 1.00000 1 10

1803

100.05000 -100.05000 100.05 1

1804

100000.00000 100000.00000 1.11111e+08 19

1805

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1806

c1 c2 c3 c4

1807

0.00000 0.00000 0 7

1808

0.00000 -0.10000 -0.1 13

1809

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC;

1810

c1 c2 c3 c4

1811

100000.00000 -100000.00000 100000 5

1812

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1813

c1 c2 c3 c4

1814

100000.00000 -100000.00000 100000 5

1815

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC;

1816

c1 c2 c3 c4

1817

100000.00000 -100000.00000 100000 5

1818

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1819

c1 c2 c3 c4

1820

100000.00000 -100000.00000 100000 5

1821

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC;

1822

c1 c2 c3 c4

1823

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1824

c1 c2 c3 c4

1825

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC;

1826

c1 c2 c3 c4

1827

0.00000 0.00000 0 7

1828

0.00000 -0.10000 -0.1 13

1829

100.05000 -100.05000 100.05 1

1830

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC LIMIT 2;

1831

c1 c2 c3 c4

1832

0.00000 0.00000 0 7

1833

0.00000 -0.10000 -0.1 13

1834

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC;

1835

c1 c2 c3 c4

1836

0.00000 0.00000 0 7

1837

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC LIMIT 2;

1838

c1 c2 c3 c4

1839

0.00000 0.00000 0 7

1840

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC;

1841

c1 c2 c3 c4

1842

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

1843

c1 c2 c3 c4

1844

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC;

1845

c1 c2 c3 c4

1846

12345.00000 NULL NULL NULL

1847

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

1848

c1 c2 c3 c4

1849

12345.00000 NULL NULL NULL

1850

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC;

1851

c1 c2 c3 c4

1852

0.00000 0.00000 0 7

1853

0.00000 -0.10000 -0.1 13

1854

1.00000 1.00000 1 10

1855

100.05000 -100.05000 100.05 1

1856

100000.00000 100000.00000 1.11111e+08 19

1857

100000.00000 -100000.00000 100000 5

1858

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

1859

c1 c2 c3 c4

1860

0.00000 0.00000 0 7

1861

0.00000 -0.10000 -0.1 13

1862

SELECT c1 FROM t1 GROUP BY c1;

1863

1864

0.00000

1865

1.00000

1866

100.05000

1867

100000.00000

1868

12345.00000

1869

SELECT DISTINCT c1 FROM t1;

1870

1871

0.00000

1872

1.00000

1873

100.05000

1874

100000.00000

1875

12345.00000

1876

SELECT c1,MIN(c2) FROM t1 GROUP BY c1;

1877

c1 MIN(c2)

1878

0.00000 -0.10000

1879

1.00000 1.00000

1880

100.05000 -100.05000

1881

100000.00000 -100000.00000

1882

12345.00000 NULL

1883

CREATE TABLE t5(c1 FLOAT(23,0) UNSIGNED NOT NULL, c2 FLOAT(23,0) SIGNED NULL, c3 FLOAT, c4 INT, INDEX idx(c1,c2));

1884

INSERT INTO t5 VALUES('1e+22','-1e+22','1e+22',1),('1e-22','-1e-22','1e-22',2);

1885

SELECT * FROM t5;

1886

ALTER TABLE t5 CHANGE c1 c1 FLOAT(24,0) SIGNED NOT NULL, CHANGE c2 c2 FLOAT(24,0) UNSIGNED NULL;

1887

Warnings:

1888

Warning 1264 Out of range value for column 'c2' at row 1

1889

INSERT INTO t5 VALUES('-1e+23','1e+23','1e+23',3),('-1e-23','1e-23','1e-23',4);

1890

SELECT * FROM t5;

1891

ALTER TABLE t5 CHANGE c1 c1 FLOAT(53,0) UNSIGNED, CHANGE c2 c2 FLOAT(53,0) SIGNED;

1892

Warnings:

1893

Warning 1264 Out of range value for column 'c1' at row 3

1894

INSERT INTO t5 VALUES('1e+52','-1e+52','1e+52',5),('1e-52','-1e-52','1e-52',6);

1895

Warnings:

1896

Warning 1264 Out of range value for column 'c3' at row 1

1897

INSERT INTO t5 VALUES('1e+53','-1e+53','1e+53',7),('1e-53','-1e-53','1e-53',8);

1898

Warnings:

1899

Warning 1264 Out of range value for column 'c3' at row 1

1900

SELECT * FROM t5;

1901

c1 c2 c3 c4

1902

# # 0 6

1903

# # 0 8

1904

# # 1e+22 1

1905

# # 1e+23 3

1906

# # 1e-22 2

1907

# # 1e-23 4

1908

# # 3.40282e+38 5

1909

# # 3.40282e+38 7

1910

DROP TABLE t5;

1911

CREATE TABLE t5(c1 FLOAT(16,6), c2 tinyint);

1912

INSERT INTO t5 VALUES(1.1325,3);

1913

SELECT ROUND(c1,c2),TRUNCATE(c1,c2) FROM t5;

1914

ROUND(c1,c2) TRUNCATE(c1,c2)

1915

1.133000 1.132000

1916

DROP TABLE t5;

1917

CREATE TABLE t7(c1 FLOAT(5,10));

1918

ERROR 42000: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'c1').

1919

DROP TABLE t1,t2;

1920

CREATE TABLE t1(c1 DOUBLE(10,5) UNSIGNED NOT NULL, c2 DOUBLE(10,5) SIGNED NULL, c3 DOUBLE, c4 INT, UNIQUE INDEX idx(c1,c2));

1921

CREATE TABLE t2(c1 DOUBLE(10,0) SIGNED NOT NULL, c2 DOUBLE(10,0) UNSIGNED NULL, c3 DOUBLE, c4 INT);

1922

INSERT INTO t1 VALUES('00100.05000','-00100.05000','00100.05000',1);

1923

INSERT INTO t2 VALUES('-1000000000','1000000000','1000000000',2);

1924

INSERT INTO t1(c1) VALUES('12345.000009');

1925

INSERT INTO t1 VALUES('99999.99999','-99999.99999','99999.99999',3);

1926

INSERT INTO t2 VALUES('-9999999999','-9999999999','9999999999',4);

1927

Warnings:

1928

Warning 1264 Out of range value for column 'c2' at row 1

1929

SELECT * FROM t1;

1930

c1 c2 c3 c4

1931

100.05000 -100.05000 100.05 1

1932

12345.00001 NULL NULL NULL

1933

99999.99999 -99999.99999 99999.99999 3

1934

INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);

1935

ERROR 23000: Duplicate entry '99999.99999--99999.99999' for key 'idx'

1936

DELETE FROM t1 WHERE c1='99999.99999' AND c2='-99999.99999';

1937

INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);

1938

Warnings:

1939

Warning 1264 Out of range value for column 'c1' at row 1

1940

Warning 1264 Out of range value for column 'c2' at row 1

1941

INSERT INTO t2 VALUES('10000000000','-10000000000','10000000000',6);

1942

Warnings:

1943

Warning 1264 Out of range value for column 'c1' at row 1

1944

Warning 1264 Out of range value for column 'c2' at row 1

1945

insert into t1 values ("0.0","0.0","0.0",7),("01.0","01.0","01.0",10);

1946

insert into t1 values ("-.1","-.1","-.1",13);

1947

Warnings:

1948

Warning 1264 Out of range value for column 'c1' at row 1

1949

insert into t1 values ("+111111111.11","+111111111.11","+111111111.11",19);

1950

Warnings:

1951

Warning 1264 Out of range value for column 'c1' at row 1

1952

Warning 1264 Out of range value for column 'c2' at row 1

1953

insert into t2 values ("0.0","0.0","0.0",7),("-0.0","-0.0","-0.0",8),("+0.0","+0.0","+0.0",9),("01.0","01.0","01.0",10),("+01.0","+01.0","+01.0",11),("-01.0","-01.0","-01.0",12);

1954

Warnings:

1955

Warning 1264 Out of range value for column 'c2' at row 6

1956

insert into t2 values ("-.1","-.1","-.1",13),("+.1","+.1","+.1",14),(".1",".1",".1",15);

1957

Warnings:

1958

Warning 1264 Out of range value for column 'c2' at row 1

1959

insert into t2 values ("00000000000001","00000000000001","00000000000001",16),("+0000000000001","+0000000000001","+0000000000001",17),("-0000000000001","-0000000000001","-0000000000001",18);

1960

Warnings:

1961

Warning 1264 Out of range value for column 'c2' at row 3

1962

insert into t2 values ("+111111111.11","+111111111.11","+111111111.11",19),("111111111.11","111111111.11","111111111.11",20),("-11111111.11","-11111111.11","-11111111.11",21);

1963

Warnings:

1964

Warning 1264 Out of range value for column 'c2' at row 3

1965

insert into t2 values ("-111111111.11","-111111111.11","-111111111.11",22),("+1111111111.11","+1111111111.11","+1111111111.11",23),("1111111111.11","1111111111.11","1111111111.11",24);

1966

Warnings:

1967

Warning 1264 Out of range value for column 'c2' at row 1

1968

insert into t2 values ("1e+1000","1e+1000","1e+1000",25),("1e-1000","1e-1000","1e-1000",26),("-1e+1000","-1e+1000","-1e+1000",27);

1969

Warnings:

1970

Warning 1264 Out of range value for column 'c1' at row 1

1971

Warning 1264 Out of range value for column 'c1' at row 1

1972

Warning 1264 Out of range value for column 'c2' at row 1

1973

Warning 1264 Out of range value for column 'c2' at row 1

1974

Warning 1264 Out of range value for column 'c3' at row 1

1975

Warning 1264 Out of range value for column 'c1' at row 3

1976

Warning 1264 Out of range value for column 'c1' at row 3

1977

Warning 1264 Out of range value for column 'c2' at row 3

1978

Warning 1264 Out of range value for column 'c2' at row 3

1979

Warning 1264 Out of range value for column 'c3' at row 3

1980

insert into t2 values ("1e+4294967296","1e+4294967296","1e+4294967296",28),("1e-4294967296","1e-4294967296","1e-4294967296",29);

1981

Warnings:

1982

Warning 1264 Out of range value for column 'c1' at row 1

1983

Warning 1264 Out of range value for column 'c1' at row 1

1984

Warning 1264 Out of range value for column 'c2' at row 1

1985

Warning 1264 Out of range value for column 'c2' at row 1

1986

Warning 1264 Out of range value for column 'c3' at row 1

1987

1988

Warnings:

1989

Warning 1264 Out of range value for column 'c1' at row 1

1990

Warning 1264 Out of range value for column 'c1' at row 1

1991

Warning 1264 Out of range value for column 'c2' at row 1

1992

Warning 1264 Out of range value for column 'c2' at row 1

1993

Warning 1264 Out of range value for column 'c3' at row 1

1994

Warning 1264 Out of range value for column 'c1' at row 2

1995

Warning 1264 Out of range value for column 'c1' at row 2

1996

Warning 1264 Out of range value for column 'c2' at row 2

1997

Warning 1264 Out of range value for column 'c2' at row 2

1998

Warning 1264 Out of range value for column 'c3' at row 2

1999

SELECT * FROM t1;

2000

c1 c2 c3 c4

2001

0.00000 -0.10000 -0.1 13

2002

0.00000 0.00000 0 7

2003

1.00000 1.00000 1 10

2004

100.05000 -100.05000 100.05 1

2005

12345.00001 NULL NULL NULL

2006

99999.99999 -99999.99999 100000.000002 5

2007

99999.99999 99999.99999 111111111.11 19

2008

SELECT * FROM t2;

2009

c1 c2 c3 c4

2010

-1 0 -1 12

2011

-1 0 -1 18

2012

-1000000000 1000000000 1000000000 2

2013

-11111111 0 -11111111.11 21

2014

-111111111 0 -111111111.11 22

2015

-9999999999 0 -1.79769313486232e+308 27

2016

-9999999999 0 9999999999 4

2017

0 0 -0 8

2018

0 0 -0.1 13

2019

0 0 0 26

2020

0 0 0 29

2021

0 0 0 32

2022

0 0 0 33

2023

0 0 0 7

2024

0 0 0 9

2025

0 0 0.1 14

2026

0 0 0.1 15

2027

1 1 1 10

2028

1 1 1 11

2029

1 1 1 16

2030

1 1 1 17

2031

111111111 111111111 111111111.11 19

2032

111111111 111111111 111111111.11 20

2033

1111111111 1111111111 1111111111.11 23

2034

1111111111 1111111111 1111111111.11 24

2035

9999999999 0 10000000000 6

2036

9999999999 9999999999 1.79769313486232e+308 25

2037

9999999999 9999999999 1.79769313486232e+308 28

2038

9999999999 9999999999 1.79769313486232e+308 30

2039

9999999999 9999999999 1.79769313486232e+308 31

2040

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t1;

2041

total_rows min_value max_value sum avg

2042

7 0.00000 99999.99999 212446.04999 30349.435712857

2043

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t1;

2044

total_rows min_value max_value sum avg

2045

7 -99999.99999 99999.99999 -99.15000 -16.525000000

2046

SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t1;

2047

total_rows min_value max_value sum avg

2048

7 -0.1 111111111.11 111211212.060002 18535202.0100003

2049

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t2;

2050

total_rows min_value max_value sum avg

2051

30 -9999999999 9999999999 31322222221 1044074074.0333

2052

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t2;

2053

total_rows min_value max_value sum avg

2054

30 0 9999999999 43444444444 1448148148.1333

2055

SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t2;

2056

total_rows min_value max_value sum avg

2057

30 -1.79769313486232e+308 1.79769313486232e+308 inf inf

2058

SELECT * FROM t1;

2059

c1 c2 c3 c4

2060

0.00000 -0.10000 -0.1 13

2061

0.00000 0.00000 0 7

2062

1.00000 1.00000 1 10

2063

100.05000 -100.05000 100.05 1

2064

12345.00001 NULL NULL NULL

2065

99999.99999 -99999.99999 100000.000002 5

2066

99999.99999 99999.99999 111111111.11 19

2067

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;

2068

total_rows min_value max(c1)

2069

7 0.00000 99999.99999

2070

SELECT * FROM t1 WHERE c3 = '0.0';

2071

c1 c2 c3 c4

2072

0.00000 0.00000 0 7

2073

SELECT c1,c2 FROM t1;

2074

c1 c2

2075

0.00000 -0.10000

2076

0.00000 0.00000

2077

1.00000 1.00000

2078

100.05000 -100.05000

2079

12345.00001 NULL

2080

99999.99999 -99999.99999

2081

99999.99999 99999.99999

2082

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

2083

c1 c2

2084

0.00000 0.00000

2085

0.00000 -0.10000

2086

1.00000 1.00000

2087

100.05000 -100.05000

2088

12345.00001 NULL

2089

99999.99999 99999.99999

2090

99999.99999 -99999.99999

2091

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

2092

c1 c2 c3 c4

2093

0.00000 -0.10000 -0.1 13

2094

0.00000 0.00000 0 7

2095

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

2096

c1 c2 c3 c4

2097

0.00000 0.00000 0 7

2098

0.00000 -0.10000 -0.1 13

2099

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2;

2100

c1 c2 c3 c4

2101

0.00000 -0.10000 -0.1 13

2102

0.00000 0.00000 0 7

2103

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 LIMIT 2;

2104

c1 c2 c3 c4

2105

0.00000 -0.10000 -0.1 13

2106

0.00000 0.00000 0 7

2107

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC;

2108

c1 c2 c3 c4

2109

0.00000 0.00000 0 7

2110

0.00000 -0.10000 -0.1 13

2111

SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC LIMIT 2;

2112

c1 c2 c3 c4

2113

0.00000 0.00000 0 7

2114

0.00000 -0.10000 -0.1 13

2115

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2;

2116

c1 c2 c3 c4

2117

1.00000 1.00000 1 10

2118

100.05000 -100.05000 100.05 1

2119

12345.00001 NULL NULL NULL

2120

99999.99999 -99999.99999 100000.000002 5

2121

99999.99999 99999.99999 111111111.11 19

2122

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 LIMIT 2;

2123

c1 c2 c3 c4

2124

1.00000 1.00000 1 10

2125

100.05000 -100.05000 100.05 1

2126

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2;

2127

c1 c2 c3 c4

2128

1.00000 1.00000 1 10

2129

100.05000 -100.05000 100.05 1

2130

12345.00001 NULL NULL NULL

2131

99999.99999 -99999.99999 100000.000002 5

2132

99999.99999 99999.99999 111111111.11 19

2133

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 LIMIT 2;

2134

c1 c2 c3 c4

2135

1.00000 1.00000 1 10

2136

100.05000 -100.05000 100.05 1

2137

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2;

2138

c1 c2 c3 c4

2139

0.00000 -0.10000 -0.1 13

2140

0.00000 0.00000 0 7

2141

1.00000 1.00000 1 10

2142

100.05000 -100.05000 100.05 1

2143

12345.00001 NULL NULL NULL

2144

99999.99999 -99999.99999 100000.000002 5

2145

99999.99999 99999.99999 111111111.11 19

2146

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 LIMIT 2;

2147

c1 c2 c3 c4

2148

0.00000 -0.10000 -0.1 13

2149

0.00000 0.00000 0 7

2150

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2;

2151

c1 c2 c3 c4

2152

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 LIMIT 2;

2153

c1 c2 c3 c4

2154

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2;

2155

c1 c2 c3 c4

2156

0.00000 -0.10000 -0.1 13

2157

0.00000 0.00000 0 7

2158

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 LIMIT 2;

2159

c1 c2 c3 c4

2160

0.00000 -0.10000 -0.1 13

2161

0.00000 0.00000 0 7

2162

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2;

2163

c1 c2 c3 c4

2164

0.00000 -0.10000 -0.1 13

2165

0.00000 0.00000 0 7

2166

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 LIMIT 2;

2167

c1 c2 c3 c4

2168

0.00000 -0.10000 -0.1 13

2169

0.00000 0.00000 0 7

2170

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2;

2171

c1 c2 c3 c4

2172

0.00000 -0.10000 -0.1 13

2173

0.00000 0.00000 0 7

2174

1.00000 1.00000 1 10

2175

100.05000 -100.05000 100.05 1

2176

12345.00001 NULL NULL NULL

2177

99999.99999 -99999.99999 100000.000002 5

2178

99999.99999 99999.99999 111111111.11 19

2179

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;

2180

c1 c2 c3 c4

2181

0.00000 -0.10000 -0.1 13

2182

0.00000 0.00000 0 7

2183

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2;

2184

c1 c2 c3 c4

2185

0.00000 -0.10000 -0.1 13

2186

0.00000 0.00000 0 7

2187

99999.99999 -99999.99999 100000.000002 5

2188

99999.99999 99999.99999 111111111.11 19

2189

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 LIMIT 2;

2190

c1 c2 c3 c4

2191

0.00000 -0.10000 -0.1 13

2192

0.00000 0.00000 0 7

2193

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2;

2194

c1 c2 c3 c4

2195

1.00000 1.00000 1 10

2196

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 LIMIT 2;

2197

c1 c2 c3 c4

2198

1.00000 1.00000 1 10

2199

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;

2200

c1 c2 c3 c4

2201

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;

2202

c1 c2 c3 c4

2203

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;

2204

c1 c2 c3 c4

2205

0.00000 -0.10000 -0.1 13

2206

0.00000 0.00000 0 7

2207

1.00000 1.00000 1 10

2208

100.05000 -100.05000 100.05 1

2209

12345.00001 NULL NULL NULL

2210

99999.99999 -99999.99999 100000.000002 5

2211

99999.99999 99999.99999 111111111.11 19

2212

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

2213

c1 c2 c3 c4

2214

0.00000 -0.10000 -0.1 13

2215

0.00000 0.00000 0 7

2216

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC;

2217

c1 c2 c3 c4

2218

1.00000 1.00000 1 10

2219

100.05000 -100.05000 100.05 1

2220

12345.00001 NULL NULL NULL

2221

99999.99999 99999.99999 111111111.11 19

2222

99999.99999 -99999.99999 100000.000002 5

2223

SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC LIMIT 2;

2224

c1 c2 c3 c4

2225

1.00000 1.00000 1 10

2226

100.05000 -100.05000 100.05 1

2227

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC;

2228

c1 c2 c3 c4

2229

1.00000 1.00000 1 10

2230

100.05000 -100.05000 100.05 1

2231

12345.00001 NULL NULL NULL

2232

99999.99999 99999.99999 111111111.11 19

2233

99999.99999 -99999.99999 100000.000002 5

2234

SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC LIMIT 2;

2235

c1 c2 c3 c4

2236

1.00000 1.00000 1 10

2237

100.05000 -100.05000 100.05 1

2238

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC;

2239

c1 c2 c3 c4

2240

0.00000 0.00000 0 7

2241

0.00000 -0.10000 -0.1 13

2242

1.00000 1.00000 1 10

2243

100.05000 -100.05000 100.05 1

2244

12345.00001 NULL NULL NULL

2245

99999.99999 99999.99999 111111111.11 19

2246

99999.99999 -99999.99999 100000.000002 5

2247

SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC LIMIT 2;

2248

c1 c2 c3 c4

2249

0.00000 0.00000 0 7

2250

0.00000 -0.10000 -0.1 13

2251

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC;

2252

c1 c2 c3 c4

2253

SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC LIMIT 2;

2254

c1 c2 c3 c4

2255

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC;

2256

c1 c2 c3 c4

2257

0.00000 0.00000 0 7

2258

0.00000 -0.10000 -0.1 13

2259

SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC LIMIT 2;

2260

c1 c2 c3 c4

2261

0.00000 0.00000 0 7

2262

0.00000 -0.10000 -0.1 13

2263

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC;

2264

c1 c2 c3 c4

2265

0.00000 0.00000 0 7

2266

0.00000 -0.10000 -0.1 13

2267

SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC LIMIT 2;

2268

c1 c2 c3 c4

2269

0.00000 0.00000 0 7

2270

0.00000 -0.10000 -0.1 13

2271

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC;

2272

c1 c2 c3 c4

2273

0.00000 0.00000 0 7

2274

0.00000 -0.10000 -0.1 13

2275

1.00000 1.00000 1 10

2276

100.05000 -100.05000 100.05 1

2277

12345.00001 NULL NULL NULL

2278

99999.99999 99999.99999 111111111.11 19

2279

99999.99999 -99999.99999 100000.000002 5

2280

SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2281

c1 c2 c3 c4

2282

0.00000 0.00000 0 7

2283

0.00000 -0.10000 -0.1 13

2284

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC;

2285

c1 c2 c3 c4

2286

0.00000 0.00000 0 7

2287

0.00000 -0.10000 -0.1 13

2288

99999.99999 99999.99999 111111111.11 19

2289

99999.99999 -99999.99999 100000.000002 5

2290

SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;

2291

c1 c2 c3 c4

2292

0.00000 0.00000 0 7

2293

0.00000 -0.10000 -0.1 13

2294

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC;

2295

c1 c2 c3 c4

2296

1.00000 1.00000 1 10

2297

SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC LIMIT 2;

2298

c1 c2 c3 c4

2299

1.00000 1.00000 1 10

2300

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;

2301

c1 c2 c3 c4

2302

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

2303

c1 c2 c3 c4

2304

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;

2305

c1 c2 c3 c4

2306

0.00000 0.00000 0 7

2307

0.00000 -0.10000 -0.1 13

2308

1.00000 1.00000 1 10

2309

100.05000 -100.05000 100.05 1

2310

12345.00001 NULL NULL NULL

2311

99999.99999 99999.99999 111111111.11 19

2312

99999.99999 -99999.99999 100000.000002 5

2313

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

2314

c1 c2 c3 c4

2315

0.00000 0.00000 0 7

2316

0.00000 -0.10000 -0.1 13

2317

SELECT * FROM t1;

2318

c1 c2 c3 c4

2319

0.00000 -0.10000 -0.1 13

2320

0.00000 0.00000 0 7

2321

1.00000 1.00000 1 10

2322

100.05000 -100.05000 100.05 1

2323

12345.00001 NULL NULL NULL

2324

99999.99999 -99999.99999 100000.000002 5

2325

99999.99999 99999.99999 111111111.11 19

2326

SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;

2327

total_rows min_value max(c1)

2328

7 0.00000 99999.99999

2329

SELECT * FROM t1 WHERE c3 = '-0.0';

2330

c1 c2 c3 c4

2331

0.00000 0.00000 0 7

2332

SELECT c1,c2 FROM t1;

2333

c1 c2

2334

0.00000 -0.10000

2335

0.00000 0.00000

2336

1.00000 1.00000

2337

100.05000 -100.05000

2338

12345.00001 NULL

2339

99999.99999 -99999.99999

2340

99999.99999 99999.99999

2341

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

2342

c1 c2

2343

0.00000 0.00000

2344

0.00000 -0.10000

2345

1.00000 1.00000

2346

100.05000 -100.05000

2347

12345.00001 NULL

2348

99999.99999 99999.99999

2349

99999.99999 -99999.99999

2350

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

2351

c1 c2 c3 c4

2352

0.00000 -0.10000 -0.1 13

2353

0.00000 0.00000 0 7

2354

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

2355

c1 c2 c3 c4

2356

0.00000 0.00000 0 7

2357

0.00000 -0.10000 -0.1 13

2358

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2;

2359

c1 c2 c3 c4

2360

99999.99999 -99999.99999 100000.000002 5

2361

99999.99999 99999.99999 111111111.11 19

2362

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

2363

c1 c2 c3 c4

2364

99999.99999 -99999.99999 100000.000002 5

2365

99999.99999 99999.99999 111111111.11 19

2366

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC;

2367

c1 c2 c3 c4

2368

99999.99999 99999.99999 111111111.11 19

2369

99999.99999 -99999.99999 100000.000002 5

2370

SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2371

c1 c2 c3 c4

2372

99999.99999 99999.99999 111111111.11 19

2373

99999.99999 -99999.99999 100000.000002 5

2374

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2;

2375

c1 c2 c3 c4

2376

0.00000 -0.10000 -0.1 13

2377

0.00000 0.00000 0 7

2378

1.00000 1.00000 1 10

2379

100.05000 -100.05000 100.05 1

2380

12345.00001 NULL NULL NULL

2381

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 LIMIT 2;

2382

c1 c2 c3 c4

2383

0.00000 -0.10000 -0.1 13

2384

0.00000 0.00000 0 7

2385

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2;

2386

c1 c2 c3 c4

2387

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 LIMIT 2;

2388

c1 c2 c3 c4

2389

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2;

2390

c1 c2 c3 c4

2391

99999.99999 -99999.99999 100000.000002 5

2392

99999.99999 99999.99999 111111111.11 19

2393

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 LIMIT 2;

2394

c1 c2 c3 c4

2395

99999.99999 -99999.99999 100000.000002 5

2396

99999.99999 99999.99999 111111111.11 19

2397

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2;

2398

c1 c2 c3 c4

2399

0.00000 -0.10000 -0.1 13

2400

0.00000 0.00000 0 7

2401

1.00000 1.00000 1 10

2402

100.05000 -100.05000 100.05 1

2403

12345.00001 NULL NULL NULL

2404

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 LIMIT 2;

2405

c1 c2 c3 c4

2406

0.00000 -0.10000 -0.1 13

2407

0.00000 0.00000 0 7

2408

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2;

2409

c1 c2 c3 c4

2410

0.00000 -0.10000 -0.1 13

2411

0.00000 0.00000 0 7

2412

1.00000 1.00000 1 10

2413

100.05000 -100.05000 100.05 1

2414

12345.00001 NULL NULL NULL

2415

99999.99999 -99999.99999 100000.000002 5

2416

99999.99999 99999.99999 111111111.11 19

2417

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 LIMIT 2;

2418

c1 c2 c3 c4

2419

0.00000 -0.10000 -0.1 13

2420

0.00000 0.00000 0 7

2421

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2;

2422

c1 c2 c3 c4

2423

99999.99999 -99999.99999 100000.000002 5

2424

99999.99999 99999.99999 111111111.11 19

2425

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 LIMIT 2;

2426

c1 c2 c3 c4

2427

99999.99999 -99999.99999 100000.000002 5

2428

99999.99999 99999.99999 111111111.11 19

2429

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2;

2430

c1 c2 c3 c4

2431

100.05000 -100.05000 100.05 1

2432

12345.00001 NULL NULL NULL

2433

99999.99999 -99999.99999 100000.000002 5

2434

99999.99999 99999.99999 111111111.11 19

2435

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;

2436

c1 c2 c3 c4

2437

100.05000 -100.05000 100.05 1

2438

12345.00001 NULL NULL NULL

2439

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2;

2440

c1 c2 c3 c4

2441

100.05000 -100.05000 100.05 1

2442

99999.99999 -99999.99999 100000.000002 5

2443

99999.99999 99999.99999 111111111.11 19

2444

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 LIMIT 2;

2445

c1 c2 c3 c4

2446

100.05000 -100.05000 100.05 1

2447

99999.99999 -99999.99999 100000.000002 5

2448

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2;

2449

c1 c2 c3 c4

2450

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

2451

c1 c2 c3 c4

2452

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;

2453

c1 c2 c3 c4

2454

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;

2455

c1 c2 c3 c4

2456

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;

2457

c1 c2 c3 c4

2458

0.00000 -0.10000 -0.1 13

2459

0.00000 0.00000 0 7

2460

1.00000 1.00000 1 10

2461

100.05000 -100.05000 100.05 1

2462

12345.00001 NULL NULL NULL

2463

99999.99999 -99999.99999 100000.000002 5

2464

99999.99999 99999.99999 111111111.11 19

2465

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

2466

c1 c2 c3 c4

2467

0.00000 -0.10000 -0.1 13

2468

0.00000 0.00000 0 7

2469

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC;

2470

c1 c2 c3 c4

2471

0.00000 0.00000 0 7

2472

0.00000 -0.10000 -0.1 13

2473

1.00000 1.00000 1 10

2474

100.05000 -100.05000 100.05 1

2475

12345.00001 NULL NULL NULL

2476

SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2477

c1 c2 c3 c4

2478

0.00000 0.00000 0 7

2479

0.00000 -0.10000 -0.1 13

2480

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC;

2481

c1 c2 c3 c4

2482

SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2483

c1 c2 c3 c4

2484

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC;

2485

c1 c2 c3 c4

2486

99999.99999 99999.99999 111111111.11 19

2487

99999.99999 -99999.99999 100000.000002 5

2488

SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2489

c1 c2 c3 c4

2490

99999.99999 99999.99999 111111111.11 19

2491

99999.99999 -99999.99999 100000.000002 5

2492

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC;

2493

c1 c2 c3 c4

2494

0.00000 0.00000 0 7

2495

0.00000 -0.10000 -0.1 13

2496

1.00000 1.00000 1 10

2497

100.05000 -100.05000 100.05 1

2498

12345.00001 NULL NULL NULL

2499

SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2500

c1 c2 c3 c4

2501

0.00000 0.00000 0 7

2502

0.00000 -0.10000 -0.1 13

2503

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC;

2504

c1 c2 c3 c4

2505

0.00000 0.00000 0 7

2506

0.00000 -0.10000 -0.1 13

2507

1.00000 1.00000 1 10

2508

100.05000 -100.05000 100.05 1

2509

12345.00001 NULL NULL NULL

2510

99999.99999 99999.99999 111111111.11 19

2511

99999.99999 -99999.99999 100000.000002 5

2512

SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2513

c1 c2 c3 c4

2514

0.00000 0.00000 0 7

2515

0.00000 -0.10000 -0.1 13

2516

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC;

2517

c1 c2 c3 c4

2518

99999.99999 99999.99999 111111111.11 19

2519

99999.99999 -99999.99999 100000.000002 5

2520

SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2521

c1 c2 c3 c4

2522

99999.99999 99999.99999 111111111.11 19

2523

99999.99999 -99999.99999 100000.000002 5

2524

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC;

2525

c1 c2 c3 c4

2526

100.05000 -100.05000 100.05 1

2527

12345.00001 NULL NULL NULL

2528

99999.99999 99999.99999 111111111.11 19

2529

99999.99999 -99999.99999 100000.000002 5

2530

SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2531

c1 c2 c3 c4

2532

100.05000 -100.05000 100.05 1

2533

12345.00001 NULL NULL NULL

2534

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC;

2535

c1 c2 c3 c4

2536

100.05000 -100.05000 100.05 1

2537

99999.99999 99999.99999 111111111.11 19

2538

99999.99999 -99999.99999 100000.000002 5

2539

SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;

2540

c1 c2 c3 c4

2541

100.05000 -100.05000 100.05 1

2542

99999.99999 99999.99999 111111111.11 19

2543

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC;

2544

c1 c2 c3 c4

2545

SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2546

c1 c2 c3 c4

2547

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;

2548

c1 c2 c3 c4

2549

SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

2550

c1 c2 c3 c4

2551

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;

2552

c1 c2 c3 c4

2553

0.00000 0.00000 0 7

2554

0.00000 -0.10000 -0.1 13

2555

1.00000 1.00000 1 10

2556

100.05000 -100.05000 100.05 1

2557

12345.00001 NULL NULL NULL

2558

99999.99999 99999.99999 111111111.11 19

2559

99999.99999 -99999.99999 100000.000002 5

2560

SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

2561

c1 c2 c3 c4

2562

0.00000 0.00000 0 7

2563

0.00000 -0.10000 -0.1 13

2564

SELECT * FROM t1;

2565

c1 c2 c3 c4

2566

0.00000 -0.10000 -0.1 13

2567

0.00000 0.00000 0 7

2568

1.00000 1.00000 1 10

2569

100.05000 -100.05000 100.05 1

2570

12345.00001 NULL NULL NULL

2571

99999.99999 -99999.99999 100000.000002 5

2572

99999.99999 99999.99999 111111111.11 19

2573

SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t1;

2574

total_rows min_value max(c2)

2575

7 -99999.99999 99999.99999

2576

SELECT * FROM t1 WHERE c3 = '-0.0';

2577

c1 c2 c3 c4

2578

0.00000 0.00000 0 7

2579

SELECT c1,c2 FROM t1;

2580

c1 c2

2581

0.00000 -0.10000

2582

0.00000 0.00000

2583

1.00000 1.00000

2584

100.05000 -100.05000

2585

12345.00001 NULL

2586

99999.99999 -99999.99999

2587

99999.99999 99999.99999

2588

SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;

2589

c1 c2

2590

0.00000 0.00000

2591

0.00000 -0.10000

2592

1.00000 1.00000

2593

100.05000 -100.05000

2594

12345.00001 NULL

2595

99999.99999 99999.99999

2596

99999.99999 -99999.99999

2597

SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;

2598

c1 c2 c3 c4

2599

0.00000 -0.10000 -0.1 13

2600

0.00000 0.00000 0 7

2601

SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;

2602

c1 c2 c3 c4

2603

0.00000 0.00000 0 7

2604

0.00000 -0.10000 -0.1 13

2605

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2;

2606

c1 c2 c3 c4

2607

99999.99999 -99999.99999 100000.000002 5

2608

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 LIMIT 2;

2609

c1 c2 c3 c4

2610

99999.99999 -99999.99999 100000.000002 5

2611

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC;

2612

c1 c2 c3 c4

2613

99999.99999 -99999.99999 100000.000002 5

2614

SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2615

c1 c2 c3 c4

2616

99999.99999 -99999.99999 100000.000002 5

2617

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2;

2618

c1 c2 c3 c4

2619

0.00000 -0.10000 -0.1 13

2620

0.00000 0.00000 0 7

2621

1.00000 1.00000 1 10

2622

100.05000 -100.05000 100.05 1

2623

99999.99999 99999.99999 111111111.11 19

2624

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 LIMIT 2;

2625

c1 c2 c3 c4

2626

0.00000 -0.10000 -0.1 13

2627

0.00000 0.00000 0 7

2628

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2;

2629

c1 c2 c3 c4

2630

0.00000 -0.10000 -0.1 13

2631

0.00000 0.00000 0 7

2632

1.00000 1.00000 1 10

2633

100.05000 -100.05000 100.05 1

2634

99999.99999 99999.99999 111111111.11 19

2635

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 LIMIT 2;

2636

c1 c2 c3 c4

2637

0.00000 -0.10000 -0.1 13

2638

0.00000 0.00000 0 7

2639

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2;

2640

c1 c2 c3 c4

2641

0.00000 -0.10000 -0.1 13

2642

0.00000 0.00000 0 7

2643

1.00000 1.00000 1 10

2644

100.05000 -100.05000 100.05 1

2645

99999.99999 -99999.99999 100000.000002 5

2646

99999.99999 99999.99999 111111111.11 19

2647

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 LIMIT 2;

2648

c1 c2 c3 c4

2649

0.00000 -0.10000 -0.1 13

2650

0.00000 0.00000 0 7

2651

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2;

2652

c1 c2 c3 c4

2653

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 LIMIT 2;

2654

c1 c2 c3 c4

2655

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2;

2656

c1 c2 c3 c4

2657

99999.99999 -99999.99999 100000.000002 5

2658

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 LIMIT 2;

2659

c1 c2 c3 c4

2660

99999.99999 -99999.99999 100000.000002 5

2661

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2;

2662

c1 c2 c3 c4

2663

99999.99999 -99999.99999 100000.000002 5

2664

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 LIMIT 2;

2665

c1 c2 c3 c4

2666

99999.99999 -99999.99999 100000.000002 5

2667

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2;

2668

c1 c2 c3 c4

2669

0.00000 -0.10000 -0.1 13

2670

0.00000 0.00000 0 7

2671

100.05000 -100.05000 100.05 1

2672

99999.99999 -99999.99999 100000.000002 5

2673

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 LIMIT 2;

2674

c1 c2 c3 c4

2675

0.00000 -0.10000 -0.1 13

2676

0.00000 0.00000 0 7

2677

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2;

2678

c1 c2 c3 c4

2679

0.00000 0.00000 0 7

2680

99999.99999 -99999.99999 100000.000002 5

2681

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 LIMIT 2;

2682

c1 c2 c3 c4

2683

0.00000 0.00000 0 7

2684

99999.99999 -99999.99999 100000.000002 5

2685

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2;

2686

c1 c2 c3 c4

2687

99999.99999 -99999.99999 100000.000002 5

2688

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;

2689

c1 c2 c3 c4

2690

99999.99999 -99999.99999 100000.000002 5

2691

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2;

2692

c1 c2 c3 c4

2693

12345.00001 NULL NULL NULL

2694

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 LIMIT 2;

2695

c1 c2 c3 c4

2696

12345.00001 NULL NULL NULL

2697

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2;

2698

c1 c2 c3 c4

2699

0.00000 -0.10000 -0.1 13

2700

0.00000 0.00000 0 7

2701

1.00000 1.00000 1 10

2702

100.05000 -100.05000 100.05 1

2703

99999.99999 -99999.99999 100000.000002 5

2704

99999.99999 99999.99999 111111111.11 19

2705

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 LIMIT 2;

2706

c1 c2 c3 c4

2707

0.00000 -0.10000 -0.1 13

2708

0.00000 0.00000 0 7

2709

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC;

2710

c1 c2 c3 c4

2711

0.00000 0.00000 0 7

2712

0.00000 -0.10000 -0.1 13

2713

1.00000 1.00000 1 10

2714

100.05000 -100.05000 100.05 1

2715

99999.99999 99999.99999 111111111.11 19

2716

SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2717

c1 c2 c3 c4

2718

0.00000 0.00000 0 7

2719

0.00000 -0.10000 -0.1 13

2720

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC;

2721

c1 c2 c3 c4

2722

0.00000 0.00000 0 7

2723

0.00000 -0.10000 -0.1 13

2724

1.00000 1.00000 1 10

2725

100.05000 -100.05000 100.05 1

2726

99999.99999 99999.99999 111111111.11 19

2727

SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2728

c1 c2 c3 c4

2729

0.00000 0.00000 0 7

2730

0.00000 -0.10000 -0.1 13

2731

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC;

2732

c1 c2 c3 c4

2733

0.00000 0.00000 0 7

2734

0.00000 -0.10000 -0.1 13

2735

1.00000 1.00000 1 10

2736

100.05000 -100.05000 100.05 1

2737

99999.99999 99999.99999 111111111.11 19

2738

99999.99999 -99999.99999 100000.000002 5

2739

SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2740

c1 c2 c3 c4

2741

0.00000 0.00000 0 7

2742

0.00000 -0.10000 -0.1 13

2743

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC;

2744

c1 c2 c3 c4

2745

SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2746

c1 c2 c3 c4

2747

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC;

2748

c1 c2 c3 c4

2749

99999.99999 -99999.99999 100000.000002 5

2750

SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2751

c1 c2 c3 c4

2752

99999.99999 -99999.99999 100000.000002 5

2753

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC;

2754

c1 c2 c3 c4

2755

99999.99999 -99999.99999 100000.000002 5

2756

SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2757

c1 c2 c3 c4

2758

99999.99999 -99999.99999 100000.000002 5

2759

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC;

2760

c1 c2 c3 c4

2761

0.00000 0.00000 0 7

2762

0.00000 -0.10000 -0.1 13

2763

100.05000 -100.05000 100.05 1

2764

99999.99999 -99999.99999 100000.000002 5

2765

SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC LIMIT 2;

2766

c1 c2 c3 c4

2767

0.00000 0.00000 0 7

2768

0.00000 -0.10000 -0.1 13

2769

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC;

2770

c1 c2 c3 c4

2771

0.00000 0.00000 0 7

2772

99999.99999 -99999.99999 100000.000002 5

2773

SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC LIMIT 2;

2774

c1 c2 c3 c4

2775

0.00000 0.00000 0 7

2776

99999.99999 -99999.99999 100000.000002 5

2777

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC;

2778

c1 c2 c3 c4

2779

99999.99999 -99999.99999 100000.000002 5

2780

SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;

2781

c1 c2 c3 c4

2782

99999.99999 -99999.99999 100000.000002 5

2783

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC;

2784

c1 c2 c3 c4

2785

12345.00001 NULL NULL NULL

2786

SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC LIMIT 2;

2787

c1 c2 c3 c4

2788

12345.00001 NULL NULL NULL

2789

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC;

2790

c1 c2 c3 c4

2791

0.00000 0.00000 0 7

2792

0.00000 -0.10000 -0.1 13

2793

1.00000 1.00000 1 10

2794

100.05000 -100.05000 100.05 1

2795

99999.99999 99999.99999 111111111.11 19

2796

99999.99999 -99999.99999 100000.000002 5

2797

SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;

2798

c1 c2 c3 c4

2799

0.00000 0.00000 0 7

2800

0.00000 -0.10000 -0.1 13

2801

SELECT c1 FROM t1 GROUP BY c1;

2802

2803

0.00000

2804

1.00000

2805

100.05000

2806

12345.00001

2807

99999.99999

2808

SELECT DISTINCT c1 FROM t1;

2809

2810

0.00000

2811

1.00000

2812

100.05000

2813

12345.00001

2814

99999.99999

2815

SELECT c1,MIN(c2) FROM t1 GROUP BY c1;

2816

c1 MIN(c2)

2817

0.00000 -0.10000

2818

1.00000 1.00000

2819

100.05000 -100.05000

2820

12345.00001 NULL

2821

99999.99999 -99999.99999

2822

CREATE TABLE t5(c1 DOUBLE(23,0) UNSIGNED NOT NULL, c2 DOUBLE(23,0) SIGNED NULL, c3 DOUBLE, c4 INT, INDEX idx(c1,c2));

2823

INSERT INTO t5 VALUES('1e+22','-1e+22','1e+22',1),('1e-22','-1e-22','1e-22',2);

2824

SELECT * FROM t5;

2825

c1 c2 c3 c4

2826

0 0 1e-22 2

2827

10000000000000000000000 -10000000000000000000000 1e+22 1

2828

ALTER TABLE t5 CHANGE c1 c1 DOUBLE(24,0) SIGNED NOT NULL, CHANGE c2 c2 DOUBLE(24,0) UNSIGNED NULL;

2829

Warnings:

2830

Warning 1264 Out of range value for column 'c2' at row 1

2831

INSERT INTO t5 VALUES('-1e+23','1e+23','1e+23',3),('-1e-23','1e-23','1e-23',4);

2832

SELECT * FROM t5;

2833

ALTER TABLE t5 CHANGE c1 c1 DOUBLE(53,0) UNSIGNED, CHANGE c2 c2 DOUBLE(53,0) SIGNED;

2834

Warnings:

2835

Warning 1264 Out of range value for column 'c1' at row 3

2836

INSERT INTO t5 VALUES('1e+52','-1e+52','1e+52',5),('1e-52','-1e-52','1e-52',6);

2837

INSERT INTO t5 VALUES('1e+53','-1e+53','1e+53',7),('1e-53','-1e-53','1e-53',8);

2838

SELECT * FROM t5;

2839

DROP TABLE t5;

2840

CREATE TABLE t5(c1 DOUBLE(16,6), c2 tinyint);

2841

INSERT INTO t5 VALUES(1.1325,3);

2842

SELECT ROUND(c1,c2),TRUNCATE(c1,c2) FROM t5;

2843

ROUND(c1,c2) TRUNCATE(c1,c2)

2844

1.132000 1.132000

2845

DROP TABLE t5;

2846

CREATE TABLE t7(c1 DOUBLE(5,10));

2847

ERROR 42000: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'c1').

2848

DROP TABLE t1,t2;

Older »