Webyog Forums > Updating Embedded Db Broken

peterlaursen

Apr 9 2006, 03:04 PM

I added a column to a table like

CODE

alter table `test2`.`PLADDER` add column `newcolumn` varchar (50) NULL after `id`

.. no matter if I use the ALTER TABLE GUI or type it

and next write in editor

CODE

select * from pladder where newc<TAB>

.. autocomplete does not find 'newcolumn'. Not even after a 'Rebuild tags' or a restart of the program.

(or similar if a Add a table ttttt and write select * from tt<TAB>

After deleting all tag files it works as expected after a restart. So might be that the file was bad. It also has been rebuilt several hundred times!

I again request that the tag file name is human readable like connectionname_checksum.db and not only checksum.db . Then I would only have had to delete one file and not all about 40 files. I also request a embedded database maintenaince functionality (SQLite VACUUM command for instance) from inside SQLyog. And maybe even a 'Rebuild from scratch' option.

BTW is there any 'limit' to how many characters you will have to type for autocomplete to be functional?
typing tt<TAB> does not find ttttt!

peterlaursen

Apr 9 2006, 03:53 PM

Well I tried creating this DB:

CODE

create database if not exists `mystest`;

USE `mystest`;

/*Table structure for table `myt` */

DROP TABLE IF EXISTS `myt`;

CREATE TABLE `myt` (
  `id` bigint(20) NOT NULL auto_increment,
  `ttt.ttt` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tttttt` */

DROP TABLE IF EXISTS `tttttt`;

CREATE TABLE `tttttt` (
  `id` bigint(20) NOT NULL auto_increment,
  `ttt.ttt.ttt` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

And things work 100%. Also columns with a "." is now found by autocomplete OK.
Looks like indexes were currupted in the old file ...

But backticks should still be stripped!

Ritesh

Apr 10 2006, 05:26 AM

QUOTE (peterlaursen @ Apr 9 2006, 03:04 PM)

I added a column to a table like

CODE

alter table `test2`.`PLADDER` add column `newcolumn` varchar (50) NULL after `id`

.. no matter if I use the ALTER TABLE GUI or type it
and next write in editor

CODE

select * from pladder where newc<TAB>

.. autocomplete does not find 'newcolumn'. Not even after a 'Rebuild tags' or a restart of the program.

(or similar if a Add a table ttttt and write select * from tt<TAB>

After deleting all tag files it works as expected after a restart. So might be that the file was bad. It also has been rebuilt several hundred times!

I again request that the tag file name is human readable like connectionname_checksum.db and not only checksum.db . Then I would only have had to delete one file and not all about 40 files. I also request a embedded database maintenaince functionality (SQLite VACUUM command for instance) from inside SQLyog. And maybe even a 'Rebuild from scratch' option.

BTW is there any 'limit' to how many characters you will have to type for autocomplete to be functional?
typing tt<TAB> does not find ttttt!

This looks like a bug. I will work on it today.

Ritesh

Apr 10 2006, 06:50 AM

Fixed in BETA 7 development tree.