~drizzle-trunk/drizzle/development : contents of tests/r/round.result at revision 1019.1.5

~drizzle-trunk/drizzle/development : (revision 1019.1.5)

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (sint8 int not null);
INSERT INTO t1 VALUES ('0.1');
INSERT INTO t1 VALUES ('0.5');
INSERT INTO t1 VALUES ('127.4');
INSERT INTO t1 VALUES ('127.5');
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
INSERT INTO t1 VALUES ('-127.4');
INSERT INTO t1 VALUES ('-127.5');
INSERT INTO t1 VALUES ('-128.4');
INSERT INTO t1 VALUES ('-128.5');
SELECT * FROM t1;
sint8
0
1
127
128
0
-1
-127
-128
-128
-129
DROP TABLE t1;
CREATE TABLE t1 (uint8 int not null);
INSERT INTO t1 VALUES ('0.1');
INSERT INTO t1 VALUES ('0.5');
INSERT INTO t1 VALUES ('127.4');
INSERT INTO t1 VALUES ('127.5');
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
INSERT INTO t1 VALUES ('255.4');
INSERT INTO t1 VALUES ('255.5');
SELECT * FROM t1;
uint8
0
1
127
128
0
-1
255
256
DROP TABLE t1;
CREATE TABLE t1 (sint16 int not null);
INSERT INTO t1 VALUES ('0.1');
INSERT INTO t1 VALUES ('0.5');
INSERT INTO t1 VALUES ('32767.4');
INSERT INTO t1 VALUES ('32767.5');
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
INSERT INTO t1 VALUES ('-32767.4');
INSERT INTO t1 VALUES ('-32767.5');
INSERT INTO t1 VALUES ('-32768.4');
INSERT INTO t1 VALUES ('-32768.5');
SELECT * FROM t1;
sint16
0
1
32767
32768
0
-1
-32767
-32768
-32768
-32769
DROP TABLE t1;
CREATE TABLE t1 (uint16 int not null);
INSERT INTO t1 VALUES ('0.1');
INSERT INTO t1 VALUES ('0.5');
INSERT INTO t1 VALUES ('32767.4');
INSERT INTO t1 VALUES ('32767.5');
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
INSERT INTO t1 VALUES ('65535.4');
INSERT INTO t1 VALUES ('65535.5');
SELECT * FROM t1;
uint16
0
1
32767
32768
0
-1
65535
65536
DROP TABLE t1;
CREATE TABLE t1 (sint24 int not null);
INSERT INTO t1 VALUES ('0.1');
INSERT INTO t1 VALUES ('0.5');
INSERT INTO t1 VALUES ('8388607.4');
INSERT INTO t1 VALUES ('8388607.5');
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
INSERT INTO t1 VALUES ('-8388607.4');
INSERT INTO t1 VALUES ('-8388607.5');
INSERT INTO t1 VALUES ('-8388608.4');
INSERT INTO t1 VALUES ('-8388608.5');
SELECT * FROM t1;
sint24
0
1
8388607
8388608
0
-1
-8388607
-8388608
-8388608
-8388609
DROP TABLE t1;
CREATE TABLE t1 (uint24 int not null);
INSERT INTO t1 VALUES ('0.1');
INSERT INTO t1 VALUES ('0.5');
INSERT INTO t1 VALUES ('8388607.4');
INSERT INTO t1 VALUES ('8388607.5');
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
INSERT INTO t1 VALUES ('16777215.4');
INSERT INTO t1 VALUES ('16777215.5');
SELECT * FROM t1;
uint24
0
1
8388607
8388608
0
-1
16777215
16777216
DROP TABLE t1;
CREATE TABLE t1 (sint64 bigint not null);
INSERT INTO t1 VALUES ('0.1');
INSERT INTO t1 VALUES ('0.5');
INSERT INTO t1 VALUES ('9223372036854775807.4');
INSERT INTO t1 VALUES ('9223372036854775806.5');
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
INSERT INTO t1 VALUES ('-9223372036854775807.4');
INSERT INTO t1 VALUES ('-9223372036854775807.5');
INSERT INTO t1 VALUES ('-9223372036854775808.4');
INSERT INTO t1 VALUES ('-9223372036854775802.5');
SELECT * FROM t1;
sint64
0
1
9223372036854775807
9223372036854775807
0
-1
-9223372036854775807
-9223372036854775808
-9223372036854775808
-9223372036854775803
DROP TABLE t1;
CREATE TABLE t1 (uint64 bigint not null);
INSERT INTO t1 VALUES ('0.1');
INSERT INTO t1 VALUES ('0.5');
INSERT INTO t1 VALUES ('9223372036854775807.4');
INSERT INTO t1 VALUES ('9223372036854775807.5');
ERROR 22003: Out of range value for column 'uint64' at row 1
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
INSERT INTO t1 VALUES ('18446744073709551615.4');
ERROR 22003: Out of range value for column 'uint64' at row 1
SELECT * FROM t1;
uint64
0
1
9223372036854775807
0
-1
DROP TABLE t1;
CREATE TABLE t1 (str varchar(128), sint64 bigint not null default 0);
INSERT INTO t1 (str) VALUES ('1.5');
INSERT INTO t1 (str) VALUES ('1.00005e4');
INSERT INTO t1 (str) VALUES ('1.0005e3');
INSERT INTO t1 (str) VALUES ('1.005e2');
INSERT INTO t1 (str) VALUES ('1.05e1');
INSERT INTO t1 (str) VALUES ('1.5e0');
INSERT INTO t1 (str) VALUES ('100005e-1');
INSERT INTO t1 (str) VALUES ('100050e-2');
INSERT INTO t1 (str) VALUES ('100500e-3');
INSERT INTO t1 (str) VALUES ('105000e-4');
INSERT INTO t1 (str) VALUES ('150000e-5');
UPDATE t1 SET sint64=str;
SELECT * FROM t1;
str	sint64
1.5	2
1.00005e4	10001
1.0005e3	1001
1.005e2	101
1.05e1	11
1.5e0	2
100005e-1	10001
100050e-2	1001
100500e-3	101
105000e-4	11
150000e-5	2
DROP TABLE t1;

