Hello Xypron, $ echo $LANG pt_BR.UTF-8
But I tested changed to C, en_US.UTF-8 and not worked. $ glpsol -m nurse.mod GLPSOL: GLPK LP/MIP Solver, v4.43 Parameter(s) specified in the command line: -m nurse.mod Reading model section from nurse.mod... 20 lines were read Reading shifts_cost... SELECT id,cost FROM shifts Display statement at line 19 I: (1,'1.000') (2,'1.200') (3,'1.300') Model has been successfully generated GLPK Simplex Optimizer, v4.43 0 rows, 0 columns, 0 non-zeros ~ 0: obj = 0.000000000e+00 infeas = 0.000e+00 OPTIMAL SOLUTION FOUND Time used: 0.0 secs Memory used: 0.1 Mb (70106 bytes) Thanks for you agility. On Sat, Sep 4, 2010 at 22:01, glpk xypron <[email protected]> wrote: > Hello Marcello, > > please, run the following: > > set I, dimen 2; > table shifts_cost IN "MySQL" 'Database=nsp;UID=nsp;PWD=nurseproblem' > 'SELECT id,cost FROM shifts' : > I <- [id, cost]; > display I; > end; > > and send the result. > > What is the output of system command locale? > > Best regards > > Xypron > > > -------- Original-Nachricht -------- >> Datum: Sat, 4 Sep 2010 20:53:14 -0300 >> Betreff: Re: [Help-glpk] Error: requires numeric data. > >> Hello Xypron, >> >> mysql> desc shifts; >> +-------------------+------------------+------+-----+---------+----------------+ >> | Field | Type | Null | Key | Default | Extra >> | >> +-------------------+------------------+------+-----+---------+----------------+ >> | id | int(11) unsigned | NO | PRI | NULL | >> auto_increment | >> | shift | varchar(100) | YES | | | >> | >> | duration_in_hours | tinyint(4) | NO | | NULL | >> | >> | cost | double | YES | | NULL | >> | >> +-------------------+------------------+------+-----+---------+----------------+ >> 4 rows in set (0.00 sec) >> >> mysql> select * from shifts; >> +----+--------+-------------------+------------------+ >> | id | shift | duration_in_hours | cost | >> +----+--------+-------------------+------------------+ >> | 1 | turno1 | 8 | 1 | >> | 2 | turno2 | 8 | 1.20000004768372 | >> | 3 | turno3 | 8 | 1.29999995231628 | >> +----+--------+-------------------+------------------+ >> 3 rows in set (0.00 sec) >> >> $ mysql --version >> mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using >> readline 6.1 >> >> $ dpkg -l|grep mysql >> ii libaprutil1-dbd-mysql 1.3.9+dfsg-3 The Apache Portable Runtime >> Utility Library - MySQL Dri >> ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL >> database >> ii libmysql-ruby 2.8.2-1 MySQL module for Ruby >> ii libmysql-ruby1.8 2.8.2-1 MySQL module for Ruby 1.8 >> ii libmysqlclient15-dev 5.0.51a-24+lenny2 MySQL database development >> files >> ii libmysqlclient15off 5.0.51a-24+lenny2 MySQL database client >> library >> ii libmysqlclient16 5.1.49-1 MySQL database client library >> ii libqt4-sql-mysql 4:4.6.3-1 Qt 4 MySQL database driver >> ii mysql-client-5.1 5.1.49-1 MySQL database client binaries >> ii mysql-common 5.1.49-1 MySQL database common files, e.g. >> /etc/mysql/my.cnf >> ii mysql-server 5.1.49-1 MySQL database server (metapackage >> depending on the lat >> ii mysql-server-5.1 5.1.49-1 MySQL database server binaries and >> system database setu >> ii mysql-server-core-5.1 5.1.49-1 MySQL database server binaries >> ii php5-mysql 5.3.2-2 MySQL module for php5 >> >> $ glpsol -m nurse.mod >> GLPSOL: GLPK LP/MIP Solver, v4.43 >> Parameter(s) specified in the command line: >> -m nurse.mod >> Reading model section from nurse.mod... >> Reading data section from nurse.mod... >> 30 lines were read >> Reading shifts_cost... >> SELECT shift, cost FROM shifts >> nurse.mod:12: Shifts_cost requires numeric data >> MathProg model processing error >> >> I was careful to restart mysql, do not you think that strange? >> I await your advice. >> >> Thanks. >> >> On Sat, Sep 4, 2010 at 19:01, glpk xypron <[email protected]> wrote: >> > Hello Marcello, >> > >> > your examples runs fine, when I use the following to create the >> > MySQL table: >> > >> > USE nsp; >> > >> > DROP TABLE IF EXISTS shifts; >> > >> > CREATE TABLE shifts ( >> > id INT, >> > cost DOUBLE, >> > PRIMARY KEY ( id ) >> > ); >> > >> > INSERT INTO shifts ( id, cost ) VALUES >> > ( 1, 1. ), >> > ( 2, 2. ), >> > ( 3, 4.3 ); >> > >> > >> > Please, check the definition of column cost in >> > your MySQL table using one of the following commands: >> > >> > SHOW CREATE TABLE shifts; >> > DESCRIBE shifts; >> > >> > Best regards >> > >> > Xypron >> > >> > -------- Original-Nachricht -------- >> >> Datum: Sat, 4 Sep 2010 15:27:18 -0300 >> >> Betreff: [Help-glpk] Error: requires numeric data. >> > >> >> Hello, >> >> >> >> Looking in my bare bone model, see this error down, can you help me? >> >> >> >> $ glpsol -m nurse.mod >> >> GLPSOL: GLPK LP/MIP Solver, v4.43 >> >> Parameter(s) specified in the command line: >> >> -m nurse.mod >> >> Reading model section from nurse.mod... >> >> Reading data section from nurse.mod... >> >> 32 lines were read >> >> Reading shifts_cost... >> >> SELECT id,cost FROM shifts >> >> nurse.mod:14: Shifts_cost requires numeric data >> >> MathProg model processing error >> >> >> >> /* nurse.mod - Solve simple NSP - Nurse Scneduling Problem >> >> /*** Variables ***/ >> >> set SHIFTS; >> >> >> >> /*** Parameters ***/ >> >> /* Custo por turno */ >> >> param Shifts_cost{i in SHIFTS}; >> >> table shifts_cost IN "MySQL" 'Database=nsp;UID=nsp;PWD=nurseproblem' >> >> 'SELECT id,cost FROM shifts' : SHIFTS <- [id], Shifts_cost~cost; >> >> >> >> param Time_work >= 0; >> >> >> >> /*** solve section ***/ >> >> solve; >> >> for {i in SHIFTS} >> >> { >> >> printf "%d",Shifts_cost[i]; >> >> printf "\n"; >> >> } >> >> >> >> /*** data section ***/ >> >> data; >> >> >> >> #param Shifts_cost := 1 1, 2 2, 3 4.3; >> >> end; >> >> >> >> -- >> >> Marcello Henrique >> > >> > -- >> > GMX DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 >> Euro/mtl.!* >> > http://portal.gmx.net/de/go/dsl >> > >> >> >> >> -- >> Marcello Henrique >> Blog - http://faraohh.wordpress.com >> Associação Software Livre de Goiás (www.aslgo.org.br) >> Cercomp - UFG (www.cercomp.ufg.br) >> >> _______________________________________________ >> Help-glpk mailing list >> [email protected] >> http://lists.gnu.org/mailman/listinfo/help-glpk > > -- > GMX DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 Euro/mtl.!* > http://portal.gmx.net/de/go/dsl > -- Marcello Henrique Blog - http://faraohh.wordpress.com Associação Software Livre de Goiás (www.aslgo.org.br) Cercomp - UFG (www.cercomp.ufg.br) _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
