MySQL Forums
Forum List  »  German

Maximale Größe von casted CHAR
Posted by: Lorenz Werner
Date: June 11, 2012 07:09AM

Hallo zusammen,

ich habe das Problem, dass sich 2 verschiedene MySQL Server scheinbar unterschiedlich verhalten bei der Max. Größe von CHAR.


Server 1:
- Version: 5.0.91-log

Server 2:
- Version: 5.1.62-0ubuntu0.10.04.1-log


Bei folgender Abfrage kommt es bei Server 1 zu maximal 4096 Zeichen, bei Server 2 ist allerdings schon bei 1024 schluß (Folgende Abfrage ist fehlerhaft: CAST(GROUP_CONCAT(DISTINCT local_accounting__orders.order_id SEPARATOR ", ") as CHAR(4096)) as order_id):

SELECT
local_accounting.accounting_id,
local_accounting.accounting_number,
local_accounting.complete_accounting_number,
local_accounting.notable,
YEAR(local_accounting.accounting_date) as accounting_year,
CAST(GROUP_CONCAT(DISTINCT local_accounting__orders.order_id SEPARATOR ", ") as CHAR(4096)) as order_id,
local_orders.status,
IF(local_accounting.accounting_status = '.Constants::get('status_invoice_storno').',
0,
SUM(local_order_prices.price)
) as price,
local_accounting.accounting_status as invoice_status,
users.user_id,
users.title,
users.firstname,
users.lastname,
users.name1,
users.name2,
users.name3,
local_user_locations.zip,
local_user_locations.city,
local_user_invoice_addresses.firstname as user_invoice_address_firstname,
local_user_invoice_addresses.lastname as user_invoice_address_lastname,
local_user_invoice_addresses.name1 as user_invoice_address_name1,
local_user_invoice_addresses.name2 as user_invoice_address_name2,
local_user_invoice_addresses.name3 as user_invoice_address_name3,
local_user_invoice_addresses.street as user_invoice_address_street,
local_user_invoice_addresses.house_no as user_invoice_address_house_no,
local_user_invoice_addresses.zip as user_invoice_address_zip,
local_user_invoice_addresses.city as user_invoice_address_city,
local_cost_centers.short_description as cost_center_description,
local_cost_centers.name1 as cost_center_name1,
local_cost_centers.name2 as cost_center_name2,
local_cost_centers.name3 as cost_center_name3
FROM
local_accounting
INNER JOIN local_accounting__orders
ON 1
AND local_accounting__orders.accounting_id = local_accounting.accounting_id
INNER JOIN local_orders
ON 1
AND local_orders.order_id = local_accounting__orders.order_id
LEFT JOIN local_cost_centers__orders
ON 1
AND local_cost_centers__orders.order_id = local_orders.order_id
LEFT JOIN local_cost_centers
ON 1
AND local_cost_centers.cost_center_id = local_cost_centers__orders.cost_center_id
INNER JOIN local_order_prices
ON 1
AND local_order_prices.order_id = local_orders.order_id
AND local_order_prices.accounting_id = local_accounting.accounting_id
INNER JOIN local_product_price_types
ON 1
AND local_product_price_types.product_price_type_id = local_order_prices.product_price_type_id
INNER JOIN local_product_price_type_groups
ON 1
AND local_product_price_type_groups.product_price_type_group_id = local_product_price_types.product_price_type_group_id
AND local_product_price_type_groups.product_price_type_group_name IN ('. $price_type_group_name .')
INNER JOIN users
ON users.user_id = local_accounting.user_id
INNER JOIN
local_user_locations
ON 1
AND local_user_locations.user_location_id = users.main_location_id
LEFT JOIN
local_user_invoice_addresses
ON 1
AND local_user_invoice_addresses.user_id = local_accounting.user_id
WHERE 1
'.$where.'
AND local_accounting.accounting_type = '.$accounting_type.'
AND local_accounting.accounting_date >= "'.$date_from.'"
AND local_accounting.accounting_date <= "'.$date_to.'"
AND (users.firstname LIKE "%'.$search.'%"
OR local_accounting.complete_accounting_number LIKE "%'.$search.'%"
OR local_accounting__orders.order_id LIKE "%'.$search.'%"
OR users.lastname LIKE "%'.$search.'%"
OR users.name1 LIKE "%'.$search.'%"
OR users.name2 LIKE "%'.$search.'%"
OR users.name3 LIKE "%'.$search.'%")
GROUP BY local_accounting.accounting_id




Hat jemand von euch evtl eine Idee, wieso es auf Server 2 schhluß ist bei 1024 Zeichen?


Viele Grüße
Lorenz Werner



Edited 1 time(s). Last edit at 06/11/2012 07:11AM by Lorenz Werner.

Options: ReplyQuote


Subject
Views
Written By
Posted
Maximale Größe von casted CHAR
1483
June 11, 2012 07:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.