View Issue Details

IDProjectCategoryView StatusLast Update
0005761VALENTINA SERVERSQLpublic2012-04-10 22:38
ReporterKirillAssigned ToIvan Smahin 
PriorityhighSeveritycrashReproducibilityalways
Status resolvedResolutionfixed 
Product Version5.0 
Target VersionFixed in Version5.0 
Summary0005761: VServer crashes on query with binding from VPHP5.0
DescriptionPHP script:
<?php
ini_set('display_errors',1);
$conn = valentina_connect( "192.168.1.6:15433", "sa", "sa", "Latin1" );
if(!$conn) die ("error connecting!");
valentina_select_db("database1");
valentina_query("SELECT * FROM person WHERE Name = :1", array('john'));
valentina_close( $conn );
?>

Database damp attached
TagsNo tags attached.

Activities

Kirill Pekarov

Kirill Pekarov

2012-04-04 10:07

developer  

1.sql (3,416 bytes)
Kirill Pekarov

Kirill Pekarov

2012-04-04 10:22

developer   ~0006258

Binding array looks good.
After the query "SELECT * FROM person WHERE Name = :1",
VServer has sent exception 394504 and crashed.
Kirill Pekarov

Kirill Pekarov

2012-04-04 10:35

developer   ~0006259

2012-04-04 13:28:29.176171 (TID 140187690264320): (UID 27) Database 'database1.vdb' remoteID 34114704 registered.
2012-04-04 13:28:29.176224 (TID 140187690264320): (UID 27) Database 'database1' has been successfully opened.
2012-04-04 13:28:29.189456 (TID 140187665086208): (UID 27) I_SqlDatabase 'database1.vdb' SqlQuery 'SELECT * FROM person WHERE Name = :1'.
Ruslan Zasukhin

Ruslan Zasukhin

2012-04-10 22:38

administrator   ~0006263

issue was in fact that VPHP send strings as varbinary value, and there was no such convert ion in kernel ...
it is added now ..

Besides this bug have inspired improves in the Binding area of VPHP...

Issue History

Date Modified Username Field Change
2012-04-04 10:07 Kirill Pekarov New Issue
2012-04-04 10:07 Kirill Pekarov File Added: 1.sql
2012-04-04 10:22 Kirill Pekarov Note Added: 0006258
2012-04-04 10:35 Kirill Pekarov Note Added: 0006259
2012-04-10 22:38 Ruslan Zasukhin Note Added: 0006263
2012-04-10 22:38 Ruslan Zasukhin Status assigned => resolved
2012-04-10 22:38 Ruslan Zasukhin Fixed in Version => 5.0
2012-04-10 22:38 Ruslan Zasukhin Resolution open => fixed