Bug: Unexpected "table Doesn't Exist" Message

[vygi]

This is a small one:

let's say you select something from a table which is located on another database than currently active (SQLyou said “use ” in the background), eg. you are in the database called OLAP and select something from table entries located in the database Archive:

SELECT * FROM Archive.entries WHERE date=20051120

It works indeed, SQLyog shows result as “(Read Only)” but if you try to edit this table and switch from “Ready only” to “Archive”, it says:

Error No. 1146

Table “OLAP.entries” doesn't exist

This is caused by following statement I can see in the history:

show full fields from `entries`

This is wrong; either SQLyou must use database prefix (`Archive.entries`) or not allow to switch to edit mode.

All the best,

Vygi

[peterlaursen]

confirmed!

Another solution could be to issue a 'use ..' in the background when table for editing is selected from drop-down.

[vygi]

peterlaursen: are you permanently online on this page?!.. 😎

[peterlaursen]

yeah … I like the dolphins too 😛

[vygi]

peterlaursen wrote on Nov 29 2005, 04:00 PM:

yeah … I like the dolphins too  😛

hey – that was my 50th post and I became “Advanced Member”! 😀

[peterlaursen]

oh that's fine …

but which one is you ? 😀

[vygi]

peterlaursen wrote on Nov 29 2005, 04:16 PM:

but which one is you ?  😀

I'm on the left 😉

[X] <- nail here to get new monitor

[Author]

Posts