256
256
select host,user from mysql.user where (host,user) = ('localhost','test');
257
257
drop table t1,t2;
260
--echo # Bug#52124 memory leaks like a sieve in datetime, timestamp, time, date fields + warnings
262
CREATE TABLE t1 (a DATETIME NOT NULL, b TINYINT);
263
INSERT INTO t1 VALUES (0, 0),(0, 0);
265
SELECT 1 FROM t1 WHERE ROW(a, b) >=
266
ROW('1', (SELECT 1 FROM t1 WHERE a > 1234));
271
--echo # Bug #54190: Comparison to row subquery produces incorrect result
274
SELECT ROW(1,2) = (SELECT 1,2 FROM DUAL WHERE 1 = 0);
275
SELECT ROW(1,2) = (SELECT 1,3 FROM DUAL WHERE 1 = 0);
277
CREATE TABLE t1 (i INT);
278
INSERT INTO t1 () VALUES (1), (2), (3);
280
SELECT ROW(1,2) = (SELECT 1,2 FROM t1 WHERE 1 = 0);
281
SELECT ROW(1,2) = (SELECT 1,3 FROM t1 WHERE 1 = 0);
282
SELECT i FROM t1 WHERE ROW(1,2) = (SELECT 1,2 FROM DUAL WHERE 1 = 0);
283
SELECT i FROM t1 WHERE ROW(1,2) = (SELECT 1,3 FROM DUAL WHERE 1 = 0);
287
--echo End of 5.1 tests