-- tdf#91324 "Embedded Firebird - Current_Date gives wrong date back"
--
-- Show current_date, current_time, and current_timestamp in a
-- Firebird database.  LibreOffice seems to be screwing up the first
-- and third of those.
--
-- Execute this with shell commands like ...
--
--     isql=SRCDIR/workdir/UnpackedTarball/firebird/gen/firebird/bin/isql
--     script=path_to_this_file
--     cd /tmp
--     $isql -b -i $script ; rm nothing

-- Create a database for playing around.
-- (Is this really necessary?  I dunno how to avoid it.)
create database "nothing" ;
commit ;
connect "nothing" ;

-- Create a table from which to select.  table_dee really should not have
-- any columns, but I do not know how to make firebird accept that.
create table table_dee ( thing integer primary key ) ;
insert into table_dee values ( 1 ) ;

-- Show the values of interest
select current_date
     , current_time
     , current_timestamp
  from table_dee ;

-- bye
quit ;