EVOLUTION-MANAGER

Edit File: endian.result

SET time_zone='+00:00'; # # Testing little endian table # CREATE TABLE t1 ( fig INT(4) NOT NULL FIELD_FORMAT='C', name CHAR(10) NOT NULL, birth DATE NOT NULL FIELD_FORMAT='L', id CHAR(5) NOT NULL FIELD_FORMAT='L2', salary DOUBLE(9,2) NOT NULL DEFAULT 0.00 FIELD_FORMAT='LF', dept INT(4) NOT NULL FIELD_FORMAT='L2' ) ENGINE=CONNECT TABLE_TYPE=BIN BLOCK_SIZE=5 FILE_NAME='Testbal.dat'; SELECT * FROM t1; fig name birth id salary dept 5500 ARCHIBALD 1980-01-25 3789 4380.50 318 123 OLIVER 1953-08-10 23456 3400.68 2158 3123 FOO 2002-07-23 888 0.00 318 INSERT INTO t1 VALUES (5555,'RONALD','1980-02-26','3333',4444.44,555); SELECT * FROM t1; fig name birth id salary dept 5500 ARCHIBALD 1980-01-25 3789 4380.50 318 123 OLIVER 1953-08-10 23456 3400.68 2158 3123 FOO 2002-07-23 888 0.00 318 5555 RONALD 1980-02-26 3333 4444.44 555 DROP TABLE t1; CREATE TABLE t1 ( fig INT(4) NOT NULL FIELD_FORMAT='C', name CHAR(10) NOT NULL, birth DATE NOT NULL, id CHAR(5) NOT NULL FIELD_FORMAT='S', salary DOUBLE(9,2) NOT NULL DEFAULT 0.00 FIELD_FORMAT='F', dept INT(4) NOT NULL FIELD_FORMAT='S' ) ENGINE=CONNECT TABLE_TYPE=BIN BLOCK_SIZE=5 FILE_NAME='Testbal.dat' OPTION_LIST='Endian=Little'; SELECT * FROM t1; fig name birth id salary dept 5500 ARCHIBALD 1980-01-25 3789 4380.50 318 123 OLIVER 1953-08-10 23456 3400.68 2158 3123 FOO 2002-07-23 888 0.00 318 5555 RONALD 1980-02-26 3333 4444.44 555 # # Testing big endian table # CREATE TABLE t2 ( fig INT(4) NOT NULL FIELD_FORMAT='C', name CHAR(10) NOT NULL, birth DATE NOT NULL FIELD_FORMAT='B', id CHAR(5) NOT NULL FIELD_FORMAT='BS', salary DOUBLE(9,2) NOT NULL DEFAULT 0.00 FIELD_FORMAT='BF', dept INT(4) NOT NULL FIELD_FORMAT='B2' ) ENGINE=CONNECT TABLE_TYPE=BIN BLOCK_SIZE=5 FILE_NAME='Testbal.bin'; INSERT INTO t2 SELECT * FROM t1; SELECT * FROM t2; fig name birth id salary dept 5500 ARCHIBALD 1980-01-25 3789 4380.50 318 123 OLIVER 1953-08-10 23456 3400.68 2158 3123 FOO 2002-07-23 888 0.00 318 5555 RONALD 1980-02-26 3333 4444.44 555 DROP TABLE t2; CREATE TABLE t2 ( fig INT(4) NOT NULL FIELD_FORMAT='C', name CHAR(10) NOT NULL, birth DATE NOT NULL, id CHAR(5) NOT NULL FIELD_FORMAT='S', salary DOUBLE(9,2) NOT NULL DEFAULT 0.00 FIELD_FORMAT='F', dept INT(4) NOT NULL FIELD_FORMAT='2' ) ENGINE=CONNECT TABLE_TYPE=BIN BLOCK_SIZE=5 FILE_NAME='Testbal.bin' OPTION_LIST='Endian=Big'; SELECT * FROM t2; fig name birth id salary dept 5500 ARCHIBALD 1980-01-25 3789 4380.50 318 123 OLIVER 1953-08-10 23456 3400.68 2158 3123 FOO 2002-07-23 888 0.00 318 5555 RONALD 1980-02-26 3333 4444.44 555 DROP TABLE t2; CREATE TABLE t2 ( fig CHAR(4) NOT NULL, name CHAR(10) NOT NULL, birth DATE NOT NULL, id SMALLINT(5) NOT NULL, salary DOUBLE(9,2) NOT NULL DEFAULT 0.00 FIELD_FORMAT='F', dept SMALLINT(4) NOT NULL ) ENGINE=CONNECT TABLE_TYPE=BIN BLOCK_SIZE=5 FILE_NAME='Testbal.bin' OPTION_LIST='Endian=Big'; SELECT * FROM t2; fig name birth id salary dept 5500 ARCHIBALD 1980-01-25 3789 4380.50 318 123 OLIVER 1953-08-10 23456 3400.68 2158 3123 FOO 2002-07-23 888 0.00 318 5555 RONALD 1980-02-26 3333 4444.44 555 DROP TABLE t2; CREATE TABLE t2 ( fig INT(4) NOT NULL FIELD_FORMAT='C', name CHAR(10) NOT NULL, birth DATE NOT NULL FIELD_FORMAT='B', id CHAR(5) NOT NULL FIELD_FORMAT='BS', salary DOUBLE(9,2) NOT NULL DEFAULT 0.00 FIELD_FORMAT='BF', dept SMALLINT(4) NOT NULL FIELD_FORMAT='B' ) ENGINE=CONNECT TABLE_TYPE=BIN BLOCK_SIZE=5 FILE_NAME='Testbal.bin'; SELECT * FROM t2; fig name birth id salary dept 5500 ARCHIBALD 1980-01-25 3789 4380.50 318 123 OLIVER 1953-08-10 23456 3400.68 2158 3123 FOO 2002-07-23 888 0.00 318 5555 RONALD 1980-02-26 3333 4444.44 555 DROP TABLE t1, t2;