1 by brian clean slate	1	DROP TABLE IF EXISTS t1;
520.1.10 by Brian Aker Adding back more tests.	2	CREATE TABLE t1 (sint8 int not null);
1 by brian clean slate	3	INSERT INTO t1 VALUES ('0.1');
	4	INSERT INTO t1 VALUES ('0.5');
	5	INSERT INTO t1 VALUES ('127.4');
	6	INSERT INTO t1 VALUES ('127.5');
	7	INSERT INTO t1 VALUES ('-0.1');
	8	INSERT INTO t1 VALUES ('-0.5');
	9	INSERT INTO t1 VALUES ('-127.4');
	10	INSERT INTO t1 VALUES ('-127.5');
	11	INSERT INTO t1 VALUES ('-128.4');
	12	INSERT INTO t1 VALUES ('-128.5');
	13	SELECT * FROM t1;
	14	sint8
	15	0
	16	1
	17	127
520.1.10 by Brian Aker Adding back more tests.	18	128
1 by brian clean slate	19	0
	20	-1
	21	-127
	22	-128
	23	-128
520.1.10 by Brian Aker Adding back more tests.	24	-129
1 by brian clean slate	25	DROP TABLE t1;
520.1.10 by Brian Aker Adding back more tests.	26	CREATE TABLE t1 (uint8 int not null);
1 by brian clean slate	27	INSERT INTO t1 VALUES ('0.1');
	28	INSERT INTO t1 VALUES ('0.5');
	29	INSERT INTO t1 VALUES ('127.4');
	30	INSERT INTO t1 VALUES ('127.5');
	31	INSERT INTO t1 VALUES ('-0.1');
	32	INSERT INTO t1 VALUES ('-0.5');
	33	INSERT INTO t1 VALUES ('255.4');
	34	INSERT INTO t1 VALUES ('255.5');
	35	SELECT * FROM t1;
	36	uint8
	37	0
	38	1
	39	127
	40	128
	41	0
520.1.10 by Brian Aker Adding back more tests.	42	-1
	43	255
	44	256
