[Mysql-cocoa-commits] CVS: SMySQL/CLI_Test Make_DB_and_table.mysql,1.1,1.2

[Serge C. <ser...@us...>]

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');