|
Ticket
|
Type
|
Summary
|
Description
|
Submitted
|
|
26
|
Confirmed
|
disabled parameter parsing doesn't work for and()
|
|
2010-12-15
|
|
24
|
Confirmed
|
Handle NULL values
|
This code produces:
SELECT * FROM `table` WHERE `field`
when it should be:
SELECT * FROM `table` WHERE `field` is NULL
Also in DELETE, INSERT UPDATE queries, there is no way to correctly handle DB NULL values
|
2010-12-06
|
|
23
|
Confirmed
|
Disable SQL quoting in 0.4.1 interprets 0 value as false
|
db->where("param",0) results in disabling of escaping!
|
2010-12-06
|
|
22
|
Confirmed
|
MySQL GroupBy improper quoting
|
MySQL GroupBy improperly quotes the argument passed into GroupBy.
It should be either parsing the string contents and smart quoting based on the string content, or using apostrophe/backticks, or doing nothing at all.
The current behavior is to wrap each string in a single quote, which is definitely not correct (results in unexpected behavior in MySQL).
|
2010-12-06
|
|
21
|
Confirmed
|
using * in the field for select
|
I know we can simply do
$db->get($table);
But i would like to use * in some conditions.
Right now it throws exception that * is not any fields.
|
2010-12-06
|
|
20
|
Confirmed
|
last_insert_id() returns 0
|
Row is saved to database, but last_insert_id() returns 0
|
2010-12-06
|
|
19
|
Confirmed
|
Column type
|
In the helper class (In my situation: crystal-0.4/Crystal/Helper/Postgres.php) methods have only data types: string and numeric. "Boolean" should be added to the methods like:
elseif(is_bool($string))
{
...
}
|
2010-12-06
|
|
15
|
Confirmed
|
Generate wrong sql at inner_join syntax
|
The generated sql should be like:
select `country`,`city`,`city`.`active`,`country`.`active`
from `country` inner join `city` on `country`.`id`=`city`.`countryid`
but if tracked using print_r($db), the sql value is:
select `country`,`city`,`city.active`,`country.active`
from `country` inner join 'city' on `country`.`id`=`city`.`countryid`
the inner join `city` is generated 'city' (using quote), and the `city`.`active` is generated `city.active`.
Tracked down to the source, i think that syntax
$this->join = "INNER JOIN " . Crystal_Helper_Mysql::add_single_quote($params[0]) . " ON " . $params[1];
at line 51, the "Crystal_Helper_Mysql::add_single_quote" seems to be the culprit. i think it should be "Crystal_Helper_Mysql::add_apostrophe".
as for the `city.active` issue, i think at the "Crystal_Helper_Mysql::add_apostrophe" function is not detecting any "dot" symbol, and what i've done is adding a string replacement for . (dot) and change it into `.`.
|
2010-04-12
|
|
7
|
Feature
|
New syntax in the Validation class
|
Arrays are very hard to follow when you have multiple fields with multiple rules, therefor in Crystal 0.4 you can write | instead of array();
|
2010-03-06
|
|
3
|
Feature
|
Add times executed to execute() function
|
This parameter is very valuable in the situations when you need to insert test data in your database
|
2010-02-23
|
|
2
|
Feature
|
Select related fields
|
Not documented yet
|
2010-02-07
|
|
1
|
Feature
|
Exclude database fields from select query
|
New parameter to the get() function, which will exclude table columns from the final result
|
2010-02-07
|
