--source include/have_partition.inc

INSTALL SONAME 'ha_connect';

CREATE TABLE t1 (

  id INT,

  f VARCHAR(32),

  PRIMARY KEY (id DESC)

) ENGINE=CONNECT TABLE_TYPE=DOS FILE_NAME='f.txt';

INSERT INTO t1 VALUES(1,'one'),(2,'two'),(3,'three');

SELECT * FROM t1 WHERE id >= 2;

# Cleanup

DROP TABLE t1;

UNINSTALL SONAME 'ha_connect';

SELECT * FROM t1 WHERE id >= 2;

id	f

DROP TABLE t1;

SELECT * FROM t1 WHERE id >= 2;

id	f

2	two

3	three

DROP TABLE t1;