1 by brian clean slate	45	DROP TABLE t1;
520.1.10 by Brian Aker Adding back more tests.	46	CREATE TABLE t1 (sint16 int not null);
1 by brian clean slate	47	INSERT INTO t1 VALUES ('0.1');
	48	INSERT INTO t1 VALUES ('0.5');
	49	INSERT INTO t1 VALUES ('32767.4');
	50	INSERT INTO t1 VALUES ('32767.5');
	51	INSERT INTO t1 VALUES ('-0.1');
	52	INSERT INTO t1 VALUES ('-0.5');
	53	INSERT INTO t1 VALUES ('-32767.4');
	54	INSERT INTO t1 VALUES ('-32767.5');
	55	INSERT INTO t1 VALUES ('-32768.4');
	56	INSERT INTO t1 VALUES ('-32768.5');
	57	SELECT * FROM t1;
	58	sint16
	59	0
	60	1
	61	32767
520.1.10 by Brian Aker Adding back more tests.	62	32768
1 by brian clean slate	63	0
	64	-1
	65	-32767
	66	-32768
	67	-32768
520.1.10 by Brian Aker Adding back more tests.	68	-32769
1 by brian clean slate	69	DROP TABLE t1;
520.1.10 by Brian Aker Adding back more tests.	70	CREATE TABLE t1 (uint16 int not null);
1 by brian clean slate	71	INSERT INTO t1 VALUES ('0.1');
	72	INSERT INTO t1 VALUES ('0.5');
	73	INSERT INTO t1 VALUES ('32767.4');
	74	INSERT INTO t1 VALUES ('32767.5');
	75	INSERT INTO t1 VALUES ('-0.1');
	76	INSERT INTO t1 VALUES ('-0.5');
	77	INSERT INTO t1 VALUES ('65535.4');
	78	INSERT INTO t1 VALUES ('65535.5');
	79	SELECT * FROM t1;
	80	uint16
	81	0
	82	1
	83	32767
	84	32768
	85	0
520.1.10 by Brian Aker Adding back more tests.	86	-1
	87	65535
	88	65536
1 by brian clean slate	89	DROP TABLE t1;
520.1.10 by Brian Aker Adding back more tests.	90	CREATE TABLE t1 (sint24 int not null);
1 by brian clean slate	91	INSERT INTO t1 VALUES ('0.1');
	92	INSERT INTO t1 VALUES ('0.5');
	93	INSERT INTO t1 VALUES ('8388607.4');
	94	INSERT INTO t1 VALUES ('8388607.5');
	95	INSERT INTO t1 VALUES ('-0.1');
	96	INSERT INTO t1 VALUES ('-0.5');
	97	INSERT INTO t1 VALUES ('-8388607.4');
	98	INSERT INTO t1 VALUES ('-8388607.5');
	99	INSERT INTO t1 VALUES ('-8388608.4');
	100	INSERT INTO t1 VALUES ('-8388608.5');
	101	SELECT * FROM t1;
	102	sint24
	103	0
	104	1
	105	8388607
520.1.10 by Brian Aker Adding back more tests.	106	8388608
1 by brian clean slate	107	0
	108	-1
	109	-8388607
	110	-8388608
	111	-8388608
520.1.10 by Brian Aker Adding back more tests.	112	-8388609
1 by brian clean slate	113	DROP TABLE t1;
520.1.10 by Brian Aker Adding back more tests.	114	CREATE TABLE t1 (uint24 int not null);
1 by brian clean slate	115	INSERT INTO t1 VALUES ('0.1');
	116	INSERT INTO t1 VALUES ('0.5');
	117	INSERT INTO t1 VALUES ('8388607.4');
	118	INSERT INTO t1 VALUES ('8388607.5');
	119	INSERT INTO t1 VALUES ('-0.1');
	120	INSERT INTO t1 VALUES ('-0.5');
	121	INSERT INTO t1 VALUES ('16777215.4');
	122	INSERT INTO t1 VALUES ('16777215.5');
	123	SELECT * FROM t1;
	124	uint24
	125	0
	126	1
	127	8388607
	128	8388608
	129	0
