~drizzle-trunk/drizzle/development : contents of tests/t/round.test at revision 2254

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

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

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;
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;
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;
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;
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;
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;
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;
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');
--error ER_WARN_DATA_OUT_OF_RANGE
INSERT INTO t1 VALUES ('9223372036854775807.5');
INSERT INTO t1 VALUES ('-0.1');
INSERT INTO t1 VALUES ('-0.5');
--error ER_WARN_DATA_OUT_OF_RANGE
INSERT INTO t1 VALUES ('18446744073709551615.4');
SELECT * FROM t1;
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;
DROP TABLE t1;



1 by brian clean slate	1	--disable_warnings
	2	DROP TABLE IF EXISTS t1;
	3	--enable_warnings
	4
396 by Brian Aker Cleanup tiny and small int.	5	CREATE TABLE t1 (sint8 int not null);
1 by brian clean slate	6	INSERT INTO t1 VALUES ('0.1');
	7	INSERT INTO t1 VALUES ('0.5');
	8	INSERT INTO t1 VALUES ('127.4');
	9	INSERT INTO t1 VALUES ('127.5');
	10	INSERT INTO t1 VALUES ('-0.1');
	11	INSERT INTO t1 VALUES ('-0.5');
	12	INSERT INTO t1 VALUES ('-127.4');
	13	INSERT INTO t1 VALUES ('-127.5');
	14	INSERT INTO t1 VALUES ('-128.4');
	15	INSERT INTO t1 VALUES ('-128.5');
	16	SELECT * FROM t1;
	17	DROP TABLE t1;
	18
413.2.2 by Brian Aker Removed UNSIGNED from parser.	19	CREATE TABLE t1 (uint8 int not null);
1 by brian clean slate	20	INSERT INTO t1 VALUES ('0.1');
	21	INSERT INTO t1 VALUES ('0.5');
	22	INSERT INTO t1 VALUES ('127.4');
	23	INSERT INTO t1 VALUES ('127.5');
	24	INSERT INTO t1 VALUES ('-0.1');
	25	INSERT INTO t1 VALUES ('-0.5');
	26	INSERT INTO t1 VALUES ('255.4');
	27	INSERT INTO t1 VALUES ('255.5');
	28	SELECT * FROM t1;
	29	DROP TABLE t1;
	30
	31
396 by Brian Aker Cleanup tiny and small int.	32	CREATE TABLE t1 (sint16 int not null);
1 by brian clean slate	33	INSERT INTO t1 VALUES ('0.1');
	34	INSERT INTO t1 VALUES ('0.5');
	35	INSERT INTO t1 VALUES ('32767.4');
	36	INSERT INTO t1 VALUES ('32767.5');
	37	INSERT INTO t1 VALUES ('-0.1');
	38	INSERT INTO t1 VALUES ('-0.5');
	39	INSERT INTO t1 VALUES ('-32767.4');
	40	INSERT INTO t1 VALUES ('-32767.5');
	41	INSERT INTO t1 VALUES ('-32768.4');
	42	INSERT INTO t1 VALUES ('-32768.5');
	43	SELECT * FROM t1;
	44	DROP TABLE t1;
	45
	46
413.2.2 by Brian Aker Removed UNSIGNED from parser.	47	CREATE TABLE t1 (uint16 int not null);
1 by brian clean slate	48	INSERT INTO t1 VALUES ('0.1');
	49	INSERT INTO t1 VALUES ('0.5');
	50	INSERT INTO t1 VALUES ('32767.4');
	51	INSERT INTO t1 VALUES ('32767.5');
	52	INSERT INTO t1 VALUES ('-0.1');
	53	INSERT INTO t1 VALUES ('-0.5');
	54	INSERT INTO t1 VALUES ('65535.4');
	55	INSERT INTO t1 VALUES ('65535.5');
	56	SELECT * FROM t1;
	57	DROP TABLE t1;
	58
