René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Index on a table containing columns with no sort order fails while reflecting the table","articleBody":"#### Environment details\r\n\r\n  - Programming language: Python\r\n  - OS: debian (can be reproduce on any OS)\r\n  - Language runtime version: Python 3.11.7\r\n  - Package version:  sqlalchemy-spanner==1.7.0, SQLAlchemy==1.4.49\r\n\r\n#### Steps to reproduce\r\n\r\n  1. Install Packages:\r\n\r\n```\r\n pip install SQLAlchemy==1.4.49 sqlalchemy-spanner==1.7.0\r\n\r\n```\r\n\r\n  2. Setup Engine:\r\n\r\n```\r\nfrom sqlalchemy import create_engine\r\n\r\n# Replace the following with your actual database connection string\r\nDATABASE_URL = \"spanner+spanner:///projects/YOUR_PROJECT_ID/instances/YOUR_INSTANCE_ID/databases/YOUR_DATABASE_ID\"\r\nengine = create_engine(DATABASE_URL)\r\n```\r\n\r\n  3. Setup Database:\r\n\r\n```\r\n# SQL for creating the table\r\ncreate_table_sql = \"\"\"\r\nCREATE TABLE clicks (\r\n  id INT64 NOT NULL,\r\n  date DATE NOT NULL,\r\n  url_hash STRING(32) NOT NULL,\r\n  url STRING(MAX) NOT NULL,\r\n) PRIMARY KEY(id, date DESC, url_hash);\r\n\"\"\"\r\n\r\n# SQL for creating the index\r\ncreate_index_sql = \"\"\"\r\nCREATE INDEX idx_on_clicks ON clicks(id, date DESC, url_hash) STORING (url);\r\n\"\"\"\r\n\r\n# Execute the SQL commands\r\nwith engine.connect() as connection:\r\n    connection.execute(create_table_sql)\r\n    connection.execute(create_index_sql)\r\n\r\n```\r\n\r\n  4. Reflect Database:\r\n\r\n```\r\nfrom sqlalchemy import MetaData, inspect\r\n\r\ninspector = inspect(engine)\r\nmeta = MetaData(bind=engine)\r\nMetaData.reflect(meta, views=True)\r\n```\r\n\r\n  5. Exception from Step 4:\r\n\r\n```\r\n  File \"/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py\", line 614, in __new__\r\n    table._init(name, metadata, *args, **kw)\r\n  File \"/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py\", line 689, in _init\r\n    self._autoload(\r\n  File \"/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py\", line 724, in _autoload\r\n    conn_insp.reflect_table(\r\n  File \"/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/reflection.py\", line 807, in reflect_table\r\n    self._reflect_indexes(\r\n  File \"/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/reflection.py\", line 1071, in _reflect_indexes\r\n    if k in c_sorting:\r\n       ^^^^^^^^^^^^^^\r\nTypeError: argument of type 'NoneType' is not iterable\r\n```\r\n\r\n**Note:** SQLAlchemy-2.0.30 also has the same issue.","author":{"url":"https://github.com/mmahmed","@type":"Person","name":"mmahmed"},"datePublished":"2024-06-11T17:21:03.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/399/python-spanner-sqlalchemy/issues/399"}