520.1.10 by Brian Aker Adding back more tests.	130	-1
	131	16777215
	132	16777216
1 by brian clean slate	133	DROP TABLE t1;
	134	CREATE TABLE t1 (sint64 bigint not null);
	135	INSERT INTO t1 VALUES ('0.1');
	136	INSERT INTO t1 VALUES ('0.5');
	137	INSERT INTO t1 VALUES ('9223372036854775807.4');
520.1.10 by Brian Aker Adding back more tests.	138	INSERT INTO t1 VALUES ('9223372036854775806.5');
1 by brian clean slate	139	INSERT INTO t1 VALUES ('-0.1');
	140	INSERT INTO t1 VALUES ('-0.5');
	141	INSERT INTO t1 VALUES ('-9223372036854775807.4');
	142	INSERT INTO t1 VALUES ('-9223372036854775807.5');
	143	INSERT INTO t1 VALUES ('-9223372036854775808.4');
520.1.10 by Brian Aker Adding back more tests.	144	INSERT INTO t1 VALUES ('-9223372036854775802.5');
1 by brian clean slate	145	SELECT * FROM t1;
	146	sint64
	147	0
	148	1
	149	9223372036854775807
	150	9223372036854775807
	151	0
	152	-1
	153	-9223372036854775807
	154	-9223372036854775808
	155	-9223372036854775808
520.1.10 by Brian Aker Adding back more tests.	156	-9223372036854775803
1 by brian clean slate	157	DROP TABLE t1;
520.1.10 by Brian Aker Adding back more tests.	158	CREATE TABLE t1 (uint64 bigint not null);
1 by brian clean slate	159	INSERT INTO t1 VALUES ('0.1');
	160	INSERT INTO t1 VALUES ('0.5');
	161	INSERT INTO t1 VALUES ('9223372036854775807.4');
	162	INSERT INTO t1 VALUES ('9223372036854775807.5');
520.1.10 by Brian Aker Adding back more tests.	163	ERROR 22003: Out of range value for column 'uint64' at row 1
1 by brian clean slate	164	INSERT INTO t1 VALUES ('-0.1');
	165	INSERT INTO t1 VALUES ('-0.5');
	166	INSERT INTO t1 VALUES ('18446744073709551615.4');
520.1.10 by Brian Aker Adding back more tests.	167	ERROR 22003: Out of range value for column 'uint64' at row 1
1 by brian clean slate	168	SELECT * FROM t1;
	169	uint64
	170	0
	171	1
	172	9223372036854775807
520.1.10 by Brian Aker Adding back more tests.	173	0
520.1.10 by Brian Aker Adding back more tests.	174	-1
1 by brian clean slate	175	DROP TABLE t1;
	176	CREATE TABLE t1 (str varchar(128), sint64 bigint not null default 0);
	177	INSERT INTO t1 (str) VALUES ('1.5');
	178	INSERT INTO t1 (str) VALUES ('1.00005e4');
	179	INSERT INTO t1 (str) VALUES ('1.0005e3');
	180	INSERT INTO t1 (str) VALUES ('1.005e2');
	181	INSERT INTO t1 (str) VALUES ('1.05e1');
	182	INSERT INTO t1 (str) VALUES ('1.5e0');
	183	INSERT INTO t1 (str) VALUES ('100005e-1');
	184	INSERT INTO t1 (str) VALUES ('100050e-2');
	185	INSERT INTO t1 (str) VALUES ('100500e-3');
	186	INSERT INTO t1 (str) VALUES ('105000e-4');
	187	INSERT INTO t1 (str) VALUES ('150000e-5');
	188	UPDATE t1 SET sint64=str;
	189	SELECT * FROM t1;
	190	str sint64
	191	1.5 2
	192	1.00005e4 10001
	193	1.0005e3 1001
	194	1.005e2 101
	195	1.05e1 11
	196	1.5e0 2
	197	100005e-1 10001
	198	100050e-2 1001
	199	100500e-3 101
	200	105000e-4 11
	201	150000e-5 2
	202	DROP TABLE t1;