← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_length.test

  • Committer: Brian Aker
  • Date: 2009-07-12 19:26:42 UTC
  • mfrom: (1093.1.8 captain)
  • Revision ID: brian@gaz-20090712192642-xtw1hqcs4z9pxfex
Merge Jay

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_length.test
 
1
CREATE TABLE t1 (a int auto_increment primary key, v varchar(255));
 
2
INSERT INTO t1 (v) VALUES
 
3
 (NULL),
 
4
 (''),
 
5
 (0),
 
6
 ('abc'),
 
7
 ('你好'),
 
8
 ('☃');
 
9
 
 
10
#
 
11
# Verify LENGTH, OCTET_LENGTH
 
12
#
 
13
SELECT LENGTH(NULL), OCTET_LENGTH(NULL);
 
14
SELECT LENGTH(''), OCTET_LENGTH('');
 
15
SELECT LENGTH('0'), OCTET_LENGTH('0');
 
16
SELECT LENGTH('abc'), OCTET_LENGTH('abc');
 
17
SELECT LENGTH('你好'), OCTET_LENGTH('你好');
 
18
SELECT LENGTH('☃'), OCTET_LENGTH('☃');
 
19
SELECT a, v, LENGTH(v), OCTET_LENGTH(v) FROM t1;
 
20
 
 
21
#
 
22
# Verify CHAR_LENGTH, CHARACTER_LENGTH
 
23
#
 
24
SELECT CHAR_LENGTH(NULL), CHARACTER_LENGTH(NULL);
 
25
SELECT CHAR_LENGTH(''), CHARACTER_LENGTH('');
 
26
SELECT CHAR_LENGTH('0'), CHARACTER_LENGTH('0');
 
27
SELECT CHAR_LENGTH('abc'), CHARACTER_LENGTH('abc');
 
28
SELECT CHAR_LENGTH('你好'), CHARACTER_LENGTH('你好');
 
29
SELECT CHAR_LENGTH('☃'), CHARACTER_LENGTH('☃');
 
30
SELECT A, V, CHAR_LENGTH(V), CHARACTER_LENGTH(v) from t1;
 
31
 
 
32
DROP TABLE IF EXISTS t1;