520.1.10 by Brian Aker Adding back more tests.	59	CREATE TABLE t1 (sint24 int not null);
1 by brian clean slate	60	INSERT INTO t1 VALUES ('0.1');
	61	INSERT INTO t1 VALUES ('0.5');
	62	INSERT INTO t1 VALUES ('8388607.4');
	63	INSERT INTO t1 VALUES ('8388607.5');
	64	INSERT INTO t1 VALUES ('-0.1');
	65	INSERT INTO t1 VALUES ('-0.5');
	66	INSERT INTO t1 VALUES ('-8388607.4');
	67	INSERT INTO t1 VALUES ('-8388607.5');
	68	INSERT INTO t1 VALUES ('-8388608.4');
	69	INSERT INTO t1 VALUES ('-8388608.5');
	70	SELECT * FROM t1;
	71	DROP TABLE t1;
	72
520.1.10 by Brian Aker Adding back more tests.	73	CREATE TABLE t1 (uint24 int not null);
1 by brian clean slate	74	INSERT INTO t1 VALUES ('0.1');
	75	INSERT INTO t1 VALUES ('0.5');
	76	INSERT INTO t1 VALUES ('8388607.4');
	77	INSERT INTO t1 VALUES ('8388607.5');
	78	INSERT INTO t1 VALUES ('-0.1');
	79	INSERT INTO t1 VALUES ('-0.5');
	80	INSERT INTO t1 VALUES ('16777215.4');
	81	INSERT INTO t1 VALUES ('16777215.5');
	82	SELECT * FROM t1;
	83	DROP TABLE t1;
	84
	85	CREATE TABLE t1 (sint64 bigint not null);
	86	INSERT INTO t1 VALUES ('0.1');
	87	INSERT INTO t1 VALUES ('0.5');
	88	INSERT INTO t1 VALUES ('9223372036854775807.4');
520.1.10 by Brian Aker Adding back more tests.	89	INSERT INTO t1 VALUES ('9223372036854775806.5');
1 by brian clean slate	90	INSERT INTO t1 VALUES ('-0.1');
	91	INSERT INTO t1 VALUES ('-0.5');
	92	INSERT INTO t1 VALUES ('-9223372036854775807.4');
	93	INSERT INTO t1 VALUES ('-9223372036854775807.5');
	94	INSERT INTO t1 VALUES ('-9223372036854775808.4');
520.1.10 by Brian Aker Adding back more tests.	95	INSERT INTO t1 VALUES ('-9223372036854775802.5');
1 by brian clean slate	96	SELECT * FROM t1;
	97	DROP TABLE t1;
	98
413.2.2 by Brian Aker Removed UNSIGNED from parser.	99	CREATE TABLE t1 (uint64 bigint not null);
1 by brian clean slate	100	INSERT INTO t1 VALUES ('0.1');
	101	INSERT INTO t1 VALUES ('0.5');
	102	INSERT INTO t1 VALUES ('9223372036854775807.4');
1731.3.1 by Lee Bieber change tests to use enum values instead of error numbers	103	--error ER_WARN_DATA_OUT_OF_RANGE
1 by brian clean slate	104	INSERT INTO t1 VALUES ('9223372036854775807.5');
	105	INSERT INTO t1 VALUES ('-0.1');
	106	INSERT INTO t1 VALUES ('-0.5');
1731.3.1 by Lee Bieber change tests to use enum values instead of error numbers	107	--error ER_WARN_DATA_OUT_OF_RANGE
1 by brian clean slate	108	INSERT INTO t1 VALUES ('18446744073709551615.4');
	109	SELECT * FROM t1;
	110	DROP TABLE t1;
	111
	112	CREATE TABLE t1 (str varchar(128), sint64 bigint not null default 0);
	113	INSERT INTO t1 (str) VALUES ('1.5');
	114	INSERT INTO t1 (str) VALUES ('1.00005e4');
	115	INSERT INTO t1 (str) VALUES ('1.0005e3');
	116	INSERT INTO t1 (str) VALUES ('1.005e2');
	117	INSERT INTO t1 (str) VALUES ('1.05e1');
	118	INSERT INTO t1 (str) VALUES ('1.5e0');
	119	INSERT INTO t1 (str) VALUES ('100005e-1');
	120	INSERT INTO t1 (str) VALUES ('100050e-2');
	121	INSERT INTO t1 (str) VALUES ('100500e-3');
	122	INSERT INTO t1 (str) VALUES ('105000e-4');
	123	INSERT INTO t1 (str) VALUES ('150000e-5');
	124	UPDATE t1 SET sint64=str;
	125	SELECT * FROM t1;
	126	DROP TABLE t1;
	127
	128