�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain%2F'>main</a>/</p><hr><h3>✏️ Editing: myisam_enable_keys-10506.result</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>call mtr.add_suppression(&quot;Can&#039;t find record in &#039;.*&#039;&quot;);
CREATE TABLE t1 (
pk INT AUTO_INCREMENT,
i INT,
d DATE,
dt DATETIME,
v VARCHAR(1),
PRIMARY KEY (pk),
KEY (dt)
) ENGINE=MyISAM;
INSERT INTO t1 (i, d, dt, v) VALUES 
(9, &#039;2005-07-23&#039;, &#039;2004-05-13 01:01:39&#039;, &#039;t&#039;),
(2, &#039;2009-11-01&#039;, &#039;2003-12-24 07:39:29&#039;, &#039;h&#039;),
(6, NULL, &#039;2008-07-03 05:32:22&#039;, &#039;l&#039;),
(6, &#039;2007-07-16&#039;, &#039;2008-08-28 18:46:11&#039;, &#039;j&#039;),
(5, NULL, &#039;2001-07-12 21:27:00&#039;, &#039;h&#039;),
(3, &#039;2007-07-22&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;p&#039;),
(2, &#039;2000-11-21&#039;, &#039;2007-05-25 11:58:54&#039;, &#039;g&#039;),
(6, &#039;1900-01-01&#039;, &#039;2009-06-03 17:11:10&#039;, &#039;i&#039;),
(2, &#039;2008-02-10&#039;, &#039;2001-06-15 16:20:07&#039;, &#039;p&#039;),
(3, &#039;2009-06-04&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;h&#039;),
(9, &#039;2007-04-25&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;e&#039;),
(9, &#039;2006-03-02&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;e&#039;),
(1, &#039;1900-01-01&#039;, &#039;2002-11-08 09:33:27&#039;, &#039;u&#039;),
(7, &#039;2008-07-13&#039;, &#039;2007-08-07 17:35:52&#039;, &#039;j&#039;),
(0, &#039;2004-11-12&#039;, &#039;2006-05-01 00:00:00&#039;, &#039;e&#039;),
(0, &#039;1900-01-01&#039;, &#039;2003-05-01 00:00:00&#039;, &#039;z&#039;),
(1, &#039;2009-09-02&#039;, &#039;2007-02-12 09:30:49&#039;, &#039;w&#039;),
(0, &#039;2004-11-06&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;t&#039;),
(4, &#039;2003-01-06&#039;, &#039;2002-07-03 02:51:11&#039;, &#039;i&#039;),
(6, &#039;2006-01-14&#039;, &#039;2008-02-26 04:57:32&#039;, &#039;i&#039;),
(0, &#039;2002-01-19&#039;, &#039;2009-02-12 00:00:00&#039;, &#039;i&#039;),
(8, &#039;2007-02-12&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;b&#039;),
(4, &#039;1900-01-01&#039;, &#039;2001-05-16 05:28:40&#039;, &#039;m&#039;),
(2, &#039;2005-07-16&#039;, NULL, &#039;j&#039;),
(1, &#039;2004-09-04&#039;, &#039;2001-01-24 21:45:18&#039;, &#039;v&#039;),
(3, &#039;2009-07-01&#039;, NULL, NULL),
(2, &#039;2009-07-21&#039;, &#039;2002-07-24 00:00:00&#039;, &#039;h&#039;),
(4, NULL, &#039;2001-11-03 12:22:30&#039;, &#039;q&#039;),
(1, &#039;2002-06-22&#039;, &#039;2008-06-17 03:17:59&#039;, &#039;f&#039;),
(7, &#039;2005-06-23&#039;, &#039;2005-12-24 00:00:00&#039;, &#039;p&#039;),
(6, &#039;2001-05-20&#039;, &#039;2008-10-23 00:00:00&#039;,  NULL),
(3, &#039;2001-10-01&#039;, &#039;2000-10-12 16:32:35&#039;, &#039;o&#039;),
(3, &#039;2001-01-07&#039;, &#039;2005-09-11 10:09:54&#039;, &#039;w&#039;),
(6, &#039;2007-11-02&#039;, &#039;2009-09-10 01:44:18&#039;, &#039;l&#039;),
(6, NULL, NULL, &#039;i&#039;),
(9, NULL, &#039;2002-05-18 15:21:55&#039;, &#039;d&#039;),
(4, &#039;2008-12-21&#039;, &#039;2004-10-15 10:09:54&#039;, &#039;j&#039;),
(6, &#039;2003-10-05&#039;, &#039;2009-07-13 03:51:02&#039;, &#039;e&#039;),
(2, &#039;2001-03-03&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;e&#039;),
(2, &#039;2007-04-04&#039;, &#039;2001-11-08 21:14:52&#039;, &#039;q&#039;),
(5, NULL, &#039;2006-12-02 00:00:00&#039;, &#039;m&#039;),
(0, &#039;2009-01-04&#039;, &#039;1900-01-01 00:00:00&#039;, NULL),
(8, &#039;2008-04-03&#039;, &#039;2005-01-01 11:55:18&#039;, &#039;q&#039;),
(8, NULL, &#039;2005-02-28 03:44:02&#039;, &#039;w&#039;),
(0, &#039;2003-08-22&#039;, NULL, &#039;c&#039;),
(9, &#039;1900-01-01&#039;, NULL, &#039;y&#039;),
(NULL, NULL, &#039;2006-08-25 16:28:09&#039;, &#039;g&#039;),
(5, &#039;2004-07-04&#039;, &#039;2002-08-11 00:00:00&#039;, &#039;z&#039;),
(1, &#039;1900-01-01&#039;, &#039;2007-07-22 21:19:18&#039;, &#039;m&#039;),
(2, &#039;2007-02-04&#039;, &#039;2006-02-10 18:41:38&#039;, &#039;t&#039;),
(2, &#039;1900-01-01&#039;, &#039;2009-02-16 14:58:58&#039;, &#039;d&#039;),
(7, &#039;2001-03-14&#039;, &#039;2007-08-14 00:00:00&#039;, &#039;h&#039;),
(0, NULL, &#039;1900-01-01 00:00:00&#039;, NULL),
(1, &#039;2008-10-05&#039;, NULL, &#039;f&#039;),
(6, &#039;2001-11-25&#039;, &#039;2008-12-03 06:59:23&#039;, &#039;l&#039;),
(NULL, &#039;2003-01-27&#039;, &#039;2008-10-04 00:00:00&#039;, &#039;g&#039;),
(8, &#039;2008-08-08&#039;, &#039;2009-07-07 07:00:21&#039;, &#039;v&#039;),
(8, &#039;2006-07-03&#039;, &#039;2001-04-15 00:00:00&#039;, NULL),
(5, &#039;2002-11-21&#039;, &#039;2007-07-08 04:01:58&#039;, &#039;m&#039;),
(5, &#039;2006-04-08&#039;, &#039;2007-09-23 00:01:35&#039;, &#039;i&#039;),
(5, &#039;2001-05-06&#039;, &#039;2008-05-15 00:00:00&#039;, &#039;h&#039;),
(7, &#039;1900-01-01&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;u&#039;),
(30, &#039;2007-04-16&#039;, &#039;2004-03-05 23:35:38&#039;, &#039;o&#039;),
(NULL, &#039;1900-01-01&#039;, &#039;2007-08-25 01:32:47&#039;, &#039;z&#039;),
(6, &#039;2004-12-03&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;o&#039;),
(8, &#039;2001-06-23&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;f&#039;),
(NULL, &#039;2008-12-15&#039;, &#039;2001-05-19 08:28:28&#039;, &#039;a&#039;),
(9, &#039;2000-02-15&#039;, &#039;2009-09-03 06:07:22&#039;, &#039;d&#039;),
(2, &#039;2001-08-05&#039;, &#039;2006-10-08 07:17:27&#039;, &#039;k&#039;),
(5, &#039;2004-01-17&#039;, &#039;2003-09-06 20:36:01&#039;, &#039;d&#039;),
(4, &#039;2003-10-01&#039;, &#039;2001-02-05 18:10:49&#039;, &#039;u&#039;),
(4, &#039;2003-07-28&#039;, &#039;2001-01-07 16:11:37&#039;, &#039;h&#039;),
(0, &#039;1900-01-01&#039;, &#039;2008-08-01 05:26:38&#039;, &#039;w&#039;),
(9, &#039;1900-01-01&#039;, &#039;2001-05-08 00:00:00&#039;, &#039;t&#039;),
(1, &#039;2000-04-17&#039;, &#039;2008-07-10 21:26:28&#039;, &#039;i&#039;),
(8, &#039;2002-01-05&#039;, &#039;2006-08-06 20:56:35&#039;, &#039;k&#039;),
(9, &#039;2001-04-10&#039;, &#039;2003-02-17 00:00:00&#039;, &#039;z&#039;),
(0, &#039;2009-12-04&#039;, NULL, &#039;h&#039;),
(7, NULL, &#039;2004-10-27 00:29:57&#039;, &#039;h&#039;),
(2, &#039;2006-03-07&#039;, &#039;2008-03-04 06:14:13&#039;, &#039;b&#039;),
(0, &#039;2001-10-15&#039;, &#039;2001-03-17 00:00:00&#039;, &#039;m&#039;),
(5, &#039;1900-01-01&#039;, &#039;2009-02-21 11:35:50&#039;, &#039;i&#039;),
(4, NULL, &#039;1900-01-01 00:00:00&#039;, &#039;w&#039;),
(5, &#039;2009-04-05&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;m&#039;),
(6, &#039;2001-03-19&#039;, &#039;2001-04-12 00:00:00&#039;, &#039;q&#039;),
(NULL, &#039;2009-12-08&#039;, &#039;2001-12-04 20:21:01&#039;, &#039;k&#039;),
(2, &#039;2005-02-09&#039;, &#039;2001-05-27 08:41:01&#039;, &#039;l&#039;),
(9, &#039;2004-05-25&#039;, &#039;2004-09-18 00:00:00&#039;, &#039;c&#039;),
(3, &#039;2005-01-17&#039;, &#039;2002-09-12 11:18:48&#039;, &#039;d&#039;),
(0, &#039;2003-08-28&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;k&#039;),
(6, &#039;2006-10-11&#039;, &#039;2003-10-28 03:31:02&#039;, &#039;a&#039;),
(5, &#039;1900-01-01&#039;, &#039;2001-08-22 10:20:09&#039;, &#039;p&#039;),
(8, &#039;1900-01-01&#039;, &#039;2008-04-24 00:00:00&#039;, &#039;o&#039;),
(4, &#039;2005-08-18&#039;, &#039;2006-11-10 10:08:49&#039;, &#039;e&#039;),
(NULL, &#039;2007-03-12&#039;, &#039;2007-10-16 00:00:00&#039;, &#039;n&#039;),
(1, &#039;2000-11-18&#039;, &#039;2009-05-27 12:25:07&#039;, &#039;t&#039;),
(4, &#039;2001-03-03&#039;, NULL, &#039;u&#039;),
(3, &#039;2003-09-11&#039;, &#039;2001-09-10 18:10:10&#039;, &#039;f&#039;),
(4, &#039;2007-06-17&#039;, &#039;1900-01-01 00:00:00&#039;, &#039;t&#039;),
(NULL, &#039;2008-09-11&#039;, &#039;2004-06-07 23:17:09&#039;, &#039;k&#039;);
ALTER TABLE t1 ADD UNIQUE KEY ind1 (pk, d, i, v);
ALTER TABLE t1 ADD UNIQUE KEY ind2 (d, v);
ERROR 23000: Duplicate entry &#039;2008-09-11-k&#039; for key &#039;ind2&#039;
DROP TABLE t1;
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain'>🔙 Back</a></p>