Download & Extend

[DBTNG + BLOB] remap {comments}.comment

Project:Drupal core
Version:7.x-dev
Component:comment.module
Category:feature request
Priority:critical
Assigned:hswong3i
Status:closed (duplicate)

Issue Summary

As case mentioned in http://drupal.org/node/147947, this patch remap {comments}.comment as BLOB type. Also merge with http://drupal.org/node/300219 for correct schema definition.

MySQL:

  • update.php: pass.
  • INSERT/UPDATE: pass.

PostgreSQL:

  • update.php: FAILED. Seems PostgreSQL schema don't handle change field correctly.
  • INSERT/UPDATE: FAILED. Seems db_insert() of PostgreSQL don't handle correctly.
AttachmentSizeStatusTest resultOperations
comments-comment.patch4.73 KBIdleFailed: Failed to apply patch.View details | Re-test

Comments

#1

Revamp with drupal_write_record() for simpler handling.

When combine with simplify drupal_write_record() with db_insert() and db_update(), it can prevent the incorrect input type for pid and uid when compare with using db_insert() directly.

Tested with MySQL and PostgreSQL. Stand alone simpletetest, pass; simpletest when combine with http://drupal.org/node/299088, also pass.

#2

Revamp with drupal_write_record() for simpler handling.

When combine with simplify drupal_write_record() with db_insert() and db_update(), it can prevent the incorrect input type for pid and uid when compare with using db_insert() directly.

Tested with MySQL and PostgreSQL. Stand alone simpletetest, pass; simpletest when combine with http://drupal.org/node/299088, also pass.

AttachmentSizeStatusTest resultOperations
comments-comment.patch3.93 KBIdleFailed: Failed to apply patch.View details | Re-test

#3

Update based on http://drupal.org/node/316095 founding. Revamp BLOB field with nullable.

Tested with MySQL and PostgreSQL. Stand alone simpletest, pass; simpletest when combine with http://drupal.org/node/299088, also pass.

AttachmentSizeStatusTest resultOperations
comments-comment-1223485861.patch3.21 KBIdleFailed: Failed to apply patch.View details | Re-test

#4

Status:needs review» needs work

The last submitted patch failed testing.

#5

Title:Remap field as BLOB: {comments}.comment» [DBTNG + BLOB] remap {comments}.comment
Status:needs work» needs review

Patch reroll after DBTNG syntax revamp #314532: DBTNG comment.module. Only change schema as BLOB type. Pass all comment's simpletest.

AttachmentSizeStatusTest resultOperations
dbtng-comments-comment-1226549584.patch1.14 KBIdlePassed: 7431 passes, 0 fails, 0 exceptionsView details | Re-test

#6

Status:needs review» needs work

The last submitted patch failed testing.

#7

#8

Status:needs review» closed (duplicate)

duplicate with #147947: [DBTNG + XDB] Replace some TEXT:BIG with BLOB

nobody click here