---In firebird-support@yahoogroups.com, <jonatan.lauritsen@...> wrote : > > I am trying to create or modify the following procedure: > > create or alter procedure test_procedure(id integer, p_from_date date) > as > > declare variable from_date date; > declare variable to_date date; > > begin > end > > But this SQL restarts server or the connection remains hanging (from IBExpert > or from Flamerobin). > This problem is in Firebird 3.0.0 and 3.0.1 (64 bit). There are no relevant > messages in firebird.log > (e.g. no gds exceptions).
I can't reproduce it: \Firebird-3.0.0.32483-2_x64_pdb>isql Use CONNECT or CREATE DATABASE to specify a database SQL> set sql dialect 1; SQL> create database 'a.fdb'; SQL> show version; ISQL Version: WI-V3.0.0.32483 Firebird 3.0 Server version: Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.0.32483 Firebird 3.0" on disk structure version 12.0 SQL> SQL> set term ^; SQL> SQL> create or alter procedure test_procedure(id integer, p_from_date date) CON> as CON> CON> declare variable from_date date; CON> declare variable to_date date; CON> CON> begin CON> end CON> ^ SQL warning code = 301 -DATE data type is now called TIMESTAMP -SQL warning code = 301 -DATE data type is now called TIMESTAMP -SQL warning code = 301 -DATE data type is now called TIMESTAMP SQL> SQL> set term ;^ SQL> show procedure; Global procedures Procedure Name Invalid Dependency, Type ================================= ======= ===================================== TEST_PROCEDURE SQL> SQL> show procedure test_procedure; Procedure text: ============================================================================= declare variable from_date date; declare variable to_date date; begin end ============================================================================= Parameters: ID INPUT INTEGER P_FROM_DATE INPUT TIMESTAMP SQL> commit; SQL> SQL> drop database; SQL> exit; Reagrds, Vlad
