Allow the selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
--------------------------------------------------------------------
Key: CORE-3972
URL: http://tracker.firebirdsql.org/browse/CORE-3972
Project: Firebird Core
Issue Type: Improvement
Components: API / Client Library, Engine
Reporter: Adriano dos Santos Fernandes
As an immediate workaround for CORE-3964, I propose to let BIGINT (and DATE and
TIME) to be passed for dialect 1 clients.
Thechanges just transform something that is currently an error into something
that may be unexpected (SQL_INT64) but will work for good clients.
Arithmetics will not be changed:
-- Create database on dialect 3
isql
create table t1 (n1 numeric(12,3));
insert into t1 values (1.23);
insert into t1 values (10.23);
insert into t1 values (3.567);
commit;
exit;
-- Change database and client to dialect 1 (with new semantics)
gfix -sql_dialect 1 zz.fdb
isql -sql_dialect 1 zz.fdb
set sqlda_display on;
select n1, n1 / 2 from t1;
OUTPUT SQLDA version: 1 sqln: 20 sqld: 2
01: sqltype: 581 INT64 Nullable sqlscale: -3 sqlsubtype: 1 sqllen: 8
: name: (2)N1 alias: (2)N1
: table: (2)T1 owner: (6)SYSDBA
02: sqltype: 481 DOUBLE Nullable sqlscale: 0 sqlsubtype: 0 sqllen: 8
: name: (6)DIVIDE alias: (6)DIVIDE
: table: (0) owner: (0)
N1 DIVIDE
===================== =======================
1.230 0.6150000000000000
10.230 5.115000000000000
3.567 1.783500000000000
-- Test with current dialect 1
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-N1
-Client SQL dialect 1 does not support reference to BIGINT datatype
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
