| Subject: | Doesn't seem to play nice with a Teradata connection... |
| Date: | Mon, 14 Apr 2008 11:53:58 +0100 |
| To: | bug-SQL-Shell [...] rt.cpan.org |
| From: | Andrew Bruce <Andrew_Bruce [...] agilent.com> |
Hi,
After looking for exactly this kind of application (sqlsh), I was
disappointed to find that it doesn't seem to work correctly with a
Teradata connection.
I am using the DBI:Teradata driver, which works fine within a
typical perl script.
When I use sqlsh, I can connect to the Teradata DB with no problems,
but I can not 'select' any data.
No errors are returned, and no data is returned.
For example, if I describe a table, it works fine:
DBI:Teradata:abi> desc dbc.tables;
+----------------------------------------------+
| dbc.tables |
+----------------------+----------------+------+
| Field | Type | Null |
+----------------------+----------------+------+
| DatabaseName | CHAR(30) | NO |
| TableName | CHAR(30) | NO |
| Version | SMALLINT(2) | NO |
| TableKind | CHAR(1) | NO |
...
However, a simple count on the number of rows gives:
DBI:Teradata:abi> select count(*) from dbc.tables
+----------+
| Count(*) |
+----------+
+----------+
Or a 'show tables':
DBI:Teradata:abi> show tables;
+-------+------+
| table | rows |
+-------+------+
+-------+------+
I've tested my installation against a MySQL config, and sqlsh works
fine, so it looks like the SQL::Shell module doesn't work well with
the Teradata driver...
If you would like me to run any further diagnostics, please feel
free to get in touch.
Kind regards,
Andy Bruce
Message body not shown because it is not plain text.