mirror of
https://github.com/MariaDB/server.git
synced 2026-02-14 22:58:42 +01:00
a392c79552
- Apply to ODBC tables as well as MYSQL tables - Fix and enhance the CheckCond routine Make ReadKey and MakeKeyWhere handle all conditions modified: storage/connect/.gitattributes modified: storage/connect/.gitignore modified: storage/connect/connect.cc modified: storage/connect/connect.h modified: storage/connect/ha_connect.cc modified: storage/connect/ha_connect.h modified: storage/connect/mycat.cc modified: storage/connect/tabmysql.cpp modified: storage/connect/tabmysql.h modified: storage/connect/tabodbc.cpp modified: storage/connect/tabodbc.h modified: storage/connect/xobject.cpp modified: storage/connect/xobject.h modified: storage/connect/xtable.h Add some new tests: storage/connect/mysql-test/connect/r/endian.result storage/connect/mysql-test/connect/r/mysql_index.result storage/connect/mysql-test/connect/t/endian.test storage/connect/mysql-test/connect/t/mysql_index.test
105 lines
3.5 KiB
Text
105 lines
3.5 KiB
Text
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;
|