Method parse_show

src/sql-parser/src/parser.rs:8042–8253

(&mut self)

    }

    fn parse_show(&mut self) -> Result<ShowStatement<Raw>, ParserError> {
        let redacted = self.parse_keyword(REDACTED);
        if redacted && !self.peek_keyword(CREATE) {
            return parser_err!(
                self,
                self.peek_pos(),
                "SHOW REDACTED is only supported for SHOW REDACTED CREATE ..."
            );
        }
        if self.parse_one_of_keywords(&[COLUMNS, FIELDS]).is_some() {
            self.parse_show_columns()
        } else if self.parse_keyword(OBJECTS) {
            let from = if self.parse_keywords(&[FROM]) {
                Some(self.parse_schema_name()?)
            } else {
                None
            };
            Ok(ShowStatement::ShowObjects(ShowObjectsStatement {
                object_type: ShowObjectType::Object,
                from,
                filter: self.parse_show_statement_filter()?,
            }))
        } else if let Some(object_type) = self.parse_plural_object_type() {
            let from = if object_type.lives_in_schema() {
                if self.parse_keywords(&[FROM]) {
                    Some(self.parse_schema_name()?)
                } else {
                    None
                }
            } else {
                None
            };

            let show_object_type = match object_type {
                ObjectType::Database => ShowObjectType::Database,
                ObjectType::Schema => {
                    let from = if self.parse_keyword(FROM) {
                        Some(self.parse_database_name()?)
                    } else {
                        None
                    };
                    ShowObjectType::Schema { from }
                }
                ObjectType::Table => {
                    let on_source = if self.parse_one_of_keywords(&[ON]).is_some() {
                        Some(self.parse_raw_name()?)
                    } else {
                        None
                    };
                    ShowObjectType::Table { on_source }
                }
                ObjectType::View => ShowObjectType::View,
                ObjectType::Source => {
                    let in_cluster = self.parse_optional_in_cluster()?;
                    ShowObjectType::Source { in_cluster }
                }
                ObjectType::Subsource => {
                    let on_source = if self.parse_one_of_keywords(&[ON]).is_some() {