Why DROP INDEX IF EXISTS generates a MySQL note

Question

I'm using MariaDB and I have a sql file which looks like this:

create table table1(
     id int auto_increment primary key,
     name varchar(50))
);
drop index if exists my_index on table1;
create fulltext index my_index on table1(name);

When i run this file with source file.sql it generates this warning:

+-------+------+--------------------------------------------------------------------------+
| Level | Code | Message                                                                  |
+-------+------+--------------------------------------------------------------------------+
| Note  | 1091 | Can't DROP 'my_index'; check that column/key exists                      |
+-------+------+--------------------------------------------------------------------------+

Is there a way to take this warning away?

Well, it works without error in this db<>fiddle test here. So I guess you just don't want the warning. — LukStorms
– LukStorms, Commented Jan 3, 2020 at 13:45

VBoka · Accepted Answer · 2020-01-03 13:36:06Z

2

This is what I have founded here: https://mariadb.com/kb/en/drop-index/

If the IF EXISTS clause is used, then MariaDB will return a warning instead of an error if the index does not exist.

Hope this helps.

answered Jan 3, 2020 at 13:36

VBoka

9,0933 gold badges19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alberto Over a year ago

so in other words, is nothing to care about

VBoka Over a year ago

Well, yes, but I am checking to see how to resolve this: "Is there a way to take this warning away?" There is a table : mariadb.com/kb/en/information-schema-index_statistics-table that you can query and check if the index exists. And then if it exists drop it and if not...but I can not run it on dbfiddle.uk/?rdbms=mariadb_10.4 to test that... sorry. Maybe this comment will also be of some help...

Collectives™ on Stack Overflow

Why DROP INDEX IF EXISTS generates a MySQL note

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related