[Sqlalchemy-tickets] Issue #4152: sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column '0'" (zzzeek/sqlalchemy)

[Shikari S. <iss...@bi...>]

New issue 4152: sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column '0'"
https://bitbucket.org/zzzeek/sqlalchemy/issues/4152/sqlalchemyexcnosuchcolumnerror-could-not

Shikari Shambhu:

Hello, trying to troubleshoot. Can anyone pls help ? 



**Versions:** 

WIN 10, 64-bit

Python 2.7.12 |Anaconda 4.2.0 (64-bit)| (default, Jun 29 2016, 11:07:13) [MSC v.1500 64 bit (AMD64)] on win32

sqlite3.version : '2.6.0'
sqlite3.sqlite_version : '3.8.11'
sqlalchemy.__version__ :  '1.1.5'

**Code>	**

	import pandas as pd
	import sqlalchemy as sa
	import time

	host = 'redshift.amazonaws.com'
	port = '1234'
	user = 'user'
	password = 'password'
	database = 'db'
	url =  "postgresql://%s:%s@%s:%s/%s" % (user,password,host,port,database)
	engine = sa.create_engine(url)

	query = 'select * from table limit 10'

	df = pd.read_sql_query(query, engine)

	engine.connect().close()


** Error >  **
*Too long, entire error attached as TXT*

  File "C:\Program Files\Anaconda2\lib\site-packages\sqlalchemy\engine\result.py", line 563, in _key_fallback
    expression._string_or_unprintable(key))
sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column '0'"

Responsible: zzzeek