Update of /cvsroot/mysql-cocoa/SMySQL/CLI_Test
In directory sc8-pr-cvs1:/tmp/cvs-serv6792/CLI_Test
Modified Files:
Make_DB_and_table.mysql
Log Message:
Corrected the issue (raised by Lorenz Textor) on BigInt MySQL type (corresponding to long long, not long int), where a BIGINT would be passed back as a 32 bits integer instead of 64 bits.
Now MCPResult handles properly BIGINT. Added a BIGINT column in the test1 table (CLI_Test), to check if it is working.
NB : Unsigned int (both INT and BIGINT) might still causes problem if they are in the higher half of their range (because they will be interpreted as signed integers).
2003-08-21; Serge Cohen.
Index: Make_DB_and_table.mysql
===================================================================
RCS file: /cvsroot/mysql-cocoa/SMySQL/CLI_Test/Make_DB_and_table.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** Make_DB_and_table.mysql 16 Aug 2003 20:36:23 -0000 1.1
--- Make_DB_and_table.mysql 21 Aug 2003 06:30:52 -0000 1.2
***************
*** 4,8 ****
-- Maybe you want to keep the next line commented out, so that if you enrich the DB for your test the modification are not droped.
-- DROP DB IF EXISTS test_mysqlclass;
! CREATE DATABASE test_mysqlclass;
USE test_mysqlclass;
--- 4,8 ----
-- Maybe you want to keep the next line commented out, so that if you enrich the DB for your test the modification are not droped.
-- DROP DB IF EXISTS test_mysqlclass;
! CREATE DATABASE IF NOT EXISTS test_mysqlclass;
USE test_mysqlclass;
***************
*** 13,22 ****
test1_desc char(250) NOT NULL default 'non documented',
test1_text text NOT NULL default '',
PRIMARY KEY (test1_id)
) TYPE=MyISAM COMMENT='A simple test table for CLI_Test application running with SMySQL framework.';
! INSERT INTO test1 (test1_id, test1_name, test1_desc, test1_text) VALUES (1,'first','first entry in the table', 'this is a text, which is indeed stored in the DB as a blob, hence you have to use the proper method to display it as a NSString rather than NSData...');
! INSERT INTO test1 (test1_id, test1_name, test1_desc, test1_text) VALUES (2,'second','second entry in the table', 'just to have more than just one line in the test1 table...');
! INSERT INTO test1 (test1_id, test1_name, test1_desc, test1_text) VALUES (3,'third','third, and last, entry in the table', 'I like multiple lines in DB tables, but I\'m too lazy to go further than 3!!');
--- 13,23 ----
test1_desc char(250) NOT NULL default 'non documented',
test1_text text NOT NULL default '',
+ test1_ll bigint NOT NULL,
PRIMARY KEY (test1_id)
) TYPE=MyISAM COMMENT='A simple test table for CLI_Test application running with SMySQL framework.';
! INSERT INTO test1 (test1_id, test1_name, test1_desc, test1_text, test1_ll) VALUES (1,'first','first entry in the table', 'this is a text, which is indeed stored in the DB as a blob, hence you have to use the proper method to display it as a NSString rather than NSData...', '2147483647');
! INSERT INTO test1 (test1_id, test1_name, test1_desc, test1_text, test1_ll) VALUES (2,'second','second entry in the table', 'just to have more than just one line in the test1 table...', '2147483648');
! INSERT INTO test1 (test1_id, test1_name, test1_desc, test1_text, test1_ll) VALUES (3,'third','third, and last, entry in the table', 'I like multiple lines in DB tables, but I\'m too lazy to go further than 3!!', '9223372036854775806');
|
