SQL: read_sql with a stored procedure

[httassadar]

pandas 0.14.0

pandas.io.sql.read_sql(sql,dbconn) does not work if the string sql does not have 'select' in it. If I'm reading a sproc, sql will start with 'exec' and no 'select'.

There is a test on line 377 in pandas\io\sql.py
if 'select' in sql.lower()

I modified it to
if 'select' in sql.lower() or 'exec' in sql.lower()

then it works.

[jorisvandenbossche]

This is already fixed in 0.14.1 (so you can update to that), but thanks for the report!

See #7326

[httassadar]

cool, thanks.