search

greenlion / warp

WarpSQL Server, an open source OLAP focused distribution of the world's most popular open source database bundled with OLAP performance related plugins such as the WARP storage engine..
http://warpsql.blog
Other
42 stars 2 forks source link

information_schema.TABLES shows AUTO_INCREMENT=2 #63

Open federico-razzoli opened 4 years ago

federico-razzoli commented 4 years ago 
mysql> SELECT TABLE_NAME, ENGINE, AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_NAME= 't' ;
+------------+--------+----------------+
| TABLE_NAME | ENGINE | AUTO_INCREMENT |
+------------+--------+----------------+
| t          | WARP   |              2 |
+------------+--------+----------------+

In my tests, the value is always 2.

I don't think this matters for users. I report it because it could be an indicator of something wrong in the code.