Menu

#3269 Exception when selecting "Find text on server" menu item

Fixed
nobody
None
Defect
2013-07-06
2013-07-05
Anonymous
No

Originally created by: jerome.v...@gmail.com

What exact steps will reproduce the problem?
1. Open a connection to the database
2. Choose "Find text on server" in the "Search Menu"

What was the expected output?
- Search Dialog

What happened instead?
- Exception report (attached)
- Messages in the log pane :
SELECT @@SPID;
/* Connected. Thread-ID: 56 */
SELECT DATEDIFF(SECOND, "login_time", CURRENT_TIMESTAMP) FROM "master"."dbo"."sysprocesses" WHERE "spid"=1;
SELECT @@VERSION;
USE "datest";
/* Entering session "Dev-Datest " */
SELECT *, '' AS 'schema' FROM "datest".."sysobjects" WHERE "type" IN ('P', 'U', 'V', 'TR', 'FN');
-- here I select "Find text on server" menu item
SELECT '' AS "Collation", '' AS "Charset", 0 AS "Id", '' AS "Default", '' AS "Compiled", 1 AS "Sortlen";
SELECT "name" AS "Charset", "description" AS "Description" FROM "sys"."syscharsets";
/* SQL Error (208): 'sys.syscharsets' : nom d'objet incorrect. */

on MS SQL 2000 the request should be :

SELECT "name" AS "Charset", "description" AS "Description" FROM  master.dbo.syscharsets

Version used?
HeidiSQL revision: [r4453]
OS : Windows 2000
DB : MS sql server 2000

1 Attachments

Related

Commit: [r4453]

Discussion

  • Anonymous

    Anonymous - 2013-07-06

    Originally posted by: a...@anse.de

    [r4456] turns sys.syscharsets to master..syscharsets - works on MSSQL 2008 and should also work on older servers.

     

    Related

    Commit: [r4456]