Bug #10363 | Error in 139 4.1.x series, but no error in 4.0.x series | ||
---|---|---|---|
Submitted: | 4 May 2005 17:06 | Modified: | 29 Sep 2008 21:48 |
Reporter: | Seth Russell | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 4.1.x | OS: | Linux (Linux and Solaris) |
Assigned to: | Heikki Tuuri | CPU Architecture: | Any |
[4 May 2005 17:06]
Seth Russell
[4 May 2005 17:24]
MySQL Verification Team
Could you please provide a complete test case ? Thanks in advance.
[4 May 2005 18:08]
Heikki Tuuri
Hi! Are you using UTF-8 or TEXT fields longer than 512 bytes? --Heikki
[4 May 2005 18:23]
Seth Russell
I would love to provide more information... Please explain what exactly you would like, if this is not sufficent. I provided the create table syntax, and an insert statement that generates the error in the 4.1.x series. The same create table and insert statement does not generate an error in the 4.0.x series. Actual steps to re-create error (Note this is the mysql 4.1.x server): mysql -h mysqlhost_4_1_x -p mydb set foreign_key_checks = 0; source (file that has create statement and insert statement) Result: ERROR 1030 (HY000): Got error 139 from storage engine Expected result: Same behaviour as mysql 4.0.x server as shown below Steps to perform successfully (Note this is the mysql 4.0.x series server): mysql -h mysqlhost_4_0_x -p mydb set foreign_key_checks = 0; source (file that has create statement and insert statement) Result: Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.15 sec) Query OK, 1 row affected (0.02 sec)
[4 May 2005 18:48]
MySQL Verification Team
You are provide the create table: CREATE TABLE embark_application ( which has: <cut> (`physics_research_area_choice_1`) REFERENCES `research_area` (`embark_code`), CONSTRAINT `embark_application_ibfk_2` FOREIGN KEY (`gpa_scale`) REFERENCES `gpa_scales` (`code`), CONSTRAINT `embark_application_ibfk_20` FOREIGN KEY (`physics_research_area_choice_2`) REFERENCES `research_area` (`embark_code`), CONSTRAINT `embark_application_ibfk_21` FOREIGN KEY <cut> not having the other tables I can't create that table. Thanks.
[4 May 2005 19:42]
Seth Russell
Heikki, I have done nothing to specify a character encoding. The default character set on Linux is UTF-8, but I'm not sure what it is on Solaris 8 (sparc). In the database, I have done nothing to specify a character set (the table shows 'default'). I have done nothing in the mysql config files to specify a character set. The error occurs on mysql 4.1.x on both on Linux and Solaris. The largest text field (lit_writing_sample_text) in the data sample provided is 37435 bytes (in the 4.0.x db). The largest in the table is 65535 bytes.
[4 May 2005 19:43]
Seth Russell
Miguel, To create the table, you need to first execute the statement: set foreign_key_checks = 0; In my tests, the error occurs with the other tables present as well as with out the other tables.
[4 May 2005 20:07]
Heikki Tuuri
Seth, 4.1.xx stores 768 bytes of TEXT locally to the row, while 4.0 only stored 512 bytes. That may explain the error. We may fix this in 5.0.xx, so that only indexed TEXT columns put that prefix locally to the record. The workaround is to move some TEXT fields to another table. If you have moved to UTF-8, then all CHAR(n) columns take 3 x the old size. That has also caused problems for some users. Regards, Heikki
[4 May 2005 20:13]
MySQL Verification Team
-> NULL,NULL,'1001-11-11 11:11:11',11); Query OK, 1 row affected (0.12 sec) mysql> select version(); +------------------+ | version() | +------------------+ | 4.0.24-debug-log | +------------------+ 1 row in set (0.02 sec) -> NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, -> -> NULL,NULL,'1001-11-11 11:11:11',11); ERROR 1030 (HY000): Got error 139 from storage engine mysql> select version(); +------------------+ | version() | +------------------+ | 4.1.11-debug-log | +------------------+ 1 row in set (0.00 sec)
[4 May 2005 21:25]
Seth Russell
Heikki, Thanks for your help in this issue. If what you said about more of the 'TEXT' field being stored in locally in the table in 4.1.x then in 4.0.x, that means the documenation: http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html is incorrect. Do I need to open a separate bug to request the documentation to be updated, or can you do it? seth
[5 May 2005 7:22]
Heikki Tuuri
Seth, the documentation error is already listed in the bugs database, about 3 weeks ago. I have to fix the docs. Thank you, Heikki
[5 May 2005 18:31]
Seth Russell
Heikki, You said that in 4.1.x text fields acutally put 768 bytes in the local table (and count toward the row maximum). The documentation says that row length should be approximately 8000 bytes. I wrote a little query (see below) that calculates row length. The maximum row length that I am able to have in 4.1.x (on linux and solaris) is actually 6947 bytes (as measured by the function length()). Is this another problem with the documentation, or are there other issues involved with length calculation? -------------------------------------------------------------- select id, if ( ifnull(length( citizen_comments ),0) > 768, 768, ifnull(length( citizen_comments ),0)) as atest, ifnull(length( citizen_comments ),0) as a, if ( ifnull(length( sociology_writing_sample_text ),0) > 768, 768, ifnull(length( sociology_writing_sample_text ),0)) as btest, ifnull(length( sociology_writing_sample_text ),0) as b, if ( ifnull(length( language_proficiency ),0) > 768, 768, ifnull(length( language_proficiency ),0)) as ctest, ifnull(length( language_proficiency ),0) as c, if ( ifnull(length( research_work ),0) > 768, 768, ifnull(length( research_work ),0)) as dtest, ifnull(length( research_work ),0) as d from embark_application where id < 20; +----+-------+---+-------+---+-------+-----+-------+------+ | id | atest | a | btest | b | ctest | c | dtest | d | +----+-------+---+-------+---+-------+-----+-------+------+ | 1 | 0 | 0 | 0 | 0 | 188 | 188 | 223 | 223 | | 2 | 0 | 0 | 0 | 0 | 768 | 524 | 468 | 468 | | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 303 | 303 | | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 162 | 162 | | 5 | 0 | 0 | 0 | 0 | 205 | 205 | 471 | 471 | | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 52 | | 7 | 0 | 0 | 0 | 0 | 347 | 347 | 432 | 432 | | 8 | 0 | 0 | 0 | 0 | 71 | 71 | 338 | 338 | | 9 | 0 | 0 | 0 | 0 | 155 | 155 | 460 | 460 | | 10 | 0 | 0 | 0 | 0 | 231 | 231 | 227 | 227 | | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 12 | 0 | 0 | 0 | 0 | 46 | 46 | 768 | 1812 | | 13 | 0 | 0 | 0 | 0 | 221 | 221 | 768 | 628 | | 14 | 2 | 2 | 0 | 0 | 41 | 41 | 356 | 356 | | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 216 | 216 | | 16 | 0 | 0 | 0 | 0 | 29 | 29 | 173 | 173 | | 17 | 0 | 0 | 0 | 0 | 122 | 122 | 304 | 304 | | 18 | 0 | 0 | 0 | 0 | 98 | 98 | 213 | 213 | | 19 | 0 | 0 | 0 | 0 | 155 | 155 | 249 | 249 | +----+-------+---+-------+---+-------+-----+-------+------+ select id, if ( ifnull(length( additional_info ),0) > 768, 768, ifnull(length( additional_info ),0)) as a, if ( ifnull(length( anthro_writing_sample_text ),0) > 768, 768, ifnull(length( anthro_writing_sample_text ),0)) as b, if ( ifnull(length( benefit_society ),0) > 768, 768, ifnull(length( benefit_society ),0)) as c, if ( ifnull(length( citizen_comments ),0) > 768, 768, ifnull(length( citizen_comments ),0)) as d, if ( ifnull(length( digital_arts_and_new_media_writing_sample_url ),0) > 768, 768, ifnull(length( digital_arts_and_new_media_writing_sample_url ),0)) as e, if ( ifnull(length( ed_credential_bclad_sing_which ),0) > 768, 768, ifnull(length( ed_credential_bclad_sing_which ),0)) as f, if ( ifnull(length( ed_credential_clad_sing_which ),0) > 768, 768, ifnull(length( ed_credential_clad_sing_which ),0))as g, if ( ifnull(length( ed_resume_test ),0) > 768, 768, ifnull(length( ed_resume_test ),0))as h, if ( ifnull(length( ed_writing_sample_edd_text ),0) > 768, 768, ifnull(length( ed_writing_sample_edd_text ),0)) as i, if ( ifnull(length( ed_writing_sample_ma_text ),0) > 768, 768, ifnull(length( ed_writing_sample_ma_text ),0))as j, if ( ifnull(length( ed_writing_sample_phd_text ),0) > 768, 768, ifnull(length( ed_writing_sample_phd_text ),0))as k, if ( ifnull(length( fellow_applied ),0) > 768, 768, ifnull(length( fellow_applied ),0)) as l, if ( ifnull(length( fellow_awarded ),0) > 768, 768, ifnull(length( fellow_awarded ),0)) as m, if ( ifnull(length( hist_con_writing_sample_text ),0) > 768, 768, ifnull(length( hist_con_writing_sample_text ),0)) as n, if ( ifnull(length( history_writing_sample_text ),0) > 768, 768, ifnull(length( history_writing_sample_text ),0)) as o, if ( ifnull(length( language_proficiency ),0) > 768, 768, ifnull(length( language_proficiency ),0)) as p, if ( ifnull(length( linguistics_essay ),0) > 768, 768, ifnull(length( linguistics_essay ),0)) as q, if ( ifnull(length( list_pubs ),0) > 768, 768, ifnull(length( list_pubs ),0)) as r, if ( ifnull(length( list_teaching ),0) > 768, 768, ifnull(length( list_teaching ),0))as s, if ( ifnull(length( lit_writing_sample_text ),0) > 768, 768, ifnull(length( lit_writing_sample_text ),0)) as t, if ( ifnull(length( music_dma_writing_sample_text ),0) > 768, 768, ifnull(length( music_dma_writing_sample_text ),0)) as u, if ( ifnull(length( music_writing_sample_text ),0) > 768, 768, ifnull(length( music_writing_sample_text ),0)) as v, if ( ifnull(length( obstacles ),0) > 768, 768, ifnull(length( obstacles ),0)) as w, if ( ifnull(length( philosophy_writing_sample_text ),0) > 768, 768, ifnull(length( philosophy_writing_sample_text ),0)) as x, if ( ifnull(length( politics_writing_sample_text ),0) > 768, 768, ifnull(length( politics_writing_sample_text ),0)) as y, if ( ifnull(length( research_work ),0) > 768, 768, ifnull(length( research_work ),0)) as z, if ( ifnull(length( resume_text ),0) > 768, 768, ifnull(length( resume_text ),0)) as aa, if ( ifnull(length( social_doc_writing_sample_text ),0) > 768, 768, ifnull(length( social_doc_writing_sample_text ),0)) as ab, if ( ifnull(length( social_doc_writing_sample_url ),0) > 768, 768, ifnull(length( social_doc_writing_sample_url ),0)) as ac, if ( ifnull(length( sociology_writing_sample_text ),0) > 768, 768, ifnull(length( sociology_writing_sample_text ),0))as ad, if ( ifnull(length( statement_purpose_text ),0) > 768, 768, ifnull(length( statement_purpose_text ),0)) as ae from embark_application where id < 20; select id, -- the non text part ifnull(length( fobrochure ),0) + ifnull(length( aka_middle_inital3 ),0) + ifnull(length( us_citizen ),0) + ifnull(length( aka_middle_inital2 ),0) + ifnull(length( nosupyn ),0) + ifnull(length( need_other_visa ),0) + ifnull(length( perm_prior_to_9_2003 ),0) + ifnull(length( part_time_flag ),0) + ifnull(length( prevreg ),0) + ifnull(length( ferpa_wavier_choice2 ),0) + ifnull(length( native_english_speaker ),0) + ifnull(length( toefl_taken ),0) + ifnull(length( fellowgran ),0) + ifnull(length( perm_prior_to_9_2004 ),0) + ifnull(length( foonline ),0) + ifnull(length( foother ),0) + ifnull(length( qualify_for_feewaiver ),0) + ifnull(length( fofriend ),0) + ifnull(length( forecruit ),0) + ifnull(length( need_f1 ),0) + ifnull(length( foweb ),0) + ifnull(length( ugfa ),0) + ifnull(length( teachas ),0) + ifnull(length( researchas ),0) + ifnull(length( teachcaree ),0) + ifnull(length( in_ca_1_year ),0) + ifnull(length( ug_volunteer ),0) + ifnull(length( aka_middle_inital1 ),0) + ifnull(length( aka_middle_inital5 ),0) + ifnull(length( maintain_current_visa_type ),0) + ifnull(length( ca_high_school ),0) + ifnull(length( california_residency ),0) + ifnull(length( ethnic ),0) + ifnull(length( ferpa_wavier_choice ),0) + ifnull(length( foadvisor ),0) + ifnull(length( aka_middle_inital4 ),0) + ifnull(length( gresubyn ),0) + ifnull(length( greyn ),0) + ifnull(length( current_f1 ),0) + ifnull(length( sex ),0) + ifnull(length( ferpa_wavier_choice3 ),0) + ifnull(length( folibrary ),0) + ifnull(length( prevapp ),0) + ifnull(length( referee2_state ),0) + ifnull(length( degstate1 ),0) + ifnull(length( referee1_phone ),0) + ifnull(length( other_citizen ),0) + ifnull(length( referee3_country ),0) + ifnull(length( referee3_email ),0) + ifnull(length( hs_state ),0) + ifnull(length( referee1_country ),0) + ifnull(length( degstate3 ),0) + ifnull(length( perm_addr_state ),0) + ifnull(length( referee2_phone ),0) + ifnull(length( birth_country ),0) + ifnull(length( occupation ),0) + ifnull(length( degcountry1 ),0) + ifnull(length( which_other_visa ),0) + ifnull(length( referee2_email ),0) + ifnull(length( degcountry3 ),0) + ifnull(length( referee1_email ),0) + ifnull(length( degcountry2 ),0) + ifnull(length( degcountry6 ),0) + ifnull(length( degstate2 ),0) + ifnull(length( current_addr_state ),0) + ifnull(length( birth_state ),0) + ifnull(length( referee2_country ),0) + ifnull(length( degcountry5 ),0) + ifnull(length( degcountry4 ),0) + ifnull(length( prior_visa_status ),0) + ifnull(length( perm_resident ),0) + ifnull(length( degstate6 ),0) + ifnull(length( degstate4 ),0) + ifnull(length( degstate5 ),0) + ifnull(length( referee3_phone ),0) + ifnull(length( referee1_state ),0) + ifnull(length( perm_addr_country ),0) + ifnull(length( referee3_state ),0) + ifnull(length( current_addr_country ),0) + ifnull(length( current_visa_type ),0) + ifnull(length( subjscore ),0) + ifnull(length( tscore ),0) + ifnull(length( subjpct ),0) + ifnull(length( grequantp ),0) + ifnull(length( numsb ),0) + ifnull(length( numsbcol ),0) + ifnull(length( greverbp ),0) + ifnull(length( greanalp ),0) + ifnull(length( last_update ),0) + ifnull(length( attendto4_month ),0) + ifnull(length( degree4_date_month ),0) + ifnull(length( attendfr3_month ),0) + ifnull(length( ed_cset_test_date_month ),0) + ifnull(length( attendto1_month ),0) + ifnull(length( apply_date_day ),0) + ifnull(length( degree3_date_month ),0) + ifnull(length( degree5_date_month ),0) + ifnull(length( attendfr6_month ),0) + ifnull(length( attendto3_month ),0) + ifnull(length( ed_ssat_test_date_year ),0) + ifnull(length( attendfr2_month ),0) + ifnull(length( subjdate_month ),0) + ifnull(length( attendfr5_month ),0) + ifnull(length( ed_ssat_test_date_month ),0) + ifnull(length( us_social_security_num2 ),0) + ifnull(length( ed_cset_test_date_year ),0) + ifnull(length( ed_praxis_test_date_year ),0) + ifnull(length( attendfr4_month ),0) + ifnull(length( ed_msat_test_date_month ),0) + ifnull(length( ed_cbest_test_date_day ),0) + ifnull(length( ed_msat_test_date_year ),0) + ifnull(length( ed_msat_test_date_day ),0) + ifnull(length( attendto5_month ),0) + ifnull(length( ed_cset_test_date_day ),0) + ifnull(length( ed_bclad_test_date_year ),0) + ifnull(length( ed_cbest_test_date_day2 ),0) + ifnull(length( birth_mo ),0) + ifnull(length( ed_cbest_test_date_month2 ),0) + ifnull(length( ed_ssat_test_date_day ),0) + ifnull(length( ed_bclad6_test_date_day ),0) + ifnull(length( ed_bclad6_test_date_month ),0) + ifnull(length( submit_date_day ),0) + ifnull(length( attendto6_month ),0) + ifnull(length( toefldate_month ),0) + ifnull(length( ed_cbest_test_date_year ),0) + ifnull(length( degree1_date_month ),0) + ifnull(length( attendfr1_month ),0) + ifnull(length( apply_date_month ),0) + ifnull(length( gendate_month ),0) + ifnull(length( ed_cbest_test_date_year2 ),0) + ifnull(length( submit_date_month ),0) + ifnull(length( attendto2_month ),0) + ifnull(length( ed_cbest_test_date_month ),0) + ifnull(length( degree2_date_month ),0) + ifnull(length( degree6_date_month ),0) + ifnull(length( ed_praxis_test_date_day ),0) + ifnull(length( birth_day ),0) + ifnull(length( ed_praxis_test_date_month ),0) + ifnull(length( last_user_id ),0) + ifnull(length( id ),0) + ifnull(length( form_instance_id ),0) + ifnull(length( user_id ),0) + ifnull(length( birth_year ),0) + ifnull(length( attendto5_year ),0) + ifnull(length( attendfr1_year ),0) + ifnull(length( apply_date_year ),0) + ifnull(length( toefldate_year ),0) + ifnull(length( degree5_date_year ),0) + ifnull(length( subjdate_year ),0) + ifnull(length( attendto2_year ),0) + ifnull(length( degree1_date_year ),0) + ifnull(length( attendto6_year ),0) + ifnull(length( attendto1_year ),0) + ifnull(length( degree2_date_year ),0) + ifnull(length( attendfr2_year ),0) + ifnull(length( degree4_date_year ),0) + ifnull(length( prevapp_year ),0) + ifnull(length( attendfr4_year ),0) + ifnull(length( gendate_year ),0) + ifnull(length( attendto3_year ),0) + ifnull(length( qualifying_program_year ),0) + ifnull(length( volunteer_type1_hrs ),0) + ifnull(length( ug_hours2 ),0) + ifnull(length( ug_hours1 ),0) + ifnull(length( us_social_security_num3 ),0) + ifnull(length( submit_date_year ),0) + ifnull(length( hs_advplcl ),0) + ifnull(length( volunteer_type2_hrs ),0) + ifnull(length( degree6_date_year ),0) + ifnull(length( attendto4_year ),0) + ifnull(length( attendfr5_year ),0) + ifnull(length( attendfr3_year ),0) + ifnull(length( attendfr6_year ),0) + ifnull(length( us_social_security_num1 ),0) + ifnull(length( degree3_date_year ),0) + ifnull(length( referee1_recommender_id ),0) + ifnull(length( referee2_recommender_id ),0) + ifnull(length( referee3_recommender_id ),0) + ifnull(length( authorization_code ),0) + ifnull(length( grad_program ),0) + ifnull(length( payment_method ),0) + ifnull(length( degree3 ),0) + ifnull(length( qualifying_program ),0) + ifnull(length( degree2 ),0) + ifnull(length( degree6 ),0) + ifnull(length( degree5 ),0) + ifnull(length( degree1 ),0) + ifnull(length( degree4 ),0) + ifnull(length( native_lang ),0) + ifnull(length( major6 ),0) + ifnull(length( major4 ),0) + ifnull(length( major2 ),0) + ifnull(length( major5 ),0) + ifnull(length( major1 ),0) + ifnull(length( major3 ),0) + ifnull(length( current_addr_street1 ),0) + ifnull(length( volunteer_type2 ),0) + ifnull(length( perm_addr_zip ),0) + ifnull(length( focontact2_first ),0) + ifnull(length( other_degstate3 ),0) + ifnull(length( aka_first_name2 ),0) + ifnull(length( referee1_inst_other ),0) + ifnull(length( current_addr_street2 ),0) + ifnull(length( cs_research_area_choice_other ),0) + ifnull(length( ce_research_area_choice_3 ),0) + ifnull(length( psych_research_area_choice1 ),0) + ifnull(length( cs_research_area_choice_1 ),0) + ifnull(length( ce_research_area_choice_other ),0) + ifnull(length( referee2_street_addr ),0) + ifnull(length( aka_first_name5 ),0) + ifnull(length( focontact1_last ),0) + ifnull(length( ce_research_area_choice_1 ),0) + ifnull(length( referee2_state_other ),0) + ifnull(length( current_addr_city ),0) + ifnull(length( referee2_title ),0) + ifnull(length( aka_last_name4 ),0) + ifnull(length( biol_research_area ),0) + ifnull(length( aka_first_name3 ),0) + ifnull(length( referee2_inst_other ),0) + ifnull(length( other_degstate6 ),0) + ifnull(length( aka_last_name5 ),0) + ifnull(length( other_degstate5 ),0) + ifnull(length( referee2_city ),0) + ifnull(length( current_phone_number ),0) + ifnull(length( referee1_state_other ),0) + ifnull(length( ug_employment1 ),0) + ifnull(length( ee_research_area_choice_1 ),0) + ifnull(length( ee_research_area_choice_3 ),0) + ifnull(length( ee_research_area_choice_other ),0) + ifnull(length( other_school3 ),0) + ifnull(length( embark_login_email ),0) + ifnull(length( perm_addr_street2 ),0) + ifnull(length( other_school4 ),0) + ifnull(length( referee1_city ),0) + ifnull(length( aka_last_name3 ),0) + ifnull(length( referee1_title ),0) + ifnull(length( referee1_name_last ),0) + ifnull(length( aka_last_name1 ),0) + ifnull(length( other_degstate4 ),0) + ifnull(length( prevapp_major ),0) + ifnull(length( cs_research_area_choice_3 ),0) + ifnull(length( referee2_name_first ),0) + ifnull(length( referee2_name_last ),0) + ifnull(length( aka_last_name2 ),0) + ifnull(length( aka_first_name1 ),0) + ifnull(length( first_name ),0) + ifnull(length( father_occ ),0) + ifnull(length( other_school6 ),0) + ifnull(length( perm_phone_number ),0) + ifnull(length( research_emphasis ),0) + ifnull(length( other_school5 ),0) + ifnull(length( current_phone_area ),0) + ifnull(length( middle_name ),0) + ifnull(length( birth_state_other ),0) + ifnull(length( ce_research_area_choice_2 ),0) + ifnull(length( perm_phone_area ),0) + ifnull(length( perm_addr_city ),0) + ifnull(length( referee3_name_last ),0) + ifnull(length( ee_research_area_choice_2 ),0) + ifnull(length( other_school2 ),0) + ifnull(length( referee1_zip ),0) + ifnull(length( perm_addr_street1 ),0) + ifnull(length( focontact1_first ),0) + ifnull(length( focontact1_discipline ),0) + ifnull(length( scicomm_research_area ),0) + ifnull(length( chem_research_area_choice_2 ),0) + ifnull(length( perm_addr_state_other ),0) + ifnull(length( forecruit_contact ),0) + ifnull(length( referee3_inst_other ),0) + ifnull(length( referee1_name_first ),0) + ifnull(length( cs_research_area_choice_2 ),0) + ifnull(length( ugfa_terms2 ),0) + ifnull(length( referee3_street_addr ),0) + ifnull(length( referee3_city ),0) + ifnull(length( referee3_zip ),0) + ifnull(length( other_degstate1 ),0) + ifnull(length( referee3_title ),0) + ifnull(length( referee3_name_first ),0) + ifnull(length( referee1_street_addr ),0) + ifnull(length( other_eth ),0) + ifnull(length( tribalaff ),0) + ifnull(length( ug_employment2 ),0) + ifnull(length( other_degstate2 ),0) + ifnull(length( email_addr ),0) + ifnull(length( hs_state_other ),0) + ifnull(length( hs_num ),0) + ifnull(length( referee2_zip ),0) + ifnull(length( hsname ),0) + ifnull(length( hsloc ),0) + ifnull(length( other_school1 ),0) + ifnull(length( ugfa_type1 ),0) + ifnull(length( current_addr_state_other ),0) + ifnull(length( volunteer_type1 ),0) + ifnull(length( aka_first_name4 ),0) + ifnull(length( ugfa_terms1 ),0) + ifnull(length( ugfa_type2 ),0) + ifnull(length( guardian_occ ),0) + ifnull(length( mother_occ ),0) + ifnull(length( last_name ),0) + ifnull(length( focontact2_last ),0) + ifnull(length( chem_research_area_choice_1 ),0) + ifnull(length( focontact2_discipline ),0) + ifnull(length( father_edu ),0) + ifnull(length( guardian_edu ),0) + ifnull(length( referee3_state_other ),0) + ifnull(length( current_addr_state_zip ),0) + ifnull(length( mother_edu ),0) + ifnull(length( ocea_researcharea_choice1 ),0) + ifnull(length( ocea_researcharea_choice2 ),0) + ifnull(length( ocea_faculty_sponsor_name ),0) + ifnull(length( physics_research_area_choice_other ),0) + ifnull(length( qualifying_program_institution_other ),0) + ifnull(length( foother_text ),0) + ifnull(length( ed_credential ),0) + ifnull(length( physics_research_area_choice_2 ),0) + ifnull(length( physics_research_area_choice_1 ),0) + ifnull(length( physics_research_area_choice_3 ),0) + ifnull(length( school3 ),0) + ifnull(length( school1 ),0) + ifnull(length( referee3_institution ),0) + ifnull(length( school2 ),0) + ifnull(length( school6 ),0) + ifnull(length( school5 ),0) + ifnull(length( qualifying_program_institution ),0) + ifnull(length( school4 ),0) + ifnull(length( referee2_institution ),0) + ifnull(length( referee1_institution ),0) + ifnull(length( selfgpa ),0) + ifnull(length( subjcode ),0) + ifnull(length( grequant ),0) + ifnull(length( greanal ),0) + ifnull(length( greverb ),0) + ifnull(length( term_applying_for ),0) + ifnull(length( qualifying_program_season ),0) + ifnull(length( prevapp_qtr ),0) + ifnull(length( diversity_fellowship ),0) + ifnull(length( financial_support ),0) + ifnull(length( eap_app ),0) + ifnull(length( gpa_scale ),0) + ifnull(length( foreign_domestic ),0) as totalnontext, -- the text part if ( ifnull(length( additional_info ),0) > 768, 768 , ifnull(length( additional_info ),0)) + if ( ifnull(length( anthro_writing_sample_text ),0) > 768, 768 , ifnull(length( anthro_writing_sample_text ),0)) + if ( ifnull(length( benefit_society ),0) > 768, 768 , ifnull(length( benefit_society ),0)) + if ( ifnull(length( citizen_comments ),0) > 768, 768 , ifnull(length( citizen_comments ),0)) + if ( ifnull(length( digital_arts_and_new_media_writing_sample_url ),0) > 768, 768 , ifnull(length( digital_arts_and_new_media_writing_sample_url ),0)) + if ( ifnull(length( ed_credential_bclad_sing_which ),0) > 768, 768 , ifnull(length( ed_credential_bclad_sing_which ),0)) + if ( ifnull(length( ed_credential_clad_sing_which ),0) > 768, 768 , ifnull(length( ed_credential_clad_sing_which ),0)) + if ( ifnull(length( ed_resume_test ),0) > 768, 768 , ifnull(length( ed_resume_test ),0)) + if ( ifnull(length( ed_writing_sample_edd_text ),0) > 768, 768 , ifnull(length( ed_writing_sample_edd_text ),0)) + if ( ifnull(length( ed_writing_sample_ma_text ),0) > 768, 768 , ifnull(length( ed_writing_sample_ma_text ),0)) + if ( ifnull(length( ed_writing_sample_phd_text ),0) > 768, 768 , ifnull(length( ed_writing_sample_phd_text ),0)) + if ( ifnull(length( fellow_applied ),0) > 768, 768 , ifnull(length( fellow_applied ),0)) + if ( ifnull(length( fellow_awarded ),0) > 768, 768 , ifnull(length( fellow_awarded ),0)) + if ( ifnull(length( hist_con_writing_sample_text ),0) > 768, 768 , ifnull(length( hist_con_writing_sample_text ),0)) + if ( ifnull(length( history_writing_sample_text ),0) > 768, 768 , ifnull(length( history_writing_sample_text ),0)) + if ( ifnull(length( language_proficiency ),0) > 768, 768 , ifnull(length( language_proficiency ),0)) + if ( ifnull(length( linguistics_essay ),0) > 768, 768 , ifnull(length( linguistics_essay ),0)) + if ( ifnull(length( list_pubs ),0) > 768, 768 , ifnull(length( list_pubs ),0)) + if ( ifnull(length( list_teaching ),0) > 768, 768 , ifnull(length( list_teaching ),0)) + if ( ifnull(length( lit_writing_sample_text ),0) > 768, 768 , ifnull(length( lit_writing_sample_text ),0)) + if ( ifnull(length( music_dma_writing_sample_text ),0) > 768, 768 , ifnull(length( music_dma_writing_sample_text ),0)) + if ( ifnull(length( music_writing_sample_text ),0) > 768, 768 , ifnull(length( music_writing_sample_text ),0)) + if ( ifnull(length( obstacles ),0) > 768, 768 , ifnull(length( obstacles ),0)) + if ( ifnull(length( philosophy_writing_sample_text ),0) > 768, 768 , ifnull(length( philosophy_writing_sample_text ),0)) + if ( ifnull(length( politics_writing_sample_text ),0) > 768, 768 , ifnull(length( politics_writing_sample_text ),0)) + if ( ifnull(length( research_work ),0) > 768, 768 , ifnull(length( research_work ),0)) + if ( ifnull(length( resume_text ),0) > 768, 768 , ifnull(length( resume_text ),0)) + if ( ifnull(length( social_doc_writing_sample_text ),0) > 768, 768 , ifnull(length( social_doc_writing_sample_text ),0)) + if ( ifnull(length( social_doc_writing_sample_url ),0) > 768, 768 , ifnull(length( social_doc_writing_sample_url ),0)) + if ( ifnull(length( sociology_writing_sample_text ),0) > 768, 768 , ifnull(length( sociology_writing_sample_text ),0)) + if ( ifnull(length( statement_purpose_text ),0) > 768, 768 , ifnull(length( statement_purpose_text ),0)) as totaltext, -- the non text part ifnull(length( fobrochure ),0) + ifnull(length( aka_middle_inital3 ),0) + ifnull(length( us_citizen ),0) + ifnull(length( aka_middle_inital2 ),0) + ifnull(length( nosupyn ),0) + ifnull(length( need_other_visa ),0) + ifnull(length( perm_prior_to_9_2003 ),0) + ifnull(length( part_time_flag ),0) + ifnull(length( prevreg ),0) + ifnull(length( ferpa_wavier_choice2 ),0) + ifnull(length( native_english_speaker ),0) + ifnull(length( toefl_taken ),0) + ifnull(length( fellowgran ),0) + ifnull(length( perm_prior_to_9_2004 ),0) + ifnull(length( foonline ),0) + ifnull(length( foother ),0) + ifnull(length( qualify_for_feewaiver ),0) + ifnull(length( fofriend ),0) + ifnull(length( forecruit ),0) + ifnull(length( need_f1 ),0) + ifnull(length( foweb ),0) + ifnull(length( ugfa ),0) + ifnull(length( teachas ),0) + ifnull(length( researchas ),0) + ifnull(length( teachcaree ),0) + ifnull(length( in_ca_1_year ),0) + ifnull(length( ug_volunteer ),0) + ifnull(length( aka_middle_inital1 ),0) + ifnull(length( aka_middle_inital5 ),0) + ifnull(length( maintain_current_visa_type ),0) + ifnull(length( ca_high_school ),0) + ifnull(length( california_residency ),0) + ifnull(length( ethnic ),0) + ifnull(length( ferpa_wavier_choice ),0) + ifnull(length( foadvisor ),0) + ifnull(length( aka_middle_inital4 ),0) + ifnull(length( gresubyn ),0) + ifnull(length( greyn ),0) + ifnull(length( current_f1 ),0) + ifnull(length( sex ),0) + ifnull(length( ferpa_wavier_choice3 ),0) + ifnull(length( folibrary ),0) + ifnull(length( prevapp ),0) + ifnull(length( referee2_state ),0) + ifnull(length( degstate1 ),0) + ifnull(length( referee1_phone ),0) + ifnull(length( other_citizen ),0) + ifnull(length( referee3_country ),0) + ifnull(length( referee3_email ),0) + ifnull(length( hs_state ),0) + ifnull(length( referee1_country ),0) + ifnull(length( degstate3 ),0) + ifnull(length( perm_addr_state ),0) + ifnull(length( referee2_phone ),0) + ifnull(length( birth_country ),0) + ifnull(length( occupation ),0) + ifnull(length( degcountry1 ),0) + ifnull(length( which_other_visa ),0) + ifnull(length( referee2_email ),0) + ifnull(length( degcountry3 ),0) + ifnull(length( referee1_email ),0) + ifnull(length( degcountry2 ),0) + ifnull(length( degcountry6 ),0) + ifnull(length( degstate2 ),0) + ifnull(length( current_addr_state ),0) + ifnull(length( birth_state ),0) + ifnull(length( referee2_country ),0) + ifnull(length( degcountry5 ),0) + ifnull(length( degcountry4 ),0) + ifnull(length( prior_visa_status ),0) + ifnull(length( perm_resident ),0) + ifnull(length( degstate6 ),0) + ifnull(length( degstate4 ),0) + ifnull(length( degstate5 ),0) + ifnull(length( referee3_phone ),0) + ifnull(length( referee1_state ),0) + ifnull(length( perm_addr_country ),0) + ifnull(length( referee3_state ),0) + ifnull(length( current_addr_country ),0) + ifnull(length( current_visa_type ),0) + ifnull(length( subjscore ),0) + ifnull(length( tscore ),0) + ifnull(length( subjpct ),0) + ifnull(length( grequantp ),0) + ifnull(length( numsb ),0) + ifnull(length( numsbcol ),0) + ifnull(length( greverbp ),0) + ifnull(length( greanalp ),0) + ifnull(length( last_update ),0) + ifnull(length( attendto4_month ),0) + ifnull(length( degree4_date_month ),0) + ifnull(length( attendfr3_month ),0) + ifnull(length( ed_cset_test_date_month ),0) + ifnull(length( attendto1_month ),0) + ifnull(length( apply_date_day ),0) + ifnull(length( degree3_date_month ),0) + ifnull(length( degree5_date_month ),0) + ifnull(length( attendfr6_month ),0) + ifnull(length( attendto3_month ),0) + ifnull(length( ed_ssat_test_date_year ),0) + ifnull(length( attendfr2_month ),0) + ifnull(length( subjdate_month ),0) + ifnull(length( attendfr5_month ),0) + ifnull(length( ed_ssat_test_date_month ),0) + ifnull(length( us_social_security_num2 ),0) + ifnull(length( ed_cset_test_date_year ),0) + ifnull(length( ed_praxis_test_date_year ),0) + ifnull(length( attendfr4_month ),0) + ifnull(length( ed_msat_test_date_month ),0) + ifnull(length( ed_cbest_test_date_day ),0) + ifnull(length( ed_msat_test_date_year ),0) + ifnull(length( ed_msat_test_date_day ),0) + ifnull(length( attendto5_month ),0) + ifnull(length( ed_cset_test_date_day ),0) + ifnull(length( ed_bclad_test_date_year ),0) + ifnull(length( ed_cbest_test_date_day2 ),0) + ifnull(length( birth_mo ),0) + ifnull(length( ed_cbest_test_date_month2 ),0) + ifnull(length( ed_ssat_test_date_day ),0) + ifnull(length( ed_bclad6_test_date_day ),0) + ifnull(length( ed_bclad6_test_date_month ),0) + ifnull(length( submit_date_day ),0) + ifnull(length( attendto6_month ),0) + ifnull(length( toefldate_month ),0) + ifnull(length( ed_cbest_test_date_year ),0) + ifnull(length( degree1_date_month ),0) + ifnull(length( attendfr1_month ),0) + ifnull(length( apply_date_month ),0) + ifnull(length( gendate_month ),0) + ifnull(length( ed_cbest_test_date_year2 ),0) + ifnull(length( submit_date_month ),0) + ifnull(length( attendto2_month ),0) + ifnull(length( ed_cbest_test_date_month ),0) + ifnull(length( degree2_date_month ),0) + ifnull(length( degree6_date_month ),0) + ifnull(length( ed_praxis_test_date_day ),0) + ifnull(length( birth_day ),0) + ifnull(length( ed_praxis_test_date_month ),0) + ifnull(length( last_user_id ),0) + ifnull(length( id ),0) + ifnull(length( form_instance_id ),0) + ifnull(length( user_id ),0) + ifnull(length( birth_year ),0) + ifnull(length( attendto5_year ),0) + ifnull(length( attendfr1_year ),0) + ifnull(length( apply_date_year ),0) + ifnull(length( toefldate_year ),0) + ifnull(length( degree5_date_year ),0) + ifnull(length( subjdate_year ),0) + ifnull(length( attendto2_year ),0) + ifnull(length( degree1_date_year ),0) + ifnull(length( attendto6_year ),0) + ifnull(length( attendto1_year ),0) + ifnull(length( degree2_date_year ),0) + ifnull(length( attendfr2_year ),0) + ifnull(length( degree4_date_year ),0) + ifnull(length( prevapp_year ),0) + ifnull(length( attendfr4_year ),0) + ifnull(length( gendate_year ),0) + ifnull(length( attendto3_year ),0) + ifnull(length( qualifying_program_year ),0) + ifnull(length( volunteer_type1_hrs ),0) + ifnull(length( ug_hours2 ),0) + ifnull(length( ug_hours1 ),0) + ifnull(length( us_social_security_num3 ),0) + ifnull(length( submit_date_year ),0) + ifnull(length( hs_advplcl ),0) + ifnull(length( volunteer_type2_hrs ),0) + ifnull(length( degree6_date_year ),0) + ifnull(length( attendto4_year ),0) + ifnull(length( attendfr5_year ),0) + ifnull(length( attendfr3_year ),0) + ifnull(length( attendfr6_year ),0) + ifnull(length( us_social_security_num1 ),0) + ifnull(length( degree3_date_year ),0) + ifnull(length( referee1_recommender_id ),0) + ifnull(length( referee2_recommender_id ),0) + ifnull(length( referee3_recommender_id ),0) + ifnull(length( authorization_code ),0) + ifnull(length( grad_program ),0) + ifnull(length( payment_method ),0) + ifnull(length( degree3 ),0) + ifnull(length( qualifying_program ),0) + ifnull(length( degree2 ),0) + ifnull(length( degree6 ),0) + ifnull(length( degree5 ),0) + ifnull(length( degree1 ),0) + ifnull(length( degree4 ),0) + ifnull(length( native_lang ),0) + ifnull(length( major6 ),0) + ifnull(length( major4 ),0) + ifnull(length( major2 ),0) + ifnull(length( major5 ),0) + ifnull(length( major1 ),0) + ifnull(length( major3 ),0) + ifnull(length( current_addr_street1 ),0) + ifnull(length( volunteer_type2 ),0) + ifnull(length( perm_addr_zip ),0) + ifnull(length( focontact2_first ),0) + ifnull(length( other_degstate3 ),0) + ifnull(length( aka_first_name2 ),0) + ifnull(length( referee1_inst_other ),0) + ifnull(length( current_addr_street2 ),0) + ifnull(length( cs_research_area_choice_other ),0) + ifnull(length( ce_research_area_choice_3 ),0) + ifnull(length( psych_research_area_choice1 ),0) + ifnull(length( cs_research_area_choice_1 ),0) + ifnull(length( ce_research_area_choice_other ),0) + ifnull(length( referee2_street_addr ),0) + ifnull(length( aka_first_name5 ),0) + ifnull(length( focontact1_last ),0) + ifnull(length( ce_research_area_choice_1 ),0) + ifnull(length( referee2_state_other ),0) + ifnull(length( current_addr_city ),0) + ifnull(length( referee2_title ),0) + ifnull(length( aka_last_name4 ),0) + ifnull(length( biol_research_area ),0) + ifnull(length( aka_first_name3 ),0) + ifnull(length( referee2_inst_other ),0) + ifnull(length( other_degstate6 ),0) + ifnull(length( aka_last_name5 ),0) + ifnull(length( other_degstate5 ),0) + ifnull(length( referee2_city ),0) + ifnull(length( current_phone_number ),0) + ifnull(length( referee1_state_other ),0) + ifnull(length( ug_employment1 ),0) + ifnull(length( ee_research_area_choice_1 ),0) + ifnull(length( ee_research_area_choice_3 ),0) + ifnull(length( ee_research_area_choice_other ),0) + ifnull(length( other_school3 ),0) + ifnull(length( embark_login_email ),0) + ifnull(length( perm_addr_street2 ),0) + ifnull(length( other_school4 ),0) + ifnull(length( referee1_city ),0) + ifnull(length( aka_last_name3 ),0) + ifnull(length( referee1_title ),0) + ifnull(length( referee1_name_last ),0) + ifnull(length( aka_last_name1 ),0) + ifnull(length( other_degstate4 ),0) + ifnull(length( prevapp_major ),0) + ifnull(length( cs_research_area_choice_3 ),0) + ifnull(length( referee2_name_first ),0) + ifnull(length( referee2_name_last ),0) + ifnull(length( aka_last_name2 ),0) + ifnull(length( aka_first_name1 ),0) + ifnull(length( first_name ),0) + ifnull(length( father_occ ),0) + ifnull(length( other_school6 ),0) + ifnull(length( perm_phone_number ),0) + ifnull(length( research_emphasis ),0) + ifnull(length( other_school5 ),0) + ifnull(length( current_phone_area ),0) + ifnull(length( middle_name ),0) + ifnull(length( birth_state_other ),0) + ifnull(length( ce_research_area_choice_2 ),0) + ifnull(length( perm_phone_area ),0) + ifnull(length( perm_addr_city ),0) + ifnull(length( referee3_name_last ),0) + ifnull(length( ee_research_area_choice_2 ),0) + ifnull(length( other_school2 ),0) + ifnull(length( referee1_zip ),0) + ifnull(length( perm_addr_street1 ),0) + ifnull(length( focontact1_first ),0) + ifnull(length( focontact1_discipline ),0) + ifnull(length( scicomm_research_area ),0) + ifnull(length( chem_research_area_choice_2 ),0) + ifnull(length( perm_addr_state_other ),0) + ifnull(length( forecruit_contact ),0) + ifnull(length( referee3_inst_other ),0) + ifnull(length( referee1_name_first ),0) + ifnull(length( cs_research_area_choice_2 ),0) + ifnull(length( ugfa_terms2 ),0) + ifnull(length( referee3_street_addr ),0) + ifnull(length( referee3_city ),0) + ifnull(length( referee3_zip ),0) + ifnull(length( other_degstate1 ),0) + ifnull(length( referee3_title ),0) + ifnull(length( referee3_name_first ),0) + ifnull(length( referee1_street_addr ),0) + ifnull(length( other_eth ),0) + ifnull(length( tribalaff ),0) + ifnull(length( ug_employment2 ),0) + ifnull(length( other_degstate2 ),0) + ifnull(length( email_addr ),0) + ifnull(length( hs_state_other ),0) + ifnull(length( hs_num ),0) + ifnull(length( referee2_zip ),0) + ifnull(length( hsname ),0) + ifnull(length( hsloc ),0) + ifnull(length( other_school1 ),0) + ifnull(length( ugfa_type1 ),0) + ifnull(length( current_addr_state_other ),0) + ifnull(length( volunteer_type1 ),0) + ifnull(length( aka_first_name4 ),0) + ifnull(length( ugfa_terms1 ),0) + ifnull(length( ugfa_type2 ),0) + ifnull(length( guardian_occ ),0) + ifnull(length( mother_occ ),0) + ifnull(length( last_name ),0) + ifnull(length( focontact2_last ),0) + ifnull(length( chem_research_area_choice_1 ),0) + ifnull(length( focontact2_discipline ),0) + ifnull(length( father_edu ),0) + ifnull(length( guardian_edu ),0) + ifnull(length( referee3_state_other ),0) + ifnull(length( current_addr_state_zip ),0) + ifnull(length( mother_edu ),0) + ifnull(length( ocea_researcharea_choice1 ),0) + ifnull(length( ocea_researcharea_choice2 ),0) + ifnull(length( ocea_faculty_sponsor_name ),0) + ifnull(length( physics_research_area_choice_other ),0) + ifnull(length( qualifying_program_institution_other ),0) + ifnull(length( foother_text ),0) + ifnull(length( ed_credential ),0) + ifnull(length( physics_research_area_choice_2 ),0) + ifnull(length( physics_research_area_choice_1 ),0) + ifnull(length( physics_research_area_choice_3 ),0) + ifnull(length( school3 ),0) + ifnull(length( school1 ),0) + ifnull(length( referee3_institution ),0) + ifnull(length( school2 ),0) + ifnull(length( school6 ),0) + ifnull(length( school5 ),0) + ifnull(length( qualifying_program_institution ),0) + ifnull(length( school4 ),0) + ifnull(length( referee2_institution ),0) + ifnull(length( referee1_institution ),0) + ifnull(length( selfgpa ),0) + ifnull(length( subjcode ),0) + ifnull(length( grequant ),0) + ifnull(length( greanal ),0) + ifnull(length( greverb ),0) + ifnull(length( term_applying_for ),0) + ifnull(length( qualifying_program_season ),0) + ifnull(length( prevapp_qtr ),0) + ifnull(length( diversity_fellowship ),0) + ifnull(length( financial_support ),0) + ifnull(length( eap_app ),0) + ifnull(length( gpa_scale ),0) + ifnull(length( foreign_domestic ),0) + -- the text part if ( ifnull(length( additional_info ),0) > 768, 768 , ifnull(length( additional_info ),0)) + if ( ifnull(length( anthro_writing_sample_text ),0) > 768, 768 , ifnull(length( anthro_writing_sample_text ),0)) + if ( ifnull(length( benefit_society ),0) > 768, 768 , ifnull(length( benefit_society ),0)) + if ( ifnull(length( citizen_comments ),0) > 768, 768 , ifnull(length( citizen_comments ),0)) + if ( ifnull(length( digital_arts_and_new_media_writing_sample_url ),0) > 768, 768 , ifnull(length( digital_arts_and_new_media_writing_sample_url ),0)) + if ( ifnull(length( ed_credential_bclad_sing_which ),0) > 768, 768 , ifnull(length( ed_credential_bclad_sing_which ),0)) + if ( ifnull(length( ed_credential_clad_sing_which ),0) > 768, 768 , ifnull(length( ed_credential_clad_sing_which ),0)) + if ( ifnull(length( ed_resume_test ),0) > 768, 768 , ifnull(length( ed_resume_test ),0)) + if ( ifnull(length( ed_writing_sample_edd_text ),0) > 768, 768 , ifnull(length( ed_writing_sample_edd_text ),0)) + if ( ifnull(length( ed_writing_sample_ma_text ),0) > 768, 768 , ifnull(length( ed_writing_sample_ma_text ),0)) + if ( ifnull(length( ed_writing_sample_phd_text ),0) > 768, 768 , ifnull(length( ed_writing_sample_phd_text ),0)) + if ( ifnull(length( fellow_applied ),0) > 768, 768 , ifnull(length( fellow_applied ),0)) + if ( ifnull(length( fellow_awarded ),0) > 768, 768 , ifnull(length( fellow_awarded ),0)) + if ( ifnull(length( hist_con_writing_sample_text ),0) > 768, 768 , ifnull(length( hist_con_writing_sample_text ),0)) + if ( ifnull(length( history_writing_sample_text ),0) > 768, 768 , ifnull(length( history_writing_sample_text ),0)) + if ( ifnull(length( language_proficiency ),0) > 768, 768 , ifnull(length( language_proficiency ),0)) + if ( ifnull(length( linguistics_essay ),0) > 768, 768 , ifnull(length( linguistics_essay ),0)) + if ( ifnull(length( list_pubs ),0) > 768, 768 , ifnull(length( list_pubs ),0)) + if ( ifnull(length( list_teaching ),0) > 768, 768 , ifnull(length( list_teaching ),0)) + if ( ifnull(length( lit_writing_sample_text ),0) > 768, 768 , ifnull(length( lit_writing_sample_text ),0)) + if ( ifnull(length( music_dma_writing_sample_text ),0) > 768, 768 , ifnull(length( music_dma_writing_sample_text ),0)) + if ( ifnull(length( music_writing_sample_text ),0) > 768, 768 , ifnull(length( music_writing_sample_text ),0)) + if ( ifnull(length( obstacles ),0) > 768, 768 , ifnull(length( obstacles ),0)) + if ( ifnull(length( philosophy_writing_sample_text ),0) > 768, 768 , ifnull(length( philosophy_writing_sample_text ),0)) + if ( ifnull(length( politics_writing_sample_text ),0) > 768, 768 , ifnull(length( politics_writing_sample_text ),0)) + if ( ifnull(length( research_work ),0) > 768, 768 , ifnull(length( research_work ),0)) + if ( ifnull(length( resume_text ),0) > 768, 768 , ifnull(length( resume_text ),0)) + if ( ifnull(length( social_doc_writing_sample_text ),0) > 768, 768 , ifnull(length( social_doc_writing_sample_text ),0)) + if ( ifnull(length( social_doc_writing_sample_url ),0) > 768, 768 , ifnull(length( social_doc_writing_sample_url ),0)) + if ( ifnull(length( sociology_writing_sample_text ),0) > 768, 768 , ifnull(length( sociology_writing_sample_text ),0)) + if ( ifnull(length( statement_purpose_text ),0) > 768, 768 , ifnull(length( statement_purpose_text ),0)) as total from embark_application order by total;
[5 May 2005 18:42]
Seth Russell
oops! I accidentally included some extra queries. The query that I used to calculate length is the last one listed. sorry about that.
[5 May 2005 20:58]
Heikki Tuuri
Seth, a row contains also the length fields, as well as a header. Regards, Heikki
[29 Sep 2008 21:48]
Konstantin Osipov
This appears to be behaving as designed, I'm not aware of any plans to fix this bug.