[Firebird-devel] [ firebird-Bugs-910430 ] ISQL and database dialect

[SourceForge.net <no...@so...>]

Bugs item #910430, was opened at 2004-03-05 13:23
Message generated for change (Comment added) made by brodsom
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=910430&group_id=9028

Category: ISQL
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Ivan Prenosil (prenosil)
Assigned to: Nobody/Anonymous (nobody)
Summary: ISQL and database dialect

Initial Comment:
When ISQL disconnects from database
(either by dropping it or by trying to connect to
non-existent database) is still remembers its sql dialect,
which can lead to some inappropriate
warning messages. Here is screenshot:


SQL> SHOW SQL DIALECT;
   Client SQL dialect has not been set and no database 
has been connected yet.
SQL> SET SQL DIALECT 1;
SQL> SET SQL DIALECT 3;
SQL> CREATE DATABASE 'c:\x.fdb';
SQL> SHOW SQL DIALECT;
        Client SQL dialect is set to: 3 and database SQL 
dialect is: 3
SQL> DROP DATABASE;
SQL> SHOW DATABASE;
Use CONNECT or CREATE DATABASE to specify a 
database


Everything is o.k. till now, but following two messages 
are wrong:

SQL> SHOW SQL DIALECT;
        Client SQL dialect is set to: 3 and database SQL 
dialect is: 3
SQL> SET SQL DIALECT 1;
WARNING: Client SQL dialect has been set to 1 when 
connecting to Database SQL dialect 3 database.
SQL>


It should look like:

SQL> SHOW SQL DIALECT;
        Client SQL dialect is set to: 3. No database is 
connected.
SQL> SET SQL DIALECT 1;
SQL> SHOW SQL DIALECT;
        Client SQL dialect is set to: 1. No database is 
connected.

Firebird 1.5 final win32

----------------------------------------------------------------------

Comment By: Blas Rodriguez Somoza (brodsom)
Date: 2004-04-26 17:31

Message:
Logged In: YES 
user_id=546439

Solved in 2.0 HEAD and added fbtcs test

----------------------------------------------------------------------

Comment By: mariuz (mapopa)
Date: 2004-03-28 13:19

Message:
Logged In: YES 
user_id=85089

confirmed on linux too 

SQL> show sql dialect;
   Client SQL dialect has not been set and no database has
been connected yet.
SQL> SET SQL DIALECT 1;
SQL> SET SQL DIALECT 3;
SQL> create dabase '/tmp/firebird';
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '/tmp/firebird';
SQL> show sql dialect;
        Client SQL dialect is set to: 3 and database SQL
dialect is: 3
SQL> show database;
Database: /tmp/firebird
        Owner: SYSDBA
PAGE_SIZE 4096
Number of DB pages allocated = 146
Sweep interval = 20000
Forced Writes are OFF
Transaction - oldest = 1
Transaction - oldest active = 2
Transaction - oldest snapshot = 2
Transaction - Next = 6
Default Character set: NONE
SQL> drop database;
SQL> show database;
Use CONNECT or CREATE DATABASE to specify a database
SQL> show sql dialect;
        Client SQL dialect is set to: 3 and database SQL
dialect is: 3
SQL> set sql dialect 1;
WARNING: Client SQL dialect has been set to 1 when
connecting to Database SQL dialect 3 database.
SQL> show sql dialect;
        Client SQL dialect is set to: 1 and database SQL
dialect is: 3


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=910430&group_id=9028