On 03/19/2014 10:40 AM, Claudio Valderrama C. wrote: >> -----Original Message----- >> From: Alex [mailto:peshk...@mail.ru] >> Sent: Miércoles, 19 de Marzo de 2014 1:16 >> Adriano: >>>> Why the engine error message about unsupported DYN is not >> sufficient? >> >> Steve: >>> <<A preprocessing error is better than defining something >> and discovering that >>> the DDL doesn't work when you compile the preprocessed file >> with the rest of >>> your program and run it.>> >>> >> Paul: >>> Agreed. Steve is not the only user out there still >> relying/using on gpre. >> >> Main idea was to be able to generate programs for older versions. > Then gpre should check the server version and if it's FB3 or newer, reject > DDL that produces DYN. Fortunately, the check can be done indirectly through > the ODS, since FB3 only uses ODS12.
May be we better spend that time generating SQL DDL instead DYN? This is useful at least to make sure that we do have all required capabilities at SQL level and did not produce regressions dropping DYN support. > While we are at it, I wonder if isql v3 can connect to older servers. At > least I tried with isql v3 and server v2.5 running and this TCP path > > isql > localhost:F:\fb2dev\fbbuild\firebird25\temp\Win32\Debug\firebird\bin\src.fdb > -user sysdba -pass masterkey > > but had no success. If isql v3 is only for FB3, then checks like this in > isql > if (isqlGlob.major_ods < ODS_VERSION11) > return; > > are obsolete and can be deleted. I tried the same TCP path using isql v2.5 > to server v2.5 and got no problems, so I assume it's not my machine. Claudio, absolutely no ideas why you have a problem here. $ ./isql -user sysdba -pas masterkey localhost:employee Database: localhost:employee, User: sysdba SQL> show version; ISQL Version: LI-T3.0.0.30967 Firebird 3.0 Alpha 2 Server version: Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V2.5.3.26735 Firebird 2.5" Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V2.5.3.26735 Firebird 2.5/tcp (ggbb)/P12" Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T3.0.0.30977 Firebird 3.0 Alpha 2/tcp (ggbb)/P12" on disk structure version 11.2 SQL> select * from country; COUNTRY CURRENCY =============== ========== USA Dollar England Pound Canada CdnDlr Switzerland SFranc Japan Yen Italy Lira France FFranc Germany D-Mark Australia ADollar Hong Kong HKDollar Netherlands Guilder Belgium BFranc Austria Schilling Fiji FDollar SQL> ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
