Updating Embedded Db Broken

[peterlaursen]

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

.. 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

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 does not find ttttt!

[peterlaursen]

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]

peterlaursen wrote on 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

.. 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

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 does not find ttttt!

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

[Ritesh]

Fixed in BETA 7 development tree.

[Author]

Posts