3814
3814
DROP TABLE t1, t2;
3815
CREATE TABLE t1 (s1 BINARY(5), s2 VARBINARY(5));
3816
INSERT INTO t1 VALUES (0x41,0x41), (0x42,0x42), (0x43,0x43);
3817
SELECT s1, s2 FROM t1 WHERE s2 IN (SELECT s1 FROM t1);
3819
SELECT s1, s2 FROM t1 WHERE (s2, 10) IN (SELECT s1, 10 FROM t1);
3821
CREATE INDEX I1 ON t1 (s1);
3822
CREATE INDEX I2 ON t1 (s2);
3823
SELECT s1, s2 FROM t1 WHERE s2 IN (SELECT s1 FROM t1);
3825
SELECT s1, s2 FROM t1 WHERE (s2, 10) IN (SELECT s1, 10 FROM t1);
3828
INSERT INTO t1 VALUES (0x41,0x41);
3829
SELECT * FROM t1 WHERE s1 = (SELECT s2 FROM t1);
3832
CREATE TABLE t1 (a1 VARBINARY(2) NOT NULL DEFAULT '0', PRIMARY KEY (a1));
3833
CREATE TABLE t2 (a2 BINARY(2) default '0', INDEX (a2));
3834
CREATE TABLE t3 (a3 BINARY(2) default '0');
3835
INSERT INTO t1 VALUES (1),(2),(3),(4);
3836
INSERT INTO t2 VALUES (1),(2),(3);
3837
INSERT INTO t3 VALUES (1),(2),(3);
3838
SELECT LEFT(t2.a2, 1) FROM t2,t3 WHERE t3.a3=t2.a2;
3843
SELECT t1.a1, t1.a1 in (SELECT t2.a2 FROM t2,t3 WHERE t3.a3=t2.a2) FROM t1;
3844
a1 t1.a1 in (SELECT t2.a2 FROM t2,t3 WHERE t3.a3=t2.a2)
3849
DROP TABLE t1,t2,t3;
3850
CREATE TABLE t1 (a1 BINARY(3) PRIMARY KEY, b1 VARBINARY(3));
3851
CREATE TABLE t2 (a2 VARBINARY(3) PRIMARY KEY);
3852
CREATE TABLE t3 (a3 VARBINARY(3) PRIMARY KEY);
3853
INSERT INTO t1 VALUES (1,10), (2,20), (3,30), (4,40);
3854
INSERT INTO t2 VALUES (2), (3), (4), (5);
3855
INSERT INTO t3 VALUES (10), (20), (30);
3856
SELECT LEFT(t1.a1,1) FROM t1,t3 WHERE t1.b1=t3.a3;
3861
SELECT a2 FROM t2 WHERE t2.a2 IN (SELECT t1.a1 FROM t1,t3 WHERE t1.b1=t3.a3);
3863
DROP TABLE t1, t2, t3;
3864
3815
CREATE TABLE t1 (a CHAR(1), b VARCHAR(10));
3865
3816
INSERT INTO t1 VALUES ('a', 'aa');
3866
3817
INSERT INTO t1 VALUES ('a', 'aaa');