maria-docs team mailing list archive

Thread
Date

10.6 ALTER TABLE ... ADD/ALTER INDEX ... [NOT] IGNORED

To: "maria-docs@xxxxxxxxxxxxxxxxxxx" <maria-docs@xxxxxxxxxxxxxxxxxxx>
From: "Andre Vergison (avergiso)" <Andre.Vergison@xxxxxxxxx>
Date: Fri, 4 Mar 2022 13:05:07 +0000
Accept-language: en-BE, en-US
Arc-authentication-results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=quest.com; dmarc=pass action=none header.from=quest.com; dkim=pass header.d=quest.com; arc=none
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=idSDCuQlk8sY3bdIlc3lbsazAerAvpdkA/YNb2F/6JA=; b=MtADcW97sJaLWLDRZmH2C0C8BMBwuxQp/tKqR/0+a6kasStwLFD0Sy8KS535oePpIzMx6kSqPqEP7P7TfBgdkw+xgV/QztQxnOq4C9mBxYzoljtzAr3+ft2wjgy8S2En66PMRsYLC17UEL8IEuT6GBL8qC1+8S/Kt9kQ85OT4W5ipSruW94wcFIh9Dvnv/cfSA8XDN3Zpd5g2fVEzdDVSJic8bItfbDmuRNomboj+8s4XJiwGcwAncBY1uI00zqU4hvHl5iQqfRtmZZY3FUxGHVA3+erFOp3bW1z2M1ePjr8YeCWBdpk388ZeRr/sS4OvbhbtZYrSlTX0lXtNw/I3g==
Arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ncdHh6OvXBXruY7Z6GbPhZvO6w2NsmNm2KDFFCwVO77NirFNpBjGmf0a6TUHVeqiw0j7VI6IJCvoqPwM7N2qDI1myLPOGW31qwzJX5nIasgK3qqKuAw/jIeqepxysc0ARD8oK1YlzsrBYdbrNOd7cDinXmRWhLzTe1KitzRLL7H3wp1oK/eb10BdOIhMgSMCz/toWEtOJ64+qJSnOZbB7drp0i/uZpEbRtuAGQO/JB4Q1fteiekgiYn5EWV6Fj5Oq12Dm0CL1XyCOVJy7eZ+Qj072XAR/sEharRC1a7BpDfnh4NQqJN/8IjENrtl5/biGClNtvBZyEWA1Oq59O42sw==
Authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=quest.com;
Thread-index: AdgvyES88AMOimfXTy2EEfSAcbpDdw==
Thread-topic: 10.6 ALTER TABLE ... ADD/ALTER INDEX ... [NOT] IGNORED

Hello,

About https://mariadb.com/kb/en/alter-table/ , the 10.6 [NOT] IGNORED index option:

It looks as if [NOT] IGNORED was not documented in the ALTER {INDEX|KEY} subclause:
  ALTER TABLE <name> ALTER INDEX name IGNORED
which works fine too.
This syntax was shown on https://mariadb.com/kb/en/ignored-indexes/ though.

The documented syntax
  ALTER TABLE <name> ADD INDEX (<columns>) IGNORED
seems to work fine.

Thanks,
Andre