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
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
|
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
