Re: some weird things when using libmysequoia

Hi again.
Please see my last email for the logging.
1/ I will investigate this later on. Did you try without the myIsam directive ?
2/ what is the alter command you are issuing ?
3/ BigIntegers are supported by both sequoia and carob. There may be bugs but basically, this is ok

Gilles.


Mihai Costache wrote:

hi l ist,
again me !!!!

test env:
apache 1.3.37
php 4.4.6
sequoia 2.10.6
carob 0.7.3   (or latest from cvs)
libmysequoia 0.9.8 (or latest from cvs)
mysql 4.1.22

1)  the create table process, when this tables have at least one column bigint type, it too long ... 5-8 min !!!

--------- example for create table ---------
CREATE TABLE `testT1` ( `col1` BIGINT( 20 ) NOT NULL ,
`col2` DOUBLE NOT NULL ,
`col3` TEXT NOT NULL ,
`col4` DATETIME NOT NULL ,
`col5` FLOAT NOT NULL ,
`col6` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `col1` ) ) ENGINE = MYISAM

2) when i must alterate a table (for example change the type for a empty column .. or add auto_increment for an empty column with int type .... etc)
i have the following error

----- snip ----------
18:25:36,234 WARN  controller.virtualdatabase.epayment Request '11895' failed (Malformed Alter Request. No drop or add condition)
18:25:36,234 WARN  virtualdatabase.VirtualDatabaseWorkerThread.epayment Error during command execution (Malformed Alter Request. No drop or add condition)
----- snip ----------

3) when i want to select from tables with column with bigint type i don't see any action ... it not doing nothing and i haven't any log from sequoia or libmysequoia ..


question: is there any chanse that this weird things to be related to some wrong configuration on my test env ? or are some limitation of l ibmysequoia ?


Thanks,
Mihai

_______________________________________________
Carob mailing list
Carob-RyYwo1q5J+pm4DMUGMHt/jIQnlzKTOB+HZ5vskTnxNA@xxxxxxxxxxxxxxxx
https://forge.continuent.org/mailman/listinfo/carob
  

_______________________________________________
Carob mailing list
Carob-RyYwo1q5J+pm4DMUGMHt/jIQnlzKTOB+HZ5vskTnxNA@xxxxxxxxxxxxxxxx
https://forge.continuent.org/mailman/listinfo/carob