search

prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
15.92k stars 5.33k forks source link

Information Schema Returning Incorrect is_nullable Value #23658

Closed NaveenNitturu closed 2 days ago

NaveenNitturu commented 2 days ago

Issue Description

The Information schema was returning NULLABLE as YES irrespective of what is been set actually while creating the table.

Steps to Reproduce

  1. Create a table with NOT NULL columns.
  2. Query the metadata of the table from the information schema, the is_nullable column shows YES even though the column is defined as NOT NULL.

Screenshots

image

NaveenNitturu commented 2 days ago

The PR has been merged #23577. Closing this issue.